bookkeeping-close

Featured

Runs small and midsize business bookkeeping operations - categorizes bank and card transactions to a chart of accounts, reconciles a bank or card statement against the ledger, works a month-end close checklist, and produces a close package for the accountant. Works from QuickBooks Online, Xero, bank CSV/OFX, or Mercury exports, and from the Xero, QuickBooks, or Mercury connectors when present. Use it whenever the user says "reconcile", "bank rec", "categorize transactions", "month end close", "close the books", "books don't match the bank", "reconciliation is off by", "uncategorized expenses", or shares a QuickBooks or Xero export or a bank statement CSV, even if they do not name the task. Never plugs a difference; every unreconciled dollar is explained or listed.

AI & Automation 307 stars 53 forks Updated 3 days ago MIT

Install

View on GitHub

Quality Score: 90/100

Stars 20%
83
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Bookkeeping Close A reconciliation proves that the books and the bank agree once timing is accounted for. Models get this wrong in predictable ways: they flip signs, treat an uncleared check as an error, count a transfer between the business's own accounts as income, miss a transaction imported twice, and force the rec to zero with an adjustment. This skill exists to prevent each of those. The deterministic matching lives in `scripts/reconcile.py`; the judgment lives here. Scope: bookkeeping, not tax. When an item has a tax consequence (capitalize vs expense, owner draws vs wages, sales tax, 1099 status, meals deductibility), record the bookkeeping fact and put it on the accountant list. Do not give tax advice. ## Inputs to collect For each account being reconciled (checking, savings, each credit card, loan, payment processor clearing): 1. Statement for the period: ending date, beginning balance, ending balance. Take the balances from the statement itself, not from the feed, because feeds can be incomplete. 2. Statement lines: bank CSV/OFX, Mercury export or `listTransactions`, or the platform's statement lines. 3. Ledger for the same account: QBO register or Transaction Detail by Account, Xero Account Transactions. Export from the date of the oldest uncleared item, not the period start, so prior-period outstanding checks can clear. 4. Book balance at period start or end for that account. 5. Chart of accounts, and any existing bank rules. See `references/platform-note...

Details

Author
OneWave-AI
Repository
OneWave-AI/claude-skills
Created
11 months ago
Last Updated
3 days ago
Language
Python
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

reconcile

Compare every balance-carrying account's book balance to its statement balance, month by month, stating the difference for every account including the zeros. Use after the backlog is categorized and the adjusting entries are in, before declaring a period closed.

1 Updated 2 weeks ago
median-labs
AI & Automation Featured

bookkeeping

Use when a small business needs audit-ready books — a chart of accounts, posting a transaction to the right account and side, clearing an uncategorized bank feed, cash vs accrual, or a ledger that won't tie to the bank. NOT interpreting the numbers — runway, burn, P&L cadence (that is `finance-ops`), NOT issuing invoices (that is `invoicing`).

116 Updated 2 days ago
ericrisco
AI & Automation Listed

qbo-bank-reconciliation

Matches bank transactions against the QuickBooks Online register and the petty cash log for a stated period, so cash gets reconciled first in the close instead of last. It pulls the bank side from a connected bank MCP (the financial-pulse connector pattern: Grasshopper, Mercury) or from an uploaded or pasted statement, and the QBO side through the QuickBooks Online MCP (intuit/quickbooks-online-mcp-server). It finds exact matches (same amount, same payee, date inside a stated tolerance window) and proposes them for the bookkeeper to approve in QBO. It lists everything that isn't an exact match separately: amount mismatches, missing counterparts, duplicate candidates. It writes nothing to QBO or to the bank. It's read-only by design. Use it whenever the user says "reconcile the bank", "run bank rec", "match the bank feed", "petty cash reconciliation", "close the books on cash", "what doesn't match in the bank register", "bank and petty cash close", "QBO bank reconciliation", or anything else that means they wa

1 Updated yesterday
skills-agents-co