Before you divide anything, strip out money that only moved between your own accounts, such as credit card repayments and transfers to savings. Those are not spending, and leaving them in can almost double your daily average. The remaining figure, divided by the days in the period, is the one to trust.
The double-counting trap
Say you use a credit card for most purchases and an everyday account for the rest. Each purchase appears once on the card statement. When you pay the card off, the repayment appears as a large debit on the everyday account. If you add up every debit from both accounts, you count the same dollars twice: once as the individual purchases and once as the repayment.
A worked month
Hypothetical numbers for a 30-day month. Card purchases totalled A$1,860. You repaid the card in full from your everyday account. You moved A$500 into savings. Rent was A$1,600. You also spent A$540 directly from the everyday account on small items.
| Everyday account debit | Amount | Is it spending? |
|---|---|---|
| Credit card repayment | A$1,860 | No, those purchases are already on the card |
| Transfer to savings | A$500 | No, it is your own money moving |
| Rent | A$1,600 | Yes, but a fixed cost |
| Direct purchases | A$540 | Yes |
Naive method: add every debit, A$1,860 + A$500 + A$1,600 + A$540 = A$4,500, and divide by 30. That gives A$150 a day, which is wrong.
Correct method for everyday spending: card purchases A$1,860 plus direct purchases A$540 = A$2,400, divided by 30 = A$80 a day, with rent of A$1,600 handled as a fixed cost on the side.
How do I tag transfers so they stay out?
Add a Type column to your sheet with values such as Spend, Transfer, Fixed and Income. Mark card repayments, savings moves and transfers between your own accounts as Transfer. Using Excel or Google Sheets, with dates in column A, amounts in column C and the type in column D, the everyday total is:
=SUMIFS($C$2:$C$400,$D$2:$D$400,"Spend")
and the daily average over 30 days is that cell divided by 30. Selecting only the type you want is safer than listing everything to exclude, because a new type you invent later cannot sneak in.
What about cash withdrawals?
Pick one rule and keep it. Either count the withdrawal as spending on the day you take the cash out, which is simple but lumpy, or log the cash purchases as you make them and leave the withdrawal itself out. Counting both is the same double-counting mistake in a different place.
Should I divide by 30 or by days elapsed?
For a finished month, divide by the real number of days in it. For a month still running, divide by days so far. Mid-month, A$1,100 of everyday spending over 14 days is A$78.57 a day (1,100 / 14 = 78.571), not A$36.67, which is what you would get dividing by 30.
What if two of us share the accounts?
Then every transfer between your accounts and your partner's is another place for double counting. Decide whose list a shared expense belongs to, record it once, and mark the payment you make to your partner for their half as a Transfer. Run the same check each month: do the Spend rows add up to the sum of what actually left your accounts for goods and services, once the transfers are taken away?
Keep it honest with a short routine
- Download or copy the statement lines for every account, including the card.
- Tag transfers and repayments first, before looking at anything else.
- Total the Spend rows and divide by the correct number of days.
- Compare the result with last month's figure and note the date.
- If the number jumps, sort the Spend rows from largest to smallest and look at the top five.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


