Sales Invoice Template Generators

1) Original (Owner) • 2) GST Variant (Owner) • 3) NON GST (CSS Aggregator) — v2 fix: R row 2 = sum of Column W

1) Original Generator (Owner)

Sort:

2) GST Variant Generator (Owner)

Sort:

Diffs vs Original: P4=15% GST on accommodation; P6=Less: Comprende Management Fees (Inclu GST of $AN); R4=H.

3) NON GST Generator (CSS)

Groups by address (Column C). Emits 3 lines per property: P2=Cleaning/Linen Fees (ΣW), P3=Comprende Management Fees (ΣM), P4=6.5% to IRD (ΣAA).
Columns: W empty, X=Property, Y=address, Z=NZD, AA=Owner Statements. L='[Month Year] (CSS)', M/N=last day of month.