top of page

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.


Costco receipt with items highlighted in two colors showing how to split a transaction between business and personal expense categories

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.


Split expense categorization: what the term means


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 where you meet it:


  • Split categorization or a split transaction is the usual name in budgeting apps and bookkeeping programs.

  • Split expense categorization is the term in expense-tracking tools, where you break one receipt into its expense types.

  • Split spend categorization and split allocations are what corporate card and expense management platforms call it, often splitting one charge across departments, locations or projects.


It's the same thing everywhere: one payment, several reasons for it. The receipt breakdown (which line belongs where) is what tells you how to split 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:


  1. 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.)

  2. 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.

  3. 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.

  4. 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).

  5. Check that it adds up. Four parts, $212 total. If you're off by a few cents, put the difference on the biggest line.

  6. 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.


What is split spend categorization?


Split spend categorization is dividing one transaction across more than one spending category, so a receipt that covered three kinds of purchase is recorded as three amounts instead of one. Expense management platforms often call these split allocations. The parts always add up to the original charge.


What is split expense categorization?


Split expense categorization is the same idea applied to expenses: one receipt, broken down line by line, with each part recorded under its own expense category. For a business owner the most common split is business versus personal, so only the business part lands in your business expenses.


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


Expense report showing spending totals by category

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.


Full disclosure: the Money Mastery System is Donna Roggio's own product.

No, a credit card payment is not an expense. The expense happened when you used the card. The payment is a transfer that moves money from your bank account to the card company to pay down what you already owe. If you record it as an expense, you count the same purchases twice. Only interest and card fees are expenses.


Business owner comparing credit card statement to bank statement while trying to track credit card spending correctly

Here's what a card payment actually is, how to record it in a spreadsheet, an app or QuickBooks, and how to fix your numbers if you've been counting it twice.


The double-counting problem


Say you put $400 on your card this month: $200 of office supplies, $150 of groceries and a $50 subscription. That's $400 of spending.


At the end of the month you pay the card bill: $400 from checking. Record that payment as an expense too, and your numbers now say you spent $800. You didn't. The payment didn't buy anything. It paid off purchases you'd already recorded.


The expense happens when you use the card, not when you pay the bill. Bookkeepers put it simply: a card payment is a liability payment, not the purchase of something. Counting both inflates your spending, shrinks your profit on paper, and can push you to cut spending that was never actually too high.


What type of transaction is a credit card payment?


A credit card payment is a debt repayment, which in your records is a transfer. Money leaves your checking account and the balance you owe on the card goes down by the same amount. Nothing new is bought, so nothing new goes in an expense category. In bookkeeping terms, it reduces a liability, not your profit.


When you buy something with the card, two things happen. You get the item, which is the expense, and your card balance goes up. When you later pay the card, your checking balance goes down and your card balance goes down. The net effect on what you're worth is zero.


It helps to sort every money movement into one of three types:


Type

What it is

Examples

Counts as spending?

Expense

Money exchanged for goods or services

Groceries, software, rent, card interest, card fees

Yes

Transfer

Money moving between accounts you own

Checking to savings, checking to credit card, business to personal (owner's draw)

No

Debt payment

Paying down money you borrowed

Card payment, loan principal

No, except the interest part, which is an expense


Moving money to yourself as an owner's draw is a transfer too, not a business expense. Get these three types straight and your spending reports, your profit and your net worth all line up.


Is paying a bill considered a purchase?


It depends on who you're paying. If you pay your phone or electric bill straight from checking, that payment is the expense, recorded on the day you pay. If you pay a credit card bill, it isn't. The purchases were recorded when you made them, and the card payment just clears the balance.


This trips people up most when bills go on the card. Say your $85 phone bill is charged to your credit card. The phone bill is an expense once, when it hits the card. When you later pay the card, that $85 is part of a transfer, not a second phone bill. And if one card charge covers several kinds of purchase, here's how to split a transaction across categories.


How to record a credit card payment (spreadsheet, app, QuickBooks)


Record each card purchase as an expense on the day you make it, in its normal category. Record the card payment as a transfer from checking to the card. Whatever tool you use, it comes down to those two steps, and only the first one touches your expense totals.


In a spreadsheet. Give card payments their own category, called Transfer or Card Payment, and leave that category out of your expense totals. If you total expenses with SUMIF, leaving it off the category list is enough. If you total a whole column, subtract the Transfer rows. If your spending report includes card payments, it's double-counting. If you're building a profit and loss statement in Google Sheets, put Transfer in its own "excluded" group so it never reaches the totals.


In a budgeting app. Most apps have a Transfer or Credit Card Payment type. Use it. If the app connects to both your bank and your card, it will often match the two sides of the payment for you, and once they're matched the payment stops counting as spending.


In QuickBooks or other bookkeeping software. The payment goes against the credit card liability account, not an expense account. The entry is: debit the credit card account (what you owe goes down), credit checking (cash goes down). The purchases on the card are the expenses. If you've been coding card payments to an expense account and recording the purchases, your profit and loss is understating your profit.


What about interest and fees?


Interest and card fees are the exception. They're real costs of borrowing, so they belong in an expense category of their own, usually Interest or Bank Fees. That includes annual fees, late fees and foreign transaction fees.


For taxes, it depends on what the borrowing paid for. Interest on a card used for personal purchases is personal interest, and the IRS doesn't allow a deduction for it (IRS Topic 505). Interest on balances from business purchases is generally a business expense. If one card carries both, the interest has to be divided between the business and personal parts (IRS Publication 334), which is one more reason to keep a card just for the business.


Seeing interest as its own line does something else too. "$187 in interest charges" sitting in your monthly report is far more motivating than knowing card debt is expensive in theory, especially if you've been stuck in the minimum payment trap.


This is general education, not tax advice. A CPA or Enrolled Agent can tell you how these rules apply to your situation.


Are credit card payments a business expense?


No. Paying a business credit card isn't a business expense, for the same reason it isn't a personal one: the expense was recorded when you bought something with the card. What is a business expense is each business purchase on the card, on the date you made it, and the interest and fees the card charges on business balances.


Even on cash-basis bookkeeping, record the expense on the purchase date, not the date you pay the card. For taxes, most preparers treat a business purchase charged to a card as paid on the day of the charge. So $600 of supplies charged on December 28 generally counts in December, even if the card bill gets paid in January. If a big year-end charge matters to your return, check the timing with your tax preparer.


What double-counting looks like on a real month


Say you earn $7,000 a month. You put about $3,500 a month on your card for software, client lunches, gas, groceries and some personal shopping. From checking you pay rent ($1,600), utilities ($200), and phone and insurance ($380).


Your real spending is $5,680: the $3,500 of card purchases plus $2,180 of bills from checking. That leaves $1,320 a month of breathing room.


Now count the $3,500 card payment as an expense too. Your records say you spent $9,180 on $7,000 of income. That looks like $2,180 a month of overspending, when you're actually $1,320 ahead.


Before and after comparison showing inflated spending total from double-counting credit card payments versus accurate expense total

Numbers like that lead to bad decisions: cutting a marketing cost that brings in clients, skipping a course you can afford, or just carrying stress you don't need. One categorization habit makes a stable month look like a crisis.


How to fix it if you've been counting it twice


  1. Don't redo the past. Pick a clean start date, such as the first of next month. Recategorizing years of history rarely pays off.

  2. Set the card up as its own account in your spreadsheet or app, so its purchases appear as individual lines.

  3. From the start date, categorize every card purchase as the expense it is: groceries to groceries, software to software.

  4. Categorize the card payment as a transfer when it shows up in checking. Not "Credit card bill," and not an expense.

  5. Check your monthly total. If it now roughly matches what you actually bought, it's fixed. If it still looks high, search for "payment," "autopay," "thank you" or your card issuer's name in your expense categories. A stray card payment is usually hiding there.


One clean start date and one new habit. After a month, every report you run will reflect what really happened, and it gets much easier to track where your money goes each week.


If you want to see how much of your card spending is habit rather than need, try a cash-only week and what it shows.


Frequently asked questions


Is paying off a credit card an expense?


No. Paying off a credit card is a transfer that reduces a debt you already owe. The expense happened when you made each purchase. The only part of what you pay the card company that is an expense is the interest and any fees, and those get recorded on their own lines.


What account does a credit card payment go to?


It goes against the credit card liability account (the balance you owe), not an expense account. In double-entry terms you debit the card account and credit checking. The purchases made on the card are what get categorized as expenses, on the dates you made them.


Is credit card interest an expense, and is it tax-deductible?


Yes, interest is an expense, so record it separately from your purchases. Whether it's deductible depends on what the borrowing paid for. Interest on personal purchases isn't deductible. Interest on business purchases generally is, as a business expense. If one card carries both, the interest has to be split between them.


How are credit card payments applied to my balance?


On personal credit cards, federal rules require the issuer to apply anything you pay above the minimum to the balance with the highest interest rate first (CFPB, Regulation Z §1026.53). The minimum payment itself can go to a lower-rate balance. These allocation rules come from the CARD Act and cover consumer cards, not necessarily business cards. To see what each extra payment does to a real balance, here's the math on $6,200.


How do I make an expense report from my credit card statement?


Download the statement as a spreadsheet file, delete the payment and credit rows, and give each remaining purchase a category. Then total by category. What's left is your card spending for the period. Leave the payment out, because it isn't spending, and record any interest and fees as their own expense lines.


How do I know if I've been double-counting?


Look at last month's expenses. If you see a line like "Credit card payment: $3,500" and the individual purchases from that same card, your spending is inflated by $3,500. Your real expenses are the individual purchases plus interest and fees.


Start free with La Soglia


Credit card purchases listed as individual transactions

If you want support keeping expenses and transfers straight month after month, the Money Mastery System brings together 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.


bottom of page