How to import receipts into Zoho Books as expenses

Entering expenses in Zoho Books one at a time works until it doesn't. A month of coffee, software and mileage is fine. A year of receipts found the week before your accountant's deadline isn't. Zoho Books can import expenses in bulk from a CSV file, and if the file is built right, the whole year goes in at once.

What the import file needs

Zoho Books matches each column in your file to one of its expense fields during import. The What Receipt? Zoho export uses these columns:

Column	What goes in it	Notes
Expense Date	2026-07-26	Pick the matching date format on the mapping screen
Expense Account	Software & Subscriptions	Must match an account name in your Zoho chart of accounts
Amount	35.00	The receipt total
Tax Amount	0.00	Tax as printed on the receipt
Vendor Name	Slack	Matched to a Zoho vendor if one exists
Paid Through	Visa ending 4242	The account you paid from. Must match a Zoho account if you use it
Customer Name		For billable expenses. Leave blank otherwise
Project Name	Client website	Matched to a Zoho project if you use projects
Reference Number	RB-82	Traces each expense back to its receipt and helps you spot duplicates
Description	Team plan, July	Your note, such as the business purpose
Currency Code	USD

You don't need What Receipt? to do this. Any spreadsheet with these columns works, and the steps below are the same. The app just saves you typing the rows.

Step by step

1. Export the file

In What Receipt?, open Settings → Export and tap Zoho CSV. Turn on Confirmed receipts only to leave out anything you haven't reviewed. The file covers all your receipts, so open it in a spreadsheet first and delete the rows you don't want this time: other periods, or anything in your Personal project.

If you're building the file yourself, save it as CSV (UTF-8).

2. Line up account names before importing

This is the step that saves you from an import full of errors. Zoho Books needs every value in Expense Account to match an existing account in your chart of accounts exactly. If your file says Software & Subscriptions and Zoho has Computer – Software, that row fails or lands in the wrong place.

You have two options:

• Create the missing accounts in Zoho under Accountant → Chart of Accounts, as Expense accounts with the same names your receipts use. This is quickest if your categories are sensible.
• Rename the categories to match Zoho's accounts. In What Receipt?, categories double as the expense account names on export, so rename once and every future export matches.

Do the same for Paid Through if you fill it in. The value has to name one of your bank, card or cash accounts in Zoho.

3. Import into Zoho Books

1. In Zoho Books, go to Purchases → Expenses.
2. Open the menu at the top right of the expenses list and choose Import Expenses.
3. Upload your CSV, check the character encoding (UTF-8) and continue.
4. On the Map Fields screen, check each column is matched to the right Zoho field. If you use the column names above, most match automatically. Set the date format to match your file (yyyy-MM-dd).
5. Preview the import. Zoho shows which rows are ready and which have problems, which are almost always account names.
6. Click Import.

Zoho moves menus around occasionally. If the import option isn't where it's described, Zoho's help pages for "import expenses" have the current path.

4. Spot-check, then attach what matters

Open a few imported expenses and compare them with the receipts. Check the date, amount, account and vendor. The Reference Number on each expense matches the receipt in What Receipt?, so it's easy to trace a number back.

A CSV carries data, not images, so the import doesn't attach receipt files. For most expenses that's fine as long as the originals are kept and searchable. For large or unusual ones, attach the receipt to the expense in Zoho as well.

Mistakes that cost an afternoon

• Importing the same period twice. Zoho doesn't know a row is a duplicate. Trim the file to the period you're importing and note where you stopped. The reference numbers make leftovers easy to spot.
• Mixing personal and business. Remove personal rows (the Project Name column makes them easy to filter) before importing, not after.
• Importing a whole year in your first attempt. Import ten rows first. Fixing a mapping mistake on ten expenses is much easier than on four hundred.
• Tax entered twice. If your Zoho organization calculates tax from tax rates, decide whether you want the receipt's tax amount or Zoho's calculation. Ask your accountant which one they expect.

Questions

Can Zoho Books import expenses from a CSV?

Yes. Zoho Books imports expenses from CSV, TSV and Excel files under Purchases → Expenses, through the menu at the top right of the list. You map your columns to Zoho's fields during import.

Why does my Zoho expense import fail?

Usually because a value in the Expense Account or Paid Through column doesn't exactly match an account in your Zoho chart of accounts. Create the missing accounts or rename the values in your file, then import again.

Does the import attach the receipt images?

No. A CSV import brings in the expense data only. Keep the original receipts somewhere searchable, and attach them in Zoho for the expenses you expect to be asked about.

Does this work for QuickBooks or Xero?

Not with this file. Each product has its own import format. What Receipt?'s standard CSV export has the fields both need (vendor, date, category, project, total, tax, currency, payment method, notes), and you or your bookkeeper can map those columns. See getting receipts into QuickBooks Online and getting receipts into Xero. Native exports for both are on the roadmap.