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

Intermediate

Standard 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

Industry-Specific

Advanced

SaaS 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

Industry-Specific

Intermediate

ARR/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