How to Catch Up on a Year of Untracked Expenses
Pull twelve months of bank and card statements, import them in bulk instead of retyping each line, work backward one month at a time splitting business from personal and assigning categories, and treat anything with no paper trail — mostly cash — as a documented estimate rather than a guess, then build the weekly habit that keeps this from recurring.
untracked expenses bookkeeping backlog record keeping spreadsheet import freelancers
The honest starting point is that you cannot remember a year of transactions, and you shouldn't try to. What you have instead is a complete, dated, itemized list of nearly everything that happened — your bank and card statements — and the job is turning that list into categorized records, not reconstructing the year from scratch in your head.
Pull every statement before you categorize anything
Resist the urge to start fixing the oldest month first. Pull the full year of statements from every account that touched business spending, even an account you mostly use personally, before you touch a single category.
- Download twelve months of statementsEvery bank and card account that touched business spending, even occasionally
- Import them instead of retyping themA CSV or XLSX export turns hundreds of lines into one file
- Separate business from personal firstDecide which account's activity you actually need to categorize
- Start with the most recent monthYour memory of March is better than your memory of last November
Starting with the most recent month isn't just convenient — it's where reconstruction is most reliable. A transaction from six weeks ago still has a plausible story attached to it. One from thirteen months ago often doesn't, and no amount of staring at "SQ *COFFEE SHOP $6.40" is going to bring it back.
Import in bulk, review in a batch
Typing a year of transactions in by hand is the task that makes people give up halfway through February. Expensorr's spreadsheet import takes a CSV, XLSX, or XLS export from your bank, maps the columns to the right fields, and shows you a preview before anything is saved — so the work becomes reviewing an already-populated year rather than creating one line at a time.
This only replaces the typing, not the judgment. You still decide what each line actually was, which category it belongs in, and which wallet it should land in — the import just removes the part of the backlog that was pure data entry.
Go month by month, not transaction by transaction
A year is roughly 300 to 1,000 transactions depending on how you spend. Reviewing that as one undifferentiated pile is what makes the backlog feel impossible. Reviewing it as twelve small, identical decisions is what actually gets finished.
- Business vs. personal, line by lineThe one split that has to happen before anything else is useful
- Categories assigned from a short, existing listDon't invent new categories mid-reconstruction; use what you'd use going forward
- Recurring charges flagged as recurringSoftware subscriptions and retainers are the easiest wins — they repeat, so one correct guess fixes several months
- Anything with an unclear vendor name investigated onceA cryptic statement line is worth thirty seconds now, not a recurring guess every month
Recurring charges are worth finding early, specifically because they're repetitive: the same software subscription that showed up in March shows up in every other month too, so getting it right once and recognizing the pattern is faster than re-deciding it eleven more times.
What's good enough when the trail runs out
Not everything from a year ago left a clean trace. Cash is the usual gap, and the honest approach depends on how much of the year is actually recoverable.
Are the statements still available, and how much of the gap is cash?
The IRS's own guidance treats receipts, statements, and deposit records as different forms of the same evidence, not a hierarchy where only a receipt counts (IRS, What kind of records should I keep). HMRC's position for the self-employed is the same in practice: it expects receipts "where possible," alongside bank statements and other proof of business payments, for records you're required to keep for five years after the relevant tax year (GOV.UK, Business records if you're self-employed). Neither authority expects a statement-based reconstruction to be perfect. Both expect it to be honest about where it's an estimate rather than a confirmed figure.
Where this breaks down is if you treat "I'll estimate it" as the plan for the whole year instead of the exception for the parts you genuinely can't document. A year that's 90% statement-backed and 10% clearly labeled estimate is a defensible record. A year that's entirely guessed because it was easier than opening the statements isn't, and an accountant will tell you the same thing if you ask before filing rather than after.
What this does not solve
Reconstruction gets you categorized records; it doesn't get you back the receipts that would have shown an itemized breakdown, and it doesn't tell you which proportion of a mixed personal-and-business charge was genuinely deductible — that's a judgment call for your accountant, not something a statement line or an app can decide for you. Expensorr also has no connection to your bank: importing a statement is something you export and upload yourself, not something that happens automatically, which is exactly why the backlog built up in the first place and why the habit below matters more than the catch-up itself.
Build the habit so next year isn't this
A year-end reconstruction is the cost of not having a weekly one. How to track expenses from receipts covers the habit that replaces it: capture at the moment of purchase, review in a short weekly batch, and never let more than a few days of transactions pile up uncategorized. Once this year is caught up, that's the only thing standing between you and doing this again next October.
Where to start
How to track expenses from receipts has the ongoing capture habit this catch-up should lead into. What to do when you've lost your receipts covers the same reconstruction logic at the scale of a single transaction rather than a year. Separating business and personal money on one bank account is worth reading if the business-vs-personal split above was the hardest part. Expense categories that actually work will save you from inventing categories mid-reconstruction, and expense tracking for freelancers is the fuller system all of this feeds into.
Frequently asked questions
Where do I even start if I haven't tracked anything all year?
With your bank and card statements, not your memory. Download twelve months of statements for every account you used for business, even partly, before you try to categorize a single transaction. The statements are the complete list of what happened; your memory is a partial, unreliable summary of it.
Can I import a whole year of transactions instead of typing them in one at a time?
Yes. Export your bank and card statements as CSV or XLSX files and import them — Expensorr maps the columns and gives you a preview before anything is saved, so a year of transactions becomes one review pass instead of hundreds of manual entries.
What do I do about cash expenses I can't reconstruct?
Estimate conservatively, write down how you arrived at the number, and flag it as an estimate rather than presenting it as a confirmed figure. Both the IRS and HMRC allow a documented estimate for records that are genuinely gone — neither accepts a round number invented to look plausible.
Do I need a receipt for every transaction from a whole untracked year?
No. A bank or card statement line showing the vendor, date, and amount is accepted evidence for most ordinary business expenses. Receipts matter most for the categories that need more detail than a statement provides, and for anything an accountant later flags as worth double-checking.
How do I make sure I'm not back here again next year?
Replace the yearly scramble with a weekly one. A few minutes reviewing the past week's transactions is a habit; reconstructing twelve months from statements is a project. The second only exists because the first didn't happen.
Track expenses without the data entry
Every Expensorr feature is free, including unlimited wallets, budgets, labels, splits, and 75 currencies. The free plan includes 20 AI receipt scans or voice captures a month. Pro lifts that limit for $4.99 a month or $39.99 a year and changes nothing else.
