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
AdvancedChannel rebates and returns accrual model (consumer goods)
Designs an accrual model for rebates, returns, and allowances common in consumer goods, with rollforward schedules. Useful for close and audit support.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
16
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
8
Industry-Specific
AdvancedHIPAA Security Rule Risk Analysis
Evaluates the technical safeguards for Protected Health Information (PHI).
Claude 3.5 SonnetGPT-4o
0
0
7