APS NZ Xcede Sheets and Templates April 2022 Release Notes

Main Features of this release

This NZ Xcede Sheets release package includes: 

• Sheets released in April 2022 with subsequent:
  • Amendments for enhancement and corrections
  • New sheets.
• Master template and entity templates:
  • New and amended financial reporting fields
     
• This document has been divided into the following sections:
• Section 1: Xcede sheets (New and amended)
• Section 2: Template changes
• Appendices: Explain the layout and reporting options for new and amended sheets.

Pre-requisites

•    XPA version 11.1 
•    Xcede Reporting Engine 10.9.25

Online Help

The APS Xcede Sheets Configuration Guide is available with this release. This online help document can be included as a Windows Help file and made available to all users through the Advance Central Console, Help menu. 

Please read the accompanying Upgrade and Installation document for instructions on installing the Configuration Guide.

Retiring Software versions 

The following versions of XPA and Xcede Reporting Engine are retired. 

• XPA 10.2 or prior
• Xcede Reporting Engine 10.8.6.14 or prior.

Financial Reporting Field Codes

In this article, new and existing Financial Reporting Fields (FRFs) will be referred to using the field code label e.g. <FirstYear>. 

To view the field code, open the FRF window in XPA and click the Show Maintenance Columns   icon.

Amended Sheets

New Sheets

Jobstreams

New Jobstreams

Template: APS NZ MASTER 2022

Amended Jobstreams

Template: APS NZ MASTER 2022

IMPORTANT!
Where the practice maintains its own Master Template and refresh financial reporting fields from the released template, jobstreams will not automatically be amended. These will need to be updated manually.

The table below lists only the New or Deleted sheets on the amended jobstreams, please compare these against the jobstream on the APS NZ MASTER 2022.XPA.

Financial Reporting Fields

New Fields

Template: APS NZ MASTER 2022

Where a report has a new group of FRFs, all the fields won’t be listed. Please refer to the template to review the group of consecutive new fields.

Version Change

Template: APS NZ MASTER 2022

​​​

Group Change

Template: APS NZ MASTER 2022

FRF Label Changes

Template: APS NZ MASTER 2022

​​

Deleted FRFs

Template: APS NZ MASTER 2022

    Livestock Groups

  New Livestock Groups

Template: APS NZ LIVESTOCK DIVISION

Where NZIFRS ledger and the policy test <PT-Har> is set to ‘Yes’ financial reporting fields are provided to enter the standard name and user defined paragraphs.

These FRFs are deleted annually and replaced with new FRFs for the ‘new and amended standards’. 

This year, provision has been made for:

•  Amendments to References to the Conceptual Framework in NZ IFRS
  • 1 UDF paragraph
•   Annual Improvements to NZ IFRS 2018 - 2020
  • Introductory paragraph, 3 subsections which includes a Title & UDF paragraph.
•  Covid 19 Related Rent Concessions - beyond 30.06.21
  • 4 UDF paragraph 
•  Interest Rate Benchmark Reform - Phase 2 (amendments to NZ IFRS 4,  NZ IFRS 7, NZ IFRS 9, NZ IFRS 16 and NZ IAS 39)
  • 3 UDF paragraphs 

   Note - Where the categorisation of an expense has changed e.g. Grants which have 'a use or return condition', please retag the accounts.

Sample Output

For NZIFRS ledgers only (<PT-Basis> = “1” or “2”), a new note (2n-BiologicalAssets) has been created to display a reconciliation of changes in the carrying amount of biological assets between the beginning and the end of the current period.
Note: 2LSTrading displays the detailed movements.

Each account 710:719 can either be presented in current assets or non-current assets. Select ‘Yes’ to FRFs <LvStk710Mv - LvStk719Mv> to move the account balance into Non-Current Assets.

The Biological Assets note is called from the Balance Sheet and is triggered by a balance in accounts 710:719 along with either the 2n-Inventories or 2n-NCA_Livestock notes.

Note Options

Financial reporting fields: Notes to the Financial Statements>Biological Assets.

The note heading can be customised < N-BioAH> and there is a user defined paragraph for additional disclosure <N-BioAUD>.

There is also an additional section to enter a heading (optional) and user defined paragraphs. These could be used if disclosure on Government Grants is required:

• < N-BioAT> User defined title 1
• < N-BioAUD1> user defined paragraph
• < N-BioAUD2> user defined paragraph.

To stop the note from printing, set the Stop Print – Notes financial reporting field <SP-BioAs> to ‘Yes’.

For more detail on the Financial Reporting Fields and the Presentation of livestock, including the Livestock Policy and Notes, refer to Assets > Livestock (710:719) in the Online Help.

Sample Outpt

Example Trial Balance

Scenario 1: Accounts 710:719 are presented in current assets.

Scenario 2: Accounts 710:719 are presented in non-current assets.

Scenario 3: Accounts 710:719 are split between current and non-current assets.




​​​​​​

The following enhancements have been made to the Depreciation Schedules:

• Asset Account Code
• Print ONLY assets with closing WDV equal or less than a value
• Depreciation Schedule – Department or Location (New report)

Asset Account Code

An FRF <DepnAccCd> has been added to enable users to display the asset account code, in brackets, after the description on the depreciation schedules.

Note: The default setting is “No”. This will need to be changed to “Yes” for to display the asset account codes.

Depreciation Schedules:

Sample Output

Print ONLY Assets with Closing WDV Equal or Less than a Value

An FRF <DepnCWDV> has been added to enable users to display only those assets that are equal to or less than a certain value.

This enhancement could be useful for displaying only low value assets that could be written off.

Depreciation Schedules:

Sample Output

Enter the closing WDV threshold into FRF <DepnCWDV>.

Note: If either FRF <DepnCWDV> has a value or <DepnZero> is set to Yes, the summary section on the following depreciation schedules won’t print:

• 2Depnnz-P
• 2Depnnz-P_book
• 2Depnnz-P_Tax
• 2DepnNZLeased-P

Depreciation Schedule – Department or Location

The following new depreciation schedule have been created:

• 2DEPNNZDeptLoc.xlsb will sort assets by either department or location
• 2DEPNNZDeptLocCheck has been created to help identify assets with incorrect data in the Department or Location field.

Asset Ledger

The ‘Department’ and ‘Location’ fields are located on the ‘Description’ tab of the ‘Assets’ screen in the asset ledger.

Simply select the asset, add data to the ‘Department’ or ‘Location’ field and select the ‘Save’ icon.

Report Options

2DEPNNZDeptLoc has the same reporting options as the other standard depreciation schedules.

The reporting field group <Depreciation Schedule - Group by Department or Location> has additional reporting options that are specific to this schedule.

FRF <DepGrDL> is used to specify whether the report is to sorted by department or location:

• Department: enter ‘1’
• Location: enter ‘2’.

Once the ‘Department’ or ‘Location’ field has been populated on the individual assets in the asset ledger, these categories need to be added to the FRFs <DepGrDL1 … DepGrDL20>.

• Any assets that have a blank department code are included on the schedule in a group titled ‘Unclassified Assets’.
• Where the Department or Location data in the asset ledger does not match the data in the FRFs, then these assets are not able to be picked up and are excluded on the depreciation schedule.

The depreciation schedule will display a “Warning: Asset Schedule Out Of Balance” message, which indicates that some assets are missing.

Use the depreciation schedule 2DEPNNZDeptLocCheck to identify assets with incorrect data in the Department or Location field.

When adding the data in the asset ledger and FRFs <DepGrDL1 … DepGrDL20>, use ‘copy’ and ‘paste’ to make the process faster and more efficient and cut down on spelling mistakes.

The FRF <DepGrDLTot> controls whether a subtotal is included for each department. The default has been set to ‘Yes’, to include the subtotal.

The FRF <DepGrDLSum> controls whether a summary of asset by Department or Location prints at the end of the report. The default has been set to ‘Yes’, to include the summary.

Printing the Report

The reports; 2DEPNNZDeptLoc and 2DEPNNZDeptLocCheck have been merged into the APS NZ MASTER templates and will need to be added to a jobstream to print.

Sample Output - 2DEPNNZDeptLoc

Sample Output - 2DEPNNZDeptLocCheck

This depreciation schedule identifies assets where Department or Location data does not match the data in FRFs <DepGrDL1...DepGrDL20> by formatting the cells in the Department or Location column with a red background.

This depreciation schedule displays the individual assets in detail, it does have the ability to print only Asset Group totals <TotalsOnly>. It also does not display any private use depreciation columns.

A new FRF <AccCode>, has been added to assist with troubleshooting.

When the FRF is set to Yes, a column will display with the account codes and the Note number column will be hidden.

Sample Output

“ : “ in the Code column indicates that a range of main accounts have been called and a cumulative value is displayed. The first account code in the range will display.

Where a main or sub account is displayed e.g. 103/ or 169/001, this indicates that the report is displaying detail and the row is displaying a value from a single account code.

Where there is no account code displayed, the values are either calculated (in some instances the detail can be displayed by unhiding the rows above), taken from a named cell on another sheet, the cumulative value of a tag set or an FRF value.

The following new Group Performance Summary reports use the ‘VA_Reports’ tag set and are based on the existing Group Performance Summary report, enabling users to report on data for up to 10 ledgers.

• Group Performance Summary – 5 Years (VA_GroupPerformanceSummary5yr) - Displays a summary of the group’s combined performance for up to 5 years.
• Group Performance Summary Trend – 5 Years (VA_GroupPerformanceSummary5yrTrend).  Displays a summary of the group’s combined performance for up to 5 years. The report displays combined values, percentages and trend lines.

Report Options

The report uses the financial reporting field (FRF) settings from the source ledger (i.e. the ledger used to generate the report).

The 5 Years reports (VA_GroupPerformanceSummary5yr & VA_GroupPerformanceSummary5yrTrend) will display up to 5 years of data by default, provided the data exists on the ledgers. To override the default, enter the number of years to be include <VA_GPRNoYr>.

User defined titles for all the tags can be set in the FRF group ‘VA_Reports - User Defined Fields’.

There are 10 Ledger Filename FRFs <VA_GPREn1- VA_GPREn10> to enter the filenames for the ledgers in the group. Note: Exclude .XPA from the filename in the FRF.

If the source ledger is to be included in the group, the FRF ‘Ledger 1 Filename – leave blank for source ledger’ can be left blank.

Options within the reports are:

• Customise the report headings <VA_GPRHead>, <VA_GPRHea5> or <VA_GPRTH5> 
• Customise the headings for Income <VA_Hinc>, Cost of Goods Sold <VA_HCOG> and Expenses <VA_Hexp>
• Display Other Income with Income or after EBITDA <VA_GPRIncM>
• Owners’ remuneration can be reportedly separately from expenses <VA_GPRExcl> and moved after EBIT or Other Income <VA_GPRRemM>

Group Performance Summary Trend Reports
In addition to the FRFs in the Group Performance Summary group, the Trend reports also use the FRFs from the Group Performance Summary Trend group.

There is the option to customise the report heading <VA_GPRTH5>. A User Defined paragraph can be included to describe items in the report <VA_GPRTUDF> and the trend lines shown in the report can be excluded if not required <VA_GPRTGP$ … VA_GPRTNP%>.


Report Data
YTD figures are retrieved for the default period set by the source ledger. The reports display the total of each tag and figures are retrieved for the default period set by the source ledger.

Sample Report - Group Performance Summary – 5 Years

VA_GroupPerformanceSummary5yr

The report displays a combined total for each tag. The report will display up to 5 years of data by default if there is data available. To override the default, enter the number of years to be included in FRF, <VA_GPRNoYr>.

Sample Report - Group Performance Summary Trend – 5 Years

VA_GroupPerformanceSummary5yrTrend

The report will display up to 5 years of data by default if there is data available. To override the default, enter the number of years to be included in FRF, <VA_GPRNoYr>.

To exclude trend lines, select No to the relevant FRF; <VA_GPRTGP$ … VA_GPRTNP%>.

Group Performance Summary Trend Calculations

The calculations for the reports are based on accounts tagged.

Gross Profit/(Loss) Amount: Total Revenue – Total Cost of Goods Sold – Total Manufacturing/Direct Costs

Gross Profit/(Loss) Percentage: Gross Profit/(Loss) Amount / Total Revenue

Earnings Before Interest, Tax, Depreciation and Amortization (EBITDA) Amount: Gross Profit/(Loss) – Total Expenses (excluding interest, depreciation and tax)

Earnings Before Interest, Tax, Depreciation and Amortization (EBITDA) Percentage:
Earnings Before Interest, Tax, Depreciation and Amortization (EBITDA) amount / Total Revenue

Net Profit/(Loss) Amount: Gross Profit/(Loss) – Total Expenses

Net Profit/(Loss) Percentage: Net Profit/(Loss) amount / Total Revenue

<A_CompliH> Set to Yes

Warning Message

Ledgers selected for group reporting should all have the same number of periods, with the same period / year end dates.

If the group ledgers are in a different year or period to the source ledger, or a filename entered into the financial reporting fields is invalid, or the ledger does not have an ‘Organisation’ name in File Details a red warning message will be displayed at the top of the report.

The example below is from the Group Performance Summary 5 Year report.

For the Group Performance Summary 5 Year reports, unhide the rows below the red warning message and the columns to the right of the report to identify the group ledger/s causing the issue.