Getting started

Exporting a standard all-transactions file for your CA

What a complete all-transactions file for your CA should contain, how to export a chosen period, and how to check its totals against your bank statement.

Editorial illustration for Exporting a standard all-transactions file for your CA

A standard all-transactions file is one spreadsheet-style list of every entry in a period: date, merchant, amount, currency, account and category. Export it for the exact period your CA asked for, open it, and compare the total with your bank or card statement before you send it. That ten-minute check saves several rounds of email later.

What should the file contain?

Your CA does not need a pretty report. They need a flat list where each row is one transaction and every row has the same columns, so it can be sorted, filtered and totalled. A good file usually carries these columns, and you should confirm the exact headings in the file you download.

ColumnWhy your CA wants it
DateTo place the entry in the right month, quarter and financial year
Merchant or descriptionTo recognise who was paid and ask you about odd entries
AmountThe figure itself; debits and credits should be distinguishable
CurrencyTo know whether an amount is in rupees or something else
AccountTo tie each row back to a bank account, card or wallet statement
CategoryTo group spending without re-reading every line

If a column you expected is missing, say so when you send the file rather than leaving your CA to guess.

How do I export a single period?

The idea is the same whatever the tool: choose the type of file, set the date range, download. In SpendixAI the Export centre has a standard all-transactions file among its templates, so the steps look like this.

  1. Decide the period with your CA first: a month, a quarter such as April to June, or the full April to March year.
  2. Open the Export centre and choose the standard all-transactions file.
  3. Set the start and end dates so they match the period exactly, including the last day of the month.
  4. Download the file and save it with a clear name, such as transactions-apr-jun-2026.
  5. Open it once yourself before sending it anywhere.

Does the file match my statement?

Do this check every time. Take the statement for one account and total its debits for the period. Then filter your file to that account and total the same rows.

Say a savings account statement shows debits of ₹1,84,500 for the quarter, but your file shows ₹1,82,200 for that account. The gap is ₹2,300. Sort the file by date and look for a missing day, a transaction you deleted by mistake, or a statement that was never imported. It may also be a row sitting in review that was not saved. A small difference with a clear cause is fine; a difference nobody can explain is worth fixing before it reaches your CA.

What if cash spending is part of the file?

Cash entries have no statement to compare with, so they deserve a second look. Make sure each one has a merchant or purpose, and keep the bill or a photo of it where you can find it. Your CA is more likely to question a row that just says cash with no explanation.

Should I send anything alongside it?

Often yes. The transactions file shows category names, but not what they mean. A separate categories and tax-codes file explains your category list and tax settings, which helps your CA read the first file correctly. Send the receipts or invoices only if asked, and say which transactions they belong to. Where the figures include GST estimates, mention that they are estimates and that your CA will check them against invoices.

Before you press send

  • The period matches what your CA asked for, start date and end date.
  • Every account you used in that period appears in the file.
  • Each account total agrees with its statement, or the gap is explained.
  • No half-finished rows are still waiting in review.
  • The file name says what it is and which period it covers.
  • Your message lists any known oddities, such as a refund or a card that was replaced mid-quarter.

Keep a copy of exactly what you sent. If your CA comes back with a question in October about a June entry, you can open the same file and answer from it.

SPENDIXAI JOURNAL

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

Explore your reports