GroupLedger Pro

R199.00

  • Consolidations workbook for group statements: a 78-page A4 PDF guide with an 8-step method, 13 pro-forma journal templates and 9 original practice questions with full solutions.
  • Excel consolidation tool: enter two trial balances and the acquisition data to get the analysis of equity, goodwill, NCI, journals and consolidated SoFP and SoPL.
  • 22 automatic checks and an Answer Checker that confirms your answers against the guide.
  • For 2nd- and 3rd-year Financial Accounting (e.g. UNISA FAC2602 and FAC3704 topics). Instant download.

Description

Consolidations workbook and Excel tool for group statements

GroupLedger Pro is a consolidations workbook for South African BCom Accounting, BCompt and BAcc students who need to master group statements. It combines a 78-page A4 study guide with an Excel consolidation tool, so you can learn the method, practise it on original questions and then let the tool prove your answers. Every answer in the guide was calculated in Python and reproduced by the spreadsheet, so the guide and the tool always agree.

If the analysis of equity, non-controlling interest (NCI) or upstream and downstream unrealised profit still feel confusing, this product breaks consolidations into clear, repeatable steps.

Who it is for

  • Second-year students meeting simple group structures for the first time, for example in UNISA FAC2602 (Selected Accounting Standards and Simple Group Structures).
  • Third-year students revising business combinations, intragroup transactions and goodwill impairment, for example in UNISA FAC3704 (Group Financial Reporting).
  • Students in equivalent Financial Accounting modules at UJ, UP, Wits, Stellenbosch, UCT and other universities.
  • Tutors who want a fast way to check a consolidation or to show how each adjustment flows through.

What is included

  • GroupLedger Pro Consolidations Guide (PDF, 78 A4 pages): clickable contents, bookmarks and links between questions and solutions.
  • GroupLedger Pro Consolidation Tool (Excel-format .xlsx, 13 sheets): a clean copy, ready for your own data.
  • GroupLedger Pro User Guide (DOCX): every sheet explained with screenshots, tips, troubleshooting and FAQs.

Inside the consolidations study guide

  • Group statements in plain language: control, the acquisition method, goodwill and bargain purchases, the two NCI measurement options, fair value adjustments and deferred tax, intragroup eliminations and goodwill impairment. IFRS 3, IFRS 10, IAS 12 and IAS 36 are explained in our own words.
  • The 8-step consolidation method, with a note at every step showing where the same calculation appears in the Excel tool.
  • A formula sheet covering mark-up versus margin, goodwill, NCI, adjusted profit and consolidated retained earnings.
  • A pro-forma journal library of 13 templates (J1 to J13), from eliminating the investment to allocating current-year profit to NCI.
  • A fully worked example that uses every feature: NCI at fair value, land and plant fair value adjustments with deferred tax, goodwill impairment, upstream and downstream inventory, an equipment transfer, a loan, management fees and dividends.
  • Nine original practice questions with full solutions, from a wholly owned subsidiary to a 75-minute exam-style consolidation. Each solution includes workings, the analysis of equity, a retained earnings proof, all pro-forma journals, the consolidated SoFP and SoPL and an answer key.
  • Exam technique and the twelve most common consolidation mistakes, plus a glossary.

Inside the Excel consolidation tool

Four input steps

  • Settings: company names, year-end, currency symbol (R by default) and tax rate (27% by default).
  • Trial balances: parent and subsidiary side by side, with a balance check for each.
  • Acquisition: date, percentage acquired, consideration, NCI method (proportionate share or fair value), equity at acquisition, up to three fair value adjustments, a deferred tax switch and goodwill impairment.
  • Intragroup: up to three inventory streams (upstream or downstream, mark-up or margin, opening and closing stock), two property, plant and equipment transfers, loans and interest, current accounts, management fees and dividends.

What it prepares for you

  • Goodwill or gain on bargain purchase, including the parent and NCI portions of goodwill.
  • A four-column analysis of equity with a consolidated retained earnings proof.
  • Thirteen pro-forma consolidation journals with an explanation on every line.
  • A consolidation worksheet (parent + subsidiary + journals = group).
  • The consolidated statement of financial position and statement of profit or loss, with profit attributable to owners and NCI.
  • A dashboard with eight key results, the group structure and four native charts.
  • Twenty-two automatic checks, including two independent proofs of retained earnings and NCI.
  • An Answer Checker: pick any question from the guide and compare 11 results with the answer key.

How it works

  1. Read the concept and method chapters of the guide.
  2. Work through the worked example on paper, then enter it in the workbook and compare each sheet.
  3. Attempt each practice question under time pressure.
  4. Enter the question in the tool and use the Answer Checker and the Workings sheet to find any step you got wrong.

Use cases

  • Preparing for a group statements test or exam and needing many fully solved consolidation questions.
  • Checking an assignment consolidation before you submit it.
  • Understanding why upstream unrealised profit affects NCI but downstream profit does not.
  • Seeing exactly how fair value adjustments, deferred tax and goodwill impairment change the statements.

File formats and software requirements

  • PDF guide: opens in any PDF reader on phone, tablet or computer. A4, ready to print.
  • Consolidation tool: Excel-format .xlsx, tested in LibreOffice Calc and built with standard functions for Microsoft Excel and Google Sheets. No macros and no internet connection needed.
  • User guide: DOCX for Microsoft Word, LibreOffice Writer or Google Docs.

Customisation

Change the currency symbol in one cell and every amount label updates. Company names and the year-end flow into every heading, statement title and chart. Input cells are violet and unlocked; formulas are protected without a password, so you can unprotect a sheet if you want to restyle it.

Digital download

This is a digital product. You receive three files immediately after payment; nothing is posted. Please note the scope: the tool consolidates one parent and one directly held subsidiary acquired on or before the first day of the current year. Mid-year acquisitions, changes in ownership, complex groups and associates are explained in principle in the guide but are not modelled in the tool.

Frequently asked questions

Is this the UNISA study guide or a past paper pack?

No. All explanations, companies, figures and questions are original and written by Mzansi Writers. It supports the topics, it does not copy any university material.

Which modules does it help with?

Group statements topics in second- and third-year Financial Accounting, such as UNISA FAC2602 and FAC3704 and similar modules at other South African universities.

Does the Excel tool work in Google Sheets?

It uses only standard functions available in Google Sheets and Microsoft Excel and was tested in LibreOffice Calc. Upload the file to Google Drive and open it with Google Sheets.

Are the answers checked?

Yes. Every answer was calculated in Python and reproduced by the Excel tool, and every trial balance, journal and statement balances.

Does it cover both NCI methods?

Yes: proportionate share of net assets and fair value, including how goodwill impairment is shared under the fair value method.

Can I share it with my study group?

No. The licence is for the purchaser’s personal use only. Reselling, sharing or uploading the files is not allowed.

Disclaimer and licence

Independent study resource by Mzansi Writers. Not affiliated with, endorsed by or produced by UNISA or any other university, SAICA, SARS or the IFRS Foundation. Module codes are used only to show which syllabus this resource supports. Licensed for personal study use only; no resale, sharing or uploading.

Reviews

There are no reviews yet.

Be the first to review “GroupLedger Pro”

Your email address will not be published. Required fields are marked *