Month-End Excel Kit: Clean + Reconcile
Two skills that usually get used back to back at month end.
First your agent cleans the export that came out of the ERP, the bank or the POS: title rows on top of the header, amounts stored as text, dates in three formats, a TOTAL row in the middle. Then it reconciles the bank statement against the books and gives you the reconciliation statement, with what matched, what needs a second look and what shows up on only one side.
Both were built for Latin American and European files, where the decimal comma and dd/mm dates are the norm. They handle US formats too.
Everything runs on your machine with Python and openpyxl. No network calls, no API keys.
Includes Messy Excel Fixer and Bank Reconciliation: Statement vs Books. Each one still works on its own.
Works with any agent that signs in to Agensi, such as Claude, ChatGPT, Claude Code, Cursor and Codex CLI.
One payment, lifetime access. 2 skills unlock instantly in your library.
What's included
2 skillsReconcile a bank statement against the books in two commands and get the reconciliation statement, with Latin American and European formats built in.
Cleans messy Excel and CSV exports into a tidy, formatted workbook, with LATAM and EU number and date formats built in, and checks that the file's own total still adds up.
See it in action
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.
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 these skills and uses them on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every skill in this bundle goes through our trust checks.
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.