Group import template

Overview

A Consolidated Financial Statements group allows you to import trial balances and set up workpapers in multiple entities at once. It works for any entity type, not just companies. 

Instructions on setting up a Consolidated Financial Statements group and importing a trial balance file are here. 

You can use the group import template attached at the bottom of this article. The template includes examples of the information you can import. 

Group import data fields

When using the group import template, ensure you take note of specific columns that affect the data import process.

The following columns are mandatory:

• Company - this is the unique entity code assigned to the taxpayer. Instructions on how to set up or edit the entity code are here.
• Code - the trial balance account code
• Description - the trial balance account description
• Amount - the trial balance accounts amount.

The following columns are optional. Leave them blank if they are not required for an account.

• AccountGroup- this sets whether an account is Balance Sheet or Income Statement and is useful when importing new account codes. 
  • If an account is already categorised as Income Statement and the template says BS, then it will not change on import.
• AdjustmentType- this will add a workpaper to an account. Enter the ID number that corresponds to the required workpaper type. A document showing the AdjustmentType IDs for different workpaper types can be found in the Workpaper Mapping Guide at the bottom of this article.
  • This will only add a workpaper if there is not already one against the account. It will not change an existing workpaper type even if a different workpaper type is listed in the import template to what is on the account already.
  • The Workpaper Mapping Guide also shows what workpapers are available for which entity types. It is important to only try importing with AdjustmentTypes that are applicable for the entity type you are importing for. 
• ReturnDisclosureType- this sets a specific Tax Form Disclosure on a workpaper. It is not required to be set on every workpaper as it will automatically be set to a default tax form disclosure based on the workpaper type. 
  • Workpapers that are more likely to need a specific ReturnDisclosureType set are listed in the Workpaper Mapping Guide. 
• AccountsAdjustment- this populates basic adjustments for permanent difference workpapers.
  • Even if you populate a number against a account with a temporary difference workpaper or entertainment workpaper it will not bring that number in. 
  • It will only import numbers, not formulae such as =100%. 
• GrossIncome- this populates the Gross income field on workpapers. This is useful for dividend income workpapers where the gross (taxable) income is different to the amount in the accounts.
  • Where the accounts amount is the same as the gross income, it is best to leave this blank.  
• RWT - this populates the withholding tax on workpapers such as interest income and dividend income. Enter this as a negative value.
• ImputationCredits - this populates the imputation credits on dividend workpapers. Enter this as a negative value. 
• PaymentDate - this populates the Date Paid on workpapers that have that field such as interest income or dividend income. If left blank, the date paid will default to the balance date.
• ForeignIncomeTaxPaid - this populates the foreign tax paid on foreign income workpapers. Enter this as a negative value. 
• Segment - this populates the Segment on foreign income workpapers. 
• NRWTRate- use this with IR3 and IR3NR entity types to populate a Year end prescribed investor rate on a PIE income workpaper (IR3) or the NRWT rate on interest, dividend or royalty workpapers (IR3NR).
  • Enter the rate as a decimal. E.g. 28% would be entered in the Group Import Template as 0.28.

Templates

• Group Import Template
• Workpaper Mapping Guide

Note: Templates contain test data, please make a copy, and delete the test data.