Business

Zoho Books CSV import: preparing your expense columns

Prepare a clean CSV of expenses for an accounting import: the usual columns, a cleaning checklist and a trial-run habit. No promises about exact screens.

Editorial illustration for Zoho Books CSV import: preparing your expense columns

A CSV that imports cleanly into accounting software like Zoho Books is one row per expense, a single date format, plain numbers, and names that match what already exists in your account. The exact screens and field names change over time, so build the file from the ideas below and check it against the current import page before uploading.

Which columns does an expense import typically ask for?

Most accounting products want a similar core set, even if they label it differently.

  • Date: the day the expense happened.
  • Expense account: the category, for example Travel or Rent.
  • Paid through: the bank, card or cash account the money left from.
  • Amount: the total paid, as a plain number.
  • Tax: the tax amount or rate, if your records show it separately.
  • Vendor: who you paid.
  • Reference: bill number, UTR or cheque number.
  • Description: a short note on what it was for.

What should I clean before importing?

  1. Make all dates one format and check none are stored as text.
  2. Strip currency symbols, commas and spaces from the amount column so each is a pure number.
  3. Make vendor names consistent: one spelling for each supplier, not Sharma Pack, Sharma Packaging and SHARMA PKG.
  4. Match expense account names exactly to the accounts in your books; if a new one is needed, create it first.
  5. Remove header repeats, subtotals and blank rows inside the data.
  6. Split any row that mixes two purposes into two rows.

How do I handle tax in the file?

Keep the tax in its own column rather than burying it in the total. If a bill is ₹5,900 including tax and your records show ₹900 tax, write ₹5,000 as the expense amount and ₹900 as the tax, so 5,000 + 900 = 5,900 still equals what left the bank. Whether that tax is recoverable, and how it should be shown, depends on your registration and the rules in force; rules and limits change, so confirm the current position with your CA or the official source.

What is a safe way to run the import?

  • Save a copy of the file before editing, so you can always go back.
  • Import five to ten rows first and open each to see where fields landed.
  • Look for rows that landed in the wrong account or with today's date instead of the real one.
  • If it went wrong, delete the trial rows and fix the file rather than patching entries one by one.
  • Only then import the rest.

Where does SpendixAI fit?

If your expenses start life as bank or card statements, SpendixAI can take the PDF, CSV or Excel statement, let you review the rows, categorise them and then export through its Export centre, which has a Zoho Books template. It also has a standard all-transactions file. Treat the template as a starting layout and compare it with the columns your own Zoho Books import page shows.

What does one finished row look like?

Here is a hypothetical row, field by field. Date: 2026-11-09. Expense account: Fuel. Paid through: Current Account. Amount: 2400. Vendor: the petrol pump you pay regularly. Reference: UPI 4821. Description: Fuel for delivery van.

  • If your bill had tax shown separately, add the tax column and reduce the amount accordingly, as in the worked figures above.
  • If the vendor is not already in your books, check whether the import creates it or fails; create it yourself first if in doubt.
  • If the same vendor appears in the file ten times, make sure all ten spellings are identical, or you may end up with ten vendors.
  • If a date is a Sunday or a holiday, that is fine; it just has to be the real date of the payment.

Saving the finished file with a month label, such as expenses-november-2026, makes it easy to find if you need to explain what you imported.

Last checks

  • Do the totals match the statement?
  • Are all vendors and accounts spelt the way the books spell them?
  • Does every row have a reference you could trace later?
  • Did your accountant approve the account list you are using?
SPENDIXAI JOURNAL

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

Explore your reports