Split Categorization: How to Split One Transaction Across Categories
Updated: 4 days ago
To split a transaction, record one payment as several smaller amounts, each in its own category, that add up exactly to the total. A $212 Costco receipt becomes groceries $118, household $41, pharmacy $33 and business supplies $20. Total each category from the itemized receipt, include the tax on the taxed lines, and check the parts equal $212.
One lump in "Shopping" tells you nothing. It hides business costs inside your grocery bill and makes your personal spending look higher than it is. Below is how to split a receipt by hand, in a spreadsheet, or in an app, and which purchases are worth the trouble.
What does split categorization mean?
Split categorization means assigning one transaction to more than one category, with the parts adding up to the original total. You'll also see it called split expense categorization, split spend categorization or a split transaction. The wording depends on whether you're in a bookkeeping program, an expense app or a corporate card platform, but it's the same thing: one payment, several reasons for it.
A transaction has one date, one merchant and one total. Categorizing asks what the money was for. When the honest answer is "three different things," putting it in one category is a guess, and every report built on that guess carries the error forward.
How to split a Costco receipt into groceries, household and pharmacy
Get the itemized receipt, give each line a category, total each category, and enter those totals against the one charge. Make sure the parts add up to the receipt total, to the cent. If one line is for your business, give it its own business category. A $212 Costco run takes about two minutes.
Here's the $212 receipt worked through:
Category | What was on the receipt | Amount |
|---|---|---|
Groceries | Produce, chicken, eggs, coffee, snacks | $118 |
Household | Paper towels, laundry detergent, trash bags | $41 |
Pharmacy / health | Vitamins, pain reliever, bandages | $33 |
Business supplies | Towels and disinfectant for the studio | $20 |
Total | $212 |
The steps:
Find the itemized receipt. If the paper one is gone, Costco keeps warehouse receipts in your costco.com account under Orders & Purchases, then In-Warehouse, and in the Costco app. (Your online account has to be registered for them to show up.)
Mark each line with a category. A pen and four letters (G, H, P, B) on the paper receipt works fine. If you're not sure which business category the studio towels belong in, here are 20 business expense categories for a service business.
Total each category, including its tax. Sales tax usually applies only to some lines. Groceries are taxed lower or not at all in many states. Add each tax amount to the lines it belongs to. If that's too fiddly, spread the tax across the taxed lines in proportion to their size.
Enter the split against the one charge. In an app or bookkeeping program, open the $212 transaction and choose Split. In a spreadsheet, replace the one row with four rows (see the spreadsheet section below).
Check that it adds up. Four parts, $212 total. If you're off by a few cents, put the difference on the biggest line.
Keep the receipt with the business line. The $20 business portion is the part you may need to back up later. If paper receipts pile up, here's a simple system for receipts that works on paper or on your phone.
Shortcut for next time: if you know a Costco run will include business items, ask the cashier to ring them up as a separate transaction. Then there's nothing to split.
Why splitting matters (more than it looks)
An unsplit receipt makes two reports wrong at once. In the example above, logging all $212 as groceries overstates your grocery spending by $94. It also hides $20 of business supplies you can't claim if you don't know they're there. Log all $212 as business and you've claimed $192 of personal shopping as a business cost.
The IRS is plain about this. If an expense is partly for business and partly personal, you separate the two, and the personal part generally isn't deductible (IRS Publication 334, chapter 8). Splitting at the time of purchase is the easiest way to know what the business part actually was.
It also makes your trends worth reading. If your "groceries" line jumps $300 one month, you want to know whether that was food or a box of salon supplies that landed in the wrong place. Splitting is one piece of how to track expenses when you're self-employed.
This is general education, not tax advice. A CPA or Enrolled Agent can confirm how these rules apply to you.
Three more receipts worth splitting
The mixed Amazon order. One $189 order holds a $49 business book, a $30 USB hub for your desk, $65 sheets for the bedroom and a $45 birthday gift. Business gets $79 (professional development $49, office equipment $30). Personal gets $110 (household $65, gifts $45). Amazon often charges items separately as they ship. Match each charge to its items in your order history before you split.
The phone bill. You can't point to a line on a phone bill, so split by a percentage you can explain. For example, if about 60% of your use is for clients, put 60% in business and 40% in personal. Write down how you got the 60% and keep that note with your records.
Gas, if one car does both jobs. This one depends on how you deduct your car. Many self-employed people use the IRS standard mileage rate (72.5 cents a mile for January through June 2026 and 76 cents a mile from July 1, 2026). Under that method you deduct business miles, not fuel, so there's no reason to split the gas receipt. Log the miles instead. The split only matters if you use the actual-expense method, where you deduct the business-use percentage of gas, insurance, repairs and so on (IRS Topic 510). If 60% of your miles this year were for business, $37.20 of a $62 fill-up is business and $24.80 is personal.
How to split a transaction in a spreadsheet, an app or QuickBooks
The mechanics are the same everywhere: one payment, several lines, and the lines must add up to the total. What differs is whether the tool checks the arithmetic for you.
In a spreadsheet. Replace the one $212 row with four rows. Give them the same date and merchant, each with its own category and amount, and add a column that ties them back to the original charge. Then add a check so a typo can't go unnoticed. Put the receipt total in one cell (say E2) and the four split amounts in F2 to F5. Beside the total, enter this formula, which subtracts the split lines from the receipt total:
=E2-SUM(F2:F5)
Anything other than zero means the split doesn't reconcile. Spreadsheets won't warn you on their own, so this one cell does the job. (If you paid with a card, the card payment itself isn't another expense. It's a transfer.)
In a budgeting app. Most current budgeting apps (YNAB, for example) have a Split option on the transaction itself. Open the charge, choose Split, add a line per category, and the app won't let you save until the parts match the total. If your app has no split option, don't add manual entries on top of the original charge. That double-counts the purchase.
In QuickBooks or other bookkeeping software. Yes, a single transaction can be split across multiple GL codes (accounts). In QuickBooks Online, open the transaction in the bank feed, choose Categorize, then Split, and assign each line to its own account until the difference shows $0. Each line then lands in the right place on your profit and loss.
How to split a transaction between business and personal
To split a transaction between business and personal, record the business share as a business expense in its own category and leave the rest as personal. Do it when you make the purchase, not at year end. The business share must be what you actually used for the business, and you need to be able to say how you got the number.
If you can point at the line on the receipt, split by the line. The studio towels at $20 are a $20 business expense. If you can't point at a line, because the cost really is shared like a phone or internet bill, split by a percentage you can defend and keep the note explaining it. Never round to something convenient. And if you're not sure whether something counts as a business expense or a personal one, decide that first, then split.
Three transactions are worth splitting every single time: warehouse and big-box runs, any online order that mixes categories, and fuel when the same vehicle does both jobs and you use the actual-expense method. Everything else can wait for the weekly review. If business and personal money currently share one account, the groundwork is in how to separate business and personal expenses in one account.
The transactions most people forget to split
Your phone bill, if you use one phone for business and personal calls. Split by your actual business-use percentage and note how you worked it out.
Your internet bill, if you work from home. Split it by how much of your internet use is for business. That's a separate percentage from your home office square footage, which applies to costs like rent and utilities. (A first landline into your home is a personal cost under IRS rules, even if you take business calls on it.)
Meals with clients. A business meal isn't split by how much of the conversation was about work. If the meal qualifies (you're there, it's with a client or business contact, and it isn't lavish), the whole bill is a business meal, and generally only 50% of it is deductible (IRS Publication 463). Record the full amount in a Business Meals category and let your tax preparer apply the 50%. A meal with no business purpose is personal, however much you talked shop.
Software you use for both, like a design app that's 80% client work and 20% family photo books. Split it 80/20.
Trips with personal days added. If the trip is mainly for business, the travel to and from is a business cost. The extra hotel nights and meals on your personal days are personal.
When to split, and when not to bother
Split when the smaller part is big enough to change a decision or a deduction, and when the purchase repeats. A weekly warehouse run is worth splitting every time. A one-off where $9 of a $40 total belongs somewhere else usually isn't.
Do your splitting during a weekly money review, not at month end. A Costco receipt from four days ago is easy because you still remember what was in the cart. One from six weeks ago is a guessing game.
Here's a five-minute test: pull up your last five Costco, Amazon, Target or Walmart charges. If more than one mixed business and personal items, splitting those going forward is the fix.
Frequently asked questions
What does "split transaction" mean?
A split transaction is one payment recorded as two or more amounts in different categories. The amounts add up to the original total. A $212 Costco charge split into groceries, household, pharmacy and business supplies is still one charge on your statement, but four lines in your reports.
Can a single transaction be split across multiple GL codes?
Yes. Bookkeeping software like QuickBooks lets you split one bank or card transaction across several accounts in your chart of accounts. Each line carries its own amount, and the lines must total the original transaction. That's how one office-store receipt can hit Office Supplies, Postage and Owner's Draw at the same time.
Can I do two separate transactions at Costco?
You can ask the cashier to ring up your business items and your personal items as two separate transactions, and pay for each on its own. It saves you splitting later and gives you a clean business receipt. If you forget, the itemized receipt in your Costco account lets you split it afterwards.
How do I split the sales tax on a receipt?
Add the tax to the lines it was charged on. On a mixed receipt, groceries are often taxed at a lower rate or not at all, while household and business supplies usually carry the full rate. If matching tax to each line is too much work, spread the tax across the taxed lines in proportion to their size.
Do I need to keep the receipt if I split a transaction?
Keep it for any split that includes a business part. The IRS expects your records to show who you paid, how much, when, and what you bought, so it's clear the amount was a business expense (IRS recordkeeping guidance). A bank statement shows only the total, and the itemized receipt shows the split. Here's how long to keep receipts, and where.
How long does splitting take?
For most people, a few minutes a week, done during a weekly money review while the purchases are fresh. The first few receipts are slower. Once your categories are set, a typical warehouse receipt takes about two minutes.
Keep your categories honest, every week
If you'd rather not do this alone, the Money Mastery System gives you five connected workbooks, Clarity AI, and the Money Mastery Collective, a community of people doing the same work beside you. Start free with La Soglia.
Comments