A shoebox of receipt photos, three bank CSV exports with different column names, a Venmo PDF, and a Slack message that says can you make this tax-ready?” are not a category system. They are how “maybe deductible” lines hide until someone asks why the year-end folder still looks like a junk drawer.
Here is the workflow I use when someone dumps messy expenses on me and wants one clean tax-ready category sheet: every spend in a period labeled, sourced, and easy to hand to their bookkeeper or tax preparer — without me pretending to be that preparer.
What “good enough” looks like
- Every row has a date, payee, amount, category, and source
- Personal vs business (or “ask) is separated when the dump mixes both
- Duplicates from bank + receipt of the same purchase are flagged, not double-counted
- Missing receipts / vague payees sit in a notes column, not silently dropped
- Category totals are easy to skim for the period they care about
- Open questions are listed once so the handoff is honest
Intake checklist
- The dump (receipt photos, bank/CSV exports, card statements, Venmo/PayPal PDFs, prior sheets)
- Period that matters (tax year, quarter, custom range)
- Any category list they already use (or “use something simple and consistent”)
- Who the sheet is for (them, a bookkeeper, a CPA handoff)
- What “done” means (clean category sheet, optional missing-receipt list, optional by-category totals)
I am a freelancer admin / spreadsheet helper. I do not give tax advice, and I am not a CPA — this is expense hygiene and labeling so their preparer can work faster, not tax, audit, or deduction advice.
The pass order that saves time
- Gather sources — list every export, photo batch, and statement; note date range and who sent it.
- Normalize columns — map into: date, payee, amount, category, personal/business/ask, source, notes.
- Dedupe lightly — same date+amount+payee from bank and receipt → flag; do not invent merges without a rule.
- Categorize consistently — use their list if they have one; otherwise a short stable set (software, travel, meals, supplies, contractors, other) and park unknowns as “ask.”
- Flag gaps — missing receipt, unclear payee, mixed personal/business → notes, not silent guesses.
- Hand back — the category sheet (+ short missing-receipt / ask list if useful); no tax filing, no “you can deduct this” language.
Columns that usually work
| Column | What goes here |
|---|---|
| Date | Transaction / purchase date |
| Payee | Merchant or person as it appears (plus a cleaned name if helpful) |
| Amount | Spend amount (note currency if mixed) |
| Category | Their label or a simple consistent bucket |
| Type | Business / personal / ask |
| Source | Which CSV, statement, or photo batch the line came from |
| Notes | Missing receipt, duplicate suspect, “needs category confirm” |
Soft CTA
If you want this done for you as a one-off: I turn an expense dump into a tax-ready category sheet in about 24 hours.
Product: https://brittanybonds.gumroad.com/l/taxready
Shop: https://brittanybonds.gumroad.com/
Catalog mirror: https://brittany-bonds.github.io/
Code ADMIN12 for $2 off.
No fake CPA claims — spreadsheet cleanup so your preparer gets a cleaner handoff.
Top comments (0)