Crestbrook Group · fictional sample
Inside the workbook.
The actual exported cells, ready to inspect. Five sheets from the corrected sandbox snapshot, before undo.
Static values. Editing Excel cells does not update totals or verification checks. Correct QuickBooks, refresh Flatbooks and export again. This sample covers the complete month of August 2026.
Sheet 1 of 5
Consolidation
Company columns, eliminations and $2,103,900 in consolidated assets.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Crestbrook Group — Consolidation | |||||
| 2 | Period: Year to date through Aug 31, 2026 | ✓ Ties to the penny | ||||
| 3 | Balance sheet as of Aug 31, 2026 · Accrual basis | |||||
| 4 | Values snapshot — editing cells does not recalculate totals or checks. Make accounting corrections in QuickBooks, refresh Flatbooks, then export again. | |||||
| 5 | ||||||
| 6 | Companies, in column order (headings are shortened): | |||||
| 7 | 1. Crestbrook Holdings LLC | |||||
| 8 | 2. Crestbrook Property Management LLC | |||||
| 9 | 3. Maplewood Apartments LLC | |||||
| 10 | ||||||
| 11 | Account | 1. Crestbrook Holdings LLC | 2. Crestbrook Property Mana… | 3. Maplewood Apartments LLC | Eliminations | Consolidated |
| 12 | Assets | |||||
| 13 | Operating Cash | 59,100.00 | 44,300.00 | 97,500.00 | 0.00 | 200,900.00 |
| 14 | Due to / from affiliates (elim) | 25,000.00 | 10,600.00 | 0.00 | -35,600.00 | 0.00 |
| 15 | Building | 0.00 | 676,000.00 | 832,000.00 | 0.00 | 1,508,000.00 |
| 16 | Land | 0.00 | 169,000.00 | 208,000.00 | 0.00 | 377,000.00 |
| 17 | Office Equipment | 18,000.00 | 0.00 | 0.00 | 0.00 | 18,000.00 |
| 18 | Liabilities | |||||
| 19 | Accounts Payable - trade | 6,500.00 | 0.00 | 0.00 | 0.00 | 6,500.00 |
| 20 | Due to / from affiliates (elim) | 0.00 | 25,000.00 | 10,600.00 | -35,600.00 | 0.00 |
| 21 | Security Deposits Held | 0.00 | 15,600.00 | 19,200.00 | 0.00 | 34,800.00 |
| 22 | Mortgage Note Payable | 0.00 | 533,000.00 | 656,000.00 | 0.00 | 1,189,000.00 |
| 23 | Equity | |||||
| 24 | Opening Balance Equity | 113,500.00 | 220,800.00 | 300,100.00 | 0.00 | 634,400.00 |
| 25 | Income | |||||
| 26 | Management fee income (elim) | 0.00 | 8,400.00 | 0.00 | -8,400.00 | 0.00 |
| 27 | Rental Income | 0.00 | 124,800.00 | 201,600.00 | 0.00 | 326,400.00 |
| 28 | Service Revenue | 40,000.00 | 0.00 | 0.00 | 0.00 | 40,000.00 |
| 29 | Expenses | |||||
| 30 | General & Administrative | 22,000.00 | 0.00 | 0.00 | 0.00 | 22,000.00 |
| 31 | Insurance | 900.00 | 0.00 | 0.00 | 0.00 | 900.00 |
| 32 | Legal & Professional Fees | 0.00 | 0.00 | 2,500.00 | 0.00 | 2,500.00 |
| 33 | Management fees paid (elim) | 0.00 | 0.00 | 8,400.00 | -8,400.00 | 0.00 |
| 34 | Property Insurance | 0.00 | 7,000.00 | 8,600.00 | 0.00 | 15,600.00 |
| 35 | Property Taxes | 0.00 | 10,100.00 | 12,500.00 | 0.00 | 22,600.00 |
| 36 | Repairs & Maintenance | 0.00 | 9,400.00 | 18,000.00 | 0.00 | 27,400.00 |
| 37 | Salaries & Wages | 35,000.00 | 0.00 | 0.00 | 0.00 | 35,000.00 |
| 38 | Utilities | 0.00 | 1,200.00 | 0.00 | 0.00 | 1,200.00 |
| 39 | ||||||
| 40 | Total assets | 2,103,900.00 | ||||
| 41 | Total liabilities + equity | 2,103,900.00 | ||||
| 42 | ✓ Balanced | 0.00 | ||||
Sheet 2 of 5
Monthly P&L
August 1–31: $48,000 income, $8,600 expenses and $39,400 net income. The $2,400 intercompany fee is removed from both income and expenses; it does not change group net income.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Crestbrook Group — Monthly P&L | |||||
| 2 | Month only: Aug 1 – Aug 31, 2026 | ✓ Ties to the penny | ||||
| 3 | Accrual basis. Values snapshot. Intercompany accounts remain visible with their elimination adjustments. | |||||
| 4 | Values snapshot — editing cells does not recalculate totals or checks. Make accounting corrections in QuickBooks, refresh Flatbooks, then export again. | |||||
| 5 | 1. Crestbrook Holdings LLC | |||||
| 6 | 2. Crestbrook Property Management LLC | |||||
| 7 | 3. Maplewood Apartments LLC | |||||
| 8 | ||||||
| 9 | Account | 1. Crestbrook Holdings LLC | 2. Crestbrook Property Mana… | 3. Maplewood Apartments LLC | Eliminations | Consolidated |
| 10 | Income | |||||
| 11 | Management fee income (elim) | 0.00 | 2,400.00 | 0.00 | -2,400.00 | 0.00 |
| 12 | Rental Income | 0.00 | 0.00 | 48,000.00 | 0.00 | 48,000.00 |
| 13 | Total income | 0.00 | 2,400.00 | 48,000.00 | -2,400.00 | 48,000.00 |
| 14 | Expenses | |||||
| 15 | Insurance | 900.00 | 0.00 | 0.00 | 0.00 | 900.00 |
| 16 | Management fees paid (elim) | 0.00 | 0.00 | 2,400.00 | -2,400.00 | 0.00 |
| 17 | Repairs & Maintenance | 0.00 | 0.00 | 6,500.00 | 0.00 | 6,500.00 |
| 18 | Utilities | 0.00 | 1,200.00 | 0.00 | 0.00 | 1,200.00 |
| 19 | Total expenses | 900.00 | 1,200.00 | 8,900.00 | -2,400.00 | 8,600.00 |
| 20 | ||||||
| 21 | Net income | -900.00 | 1,200.00 | 39,100.00 | 0.00 | 39,400.00 |
Sheet 3 of 5
YTD P&L
January 1–August 31. Net income is $239,200.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Crestbrook Group — YTD P&L | |||||
| 2 | Year to date through Aug 31, 2026 | ✓ Ties to the penny | ||||
| 3 | Accrual basis. Values snapshot. Intercompany accounts remain visible with their elimination adjustments. | |||||
| 4 | Values snapshot — editing cells does not recalculate totals or checks. Make accounting corrections in QuickBooks, refresh Flatbooks, then export again. | |||||
| 5 | 1. Crestbrook Holdings LLC | |||||
| 6 | 2. Crestbrook Property Management LLC | |||||
| 7 | 3. Maplewood Apartments LLC | |||||
| 8 | ||||||
| 9 | Account | 1. Crestbrook Holdings LLC | 2. Crestbrook Property Mana… | 3. Maplewood Apartments LLC | Eliminations | Consolidated |
| 10 | Income | |||||
| 11 | Management fee income (elim) | 0.00 | 8,400.00 | 0.00 | -8,400.00 | 0.00 |
| 12 | Rental Income | 0.00 | 124,800.00 | 201,600.00 | 0.00 | 326,400.00 |
| 13 | Service Revenue | 40,000.00 | 0.00 | 0.00 | 0.00 | 40,000.00 |
| 14 | Total income | 40,000.00 | 133,200.00 | 201,600.00 | -8,400.00 | 366,400.00 |
| 15 | Expenses | |||||
| 16 | General & Administrative | 22,000.00 | 0.00 | 0.00 | 0.00 | 22,000.00 |
| 17 | Insurance | 900.00 | 0.00 | 0.00 | 0.00 | 900.00 |
| 18 | Legal & Professional Fees | 0.00 | 0.00 | 2,500.00 | 0.00 | 2,500.00 |
| 19 | Management fees paid (elim) | 0.00 | 0.00 | 8,400.00 | -8,400.00 | 0.00 |
| 20 | Property Insurance | 0.00 | 7,000.00 | 8,600.00 | 0.00 | 15,600.00 |
| 21 | Property Taxes | 0.00 | 10,100.00 | 12,500.00 | 0.00 | 22,600.00 |
| 22 | Repairs & Maintenance | 0.00 | 9,400.00 | 18,000.00 | 0.00 | 27,400.00 |
| 23 | Salaries & Wages | 35,000.00 | 0.00 | 0.00 | 0.00 | 35,000.00 |
| 24 | Utilities | 0.00 | 1,200.00 | 0.00 | 0.00 | 1,200.00 |
| 25 | Total expenses | 57,900.00 | 27,700.00 | 50,000.00 | -8,400.00 | 127,200.00 |
| 26 | ||||||
| 27 | Net income | -17,900.00 | 105,500.00 | 151,600.00 | 0.00 | 239,200.00 |
Sheet 4 of 5
Intercompany
Matched balances and the recorded explanation for journal #246.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Crestbrook Group — Intercompany | |||||
| 2 | Period: Year to date through Aug 31, 2026 | |||||
| 3 | Balance sheet as of Aug 31, 2026 — recognized due-to/from pairs · Accrual basis | |||||
| 4 | Values snapshot — editing cells does not recalculate totals or checks. Make accounting corrections in QuickBooks, refresh Flatbooks, then export again. | |||||
| 5 | Positive net = receivable; negative net = payable. Amounts use the companies' reporting currency. | |||||
| 6 | Difference = A net + B net. Matched means a zero difference; it does not establish the accounting cause. | |||||
| 7 | ||||||
| 8 | Entity A | Entity B | A net | B net | Difference | Status |
| 9 | Crestbrook Holdings LLC | Crestbrook Property Management LLC | 25,000.00 | -25,000.00 | 0.00 | Matched |
| 10 | Crestbrook Property Management LLC | Maplewood Apartments LLC | 10,600.00 | -10,600.00 | 0.00 | Matched |
| 11 | ||||||
| 12 | Flatbooks-recorded corrections | 2026-08 | ||||
| 13 | Only corrections recorded by Flatbooks for this reporting period appear here. This is not a complete QuickBooks journal-entry register. | |||||
| 14 | Prepared details are historical: later changes in QuickBooks are not reflected here. Recorded status is not a fresh verification of QuickBooks. | |||||
| 15 | Recorded at is when Flatbooks created the correction record, not the confirmed QuickBooks posting time. | |||||
| 16 | ||||||
| 17 | Correction record | SAMPLE-CORRECTION-1 | ||||
| 18 | Recorded status | Posted | ||||
| 19 | Company | Maplewood Apartments LLC | QuickBooks realm | SANDBOX-COMPANY-3 | ||
| 20 | Counterparty | Crestbrook Property Management LLC | QuickBooks realm | SANDBOX-COMPANY-2 | ||
| 21 | Recorded at (UTC) | Sep 22, 2026, 11:31 PM UTC | ||||
| 22 | Original journal entry ID | 246 | ||||
| 23 | Reversal journal entry ID | Not recorded | ||||
| 24 | Correction amount | 137.49 | ||||
| 25 | Prepared journal date | 2026-08-31 | ||||
| 26 | Reviewed cause / source | FICTIONAL MONTHLY STORY 2026-09-22: sandbox JE #245 duplicated a $137.49 repair expense/payable. Reverse that duplicate in Maplewood; credit Repairs & Maintenance. Verified against the recorded fixture lines. | ||||
| 27 | Prepared entry | Account name | QuickBooks account ID | Side | Amount | |
| 28 | Intercompany account | Due to Crestbrook Property Management LLC | 1150040025 | Debit | 137.49 | |
| 29 | Offset account | Repairs & Maintenance | 1150040022 | Credit | 137.49 | |
Sheet 5 of 5
Verification
The coverage declaration, supported scope and 16 passing numeric checks.
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Crestbrook Group — Verification | ||||
| 2 | Report coverage | REVIEWED | |||
| 3 | The reviewer confirmed complete company coverage and no adjustments beyond Flatbooks’ supported eliminations for this month. This records the reviewer’s judgment. Financial checks must also pass before export. | ||||
| 4 | Review note | FICTIONAL MONTHLY STORY 2026-09-22: three sibling sandbox companies, common individual owner, complete USD accrual group; no investment/equity or other unsupported group adjustments. Test assumptions, not real client evidence. | |||
| 5 | Coverage reviewed at (UTC) | 2026-09-22T23:30:17.336Z | |||
| 6 | Coverage reviewed by | Sandbox reviewer | |||
| 7 | Limits | Recognized due-to/from and management fees only. No investment/equity, non-controlling interest, acquisition, intra-group profit or currency translation adjustments. | |||
| 8 | Period: Year to date through Aug 31, 2026 · Accrual basis | Generated: Sep 22, 2026, 11:32 PM UTC | |||
| 9 | Values snapshot — editing cells does not recalculate totals or checks. Make accounting corrections in QuickBooks, refresh Flatbooks, then export again. | ||||
| 10 | |||||
| 11 | Check | Result | Ours ($) | QuickBooks ($) | Difference ($) |
| 12 | Consolidated assets equal liabilities + equity | PASS | 2,103,900.00 | 0.00 | |
| 13 | Intercompany due-to/due-from nets to $0 across entities | PASS | 0.00 | ||
| 14 | Intercompany management fees net — group and per pair | PASS | 0.00 | ||
| 15 | Crestbrook Holdings LLC — assets matches QuickBooks' own report | PASS | 102,100.00 | 102,100.00 | 0.00 |
| 16 | Crestbrook Holdings LLC — net income matches QuickBooks' own report | PASS | -17,900.00 | -17,900.00 | 0.00 |
| 17 | Crestbrook Holdings LLC — liabilities matches QuickBooks' own report | PASS | 6,500.00 | 6,500.00 | 0.00 |
| 18 | Crestbrook Property Management LLC — assets matches QuickBooks' own report | PASS | 899,900.00 | 899,900.00 | 0.00 |
| 19 | Crestbrook Property Management LLC — net income matches QuickBooks' own report | PASS | 105,500.00 | 105,500.00 | 0.00 |
| 20 | Crestbrook Property Management LLC — liabilities matches QuickBooks' own report | PASS | 573,600.00 | 573,600.00 | 0.00 |
| 21 | Maplewood Apartments LLC — assets matches QuickBooks' own report | PASS | 1,137,500.00 | 1,137,500.00 | 0.00 |
| 22 | Maplewood Apartments LLC — net income matches QuickBooks' own report | PASS | 151,600.00 | 151,600.00 | 0.00 |
| 23 | Maplewood Apartments LLC — liabilities matches QuickBooks' own report | PASS | 685,800.00 | 685,800.00 | 0.00 |
| 24 | |||||
| 25 | Monthly P&L — Aug 1 – Aug 31, 2026 | ||||
| 26 | Crestbrook Holdings LLC — monthly net income | PASS | -900.00 | -900.00 | 0.00 |
| 27 | Crestbrook Property Management LLC — monthly net income | PASS | 1,200.00 | 1,200.00 | 0.00 |
| 28 | Maplewood Apartments LLC — monthly net income | PASS | 39,100.00 | 39,100.00 | 0.00 |
| 29 | |||||
| 30 | Monthly intercompany fees | ||||
| 31 | Company pair | Result | First company: debit less credit | Second company: debit less credit | Difference |
| 32 | Monthly fees: Crestbrook Property Management LLC / Maplewood Apartments LLC | PASS | -2,400.00 | 2,400.00 | 0.00 |
| 33 | Monthly P&L = closing YTD less preceding month-end YTD. January has a zero opening P&L. Balance-sheet earnings remain YTD. | ||||
| 34 | |||||
| 35 | Every figure is computed deterministically from the QuickBooks trial balances — no AI in the money path. | ||||
| 36 | Generated by flatbooks · flatbooks.io | ||||