Productivity
Bank Reconciliation to GL
SKILLOpen-source projectA CPA workflow skill that matches bank statement activity to a cash GL, classifies unmatched items, and builds a reconciliation workpaper.
Key Features
- Match bank and general-ledger transactions through a six-pass cascade, from check number and amount to grouped deposits or settlements.
- Require aligned accounts and periods, statement controls, and a GL close that agrees with the trial balance before matching.
- Produce a four-column reconciliation workpaper, proposed journal entries for unrecorded items, and an aged outstanding-item schedule.
Target Demographics
Bookkeepers, accounting teams, and CPAs who prepare month-end cash reconciliations from bank statements, GL detail, and prior-period outstanding items.
Our Take
This is a concrete bank-to-cash-GL procedure, not merely a fuzzy transaction matcher. Its strongest control is refusing to hide an unexplained difference; classification and journal-entry decisions remain professional judgments that the skill cannot safely automate away.
Pros
- Uses ordered matching rules and records why a pair matched, preserving evidence for review.
- Separates mechanical matching from classifying timing items, errors, and unrecorded bank activity, and requires an unexplained difference of zero for completion.
Cons
- Needs complete bank and book inputs, opening/closing balances, and prior outstanding items where available; poor source data blocks a sound reconciliation.
- Requires Python and workbook libraries, and a CPA or qualified reviewer must assess reconciling-item classifications and proposed entries.
Pricing
The CPA skills repository is MIT-licensed and lists no paid fee for the skill. The documented workflow requires Python 3.9+, openpyxl, and pdfplumber; agent/model access is separate. The skill is a workpaper aid and not a substitute for professional accounting judgment.