The Reconciled Pack Course · Free with your email

The ledger export becomes a pack that proves itself.

This course teaches you to have Claude for Excel build the reconciliations into the workbook itself, so the pack you send the board traces back to the ledgers, figure by figure. The checks are formulas that live beside the pack: the sources balance, every account has a home, intercompany cancels, and one cell says whether the whole pack still reconciles. Move a line, add an accrual, take in a late journal, and the checks answer before anything goes out. Next month the same workbook runs again, new accounts flagged and last month's adjustments carried or cleared. You download the whole working pack: the step by step guide, an invented group's ledgers for August, September and October, a blank pack layout, the skill that runs each month, the exact briefs, the sign off checklist, and finished workbooks for August and September.

Get the course

Checks that live in the workbook Every working file included A sign off checklist, because someone signs The whole course in about 2h30hrs

If you build the monthly pack in Excel from ledger exports, and every figure has to trace back to the ledger, this was built for you.

Who this is for

Financial managers who build the monthly pack from more than one ledger
Accountants who need every pack figure traced to its account
Anyone whose checks live in their head instead of the workbook

How long it takes

About 2h30hrs for the whole course, from the first August brief to October on your own
The workbook and its checks are built once, in August
September and October run in the same workbook, with the checks already in place

What this will teach you

How to lock a ledger before you build on it, from a connector or an export
How to have Claude for Excel build checks that live in the workbook, and prove each one can fail
How to carry adjustments into next month so the pack still reconciles

The outcome

See the outcome before you start

Two pages from the finished September pack. The month ran in the same workbook as August: a new account flagged and mapped, last month's accrual reversed against the real invoice, and every check passing before the pack went out.

The summary page from the finished September pack: results against budget, cash and working capital, the bridge from the ledgers to the pack, and the checks result — The summary page: the result, cash and working capital, and the bridge from the ledgers, with the checks result in the header.

The checks page from the finished September pack: every check listed with its group, difference, tolerance and verdict — The checks page: every check passing, the year to date traced line by line to August's issued pack.

Here is what you will hold at the end, and what each piece does for you. A workbook that turns both companies' ledgers into the group pack and shows, check by check, that every figure still comes from the ledger. An invented group's ledgers for August, September and October, so you practise where mistakes are free. The skill that runs the month, so next month starts from the workbook, not from memory. The exact briefs to give Claude for Excel, blank and filled. The sign off checklist, because someone signs before a pack goes to the board. And finished workbooks for August and September, so you hold the destination before you start.

And the honest arithmetic. The whole course takes about two and a half hours, and the heavy lifting is August, where the workbook and its checks are built once. September shows the same workbook running again, and October is yours alone. Every month after that, the checks do the tracing, and the judgment stays yours.

From the ledger to your own pack. Here is the road.

Reconciled from ledger to packPRINCIPLE
Set up once: Excel, the add-in, the skillBUILD
Lock the ledgers before you buildBUILD
Every account has a homeBUILD
The checks live in the workbookBUILD
Prove every check can failSIGN
Wire the pack to the ledgerBUILD
Adjustments that keep the ledger in sightRUN
When the ledger moves after the exportRUN
Sign it and issue itSIGN
Next month, same workbookREPEAT
Rules, not adjustmentsREPEAT
October on your ownREPEAT
Your own ledgersREPEAT

The pack

What this consists of

In the pack	What it is
Start Here	The map of the pack, and what you need installed.
The Course Guide	The whole method, month by month, as an A4 you can print.
The Workbooks	The blank layout you build in, the finished August and September workbooks, and the skeleton for your own ledgers.
The Ledgers	An invented group's ledgers for August, September and October: a connector pull, the exports, the printed trial balances and the approved budget.
The Skill and Briefs	The skill that runs each month, the exact briefs for Claude for Excel, and the answer sheet for October.
The Sign Off	The checklist as one printable page, with a signature line, because someone signs.
The Result	The August and September packs as the board receives them.

Keurbos Group, the business running through the pack, is invented. Every company, account, figure and ledger entry was made up for the course.

Free with your email

Get the course

Rather run it live, in the room? The training day does exactly this at your offices, in your own live files, with your team. A conversation costs nothing.