Run the month-end close workflow. Reconcile, flag gaps, narrate the P&L, and export the close packet for the owner's records (and their accountant).
Parse arguments:
- (default: previous calendar month) — format
- (default ) — (Google Drive / OneDrive), (local), or
Step 1 — Reconcile
Trigger the
skill workflow:
- Pull all QuickBooks transactions for the target month.
- Pull settlements from each connected payment processor (PayPal, Stripe, Square) for the same month.
- Match QB entries to processor settlements by amount + date (±2 days).
- Surface three gap categories:
- Unmatched processor settlements — money came in via PayPal/Stripe/Square but never landed in QB
- Unmatched QB deposits — QB shows income with no processor record (cash? wire? misclassified?)
- Variance lines — matched but amount differs (fees, refunds split)
Step 2 — Flag suspicious entries
Surface in the same report:
- Uncategorized transactions — QB entries with no category
- Suspicious duplicates — same amount, same vendor, within 3 days
- Missing receipts — QB entries above $75 with no attachment
For each, recommend an action: categorize as X, delete duplicate, attach receipt from inbox.
Wait for owner to triage flagged items before generating the narrative. Do not auto-categorize or auto-delete.
Step 3 — P&L narrative
After triage, generate a plain-English P&L narrative:
{Month YYYY} closed at ${revenue} revenue ({+/-}{X}% vs prior month).
Top driver: {category/customer}. Biggest swing: {category} {direction} ${amount}
because {reason inferred from transactions}.
Margin: {X}% ({+/-}Y pts vs prior). {Cost-side commentary}.
Three notable items:
1. ...
2. ...
3. ...
Numbers come from QB; the why comes from cross-referencing top transactions, vendor names, and prior-month deltas.
Step 4 — Export the close packet
Generate two files:
close-packet-{YYYY-MM}.xlsx
— multi-tab workbook:
- — QB ↔ processor match table with gap rows highlighted
- — uncategorized / duplicates / missing receipts
- — formatted income statement with prior-month delta column
- — accounts + ending balances
close-packet-{YYYY-MM}.pdf
— one-page summary: P&L narrative + top-line numbers + gap count
Save both to the chosen
location. Filename format:
close-packet-2026-04.xlsx
etc.
Connector failures
If QuickBooks is unreachable, stop — reconciliation requires QB as the source of truth. If a payment processor (PayPal, Stripe, Square) is unreachable, run reconciliation against the available processors and note "PayPal not connected — PayPal settlements skipped from reconciliation" (or whichever is missing). If all processors are missing, run QB-only analysis and flag it.
Approval gates
- Never auto-fix flagged items. Always show the gap, recommend an action, wait for the owner.
- Never delete duplicates without explicit confirmation. Show both records side-by-side.
- Saving the packet is auto — it goes to the owner's own drive.
Output
End the run with a one-paragraph recap: revenue, margin, gap count remaining (if any), file paths to the saved packet. If gaps were not all resolved, list them so the owner can revisit.