Why does the expense report total differ from the bank statement? That is the problem this answer tackles. Is something broken? Usually not. A bank statement lists every debit, including transfers and card bill payments, while a spending report counts only what you spent. The gap is normally your own transfers, a card bill counted twice or left out, refunds, or a missing account, and you can reconcile it line by line.
What is each document counting?
A bank statement is a list of money movements. A spending report is a list of purchases. Paying your credit card bill moves money out of the bank, but the purchases behind it were the spending. Moving money into a savings account is also a movement, not a spend. If both are counted as expenses, your report will look inflated.
What are the usual causes?
- Transfers between your own accounts treated as spending.
- Credit card bill payment counted as well as the card's own purchases.
- Refunds or reversals shown as income, or ignored.
- One account not imported for part of the period.
- Duplicate imports of overlapping statements.
- Date range mismatch: the statement covers the 1st to 30th, the report a different window.
- Fees and charges that sit on the statement but were never categorised.
How do you reconcile it, with numbers?
Say your savings account statement shows total debits of ₹1,00,000 for the month. You line them up.
| Debit on bank statement | Amount | Is it spending? |
|---|---|---|
| Credit card bill payment | ₹28,000 | No, the card purchases are the spending |
| Transfer to own savings | ₹15,000 | No |
| Rent | ₹18,000 | Yes |
| Groceries | ₹9,000 | Yes |
| Other bills and payments | ₹30,000 | Yes |
| Total debits | ₹1,00,000 | - |
Spending paid straight from this account is 18,000 + 9,000 + 30,000, which is ₹57,000. If the card statement is also imported and its purchases are ₹28,000, total spending is ₹85,000. If the card is not imported, the report shows ₹57,000, and the gap to the bank total is exactly 28,000 + 15,000, or ₹43,000. Every rupee is now explained.
What steps should you follow?
- Fix the date range so both documents cover the same days.
- List the bank debits and mark transfers and card bill payments.
- Check that every account and card is imported for the whole period. SpendixAI imports per account, so a missing statement shows up as a missing account.
- Look for duplicates. SpendixAI flags possible duplicate imports and has a report listing same-amount charges to the same merchant within two days.
- Re-add the totals after excluding transfers.
When should you worry?
If, after all this, a gap remains that no transfer, fee or refund explains, compare the bank's own running balance. A wrongly parsed amount in an import is possible, so review rows against the statement. Contact your bank only about transactions you do not recognise.
How do you stop it happening next month?
- Import every account for the same period on the same day.
- Create one category for transfers between your own accounts and one for card bill payments, so reports can leave them out.
- Review the list of recent imports and look for anything marked failed or duplicate.
- Compare one account's closing balance with the statement at month end, as a quick sanity test.
Once your transfers are labelled, the gap you saw this month turns into a habit-free check. The reconciliation becomes a two-minute glance and not an evening of detective work.
Quick checklist
- Same dates.
- Same accounts.
- Transfers separated.
- Card bill counted once.
- Duplicates removed.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


