Start by checking which download formats your own statement page offers; many banks provide PDF only, some also give CSV or Excel. If a CSV is on offer, download it and clean the dates, amounts and narration. If you only have a PDF, upload it to a tool that reads PDFs rather than forcing a conversion. Either way, prove the totals against the closing balance.
Which format should you download?
Look at the statement download options for your account and pick CSV or Excel if they exist, because there is no guesswork in reading them. This article does not describe any bank's menus, since layouts change; check your own screen. If you see only PDF, skip to the section on PDFs below.
How do you clean a CSV?
- Open it in Excel or Google Sheets. If dates look like text, such as 05/10/2026 left-aligned, convert them with Data, Text to Columns, choosing the date format that matches your file.
- Check whether debits and credits are in one column with signs or in two columns. A tracker prefers one of these consistently.
- Look for commas inside the narration. If columns have shifted, the file was not quoted properly; reimport using the Text import option.
- Remove any header, footer or summary lines so only transactions remain.
- Format the amount column as numbers, and strip any stray text such as 'Cr' or 'Dr' into its own column.
A worked example: prove the file is complete
Say the statement shows an opening balance of ₹48,200 and your CSV has these four rows:
| Date | Narration | Debit | Credit |
|---|---|---|---|
| 02/10 | Card purchase, groceries | ₹2,350 | - |
| 05/10 | Salary credit | - | ₹60,000 |
| 11/10 | Utility payment | ₹1,180 | - |
| Totals | - | ₹3,530 | ₹60,000 |
Opening ₹48,200 minus ₹3,530 plus ₹60,000 gives ₹104,670. If the closing balance printed on your statement is ₹104,670, your file is complete. In Excel the check is one line: =Opening-SUM(C2:C4)+SUM(D2:D4), with the opening balance in a cell of its own. If the two figures differ, a row is missing or a number has turned into text.
What if you only have a PDF?
Converting a PDF to CSV by copy and paste usually scrambles columns, especially where narrations wrap on to a second line. A tool designed for statements is steadier. SpendixAI accepts a bank statement as PDF, CSV or Excel, asks you to choose the account first and shows the rows for review before they are saved. we cannot promise that every layout will parse perfectly, which is why the review step exists. Protected PDFs need the password you set or were given by the bank; never type it into an unfamiliar site.
Why do some rows split into two lines?
Long narrations sometimes wrap in a PDF, which makes one transaction look like two rows when copied out. A tell-tale sign is a row with text but no date and no amount. In a spreadsheet, filter the date column for blanks, then move the leftover text into the previous row's narration, or merge them with =B2&" "&B3. Delete the empty line afterwards. Do this before you add up anything, otherwise totals and counts will be wrong.
What should you do after the import?
- Label rows with categories, starting with the largest and most frequent merchants.
- Mark transfers between your own accounts so they are not counted as spending.
- Check for the same row appearing twice if two periods overlapped.
- Compare the month's total with the closing balance once more.
If a statement will not open or the totals refuse to match, contact your bank through its official channel for a fresh copy instead of editing figures by hand.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

