Those familiar with construction accounting understand the importance of a jobs schedule which encapsulates what makes construction accounting different from all other types of accounting. It is the place where revenue is calculated over time (percentage of completion method).
As an auditor I get to see job schedules from a variety of size and type of construction companies. Unfortunately, I see construction companies that still have a tough time getting this schedule right.
What should be included in a jobs schedule?
Many specialized construction accounting systems do not do a particularly good job of producing an effective jobs schedule. This can be due to system design, capabilities, or simply because it takes too many resources to maintain a current schedule in the system. Therefore, some companies maintain a schedule outside of their accounting system, typically in Excel.
Whether a system generated or an outside schedule is used, an effective jobs schedule should include information that is relevant for financial reporting and to monitor jobs individually.
There are many variations of a jobs schedule, however to have an effective schedule the schedule must include the following four pieces of information for each job:
- Contract amount
- Estimated cost to complete
- Costs to date
- Billings to date
With these four pieces of information, the following can be calculated for each job and should also be included in the jobs schedule:
- Contract revenue
- Estimated profit
- Costs and estimated earnings in excess of billings (underbillings)
- Billings in excess of costs and estimated earnings (overbillings)
- Backlog (remaining performance obligations)
For financial reporting, a schedule that includes all the fields above will provide the following:
