To get categorised transactions into QuickBooks or Zoho Books, export one account's transactions as CSV, make sure every row has a date, description, amount and category, and decide in advance what to do with payments in a different currency. If you are a freelancer paid in euros and occasionally in another currency, that last decision is where most imports go wrong.
Why does currency need a decision before you export?
A bookkeeper keeps books in one main currency. Say yours is the euro, and a client pays you $1,000 that lands in your account as €918.40 after conversion. The statement shows €918.40, and that is the figure that belongs in the file. The dollar amount can sit in a note column, but it should not be the amount the importer reads.
| Payment | Original | Amount that hit the account | Put in the amount column |
|---|---|---|---|
| Client A invoice | €2,000.00 | €2,000.00 | 2000.00 |
| Client B invoice | $1,000.00 | €918.40 | 918.40 |
| Software subscription | €24.00 | -€24.00 | -24.00 |
| Co-working desk | €180.00 | -€180.00 | -180.00 |
The total of the four rows is 2,000.00 + 918.40 - 24.00 - 180.00 = 2,714.40. If the account moved by €2,714.40 over those transactions, the file agrees with the bank.
What should the file look like?
- One account and one period per file
- A date in one fixed format, agreed with the bookkeeper
- An amount column with a minus sign for money out
- A category column using their names
- An optional note column for the original currency or invoice number
How do you handle the decimal comma problem?
Some European setups write 1.250,50 where others write 1,250.50. If your file mixes the two, an import tool may read 1.250,50 as text and reject the row. Decide on one convention before you save, and ask your bookkeeper which one their import expects. A quick test: add the amount column in a spreadsheet. If the total is zero or an error, some amounts are being treated as text.
Step by step before sending
- Export the account as CSV and keep the original.
- Remove balance lines, headers repeated on each page and any summary rows.
- Convert each amount so it is the figure that actually reached the account.
- Add the category from the agreed list.
- Add the original currency amount in a note column for foreign payments.
- Check the net total against the statement.
Can software reduce the manual work?
SpendixAI is built around India and INR, so it does not serve euro accounts, but it shows a sensible design: each expense can carry its own currency, totals use a rate saved with each transaction, and the export centre provides Zoho Books and QuickBooks templates. Whatever tool you use, saving the rate with the transaction is the habit worth copying.
Which date format should you choose?
The date column deserves a decision of its own. Year, month, day written as 2026-03-14 is the least ambiguous because no reading of it puts the month first by accident. If your bookkeeper's template insists on another order, follow it, but test with one date above the twelfth, such as the 14th, after you convert. If that row survives intact, the whole column is being read in the order you meant. Writing the format into your covering note removes any doubt about it later.
Quick checks
- Does the net total match the account movement?
- Are all amounts numbers in one decimal style?
- Are foreign payments noted?
- Did you keep the untouched original?
Useful ideas start with a clearer picture of your own spending.
Explore your reports
