Close Month

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:

• --month (default: previous calendar month) — YYYY-MM format
• --save-to (default files) — files (Google Drive / OneDrive), desktop (local), or both

Step 1 — Reconcile

Trigger the month-end-prep 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:
• Reconciliation — QB ↔ processor match table with gap rows highlighted
• Flagged — uncategorized / duplicates / missing receipts
• P&L — formatted income statement with prior-month delta column
• Trial Balance — accounts + ending balances
• close-packet-{YYYY-MM}.pdf — one-page summary: P&L narrative + top-line numbers + gap count

Save both to the chosen --save-to 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.