Python scripts
Excel Consolidation & Markup Script: Multi-Entity Rollups With Adjustments and Eliminations
Combine entity trial balances, apply adjustments and intercompany eliminations, and hand a reviewer a workbook that recalculates and checks itself.
$39 one time · example and blank copies · download link by email
Who it is for
Bookkeepers and controllers who consolidate a handful of related entities in spreadsheets and want the workpaper built the same way every time.
Why it is different
- Output is live formulas, so a reviewer can trace every figure.
- Failed checks turn red and are listed on one tab.
- You decide the eliminations; the script never guesses them.
What is inside
- Entities tab. Every account against each entity, with a total that must be zero.
- Adjustments tab. Your adjusting and elimination journal lines.
- Consolidation tab. Combined, adjustments, eliminations and consolidated columns, with flagged rows.
- Checks tab. Trial balances, journals, each elimination set and intercompany accounts, tested.
- Sample files. Three entities and a journal so you can run it first.
Get it
Excel Consolidation & Markup Script (Python)
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of Python scripts with sample files. Needs Python 3.8 or newer. A workpaper builder, not an accounting opinion. It does not handle currency translation, non-controlling interests or goodwill. Needs Python and the openpyxl package. Not accounting advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Also from MCC Solutions
Month-End Close Workbook
A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock.
$19
Sales-Channel Profit Tracker
Which channel makes you money, and which one only looks busy? Sales minus cost of goods, shipping, platform and card fees and event costs, by channel, by event and by month.
$24