A single view of all your accounts and cards is a table with one row per account, showing its latest balance and whether it is something you own or owe. Subtract what you owe on cards and loans from what sits in accounts, and you have a net position you can update in ten minutes each month.
Which accounts belong on the list?
- Savings and current accounts, including the one platforms pay into.
- Wallets and prepaid balances that you actually keep money in.
- Cash you hold at home, if it is meaningful.
- Credit cards, with the outstanding amount, not the credit limit.
- Loans and EMIs, with the principal outstanding from the lender's statement.
- Money owed to you, only if you are sure it will be repaid, and shown separately.
A worked example with made-up numbers
Say a gig worker has two bank accounts, a wallet and cash, plus two credit cards:
| Item | Type | Amount in rupees |
|---|---|---|
| Savings account A | Own | 24,500 |
| Savings account B | Own | 6,300 |
| Wallet | Own | 1,200 |
| Cash in hand | Own | 2,000 |
| Credit card 1 outstanding | Owe | 14,800 |
| Credit card 2 outstanding | Owe | 3,250 |
What you own: 24,500 plus 6,300 plus 1,200 plus 2,000 is ₹34,000. What you owe: 14,800 plus 3,250 is ₹18,050. Net position: 34,000 minus 18,050, which is ₹15,950. Looking only at the savings accounts you would feel richer than you are; looking only at the card bills you would feel poorer.
How do you build it in a sheet?
Put Own or Owe in column B and amounts in column C, then use:
- Total owned: =SUMIFS($C$2:$C$30,$B$2:$B$30,"Own")
- Total owed: =SUMIFS($C$2:$C$30,$B$2:$B$30,"Owe")
- Net: the first minus the second
Add a column for the date of the figure, so you can see how old each balance is.
How often should you update it?
Monthly is enough for most people. For a gig worker whose payouts land in several accounts, a weekly check on the day after the big payout is more useful. Update from statements and the official app, not from memory. If a number is a week old, say so in the date column.
What should a good dashboard tool let you do?
- Add any kind of account: bank, card or wallet.
- Keep each transaction tied to the account it came from.
- Show activity by account over a date range.
- Import statements without asking for your net-banking login.
- Handle more than one currency if you need it.
- Export the data.
What mistakes make the net position wrong?
- Counting a card limit or an unbilled overdraft as money you have.
- Using an old balance for an account that gets daily UPI debits.
- Forgetting the account the platform pays into, because it is only a pass-through.
- Leaving out an EMI because it is auto-debited and feels invisible.
- Mixing currencies in one column without converting them at a consistent, noted rate.
None of these is hard to fix, but each can shift the total by thousands of rupees, so look for them first when the figure feels off.
What does SpendixAI cover?
In SpendixAI you choose the account before each import, bank, card or wallet, and each transaction keeps that account. You can look at activity by account and at overall spending on the dashboard. It does not read SMS or connect to banks, so it does not show live balances or a net worth figure; keep the net position in your sheet and use the app for the transactions behind it.
A first-time setup checklist
- List every account and card from your UPI apps and wallets.
- Download the latest statement for each.
- Enter balances and outstanding amounts with dates.
- Total owned and owed, then compute the net.
- Set a monthly reminder to repeat.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
