- Home
- Skills
- Finance & Accounting
- Bank Reconciliation: Statement vs Books
More screenshots
Works with the AI Agents you already use
Bank Reconciliation: Statement vs Books
Reconcile a bank statement against the books in two commands and get the reconciliation statement, with Latin American and European formats built in.
$15
Bank Reconciliation: Statement vs Books
Example session with this skill installed
Reconcile extracto_octubre.xlsx against libro_bancos_octubre.csv. The bank and the books don't agree this month.
- Read your context and instructions
- Compiled the bank reconciliation
October reconciles except for one item to confirm. (Demo data is fictitious.)
| Check | Result |
|---|---|
| Bank movements | 67 (opening and closing balance rows skipped) |
| Book movements | 68 |
| Matched one to one | 60 |
| Matched as a group | 1 deposit of 2,500,000.50 = 3 cash receipts |
| Only in the bank | 4, total -60,694.15 |
| Only in the books | 3, total -389,500.00 |
| To review | 2 |
Reconciliation
| Amount | |
|---|---|
| Balance per bank | 83,050,022.74 |
| + Deposits in transit | 2,340,500.00 |
| - Outstanding checks | -2,730,000.00 |
| Adjusted bank | 82,660,522.74 |
| Balance per books | 82,730,216.89 |
| + Interest not recorded | 4,118.22 |
| - Fees and 4x1000 not recorded | -64,812.37 |
| Adjusted books | 82,669,522.74 |
| Difference | -9,000.00 |
The 9,000 is the international transfer: the books show 1,200,000.00 and the bank received 1,191,000.00, so the bank kept a fee. Confirm it and record the fee, and the difference goes to 0.
To record in the books: management fee 19,900.00, 4x1000 tax 38,412.37, transfer fee 6,500.00 and interest 4,118.22. Just timing: checks 004512 (1,980,000.00) and 004513 (750,000.00), and the deposit of 2,340,500.00 on Oct 31.
Saved as extracto_octubre_reconciliation.xlsx.
Connects securely to your tools. The creator never sees your data.
About this skill
Month end, and the bank balance doesn't match the books. Somewhere in two exports are the fees nobody recorded, the 4x1000 tax, the checks that haven't been cashed and the deposit that's still in transit.
This skill gives your agent two Python scripts that line up the bank statement with the books and build the reconciliation for you. It reads Excel or CSV straight from the bank and from the accounting system, including Latin American and European formats (1.234,56, dd/mm/yyyy, Debe/Haber, Débitos/Créditos).
It matches by amount and date, with a few days of tolerance, and uses the check or document number when there is one. It also catches one deposit that covers several receipts. What's left goes into two lists: what's only in the bank (fees, taxes and interest you still need to record) and what's only in the books (checks not cashed, deposits in transit). Lines that look related but don't match exactly, like a transfer that arrived net of a fee, go to a review list with the reason. Nothing is forced.
You get a workbook with the reconciliation statement, the difference (green when it's 0) and every line in its place, with the row it came from.
If a client reconciles every month, the agent can leave them a small folder with a .bat they double-click.
It runs on your machine. No network calls, no API keys. Tested on 5,000 movements per side, which takes under a second.
What it doesn't do: one bank account per run. Two identical amounts on the same day can pair the other way round; the totals stay right.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
One bank account per run and one table per sheet. Old .xls files need to be saved as .xlsx first. Two identical amounts on the same day can pair the other way round; the totals stay right.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 6 days ago
- Software
Pythonopenpyxl for Excel files (pip install openpyxl)