Lighting the Way to AIExact recipes for real AI jobs

research · ~25 min

Turn a week of bank or CSV activity into a cash-position brief—opening/closing, inflow/outflow buckets, verified totals—without inventing runway or giving tax advice.

Last verified: 2026-09-08

Not bookkeeping, audit, or tax advice. Compute only from the paste. No invented runway. Recompute totals in Sheets.

Ads, equipment, and payment-terms calls belong on the small business (SMB) decision trees hub first—then come back here to brief the week you actually pasted.

Top picks

Best Overall

ChatGPT (Advanced Data Analysis)

Code-backed sums beat prose guesses for weekly totals.

Open ChatGPT

Best Free

Claude

Works with a redacted CSV sample—schema + sample rows when you avoid a full PII upload.

Open Claude

Best Power-User

Claude + Google Sheets

Generate the brief structure; verify every headline number in Sheets. QuickBooks/Xero exports are inputs you paste—do not treat chat as your ledger.

Open Google Sheets

Protocol

  1. Step 1 of 5

    PII hygiene + week window (3–5 min).

    Define the week (e.g. Mon–Sun dates). From bank CSV or export: keep date, amount, direction (in/out), and coarse category if you have it. Drop or hash payee names, account numbers, SSNs, and memo fields with personal data when policy requires. Sample if huge. Distinct from the ask-my-data how-to (one ad-hoc question + checksum): this recipe’s output shape is always a weekly cash-position brief for the owner.

  2. Step 2 of 5

    Profile, then brief—no “insights” freestyle.

    Paste the rules first. A number without a checksum is not done. Runway stays omitted unless you provided burn or obligations.

    Copy-paste prompt

    I need a WEEKLY CASH-POSITION BRIEF—not a general “ask my data” exploration.
    Hard rules:
    - Compute only from the data I paste. Do not invent balances, transfers, or categories.
    - Output exactly: Week range; Opening cash (only if I provide it); Inflows total + top buckets; Outflows total + top buckets; Net change; Closing cash (opening + net only if opening provided—else [NEED FACT]); 3 data-quality warnings; Checksum lines I can recompute in Sheets.
    - Runway / weeks-of-cash ONLY if I provide burn rate or near-term obligations—otherwise omit runway and say [MISSING burn/obligations].
    - Not bookkeeping, not tax advice, not a forecast.
    Confirm in one sentence, then wait for data.
  3. Step 3 of 5

    Fill pack (step 3a) and generate (step 3b).

    Paste the redacted week, then send the generate command.

    Paste pack

    WEEK START: [YYYY-MM-DD]
    WEEK END: [YYYY-MM-DD]
    OPENING CASH (if known): [amount or NEED FACT]
    BURN / OBLIGATIONS FOR RUNWAY (optional): [or OMIT]
    CATEGORY RULES I USE (optional): [e.g. payroll, rent, owner draw, revenue]
    CSV OR TRANSACTION LIST (redacted):
    [paste]

    After you send the filled pack, copy the Generate command in the next box and paste it into the SAME chat so the AI runs the decision tree / produces the output.

    Generate command — copy and send this next (same chat)

    Build the weekly cash-position brief now. Show aggregation logic. Mark [NEED FACT] / [MISSING]. No invented runway.
  4. Step 4 of 5

    Verify totals (mandatory).

    Recompute inflow sum, outflow sum, and net in Sheets (SUMIF / filters). If chat ≠ sheet, trust the sheet and paste the mismatch back.

  5. Step 5 of 5

    Second-model check (optional, 5 min).

    Write the owner takeaway yourself (e.g. “payroll cleared; receivables lag”). If you want a second-model pass:

    Second-model check

    Here is a weekly cash-position brief from another assistant plus my checksum totals from Sheets.
    Find: (1) numbers that disagree with my checksums, (2) invented runway or forecasts, (3) categories I didn’t define, (4) residual PII in the brief.
    Return only corrections. Not tax advice.

When not to

  • Not bookkeeping, audit, or tax advice—your accountant owns filings.
  • Health/student/payment PII you may not upload—analyze locally under policy.
  • Do not publish runway metrics when burn/obligations were not provided.
  • Do not use this when you really need open-ended CSV Q&A—use the ask-my-data how-to instead.

Dated sources

Related recipes

Copied