# Finance Reconciliation > Reconcile GL balances to subledger, bank, or third-party balances Use when this capability is needed. - Skill: `tomevault-io/finance-reconciliation` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/finance-reconciliation` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/finance-reconciliation/raw - Safety review: pending (external: skill-scanner PASS, skillspector PASS) - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Coding & Dev Tools - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/finance-reconciliation --- # Account Reconciliation > If you see unfamiliar placeholders or need to check which tools are connected, please ask about available integrations. **Important**: This skill assists with reconciliation workflows but does not provide financial advice. All reconciliations should be reviewed by qualified financial professionals before sign-off. Reconcile GL account balances to subledger, bank, or third-party balances. Identify and categorize reconciling items and generate a reconciliation workpaper. ## Usage You can ask to reconcile an account (e.g., "Reconcile the bank account" or "Prepare the AP recon"). ### Arguments - `account` — The account or account category to reconcile. Examples: - `cash` or `bank` — Bank reconciliation (GL cash to bank statement) - `accounts-receivable` or `ar` — AR subledger reconciliation - `accounts-payable` or `ap` — AP subledger reconciliation - `fixed-assets` or `fa` — Fixed asset subledger reconciliation - `intercompany` or `ic` — Intercompany balance reconciliation - `prepaid` — Prepaid expense schedule reconciliation - `accrued-liabilities` — Accrued liabilities detail reconciliation - Any specific GL account code (e.g., `1010`, `2100`) - `period` — The accounting period end date (e.g., `2024-12`, `2024-12-31`) ## Workflow ### 1. Gather Both Sides of the Reconciliation If an ERP or data warehouse is connected: - Pull the GL balance for the specified account(s) as of period end - Pull the subledger, bank statement, or third-party balance for comparison - Pull prior period reconciliation (if available) for outstanding item carryforward If no data source is connected: > Connect an ERP or data warehouse to pull account balances automatically. To reconcile manually, provide: > > 1. **GL side:** The general ledger balance for the account as of period end > 2. **Other side:** The subledger balance, bank statement balance, or third-party confirmation balance > 3. **Prior period outstanding items** (optional): Any reconciling items from the prior period reconciliation ### 2. Compare Balances Calculate the difference between the two sides: ``` GL Balance: $XX,XXX.XX Subledger/Bank/Other Balance: $XX,XXX.XX ---------- Difference: $XX,XXX.XX ``` ### 3. Identify Reconciling Items Analyze the difference and categorize reconciling items: **Timing Differences** (items that will clear in subsequent periods): - Outstanding checks / payments issued but not yet cleared - Deposits in transit / receipts recorded but not yet credited - Invoices posted in one system but pending in the other - Accruals awaiting reversal **Permanent Differences** (items requiring adjustment): - Errors in recording (wrong amount, wrong account, duplicate entries) - Missing entries (transactions in one system but not the other) - Bank fees or charges not yet recorded - Foreign currency translation differences **Prior Period Items** (carryforward from prior reconciliation): - Items from prior period that have now cleared (remove from reconciliation) - Items from prior period still outstanding (carry forward with aging) ### 4. Generate Reconciliation Workpaper ``` ACCOUNT RECONCILIATION Account: [Account code] — [Account name] Period End: [Date] Prepared by: [User] Date Prepared: [Today] RECONCILIATION SUMMARY ======================= Balance per General Ledger: $XX,XXX.XX Add: Reconciling items increasing GL [Item description] $X,XXX.XX [Item description] $X,XXX.XX --------- Subtotal additions: $X,XXX.XX Less: Reconciling items decreasing GL [Item description] ($X,XXX.XX) [Item description] ($X,XXX.XX) --------- Subtotal deductions: ($X,XXX.XX) Adjusted GL Balance: $XX,XXX.XX Balance per [Subledger/Bank/Other]: $XX,XXX.XX Add: Reconciling items [Item description] $X,XXX.XX Less: Reconciling items [Item description] ($X,XXX.XX) Adjusted [Other] Balance: $XX,XXX.XX DIFFERENCE: $0.00 ``` ### 5. Reconciling Items Detail Present each reconciling item with: | # | Description | Amount | Category | Age (Days) | Status | Action Required | | --- | ----------- | ------ | -------- | ---------- | ------------------- | ----------------- | | 1 | [Detail] | $X,XXX | Timing | 5 | Expected to clear | Monitor | | 2 | [Detail] | $X,XXX | Error | N/A | Requires correction | Post adjusting JE | ### 6. Review and Escalation Flag items that require attention: - **Aged items:** Reconciling items outstanding more than 30/60/90 days - **Large items:** Individual items exceeding materiality thresholds - **Growing balances:** Reconciling item totals increasing period over period - **Unresolved prior period items:** Items carried forward without resolution - **Unexplained differences:** Amounts that cannot be tied to specific transactions ### 7. Output Provide: 1. The formatted reconciliation workpaper 2. List of reconciling items with categorization and aging 3. Required adjusting entries (if any permanent differences identified) 4. Action items for items requiring follow-up 5. Comparison to prior period reconciliation (if available) 6. Sign-off section for preparer and reviewer --- > Converted and distributed by [TomeVault](https://tomevault.io/claim/frumu-ai) — claim your Tome and manage your conversions.