Your tracker and your bank balance differ because a purchase and its posting to the account are two separate events. You record the spend the day you pay; the bank or card may show it later, after authorisation and settlement. Mark such items as pending in your own records, clear them when they appear on the statement, and your month-end totals will reconcile.
What happens between buying and posting?
For a card payment there are usually three moments. First, the purchase: you tap, swipe or enter details. Second, authorisation: the bank approves the payment and may hold the amount. Third, settlement and posting: the merchant claims the money and it appears on your statement with a posting date. The gap between the first and third is not fixed, and it varies by merchant, bank and payment method, so check your own statements for how long it usually takes.
Some payments also show a hold that later changes. Fuel stations, hotels and car rentals may authorise one amount and settle another. If the posted amount is different from the amount you entered, trust the statement, and correct your record.
A worked example of a balance that does not match
Say a card statement downloaded today lists ₹12,400 of purchases. Your tracker, which you update on the day of each purchase, shows ₹16,700 on the same card. The numbers are hypothetical. The difference is 16,700 minus 12,400, which is ₹4,300.
| Purchase day | Amount | On the statement yet? |
|---|---|---|
| Monday | ₹850 | No, pending |
| Tuesday | ₹2,300 | No, pending |
| Wednesday | ₹1,150 | No, pending |
| Pending total | ₹4,300 | Explains the whole gap |
850 plus 2,300 plus 1,150 is 4,300, so the gap is fully explained. Nothing is wrong, and nothing is missing. If a gap is larger than your pending list, then something else is missing, and that is the time to look harder.
How do I mark a transaction as pending?
- In a spreadsheet, add a Status column with the values Pending and Cleared, and filter for Pending at month end.
- In an app, add a short note such as pending to the entry, or keep a small separate list of items you expect to appear.
- Always keep the date you paid as the transaction date, so your spending lands in the right month in your own view.
- Write the amount, the merchant and an approximate date, so you can match it on the statement.
How do I clear pending items?
- When the next statement or import arrives, match each pending item by amount and merchant.
- Mark each match as cleared, and use the posted amount if it differs.
- Do not add the matched item a second time. If your tracker shows a possible duplicate, review it before saving.
- Anything still pending after a reasonable time deserves a check with the merchant or the bank.
Month-end cut-offs
A purchase on the last day of the month may post in the next one. Decide which date rules your reports. For spending analysis, the day you paid is usually clearer. For reconciling to a statement, the posting date is. If you want both, keep the transaction date in your tracker and compare with the statement's period, expecting a handful of items to straddle the boundary.
A short monthly routine
- Download the statement after it has closed, not on the last day.
- List pending items from the final days of the month.
- Match, clear and correct amounts.
- Compare the statement total with your tracker total, allowing for the pending list.
- Note anything unexplained, and look into it before the next month starts.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
