61 Seacourt — Financial Analysis Dashboard

Generated: 2026-03-11 15:50:06

Errors: 0 Warnings: 34 Info: 26

Executive Summary

This analysis covers 28 invoices containing 662 transactions, with total project spend of $2,672,153.70. Subcontractor costs account for $1,603,374.82, wages $381,973.14, builder's margin $350,137.49, and fixed fee disbursements $373,239.00.

Financial checks identified 0 error(s) and 6 warning(s) requiring attention.

AI analysis flagged 28 additional finding(s) for manual review.

The effective margin rate across all invoices is 17.6% (nominal rate: 18%).

Interactive Charts

Financial Checks (F1-F7)

WARNING F1: Builder's margin validation (18%) 14 invoice(s) with margin discrepancies
Show 14 detail(s)
  • INV 1: Margin $11,488.66 vs expected $11,469.74 (diff $+18.92, actual rate 18.0%)
  • INV 10: No margin line found, but has $83,285.85 in costs
  • INV 13: Margin $7,369.81 vs expected $7,481.48 (diff $-111.67, actual rate 17.7%)
  • INV 15: Margin $35,497.08 vs expected $28,037.84 (diff $+7,459.24, actual rate 22.8%)
  • INV 16: Margin $9,617.85 vs expected $9,704.49 (diff $-86.64, actual rate 17.8%)
  • INV 18: Margin $13,741.38 vs expected $13,753.37 (diff $-11.99, actual rate 18.0%)
  • INV 20: Margin $13,729.94 vs expected $13,854.96 (diff $-125.02, actual rate 17.8%)
  • INV 22: Margin $10,015.82 vs expected $8,616.30 (diff $+1,399.52, actual rate 20.9%)
  • INV 23: Margin $28,138.33 vs expected $28,233.24 (diff $-94.91, actual rate 17.9%)
  • INV 24: Margin $11,522.08 vs expected $11,486.71 (diff $+35.37, actual rate 18.1%)
  • INV 27: Margin $21,604.24 vs expected $22,104.44 (diff $-500.20, actual rate 17.6%)
  • INV 3: Margin $3,681.04 vs expected $3,731.40 (diff $-50.36, actual rate 17.8%)
  • INV 5: Margin $7,860.52 vs expected $7,963.48 (diff $-102.96, actual rate 17.8%)
  • INV 7: Margin $4,059.97 vs expected $4,122.92 (diff $-62.95, actual rate 17.7%)
WARNING F2: Invoice totals cross-check 9 discrepancy(ies)
Show 9 detail(s)
  • INV 1: Sheet says $118,112.58, transactions sum to $116,680.43 (diff $+1,432.15)
  • INV 2: Sheet says $815.19, transactions sum to $4,548.73 (diff $-3,733.54)
  • INV 9: Sheet says $62,824.93, transactions sum to $82,071.02 (diff $-19,246.09)
  • INV 10: Sheet says $97,920.13, transactions sum to $82,983.19 (diff $+14,936.94)
  • INV 14: Sheet says $41,215.57, transactions sum to $45,747.57 (diff $-4,532.00)
  • INV 16: Sheet says $33,191.24, transactions sum to $33,183.54 (diff $+7.70)
  • INV 22: Sheet says $65,659.28, transactions sum to $57,884.18 (diff $+7,775.10)
  • Pool: Sheet says $439,880.59, transactions sum to $340,148.51 (diff $+99,732.08)
  • INV 24: Sheet says $75,533.62, transactions sum to $75,337.12 (diff $+196.50)
INFO F3: Fixed fee disbursement tracking $373,239.00 across 9 payments
Show 10 detail(s)
  • Total: $373,239.00 (9 payments)
  • INV 1: $41,471.00
  • INV 11: $41,471.00
  • INV 13: $41,471.00
  • INV 15: $41,471.00
  • INV 17: $41,471.00
  • INV 3: $41,471.00
  • INV 5: $41,471.00
  • INV 7: $41,471.00
  • INV 9: $41,471.00
WARNING F4: Wage bill plausibility Mean $14,147.15/period, 27 entries
Show 3 detail(s)
  • Wage statistics: mean=$14,147.15, σ=$6,513.39, min=$3,854.86, max=$27,130.83 (27 entries)
  • Duplicate wage period '01 nov 24 - 26 jan 25' in: INV 1, INV 3, INV 4, INV 5, INV 6, INV 7, INV 8
  • Duplicate wage period '3rd may - 16th may' in: INV 10, INV 11, INV 12, INV 13, INV 14, INV 15, INV 16, INV 17, INV 18, INV 19, INV 20, INV 21, INV 22, INV 23, INV 24, INV 25, INV 26, INV 27, INV 9
WARNING F5: Potential duplicate charges 105 potential duplicate(s)
Show 105 detail(s)
  • 365 Site Services: $264.00 on rows 655 (INV 27) and 660 (INV 27), 28 days apart
  • City Of Newcastle: $122.19 on rows 8 (INV 1) and 10 (INV 1), 0 days apart
  • 1300TempFence: $108.90 on rows 34 (INV 3) and 63 (INV 5), 28 days apart
  • 1300TempFence: $108.90 on rows 93 (INV 7) and 137 (INV 9), 30 days apart
  • 1300TempFence: $108.90 on rows 196 (INV 12) and 251 (INV 14), 30 days apart
  • 1300TempFence: $108.90 on rows 355 (INV 18) and 419 (INV 20), 30 days apart
  • 1300TempFence: $108.90 on rows 492 (INV 22) and 580 (INV 25), 30 days apart
  • Central Waste Station: $1,144.00 on rows 14 (INV 1) and 15 (INV 1), 0 days apart
  • Central Waste Station: $1,144.00 on rows 14 (INV 1) and 19 (INV 1), 2 days apart
  • Central Waste Station: $1,144.00 on rows 14 (INV 1) and 20 (INV 1), 2 days apart
  • Central Waste Station: $1,144.00 on rows 14 (INV 1) and 11 (INV 1), 9 days apart
  • Central Waste Station: $1,144.00 on rows 14 (INV 1) and 12 (INV 1), 10 days apart
  • Central Waste Station: $1,144.00 on rows 15 (INV 1) and 19 (INV 1), 2 days apart
  • Central Waste Station: $1,144.00 on rows 15 (INV 1) and 20 (INV 1), 2 days apart
  • Central Waste Station: $1,144.00 on rows 15 (INV 1) and 11 (INV 1), 9 days apart
  • Central Waste Station: $1,144.00 on rows 15 (INV 1) and 12 (INV 1), 10 days apart
  • Central Waste Station: $1,144.00 on rows 19 (INV 1) and 20 (INV 1), 0 days apart
  • Central Waste Station: $1,144.00 on rows 19 (INV 1) and 11 (INV 1), 7 days apart
  • Central Waste Station: $1,144.00 on rows 19 (INV 1) and 12 (INV 1), 8 days apart
  • Central Waste Station: $1,144.00 on rows 20 (INV 1) and 11 (INV 1), 7 days apart
  • Central Waste Station: $1,144.00 on rows 20 (INV 1) and 12 (INV 1), 8 days apart
  • Central Waste Station: $1,144.00 on rows 11 (INV 1) and 12 (INV 1), 1 days apart
  • Central Waste Station: $759.00 on rows 27 (INV 3) and 47 (INV 4), 8 days apart
  • NHS: $151.33 on rows 168 (INV 10) and 170 (INV 10), 0 days apart
  • NHS: $360.72 on rows 375 (INV 18) and 429 (INV 20), 26 days apart
  • Kennards Hire: $260.00 on rows 42 (INV 4) and 72 (INV 6), 24 days apart
  • Kennards Hire: $100.00 on rows 55 (INV 5) and 73 (INV 6), 13 days apart
  • Kennards Hire: $100.00 on rows 55 (INV 5) and 102 (INV 7), 21 days apart
  • Kennards Hire: $100.00 on rows 55 (INV 5) and 94 (INV 7), 28 days apart
  • Kennards Hire: $100.00 on rows 73 (INV 6) and 102 (INV 7), 8 days apart
  • Kennards Hire: $100.00 on rows 73 (INV 6) and 94 (INV 7), 15 days apart
  • Kennards Hire: $100.00 on rows 73 (INV 6) and 125 (INV 8), 22 days apart
  • Kennards Hire: $100.00 on rows 73 (INV 6) and 119 (INV 8), 28 days apart
  • Kennards Hire: $100.00 on rows 102 (INV 7) and 94 (INV 7), 7 days apart
  • Kennards Hire: $100.00 on rows 102 (INV 7) and 125 (INV 8), 14 days apart
  • Kennards Hire: $100.00 on rows 102 (INV 7) and 119 (INV 8), 20 days apart
  • Kennards Hire: $100.00 on rows 102 (INV 7) and 132 (INV 9), 29 days apart
  • Kennards Hire: $100.00 on rows 94 (INV 7) and 125 (INV 8), 7 days apart
  • Kennards Hire: $100.00 on rows 94 (INV 7) and 119 (INV 8), 13 days apart
  • Kennards Hire: $100.00 on rows 94 (INV 7) and 132 (INV 9), 22 days apart
  • Kennards Hire: $100.00 on rows 94 (INV 7) and 135 (INV 9), 27 days apart
  • Kennards Hire: $100.00 on rows 125 (INV 8) and 119 (INV 8), 6 days apart
  • Kennards Hire: $100.00 on rows 125 (INV 8) and 132 (INV 9), 15 days apart
  • Kennards Hire: $100.00 on rows 125 (INV 8) and 135 (INV 9), 20 days apart
  • Kennards Hire: $100.00 on rows 119 (INV 8) and 132 (INV 9), 9 days apart
  • Kennards Hire: $100.00 on rows 119 (INV 8) and 135 (INV 9), 14 days apart
  • Kennards Hire: $100.00 on rows 132 (INV 9) and 135 (INV 9), 5 days apart
  • (DD) Kennards Hire: $776.00 on rows 248 (INV 14) and 262 (INV 15), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 248 (INV 14) and 310 (INV 16), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 262 (INV 15) and 310 (INV 16), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 262 (INV 15) and 340 (INV 17), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 310 (INV 16) and 340 (INV 17), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 310 (INV 16) and 354 (INV 18), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 340 (INV 17) and 354 (INV 18), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 340 (INV 17) and 390 (INV 19), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 354 (INV 18) and 390 (INV 19), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 354 (INV 18) and 437 (INV 20), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 390 (INV 19) and 437 (INV 20), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 390 (INV 19) and 467 (INV 21), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 437 (INV 20) and 467 (INV 21), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 437 (INV 20) and 486 (INV 22), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 467 (INV 21) and 486 (INV 22), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 467 (INV 21) and 509 (INV 23), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 486 (INV 22) and 509 (INV 23), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 486 (INV 22) and 567 (INV 24), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 509 (INV 23) and 567 (INV 24), 14 days apart
  • (DD) Kennards Hire: $776.00 on rows 509 (INV 23) and 577 (INV 25), 28 days apart
  • (DD) Kennards Hire: $776.00 on rows 567 (INV 24) and 577 (INV 25), 14 days apart
  • Clean Valley: $646.80 on rows 101 (INV 7) and 114 (INV 8), 20 days apart
  • Clean Valley: $646.80 on rows 101 (INV 7) and 121 (INV 8), 21 days apart
  • Clean Valley: $646.80 on rows 114 (INV 8) and 121 (INV 8), 1 days apart
  • Recycle Central Group: $572.00 on rows 136 (INV 9) and 129 (INV 9), 10 days apart
  • Recycle Central Group: $572.00 on rows 136 (INV 9) and 183 (INV 11), 29 days apart
  • Recycle Central Group: $572.00 on rows 129 (INV 9) and 183 (INV 11), 19 days apart
  • Recycle Central Group: $572.00 on rows 129 (INV 9) and 185 (INV 11), 21 days apart
  • Recycle Central Group: $572.00 on rows 183 (INV 11) and 185 (INV 11), 2 days apart
  • Recycle Central Group: $1,140.00 on rows 214 (INV 12) and 213 (INV 12), 3 days apart
  • Recycle Central Group: $385.00 on rows 212 (INV 12) and 228 (INV 13), 6 days apart
  • Recycle Central Group: $385.00 on rows 212 (INV 12) and 249 (INV 14), 20 days apart
  • Recycle Central Group: $385.00 on rows 228 (INV 13) and 249 (INV 14), 14 days apart
  • Scaffbuilt Solutions: $968.00 on rows 246 (INV 14) and 283 (INV 15), 14 days apart
  • Scaffbuilt Solutions: $968.00 on rows 246 (INV 14) and 312 (INV 16), 29 days apart
  • Scaffbuilt Solutions: $968.00 on rows 283 (INV 15) and 312 (INV 16), 15 days apart
  • Scaffbuilt Solutions: $968.00 on rows 283 (INV 15) and 341 (INV 17), 28 days apart
  • Scaffbuilt Solutions: $968.00 on rows 312 (INV 16) and 341 (INV 17), 13 days apart
  • Scaffbuilt Solutions: $968.00 on rows 312 (INV 16) and 380 (INV 18), 27 days apart
  • Scaffbuilt Solutions: $968.00 on rows 341 (INV 17) and 380 (INV 18), 14 days apart
  • Scaffbuilt Solutions: $968.00 on rows 341 (INV 17) and 403 (INV 19), 29 days apart
  • Scaffbuilt Solutions: $968.00 on rows 380 (INV 18) and 403 (INV 19), 15 days apart
  • Scaffbuilt Solutions: $968.00 on rows 380 (INV 18) and 436 (INV 20), 28 days apart
  • Scaffbuilt Solutions: $968.00 on rows 403 (INV 19) and 436 (INV 20), 13 days apart
  • Scaffbuilt Solutions: $330.00 on rows 488 (INV 22) and 514 (INV 23), 16 days apart
  • Hancock Speedway: $216.06 on rows 421 (INV 20) and 464 (INV 21), 3 days apart
  • Skips And Scrap Recycling: $935.00 on rows 286 (INV 15) and 284 (INV 15), 2 days apart
  • Skips And Scrap Recycling: $935.00 on rows 286 (INV 15) and 285 (INV 15), 8 days apart
  • Skips And Scrap Recycling: $935.00 on rows 286 (INV 15) and 300 (INV 16), 22 days apart
  • Skips And Scrap Recycling: $935.00 on rows 284 (INV 15) and 285 (INV 15), 6 days apart
  • Skips And Scrap Recycling: $935.00 on rows 284 (INV 15) and 300 (INV 16), 20 days apart
  • Skips And Scrap Recycling: $935.00 on rows 285 (INV 15) and 300 (INV 16), 14 days apart
  • Skips And Scrap Recycling: $935.00 on rows 440 (INV 20) and 471 (INV 21), 13 days apart
  • Skips And Scrap Recycling: $935.00 on rows 440 (INV 20) and 448 (INV 21), 21 days apart
  • Skips And Scrap Recycling: $935.00 on rows 471 (INV 21) and 448 (INV 21), 8 days apart
  • Skips And Scrap Recycling: $935.00 on rows 471 (INV 21) and 512 (INV 23), 29 days apart
  • Skips And Scrap Recycling: $935.00 on rows 448 (INV 21) and 512 (INV 23), 21 days apart
  • Solmer Civil: $55,000.00 on rows 547 (Pool) and 549 (Pool), 20 days apart
WARNING F6: Credit note tracking 14 credit(s), 10 unmatched
Show 14 detail(s)
  • INV 3 row 30: $-279.77 from NHS — credit [matched]
  • INV 5 row 60: $-572.00 from Central Waste Station — Skip Bin [matched]
  • INV 7 row 104: $-349.72 from NHS — 240 X 45MM LVL13 H2 6.0M [UNMATCHED]
  • INV 10 row 169: $-151.33 from NHS — Credit for steel door frame [matched]
  • INV 10 row 171: $-151.33 from NHS — Credit for steel door frame [matched]
  • INV 13 row 221: $-620.40 from PW Saddington & Sons Pty LTD — Credit for scratch coat exposure [UNMATCHED]
  • INV 15 row 280: $-30.73 from NHS — Credit for invoice 1597 [UNMATCHED]
  • INV 16 row 320: $-489.06 from NHS — Credit for Framing [UNMATCHED]
  • INV 16 row 330: $-29,859.11 from Bishop & Hart — Credit from previous invoice (margin on disbursement incorrectloy charged) [UNMATCHED]
  • INV 18 row 377: $-66.59 from NHS — Credit for Framing [UNMATCHED]
  • INV 20 row 424: $-694.54 from NHS — Credit for invoice 1597 [UNMATCHED]
  • INV 23 row 523: $-178.61 from NHS — Credit for Treated Pine [UNMATCHED]
  • INV 23 row 530: $-348.67 from NHS — Blue Structural MGP10 Pine 6.0M $5000 up for grabs with exclusive NHS NewTechWood promotion between 1/10/25 to 31/1/26. [UNMATCHED]
  • INV 27 row 644: $-2,778.89 from NHS — Credit for Plasterboard [UNMATCHED]
WARNING F7: Unusual category review 3 transaction(s) in unusual categories
Show 4 detail(s)
  • Totals by unusual category: 447 - Marketing | Social Media: $15,466.00 486 - Staff Amenities: $50.34
  • INV 1 row 7: $50.34 — Foodworks — 486 - Staff Amenities — Direct business cost not associated with Project.
  • INV 21 row 475: $15,026.00 — Newcastle Home Staging — 447 - Marketing | Social Media — Plasterboard sheeting and setting at 61 seacourt ave Dudley
  • INV 25 row 585: $440.00 — Digital Underground Pty Ltd — 447 - Marketing | Social Media — Minimum call out - Seacourt Dudley shoot - 10/12/25 (Operator: Lachy)

AI Analysis (G1-G4)

WARNING G1: Abnormal Disbursement Pattern Multiple invoices contain $41,471 disbursements while others have $0, suggesting irregular cash flow management or potential duplicate charges.
Show 4 detail(s)
  • INV 1, 3, 5, 7, 9, 11, 13, 15, 17 all contain exactly $41,471 disbursement
  • This represents 9 out of 27 invoices with identical disbursement amounts
  • Remaining invoices (except Pool) show $0 disbursement
  • Pattern suggests either systematic billing or potential duplicate allocation
WARNING G1: Disproportionate Margin in INV 1 INV 1 shows a margin of $11,489 (9.8% of total) which is notably higher than most similar-sized invoices.
Show 4 detail(s)
  • INV 1 total: $116,680 with margin of $11,489
  • Base costs (subcontractors + wages): $63,720
  • Margin percentage: 9.8% vs typical 5-7% for comparable invoices
  • INV 5 ($93,001) shows margin of only $7,861 (8.4%) with similar cost structure
INFO G1: Extraordinary Invoice Amount - INV 15 INV 15 is significantly larger than most invoices at $232,703, representing approximately 2x the median invoice value.
Show 5 detail(s)
  • INV 15 total: $232,703
  • Median invoice value: ~$82,000
  • High subcontractor costs: $128,635 (55.3% of total)
  • Also includes substantial margin of $35,497
  • Spike from INV 14 ($45,748) to INV 15 is 408% increase
INFO G1: Unusual Wage Trajectory Wages show an unusual increasing trend from early invoices to mid-project, then stabilize with some volatility.
Show 5 detail(s)
  • INV 2-9: wages range $3,855-$15,161
  • INV 10-15: wages spike to $16,961-$27,131 (peak at INV 15)
  • INV 16-27: wages drop and stabilize at $4,588-$23,077
  • Suggests potential labor-intensive phase in middle of project
  • High wages in INV 12 ($21,930) and INV 14 ($22,795) without corresponding high subcontractor costs
WARNING G1: Exceptional Credit in INV 16 INV 16 contains a credit of -$30,348, which is substantially larger than all other credits and represents 91.5% of the invoice total.
Show 5 detail(s)
  • INV 16 shows: Total $33,184 with credit of -$30,348
  • Net amount after credit: only $2,836
  • All other invoices have credits ranging from $0 to -$2,779
  • Suggests either a significant return/adjustment or potential data error
  • Requires investigation into the nature of this credit
WARNING G1: Margin Inconsistency in INV 10 INV 10 shows zero margin despite $66,324 in subcontractor costs and $16,961 in wages, which is anomalous.
Show 5 detail(s)
  • INV 10 total: $82,983 with $0 margin
  • Base costs: $83,285 (exceeds total by $302)
  • Only invoice with $0 margin and substantial costs
  • Credit of -$303 nearly matches the overage, suggesting possible correction
  • Pattern indicates either cost-pass-through invoice or accounting adjustment
INFO G1: Large Consecutive Spike - INV 23 INV 23 shows a significant jump in subcontractor costs and total amount compared to surrounding invoices.
Show 5 detail(s)
  • INV 23 total: $184,462 with subcontractor costs of $146,074 (79.2%)
  • Represents 2.4x the cost of INV 22 ($57,884)
  • Notably low wages for the amount: $10,777
  • High margin of $28,138 consistent with large subcontractor invoices
  • Large credit of -$527 suggests minor adjustment
INFO G1: Pool Invoice Composition Pool invoice shows substantially different composition with only subcontractor costs and margin, no wages or disbursements.
Show 5 detail(s)
  • Pool total: $340,149
  • Subcontractors: $288,261 (84.8%)
  • Margin: $51,887 (15.2%)
  • No wages, disbursements, or credits
  • Suggests specialized/material-heavy work (likely pool construction)
WARNING G2: High Concentration Risk - NHS NHS represents 28.4% of total spend ($194,019) across 204 transactions, creating significant vendor concentration risk
Show 3 detail(s)
  • NHS appears in 25 invoices (INV 3-27), indicating it may be a primary contractor or umbrella vendor
  • High transaction count (204) suggests either many small items or potential for duplicate/erroneous entries
  • Recommend verifying if NHS is a main contractor that should be broken down into sub-component costs
WARNING G2: Single-Transaction Large Suppliers Multiple suppliers with significant amounts appearing in only one invoice warrant investigation
Show 5 detail(s)
  • Solmer Civil: $165,000 (3 transactions) - appears only in 'Pool' invoice
  • Wakefield Metal Roofing: $81,825 (1 transaction) - appears only in INV 15
  • T & H Excavations: $80,481 (1 transaction) - appears only in 'Pool' invoice
  • Aleve: $59,950 (1 transaction) - appears only in INV 17
  • These should be verified for completeness, accuracy, and whether they represent legitimate single-phase work
INFO G2: Potential Duplicate or Related Suppliers Multiple suppliers with similar naming patterns or related services identified
Show 4 detail(s)
  • Make Windows & Doors vs VRC Joinery Pty Ltd - both appear to provide similar services (windows/doors/joinery)
  • Newcastle Pro Plastering vs Newcastle Insulation - both Newcastle-based suppliers with similar service types
  • T & H Excavations vs S-Crete Concrete Contractors - both related to earthworks/ground preparation
  • Consider confirming these are distinct entities and not duplicate vendor records
INFO G2: Unusual Suppliers for Home Renovation Some supplier names appear unusual or potentially non-standard for a home renovation project
Show 3 detail(s)
  • Newcastle Home Staging ($15,026, INV 21) - staging services typically occur after renovation completion, not during
  • Master Builders Insurance Brokers ($39,795, INV 1) - insurance should be separate from renovation costs; verify this isn't a coding error
  • DRB Consulting Engineers Pty Ltd ($35,090) - verify scope and necessity for home renovation vs commercial project
INFO G2: High-Frequency, Low-Value Supplier Pattern Some suppliers show high transaction counts relative to total spend, suggesting possible rental/supply relationships
Show 4 detail(s)
  • (DD) Kennards Hire: $18,773 across 32 transactions (avg $587/transaction) - equipment rental supplier appearing in 21 invoices
  • Bunnings: $10,908 across 18 transactions (avg $606/transaction) - retail supplier with wide distribution across invoices
  • Scaffbuilt Solutions: $24,046 across 12 transactions (avg $2,004/transaction) - scaffolding rental across 13 invoices
  • Central Waste Station: $14,684 across 12 transactions - waste management appearing early in invoices (INV 1-5)
INFO G2: Invoice Coverage Anomalies Some invoices contain unusual supplier distributions suggesting possible data quality issues
Show 3 detail(s)
  • 'Pool' invoice appears as a distinct invoice identifier (not numbered like INV 1-27) containing 3 major suppliers: Solmer Civil ($165K), T & H Excavations ($80K), Star Glass Design ($44K)
  • Central Waste Station only appears in INV 1-5 (early phase), suggesting project phasing or timing issue
  • Verify if 'Pool' is a separate project or if naming conventions are consistent across all invoice identifiers
WARNING G3: INV 1 - Foodworks charge not project-related Line item explicitly states 'Direct business cost not associated with Project'
Show 1 detail(s)
  • $50.34 | Foodworks | Direct business cost not associated with Project.
WARNING G3: INV 1 - Duplicate waste removal charges Multiple similar waste removal line items from Central Waste Station may be duplicates
Show 6 detail(s)
  • $1,144.00 | Central Waste Station | Skips for waste
  • $1,144.00 | Central Waste Station | Skip Bin Hire
  • $1,144.00 | Central Waste Station | Waste removal
  • $1,144.00 | Central Waste Station | Waste removal
  • $1,144.00 | Central Waste Station | Waste removal
  • $1,144.00 | Central Waste Station | Waste removal
INFO G3: INV 3 - Credit note and matching charge Credit note of -$279.77 immediately followed by identical positive charge of $279.77 from NHS
Show 2 detail(s)
  • -$279.77 | CREDIT_NOTE | credit
  • $279.77 | NHS | Floor above Theatre
WARNING G3: INV 10 - Duplicate steel door frame charges with credits Steel door frame charged twice ($151.33 each) with matching credit notes, net effect zero
Show 4 detail(s)
  • $151.33 | NHS | Steel Door Frame
  • -$151.33 | CREDIT_NOTE | Credit for steel door frame
  • $151.33 | NHS | Steel Door Frame
  • -$151.33 | CREDIT_NOTE | Credit for steel door frame
WARNING G3: INV 6 - Personal reimbursement items Items charged that appear to be personal reimbursements rather than project costs
Show 2 detail(s)
  • $350.00 | MAT BROWN CONCRETE | Used Glenn's work credit card
  • $47.70 | BCS | Reimburse Shaun please
WARNING G3: INV 10 - Missing margin calculation INV 10 total is $82,983.19 but appears to be missing a MARGIN line item (ends abruptly at WAGES)
Show 2 detail(s)
  • Invoice ends with '$16,961.35 | WAGES | Wages for period 3rd May - 16th May' with no margin line item
  • All other invoices in this period include margin calculations
WARNING G3: INV 16 - Large credit note for margin error Significant credit note specifically referencing incorrect margin charge
Show 1 detail(s)
  • -$29,859.11 | CREDIT_NOTE | Credit from previous invoice (margin on disbursement incorrectly charged)
WARNING G3: INV 17 - Personal item and reimbursement charges Non-standard items that appear to be personal purchases or reimbursements
Show 2 detail(s)
  • $515.00 | Brands Direct Online | Robinhood Ironing Centre IC1300 White / Robinhood
  • $239.20 | Tile Warehouse | Please reimburse shaun. Used my own card as work credit card declined
WARNING G3: INV 18 - Non-project items in invoice Items appear to be personal goods not directly related to renovation
Show 1 detail(s)
  • $1,449.70 | COMETA | Foxydry Pro 160 cm drying rack
INFO G3: INV 20 - Large credit note without explanation Credit note amount suggests possible adjustment but lacks descriptive detail
Show 1 detail(s)
  • -$694.54 | CREDIT_NOTE | Credit for invoice 1597
INFO G3: INV 23 - Credit notes for materials Multiple credit notes suggesting adjustments to material charges
Show 2 detail(s)
  • -$178.61 | CREDIT_NOTE | Credit for Treated Pine
  • -$348.67 | CREDIT_NOTE | Blue Structural MGP10 Pine 6.0M
WARNING G3: INV 25 - Deposit pending invoice Invoice includes deposit for item awaiting separate invoice
Show 1 detail(s)
  • $9,300.00 | Glass Pool Windows Australia | Deposit paid an awaiting invoice
WARNING G3: INV 25 - Zero line item with no description Line item with $0.00 amount and no description
Show 1 detail(s)
  • $0.00 | Newcastle Cut N Drill
WARNING G3: INV 26 - Personal reimbursement Line item appears to be personal reimbursement
Show 1 detail(s)
  • $76.46 | Aluminium Specialties Group | Reimburse Rowan
WARNING G3: Multiple invoices - Repeated disbursement charges Same disbursement amount ($41,471.00) appears in nearly every invoice, suggesting potential systematic duplication
Show 11 detail(s)
  • INV 1: $41,471.00
  • INV 3: $41,471.00
  • INV 5: $41,471.00
  • INV 7: $41,471.00
  • INV 9: $41,471.00
  • INV 11: $41,471.00
  • INV 12: $41,471.00
  • INV 13: $41,471.00
  • INV 15: $41,471.00
  • INV 17: $41,471.00
  • Total from disbursement line items alone: $414,710.00
INFO G3: INV 11 - Asbestos testing charged to business card Asbestos testing invoice notes business card was used for payment
Show 1 detail(s)
  • $214.50 | ESP Environmental & Safety Professionals | Invoice for asbestos testing used the business card for payment
WARNING G3: INV 12 - Sand purchase using company card Item description indicates company card was used for personal supply purchase
Show 1 detail(s)
  • $33.00 | J E Mantle | Used company card. Bought sand for the bricklayer
WARNING G3: INV 19 - Personal item in invoice Non-renovation related item charged
Show 1 detail(s)
  • $1,451.14 | VRC Joinery Pty Ltd | Tall Cabinets Flat Pack / Pickup from Factory
INFO G3: Pool invoice - Structural balustrade unusually large Single item is substantial cost component of pool package
Show 1 detail(s)
  • $42,780.17 | Star Glass Design | External Structural Balustrade
WARNING G4: Duplicate Bishop & Hart Disbursement Entries Multiple invoices contain identical 'Disbursement of Fixed Fee for Preliminary Works' entries from Bishop & Hart for $41,471.00
Show 10 detail(s)
  • INV 1: $41,471.00 (no-date)
  • INV 3: $41,471.00 (no-date)
  • INV 5: $41,471.00 (no-date)
  • INV 7: $41,471.00 (no-date)
  • INV 9: $41,471.00 (no-date)
  • INV 11: $41,471.00 (no-date)
  • INV 13: $41,471.00 (no-date)
  • INV 15: $41,471.00 (no-date)
  • INV 17: $41,471.00 (no-date)
  • This exact amount appears 9 times across different invoices - potential duplicate billing or data entry error
INFO G4: Suspiciously Round Numbers in Waste Removal Multiple waste removal charges show identical round amounts suggesting potential standardized billing rather than actual usage
Show 5 detail(s)
  • Central Waste Station: $1,144.00 appears 5 times on similar dates in November 2024
  • Recycle Central Group: $572.00 appears 4 times on different dates
  • Clean Valley: $646.80 appears 3 times on different dates
  • Skips And Scrap Recycling: $935.00 appears 10+ times across multiple invoices
  • These patterns suggest possible duplicate charges or standardized billing without variation
INFO G4: Repeated Kennards Hire Prop Charges Multiple small identical Kennards Hire charges for 'Prop' items appearing across different invoices
Show 3 detail(s)
  • $100.00 for 'PROP' appears at least 8 times across different invoices (INV 5-7, INV 25-26)
  • $776.00 for 'SCAFFOLD' appears repeatedly (at least 15+ times) suggesting standard recurring charges
  • Pattern suggests either systematic billing or potential duplicate entries
WARNING G4: Missing Dates on Multiple High-Value Transactions Numerous transactions lacking specific dates, making audit trail difficult to establish
Show 6 detail(s)
  • Bishop & Hart entries with 'no-date' across all invoices (wages, disbursements, margins)
  • Make Windows & Doors: $48,576.00 (no-date) in INV 10
  • VRC Joinery Pty Ltd: $87,115.00 (no-date) in INV 23
  • Earp Bros - Surface Evolution: $14,206.25 (no-date) in INV 23
  • Cold Buster Underfloor Heating: $3,173.06 (no-date) in INV 21
  • Makes verification of transaction timing and chronological order impossible
INFO G4: Temporary Fence Hire - Identical Recurring Charges 1300TempFence charges appear identical across the entire project duration
Show 3 detail(s)
  • $108.90 appears exactly 11 times from November 2024 through February 2026
  • All charges are for 'Temp Fence Hire' with no variation in amount despite 3+ month duration
  • Suggests standardized monthly billing without adjustment for actual usage or changes
WARNING G4: Inconsistent Invoice Numbering and Dating Invoice structure shows anomalies in dating and categorization patterns
Show 4 detail(s)
  • INV 25 contains date '2025-01-01' which is before many earlier invoices (dated 2024-11 to 2025-02)
  • Pool-category transactions dated 2025-12-01 onwards, then jump to 2026-01-22 and 2026-02-11
  • INV 27 contains mixed dates: '2025-02-10' (impossible - before project start), '2025-11-06', '2025-11-19', '2025-11-27', '2025-12-04', etc.
  • Suggests data entry errors or transactions entered out of chronological order
WARNING G4: Duplicate Waste Removal Transactions Identical waste removal charges on consecutive dates suggesting duplicate entries
Show 4 detail(s)
  • Central Waste Station: $1,144.00 on 2024-11-05 AND $1,144.00 on 2024-11-05 (same date)
  • Central Waste Station: $1,144.00 on 2024-11-07 AND $1,144.00 on 2024-11-07 (same date)
  • Recycle Central Group: $572.00 on 2025-05-06 AND $572.00 on 2025-05-16 (both in same invoice INV 9)
  • Potential duplicate billing for waste services
INFO G4: Suspiciously High Equipment Supply Costs Multiple very large single invoices from specialized suppliers with no line-item detail
Show 6 detail(s)
  • Alfresco Outdoors & Heating: $13,482.10 - minimal description
  • Duramen Designs: $13,260.50 (50% deposit) - minimal detail
  • Wakefield Metal Roofing: $81,824.60 - complex service with limited description
  • Aleve: $59,950.00 - HVAC system but minimal breakdown
  • VRC Joinery: $87,115.00 - no line items provided
  • These large amounts lack supporting documentation details
WARNING G4: Credit Note Applied Against Margin Charges INV 16 contains negative margin adjustment suggesting prior overbilling or correction
Show 3 detail(s)
  • Bishop & Hart CREDIT_NOTE: -$29,859.11 for 'Credit from previous invoice (margin on disbursement incorrectly charged)'
  • This large credit suggests systematic errors in margin calculations across prior invoices
  • Indicates potential overcharging on disbursement margin in earlier periods
WARNING G4: Personal Expense Reimbursements Mixed with Project Costs Multiple transactions appear to be personal expenses or unclear business purpose
Show 7 detail(s)
  • Foodworks: $50.34 - explicitly noted 'Direct business cost not associated with Project'
  • Brands Direct Online: $515.00 for 'Robinhood Ironing Centre IC1300 White'
  • Tile Warehouse: $239.20 - 'Please reimburse shaun. Used my own card as work credit card declined'
  • Whitworths Marine & Leisure: $23.80 - 'Reimburse Kalan'
  • Aluminium Specialties Group: $76.46 - 'Reimburse Rowan'
  • J E Mantle: $265.00 - 'aggregate' with unclear project connection
  • These suggest inadequate expense controls and personal reimbursements commingled with project costs
INFO G4: NHS Multiple Credit Notes Multiple credit notes from NHS across different invoices suggest billing adjustments or reversals
Show 8 detail(s)
  • INV 3: -$279.77 credit (immediately followed by $279.77 regular charge - likely correcting duplicate)
  • INV 7: -$349.72 credit
  • INV 10: -$151.33 credit (immediately followed by $151.33 regular charge, then another -$151.33 credit and $151.33 charge)
  • INV 15: -$30.73 credit
  • INV 16: -$489.06 credit
  • INV 18: -$66.59 credit
  • INV 27: -$2,778.89 credit for 'Plasterboard'
  • Pattern suggests either corrections of errors or duplicate billing and reversal cycles
WARNING G4: Date Anomaly - INV 27 Historical Dates INV 27 contains multiple transactions dated before the project appears to have started
Show 8 detail(s)
  • 2025-02-10: Kennards Hire $776 (but INV 1 is dated 2024-10-25 onwards)
  • 2025-11-06: 365 Site Services $264
  • 2025-11-19: Premium Sliding Doors $1,795.65
  • 2025-11-27: DRB Consulting Engineers $3,960
  • 2025-12-04: 365 Site Services $264
  • 2025-12-10: Reece Australia $80.42
  • 2025-12-14: Make Windows & Doors $12,144
  • These dates out of sequence suggest transactions added to wrong invoice or data entry errors
INFO G4: Bishop & Hart Consistent Margin Percentage Bishop & Hart margin entries show 18% margin applied consistently but amounts vary significantly
Show 3 detail(s)
  • Multiple margin entries labeled 'Builders Margin 18%' appear across all invoices
  • Margin amounts: $11,488.66, $693.87, $3,681.04, $2,518.19, $4,059.97, $5,050.91, $6,193.22, $4,581.77, $11,919.53, $7,369.81, $6,978.44, $35,497.08, $13,741.38, $20,359.54, $13,200.10, $28,138.33, $51,887.06, $11,522.08, $12,229.44, $10,907.81, $21,604.24
  • Wide variance in margin amounts despite stated 18% suggests margins calculated on different bases or inconsistently applied
INFO G4: Incomplete Transaction Descriptions Many transactions lack sufficient detail for audit verification
Show 5 detail(s)
  • Metaland: $753.70 - no description
  • Kennards Hire: $260.00, $309.00 - no description
  • Central Waste Station: $759.00 - description only states supplier name
  • NHS: Multiple invoices with descriptions like 'Materials Purchased' or 'Materials - 1597' without itemization
  • Makes verification of appropriateness and necessity difficult
INFO G4: Pool Project Transactions - Separate or Integrated? Pool-related transactions appear under separate 'Pool' category with inconsistent treatment
Show 6 detail(s)
  • Star Glass Design: $42,780.17 for 'External Structural Balustrade'
  • Solmer Civil: $55,000 (three entries at $55,000 each for deposits/progress claims)
  • T & H Excavations: $80,481.28 for site support
  • Bishop & Hart Pool margin: $51,887.06
  • These are tracked separately from main project invoices (INV 1-27) suggesting potential scope creep or separate billing
  • No clear connection established to main renovation project
INFO G4: Duplicate / Near-Duplicate Steel Fabrication Orders Multiple steel fabrication charges from Bennat Fabrications suggest potential duplication
Show 6 detail(s)
  • INV 7: Bennat Fabrications $5,630.02 - 'Steel fabrication'
  • INV 12: Bennat Fabrications $9,551.08 - 'Supply and install steel'
  • INV 16: Bennat Fabrications $5,021.83 - 'Supply steel and carry out site work. 310 ub beam'
  • INV 22: Bennat Fabrications $3,289.00 - 'Supply and deliver 250 pfc galvanized'
  • INV 26: Bennat Fabrications $1,848.00 - 'Manufacture brackets/posts'
  • Multiple fabrication orders totaling $25,339.93 lack clear coordination documentation
INFO G4: Scaffold and Temporary Hire Pattern Scaffolding companies show repetitive identical charges across entire project
Show 4 detail(s)
  • Scaffbuilt Solutions: $968.00 appears 11+ times from June 2025 onwards
  • Kennards Hire Scaffold: $776.00 appears 15+ times from August 2025 onwards
  • 1300TempFence: $108.90 appears 11 times consistently
  • These identical recurring charges across 6+ months suggest fixed monthly fees rather than actual usage-based billing
WARNING G4: Large Deposits without Final Invoices Multiple large deposit payments lack corresponding final invoices for balance
Show 5 detail(s)
  • Duramen Designs: $13,260.50 (50% deposit on $26,521 total) - second payment not shown
  • Earp Bros - Surface Evolution: $7,020.00 deposit - final invoice shown separately
  • Glass Pool Windows Australia: $9,300.00 'Deposit paid and awaiting invoice' - no final invoice provided
  • VRC Joinery: $87,115.00 noted as 'Deposit & Check Measure' - unclear if final invoice processed
  • Makes it impossible to verify complete project cost for these vendors
INFO G4: Inconsistent Classification of Similar Items Similar items classified differently (REGULAR vs other types) across invoices
Show 3 detail(s)
  • Bishop & Hart payments show mix of REGULAR, DISBURSEMENT, WAGES, MARGIN, and CREDIT_NOTE classifications
  • Most transactions are REGULAR, but wage and margin entries appear as separate classifications
  • Lack of consistent categorization makes cost analysis and validation difficult
INFO G4: Suspiciously Round Amount - $5,000+ Multiple transactions showing exactly $5,000 or near-round multiples of $5,000
Show 6 detail(s)
  • DRB Consulting Engineers: $6,050.00 appears twice (INV 1 and INV 5)
  • DRB Consulting Engineers: $4,730.00 (INV 7)
  • DRB Consulting Engineers: $3,960.00 appears twice (INV 8, INV 27)
  • DRB Consulting Engineers: $1,430.00 (INV 9)
  • DRB Consulting Engineers: $14,960.00 (INV 27)
  • Multiple round professional service invoices suggest possible standardized fee structure or estimates rather than actual time-based invoicing
Generated: 2026-03-11 15:50:06
Invoice Chat
Ask me anything about the invoice data. For example:
  • "How much have we paid Make Windows?"
  • "Show me all invoices from the electrician"
  • "What's the total spent on tiling?"