Cards and UPI

Use your regular bills to catch a missing month in your records (AU)

Rent, phone and subscriptions repeat monthly, so a month without them signals missing data. A worked A$ example shows how to find and fill the gap.

Editorial illustration for Use your regular bills to catch a missing month in your records (AU)

Your recurring bills are the best detectors of a missing month. Rent, a phone plan and a streaming subscription appear every month without fail, so a month where they are absent almost certainly means a statement was never imported.

Pick three or four tripwires

Choose payments that should appear once each month, at a similar amount. Good candidates are rent or a mortgage repayment, a phone or internet bill, a gym membership and one streaming subscription. Search for each by name in your tracker and note the months in which it shows.

BillJanFebMarAprMay
Rent A$2,200.00YesYesNoYesYes
Phone A$65.00YesYesNoYesYes
Gym A$39.00YesYesNoYesYes
Streaming A$16.99YesYesNoYesYes

When all four vanish in the same month, as in March here, the cause is not four cancellations. It is one missing statement.

Put a figure on what is missing

The four bills above add up to 2,200.00 + 65.00 + 39.00 + 16.99 = A$2,320.99. That is the least that should be sitting in March, before any shopping, fuel or eating out. If your March total for all spending is under A$2,320.99, you have proof the month is incomplete.

What if only one bill is missing?

  • It may have been cancelled or moved to another card. Check where it is now billed.
  • The payment may have gone from an account you have not imported, such as a second card or a partner's account.
  • The merchant may have changed the name on the statement. Search with part of the name.
  • The charge may have landed on the first of the next month, so look at the dates either side.

Where should I look for the old statement?

Start with the account that paid the bill. Banks offer different periods of online history, so check how far back yours goes; if the month is older than that, ask your bank how to obtain a copy. If the account has been closed, look for final statements in your email or files from the time of closing.

A repair checklist

  1. List the months where tripwire bills are absent.
  2. Name the account most likely to have paid them.
  3. Obtain the statement for those dates and check the first and last day.
  4. Import it, reviewing rows before saving to avoid repeats.
  5. Search for the tripwire bills again to confirm they now show up.

You can also use your income as a tripwire. A regular pay credit should appear in every month, so a month with no salary and no rent is almost certainly empty of data rather than empty of life. If your pay is irregular, look instead for the smallest recurring item you have, such as a phone plan.

For couples and households, remember that the missing month may be sitting in the other person's account. If rent leaves a joint account but groceries leave a personal card, you will need both sets of statements before a month looks whole. Agree who downloads which one and when, and add the answer to your coverage list.

Keep the tripwires going

Once a quarter, search for your tripwire bills in the last three months. It takes a minute and finds gaps long before a report goes wrong. If you use your records to apply for credit or to talk to an accountant, ask them what period they need and fill every gap in that range first.

SPENDIXAI JOURNAL

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

Explore your reports