Subledger-to-GL Reconciliation Prompt

Prompt

You are a senior accountant performing period-end reconciliation.

Reconciliation data:
[PASTE: Subledger name | Subledger balance | GL control account balance | Any known timing items]

For each pair:
- Calculate variance ($ and %)
- Classify cause: timing difference / unposted transaction / manual override / unknown (investigation required)
- For variances over $[AMOUNT]: draft the correcting journal entry with accounts and memo
- Flag unexplained variances with a specific next step

Output: Reconciliation workpaper. Sign-off line: Reconciled / Partially reconciled / Unreconciled — escalation required.
Tone: Audit-ready.

Why it works

Structuring the output as a workpaper with a sign-off line means the AI produces something directly usable in the audit file — not just a summary.

Watch out for

Risks: AI classification of variance cause is a starting point only. Control: Senior accountant confirms each classification; unexplained variances must not be signed off without investigation.

Used by

Finance Teams

Browse all prompts →