Skip to main content
Skip table of contents

Tax 2020 guides

Tax tracking EOY returns
Prerequisites
Check your versions

Make sure you have the following versions or later:

Application

Minimum version

System Release

8.1a

Central Database

6.3aNZ

AE Tax Returns System*

2020.0

AE Tax Homepages

2020.0

AE

5.4.34

Pre-installation checks
  • Make sure everyone's logged out of all MYOB programs.
  • Check that your computer meets the system requirements.
  • Back up the Tax Tracking system:
    • for CFS Tax, you can either use the System Services backup option or copy data files through Windows Explorer.

    • the Tax Tracking System 2019 files are DZZNT*, usually located in the \SOL63\TAXFILE folder

    • for SQL Tax, use SQL Server Management Studio.

End of year procedure

There are 13 steps to the end of year procedure.

Step 1: Check for incomplete records

If any of the columns below are not showing in the returns index, make them available by ticking the required column from within the View button.

  1. Open the Tax Tracking System.

  2. Click the Year 

    icon.

  3. Click All.
  4. On the Returns 2019 screen:

    1. Sort by IRD number

    2. Press Home to go to the top of the list

    3. Look for and delete incomplete records.

      Incomplete records don't display the year or the IRD number.

    4. Press End to go to the bottom of the list
    5. Look for and delete incomplete records.

      Check for an incomplete year or IRD number.

  5. Sort by Client order, then repeat step 4.
  6. Sort by Alpha order, then repeat step 4.

Step 2: Check your general options

Select the required rollover options:

  1. Select UtilitiesControl Record > General

  2. Click the Return Header tab in the General Options window.

    If you change any settings, existing fields will only update when you add new values or manually refresh the existing data.

  3. Refer to the following table and check the Return Header options.

    Option

    Information

    Update RIT from provisional balances

    If ticked, the RIT field under the Tax section of the return header shows the total of the provisional amounts in the calculated column of the balances area less uplift.

    If not ticked, the RIT field is only updated when the return is finalised in the Tax Returns System.

    Update provisional from balances

    If ticked, the Prov Tax field under the Tax section of return header shows the total of the provisional amounts in the calculated column of the Balances area.

    If not ticked, the Prov Tax field is updated after the end of year rollover and when the return is finalised in the Tax Returns System.

    Include voluntary with provisional and RIT

    If ticked, any voluntary amounts in the calculated column of the Balances area are included in the RIT and/or Prov Tax fields under the Tax section of the return header only if Update RIT from provisional balances and/or Update provisional from balances are also ticked. This will affect the next year’s provisional value calculated at rollover.

    Update next year LY prov when balances modified

    If ticked:

    • any changes to balances or transactions in the calculated column, including voluntary payments, flow through to the LY Prov field in the following year TTS General screen.

    • any changes to the calculated amounts in the previous year’s balances tab flow through to the next year General tab in the LY Prov field.

    Remove lodged workflow dates

    If ticked, the workflow date is removed from the Lodged workflow when undoing the status of a tax return from lodged.

    If not ticked, the workflow date is not removed from the Lodged workflow.

    This option is ticked by default.

    Addfullstop to initials

    If ticked, the individual’s name prints with a full stop after each initial.

    If not ticked, a space prints after each initial.

    TXNAME takes precedence in A185

    If ticked, the name from the TXNAME field in CDS populates the letter-writing field A185 exactly as entered.

    If not ticked, or TXNAME is not present in CDS for a client, the formatted name from the Details tab in CDS populates letter writing field A185. For example Mrs Angela Belinda Cook prints as Mrs A B Cook.

  4. Click the Rollover tab

  5. Refer to the following table and check the Rollover options.

    OptionInformation
    Zero RIT on Rollover

    When ticked, the RIT field under the tax section of the return header will rollover as zero.

    If not ticked, the RIT field shows the total of provisional amounts in the calculated column of the balances area less uplift.

    Trf Actual prov values to LY on rollover

    When ticked, the LY Prov field in the tax section of the return header will update with the value of all the provisional and voluntary payments (i.e., actuals) attached to P1, P2, P3 and V1, V2, V3 balance codes.

    If not ticked, LY Prov will update with the P1, P2, P3 calculated amounts and also V1, V2, V3 if Include voluntary with provisional and RIT is selected.

    If this option is selected and you have also selected Update next year LY prov when balances modified on the Return Header tab, the actual amounts update from the LY balances screen if modified into the current year LY field in the TTS General tab.
    Roll notes

    If ticked, the notes attached to the return header rollover into the new year when a rollover is performed.

    If not ticked, the notes won't rollover.

    Roll comment

    If ticked, the comments attached to the return header will be rolled over into the new year when a rollover is performed.

    If not ticked, the comments will not be rolled over.

    Roll student loan

    If ticked, the calculated student loan payments are added together uplifted to generate three student loan interim balances in the new year when a rollover is performed.

    If not ticked, the student loan will not be rolled.

  6. Click OK when finished

Step 3: Check templates
  1. Select UtilitiesControl Record > Returns to verify the balance and workflow template attached to each return type.

  2. Select UtilitiesBalance Setup > Templates to review the balance templates and make sure the rollover created the correct balance codes.

  3. Select UtilitiesWorkflow Setup > Templates to review the workflow templates and make sure the rollover created the correct workflow codes.

Step 4: Check the return header flags

The flags roll forward with the same settings as in the 2019 return header unless specified below:

  • Estimated: If selected in 2019, it won't be selected in 2020

  • Final: If selected in 2019, it won't be included in the rollover.

To check your flag settings, select ReportsPractice ReportsFlags and review each one.

Step 5: Delete layouts

Delete any pre-rollover report layouts at the client level.

  1. Select MaintenanceLetter Writing > Practice Letters.

  2. Delete any layouts at the client level, as marked in red above.
  3. Highlight the letter layout code then click Delete.

  4. Click Cancel when finished.

Step 6: Purge the pre-rollover file

Delete the contents of the pre-rollover holding file before performing the rollover. If you don't delete the file, we'll append to it.

  1. Select Utilities > End of year.

  2. At the End of Year Options window click Purge Pre-rollover File.
  3. Click Yes to proceed.

  4. Click Cancel when finished.

Step 7: Check pre-rollover settings

To rollover all returns (with no exceptions), select one of our pre-rollover templates.

Once you've generated the pre-rollover report, it is final. This means the rollover won't include any changes you make to returns after this time.

  1. Select Utilities > End of Year and click Pre-rollover.

  2. Double-click the template.

  3. Double-click the template. The Select Pre-Rollover Options screen opens.

    If you need to create a pre-rollover file with exclusions, you must:

    • create a new pre-rollover template
    • click Selections to define the exclusion to the rollover.
  4. To check the pre-rollover settings, select UtilitiesEnd of YearPre-Rollover > 2020 > Properties.
    You shouldn't need to change anything. Click OK.

Step 8: Pre-rollover execution
  1. Double-click the pre-rollover template created in Step 7: Check pre-rollover settings.

  2. Click Yes to perform the pre-rollover.

  3. When complete, you'll see the Select Pre-Rollover Options window.

Step 9: Rollover

Do not rollover into the new year until you've completed this step.

The pre-rollover step creates a holding file from which the final rollover is based. The pre-rollover can be rerun with new data added to the information previously created in the holding file.

Print the holding file to provide a detailed report for a partner or manager to check prior to rollover. File the report after it has been checked.

To list the pre-rollover file, select UtilitiesEnd of Year > List pre-rollover.

The layouts can include the following dependant on the sequence chosen:

Report legend

Column

Details

Year

The year to roll from.

IRD Number

The IRD number of the client.

Type

Return type.

Name

The name of the client.

Est

Indicates if the 2020 provisional tax was estimated. The Estimated flag is selected in the 2019 return header.

Lodged

The date the 2019 return was lodged.

Partner

Partner code.

Client

Client code.

Alpha

Return alpha.

Return

Return code.

Basis

For a finalised 2019 return, we'll base the calculation on the actual 2019 RIT, so the basis will be Calc.

For an unfinished 2019 return, the basis will be Prev.

Prov Method

Shows:

  • Std if provisional tax paid in three instalments

  • 6Mth if provisional tax paid in two instalments

  • Ratio if provisional tax is calculated and paid on the GST return.

The method is obtained from the information in the GST tab of the return header.

This Yr Voluntary

The total amount of voluntary payments made for 2020 provisional tax.

Any voluntary payments made during the year may affect the provisional tax generated for the new year. This depends on the selections in Utilities > Control Record > General regarding the RIT and Prov Tax updates on the tax section of the return header.

This Yr Taxable IncomeThe 2019 taxable income.

This Yr RIT

The RIT value from the 2019 return header.

Next Yr Provisional

The amount calculated for 2020 provisional tax.

The uplift is applied to the RIT value unless the 2019 RIT value is zero, the 2019 return has not been finalised and there was 2020 provisional tax, then the 2020 provisional tax will be equal to the 2019 provisional tax, i.e. ‘safe harbour’. We won't calculate provisional tax for 2019 if the GST tab ratio setting is Y.

This Yr Act Prov

The amount of actual provisional tax paid.

If you select Transfer Actual prov values to LY on rollover in UtilitiesControl Record > General, this amount transfers to Last Year Prov in the 2020 return header.

This Yr Calc Prov

The amount of calculated 2020 provisional tax.

If you don't select Transfer Actual prov values to LY on rollover in UtilitiesControl Record > General, this amount will transfer to Last Year Prov in the 2020 return header.

Student LoanWe'll list student loan on the report if the client has S1, S2 or S3 in 2019. Student loan only rolls into 2020 if it's selected in UtilitiesControl Record > General.


Edit layouts

Only perform this step if you need to.

You can edit the letter layout used in the pre-rollover process to suit your practice.

  1. Transfer the letter layout from Master letters.
    Select MaintenanceLetter Writing > Transfer Master Letters.
  2. Edit the letters as required.
  3. Select MaintenanceLetter Writing > Practice Letters.

  4. Highlight and double-click the letter layout code to open it for editing.

    Once you've transferred a letter layout to client level, it is final. We won't recognise any changes made to the pre-rollover report layout in future releases until you:

    • delete the letter layout at client level or
    • transfer an updated copy from master level.
Step 10: Edit the pre-rollover file
  • You can edit the holding file after a partner or manager has checked the printed pre-rollover report.
  • If you delete a return from this list, it won't rollover to the next year.

  • If you need to manually insert a return after you've deleted it in error, contact MYOB support.

To edit the pre-rollover file

  1. Select UtilitiesEnd of Year > Edit pre-rollover file.

  2. Use the search to locate the IRD number for editing if required.

Step 11: Back up the Tax Tracking System
  • Make sure everyone's logged out of all MYOB programs.
  • Back up the Tax Tracking System:
    • For CFS Tax, you can either use the System Services backup option or copy data files through Windows Explorer
      The Tax Tracking System 2019 files are DZZNT*, usually located in the \SOL63\TAXFILE folder

    • For SQL Tax, use SQL Server Management Studio.
Step 12: Rollover

This step of the end of year rollover generates the 2020 return headers.

You must not interrupt the rollover. How long it takes depends on the size of the ledger and the speed of the computer.

  1. Select UtilitiesEnd of year > Rollover.

  2. Click Rollover.

  3. Click Yes at the prompt to perform the rollover.

Return Properties screens post-rollover

You can access the following screens by entering on any return and showing the rolled information.

General tab

The General tab should look like this:

 

 

Field

Information

Name, Return Address and Team information

From your central database.

Return Type, Location, Balance Month and Required Flag

2019 RIT

Will be zero, or calculated 2020 provisional tax less uplift, depending on the selection in UtilitiesControl Record > General.

2019 Prov Tax (per Balances tab)

The total of P1, P2 and P3.

Losses B/F

The amount from Losses C/F in 2019.

Excess Imp credits B/F

The amount from Excess Imp credits c/f in 2019.

2019 Prov

Calculated provisional tax from 2019 or the actual payments, depending on the selection in UtilitiesControl Record > General. You can also include voluntary amounts.

 

Other Details

The GST tab should look like this:

 

This screen shows all information relating to GST, AIM and Ratio settings.

MYOB Balances tab

The MYOB Balances tab should look like this:

 

Balance codes created as per template.

 

Field

Information

P1, P2, P3

We've divided the calculated provisional tax into three provisional tax amounts.

S1, S2, S3

If selected in UtilitiesControl Record > General, the calculated student loan is divided into three student loan amounts.

 

Workflow tab

The Workflow tab should like this:

 

 

Shows workflow codes created as per template.

Step 13: Check the current year in the control record

When the rollover has finished, the system automatically updates the current year in the control record.

To check the current year

  1. Select UtilitiesControl Record > Dates.

  2. On the Edit Dates window, check that the Current year is 2020. If it isn't:

    1. Click Edit.

    2. Change the Current year field to 2020.
    3. Click OK.
Tax returns rollover

We strongly recommend that you rollover your tax returns in bulk. A rollover transfers all 2019 information (except dollar values) of the selected schedule(s) into the 2020 return header.

Read this guide completely before you start your rollover. It will help you plan for the tasks required.

If you need help with your tax returns rollover, contact your client manager on 0800 94 96 99 and ask about our tax year-end service.

For general support, contact the MYOB call centre on 0800 94 96 98 or go to my.MYOB and log a support request.

Prerequisites
Check your versions

Make sure you have the following versions or later:

Application

Minimum version

System Release

8.1a

Central Database

6.3aNZ

AE Tax Returns System*

2020.0

AE Tax Homepages

2020.0

AE

5.4.34

Pre-installation checks
  • Make sure everyone's logged out of all MYOB programs.
  • Check that your computer meets the system requirements.
  • Back up the Tax Returns system:
    • For CFS Tax, you can either use the System Services backup option or copy data files through Windows Explorer
      The Tax Returns System 2019 files are DZZNQ8*, usually located in the \SOL63\TAXFILE folder

    • For SQL Tax, use SQL Server Management Studio.
To rollover returns
Check your return rollover defaults

The Tax Returns System 2020 can receive an electronic Summary of Earnings (SOE) file from the Inland Revenue (IR).

IR will send the SOE file to your tax agents mailbox in early May 2020.

The following table lists the return types, the income data that will be in the SOE file, and the key points to be updated:

Return type 
IR3 Individual return

Summary of earnings KP11, KP11A, KP11E, family assistance payments from WINZ, and student loan repayment deductions.

SchedularpaymentsKP12A, KP12B.

IR3 Non-resident returnSummary of earnings KP13A, KP13B and student loan repayment deductions.
IR4 Company returnWithholding payments KP12A, KP12B.
IR6 Trust returnSchedular payments KP15A, KP15B.
IR7 Partnership returnSchedular payments KP10A, KP10B.

 

Because this information can be imported, the rollover settings for the SOE and the Withholding Tax options in the Select Schedules Types to Roll window won't be selected by default.

Bulk rollover settings

If you usually roll all tax returns together, and you want to include schedules in the rollover:

  1. Select Utilities > Rollover Returns.
  2. Tick the return types in the Rollover Options window.
  3. Click each of the schedule buttons to select the schedule types to be rolled over with the returns, as shown below:

 

The IR10 accounts information schedule isn't ticked by default. This is to ensure the warning will display if you haven't accessed the schedule. If you want to rollover the schedule, you must select it.
The IR833 property sale information schedule isn't ticked by default. This is because you may not want to rollover a one-off property sale.

To rollover in bulk
  1. Open the Tax Returns System 2020 Ledger.

  2. Select Utilities > Rollover Returns.

  3. Accept the defaults and click OK to start the rollover.

  4. On completion, the Returns listing will include all returns with a status of rolled. After you've accessed a return, the status will change to active.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.