๐Ÿฅš๐Ÿ—๏ธ๐Ÿ‘‘
Court of Accounts ยท Companion

Kingdom Tools

Practical ledgers, reports, forecasts, and safeguards โ€” one tool for every character in the court.

The Kingdom Tools Workbook
A ready-to-use spreadsheet. Gold cells are for your input; blue and green cells calculate automatically. Start with the sample Kingdom of Eggerton, then replace the examples with your own business.
โฌ‡ Download the workbook (.xlsx)
Excel ยท Google Sheets ยท Numbers

Every tab corresponds to a lesson in the book's Part Two workbook. Open it in Excel, or upload it to Google Sheets to use it free in your browser.

What's in the workbook

Twenty tools, twenty characters

Each tab is one character from the story made real โ€” the truth-holders, record keepers, money movers, and analysts of Eggerton.

๐Ÿ‘‘
Queen Verity's Balance Sheet
What the kingdom owns and owes
โš”๏ธ
Sir Ludo's Victory Report
Income statement (Profit & Loss)
๐ŸŒŠ
Garrick's River of Gold
Statement of cash flows
๐Ÿ“œ
Lady Continuance
Statement of owner's equity
โœ’๏ธ
Pip's Journal
The general journal
๐Ÿ“š
Magnus's Ledger
The general ledger
๐Ÿ—บ๏ธ
Elowen's Chart of Accounts
Where every number belongs
โš–๏ธ
Theo's Trial Balance
Does it all still tie out?
๐Ÿ“จ
Callum's AR Aging
Who owes you, and how late
๐Ÿงพ
Beatrice's AP Aging
Who you owe, and when
๐Ÿ”
Rowan's Bank Reconciliation
Match the books to the bank
๐Ÿ”ฎ
The Prophet's Forecast
13-week cash flow forecast
๐Ÿ›๏ธ
The Oracles' Ratios
How outsiders will judge you
๐Ÿ“Š
Lady Prudence's Budget vs. Actual
Plan versus what really happened
๐Ÿ—๏ธ
The Risk Keeper's Scenarios
Best, expected, and worst case
๐Ÿฅš
Henrietta's Inventory Tracker
What's on the shelves
๐Ÿ“ฃ
The Herald's Dashboard
Executive dashboard
๐Ÿค
The Ambassador's Directory
Business relationships
๐Ÿ›ก๏ธ
The Sentinel's Controls
Internal controls checklist
โš ๏ธ
The Sentinel's Risk Register
Track and rate your risks