Best Overall
ChatGPT (Advanced Data Analysis)
Code-backed sums beat prose guesses for weekly totals.
Open ChatGPTresearch · ~25 min
Not bookkeeping, audit, or tax advice. Compute only from the paste. No invented runway. Recompute totals in Sheets.
Best Overall
Code-backed sums beat prose guesses for weekly totals.
Open ChatGPTBest Free
Works with a redacted CSV sample—schema + sample rows when you avoid a full PII upload.
Open ClaudeBest Power-User
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 SheetsDefine 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.
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.
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.
Recompute inflow sum, outflow sum, and net in Sheets (SUMIF / filters). If chat ≠ sheet, trust the sheet and paste the mismatch back.
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.