Intermediate

Construction 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.

Reconcile construction retainage as of {as_of_date}.

Inputs:
- Retainage receivable detail: {retainage_ar}
- Retainage payable detail: {retainage_ap}
- Contract/job status and substantial completion dates: {job_status}
- Disputes/claims: {disputes}
- Cash receipts/payments: {cash_activity}

Output:
1) Retainage aging by job/customer/vendor.
2) Reconciliation to GL balances and recon items.
3) Top aged retainage action plan (who, next step, target date).
4) Suggested allowances/reserves (if applicable) and documentation needs.

Keep it operational and cash-focused.

Related Prompts

Industry-Specific

Advanced

Inventory 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

Industry-Specific

Beginner

Nonprofit: Functional Expense Allocation (990)

Allocates expenses between Program, Management, and Fundraising buckets.

GPT-4oGemini 1.5 Pro

Industry-Specific

Advanced

Channel 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