To download a filtered report as CSV, build the report with the filters your CA cares about, such as business accounts and one quarter, group it by category, download the CSV and check its total against the on-screen figure. The worked example below follows exactly that, with invented numbers, so you can repeat it with your own data.
What are we trying to produce?
Say your CA has asked for business spending for April to June, grouped by category, because they want to see where the money went without reading every line. You have two business accounts, a current account and a credit card, and a personal savings account that should stay out of this file.
SpendixAI has a Report builder that can filter and group, and reports can be downloaded as CSV. The steps are the same idea in any tool: choose the slice, choose the grouping, download.
How do I build the report?
- Open the Report builder and start a new report.
- Filter the accounts: select the current account and the credit card, and leave the personal savings account out.
- Filter the dates: 1 April to 30 June, with both ends included.
- Group the result by category, so each category shows as one line with its total.
- Check the on-screen result for anything odd, such as a category you do not recognise or a very large figure.
- Download the CSV and give it a clear name, such as business-spend-by-category-apr-jun.
What should the result look like?
The figures below are made up to show the shape of a grouped result. Your categories and amounts will differ.
| Category | Transactions | Total (₹) |
|---|---|---|
| Software subscriptions | 9 | 24,600 |
| Travel | 6 | 31,450 |
| Office supplies | 11 | 8,900 |
| Professional fees | 3 | 45,000 |
| Uncategorised | 4 | 6,250 |
The grand total is ₹24,600 + ₹31,450 + ₹8,900 + ₹45,000 + ₹6,250 = ₹1,16,200. Notice the Uncategorised line. Four transactions worth ₹6,250 have no category yet, so go back and fix them before sending. A report with an Uncategorised line is a to-do list.
How do I check the downloaded file?
Open the CSV in a spreadsheet and look at three things. First, the number of rows: is there one per category, plus perhaps a total row? Second, add the amounts yourself and compare with the on-screen total of ₹1,16,200. If the sum in the sheet is different, check whether the file contains a total row that you are double counting. Third, check that the amounts are real numbers, not text. A quick test is to select the column and see whether the sheet shows a sum at the bottom.
Can I get the transaction detail as well?
A grouped report shows totals, not individual entries. If your CA wants to see the rows behind each total, export the transactions for the same accounts and dates in the standard all-transactions file as well. Send both, and say that the grouped file is the summary and the other is the detail. The two should agree: the grouped totals are the sums of the detailed rows.
What if the numbers look wrong?
- A total is too low: a statement for that account may not have been imported for the whole quarter, or rows are still waiting in review.
- A total is too high: look for possible duplicates, for example the same statement imported twice.
- A category is missing: it may have been renamed, or its transactions sit under a different category.
- The currency looks odd: foreign-currency entries are totalled in the base currency using the rate saved with each transaction, so check those rows separately.
Before you send
Reread the filter settings once more, check that the date range covers the whole quarter, and confirm the file name says what it is. Mention in your email that the figures are from your records and that any GST amounts are estimates to be checked against invoices. Save a copy of the report settings so next quarter you can repeat the same steps in a few minutes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


