If your tracker's balance differs from the bank's, subtract the two to get the gap, then look for entries that explain it: a missed cash withdrawal, a payment entered twice, or a payout dated on the wrong day. For gig workers the gap often comes from weekly platform payouts and cash tips, so check those first.
Do this once a week, not once a quarter. A gap of ₹1,650 is findable in ten minutes; a gap of ₹20,000 after three months is a weekend.
What is the starting point?
Pick one date on which you know the bank's balance, preferably the last day on a statement. Everything after that date is what you compare. If the tracker's opening balance was wrong, every later total is off by the same amount, which you can spot because the gap never changes.
Worked example: finding ₹1,650
Say the bank closes the week at ₹14,380 and your tracker says ₹16,030. The tracker is ₹1,650 too high.
| Step | What you find | Effect on tracker |
|---|---|---|
| Gap | 16,030 minus 14,380 | ₹1,650 too high |
| ATM withdrawal for petrol and food | Never entered | ₹2,000 too high |
| Fuel paid by UPI | Entered by hand and also imported | ₹350 too low |
| Result | 2,000 minus 350 | ₹1,650 gap explained |
A missing debit makes the tracker too high; a doubled debit makes it too low. So one entry nudged the tracker up by ₹2,000 and the other nudged it down by ₹350, and the two together equal the gap.
Why do gig accounts drift more?
- A weekly payout can be one credit for many trips, so your tracker may hold the trips and the payout both.
- Tips in cash never reach the bank, so they should not be in the bank account at all.
- A reversed or held payout shows up as a credit and then a debit.
- You may own two accounts, one for payouts and one for spending, and move money between them.
How do I stop double counting a payout?
Decide what the tracker is for. If it is the bank balance, enter only the payout credit. If it is your earnings by trip, record trips under a separate income category and keep the bank payout as a transfer you tick off. Not both as income.
How does an expense tracker help here?
In SpendixAI every transaction keeps the account you picked, import history shows what has been uploaded, and possible duplicates are flagged when the same rows go in twice. That catches the doubled entry above. A single-purpose cash account, with expenses added by hand, keeps the ATM money from disappearing.
What if the gap is the same every week?
A constant gap means the opening balance is wrong, not a transaction. If your tracker is always ₹2,100 above the bank, then something that happened before you began tracking is missing. Fix the opening balance once: set it to what the bank said on your first tracked date, and the gap should vanish from that date on.
A gap that grows each week points to a repeat habit, for example a fee that is deducted by the platform and never imported, or a recurring auto-debit that you forgot to enter. Look at the same lines in each week's statement and see which one is missing from your tracker.
Your ten-minute Sunday routine
- Open the bank app or statement and note the closing balance.
- Note the tracker's balance for the same date.
- Work out the gap and its sign: too high means a missing debit or extra credit.
- Scan debits for withdrawals, UPI and platform fees that are not recorded.
- Scan for entries that appear twice with the same amount and date.
- When the gap is zero, write the date you reconciled.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
