datatools-dev/marketing/emails/bookkeeper/04-day14.md

Bookkeeper · Day 14 — Two-minute trick: the gate report

Subject: Two-minute trick: the gate report Send: Day 14 Goal: surface the gate tool — non-obvious, high-value once seen

---

Hi {{first_name}},

The tool inside DataTools that buyers find last is the gate — and it's the one that quietly does the most for you.

What it does: before any row gets written to the cleaned CSV, the gate runs a per-row pass-through check. Rows that fail get quarantined into a separate file (<filename>.quarantine.csv) instead of silently dropped or silently passed.

Default rules (you can add your own):

• Missing required fields (date, amount)
• Amount in unexpected currency without a flag
• Date outside the export's stated range (catches the "totals row" issue from Day 1)
• Duplicate of another row already in the file (per the dedupe pass)
• Confidence below your threshold on a field that got auto-corrected

The 2-minute workflow:

1. Run the pipeline as usual.
2. Open <filename>.quarantine.csv. (It'll be tiny — typically 0-5% of rows.)
3. Eyeball it. Anything that's a real transaction, fix-and-re-include manually. Anything that's a totals row / blank row / corrupt row — confirm it's correctly quarantined and delete it.
4. Re-run the pipeline on the fixed-up version (or just append the manually-fixed rows to the cleaned CSV).

The reason this matters: silent drops are the worst possible failure mode for a bookkeeper. You'd rather a row come out wrong (you'll catch it on review) than disappear (you won't catch it for months). The gate makes the silent-drop case impossible.

Set the gate's confidence threshold to 0.85 for client work. Lower (0.75) for personal / exploratory; higher (0.92+) only if you've spent time tuning your client's preset.

— Michael {{support_email}}