Spreadsheets

Folder structure and file names for saved bank statements

A folder tree and a year-month-account file naming pattern for bank statements that sorts correctly and makes a Power Query folder import easy.

Editorial illustration for Folder structure and file names for saved bank statements

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:

FolderWhat goes inside
Statements / FY2026-27 / hdfc-salary / originalThe PDFs as downloaded
Statements / FY2026-27 / hdfc-salary / csvCSV or Excel versions of the same months
Statements / FY2026-27 / icici-card / originalCredit card statement PDFs
Statements / FY2026-27 / receiptsScans named 2026-06-14_electricity-bill
Statements / archivePrevious 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?

  1. Create the folder tree for the current financial year first.
  2. Move this year's statements in and rename them using the pattern. Do twelve, not a hundred.
  3. Spot-check that every month from April has a file; a missing month stands out once the list is sorted.
  4. 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.

SPENDIXAI JOURNAL

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

Explore your reports