To get a Paytm Payments Bank statement as a CSV, first check which download formats your own statement screen offers; if only PDF is offered, you can convert it carefully or upload the PDF straight to a tracker. we cannot describe the app's menus, since they change, so use this as a method: get the file, clean the columns, then prove the totals.
Step 1: see what formats you can get
Open the statement section in your own account and look for a date range and a format choice. Some statement screens list PDF only, others add a spreadsheet or CSV option. Which you get depends on your account and the version of the app, so look rather than assume. Choose a month at a time, as shorter ranges are easier to check.
Name each file clearly when you save it, for example the account name and the month. Six months from now, 'statement (3)' will tell you nothing, and you will be reluctant to open each file to find the right one.
Step 2: if you only get a PDF
You have three sane options. First, upload the PDF into a tracker that reads PDFs and review the rows. Second, copy the table into a spreadsheet and fix the columns by hand. Third, ask for a different format from the bank's own support. Avoid unknown websites that promise PDF to CSV conversion: a statement contains your account details, so keep it on your own device.
Step 3: make the columns usable
A good CSV has one row per transaction and separate columns. If everything is jammed into one column, in Excel use Data, then Text to Columns, and split by comma. Aim for these headings:
Watch out for amounts that were saved as text. If a total shows zero, select the amount column and look at the alignment: text sits to the left. Converting with =VALUE(D2) in a helper column, or using Paste Special with multiply by 1, fixes it.
- Date, in one consistent format.
- Description, the narration text.
- Debit and Credit, or a single Amount column with a sign.
- Balance, if the statement includes it.
If dates look like text, convert them: in a helper column, =DATEVALUE(A2) works in Excel and Google Sheets when the text is in a date format your locale understands. Check a few rows by eye, especially days under 13, where day and month can swap.
Step 4: prove the totals
Before you analyse anything, compare the sheet to the statement. Suppose the statement summary shows total debits of ₹28,640 and total credits of ₹35,000, with 37 transactions.
| Check | Statement | Your sheet | Formula to use |
|---|---|---|---|
| Debits (₹) | 28,640 | 28,640 | =SUM(D2:D200) |
| Credits (₹) | 35,000 | 35,000 | =SUM(E2:E200) |
| Rows | 37 | 37 | =COUNTA(B2:B200) |
These assume Debit is in column D, Credit in E and Description in B; adjust to your layout. If a total is off, look for rows where a comma inside the narration pushed the amounts into the wrong column.
Can I skip the CSV step?
Often. SpendixAI accepts bank and card statements as PDF, CSV or Excel, so you can upload the file you have and review the rows before they are saved. Choose the account first so each transaction stays with it. The import history shows a status, and an Import failed notification appears if something goes wrong. It does not promise every layout will read perfectly, so check row counts and totals against the statement, as above.
Checklist
- Download one month in the best format on offer.
- Open it, make columns clean, and format dates.
- Compare totals and row count to the statement.
- Import or analyse only after the numbers match.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

