{"pass":true,"passed":13,"total":13,"generatedAt":"2026-07-17T05:38:15.576Z","dataMode":"bundled QBO-shaped fixtures","checks":[{"id":"bill_split_sums","label":"Multi-project bill line amounts sum to bill TotalAmt","pass":true,"detail":"bill_101: $100 + $200 + $100 = $400 vs TotalAmt $400"},{"id":"bug_reproduced","label":"Report-builder repetition overstates the bill 3x; API per-line path matches","pass":true,"detail":"header-repeat total $1200 vs per-line total $400"},{"id":"no_control_lines","label":"No A/P, A/R or bank control lines in flattened rows","pass":true,"detail":"42 flattened rows, 0 balance-sheet lines"},{"id":"pagination_complete","label":"Paged extraction fetches COUNT(*) for every entity","pass":true,"detail":"Bill 8/8 across 3 pages; Invoice 10/10 across 4 pages; Purchase 2/2 across 1 page"},{"id":"no_project_dropped","label":"Lines without a Customer/Project ref are dropped","pass":true,"detail":"3 overhead lines in raw pull, 0 after rules"},{"id":"no_income_project_excluded","label":"Not-yet-invoiced project (costs, no income) absent from report","pass":true,"detail":"\"Quiet Hours\" carries $420 of costs and no income; excluded"},{"id":"labor_consolidated","label":"W-2 + 1099 recording labor merges into one line per project","pass":true,"detail":"Salt & Cedar recording = $200 (1099) + $310 (W-2) = $510"},{"id":"narrator_passthrough","label":"Talent / TalentReimb isolated as narrator pass-through rows","pass":true,"detail":"pass-through income $2730 vs expense $2650 (small handling markup)"},{"id":"indie_author_membership","label":"Indie Author group holds only single-project customers","pass":true,"detail":"J. Marsh: Driftwood Letters; R. Okafor: Lagos Frequencies; T. Bellweather: Pocket Storms"},{"id":"alphabetical_grouping","label":"Customer groups run alphabetically across the sheet","pass":true,"detail":"Aster & Vale Publishing -> Bramblewood Press -> Cormorant House -> Indie Author"},{"id":"customer_totals","label":"Every customer total column = sum of its project columns","pass":true,"detail":"4 groups x 11 rows verified"},{"id":"percent_pairs","label":"Percent columns divide by core service revenue (configurable base)","pass":true,"detail":"Cartographer narrator expense $1200 / $3800 core = 31.6%"},{"id":"column_arithmetic","label":"Total Income - Total Costs = Net Profit in every column","pass":true,"detail":"checked on all project and total columns"}]}