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
IntermediateStandard costing variance dashboard (PPV, labor, overhead)
Creates a variance dashboard structure and investigation playbook for standard costing variances. Useful for plant controllers and operations reviews.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
75
Industry-Specific
AdvancedSaaS revenue waterfall: bookings โ billings โ revenue โ cash
Builds a SaaS revenue waterfall reconciling bookings, billings, deferred revenue, and revenue recognition. Useful for FP&A and accounting alignment and board reporting.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
74
Industry-Specific
IntermediateARR/MRR rollforward with churn, expansion, and cohort view
Creates an ARR/MRR rollforward and cohort-based retention view using subscription data. Useful for SaaS metrics reporting and investor updates.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
69