A month that looks suspiciously quiet in your tracker is usually a statement you never imported, not a month you never spent. The fix is a coverage grid: one row per month, one column per account, and a mark in every cell you have actually loaded.
Why do months go missing?
Gaps come from habit, not from software. You download statements in a rush, you forget the savings account, a card gets replaced and the new one starts a fresh statement series, or you export a rolling 'last 30 days' that leaves a hole between two downloads. None of these produces an error message, so the books simply look lighter than reality.
Build the coverage grid
Make a small table on paper or in a sheet. List the last twelve months down the side and each account across the top. Fill a cell only when you have imported the statement and checked its first and last dates.
| Month | Checking | Savings | Credit card |
|---|---|---|---|
| January | Loaded | Loaded | Loaded |
| February | Loaded | Loaded | Loaded |
| March | Loaded | Missing | Loaded |
| April | Loaded | Loaded | Missing |
| May | Loaded | Loaded | Loaded |
Two blanks appear immediately. Without the grid you would only notice them when a report looked odd.
A quick way to confirm a gap with numbers
Say your tracker shows grocery spending of $412 in April, $0 in May and $395 in June. Nobody stops eating for a month, so May is suspect. Open the checking account's transaction list, filter to May, and count rows. If it holds a handful of items instead of dozens, the statement for May was either never imported or only partly imported.
A second check uses the account's own balance. Say the statement for April closes at $2,140.00 and the next statement you loaded opens at $1,615.30. Those figures should be identical. Any difference of $524.70 means at least one statement, or part of one, sits between them and has not been loaded.
What should I do once I find a hole?
- Note the account and the exact dates that are missing.
- Download the statement for that period from your bank. Pick the same layout you used before so rows import the same way.
- Before importing, check that the file's first and last dates cover the gap without a wide overlap.
- Import it, then confirm the opening balance of the new file matches the closing balance of the one before.
- Mark the cell in your grid and write the date you did it.
How do I stop it happening again?
- Pick one fixed day each month, say the third, and import every account then.
- Keep a short list of accounts, including old cards and a savings account that rarely moves.
- When you close or replace a card, note the date of its last statement in the grid.
- Check the report totals against a figure you know, such as rent or a salary credit, before relying on them.
Will the missing month affect my reports?
Yes, in a quiet way. Averages drop, budgets look healthier than they are and year-to-date totals read low. If you are about to use the numbers for anything that matters, such as a loan form or a conversation with an accountant, fill the gaps first. For anything involving tax, ask your own accountant what records they need rather than relying on a tracker alone.
Your next ten minutes
Open last year's list of accounts, draw the grid, and mark what you have. A first pass takes about ten minutes, and the blanks tell you exactly which statements to fetch.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
