When an expense report shows more spending than your bank statement debits, the most common cause is that a credit card bill has been counted twice: once as individual card purchases and again as a single payment from your salary account. Mark that payment as a transfer, not spending, and the totals usually come close.
The remaining gaps are almost always refunds, dates at the edge of the month, or a transaction imported twice.
Why does a salaried person see this so often?
A salary account and a credit card are two sets of records for the same money. Your card statement lists every purchase. Your bank statement lists one debit when you pay that card. If both statements are imported and both are treated as spending, your report counts the same rupees twice.
A worked reconciliation with made-up numbers
Say your salary is ₹85,000. Directly from the bank you pay rent ₹22,000, a loan instalment ₹9,500 and utilities ₹3,100, and you pay the card bill of ₹32,400 once. The card itself shows groceries ₹11,200, dining ₹8,400, fuel ₹6,300 and shopping ₹6,500.
| Source | Items | Amount in ₹ |
|---|---|---|
| Bank debits | Rent, loan, utilities | 34,600 |
| Bank debit | Card bill payment | 32,400 |
| Card purchases | Groceries, dining, fuel, shopping | 32,400 |
| Report total if everything is spending | 34,600 + 32,400 + 32,400 | 99,400 |
| Report total with the card payment as a transfer | 34,600 + 32,400 | 67,000 |
The arithmetic: 22,000 + 9,500 + 3,100 = 34,600, and 11,200 + 8,400 + 6,300 + 6,500 = 32,400. Counting the card payment as well produces 99,400, which is more than your whole salary. That impossible figure is the tell.
What are the other common causes?
- Refunds or reversals shown as credits, which reduce spending in a report but do not appear as a debit.
- Dates at the edges: a card purchase on the 30th that posts on the 2nd.
- A statement imported twice, or two overlapping periods.
- Cash withdrawals counted as spending, and then the cash spending added by hand.
- A transfer to your own savings or investment account tagged as an expense.
How do you fix it without redoing everything?
- Tag card bill payments and own-account transfers as transfers.
- Look at the largest ten transactions for duplicates.
- Narrow the report to one account and the exact statement dates.
- Compare the card account's report total with the card statement.
SpendixAI imports each account separately and every transaction keeps its account, so you can compare the report to one statement at a time. It flags possible duplicate imports and has a possible duplicate charges report for the same amount to the same merchant within two days. Whether a payment is spending or a transfer is something you tag.
When the gap is small
A difference of a few rupees can be a rounding or a reversed fee. A gap of a few thousand is usually one big item in the wrong bucket. A gap equal to a whole bill is the double counting above.
A habit that helps salaried people is a monthly tie-out, done on the same day as the salary credit. Write three numbers on a sticky note: the opening balance, the closing balance and the total the report says you spent. If opening plus salary minus closing is close to the spending figure after removing transfers, you are done in two minutes. If it is not, you have found the month to examine, and you have not waited a year to notice.
Next time
- Import both the bank and the card for the same dates.
- Tag the card bill payment when you first see it.
- Reconcile once a month, not once a year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

