Business

How to Export Categorised Transactions for a US Bookkeeper's Import

Get a clean, categorised transaction file ready for a QuickBooks or Zoho Books import, with a month-end checklist and a worked $1,100 reconciliation example.

Editorial illustration for How to Export Categorised Transactions for a US Bookkeeper's Import

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

  1. Download the statement for one account for one calendar month, in CSV where the bank offers it.
  2. Delete summary rows, opening-balance lines and page footers so only transactions remain.
  3. Check that every amount is a real number, not text with a dollar sign and a trailing space.
  4. Add or confirm a category on each row, using your bookkeeper's category names exactly.
  5. Sort by date, oldest first, and save a copy before you touch anything else.
  6. 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.

CheckHealthy signProblem sign
Row countMatches the statement's transaction countFewer or more rows than the bank shows
Net totalEquals closing minus opening balanceOff by exactly one row's amount
CategoriesOnly names from the agreed listVariants such as Office and Office Supplies
DatesAll one format, all inside the monthMixed 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
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports