A freelancer's statements pile up fast: a current account, a savings account, maybe a card and a gateway wallet. Each PDF may have its own password rule. The workable approach is to name each file by account and month, open it with the password your bank set, confirm its dates, and import it into the right account.
Why bother? Because clients, banks and your accountant can all ask for records, and finding twelve months of files in a hurry is stressful.
How many files are we talking about?
Four accounts for twelve months is 4 × 12 = 48 files a year. At three minutes each that is 144 minutes, about two and a half hours. Doing four files a month is twelve minutes. Small and regular wins.
What naming makes them easy to find?
- Account first, then year and month, like Current-2026-09 and Card-2026-09.
- Keep one folder per financial year, April to March.
- Add Opening and Closing balance to a small note beside each file.
- Store the original locked file; do not overwrite it.
How do I open and import each?
- Open the PDF with the password your bank describes in its statement email or help page.
- Confirm the period and the closing balance.
- Import into the matching account in your tracker, reviewing rows before you save.
- Mark the account and month done in a simple list.
If a file refuses to open, check the typed password and the bank's description of it before trying again. Repeated wrong attempts can annoy a viewer, but that is a matter for the viewer rather than the bank.
What should I do about client payments?
Statements show credits like UPI or NEFT from clients, usually with a short reference. Add a rule so a client name always maps to an income category. SpendixAI lets you create rules and aliases for merchants, and your corrections become history for next time. It can read a PDF, CSV or Excel statement and shows each row for review, so a payment from a client with an unusual name can be fixed in one place.
When is a CSV easier than a PDF?
When you have many months to load. Ask your bank whether it offers a CSV or Excel export for a date range, because rows then arrive cleanly. Keep the PDF anyway as the original record.
How do I check a locked statement against my invoices?
After importing, open the income rows and compare each with your invoice list. Say you raised four invoices in a month, ₹30,000, ₹18,000, ₹12,500 and ₹9,000, a total of ₹69,500. If the statement shows only three of those, you know which client is yet to pay. A tracker records what reached the bank; your invoice list records what was owed, and the difference is your follow-up list.
- Note the invoice number in the reference when you can.
- Mark paid invoices with the date the money arrived.
- Chase the unpaid ones on a fixed weekday.
When you apply for a loan or a rental agreement, the person asking usually wants three to six months of statements. If your files are named and imported, you can produce them in minutes, and you can also read your own average monthly credits from the tracker before you apply, so you know what the lender will see.
Keep the original PDF as the version you hand over. A tracker report is for your understanding; the bank's file is the evidence.
Your quarterly catch-up
- List accounts and months for the quarter.
- Tick each file you have imported.
- Reconcile closing balance to the next opening balance.
- Back up the folder to a place you control.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


