Name each statement with the year, month, account and file type, in that order, such as 2026-04_hdfc-salary_statement.pdf, and keep them in one folder per financial year and account. Year first, then a two-digit month, means your file list sorts by date without any effort, and a Power Query folder import can read every file in one go.
What file naming pattern sorts correctly?
File Explorer sorts names character by character. A name starting with Apr-2026 sorts before Feb-2026 because A comes before F. A name starting 2026-04 always sorts in time order. Use these parts:
- Year, four digits, then a hyphen.
- Month, two digits: 04 for April, 03 for March.
- An underscore, then a short account label such as hdfc-salary, sbi-joint or icici-card.
- An underscore, then what the file is: statement, csv or receipt.
Use only lowercase letters, digits, hyphens and underscores. Avoid spaces and brackets, which cause trouble when a tool reads file names. Put only the last four digits of an account number in the name, never the full number.
How should I arrange the folders?
Indian financial years run April to March, so group by that rather than the calendar year. One layout that works:
| Folder | What goes inside |
|---|---|
| Statements / FY2026-27 / hdfc-salary / original | The PDFs as downloaded |
| Statements / FY2026-27 / hdfc-salary / csv | CSV or Excel versions of the same months |
| Statements / FY2026-27 / icici-card / original | Credit card statement PDFs |
| Statements / FY2026-27 / receipts | Scans named 2026-06-14_electricity-bill |
| Statements / archive | Previous financial years, moved at year end |
For a joint account or a family with several people, either add a person folder above the account folder or put initials in the label, such as asha-hdfc-salary. Keep tax papers like Form 16 and investment proofs in a separate Tax folder for each financial year instead of among the statements.
The month then sits in the file name, not in a subfolder, so twelve files per account per year sit in a single place. Keeping the originals apart from converted files means you never mix a clean CSV with an official PDF.
Why does this help Power Query?
In Excel, Data, Get Data, From File, From Folder points at a folder and loads every file in it. This only works well when the files have the same layout. So give each account its own csv folder: one bank's exports share columns, but two banks' exports usually do not. The query can also add the file name as a column, which lets you pull the month and account from the name you have already written. If you leave stray files in the folder, such as a PDF or a half-edited copy, the query will try to read them too, so keep that folder to statement CSVs only.
What do I do with the files I already have?
- Create the folder tree for the current financial year first.
- Move this year's statements in and rename them using the pattern. Do twelve, not a hundred.
- Spot-check that every month from April has a file; a missing month stands out once the list is sorted.
- Do older years only when you need them.
A quick way to rename many files on Windows: select them all, press F2, and Explorer applies one base name with a number. For more control you can use a spreadsheet to build the new names with =TEXT(A2,"yyyy-mm")&"_hdfc-salary_statement.pdf" where A2 holds a date, then copy the results into a renaming tool or rename by hand.
Do I need all this if I use a tracker?
Less, but the same discipline helps. When you upload statements to SpendixAI you pick the account first, and batch uploads are supported, so a folder with twelve consistently named files per account is easy to upload in one go. Keep the originals anyway; they are your proof if a figure is ever questioned.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


