Your bookkeeper wants a file they can import into QuickBooks or Zoho Books, and a pile of bank screenshots will not do. What works is one CSV with a date, a description, an amount and a category on every row, covering a single account and a single month. Get those four columns right and most import screens will accept the file.
What does the bookkeeper actually need from you?
Ask for the import template before you export anything. Each accounting product publishes the columns it expects, and the order and the date format matter more than people think. Where the product lets you choose, many bookkeepers prefer a single signed amount column over separate debit and credit columns, but follow whatever their template says.
- A date on every row, in one consistent format such as 03/14/2026
- A description or payee that a human can recognise, not a card-processor code
- An amount with a clear sign: money out negative, money in positive, or two separate columns
- A category that matches names already set up in their chart of accounts
- One account per file, so the import lands in the right ledger
Step by step: from raw statement to import file
- Download the statement for one account for one calendar month, in CSV where the bank offers it.
- Delete summary rows, opening-balance lines and page footers so only transactions remain.
- Check that every amount is a real number, not text with a dollar sign and a trailing space.
- Add or confirm a category on each row, using your bookkeeper's category names exactly.
- Sort by date, oldest first, and save a copy before you touch anything else.
- Add up the file and compare it with the statement's closing balance minus the opening balance.
The last step is the one people skip. Say your statement opens the month at $5,200.00 and closes at $4,100.00, so the net movement is minus $1,100.00. If the file totals minus $1,100.00, you have everything. If it totals minus $1,250.00, a row is duplicated or a transfer was counted twice, and it is far cheaper to find that now than after import.
How do you keep categories consistent between exports?
The usual failure is naming. One month the grocery run is Groceries, the next it is Food and the one after Supermarket, and the bookkeeper ends up with three accounts for one thing. Write your category list once, share it with them, and treat it as fixed. If a new category is needed, add it deliberately rather than typing a fresh name mid-export.
| Check | Healthy sign | Problem sign |
|---|---|---|
| Row count | Matches the statement's transaction count | Fewer or more rows than the bank shows |
| Net total | Equals closing minus opening balance | Off by exactly one row's amount |
| Categories | Only names from the agreed list | Variants such as Office and Office Supplies |
| Dates | All one format, all inside the month | Mixed formats or rows from the next month |
What if one export has to cover several accounts?
Keep a separate file for each account, even when it feels wasteful. Importing a card and a current account in one file makes every transfer between them look like income or spending. A $600 payment from the checking account to the card should appear once as money leaving checking and once as money arriving on the card, and your bookkeeper will mark both as a transfer.
Where an expense app can save the retyping
If you categorise by hand every month, an app that remembers your corrections shortens the job. SpendixAI is built around India and INR, so it suits readers tracking rupee accounts rather than dollar ones, but its approach is worth knowing: you upload statements, review the rows, correct categories, and the export centre offers Zoho Books and QuickBooks templates plus a standard all-transactions file.
A short checklist before you hit send
- Template columns requested from the bookkeeper
- One account, one month, one file
- Net total tied to the statement
- Category names copied from their list
- A saved copy of the untouched original
Useful ideas start with a clearer picture of your own spending.
Explore your reports

