Business

Giving a bookkeeper your transactions for QuickBooks or Zoho Books

A bookkeeper asking for a Zoho Books or QuickBooks import wants clean rows in a set layout. What gig workers should prepare, with a small worked example.

Editorial illustration for Giving a bookkeeper your transactions for QuickBooks or Zoho Books

When a bookkeeper asks for your transactions in a Zoho Books or QuickBooks import format, they want one row per transaction, with a date, a description, an amount and ideally a category, in the column order their import screen expects. As a gig worker you only need to supply clean, categorised rows for one account at a time and let the bookkeeper confirm the layout.

Do not try to guess the template from memory. Ask for their sample file, or use an export template that matches the tool.

Do you need this at all?

Not every gig worker does. If you earn a few payouts a week and a CA files your returns from a simple sheet, a categorised spreadsheet is enough. A bookkeeper tends to become useful when you register for GST, hire a helper, or take a loan that needs proper books.

What does a clean import file look like?

  • One account per file, so the bookkeeper can match it to the right bank or card.
  • Dates in a single format throughout, ideally day, month, year.
  • A description a person can read, such as the merchant name.
  • Amounts as plain numbers, with money out and money in either in two columns or with a clear sign.
  • A category column using names the bookkeeper recognises.

The exact column order and names differ between tools and versions, so confirm with the person importing.

A worked example with hypothetical rows

DateDescriptionMoney outMoney inCategory
03-11-2026Pump A fuel1,350-Fuel
05-11-2026Platform payout-6,200Platform payouts
07-11-2026Workshop B2,400-Servicing
09-11-2026Recharge499-Phone and data

Net for these four rows: 6,200 in, and 1,350 + 2,400 + 499 = 4,249 out, so the account moved up by 1,951. If the bookkeeper's imported total does not match that, the date format or amount columns were read wrongly.

How do you prepare the rows?

  1. Choose the account and the period the bookkeeper wants.
  2. Make sure categories are consistent; correct the odd ones first.
  3. Export in the format agreed. If you only have a general file, ask whether a standard all-transactions file is acceptable.
  4. Open the file and compare the totals with your own before sending.
  5. Send it with a one-line note: account, date range and number of rows.

SpendixAI's export centre has templates for Zoho Books and QuickBooks, as well as Tally, a standard all-transactions file and a categories-and-tax-codes file. Import each bank or card statement to its own account first, review rows before saving, then export. Whether a particular layout suits your bookkeeper's version is something to check on their side before the first real import.

What should you not send?

  • Your net-banking login or any code you receive on your phone. A statement file is all that is needed.
  • A file that mixes two accounts.
  • A file with personal spending you have not tagged.

Gig work adds one more wrinkle: platform payouts are often a net figure after the platform's own deductions. Ask your bookkeeper whether they want the credited amount as one line or the gross figure with the deduction as a separate line. Either can be right depending on how they keep your books, and it is much easier to agree this before the first import than after three months of entries.

Finally, keep the file you sent. If the bookkeeper later says a month looks off, you can compare against exactly what they received.

Before you send, check

  • Row count matches your own.
  • Totals of money in and money out match.
  • Date range covers the whole period, including the first and last day.
  • Uncategorised rows are either fixed or flagged.
SPENDIXAI JOURNAL

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

Explore your reports