Why is a bank statement not an expense list?
A bank statement records movements of money in and out of one account. It does not know why. A ₹25,000 debit could be rent, a transfer to your wife's account, a deposit or a payment to a friend. A ₹10,000 debit could be an SIP, which is saving, or a bill.
An expense list answers a different question: what did we spend, and on what? To get from one to the other, you sort rows into types before adding anything.
What types of rows will I find?
| Row type | Example on the statement | Counts as spending? |
|---|---|---|
| Spending | UPI to a grocery shop, electricity bill, rent, cash withdrawal | Yes (cash is spending of unknown kind) |
| Card bill payment | Credit card payment to a bank | No. The purchases on the card are the spending |
| Investment | SIP debit, FD opening, PPF deposit | No. Money moved to an asset |
| Own transfer | To your savings account or a spouse's account | No. Money moved between your accounts |
| Loan repayment | EMI | Treated separately: principal reduces debt, interest is a cost |
| Refund or reversal | Credit from an online order | Reduces the original spending |
| Income | Salary, interest, rent received | Not spending at all |
| Bank charge | SMS charge, annual fee | Yes, a small cost |
The two most common traps are the card bill and the own transfer. Both are large, both look like spending, and counting them inflates the month.
How do I sort a real month? A worked example
Say Aditi's salary account shows these rows for October. Opening balance ₹42,000.
| Date | Description | Debit (₹) | Credit (₹) |
|---|---|---|---|
| 1 Oct | Salary | 90,000 | |
| 2 Oct | Rent via UPI | 25,000 | |
| 3 Oct | Credit card bill payment | 18,400 | |
| 5 Oct | SIP | 10,000 | |
| 6 Oct | Transfer to own savings account | 15,000 | |
| 8 Oct | Food delivery | 640 | |
| 10 Oct | Grocery via UPI | 2,350 | |
| 12 Oct | Online order refund | 1,299 | |
| 15 Oct | Electricity bill | 1,780 | |
| 20 Oct | ATM cash withdrawal | 3,000 |
Check the balance: ₹42,000 + (₹90,000 + ₹1,299) - ₹76,170 = ₹57,129.
Total debits = 25,000 + 18,400 + 10,000 + 15,000 + 640 + 2,350 + 1,780 + 3,000 = ₹76,170.
Now sort the debits:
| Type | Rows | Amount (₹) |
|---|---|---|
| Spending paid from this account | Rent, food delivery, grocery, electricity, cash | 32,770 |
| Card bill payment | Settles card purchases, which are counted from the card statement | 18,400 |
| Investment | SIP | 10,000 |
| Own transfer | To own savings | 15,000 |
| Total debits | 76,170 |
Check: 25,000 + 640 + 2,350 + 1,780 + 3,000 = 32,770. And 32,770 + 18,400 + 10,000 + 15,000 = 76,170.
The refund of ₹1,299 is a credit. If the original purchase was on the card, it reduces that card's spending, not this account's. If it was paid from this account earlier, it reduces the spending in that month's shopping line. Either way it is not income.
So the number that looks like "we spent ₹76,170" is really ₹32,770 of direct spending, plus ₹18,400 of card purchases still to be itemised from the card statement, plus ₹25,000 that moved into savings and investments.
How do I avoid counting the card twice?
This is the most common mistake in expense lists. If you count each card purchase and also count the card bill payment from the bank account, the same ₹18,400 appears twice.
The rule: pick one side. Either record spending from the card statement and treat the bank payment as a settlement, or treat the bank payment as the spending and skip the card purchase detail. The first method gives categories, the second gives only a total. Most people choose the first.
The same applies to wallet top-ups. Loading ₹2,000 into a wallet is a transfer. The spending is what you pay from the wallet.
What about category suggestions and duplicates?
Statements show descriptions like "UPI/DR/302145/ABC STORES". It is hard to know from the text whether that is groceries or a gift. Sensible tools suggest a category from the merchant name and let you correct it. Two cautions:
- Suggestions are guesses. Check the larger amounts and anything marked "miscellaneous".
- If you import a statement every month, and the periods overlap by a few days, the same row can come in twice. Match on date, amount and description before saving.
Cash is a special case. A ₹3,000 ATM withdrawal is a row on the statement, but where the cash went is invisible. Many people record it as one line, "cash", and note where it went if it was large.
What do PDFs add to the problem?
PDF statements are made for printing, not for reading by a machine. Typical issues:
- A password. Banks usually protect the file, and the bank tells you how the password is formed.
- Multi-line descriptions that break a row across lines.
- Running balances in the same table as debits and credits.
- Statements that cover different periods than the calendar month.
An Excel or CSV statement avoids most of these if your bank offers one. If you only have a PDF, check the draft against the opening balance, the closing balance and the totals the bank prints. If the numbers do not tie, a row was missed or misread.
What do people miss?
- Opening and closing balance. Always tie the list back to them. It is the quickest check that nothing was lost.
- Bank charges and interest. Small but real, and often skipped.
- Wrong statement owner. A joint account row may belong to someone else's spending.
- Reversed and failed transactions. A debit followed by a credit of the same amount is not spending.
- Treating EMI as one thing. Part of an EMI reduces the loan, and part is interest. Your lender's schedule shows the split.
- Keeping the PDF forever. The file carries your account number and every transaction. Keep it only as long as you need to.
How do I check my list against the statement?
Three tie-outs catch almost every error.
- Balance tie-out. Opening balance + total credits - total debits = closing balance. In the worked example, ₹42,000 + ₹91,299 - ₹76,170 = ₹57,129. If your list does not reproduce the closing balance, a row is missing or counted twice.
- Type tie-out. The amounts by type must add back to total debits. In the example, ₹32,770 + ₹18,400 + ₹10,000 + ₹15,000 = ₹76,170.
- Large-row check. Look at the five largest rows and make sure each is in the right type. A single mislabelled ₹25,000 rent row changes the month more than fifty small grocery rows.
When you have more than one account, do the same for each and then check that every own-account transfer appears once as a debit in one account and once as a credit in the other. If it appears only on one side, the other account's statement is missing or outside the period.
What to check for your own situation
- Is every debit labelled spending, card bill, investment, transfer or loan?
- Do opening balance, credits and debits tie to the closing balance?
- Are card purchases counted once?
- Are refunds netted against the original spending?
- Is there a plan for cash withdrawals?
How this looks in Kubear
Kubear has no bank linking and does not read SMS. You upload a bank statement, Kubear reads it into a draft list of transactions, and you review it, change categories and untick rows before anything is saved. Nothing is added without your confirmation. The uploaded file is discarded after reading.
This is general education, not personal financial, tax or insurance advice.