Bank statements

Organise 12 months of bank statements for your accountant in an hour

A one-hour plan for gig workers to collect, check and organise twelve months of bank statements for an accountant who needs them by Friday.

Editorial illustration for Organise 12 months of bank statements for your accountant in an hour

You can get twelve months of statements into a state your accountant will thank you for in about an hour if you work in a fixed order: collect, check for gaps, sort, mark and hand over. The aim is not perfect books, it is a complete, readable set with nothing missing. For gig workers the financial year runs April to March, so start with April.

What is the hour made of?

StepTaskMinutes
1Download twelve monthly statements, or one yearly file10
2Check for gaps and matching balances10
3Import and review rows20
4Tag platform payouts and work costs15
5Export and send5

The minutes add up: 10 + 10 + 20 + 15 + 5 = 60. If a step runs over, trim the tagging step, because your accountant can work with rough categories but not with missing months.

Step 1: collect everything

List every account that touched your work money: the main savings account, any second account where platform payouts land, a credit card used for fuel or phone bills, and wallets if you use them. Download a statement for each from April to March. File names like 2026-04-savings help sorting. If your bank offers a full-year download, use it; if not, twelve monthly files are fine.

Step 2: do the gap check

  1. Open each month and note the opening and closing balance.
  2. Confirm each month's closing equals the next month's opening.
  3. If they differ, a statement is missing or a page was cut off.
  4. Check the first and last dates in each file against the calendar month.

Say April closes at ₹18,300 and May opens at ₹18,300: good. If May opens at ₹21,800, ₹3,500 of activity is missing between them, and you need another file before doing anything else.

Step 3: import and review

SpendixAI keeps imported history per account, so pick the right account before each upload. It handles batch uploads and shows import history with status, and an Import failed notification tells you when one did not go through. Review the rows before saving. If you import the same month twice by accident, possible duplicate imports are flagged.

Step 4: tag what matters to your accountant

  • Platform payouts as income, one label per platform.
  • Fuel and vehicle costs.
  • Phone and data.
  • Vehicle or equipment repairs.
  • Transfers between your own accounts, labelled as transfers so they do not look like income or spending.

Do not agonise over rows you cannot place. Leave them as uncategorised and tell the accountant. They decide what is relevant.

Step 5: export and send

SpendixAI offers CSV downloads and an export centre with templates for Tally, Zoho Books and QuickBooks, plus a standard all-transactions file. Ask your accountant which format they use before choosing. Put the files in one folder with a short note listing accounts, period, and any months you could not get.

What if you cannot finish in the hour?

Send what you have, and say what is missing. An accountant can start on nine clean months while you chase the other three, and a note such as 'July statement not yet received from the bank' is far more useful than silence. Put the missing months at the top of next week's list, and ask for them straight away through the bank's normal channel rather than waiting for the last moment.

What should you not do?

  • Do not send net-banking logins; statements are enough.
  • Do not guess at tax treatment. Say what the money was, and let your accountant decide.
  • Do not delete anything you are unsure about.
  • Do not rely on screenshots of the app when a statement exists.

Rules and limits change, so anything about what is claimable or payable is a question for your CA, and your good records make that conversation short.

SPENDIXAI JOURNAL

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

Explore your reports