The AI Bookkeeper: 3 prompts, real books

Free · copy-paste · from the episode "I Built an AI Bookkeeper For My 2-Week-Old YouTube Channel"

We use this exact system for this channel's own books, on the record — including the month the P&L read $329.17 out, $0 in. Ten minutes a month, three prompts, audit-friendly output.

Setup (once)

One folder. Everything financial goes in — statement CSVs, invoice PDFs or screenshots, notes-to-self. Strip account numbers first; the AI only needs date, merchant, amount.

PROMPT 1 · THE CATEGORIZER (run monthly)

You are the bookkeeper for my business: [one-line description]. I run [N] entities: [list them]. From the attached documents: 1) Extract every business-relevant transaction: date, merchant, amount, source doc. 2) Assign each to a category (production/direct costs, software and subscriptions, equipment, fees, marketing, other) and to an entity — show your reasoning. 3) Shared costs: if a charge serves multiple entities, do NOT split it silently. Propose an allocation rule (equal split, usage-based, or revenue-based), apply it, and flag the line ALLOCATED — owner decision required. 4) Anything ambiguous (possibly personal, unclear merchant) goes in a NEEDS-A-HUMAN table with your best guess and a question for me. 5) Rules: never invent transactions; never reclassify a prior month without flagging it; when uncertain, ask.

PROMPT 2 · THE P&L (after Prompt 1)

Build a monthly P&L per entity from the categorized ledger: revenue lines (even if $0), expense lines by category with per-unit notes where costs scale with output (e.g. $ per video), total, net. Then a 12-month run-rate projection at current output, clearly labeled PROJECTION. Show the break-even number: monthly revenue needed to cover the run rate.

PROMPT 3 · THE TAX-TIME EXPORT (run yearly)

Roll the year into a single summary per entity: totals by category, the allocation rules used (verbatim), the NEEDS-A-HUMAN items still open, and a CSV I can hand to an accountant or import into tax software. Flag anything inconsistent between months.

The three rules that make it audit-friendly

  1. The AI proposes; you decide — especially business-vs-personal.
  2. Allocation rules are written down and applied consistently. Consistency beats cleverness.
  3. This is bookkeeping, not tax advice. Real money deserves a real professional.
▶
Watch it run on our real booksI Built an AI Bookkeeper For My 2-Week-Old YouTube Channel (4:41)