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.
| Bill | Jan | Feb | Mar | Apr | May |
|---|---|---|---|---|---|
| Rent A$2,200.00 | Yes | Yes | No | Yes | Yes |
| Phone A$65.00 | Yes | Yes | No | Yes | Yes |
| Gym A$39.00 | Yes | Yes | No | Yes | Yes |
| Streaming A$16.99 | Yes | Yes | No | Yes | Yes |
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
- List the months where tripwire bills are absent.
- Name the account most likely to have paid them.
- Obtain the statement for those dates and check the first and last day.
- Import it, reviewing rows before saving to avoid repeats.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
