Invoice report CSV — three format variants

Sample: invoice INV-0847, issued 1 Jul 2026, total $163.65 ($142.30 + GST $21.35). July billed in advance (12 cashbooks, 6 × Fixed Assets, 3 × Budgets & Forecasts) plus one prorated June charge (Budgets & Forecasts enabled for Miro Design Studio on 18 Jun: 13/30 × $3.00 = $1.30). Every variant reconciles to the same total — they differ only in row layout.

Variant 1 — Flat: one row per cashbook per product

Today's format plus Cashbook ID (the cashbook UUID, truncated here), Product (modules prefixed Module:), Unit price and Amount columns. Trivial to filter/pivot in Excel; the amount column sums to the invoice subtotal.

InvoiceCashbook IDCashbookProductStartEndTypeUnitAmount
INV-08479d3f2a71-…Harbour View Café LtdCashBook01/07/202631/07/2026advance10.0010.00
INV-08479d3f2a71-…Harbour View Café LtdModule: Fixed Assets01/07/202631/07/2026advance2.002.00
INV-0847b81c40e5-…Kauri Plumbing 2018 LtdCashBook01/07/202631/07/2026advance10.0010.00
INV-0847b81c40e5-…Kauri Plumbing 2018 LtdModule: Fixed Assets01/07/202631/07/2026advance2.002.00
INV-0847b81c40e5-…Kauri Plumbing 2018 LtdModule: Budgets & Forecasts01/07/202631/07/2026advance3.003.00
INV-0847f04d9c22-…Miro Design Studio LtdModule: Budgets & Forecasts18/06/202630/06/2026prorated3.001.30
… 16 more rows (remaining 10 CashBook rows, 4 Module: Fixed Assets rows, 2 Module: Budgets & Forecasts rows)
Subtotal (22 rows)142.30
GST 15%21.35
Invoice total163.65

Variant 2 — Grouped by cashbook, subtotal per cashbook

Answers "what does each client cost me?" directly — the per-cashbook subtotal is what a firm on-charges to its client. Harder to pivot (blank repeat columns), friendlier to read top-to-bottom.

CashbookProductStartEndTypeAmount
Harbour View Café LtdCashBook01/07/202631/07/2026advance10.00
Module: Fixed Assets01/07/202631/07/2026advance2.00
Harbour View Café Ltd subtotal12.00
Miro Design Studio LtdCashBook01/07/202631/07/2026advance10.00
Module: Budgets & Forecasts01/07/202631/07/2026advance3.00
Module: Budgets & Forecasts18/06/202630/06/2026prorated1.30
Miro Design Studio Ltd subtotal14.30
… 10 more cashbook groups
Subtotal142.30
GST 15%21.35
Invoice total163.65

Variant 3 — Section per Stripe line item (reconciliation-first)

Mirrors the Stripe invoice exactly: one section per invoice line, each section's subtotal equals that line's amount. Fastest to audit against the invoice PDF; least convenient for per-client cost questions.

Invoice lineCashbookStartEndTypeAmount
CashBook — qty 12 × $10.00 = $120.00
Harbour View Café Ltd01/07/202631/07/2026advance10.00
… 11 more CashBook rows
Module: Fixed Assets — qty 6 × $2.00 = $12.00
Harbour View Café Ltd01/07/202631/07/2026advance2.00
… 5 more Fixed Assets rows
Module: Budgets & Forecasts — qty 3 × $3.00 = $9.00, plus proration $1.30 = $10.30
Kauri Plumbing 2018 Ltd01/07/202631/07/2026advance3.00
Miro Design Studio Ltd18/06/202630/06/2026prorated1.30
… 2 more Budgets & Forecasts rows
Subtotal142.30
GST 15%21.35
Invoice total163.65
Recommendation: Variant 1 (flat). It is the natural extension of the current report, machine-friendly (pivot/filter), and both other views can be derived from it in Excel in one step. Variant 2's per-client subtotal is the strongest competing need — if firms ask for it, it can ship later as a second download without changing the data.