A useful dashboard for several accounts and cards counts only your own money. That means halving joint accounts, setting aside money you are holding for someone else, and treating every card balance as a debt even if it will be paid automatically. Do that, and the euro figure you end up with is one you can trust.
Whose money is it really?
A balance on the screen is not always yours. A joint account holds two people's money. A current account may hold a flatmate's share of a bill you are about to pay, or a deposit you will pass on. If you count all of that as yours, your net figure is flattering and wrong. Ask of every line: how much of this is mine to spend or save?
How do you adjust each type?
- Joint account: count your agreed share, not the full balance.
- Money held for others: subtract it from the balance and write the reason in a note.
- Credit cards: count the amount you owe today, not the next payment.
- Savings with notice periods: count them, but mark them as slower to reach.
A worked example with made-up numbers
Say these are the balances on one day.
| Account | Shown | Counted as yours | Reason |
|---|---|---|---|
| Own current account | €2,100 | €1,700 | €400 is a flatmate's share of a bill |
| Joint account | €3,000 | €1,500 | your half |
| Savings | €6,000 | €6,000 | all yours |
| Credit card | €540 owed | -€540 | a debt |
Add what you own: €1,700 plus €1,500 plus €6,000 is €9,200. Subtract the card: €9,200 minus €540 is €8,660. If you had used the raw balances, you would have shown €2,100 plus €3,000 plus €6,000, which is €11,100, then subtracted the card to get €10,560. That is €1,900 more than the truth.
What if you hold accounts in more than one currency?
Many people in Europe have a second account in another currency. Record the balance in that currency, write the rate you used to convert it and the date, and show the converted amount in your main currency. A rate you made up on the day is fine as long as you write it down, because it lets you reproduce the figure later.
What should you do when the numbers disagree?
If your sheet says one thing and the app says another, do not average them. Check the date on each, look for a pending payment that has not settled, and check whether a transfer between your own accounts has left one account but not yet reached the other. In that case the money is in transit and counts once, in whichever account it lands. Write the explanation in the note column so you do not solve the same puzzle next month.
How do you keep the dashboard honest?
- Update balances on a fixed day each month.
- Write the date next to each balance.
- Check any joint account by asking the other holder, not by guessing.
- Compare the sum of balances with last month and write one line about what changed.
- Review the list twice a year for accounts you can close or merge.
Where does a tool help?
When the sheet gets long, an accounts view that lists every account with its activity saves effort. SpendixAI offers that view for users in India. The general lesson applies anywhere: each transaction should stay attached to the account it came from, so you can see what happened in one account without sifting through the rest.
A quick audit
- Is every account on the list?
- Is every joint account halved?
- Is every card a negative?
- Is any money held for someone else excluded?
- Is the date on each row recent?
Useful ideas start with a clearer picture of your own spending.
Explore your reports

