To prepare bank statements for a lawyer, download each statement from your own account for the period you were asked about, name every file by account and dates, keep them in one folder, and add a single index page listing what each file is. Add short notes against large or unusual transactions, and share only what your adviser has asked for.
What should I ask the lawyer or mediator first?
Before downloading anything, ask four questions: which accounts and cards, which period, which format they prefer, and whether they want summaries or only the statements. Write the answers down. Many people download everything for ten years and then hand over far more than is needed. Asking first saves time and keeps unrelated information private.
How should I download and name the files?
Use your own net banking or app, the way you normally would, and choose the date range you were given. Banks differ in how they offer statements, so look at what your bank offers rather than relying on a general description. Do not ask anyone to download from your account on your behalf using your login, and do not use anyone else's.
Name files so they sort by themselves. A pattern that works: account nickname, last four digits, start month and end month. For example: Savings-1234-2024-04-to-2025-03.
| File name | Account | Period | Format |
|---|---|---|---|
| Savings-1234-2024-04-to-2025-03 | Savings account, Bank A | April 2024 to March 2025 | |
| Joint-5678-2024-04-to-2025-03 | Joint account, Bank B | April 2024 to March 2025 | |
| Card-9012-2024-04-to-2025-03 | Credit card | April 2024 to March 2025 | |
| Card-9012-2024-04-to-2025-03-data | Same card, for sorting | April 2024 to March 2025 | CSV or Excel |
Using the April to March financial year as your period unit keeps things tidy, and many advisers will think in the same terms. Ask whether they want the calendar year instead.
How do I add notes to large transactions?
Decide a threshold, such as every transaction above ₹50,000, and for each one write a single factual line in a separate notes table: date, amount, and what it was, such as school fee for first term or advance for flat repairs. If you do not remember, write that, do not guess. Keep the notes short and neutral; your adviser will ask for detail if needed.
- Date and amount as on the statement
- What the payment was for, in one line
- The document that proves it, if you have one: invoice, receipt or agreement
- Anything you are unsure about, marked as unsure
What goes into the index page?
One page, listing every file with the account, bank, period, number of pages and where the notes are. Put the date you prepared it at the top. If a statement is missing, say so on the page and why. An index turns a pile of files into a bundle that someone else can read in ten minutes.
Can SpendixAI help produce a clean history?
If you have already imported your statements, the Report builder lets you filter and group by account and date, and a CSV download gives you a plain table you can attach next to the original statements. The export centre also has a standard all-transactions file. Keep the original bank statements as the main record, since those come from the bank.
Final checks
- Confirm the list of accounts and the period with your adviser.
- Check that every statement covers the full period without gaps.
- Name every file the same way and open each one to make sure it is readable.
- Prepare the index and the notes table.
- Send only the agreed set and record the date.
This is about organising records, not about what the records mean legally. Questions on that go to your lawyer.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


