61 Seacourt — Financial Analysis Dashboard

Generated: 2026-03-07 07:07:47

Errors: 0 Warnings: 6 Info: 5

Executive Summary

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

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

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.31 (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.21, 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.53 vs expected $7,963.48 (diff $-102.95, 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.19 (diff $+7,775.09)
  • 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.01 across 9 payments
Show 10 detail(s)
  • Total: $373,239.01 (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)

INFO G1: AI pass G1 failed "Could not resolve authentication method. Expected either api_key or auth_token to be set. Or for one of the `X-Api-Key` or `Authorization` headers to be explicitly omitted"
INFO G2: AI pass G2 failed "Could not resolve authentication method. Expected either api_key or auth_token to be set. Or for one of the `X-Api-Key` or `Authorization` headers to be explicitly omitted"
INFO G3: AI pass G3 failed "Could not resolve authentication method. Expected either api_key or auth_token to be set. Or for one of the `X-Api-Key` or `Authorization` headers to be explicitly omitted"
INFO G4: AI pass G4 failed "Could not resolve authentication method. Expected either api_key or auth_token to be set. Or for one of the `X-Api-Key` or `Authorization` headers to be explicitly omitted"
Generated: 2026-03-07 07:07:47
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?"