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
AdvancedInventory reserve framework: obsolescence, shrink, and markdowns
Designs an inventory reserve approach for obsolescence and markdowns with calculation templates and controls. Useful for retail and manufacturing close and audit support.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
26
Industry-Specific
BeginnerNonprofit: Functional Expense Allocation (990)
Allocates expenses between Program, Management, and Fundraising buckets.
GPT-4oGemini 1.5 Pro
0
0
20
Industry-Specific
IntermediateAccounting for Cryptocurrencies (Intangible vs. Fair Value)
Tracks the evolution of crypto accounting rules for corporate balance sheets.
GPT-4oClaude 3.5 Sonnet
0
0
17