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 · 14-day full refund · scripts and samples · download link by email
🌙 The desk is asleep. The store never is.
Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning.
Browse the storeWho 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.
Not the right fit if
Your consolidation needs currency translation, non-controlling interests or goodwill, or you can't run Python with openpyxl.
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)
Or pay with PayPal
Uses the email and terms box above. You get the same download link by email.
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Get every update for a year, $29: the Yearly Updates Pass gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal.
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.
Ways to get it
Just this kit, or more
Membership
$29 a month
Every kit and document pack in the store, including new ones. Cancel any time.
See the membershipQuestions
Common questions
What do I get and how is it delivered?
The Excel Consolidation Script comes as a zip with the script (consolidate.py), sample files to try first and a README with the commands. The download link arrives by email after payment.
Will it run on a Mac, Windows or my phone?
It needs Python 3.8 or newer and the openpyxl package on a Mac, Windows or Linux computer, so it will not run on a phone. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund.
Is this legal or tax advice?
No, it is not accounting advice.
Is it the right fit for me?
It is made for bookkeepers and controllers who consolidate a handful of related entities in spreadsheets and want the workpaper built the same way every time. Skip it if your consolidation needs currency translation, non-controlling interests or goodwill, or you can't run Python with openpyxl.
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