Video help

ConsolidationConsolidation

 

In this video:

  • Creating divisions
  • Importing trial balances
  • Adjustments
  • Chart of accounts
  • Audit trails

 

Jump to a specific point in the video with the chapters button in the video.

 

 

 

Entity setup features

 

Image shows the Edit entity screen in the software. The on-screen options have been labelled with numbers which correspond to the numbers in the table below.

 

  Option Function Notes
1

Import

Import a list of trial balance names / divisions from Excel
2

Export

Export a list of  trial balance names / divisions to Excel
  • See Divisions export below
  • This option is only available when there are consolidation trial balances / divisions other than the default Consolidation entries division
3

Entity name

Click to edit
  • Enter the full legal entity name
  • TAB or click out of the field to save the changes
  • Duplicate entity names are permitted. We recommend adding a Tag to distinguish them
  • The case printed in section headers can be changed via Styles
4

Tag

Set a tag for the entity, such as a reference or company number
  • A tag is optional
5

Import / Delete logo

Imports or deletes a logo for reports
  • Valid file types: PNG or JPG
  • Maximum file size: 2 MB
  • Maximum image size: 115 x 45 pixels. (Images larger than 115 x 45 pixels will be scaled in the report header, with aspect ratio locked)
  • Note: The logo must be turned on in each report using Insert logo in report header in Styles
6

New Parent / Single trial balances or divisions

Add new parent / single trial balances or divisions
7

New consolidation trial balances or divisions

Add new consolidation trial balances or divisions
8

Trial balance / Division name

Displays the trial balance / division name
  • Click and drag to change the order
9

Trial balance / Division alias

Displays the trial balance / division alias
  • The alias is used to identify each trial balance / division in inputs and outputs
  • The alias should be between 2 and 4 characters
  • Click and drag to change the order
10

Subconsolidation

Tick to include the trial balances / division in a subconsolidation
  • Select the trial balances or divisions to include in the subconsolidation, by clicking the Subconsolidation box. See the FAQ for more information
11

Edit trial balance / division

Edits a trial balance / division
  • Edit the trial balance / division name, alias and subconsolidation
12

Delete trial balance / division

Delete a trial balance / division
  • If a trial balance / division has adjustments and/or a trial balance, the delete icon will be disabled
  • To delete a trial balance / division, all adjustments and trial balances should be deleted for that division

 

 

Trial balances / Divisions

Divisions are used by all reports within an entity and any changes made to divisions will affect all reports, even if a report is locked.

 

In nearly all cases, a division represents a unique trial balance. Note: This is not where trial balances are imported.

 

To import a trial balance:

 

 

Add new trial balances / divisions

Parent / Single trial balances or divisions

Where multiple trial balances form a single entity, a division for each trial balance should be created within Parent / Single trial balances or divisions.

 

To add Parent / Single trial balances or divisions:

  • Click Home > Entity setup
  • Click New within Parent / Single trial balances or divisions 
  • Add a Name
  • Add a Alias
  • If required, set where it should be inserted
  • Click OK

 

Consolidation trial balances or divisions

To add Consolidation trial balances or divisions:

  • Click Home > Entity setup
  • Click New within Consolidation trial balances or divisions
  • Add a Name
  • Add a Alias
  • If required, set where it should be inserted
  • Click OK

 

 

Sort trial balances / divisions

  • Trial balances / divisions can be sorted in any order by dragging and dropping to a new position, including dragging between the Parent / Single and Consolidation groups
  • The trial balances / divisions order will also appear elsewhere, such as adjustments and audit trail outputs

 

 

Trial balances / divisions import

To import multiple trial balances / division names from an Excel file:

  • Click Home > Entity setup
  • Click Import
  • Select the file to import
  • Click OK

    Trial balances / Divisions are always imported to the Consolidation divisions group but can be moved to the Parent / Single divisions group by dragging them to the Parent / Single divisions group.

    The required format of the import file is:

 

 

 Column A Column B

Column

Trial balance / Division name

Trial balance / Division alias

Required

Required

Required

Notes

150 characters maximum length

2, 3 or 4 characters

 

 

The following image shows a valid sample file:

 

Image shows a screenshot of a valid Excel import file. In Column A are the divisions and Column B lists the aliases.

 

Import issues
  • The only valid file type that can be uploaded is an Excel file
  • Ensure the name is in column A, starting in cell A1
  • Ensure the alias is in column B, starting in cell B1
  • The filename is greater than 100 characters in length. Change the filename so it is less than 100 characters in length
  • The Excel file is password protected
  • The Excel file contains links to an external data source. Open the Excel file, click the Data tab and click Edit links to check for or remove links. Alternatively, copy and paste the divisions data into a new Excel file
     

Trial balance / Divisions export

To export the list of trial balance / division names to an Excel file:

  • Click Home > Entity setup
  • Click Export
     

Creating reports

To create a new report:

  • Click Home > Entity reports
  • Click New report 
  • Enter a report version
  • Click OK


The following frequently asked questions may help with creating new reports: