Cards and UPI

Spending higher than income? Find the double-counted card payments

When your category totals add up to more than you earned, a card payment counted as spending is often the reason. Follow these steps to find it in minutes.

Editorial illustration for Spending higher than income? Find the double-counted card payments

If your category totals come to more than you earned and your bank balance has not collapsed, suspect double counting. The fastest way to find it is to work from the size of the gap: compare the excess with the amounts of your card payments. When they match, the payments are counted as both expense and card spend.

What is the symptom?

Say income for the month was A$6,200 and the report shows A$9,640 of spending, yet the account balance is roughly where it began. The report claims a gap of A$3,440 (9,640 - 6,200) that did not happen.

How do you hunt for the cause?

  1. Work out the excess: report spending minus income, A$3,440 in this example.
  2. List every card payment for the month. Say there were two, A$2,150 and A$1,290.
  3. Add them: 2,150 + 1,290 = A$3,440. That is the same as the excess.
  4. Label both payments as transfers and exclude them from spending.
  5. Re-run the report and confirm that it now falls close to the real spending.

When the numbers match this neatly, you are done. When they do not, the cause may be something else, and the next section covers the common ones.

What else looks like double counting?

  • The same statement imported twice.
  • A refund recorded as a purchase.
  • A purchase entered by hand and also in the statement.
  • A transfer to savings counted as spending.
  • Two accounts that both list the same shared bill.

How do you prevent it next time?

Decide on a rule: card payments and transfers never count as spending. Write it at the top of your sheet. When you load a new month, filter by account and check the payment lines first, before you look at categories. It takes two minutes and saves the hunt.

What helps in an app?

Having the account stored with every transaction, so you can see which side of a payment you are looking at. SpendixAI is built around India and INR, so it is not aimed at Australian accounts, but it does keep each transaction with the account it was imported into. Whatever you use, the checks above work the same way.

What if your totals still look high?

If tagging the payments does not close the gap, sort the month's transactions by amount and read the top ten lines. Large lines you do not recognise deserve attention, and so do pairs of equal amounts on different dates. A tenant's deposit, a savings transfer and a one-off annual bill are all legitimate large lines but can look like errors. Mark each as understood or investigate it. Work through the list until the largest item is something you can explain.

  • Check for lines that appear twice.
  • Check for transfers to your own savings.
  • Check for annual bills and one-off purchases.
  • Check for amounts imported in the wrong sign, which show as spending when they were income.

Keep the working. Write down the excess, the payments you found and the date you fixed them, in a note at the bottom of the sheet. If the numbers drift again in a few months, you can see what you did last time. It also helps if someone else, such as a partner, uses the same sheet and needs to understand why those payments are tagged as transfers.

A short checklist

  • Excess compared with card payment amounts.
  • Transfers labelled and excluded.
  • No statement imported twice.
  • Refunds recorded against the original category.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports