Group import template

Overview

The group import template (attached at the bottom of this article) shows examples of the information that can be imported using the group import function.
When using the group import template, there are specific columns that you should take note of as they affect the data import in certain ways.

The following columns must be populated:

• Company - this is the unique company code assigned to the taxpayer. Instructions on how to set up or edit the company code (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 number that corresponds to the required workpaper type. A document showing the adjustment IDs are for the different workpaper types can be found 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.
• 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. 

Templates

• Group Import Template
• Workpaper Adjustment IDs

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