# Bank Reconciliation: Free Claude Code Skill for QuickBooks

> A free, read-only Claude Code skill that explains why QuickBooks and the bank statement don't match, bridges each account to the cent, and drafts the fixes.

- **URL**: https://www.nocodetalks.co/skills/bank-reconciliation
- **Site**: Nocodetalks, a one-person product studio that builds finance tools for US accounting firms, CFOs and fintech founders
- **Contact**: ankur@nocodetalks.co
- **Free 30-minute audit**: https://cal.com/nocodetalks/quick-catchup-30-min

---

# `/bank-reconciliation`Find every reason QuickBooks and the bank disagree.

A free, read-only Claude Code skill for QuickBooks Online.

Names every cause of the gap, to the cent. Every fix is a draft for you to approve.

Need this built against your books? [I’ll build it for your firm.](https://cal.com/nocodetalks/quick-catchup-30-min)

**Ankur Khandelwal** · v0.1.0 · MIT

Install in Claude Code

Add the marketplace once:

\> `/plugin marketplace add nocodetalks/finance-skills`

Then install the skill:

\> `/plugin install bank-reconciliation@finance-skills`

Then ask: _“Why doesn’t QuickBooks match the bank for September?”_

Claude Code · Python 3.10+ · [Source on GitHub](https://github.com/nocodetalks/finance-skills/tree/main/plugins/bank-reconciliation)

## Watch it work.

QuickBooks and the bank $64,040 apart, and every reason why.

## One real gap, explained.

QuickBooks says $219,774\. The bank says $155,734\. Six items make up the $64,040.

| What                                              | Type       | Effect on the gap | Fix                                 |
| ------------------------------------------------- | ---------- | ----------------- | ----------------------------------- |
| Stripe payout booked 9/30, Stripe created it 9/30 | Timing     | +$11,920.00       | none                                |
| Stripe payout on the bank 9/17, not in the books  | Book error | −$11,000.00       | ready: record it                    |
| Gusto payroll on the bank 9/30, not in the books  | Book error | +$64,500.00       | confirm first: record it            |
| Gamma LLC deposit $1,530 entered as $1,350        | Book error | −$180.00          | confirm first: correct it           |
| $600 refund booked twice; Stripe refunded once    | Book error | −$600.00          | ready: delete the copy              |
| The real $600 refund, paid out of Stripe          | Book error | −$600.00          | confirm first: move it off Checking |

After the fixes, the books match the bank plus the payout in transit.

## The causes it finds.

Each one comes from the scripts, never from a guess.

| Type                 | What it finds                                                                                                                                                                                                                                                                                                                                                   | Fix                                                                                                                    |
| -------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------- |
| **Timing**           | Deposits in transit (a Stripe payout counts only if Stripe created it by the statement end) · checks and payments not cleared yet                                                                                                                                                                                                                               | None. It clears next month.                                                                                            |
| **Book errors**      | Statement items missing from the books (payroll, fees) · Stripe payouts not recorded · amounts typed wrong (transposed digits divide by 9) · entries booked twice · refunds paid from Stripe booked against the bank · transfers between your own accounts booked as expenses · payments booked to the wrong bank account · last month’s fixes still not posted | A draft: create, edit, delete, move, or change into a transfer. Ready when two sources agree; otherwise confirm first. |
| **Needs a decision** | A book payment that never reached the statement and isn’t a check · a possible duplicate with no proof · old uncleared items · a Stripe deposit with no payout behind it · opening balances that differ                                                                                                                                                         | None. It asks you.                                                                                                     |

How each cause is found, and its limits: [causes.md on GitHub](https://github.com/nocodetalks/finance-skills/blob/main/plugins/bank-reconciliation/skills/bank-reconciliation/references/causes.md).

## What you get.

One folder per month, on your machine.

| File              | What's in it                                                                                                                                                                                                                                                                                       |
| ----------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| reconciliation.md | For each account: every item that makes up the difference, as timing, book error or needs a decision, with its source line. Then the standard layout: statement + in transit − outstanding = adjusted bank; books + drafted fixes = adjusted books. Then the draft fixes, and what wasn’t checked. |
| drafts.json       | Each fix with the QuickBooks record it applies to, for a person, or for a connector that asks before it writes.                                                                                                                                                                                    |
| outstanding.csv   | Uncleared items and fixes not posted yet, carried into next month by themselves.                                                                                                                                                                                                                   |

## Rules it never bends.

A rec that ties can still hide an error. These keep it honest.

| Rule                            | What it means                                                                                                                                                                            |
| ------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **The books must add up first** | The copied book lines must run from QuickBooks’ opening balance to its closing balance, and the statement rows from the statement’s opening to its closing. If either doesn’t, it stops. |
| **Every cent explained**        | The items add up to the difference exactly. The run checks this and treats anything else as a bug.                                                                                       |
| **Never guesses a cause**       | What it can’t settle stays a question for you. A payment that never reached the bank is never quietly called an outstanding check.                                                       |
| **Read-only**                   | It never posts, edits or deletes in QuickBooks, even when the connector could write. Fixes are drafts, and a person approves each one.                                                   |
| **Says what it didn’t check**   | The bank feed’s For Review list, the Reconcile screen, and the other side of matched entries are listed as not checked, every time.                                                      |

## What it needs.

No keys in the chat. The books come through the connector you already use.

| Input                        | How                                                                                                                                                                                                                        |
| ---------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **QuickBooks Online**        | The account’s lines and its balance on two dates, read through any QuickBooks connector you already use, or a QuickBooks export. Claude copies them into one file, and the script checks they add up before anything runs. |
| **Bank and card statements** | The CSV export, plus the opening and closing balance printed on the statement. Pending rows are left out.                                                                                                                  |
| **Stripe (optional)**        | The balance transactions export. It’s what settles refunds and payouts. Without it, a refund booked twice looks like two uncleared payments, so those come back as questions.                                              |
| **First month only**         | If the opening balances differ, last month’s uncleared items. After that they carry forward by themselves.                                                                                                                 |
| **Your machine**             | Python 3.10 or later. No packages to install.                                                                                                                                                                              |

Getting the book side from a connector, step by step: [books-from-a-connector.md](https://github.com/nocodetalks/finance-skills/blob/main/plugins/bank-reconciliation/skills/bank-reconciliation/references/books-from-a-connector.md). Want the whole month checked, not just the bank? [month-end-review](https://www.nocodetalks.co/skills/month-end-review).

## Common questions.

Found a bug or a cause it should catch? Open an issue on [GitHub](https://github.com/nocodetalks/finance-skills) or email ankur@nocodetalks.co.

Does it post the fixes to QuickBooks?

No. It writes draft fixes. You post them in QuickBooks, or approve them one at a time through a connector that asks before it writes, and then run the reconciliation again.

Which QuickBooks connector does it need?

Any one that can read an account’s transactions and balances, or none: a register or Transaction Detail by Account export from QuickBooks works too.

How is it different from month-end-review?

month-end-review checks the whole month (AR/AP, Stripe, payroll, accruals, variance) with your own Intuit keys. bank-reconciliation does one job, the bank and card reconciliation, through the connector you already have.

Does it replace the Reconcile screen in QuickBooks?

No. It tells you why the balances differ and what to fix. Ticking cleared items and finishing the reconciliation is still done in QuickBooks.

What does it cost?

Nothing. It is MIT licensed. If you want it set up on your books, or extended to your own process, that is paid work.

## Want it set up on your books?

I can connect it to your QuickBooks, run it across every account with your team, and fit it to your own close process.

[Book a call ](https://cal.com/nocodetalks/quick-catchup-30-min)
