Construction Accounting Dashboard
Management view — drill down from company totals to job, cost code, vendor and transaction.
Jobs Requiring Attention
| Job | Project | Issue | Amount |
|---|---|---|---|
| 201220912 | Blue Ridge Mountain Service Center | Cost over budget | $28,663.06 |
| 201220912 | Blue Ridge Mountain Service Center | Pending C/O | $3,521.00 |
Control Checks
✓ Trial Balance in balance
✓ AP control reconciled
! 3 contractual documents need review
! 2 pending change orders
Jobs / Projects
One place for contract, superintendent, dates, billing, commitments, change orders and cost status.
| Job No. | Project | Supervisor | Contract | Approved C/O | Invoiced | Paid | Status |
|---|---|---|---|---|---|---|---|
| 201220912 | Blue Ridge Mountain Service Center | Tex Holdum | $302,402.00 | $22,500.00 | $247,552.23 | $185,245.10 | Active |
Job Cost Analysis
Project 201220912 — Blue Ridge Mountain Service Center
| Cost / Task | Code | Vendor Name | Budget | Original Vendor Commitments | Change Order | Total Contract incl C/O | Paid to Date | Invoiced awaiting Payment | Balance due under contract | Over / Under Budget | Contractual paperwork |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 — Site Work | $8,650.00 | $3,128.26 | $0.00 | $3,128.26 | $3,128.26 | $0.00 | $0.00 | ($5,521.74) | |||
| 100 | Windy Gal | $750.00 | $25.00 | $775.00 | $750.00 | $25.00 | $0.00 | OK | |||
| 3300 — Rough Carpentry | $22,500.00 | $17,045.48 | $7,230.00 | $24,275.48 | $19,813.48 | $1,200.00 | $3,562.00 | $1,775.48 | |||
| 3300 | Bruce Van Allen | $11,700.00 | $7,230.00 | $18,930.00 | $14,468.00 | $1,200.00 | $3,562.00 | OK | |||
| 4800 — Hard Tile | $40,385.00 | $59,014.57 | $0.00 | $59,014.57 | $41,500.00 | $7,800.00 | $9,714.57 | $18,629.57 | |||
| SUBTOTAL | $262,958.00 | $226,014.94 | $10,880.00 | $234,294.94 | $175,636.21 | $28,006.00 | $22,252.73 | ($28,663.06) |
Job Accounts Receivable
| Contract | Approved C/O | Pending C/O | Total Contract | Invoiced | Paid to Date | Balance to Invoice | Balance Due incl Pending |
|---|---|---|---|---|---|---|---|
| $302,402.00 | $22,500.00 | $3,521.00 | $324,902.00 | $247,552.23 | $185,245.10 | $77,349.77 | $143,177.90 |
Accounts Payable
Vendor invoices, commitments, payments and job-cost distribution.
AP Workflow
Invoice → Vendor → Job/Cost Code → Commitment check → Approval → Check/Payment → General Ledger → Job Cost.
Accounts Receivable
Contract billing, approved/pending change orders, receipts and job balance.
| Job | Contract + Approved C/O | Pending C/O | Invoiced | Paid | Balance Due |
|---|---|---|---|---|---|
| 201220912 | $324,902.00 | $3,521.00 | $247,552.23 | $185,245.10 | $139,656.90 |
General Ledger
Account detail, balances, journal sources and reconciliation controls.
Reconciliation Controls
GL debits = GL credits
AP subsidiary ledger = AP control account
Job Cost distribution reconciles to GL job-cost accounts
Work in Progress
Bonding / management WIP view.
| Job | Contract | Estimated Cost | Cost to Date | % Complete | Earned Revenue | Billings | Over / Under Billing |
|---|---|---|---|---|---|---|---|
| 201220912 | $324,902 | $262,958 | $234,295 | 89.1% | $289,491 | $247,552 | $41,939 |
Reports
AccuTrax report center — screen, PDF and Excel output.
Job Accounting
Job Cost Analysis
Job Cost Detail
Commitment Status
Change Order Log
Job Accounts Receivable
WIP / Bonding WIP
Financial
Operating Statement
Balance Sheet
Trial Balance
GL Account Detail
GL Account Balance
Purchase Journal
Sales Journal
Check Register