Download the statement in the most structured format your account offers, then reshape it into one dated amount column and prove it with a balance check: opening balance plus deposits minus withdrawals must equal closing balance. If the check passes, no row is lost or doubled. Layouts and menu names change, so look at your own statement and net-banking or app options rather than relying on a description of them.
What does a savings account statement usually contain?
Most savings statements have a date, a narration, a reference or cheque number, a withdrawal column, a deposit column and a running balance. The narration for UPI payments is often a long string with a handle and a reference. That string is useful, because it holds the merchant or person name, but it is also what makes columns misalign when a PDF is converted.
How do you reshape it?
- Open the file and delete everything above the header row: logos, address blocks, summary boxes.
- Delete footer rows such as page totals and disclaimers.
- Make sure dates are real dates and amounts are real numbers, not text.
- Merge withdrawal and deposit into one Amount column, with withdrawals negative.
- Keep the running balance column for the check below.
In a spreadsheet, if Withdrawal is in column D and Deposit in column E, the merged amount in F2 can be =N(E2)-N(D2). The N function turns blank cells into zero, so empty withdrawal or deposit cells do not produce errors. Copy it down the column.
How does the balance check work?
Take invented figures. Opening balance ₹18,400. In the month, deposits total ₹52,000 and withdrawals total ₹47,350. Expected closing is 18,400 plus 52,000 minus 47,350, which is ₹23,050. If your sheet's total of the Amount column is ₹4,650 and the statement's closing balance is ₹23,050, then 18,400 plus 4,650 matches, and the file is complete.
| Item | Made-up figure |
|---|---|
| Opening balance | ₹18,400 |
| Total deposits | ₹52,000 |
| Total withdrawals | ₹47,350 |
| Net change | ₹4,650 |
| Expected closing | ₹23,050 |
If the numbers disagree, compare row counts, then look for rows where a conversion merged two lines into one narration.
Do you need to convert at all?
Not always. SpendixAI accepts bank statements uploaded as PDF, CSV or Excel, and you review the rows before saving. Pick the account before importing so every transaction keeps it. It flags possible duplicate imports and shows import status in the history, but do not assume every layout parses perfectly; check the rows against your balance, as above.
Common problems
- Date format flips between day-first and month-first after opening the file.
- Amounts with commas become text and refuse to sum.
- A multi-page PDF repeats the header row on each page, giving fake rows.
- Reference numbers lose digits when a spreadsheet shows them in scientific form. Format that column as text before pasting.
How do you work out the monthly picture afterwards?
With the merged Amount column in place, a pivot table or SUMIFS formula turns it into category totals. For example, if column G holds your category and F the amount, =SUMIFS($F$2:$F$500,$G$2:$G$500,"Groceries") returns the total for that category, with withdrawals negative. Use a second formula for each category and check that they add up to the net change you proved earlier.
If the category totals do not sum to the net change, some rows have no category. Filter for blanks in column G and fill them in. That reconciliation step is what separates a spreadsheet you can trust from one that merely looks tidy.
Wrap-up
Once one month balances, save your column layout as a template. Next month takes minutes, because the only thing that changes is the data.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


