How to Import Receipts Into QuickBooks Online

There are two main ways to get receipts into QuickBooks Online (QBO). One is one receipt at a time with QuickBooks' own receipt capture (uploading or photographing a receipt and matching it to a transaction). The other is many receipts at once by turning them into a CSV file and uploading it as transactions. Which is right depends on volume and on whether those purchases already appear in your bank feed. Get that wrong and you'll record the same expense twice.

This guide explains both routes, what the CSV file needs to look like, and how to avoid duplicates. QuickBooks menus and plan features change often, so for the exact current clicks, search Intuit's QuickBooks help for "upload receipts" or "manually upload bank transactions". This article sticks to the parts that don't depend on which version you have.

First: are these purchases already in QuickBooks?

This is the question that decides everything.

Paid by a card or bank account connected to QuickBooks? The transactions are probably already arriving through your bank feed. You don't need to import the receipts as new transactions. You need to attach them as evidence and categorize the existing transactions. Importing them as well would double-count the expense.
Paid in cash, personally, or from an account that isn't connected? Then QuickBooks doesn't know about them yet, and importing the receipts as transactions is what you want.

Many businesses have a mix. Sort your receipts into those two piles first.

Route 1: Attach receipts to bank feed transactions

For purchases already in your bank feed, the goal is to pair each receipt with its transaction:

Use QuickBooks' receipt upload or capture feature (on the web, by email or in the mobile app, depending on your plan and version).
Depending on your version, QuickBooks may read the receipt and suggest a matching bank transaction.
Check the match and the category before you confirm.

This keeps the bank feed as your single source of transactions, with receipts attached as evidence. It's ideal when receipts arrive one or two at a time. It gets slow for a year-end backlog of hundreds. Check Intuit's help for how receipt capture works on your plan, because availability and steps vary.

Route 2: Upload many receipts as a CSV

For purchases not in your bank feed (cash, personal cards, unconnected accounts), you can bring them in as a batch. QuickBooks Online lets you manually upload transactions from a file into an account. Intuit's help article on manually uploading bank transactions explains the current steps and accepted file formats, so check it before your first upload.

What the CSV needs

A common format for QuickBooks bank uploads is a simple three-column CSV:

Date,Description,Amount
03/14/2026,Staples – Office supplies,-54.20
03/15/2026,Shell – Transport & fuel,-61.80

Points to get right:

One row per receipt.
Date format consistent throughout. US QuickBooks companies typically use MM/DD/YYYY. Mixed formats are a classic cause of failed uploads.
Amounts as plain numbers, with no currency symbols or thousands separators. Expenses are usually negative (money out).
One currency per file. Don't mix USD and EUR receipts in one upload.
A useful description. Vendor plus category makes the review screen in QuickBooks much faster.

You can build this file by hand in Excel or Google Sheets: three columns, then Save as CSV. The receipt spreadsheet guide covers keeping clean date and amount columns.

Creating the CSV from receipt photos and PDFs

If your receipts are photos or PDFs, typing the rows is the slow part. ReceiptBatch converts receipts to a QuickBooks Online CSV. You drop in a batch, review and correct the extracted table, then download a three-column Date,Description,Amount file. Dates are written as MM/DD/YYYY, the description is "Vendor – Category", amounts are negative (as expenses), and the option is only offered when every receipt in the batch is in the same currency.

Where to upload it

Pick the destination account deliberately:

Cash purchases: a cash or petty cash account.
Personal card used for business: many bookkeepers record these against an owner's contribution or a dedicated "paid personally" account. Ask your accountant which they prefer.
An unconnected business card: upload into that card's account in QuickBooks.

Don't upload into an account that already has a live bank feed for the same transactions, or you'll create duplicates.

After uploading

The transactions land in QuickBooks for review. For each one:

Check the date and amount against the receipt.
Set or confirm the category (expense account). It helps if your categories match your chart of accounts. See business expense categories.
Add the payee if needed.
Attach the receipt image, if your plan supports attachments, so the evidence lives with the transaction.
Confirm or add the transactions.

Avoiding duplicates

Duplicates are the most common mistake when importing receipts. Some safeguards:

Split the pile first (in the bank feed vs not in the bank feed), as above.
Check a sample after uploading: search QuickBooks for a few vendor names and amounts to make sure each appears once.
Reconcile the account against its statement. If the reconciled balance is off by the amount of some receipts, they were probably entered twice.
Keep a log. Note which receipt batches you've uploaded, and when.

Keep the receipts themselves

A CSV row in QuickBooks is a record of the expense, not the evidence for it. Keep the original receipt images or PDFs, attached in QuickBooks or stored in a year folder, for as long as your tax authority requires. A card statement line alone usually isn't enough, as is a bank statement enough instead of a receipt? explains.

If an accountant or bookkeeper manages your QuickBooks file, agree the method with them first. Some prefer to receive a spreadsheet and the receipt folder rather than having uploads in the file. See how to prepare your receipts for your accountant.

FAQ

Can I import receipts into QuickBooks Online in bulk?

Usually, yes: either by uploading several receipts through QuickBooks' own receipt features, or by uploading a CSV of transactions into an account. Check Intuit's help for the current limits and steps on your plan.

Why did my CSV upload fail?

Common causes are inconsistent date formats, currency symbols or commas inside amounts, extra header rows, blank lines, or a different column layout from the one selected during upload. Open the file in a text editor to see exactly what's in it.

Should expenses be negative in the CSV?

For a single Amount column, money out is normally negative and money in positive. Check the column mapping and the preview during upload before you confirm, so expenses don't arrive as income.

Does importing a CSV attach the receipt images?

No. A CSV carries only the data. Attach the images to the transactions separately, or keep them in your own records.