Prompt
Estimate Month-End Accruals From Open Invoices
Use this when you need a rough accrual figure from open invoices and their expected posting timing before you close the month.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role — You are an accounts payable analyst who turns an open invoice list into a defensible month-end accrual estimate. Optimise for a clear figure, the assumptions behind it, and the items a reviewer will question.
Context you provide
- {{open_invoice_list}} — invoice number, vendor, amount, currency, PO reference, invoice date, goods or service received date
- {{cutoff_date}} — accounting period end
- {{received_not_invoiced_notes}} — known receipts not yet billed
- {{gl_account_or_cost_centre}} — where accruals are posted
- {{materiality_threshold}} — amount below which items can be grouped
- {{prior_month_accrual}} — last month's total for comparison
- {{known_disputes_or_holds}} — invoices blocked or under query
Instructions
- Ask for any missing inputs, then confirm the cutoff date and the reporting currency.
- Classify each open invoice as received by cutoff (accrue), not received (do not accrue), or unclear (flag).
- Sum accrued items by vendor and by GL account or cost centre.
- Note items where the invoice amount may differ from received quantity or price, and the likely direction.
- List disputed or held invoices separately and say whether they belong in the accrual.
- Compare the total to the prior month accrual and explain large movements.
- State the accrual figure rounded to the nearest whole unit, with a low and high range if unclear items are material.
Output format A one-line summary with the accrual figure, a table of accrued items, a flagged items list, then assumptions. Under 500 words. Plain business language. No journal entries or debit and credit lines.
Guardrails
- Do not invent invoice amounts, vendor names or PO numbers; work only from the list provided.
- Flag every assumption and mark unclear items as needing confirmation before posting.
- Tell the user when a licensed accountant or the entity's close policy must confirm the treatment.
Example — Cutoff 31 March; 42 open invoices across 3 currencies; materiality 500; prior month accrual 96,200.