Lighting the Way to AIExact recipes for real AI jobsHome

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-08Lumina seed `weekly-cash-position-brief`

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

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. 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 csv-ask-my-data-analysis (one ad-hoc question + checksum): this recipe’s output shape is always a weekly cash-position brief for the owner.

  2. 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. 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. 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. 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 csv-ask-my-data-analysis instead.

Dated sources

Related recipes

Copied