How to prepare consolidated financial statements

How to prepare consolidated financial statements

Consolidated financial statements can be prepared by creating:

1. Multiple engagement files (multiple entity trial balances)

    This will require the setting up of a consolidation,  and the importing  of a trial balance into each engagement file.

    Click on the following link for guidance using this option:

    How to create a consolidation hierarchy

2. A standalone engagement file (single consolidated trial balance)

To prepare consolidated financial statements within a standalone file:


  1. Click on the Entity and reporting information optimiser.

  1. The financial statements are not defined as consolidated by default.

         Next to the question: Are these consolidated financial statements? untick the

                        default selection No.


  1. Click the Yes button.

  1. Import the consolidated trial balance into the engagement file

    • Related Articles

    • How to prepare an 18 Month period Financial Statement

      Prior year: 12 months ending 30 June XXXX Current year: 18 months ending 31 December XXXX  If there is a change in the entity's reporting date like shown above, there are three primary areas to set:  a. CaseWare file Setup b. Leadsheets / Automatic ...
    • How to Export the Financial Statements into Microsoft Word

      To export Financial Statements to Microsoft Word, follow the procedure below: 1. Open your Financial Statements. 2. From the File tab, select Export > Rich Text Format. 3. In the File Name enter the name of the RTF file. 4. Click Save.   
    • How to add or remove a Note Reference in the Financial Statements

      To add/remove a note reference in the Statement of the Financial Position: 1. Using your mouse, select anywhere within the Statement of the Financial Position. 2. From the Statements to the Financial Position tab, select Options and tick Note ...
    • Consolidation in Agile Audit

      Although consolidation is a feature in Agile Audit, it is important to be aware of a few key rules/best practices: 1. Only Trial Balance and journal data will be consolidated - there is no consolidation of risks or documentation between entities ...
    • How do I roll forward a Consolidation file?

      Once an engagement with a Consolidated Entity has been completed, the next step would be to roll forward the Consolidation File.  The correct way to roll forward a consolidation entity is following the process below: 1. Roll forward all the ...