Advanced
Construction WIP schedule: percent complete and billings
Builds a construction Work-in-Progress (WIP) schedule including percent complete, revenue recognized, billings, and under/over billings. Useful for contractors and auditors.
Create a construction WIP schedule for {contractor_name} for {period_end_date}.
Inputs:
- Job list with contract price and approved change orders: {job_contracts}
- Costs incurred to date and estimated cost to complete: {job_costs_estimates}
- Billings to date and retainage: {billings_retainage}
- Revenue recognition method (cost-to-cost, etc.): {method}
- Any claims/unapproved change orders: {claims}
Output:
1) WIP table by job: contract value, total est cost, costs to date, % complete, revenue to date, revenue this period, billings to date, over/under billing.
2) Exception flags (loss jobs, large estimate changes, unapproved COs).
3) Suggested journal entries (under/over billings, loss accruals).
4) Documentation checklist for auditors/banks.
Be explicit about assumptions and rounding.Related Prompts
Industry-Specific
IntermediateConstruction retainage reconciliation and aging action plan
Reconciles retainage receivable/payable, flags aged items, and proposes collection/settlement actions. Useful for improving cash flow and close accuracy.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0
Industry-Specific
IntermediateReal estate development cost capitalization tracker
Creates a tracker for development costs, capitalization rules, and allocation to projects/units. Useful for developers and real estate accountants managing multi-project portfolios.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0
Industry-Specific
AdvancedReal estate sale/leaseback screening (ASC 842/IFRS 16)
Screens a real estate transaction for sale/leaseback accounting and identifies required data for recognition and measurement. Useful for corporate real estate and technical accounting.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0