The Retainage Summary Report provides a comprehensive view of retainage held, released, and remaining balance across all your projects. Use this report for financial planning and accounting reconciliation.
What the Report Shows
Held
Total retainage withheld across all projects
Released
Total retainage released to date
Balance
Outstanding retainage still owed
Running the Report
- Navigate to Reports in the sidebar
- Click on Retainage Summary
- Select project scope (all projects or specific ones)
- Choose to include/exclude closed projects
- Click Generate Report
Report Columns
| Column | Description |
|---|---|
| Project | Project name and number |
| Contract Amount | Original contract plus approved change orders |
| Total Billed | Sum of all pay applications submitted |
| Retainage % | Project retainage percentage |
| Retainage Held | Total withheld to date |
| Retainage Released | Amount released (at substantial/final completion) |
| Balance Due | Retainage still owed (Held - Released) |
Retainage Per Project
Click on any project row to see a detailed breakdown of retainage by billing period.
Using for Accounting Reconciliation
Export this report to reconcile with your Retainage Receivable account in QuickBooks or Xero. The total balance should match your retainage asset account.
Reconciliation Steps
- Generate the Retainage Summary Report
- Export as CSV or XLSX
- Compare "Balance Due" total to your Retainage Receivable balance
- Investigate any discrepancies
Monthly Reconciliation
Run this report at month-end to ensure your books accurately reflect outstanding retainage.
Need help? Contact our support team at support@slpwlk.io