--- title: "Excel Consolidation Script (Python) | MCC Solutions" description: "A Python utility that rolls several entities' trial balances into one workbook with adjustments, eliminations and a Checks tab, all as live Excel formulas." url: "https://mcc-solutionsnj.com/toolkits/excel-consolidation-script" --- 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 Buy now, $39 🌙 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 store](/toolkits) 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. 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. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=excel-consolidation-script) 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 This kit **$39 one time** Excel Consolidation Script. Buy this kit Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## 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](/toolkits/month-end-close-workbook)[### 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](/toolkits/sales-channel-profit-tracker) ## More bookkeeping and business toolkits - [FAFSA 2027-28 and Scholarship Organizer](/toolkits/fafsa-and-scholarship-organizer) $15 - [Family Child Care Records Kit](/toolkits/family-child-care-records-kit) $24 - [Family Records and Important Documents Organizer](/toolkits/family-records-organizer) $14 - [Financial Ratio Analysis Workbook](/toolkits/financial-ratio-analysis-workbook) $29 - [First Job, First Paycheck Kit](/toolkits/first-job-first-paycheck-kit) $12 - [Fix-Your-Own-Credit Kit: Free Reports, Disputes and Freezes](/toolkits/diy-credit-repair-kit) $15 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)