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.
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.
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 SheetsStep 1 of 5
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.
Step 2 of 5
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.
Step 3 of 5
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.
Step 4 of 5
Recompute inflow sum, outflow sum, and net in Sheets (SUMIF / filters). If chat ≠ sheet, trust the sheet and paste the mismatch back.
Step 5 of 5
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.