A good statement import does five things: accepts the file formats your bank gives you, lets you review every row before it is saved, remembers which account each row came from, warns about duplicates, and lets you prove the totals match your statement. Test all five with one real month before you pay or commit.
The five checks
- Formats: does it take PDF, CSV and Excel? Your bank may only offer one.
- Review: can you see and fix every row before saving, or does it save blindly?
- Accounts: do you choose the bank, card or wallet before import, and does each transaction keep it?
- Duplicates: is an overlapping upload flagged?
- History: can you see what was imported, when, and whether it worked?
Why the review step matters most
Statements are messy: wrapped descriptions, split columns, a debit and a credit in different places. No parser is perfect, and any app that claims every layout will work is overselling. What protects you is a review screen where a wrong date or amount can be fixed before it enters your records.
Look at three kinds of rows in particular: refunds, which should show as money in and not a negative expense; reversals, which appear as a debit and a matching credit; and wrapped descriptions, where one transaction can spill onto two lines in a PDF. A tool that handles these properly saves you hours; one that mishandles them quietly inflates your spending.
Also check the dates on the first and last rows of the file. If the statement period runs 1 to 30 April but the first imported row is the 4th, something was skipped at the top.
A worked test: the closing-balance proof
Run this on your trial month. The figures below are hypothetical.
| Step | Figure |
|---|---|
| Opening balance | ₹42,000 |
| Total credits on the statement | ₹80,000 |
| Total debits on the statement | ₹71,500 |
| Opening plus credits minus debits | ₹50,500 |
| Closing balance on the statement | ₹50,500 |
Check: 42,000 + 80,000 - 71,500 = 50,500. Equal numbers mean the app captured everything. If the app's imported total is, say, ₹68,000 in debits, then ₹3,500 is missing, and you know to look for two or three skipped rows before trusting any report.
What happens when two statements overlap?
People often download 1 to 31 March and later 15 March to 15 April. The overlap, 15 to 31 March, would double-count about two weeks of spending. In SpendixAI, possible duplicate imports are flagged, and there is a Possible duplicate charges report listing the same amount to the same merchant within two days, which also catches a genuine double charge by a merchant. Flags are prompts to look, not verdicts.
What should you expect when an import fails?
- A clear status, not silence. The app shows import history with status and sends an Import failed notification.
- A way to retry with another format.
- No half-saved data: failed files should not leave partial rows behind. Test this with a deliberately wrong file.
Think about the bigger picture too. A monthly routine is easier to keep if the import takes minutes. Time a real run: download, pick the account, upload, review, save. If it takes longer than a coffee break for one account, find out which step is slow before you add a second account to the habit.
A closing checklist
- Upload one month for one account and run the balance proof.
- Upload the same file again and see whether it is flagged.
- Upload a second account and check each row keeps its account.
- Export the result as CSV and open it in a sheet.
- Check that you never needed to type a net-banking login.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

