account-reconciliation

Reconciles GL balances against bank statements, subledgers, and schedules with traceable matching and aging.

Updated Jun 21, 2026
One-click install
npx skills add https://github.com/lwokeray/cowork-plugins --skill account-reconciliation-lwokeray
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: account-reconciliation
Source: https://github.com/lwokeray/cowork-plugins/tree/main/plugins/finance-cowork/skills/account-reconciliation
Command: npx skills add https://github.com/lwokeray/cowork-plugins --skill account-reconciliation-lwokeray

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Finance teams spend hours manually matching GL balances to bank statements, subledgers, and supporting schedules, often losing track of reconciling items, aging, and unresolved differences. This Skill produces reviewer-reproducible reconciliation workpapers where every difference keeps its source references, match method, category, owner, and proposed adjustment. ## Core Features & Use Cases - Multi-type reconciliation: Supports bank, GL-to-subledger, balance-sheet roll-forward, intercompany, cash, AR, AP, fixed asset, prepaid, and accrual reconciliations with type-specific tie-out formulas. - Controlled matching hierarchy: Applies exact ID matching, business-key matching, one-to-many aggregation, approved tolerance matching, and review-only fuzzy candidates, never auto-resolving material items. - Classification and aging: Categorizes items as timing, book adjustment, source adjustment, classification, duplicate/omission, disputed, or unexplained, with aging buckets and prior-period roll-forward tracking. - Use Case: Ask it to reconcile an August bank account, and it validates source completeness, matches transactions by reference, separates outstanding checks from deposits in transit, and outputs an open item register with proposed journal entries. ## Quick Start Ask the assistant to reconcile the August bank statement against the GL cash account and list all outstanding items with aging and proposed adjustments.

Frequently Asked Questions about account-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile a bank statement against the GL cash account?▼

Provide the bank statement and GL detail for the same account, currency, and as-of date. The Skill validates source totals, matches transactions by exact reference first, then separates outstanding checks, deposits in transit, and unrecorded fees or interest into a tie-out with aging and proposed adjustments.

What types of account reconciliation does this support?▼

It supports bank, GL-to-subledger, balance-sheet roll-forward, intercompany, cash, AR, AP, fixed asset, prepaid, and accrual reconciliations. Each type uses a specific tie-out structure, such as adjusted bank balance minus adjusted GL balance for bank reconciliations.

Can it automatically clear or write off reconciling items?▼

No. Clearing, write-offs, settlements, reversals, and ERP postings are explicitly out of scope and must be executed by authorized personnel through approval workflows. The Skill only prepares proposed journal entries and open item registers for review.

How are fuzzy or ambiguous transaction matches handled?▼

Fuzzy matches based on similar text, dates, or amounts are listed only as review candidates and never auto-resolved. Material items, cross-currency matches, and multiple equivalent candidates always require manual reviewer judgment with preserved match methods and confidence levels.

What happens when source data is incomplete or inconsistent?▼

The reconciliation status is set to Source incomplete and tie-out stops if headers, details, filters, or scope cannot be verified. Known differences may be listed, but the reconciliation cannot be marked Prepared or Complete until completeness is restored.

When should I use journal-entry-preparation instead of this Skill?▼

Use journal-entry-preparation when creating journal entries from source documents rather than comparing balances. This Skill hands off book adjustments and reclasses to that Skill once reconciling items are classified and supported.