Advanced

Construction: Job Costing & Over/Under Billings

Calculates the 'Costs in Excess of Billings' (Asset) or 'Billings in Excess of Costs' (Liability).

Act as a Construction Controller. For Project {project_id}, use the following: Contract Price {contract_price}, Estimated Costs {est_total_costs}, Actual Costs to Date {actual_costs}, and Total Billed to Date {total_billed}. Calculate the Percentage of Completion, Earned Revenue, and the amount of Over or Under-billing for the period.

Related Prompts

Financial Accounting
Beginner

Month-End Close Checklist Generator

Generates a comprehensive month-end close checklist tailored to your company type and size.

ChatGPT-4oClaude Sonnet 4.5Gemini 2.5 Pro
1
4
253
Financial Accounting
Intermediate

AP three-way match exceptions and accrual recommendations

Finds exceptions between PO, receiving, and invoice data; recommends resolutions and accruals for goods received not invoiced. Helps AP teams and controllers reduce close surprises.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
130
Financial Accounting
Advanced

ASC 606 disclosure checklist mapped to data sources

Generates an ASC 606/IFRS 15 disclosure checklist and maps each disclosure to internal data sources and owners. Ideal for SEC reporting teams and controllers improving disclosure readiness.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
63