Business

Sending Categorised Transactions to Your Bookkeeper for QuickBooks or Zoho

A sole trader's guide to preparing a categorised transaction CSV for QuickBooks or Zoho Books, with £ examples, a column map and a mistakes list.

Editorial illustration for Sending Categorised Transactions to Your Bookkeeper for QuickBooks or Zoho

If you work for yourself and your bookkeeper asks for a file they can bring into QuickBooks or Zoho Books, the safest thing to send is a plain CSV of one account's transactions with a date, description, amount and category. This guide is written for a sole trader who has a business account and a personal card and keeps tripping over which one a payment belongs to.

Which account does each payment belong to?

Start by deciding what the file is for. The import should contain only the account the bookkeeper is working on. Say your business account shows 41 rows in March, and four of them are you paying yourself £500, £300, £250 and £450. Those are transfers to you, not business costs, so label them as drawings or owner transfers rather than leaving them as an expense category.

ColumnWhat to put in itExample
DateOne format throughout14/03/2026
DescriptionThe payee in plain wordsPrint shop, stationery
AmountSigned number, no currency symbol-48.60
CategoryName from your bookkeeper's listOffice costs
ReferenceOptional invoice or receipt numberINV-0231

How do you build the file in a spreadsheet?

Download your statement as CSV, open it, and rearrange columns to match the template. If your statement has separate paid-out and paid-in columns and the template wants one amount, create it with a formula. With paid out in column D and paid in in column E, put this in F2 and fill down: =E2-D2. Then copy column F and paste as values so the numbers survive deleting the originals.

  1. Keep the original download untouched in a separate folder.
  2. Work on a copy and remove opening and closing balance lines.
  3. Build a single signed amount column with =E2-D2 if needed.
  4. Strip pound signs and thousands commas so amounts are numbers.
  5. Type or paste the category against every row.
  6. Total the amount column and compare with the statement.

What goes wrong most often?

  • Receipts paid on a personal card: leave them out of the business file, and tell your bookkeeper separately so they can record the reimbursement.
  • Refunds entered as positive costs: a £35 refund should be a positive amount against the same category, not a new income line.
  • Split payments: a £120 supermarket shop that was £90 stock and £30 personal needs two rows or a note.
  • Wrong month: card payments that clear after month end belong where your bookkeeper puts them, so ask once and stay consistent.

Can an app do the categorising for you?

Hand-typing categories gets tedious by the second month. SpendixAI is built around India and INR, so it is not a fit for pound accounts, but its method is a useful model: import a statement, review each row, and let your own corrections become rules that apply next time. Its export centre includes Zoho Books and QuickBooks templates.

What should you say in the covering email?

Keep it to four lines: the account name, the date range, the row count and the net total. Say the file holds 41 rows and the net movement is £1,860.30, and your bookkeeper can confirm both in seconds after import. Add one line for anything odd, such as a supplier refund or a payment that was reversed. A short, factual note builds trust, and it makes the next month's request easier, because the bookkeeper knows exactly what to expect from you.

Before you send it

  • Open the finished CSV once more and read the top and bottom rows
  • Confirm the row count against the statement
  • Add the net total in your email so your bookkeeper can tick it off
  • Ask which date format their import expects
SPENDIXAI JOURNAL

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

Explore your reports