Sample data. This is the unedited report Month-End Close produced on its bundled sample files, which describe a fictional business, run the same way a subscriber's upload is run (as of 2026-10-14). No AI model and no person touched it. Your own results depend on the exports you upload.
The full download also contains: close_checklist.md, import/bank_card-amex-71003_2026-09.csv, import/bank_card-visa-4417_2026-09.csv, import/bank_checking-operating_2026-09.csv, import/bank_savings-reserve_2026-09.csv, import/categorized_2026-09.csv, import/journal_2026-09.csv, pnl_2026-09.csv, review_list.csv.
Month-end close: September 2026
Cash basis. Amounts are in the statements' currency. Every figure below comes from a file in work/, named next to it; transaction ids (T00042) and flag ids (F003) point to rows in those files.
Summary
| Transactions in month | 46 (work/categorized.csv) |
| Income | 21,179.22 (work/pnl.json) |
| Net income | -6,059.20 (work/pnl.json) |
| Uncategorized | 30 transactions, 30,015.05 (work/categorized.csv) |
| Payouts matched | 9, 16,537.51 (work/reconciliation.json) |
| Open receivables at month end | 0.00 (work/reconciliation.json) |
| Flags | 11 (work/flags.csv) |
| Review items | 44 (output/review_list.csv) |
Profit and loss
Source: work/pnl.json, line detail in work/pnl_detail.csv.
| Account | Amount | Txns |
|---|---|---|
| Income | ||
| 4010 Processor sales (gross) | 18,038.60 | 10 |
| 4020 Processor refunds | -404.50 | 4 |
| Uncategorized money in | 3,545.12 | 3 |
| Total income | 21,179.22 | |
| Expenses | ||
| 6100 Payment processing fees | 573.49 | 9 |
| Uncategorized money out | 26,469.93 | 27 |
| Total expenses | 27,043.42 | |
| Operating profit | -5,864.20 | |
| Other income | ||
| 4910 Processor adjustments | -195.00 | 2 |
| Total other income | -195.00 | |
| Net income | -6,059.20 |
Net income includes 30 uncategorized transactions (3,545.12 in, 26,469.93 out). It will change once they have accounts.
Not in the P&L
Money that moved between your own accounts or to balance-sheet accounts.
| Account | Net movement | Txns |
|---|---|---|
| Payout clearing | 84.50 | 1 |
| Transfers between accounts | 0.00 | 6 |
Tie-out: net change across all accounts -5,974.70 = net income -6,059.20 + not in P&L 84.50. Status: ties.
Payouts and deposits
Source: work/reconciliation.json.
| Payout | Paid out | Deposit | Net | Gross | Refunds | Fees | Other |
|---|---|---|---|---|---|---|---|
| shopify shopify-2026-09-01 | 2026-09-01 | T00039 2026-09-03 | 2,220.27 | 2,295.75 | 0.00 | -75.48 | 0.00 |
| stripe po_1QxT4kLarksp0904 | 2026-09-04 | T00043 2026-09-05 | 1,784.29 | 1,838.50 | 0.00 | -54.21 | 0.00 |
| shopify shopify-2026-09-08 | 2026-09-08 | T00050 2026-09-10 | 2,420.07 | 2,618.40 | -112.00 | -86.33 | 0.00 |
| paypal 7PL054471K85X | 2026-09-10 | T00052 2026-09-11 | 364.70 | 316.00 | -24.00 | -11.80 | 84.50 |
| stripe po_1QyB7rLarksp0914 | 2026-09-14 | T00060 2026-09-15 | 3,251.43 | 3,568.00 | -212.50 | -104.07 | 0.00 |
| shopify shopify-2026-09-15 | 2026-09-15 | T00065 2026-09-17 | 1,907.35 | 1,988.00 | 0.00 | -65.65 | -15.00 |
| shopify shopify-2026-09-22 | 2026-09-22 | T00074 2026-09-24 | 2,946.56 | 3,104.60 | -56.00 | -102.04 | 0.00 |
| stripe po_1QzH2mLarksp0924 | 2026-09-24 | T00075 2026-09-25 | 1,251.92 | 1,490.75 | 0.00 | -58.83 | -180.00 |
| paypal 7PL104471K70X | 2026-09-25 | T00077 2026-09-26 | 390.92 | 406.00 | 0.00 | -15.08 | 0.00 |
Not matched:
- shopify payout shopify-2026-09-29 on 2026-09-29, 2,166.28: in transit at month end
- Deposit T00079 on 2026-09-29, 412.60 (SQUARE INC DES:SQ260929 ID:T3J9 INDN:LARKSPUR CERAMICS CO CCD): no payout record
Invoices
No invoice file was given.
Flags
Source: work/flags.csv. New-vendor and unusual-amount checks: compared with transactions from 2026-08.
| Flag | Txn | Date | Description | Amount | Why |
|---|---|---|---|---|---|
| F001 possible duplicate | T00054 | 2026-09-12 | ADOBE *CREATIVE CLOUD | -59.99 | same account, vendor and amount as T00053 on 2026-09-12 |
| F002 unusual amount | T00040 | 2026-09-04 | AMZN MKTP US*3M8RR1K20 AMZN.COM/BILL WA | -142.33 | usual amount 69.02 (median of 2 earlier); this one 142.33 |
| F003 unusual amount | T00047 | 2026-09-09 | SIERRA CLAY CO | -1,850.00 | usual amount 405.52 (median of 2 earlier); this one 1,850.00 |
| F004 new vendor | T00051 | 2026-09-11 | THE HOME DEPOT #4710 OAKLAND CA | -97.82 | first payment to THE HOME DEPOT; 1 payment(s) this month, 97.82 total |
| F005 new vendor | T00062 | 2026-09-15 | ZELLE TO J FERRIS ON 09/15 REF # PP0H7QK2 | -2,500.00 | first payment to ZELLE TO J FERRIS; 1 payment(s) this month, 2,500.00 total |
| F006 new vendor | T00063 | 2026-09-16 | UPWORK -88213REF SAN FRANCISCO CA | -650.00 | first payment to UPWORK; 1 payment(s) this month, 650.00 total |
| F007 new vendor | T00070 | 2026-09-19 | CANVA* 04211-34567 | -14.99 | first payment to CANVA; 1 payment(s) this month, 14.99 total |
| F008 new vendor | T00072 | 2026-09-22 | WIRE TYPE:WIRE OUT DATE:260922 TIME:1104 ET TRN:2026092200118 BNF:KILNWORKS SUPPLY LTD | -3,000.00 | first payment to KILNWORKS SUPPLY LTD; 1 payment(s) this month, 3,000.00 total |
| F009 round number transfer | T00036 | 2026-09-01 | BRICKYARD PROPERTIES DES:RENT ID:LARKSPUR INDN:LARKSPUR CERAMICS CO CCD | -3,200.00 | 3,200.00 in whole hundreds, money leaving to an uncategorized destination |
| F010 round number transfer | T00062 | 2026-09-15 | ZELLE TO J FERRIS ON 09/15 REF # PP0H7QK2 | -2,500.00 | 2,500.00 in whole hundreds, money leaving to an uncategorized destination |
| F011 round number transfer | T00072 | 2026-09-22 | WIRE TYPE:WIRE OUT DATE:260922 TIME:1104 ET TRN:2026092200118 BNF:KILNWORKS SUPPLY LTD | -3,000.00 | 3,000.00 in whole hundreds, money leaving to an uncategorized destination |
Checklist
5 of 10 checks need attention. 44 items in output/review_list.csv.
| Check | Status | Detail | Source |
|---|---|---|---|
| Statements read for every account | DONE | 4 files, 46 transactions in September 2026 | work/parse_report.json |
| Statements cover the whole month | CHECK | card-amex-71003: transactions run 2026-09-04 to 2026-09-19 | work/transactions.csv |
| Running balances follow from the transactions | DONE | checking-operating closing 4,475.69 on 2026-09-30 (consistent); savings-reserve closing 17,008.96 on 2026-09-30 (consistent). Compare each closing balance with the bank's statement. | work/parse_report.json |
| Every transaction has an account | OPEN | 30 uncategorized, 30,015.05 total | work/categorized.csv |
| Proposed rules reviewed | OPEN | 28 proposals in work/rules_proposed.csv await a yes or no | work/rules_proposed.csv |
| Transfers between accounts paired | DONE | 5 pairs found | work/categorize_report.json |
| Payouts matched to deposits | OPEN | 9 matched (16,537.51); 1 in transit; 0 with no deposit; 1 deposit(s) with no payout record | work/reconciliation.json |
| Invoice payments matched | N/A | no invoice file given | work/reconciliation.json |
| Flags reviewed | OPEN | 5 new vendor, 1 possible duplicate, 3 round number transfer, 2 unusual amount | work/flags.csv |
| P&L ties to the accounts | DONE | net change -5,974.70 = net income -6,059.20 + balance sheet 84.50 | work/pnl.json |
Not checked by the tools
- Payroll: book gross wages, employer taxes and withholdings from the payroll provider's report (the bank shows only net pay and tax debits).
- Accruals and prepaids: bills received but not paid, and annual costs paid this month that cover later months.
- Depreciation and any loan interest/principal split.
- Sales tax: confirm what was collected and what is owed for the period.
- Inventory: count or adjust cost of goods sold if you track inventory.
- Sign-off: the owner or bookkeeper reviews this report and the review list.
Files
output/review_list.csv: every item above that needs a person, with the file and line it came fromoutput/pnl_2026-09.csv: the P&L as a spreadsheetoutput/import/: categorized transactions, a balanced journal and per-account bank files for September 2026work/: every intermediate result the numbers above come from