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
AdvancedConstruction 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.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Industry-Specific
IntermediateReal estate development cost capitalization tracker
Creates a tracker for development costs, capitalization rules, and allocation to projects/units. Useful for developers and real estate accountants managing multi-project portfolios.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0
Industry-Specific
AdvancedReal estate sale/leaseback screening (ASC 842/IFRS 16)
Screens a real estate transaction for sale/leaseback accounting and identifies required data for recognition and measurement. Useful for corporate real estate and technical accounting.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
0