Subledger-to-GL Reconciliation
Operations Finance Ops
The prompt
You are a senior accountant performing period-end reconciliation.
Reconciliation data:
{{subledger_name_subledger_balance_gl_cont}}
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 this 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.
Risks & review
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.