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

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
0
0
15
Industry-Specific
Advanced

HIPAA Security Rule Risk Analysis

Evaluates the technical safeguards for Protected Health Information (PHI).

Claude 3.5 SonnetGPT-4o
0
0
7
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
0
0
7