A controller needs two views at once: what belongs in the books through the cutoff, and when money is expected to move. A job cost forecast estimates remaining cost and expected completion margin; cutoff review determines what belongs in the books. A cash forecast adds payment and collection timing. Neither replaces a reconciliation.
Prepare the close
- Choose the cutoff and scope. Identify the period, entities and jobs included. Gather bank statements, ledger balances, open payables and receivables, retainage schedules and job-cost support for that date.
- Resolve or assign exceptions. Compare each available subledger to its control account and investigate differences without offsetting unrelated entities or balances. Mark missing evidence or an unavailable check for follow-up; it is not a pass.
- Ask the PM for remaining cost. Review the budget, approved commitments and posted costs with the person closest to the work. Record the cost-to-complete, date and reason for material changes. Estimated cost at completion combines actual cost and remaining cost; it is an estimate, not cash due in the period.
- Review and sign off independently. A second person checks the evidence and open items. If the underlying postings or assumptions change, update the affected review before closing.
The Accounting module is live. Dated PM cost-to-complete inputs, AR reconciliation, approved WIP posting and close checks are implemented. Review historical source coverage, calculation exceptions and the evidence for your company before relying on a close result. Follow the forecast-to-close workflow; a missing or failed check is not a passing reconciliation.
Turn the estimates into a weekly cash view
Start with a verified opening cash balance. For each of the next 13 weeks, list expected owner receipts, retainage releases, payroll, subcontract and supplier payments, overhead and other known cash movements. Use the expected payment date, not the date a cost was incurred or an invoice was issued. Sum each week’s inflows and outflows and carry the ending balance forward as the next opening balance.
For example, $100,000 opening cash plus $30,000 expected receipts less $80,000 expected payments leaves $50,000 at week end. If the receipt moves to the following week, the first week’s projection falls to $20,000. Confirm whether that balance covers the commitments coming due; update the owner when the answer changes.
Each week, compare the prior forecast with actual receipts and payments, move late items to realistic dates, and record why significant assumptions changed. Keep retainage separate from current collections and avoid counting an expected release twice. The cash flow calculator illustrates a single job; company overhead and timing still need attention.
Share this article