Tax 2020.1 guides
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.1 |
AE Tax Homepages | 2020.1 |
AE | 5.4.35 |
- 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.
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.
Open the Tax Tracking System.
Click the Year icon.
- Click All.
On the Returns 2019 screen:
Sort by IRD number
Press Home to go to the top of the list
Look for and delete incomplete records.
Incomplete records don't display the year or the IRD number.
- Press End to go to the bottom of the list
Look for and delete incomplete records.
Check for an incomplete year or IRD number.
- Sort by Client order, then repeat step 4.
- Sort by Alpha order, then repeat step 4.
Select the required rollover options:
Select Utilities > Control Record > General
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.
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.
Click the Rollover tab
Refer to the following table and check the Rollover options.
Option Information 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.
Click OK when finished
Select Utilities > Control Record > Returns to verify the balance and workflow template attached to each return type.
Select Utilities > Balance Setup > Templates to review the balance templates and make sure the rollover created the correct balance codes.
Select Utilities > Workflow Setup > Templates to review the workflow templates and make sure the rollover created the correct workflow codes.
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 Reports > Practice Reports > Flags and review each one.
Delete any pre-rollover report layouts at the client level.
Select Maintenance > Letter Writing > Practice Letters.
- Delete any layouts at the client level, as marked in red above.
Highlight the letter layout code then click Delete.
Click Cancel when finished.
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.
Select Utilities > End of year.
- At the End of Year Options window click Purge Pre-rollover File.
Click Yes to proceed.
Click Cancel when finished.
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.
Select Utilities > End of Year and click Pre-rollover.
Double-click the template.
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.
To check the pre-rollover settings, select Utilities > End of Year > Pre-Rollover > 2020 > Properties.
You shouldn't need to change anything. Click OK.
Double-click the pre-rollover template created in Step 7: Check pre-rollover settings.
Click Yes to perform the pre-rollover.
When complete, you'll see the Select Pre-Rollover Options window.
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 Utilities > End 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:
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 Income | The 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 Utilities > Control 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 Utilities > Control Record > General, this amount will transfer to Last Year Prov in the 2020 return header. |
Student Loan | We'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 Utilities > Control 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.
- Transfer the letter layout from Master letters.
Select Maintenance > Letter Writing > Transfer Master Letters. - Edit the letters as required.
- Select Maintenance > Letter Writing > Practice Letters.
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.
- 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
Select Utilities > End of Year > Edit pre-rollover file.
Use the search to locate the IRD number for editing if required.
- 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.
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.
Select Utilities > End of year > Rollover.
Click Rollover.
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 Utilities > Control 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 Utilities > Control 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 Utilities > Control 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.
When the rollover has finished, the system automatically updates the current year in the control record.
To check the current year
Select Utilities > Control Record > Dates.
On the Edit Dates window, check that the Current year is 2020. If it isn't:
Click Edit.
- Change the Current year field to 2020.
- Click OK.
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.
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 |
- 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.
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 return | Summary of earnings KP13A, KP13B and student loan repayment deductions. |
IR4 Company return | Withholding payments KP12A, KP12B. |
IR6 Trust return | Schedular payments KP15A, KP15B. |
IR7 Partnership return | Schedular 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:
- Select Utilities > Rollover Returns.
- Tick the return types in the Rollover Options window.
- 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.
Open the Tax Returns System 2020 Ledger.
Select Utilities > Rollover Returns.
Accept the defaults and click OK to start the rollover.
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.