Intermediate
Revenue cut-off test: shipped vs invoiced vs recognized
Builds a revenue cut-off reconciliation and exception list by comparing shipments, invoicing, and revenue recognition. Useful for month-end close and audit support.
Create a revenue cut-off test for period end {period_end_date}.
Inputs:
- Shipment/delivery data: {shipping_log}
- Invoicing data: {invoice_register}
- Revenue GL detail: {revenue_gl_detail}
- Cut-off window (days before/after): {cutoff_window_days}
- Recognition criteria summary: {recognition_criteria}
Output:
1) Matching logic description (keys used, tolerances).
2) Reconciliation table: Shipments, Invoices, Revenue—by date bucket.
3) Exceptions list with classification: early/late recognition, missing invoice, pending acceptance, returns risk.
4) Proposed entries or accruals with amounts and accounts.
5) Evidence checklist for each exception (POD, acceptance, contract clause, etc.).
Keep it audit-friendly.Related Prompts
Financial Accounting
BeginnerMonth-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
IntermediateAP 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
IntermediateAR aging review and expected credit loss (ECL/CECL-lite)
Analyzes AR aging, flags collection risks, and proposes an allowance methodology and JE. Useful for controllers in smaller entities who need a practical, supportable approach.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
70