Receipt RabbitBlog

How to split one receipt across several categories in QuickBooks Online

Short answer: Receipt Rabbit reads a receipt photo, categorizes every item on it, and posts one QuickBooks Online expense with a separate line for each category. You can split a transaction across categories by hand in QuickBooks Online, though you have to read the receipt and type each amount until the split balances. We do that typing for you and balance the lines to the cent. Every line maps to an account already in your chart of accounts, and the receipt image is attached to the expense.

On this page
  1. What does Receipt Rabbit post to QuickBooks?
  2. Does each receipt line become a QuickBooks line?
  3. What does a five-line receipt look like after the split?
  4. How do Receipt Rabbit categories find the right QuickBooks categories?
  5. Why not match to the bank transaction first?
  6. What happens to coupons and tax?
  7. What are the limits?
  8. How do I test any app that claims a QuickBooks split?
  9. Sources

A receipt that covers five kinds of spending usually ends up in QuickBooks Online as a single entry, filed under whichever category you happened to pick first. Your books then say you spent $138 on “Supplies,” even though you actually spent $64 on supplies and the rest on electronics, shipping, and household goods.

QuickBooks lets you split a transaction across multiple categories by hand: you choose Split, pick a category for each part, and type in the amounts until the remaining difference hits $0 [1]. The cost is the time you spend reading the paper receipt and typing the numbers. We built Receipt Rabbit to handle that part by reading the receipt photo, categorizing each line, and posting the expense with one line per category.

What does Receipt Rabbit post to QuickBooks?

You get one standalone expense in QuickBooks per receipt, recorded as a card, check, or cash payment to match the account you paid from. The expense lists the merchant as the payee, uses the receipt total as the amount, and includes a separate line for each category found on the receipt. Each line also carries a short description naming the items on it and the receipt total, so anyone reading the register can see what you bought without opening the transaction. Together with the attached photo, that covers what the IRS says a supporting document for an expense should show: the payee, the amount paid, proof of payment, the date, and a description of the items [2].

We attach the receipt image directly to the expense in QuickBooks, or the PDF itself if the receipt came in as a PDF. If the file upload fails for any reason, the expense still posts to your books.

Does each receipt line become a QuickBooks line?

No, we group the receipt lines by category before posting to QuickBooks. Two grocery items on the same receipt become one Groceries line with their amounts added together.

You can still inspect every individual receipt line and its category inside Receipt Rabbit. We send QuickBooks one line per category because categories correspond to your chart of accounts (the list of accounts in your books). Sending eleven separate lines that all point to Groceries would clutter your register without telling your accountant anything new.

If you want every individual item in an export, both the accountant export and the CSV keep the full line-level detail. You can read more about how that works in What the accountant export actually does.

What does a five-line receipt look like after the split?

Take a sample receipt from a home-and-office store with five items on it:

LineAmountCategory
Printer toner$64.00Office Supplies
USB-C hub$38.50Electronics & Tech
Shipping labels$12.00Shipping & Postage
Dish soap and sponges$9.75Household Goods
Light bulbs$14.25Household Goods

The receipt total comes to $138.50. Because the dish soap and light bulbs share the Household Goods category, we combine their amounts into $24.00. We then post a single expense for $138.50 with four lines:

  1. $64.00 to the QuickBooks category mapped to Office Supplies.
  2. $38.50 to the QuickBooks category mapped to Electronics & Tech.
  3. $24.00 to the QuickBooks category mapped to Household Goods.
  4. $12.00 to the QuickBooks category mapped to Shipping & Postage.

Those four lines sum to $138.50. It’s a beautiful thing! Whether Household Goods counts as business spending in your books depends on how you map that category and whether you put a business tag on those lines. For a closer look at how business tags work on mixed receipts, see How to split a Costco receipt between business and personal.

How do Receipt Rabbit categories find the right QuickBooks categories?

When you connect QuickBooks, we read your chart of accounts and match each Receipt Rabbit category to one of your existing accounts. That mapping is saved as soon as you finish connecting.

We only map to accounts that are already in your chart, and we never create new accounts on our own. If your chart of accounts has no good match for a category, add the account in QuickBooks, then disconnect and reconnect so the matching runs again.

Why not match to the bank transaction first?

When we post an expense, QuickBooks suggests it as a match for the card charge from your bank feed, as long as the amount is the same and the date falls inside Intuit’s window of 90 days before to 20 days after the transaction date [3].

We used to try matching bank transactions directly from our side, and we changed that approach because QuickBooks already handles matching between posted expenses and downloaded card charges.

What happens to coupons and tax?

When a receipt has a coupon or sales tax, we fold those amounts into the category lines so that a purchase receipt never sends negative lines to QuickBooks Online. The posted lines still balance to the cent and match the receipt total.

On a receipt that mixes business and personal items, we divide tax and coupons between the business categories and your non-business account in proportion to the purchases on each side. Tax stays inside those category lines instead of posting as a separate tax entry, and we send every line to QuickBooks marked non-taxable. If you track sales tax separately in QuickBooks, the tax will not show up on its own. That is a real limitation worth knowing before you connect your account.

For the background on why adjustments inherit a category, see Coupons and taxes are not spending categories.

What are the limits?

QuestionReceipt Rabbit’s answer
Creates accounts in your chart?No. We map to existing accounts only.
One QuickBooks line perCategory. We merge receipt lines that share a category into one line.
Sales tax tracking in QuickBooksNo. Every line is sent marked non-taxable.
DestinationsQuickBooks Online, Xero, and Lunch Money. Connecting a destination is optional.
Price of syncingSyncing to QuickBooks Online or Xero requires Pro ($8 a month or $60 a year, with a 7-day trial on the annual plan). Syncing to Lunch Money is included in Plus ($4 a month or $30 a year) and Pro.
Monthly limitFree includes 30 categorized receipts a month, Plus includes 100, and Pro includes 300. None of the plans is unlimited.
Over the limitWe save the receipt and leave it uncategorized. Upgrading retries it automatically, or you can pull to refresh after your monthly reset.

How do I test any app that claims a QuickBooks split?

  1. Does one receipt become one expense, or a pile of separate expenses?
  2. Do the lines sum to the receipt total to the cent?
  3. Is the photo attached to the expense?
  4. Does it create new accounts in your chart without asking?
  5. What does it do with a coupon larger than its category?

Sources

  1. Intuit, “Categorize online bank transactions in QuickBooks Online” (section: Split transactions between multiple categories). https://quickbooks.intuit.com/learn-support/en-us/help-article/banking/categorize-match-online-bank-transactions-online/L1bTafTz3_US_en_US
  2. IRS, “What kind of records should I keep” (what a supporting document for an expense should show). https://www.irs.gov/businesses/small-businesses-self-employed/what-kind-of-records-should-i-keep
  3. Intuit, “Match your bank and credit card transactions,” QuickBooks Online help. https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/match-online-bank-transactions-quickbooks-online/L6qyw0PvP_US_en_US

Last checked 2026-11-12.

Related: What the accountant export actually does.

Receipt Rabbit is on the App Store. Download it here.

Read as MarkdownRSS feed