The mid-month checklist I use so a receipt spreadsheet stays honest

A camera roll full of faded thermal paper, a screenshot of an Uber tip you half-remember, a sticky that says “software somehow,” a duplicate photo of the same lunch, and a Slack ping titled “did we expense that??” are not mid-month truth. Mid-month is where personal purchases bleed into business rows, tips float free of the base fare, currencies mix without a note, categories drift mid-sheet, and “I think we’re caught up” rewrites the month total.

I am a freelancer admin helper. I turn a month of receipt photos into a clean spreadsheet. I am not a CPA, bookkeeper, tax advisor, or auditor — and this is not financial, tax, legal, or accounting advice. It is the checklist I run mid-month (and again before anyone treats the sheet as tax-or-reimbursement truth) so the receipt spreadsheet stays honest while dumps are still arriving.

(If you want the full messy receipt-photo dump → clean spreadsheet workflow, see my earlier post. This one is the second-pass checklist so duplicates, personal bleed, tip fog, and category drift do not quietly rewrite the month.)

What "honest" looks like mid-month

• Every row has date, vendor, amount, currency, category, tip (or n/a), personal/business flag, source, and notes — not vibes
• One photo = one row (or the duplicate is labeled) — not two totals for the same lunch
• Personal purchases are stay-off or labeled personal — not left looking reimbursable
• Tips sit with the base fare (or ask) — not floating as mystery add-ons
• Open questions (illegible amount, missing date, mixed currency, TBD category) are listed once so the handoff is honest

If the only “receipt sheet” you have is a Slack ping titled “did we expense that??,” mid-month honesty has already slipped.

The mid-month checklist (run it before / while you clean)

Use this against the dump (camera roll, Drive folder, email forwards, screenshots, bank-app captures) before you paste everything into a pretty green “month closed” grid and call the sheet ready.

1. Inventory the receipt dump (same day you open the pile)

• [ ] Every scrap is listed once: source, date seen, claim type (business / personal / unknown / duplicate / incomplete), notes
• [ ] Duplicate photos of the same receipt are labeled duplicate — not counted twice toward the month total
• [ ] Partial dumps (cropped amounts, tip-only screenshots, “software somehow”) are labeled incomplete — not invented into tidy rows
• [ ] As-of date range that matters is named — older months stay out or flagged
• [ ] Anything clearly personal, client-reimbursed already, or belonging to a different card is labeled stay-off — do not resurrect as this mid-month chase list

2. Lock date, vendor, and amount before you trust the total

• [ ] Every “include” row has a real date or is labeled ask — not three ghost rows with blank days
• [ ] Vendor is normalized once (or ask) — not “UBER *TRIP” and “Uber” as two unrelated merchants
• [ ] Amount is a number (or ask) — not “about forty” or emoji
• [ ] Currency is named (USD / other / ask) — mixed currencies without a note are not one total
• [ ] Skim test: you can answer “what did we spend, where, and which rows are still fuzzy?” without opening the camera roll

3. Kill tip fog, personal bleed, and category drift

• [ ] Tip is attached to the base fare (or n/a / ask) — floating tip screenshots are not separate mystery spend
• [ ] Personal vs business flag is explicit — blank is not “probably business”
• [ ] Category vocabulary is named and stable for the month — mid-sheet flips are labeled recheck
• [ ] Dual amounts or dual dates stay ask — not silently forced to the friendlier option
• [ ] Everything showing “business” when the dump looks personal/gift is labeled recheck until the flag is honest

4. Park guessed fields, TBD rows, and Slack folklore in the open

• [ ] Missing required fields sit as ask with what is missing — not invented to tidy the sheet
• [ ] “TBD,” “software somehow,” and “that lunch?” without a mapping stay ask — not locked as this month’s closed total
• [ ] Anything you almost guessed (which photo wins, whether tip was cash, whether the meal was client-facing) stays in notes as guessed — not locked as truth
• [ ] Slack / sticky reminders that contradict the photo are labeled conflict — not silently preferred
• [ ] Bank CSV lines that might match a photo stay match? until you confirm — not forced merges

5. Mid-month skim before you call the sheet “caught up”

• [ ] Include / personal / duplicate / ask counts match a quick mental check of known open items
• [ ] Ask rows and duplicate suspects are countable in under a minute
• [ ] Month total never invents missing amounts — blanks stay ask
• [ ] You can hand the sheet to someone else without a 10-minute camera-roll tour
• [ ] Soft CTA only if useful: this is cleanup so dates, vendors, and categories are easier to see — not advice on deductibility, tax timing, or bookkeeping-of-record

Soft CTA

If you want a month of receipt photos turned into a clean spreadsheet: https://brittanybonds.gumroad.com/l/wxbclt

Shop: https://brittanybonds.gumroad.com/

Catalog mirror: https://brittany-bonds.github.io/

Code ADMIN12 for $2 off.

No fake CPA or tax claims — spreadsheet cleanup so your month of receipts is easier to track and hand off.