Michael
e1f364f010
Pick up and finish yesterday's cut-off Tier B pass. - build/: PyInstaller scaffold (datatools.spec + launcher.py + hook-streamlit.py + README) — folder-mode bundle, locked 127.0.0.1, per-OS recipe - marketing/COPY.md: single source of truth for every customer-facing string — landing H1/sub/CTAs, demo CTAs, email subjects, Gumroad listing, banned phrases - marketing/community-posts/: 9 drafts (3 posts × 3 niches: bookkeeper, revops, shopify-pet) — story / tip / soft-offer - marketing/emails/: 18 drafts (Gumroad delivery + 5-touch onboarding × 3 niches), per-niche segmentation guidance - docs/NEXT-STEPS.md: flip 2.2 / 2.4 / 3.1 / 3.4 to done with pointers to the new assets; add Phase 0 inventory rows - .gitignore: narrow `build/` ignore so PyInstaller spec + launcher + hooks get tracked, only generated artifacts (build/build/, build/__pycache__/, build/dist/) stay ignored Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
1.9 KiB
Bookkeeper · Day 3 — The audit trail your client will actually open
Subject: The audit trail your client will actually open Send: Day 3 Goal: deepen feature understanding around the audit trail (the real differentiator vs. spreadsheet workflow)
Hi {{first_name}},
Most "data cleaning" tools spit out a clean file and call it done. The thing your client needs — and what protects you in a year when they ask "why did you change that?" — is the audit trail.
Here's the file DataTools writes alongside every cleaned export. It's a CSV called <filename>.audit.csv and it sits next to the cleaned file in your output folder.
Five columns, append-only:
| original_value | new_value | rule_applied | confidence | timestamp |
|---|---|---|---|---|
AMZN Mktp |
Amazon |
merchant_canonicalize |
0.94 | 2026-05-04T09:12:03 |
Starbucks |
Starbucks |
whitespace_strip |
1.00 | 2026-05-04T09:12:03 |
01/02/26 |
2026-02-01 |
date_normalize_dmy |
0.88 | 2026-05-04T09:12:03 |
Why this matters in a real client conversation:
- The client asks "why is this Amazon when my statement says AMZN Mktp?" — open the audit CSV, point at the
merchant_canonicalizerow. Done in 10 seconds. - A reviewer (auditor, accountant, you in 6 months) asks "what changed?" — the audit CSV is the answer. Diffable, openable in Excel, no proprietary format.
- You spot a wrong rule firing — the
confidencecolumn tells you which rules to tune. Anything <0.90 is worth eyeballing.
One workflow change worth making: when you send the cleaned file to QuickBooks, send the audit CSV to the client at the same time, in a folder labeled "month-end audit trail". Most clients won't open it. The 10% that do will trust you forever.
Reply if you want me to walk through the audit format on a call — happy to do a quick screen-share for any buyer in the first 30 days.
— Michael {{support_email}}