For CFOs and the accountants who close a group of companies every month, on any accounting system. Written by people who do the work, checked against the standards.
A checklist for groups with a 31 December year end reporting under IFRS: what to agree in early December, what each company does in January, and the group steps in order.
Amit Prabhu6 min readTen questions to settle before quoting: companies and ownership, currencies and rates, systems, intercompany, the deliverable. What each missed question costs, and three promises to avoid.
A seven-step workflow for a firm preparing group accounts for clients whose companies sit in separate Zoho Books organizations: scope, group chart, rates, onboarding, monthly cycle, review, delivery.
A spreadsheet is a fair answer for a small, simple group. Six questions show when it stops being one, tested on four companies, three currencies and an 80% subsidiary.
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.
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.
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.
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.
Get the fileMany companies, one set of group accounts: mapping, ownership and the worksheet.
4 posts · 14 terms IntercompanyBalances and sales between group companies, compared and removed.
3 posts · 8 terms Multi-currencySubsidiaries in other currencies, the right rates and the translation reserve.
3 posts · 9 terms Month-end closeClosing every company and the group, on time, with numbers that stay put.
4 posts · 1 term Group reportingStatements, KPIs and board packs the whole group can read.
2 posts · 1 term Statistical accounts and KPIsHeadcount, units, stores and room-nights, next to the money.
2 posts · 1 term Budgeting and forecastingGroup budgets, latest estimates and the gap to actual.
4 posts Accounting systemsZoho Books, Xero, QuickBooks and trial balances from anything else.
6 posts · 2 terms GlossaryEvery consolidation term, defined in two sentences, with an example.
36 termsA checklist for groups with a 31 December year end reporting under IFRS: what to agree in early December, what each company does in January, and the group steps in order.
Ten questions to settle before quoting: companies and ownership, currencies and rates, systems, intercompany, the deliverable. What each missed question costs, and three promises to avoid.
A seven-step workflow for a firm preparing group accounts for clients whose companies sit in separate Zoho Books organizations: scope, group chart, rates, onboarding, monthly cycle, review, delivery.
A spreadsheet is a fair answer for a small, simple group. Six questions show when it stops being one, tested on four companies, three currencies and an 80% subsidiary.
Five elimination journals for the example group, line by line: the reference, the source amount, the rate, the reason. Then how to write each one up and what support sits behind it.
Negative stock in one location, a bill dated after the lock date, and two unlock rules: the four cases on Zoho's own help page, with a worked stock example and what to do about each.
One close date, one lock in each company's own system, and one record for the group. What Zoho Books lets you lock, what its help page leaves open, and a lock calendar for five companies.
The ledgers stay in Zoho Books. Only the group layer leaves the spreadsheet. What moves, what stays, and a parallel run that proves it before you switch.
Three companies name their income three ways. How to design one group chart, map every account to it once, and prove the mapped totals still equal each trial balance.
The ten pages of a monthly group board pack, in the order a board reads them, with a worked income statement page against budget and what to leave out.
Thirty minutes, on a group shaped like yours.
