Budgeting

CSV or PDF: which report format to send your CA

CSV, Excel or PDF for your CA: what each format is good for, which columns to include, and how to send receipts so the review goes faster.

Editorial illustration for CSV or PDF: which report format to send your CA

Send a CSV or Excel file for the working data and keep a PDF for the records. A CA reviewing or reconciling can sort, filter and total a spreadsheet, but cannot do much with a picture of a table. PDFs suit signed, final copies and original statements. When in doubt, ask your CA which they prefer and whether they want one combined file or one per account.

Which format suits which job?

FormatGood forWeak atSend when
CSVSorting, filtering, importing into accounting softwareNo formatting, no formulas kept, can mangle dates and long numbersThe CA will reconcile or import the data
ExcelTotals by category, several sheets, notes in cellsFormulas can break if the structure changesYou also want a summary tab and comments
PDFFinal copy, original bank statements, signed documentsHard to sort or total, copied text is messyThe CA wants proof or an archive, not a working file

What columns should the file have?

  • Date, in one consistent format.
  • Description or merchant name, as it appears on your statement.
  • Amount, with money out and money in either in separate columns or clearly signed.
  • Account or card the entry came from.
  • Category.
  • A notes column for business or personal use, or reason for the payment.
  • Receipt or invoice reference, such as a file name, if you have one.

If tax-related fields apply to some purchases, such as a GST amount, include them as a column rather than burying them in the notes. Treat those figures as estimates and let your CA confirm them from the invoices.

How should I send receipts?

Put receipt images or PDFs in one folder and name each file with the date and a few words, for example 2026-10-14-printer-ink. Mention the same name in the receipt column of your sheet. Your CA can then match a row to a file in seconds instead of asking you for each one. Skip receipts for small everyday spends unless your CA asks.

Should I send the original bank statement too?

Yes, as a PDF from your bank, for any period your CA is reconciling. A tracker file is your own record, and the bank statement is the source it was built from. Seeing both lets the CA check that nothing is missing, such as an account you forgot to export.

Where does SpendixAI fit in?

SpendixAI can download reports as CSV and has an Export centre with templates for Tally, Zoho Books and QuickBooks, a standard all-transactions file, and a categories-and-tax-codes file. If your CA already works in one of those tools, ask whether they want that layout; if they do not, the standard file is the simplest start.

What goes wrong when the file opens on the other side?

The same CSV can look different on your computer and your CA's, so a quick test is worth it. Reopen the exported file yourself before sending.

  • Dates read as 03/04/2026 can be 3 April or 4 March depending on settings. Use a clear format such as 2026-04-03.
  • Amounts with a rupee symbol or commas may become text, and a total will then ignore them. Export plain numbers.
  • Long reference or cheque numbers can lose digits or turn into scientific notation. Keep them as text.
  • Merged cells and coloured rows look neat in Excel but break sorting and importing, so avoid them in the data sheet.
  • If names use accented or regional characters, save as CSV in UTF-8 so they do not turn into symbols.

Put any commentary, such as "this refund belongs to March", in a separate notes sheet or message, not inside the data columns.

A short checklist before sending

  1. Agree the period, such as April to March for the financial year.
  2. Ask which format and which columns your CA wants.
  3. Export one file per account, or one combined file with an account column.
  4. Attach the original statements as PDFs.
  5. Share receipts in a named folder.
  6. Keep a copy of exactly what you sent, with the date.
SPENDIXAI JOURNAL

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

Explore your reports