For each project and subcontractor: what you awarded them, what they have billed, what is left to bill, the retention you are holding and the net payable.
When to use it
Before you pay a subcontractor, and when you need to know how much of an award is still open.
Before you start
- Subcontract awards have been raised against the project and the party.
- The subcontractors' bills are posted. Only posted bills count as billed.
- You need view access to the Construction reports.
Where to find it
Reports > Construction Co. > Subcontractor Statement.
The fields on this screen
This report has no filter controls. Use the column search above the grid to narrow it to one project or one subcontractor.
How it works
- One row is one project and one subcontractor, however many awards and bills sit behind it. Every money column has a total at the foot.
- Awards and Bills count the documents behind the row. They are the fastest way to spot a party who has billed without an award, or the other way round.
- Awarded is the value of the award lines. Billed is the value of their posted bills only. A bill still in draft is not counted anywhere on this row.
- Left to Bill is Awarded less Billed. A negative figure means they have billed more than they were awarded. That needs a variation to the award, not a payment.
- Retention Held and Other Ded. are the deductions taken on those posted bills.
- Net Payable is Billed less Retention Held less Other Ded. It is the value of certified work after deductions, not a bank balance, because what you have already paid them is not subtracted. Check the party's ledger for what is actually outstanding.
Tips and common mistakes
- Net Payable is not the amount to pay. Take off the payments already made, from the party ledger, before you release anything.
- A party with Awards nil and Bills above nil has been billing against no award. Raise the award, or the work has no agreed rate behind it.