Reconciliation Skill
Reconciles general ledger, sub-ledger, and bank statements end to end with adjusting entries.
Before & after
Same prompt, same agent — the only difference is the skill.
I can help you reconcile these three accounts together. You'll definitely need to provide me with the ending balances from each source—your general ledger, accounts receivable subledger, and your bank statement. I'd recommend pulling all the transactions and comparing them carefully line by line to spot discrepancies. There might be timing differences or entries you haven't recorded yet on your end. Once we identify all the differences, we can sit down and discuss what adjusting journal entries might be needed to bring everything into balance.
RECONCILIATION WORKPAPER — JULY 2026: ACCOUNT BALANCES: GL AR ACCOUNT 47,300 USD. AR SUBLEDGER 47,200 USD. BANK DEPOSIT TOTAL 46,980 USD. RECONCILIATION TARGET: Zero variance. RECONCILING ITEMS (Aged Outstanding): • Invoice dated 2026-0712 (Customer A, 1,200 USD) — Recorded in GL, not yet collected from customer. 19 days outstanding as of month-end. • Deposit batch cleared 2026-07-28 (3 customer checks totaling 2,840 USD) — Cleared bank account, not yet posted to GL. 3 days outstanding as of month-end. • NSF check returned (1,060 USD) — Cleared bank 2026-07-26 for reversal, no adjusting entry recorded. 5 days outstanding as of month-end. PROPOSED JOURNAL ENTRIES: JE-001: Debit Cash 2,840 USD / Credit Accounts Receivable 2,840 USD (deposit clearing to GL, removes timing difference) JE-002: Debit Allowance for Doubtful Accounts 1,060 USD / Credit Accounts Receivable 1,060 USD (NSF write-off, reflects bank reality) FINAL VERIFICATION: GL reconciled to AR. AR reconciled to bank. Variance threshold met. Zero remaining difference. Ready for controller review and sign-off. (Illustrative example only. Not financial advice. Consult your accountant before posting entries.)
About this skill
name: reconciliation-finance description: Use when Reconciles general ledger, sub-ledger, and bank statements end to end with adjusting entries.
Reconciliation Skill
Pulls balances from each source, compares them, categorizes every difference (timing, adjustment, or investigation), ages outstanding items, flags anything over ~100 days stale, and outputs a documented workpaper with proposed adjusting journal entries and sign-off tabs.
What you get
- Available in the official finance plugin
- ships a full Excel workpaper.
Customize your output
- Point it at your own workbooks/datasets and adapt the output structure to your reporting standards.
Example output
A June reconciliation resolved to a zero ending difference with itemized reconciling items.
Best for
Controllers, accountants, and audit teams.
SKILL.md preview
---
name: reconciliation-finance
description: Use when reconciling a general ledger, sub-ledger, and bank statement end to end, including categorizing differences and proposing adjusting journal entries.
version: 1.0.0
category: Finance / Controls
author: AgentVolt
license: proprietary
tags:
- finance
- controls
- flagship
---
# Reconciliation Skill
Pulls balances from each source, categorizes every difference, ages outstanding items, and outputs a documented workpaper with proposed adjusting entries and sign-off tabs.
## When to use
… (sign up to view the full skill)More finance skills
View all Finance skills →Audit Support Skill
Runs control testing on a financial dataset and produces an audit findings memo by severity.
Portfolio Rebalance Advisor
Drop in your current holdings and target allocation — get the exact buy/sell list, tax-loss opportunities, and drift alert.
Personal Finance Q&A
Ask any personal-finance question and get a plain-English answer tailored to your bracket, timeline, and risk appetite.
Earnings Report Analyzer
Paste a 10-K, 10-Q, or earnings call transcript — get the numbers that matter, the narrative changes, and what the CFO tried to bury.