Working files from the way we close a group: the sheets, lists and formulas we use ourselves. Each one is free, opens in Excel or as a PDF, and works whichever accounting system your companies use.
This free PowerPoint template lays out a quarterly pack for lenders and investors in twelve slides: a covenant summary with headroom, the workings behind each covenant, a sensitivity to a fall in EBITDA, the trend over five quarters, and the quarterly results, net debt and results by company. Every figure is an example from a fictional group and is marked as one.
PowerPoint file Get the templateThis free Excel workbook works through goodwill and the non-controlling interest on an acquisition under both measurement methods, the pro-rating of a company bought part-way through the year, the remeasurement in a step acquisition, and a partial disposal with and without loss of control. Every sheet uses formulas, every journal balances, and the example figures are labelled.
Excel file Get the workbookThis free Excel checklist covers the decisions and steps for running a group of companies on Xero or QuickBooks: organisations or companies, base currency, tracking categories, classes and locations, intercompany accounts for every counterparty, lock dates and closing dates, and the trial balance export that Finconsol reads. Vendor pages are linked and dated, with an owner and a status for every step.
Excel file Get the checklistThis free Excel questionnaire lists the questions a Zoho partner should ask a client with more than one company before promising consolidation: entities, ownership, currencies, systems, intercompany volume, reporting needs, budgets, deadlines and who owns the work. Each answer is scored, and a scoring sheet suggests a route and flags the questions to settle before quoting.
Excel file Get the fileThis free Excel checklist sets out the tasks for closing a group of companies at a 31 December year-end under IFRS, from six weeks before to eight weeks after. Each task has an owner, a company, the evidence to keep and a due date that follows the year-end date you enter. A progress sheet shows the percentage done by week and by owner.
Excel file Get the checklistThis free PowerPoint template lays out a monthly group board pack in twelve slides: summary, profit and loss against budget and latest estimate, cash, balance sheet, results by company, KPIs, intercompany and open items, risks and decisions. Every figure is an example from a fictional group and is marked as one.
PowerPoint file Get the templateThis free Excel checklist covers the decisions and steps for running a group of companies on Zoho Books: organizations, locations and reporting tags, base currencies, the exchange rate source, intercompany accounts, transaction locking, user roles and how the group is combined. Each step links to the Zoho help page that covers it, with an owner, a status and a done percentage.
Excel file Get the checklistThis free Excel template builds a group budget from up to eight companies, each budgeting in its own currency. It translates every budget into the group currency at a budget rate, takes the closed months as actuals, and shows the latest estimate for the year with the variance to budget. An example group is filled in.
Excel file Get the templateThis free Excel library holds forty measures for groups of companies in services, hospitality, software, manufacturing and retail. For each it gives the formula, the statistics you need to record, the money accounts it draws on and who it is good for. A calculator works out any measure for up to eight companies and rolls it up correctly for the group.
Excel file Get the libraryThis free Excel workbook works out the month's movement in the translation reserve for up to five foreign subsidiaries. You enter the opening net assets, the profit and three rates, and it shows how each part of the movement arises, with a check that the result ties. A worked example is filled in.
Excel file Get the workbookThis free Excel checklist lays out a five-day group close task by task, with an owner, a company and a due date for each. Due dates follow the month-end date you enter, and a progress sheet shows the percentage complete for each day. It is built for groups of 3 to 30 companies.
Excel file Get the checklistThis free Excel template compares what each group company records against its sister companies. It lists every pair by counterparty and transaction currency, shows the receivable, the payable and the difference, and records the reason, owner and due date for anything that does not agree. It has one sheet for each month and a filled example.
Excel file Get the templateThirty minutes, on a group shaped like yours.
