Construction business reports

Reports puts finance and sales on a single page: four figures at the top, four charts underneath, all fed from the records themselves. Revenue for the running year, open receivables, backlog meaning work committed but not yet billed, and the volume of the pipeline. The monthly rebuild in a spreadsheet, followed by the argument about whose version is the current one, stops being part of the month end.

Revenue by month draws the last eight months as columns, orange for money already collected and gray for what is still open, with the monthly total printed compactly above each column. Contract volume per site manager sorts responsibility from largest to smallest. Pipeline by phase shows open opportunities from lead through to contract, with a gray construction row for comparison. Open items by age separates balances not yet due from one to fourteen days late and longer.

A status line at the foot states when the analysis was drawn and how many documents went into it, so a figure can be traced instead of believed. Everything calculates live: a payment received or an opportunity moved to another phase changes figure and chart on the next call. From the receivable ages the way on leads into invoices, where the same overdue balances are filtered, dunned and chased case by case.