How to Import Receipts into QuickBooks Online

If you only have a few receipts a month, QuickBooks Online's built-in receipt capture is fine: snap a photo in the mobile app or upload a file, review what it read, and match or categorize it. The trouble starts when you have a backlog, such as a quarter of cash receipts, a client's shoebox, or a trip's worth of expenses. Processing those one at a time is slow.

The faster route is a CSV file uploaded as transactions. This guide explains how that works, what the file needs to look like, and how to keep your books clean while doing it. (PapersToSheet is an independent tool and is not affiliated with Intuit; QuickBooks screens change from time to time, so menu names below are described in general terms.)

Before you import: decide where these expenses belong

This is the step most guides skip, and it causes the most problems. A CSV upload in QuickBooks Online is imported into a specific bank, credit card, or cash account. Which account you choose depends on how the receipts were paid:

The CSV formats QuickBooks Online accepts

For uploading transactions from a file, QuickBooks Online accepts a CSV in either a 3-column or a 4-column layout. Both start with a date and a description; they differ in how amounts are expressed.

3-column: Date, Description, Amount

A single Amount column, where money going out (expenses) is negative and money coming in (refunds, deposits) is positive. This is the simplest format for receipts.

Date,Description,Amount
03/04/2026,Staples - printer paper and toner,-86.42
03/06/2026,Shell - fuel,-54.10
03/11/2026,Joe's Diner - lunch with client (R. Patel),-38.75
03/15/2026,Staples - return toner,24.99

4-column: Date, Description, Credit, Debit

Two amount columns, one for each direction, with positive numbers in both. Which column counts as money in and which as money out depends on the account type, and QuickBooks will ask you to map the columns during the upload, so double-check the preview.

Date,Description,Credit,Debit
03/04/2026,Staples - printer paper and toner,,86.42
03/06/2026,Shell - fuel,,54.10
03/15/2026,Staples - return toner,24.99,

Formatting rules that prevent failed uploads

• One date format throughout the file. Pick MM/DD/YYYY or another single format and use it in every row; QuickBooks asks you which format the file uses.
• Plain numbers only. No dollar signs, no thousands separators, no parentheses for negatives. Use -1250.00, not ($1,250.00).
• No extra columns, blank rows, or total rows. Delete subtotals and notes before saving.
• Commas inside descriptions. If a description contains a comma, it needs to be wrapped in double quotes. Excel does this automatically when you save as CSV; hand-edited files often miss it.
• Save as CSV, not XLSX. In Excel, use Save As and choose CSV UTF-8.

Step-by-step: from receipts to QuickBooks

1. Turn receipts into a QuickBooks-ready CSV

You can build the file by hand in Excel, typing each receipt's date, a description, and the total as a negative number. For more than a few receipts, the receipts to QuickBooks converter does it in one step: upload receipt photos or PDFs, choose the QuickBooks layout, and download a 3-column Date, Description, Amount CSV with expenses already negative and dates in a consistent format.

Write descriptions that will help you categorize later. Vendor plus a short note works well, such as Home Depot - lumber for job 212. QuickBooks can learn from vendor names when you categorize, so consistent naming pays off.

2. Review the file before uploading

Open the CSV in Excel and run three quick checks. First, total the Amount column and compare it to the total of your receipts. Second, sort by date and make sure nothing falls outside the period you expect. Third, look for duplicates:

Flag rows where the same date, description and amount appear more than once:
=IF(COUNTIFS(A:A, A2, B:B, B2, C:C, C2)>1, "DUPLICATE?", "")

3. Upload the file

1. In QuickBooks Online, go to Banking/Transactions and choose Upload from file.
2. Select your CSV and choose the account the transactions belong to (for example, Petty Cash or the card without a bank feed).
3. Map the columns: tell QuickBooks which column is the date, which is the description, and whether you use one amount column or two. Select the date format your file uses.
4. Check the preview. If expenses show as deposits, the sign or column mapping is reversed; go back and fix it rather than importing.
5. Confirm the import.

4. Categorize and attach the receipts

Imported transactions land in the review queue for that account, just like bank feed items. For each one, choose the payee and expense category, then add it to your books. Where you can, attach the original receipt image to the transaction so the evidence lives next to the entry. QuickBooks bank rules can auto-categorize recurring vendors after the first few.

Troubleshooting common upload problems

When line items matter

The bank upload records one amount per transaction. If a single receipt needs to be split across categories, say office supplies and a client reimbursable item on the same Staples receipt, split the transaction in QuickBooks during review. To know the split amounts, keep a line-item version of the receipt alongside the CSV; the standard layout from the receipt to Excel converter gives you both a document sheet and a line-item sheet.

For supplier invoices with many lines, such as stock purchases you also track as inventory, the invoice to Excel converter and a stock sheet like the free small business inventory template keep quantities in view, since the bank upload only carries totals.

Two alternatives to the bank upload

Recording receipts as expenses one by one

For a handful of cash purchases, entering each as an expense transaction directly in QuickBooks, with the receipt attached, is perfectly reasonable. It gives you full control over payee, category, and split lines from the start. It just does not scale to a backlog of fifty receipts.

Recording reimbursements as a single entry

If an employee or owner paid for several expenses personally, some businesses record the approved expense report as one bill or expense, split across categories, payable to that person. This keeps the reimbursement tied to one document. The expense report total and category subtotals become the split lines, and the individual receipts are attached to that single entry. Our guide on making an expense report from receipts shows how to produce those subtotals.

Which approach is right depends on how your accountant prefers to see reimbursements and petty cash, so it is worth a quick conversation before you import a large backlog. Whatever you choose, apply it consistently from month to month so your reports compare cleanly.

A monthly routine that keeps QuickBooks clean

1. Collect the month's cash and out-of-pocket receipts.
2. Convert them to a single QuickBooks CSV and run the duplicate and total checks.
3. Upload into the correct cash or reimbursement account and categorize.
4. Attach receipts to card and bank transactions that came in through the feed.
5. Reconcile each account against its statement.

If you are still building the habit of collecting receipts in the first place, start with our guide on how to organize receipts for taxes.