Follow

Print Reports & Reconcile Payment Summaries’ values 

In preparing your end of financial year you will need to reconcile your year to date. This means that you run and reconcile reports to ensure that payroll balances back to your accounting system. 

There are four to run from the Reports menu: 

  1. Payment Summary > Year to Date 
  2. Allowances > Year to Date 
  3. ATO Payment Summaries > ATO Payment Summary Differences 
  4. ATO Payment Summaries > ATO Payment Summary Report 

If you have changed your financial year end boundaries as discussed in Preparation Step 1, then you would run the above reports with dates ranges outlined in your File > Company Details > Configuration > Period End for the current year. 

 blobid0.png

If you have utilized the Period End option, but would still like to create the reports using Wagemaster’s Financial Year to date option, you will need to utilize an additional report Reports > Payment Summary > Financial Year Difference to balance what will be recorded on the Employee’s ATO Payment Summaries for the Financial Year 2018/2019. 

blobid1.jpg

 

Reports > Payment Summary > Year to Date (Financial) 

The Payment Summary is a record of what your Employees have been paid through Wagemaster for the financial year 2018/2019 as per their saved pay slips. 

The Net and Tax totals from this Payment Summary Report need to balance to Agrimaster. Your overall company financial records/reports that you could use to balance this Payment Summary Report to, may be stored in either a General Leger system (GL) or Profit & Loss system (P&L). Your Accountant will be able to assist in providing you with the figures to balance wages, tax, superannuation, union, allowances and other payments made to employees. If your business does not use one of these systems check the amounts against your bank deposit records. 

Reasons for discrepancies: 

  • Year to date values for terminated employees may not have been brought forward from a previous payroll system if you crossed over to Wagemaster mid financial year. 
  • Payments have been made to Employees outside of Wagemaster and recorded in your GL/Bank Deposits but not in Wagemaster payroll. 
  • Data has been entered into a copy of the original database. 
  • Employee files have been deleted. 
  • You have set up an alternate Period End within your Period End table and not customized this Report’s date range to match (Use the Financial Year Payment Summary Difference Report). 

Once a discrepancy is identified and understood, it can then be rectified. If additional Payments need to be entered a Supplementary pay slip may be used (File > Maintenance > Supplementary Payslip). 

After making any required amendments, rerun this report and confirm the figures are now correct. Every other report should now balance back to this Payment Summary Report. 

 blobid2.png

Reports > Allowances > Year to Date 

This report will show you the YTD values that have been paid or deducted for each type of allowance. If you have an alternative Period End date setup for your year-end boundaries, you will need to run this report using the Start and Finish dates, as identified in the Period End screen. 

This will cover all the Pay period ends within this range rather than selecting the YTD (financial) option to reconcile. 

Not all Allowances need to display on an employee ATO Payment Summary. Please consult with your Accountant, Association for a full listing of allowances required to show separately on your Employees ATO payment summary. Some further information is available from the ATO. 

https://www.ato.gov.au/forms/payg-payment-summary---individual-non-business/?page=4&Allowances

Refer to End of Year Preparation Step 5 for detail on Allowance configuration. 

blobid3.png

Reports > ATO Payment Summaries >ATO Payment Summary Differences 

This report highlights any variations between Wagemaster’s Payment Summary report (saved payslips) and what is going to print on the Employee’s individual ATO Payment Summary (Employee > Payments > ATO Summaries screen). In most cases this report should appear with the mes  “No Matching Records Found for this report”. 

Reasons that an Employee would show on this Report. 

  • The Employee had two files and you have combined the amounts into one of these files to produce one ATO Payment summary for the employee. 
  • As the ATO Payment fields in the employee files can be edited, an amount may have been accidently changed. 

Once a discrepancy is identified and understood, it can then be rectified if needed, by editing the fields under Employee File > Payments > ATO Summaries. Highlight the Gross Wages and/or Tax Paid cell and type in the ‘true’ identified amount. 

Re-run the Report to check that any accidental changes have now been rectified. 

Reports > ATO Payment Summaries > ATO Payment Summary Report. 

blobid4.jpg

Use this report to check/balance ATO payment summaries. 

This report displays the exact amounts that are going to print on the employee’s individual ATO Payment summaries. This is the final check before printing, that everything balances to your Payment Summary YTD. If you have been selecting “Financial Year to date”, as opposed to customizing your date range, you will need to run the Reports > Payment Summary > Financial Year differences report if your Period End dates selected are not 01/07/2018- 30/06/2019. 

You can now also check the figures against the new Payment Date report under Reports > By Payment Date > Payment Summary > Year to Date, the figures shown will be the figures as per the EFT Banking process date. 

Total Gross – Refers to the overall Total taxable payments made to the Employee via payslips processed through the payroll. This is referencing the “Gross Wages” field from the Employee / Payments / ATO Summaries screen.

Total Gross = PS Gross + Lump Sum A + B + D + E + CDEP + ETP + Pre Tax Allowances flagged to show separately on payment summary. 

Total Tax is the overall Total amount of tax that has been withheld from the Employee via payslips processed through the payroll. This is referenced in the “Tax Paid” field in Employee / Payments / ATO Summaries.

Total Tax = PS Tax + ETP Tax. 

PS Gross – Refers to what will print in the Gross Payments field on the ATO Payment Summary. This is referencing the “Summary Gross” field from the Employee / Payments / ATO Summary screen.

PS Gross = Total Gross - Lump Sum A - B - D - E - CDEP – ETP - Pre Tax Allowances flagged to show separately on payment summary. 

PS Tax – Refers to what will print in the Total Tax Withheld field on the ATO Payment Summary. This is referencing the “Summary Tax” field in Employee / Payments / ATO Summaries.

PS Tax = Total tax – ETP tax 

The ETP Gross and ETP Tax figures can be found in the Employee file under Employee > Payments > ATO Summaries screen > ETP tab. These fields will only be accessible once the Employee has been terminated. 

Discussion about the contents of ATO Payments summaries. 

What is Wagemaster referencing in the Employment Termination Payment screen? 

The below table will help you decide if any part of an Employment Termination Payment has resulted in Wagemaster referencing it in the ETP screen. Due to the nature of the Termination, these payments can be taxed differently (excluded or non-excluded) from other kinds of payments made on termination of employment. 

No manual changes or editing can be done to the ETP screen in the employee file. Please note a manual summary will need to be created outside of Wagemaster if the ETP figures in Wagemaster are not correct. You will be required to use the following paper forms prescribed by the ATO: 

  • PAYG payment summary - employment termination payment (NAT 70868) when issuing a payment summary to your employee. 
  • PAYG payment summary statement (NAT 3447) when lodging an annual report for the ETP payment summary paper forms. 

The paper annual report will be an additional lodgement to any electronic lodgement made. The electronic file must not contain those incorrect ETP payment summary records. 

Please see the section on “Excluding Employees from   Wagemaster EMPDUPE and ATO Payment Summary Print Process” in this manual. 

 

What is and isn't an Employment Termination Payment? 

 

 Wage Easy will reference payments in the ETP screen that have been taxed at Termination Lower or Upper cap due to the nature of the Termination Payment. 

It is important to consult the ATO or your Accountant if you are unsure of an amount to appear on an ETP Payment Summary. 

Multiple ETP payments for the same termination 

ETP Code 

Description 

R 

The ETP was paid this year and is due to an early retirement scheme, genuine redundancy, invalidity; or compensation as a result of personal injury, unfair dismissal, harassment or discrimination. 

O 

This code relates to any other type of ETP, also paid this year, such as a golden handshake, payment in lieu of notice, payment for unused sick leave or RDO. 

S 

This code relates to ETPs paid this year, and for the same reasons as code R, but is used when the employee was paid an ETP related to the same termination in the last financial year. 

P 

The code relates to ETPs paid this year, for the same reasons as code O, but is used when the employee was paid an ETP related to the same termination in the last financial year. 

 

For more information about completing the PAYG payment summary, refer to 

How to complete the PAYG payment summary - employment termination payment 

Excluding Employees from Wagemaster EMPDUPE and ATO Payment Summary Print Process: 

To exclude employees from the ATO Payments Summary Print Process and EMDUPE file navigate to Employee File > Payments > ATO Summaries > Delivery Options then tick Exclude this employees ATO Payment Summaries from export/print process. 

blobid5.png

Notice too, equivalent tick box for when you are live in STP Reporting. 

Amended Payment Summaries 

An original payment summary and EMPDUPE file must have been produced in Wagemaster. 

However, any error identified after the original payment summary and EMPDUPE file produced cannot be fixed in   Wage Easy. You will not be able to produce an amended ATO Payment Summary from   Wage Easy and you will need to manually lodge the amended payment summary outside of   Wage Easy. 

You cannot change the information on a payment summary after you have either: 

  • given it to your employee 
  • provided your PAYG withholding payment summary annual report to the ATO. 

If you find a mistake with any amount or ETP code after giving the payment summary to your employee or the ATO, you should complete a manual amended payment summary, placing 'X' in the amending a payment summary box. 

If there is a change in circumstances and you have not issued the payment summary to your employee, or lodged your annual report, you can complete the payment summary according to the updated circumstances. 

For example, if an employee retires from their position on a certain date, and that former employee subsequently dies, then the payment and payment summary should be completed as a death benefit ETP and be made to the dependant, non-dependant or trustee of the deceased estate 

Please always confirm with the ATO where in doubt. 

Individual non-business - income Type code 

The Type box displays one of the following codes, based on the employee's income type. 

 

 Code 

Description 

S 

This code is displayed for all employees that are not attached to the Working Holiday Maker tax table. 

 

H 

The employee is a working holiday maker. The Working Holiday Maker (2018- 2019) Tax Table is selected in the employee file for this code to be displayed on the payment summary. 

 

What do the Lump Sum fields in the ATO Payment Screen mean? 

 

Lump Sum Codes 

Lump Sum Description 

Lump Sum A 

For unused long service leave that accrued after 15 August 1978 but before 18 August 1993; or 

For unused holiday pay and other leave related payments that accrued before 18 August 1993; or 

For unused long service leave accrued after 15 August 1978, or unused holiday pay or related payments, where the amount was paid because you ceased employment under an approved early retirement scheme, because of invalidity or because of bona fide redundancy. 

This entire amount is taxable, but the maximum rate of tax is 30% plus the applicable Medicare levy rate. 

Lump Sum B 

For unused long service leave which accrued before 16 August 1978. Average marginal rate on 5% of the amount. 

Lump Sum D 

A tax-free bona fide redundancy payment or approved early retirement scheme payment. This amount is not taxable and should not be included on your income tax return. 

Employment Termination Payments (ETP) 

Cash lump sum on termination of employment, you will have been issued a separate ETP payment summary showing full details of the payment. 

Lump Sum E or Lump Sum payment in arrears 

For back payment, exceeding $400, which accrued more than 12 months ago. This entire amount is taxable, but a tax rebate (also known as a tax offset) may be available. 

 

Individual non-business - R or T codes for Lump sum A 

When an employee has been paid an amount that qualifies as Lump Sum A, you may see the code R or T displayed next to it on the payment summary. 

 

Code 

Description 

R 

The payment was due to a genuine redundancy, invalidity or early retirement scheme 

T 

The payment was made for any other reason than the ones mentioned above. 

Reporting Rules for a Lump Sum E payment 

Lump Sum Payments in arrears that are equal to or greater than $400.00 must be included on the Employee’s ATO Payment Summary, against label Lump Sum E. You must also provide the employee with a letter that details over which financial years the amount was accrued and the gross amount which accrued over those years. 

Where the Lump Sum Payment is less than $400.00, the gross amount should be included against the Gross Payment on the Employee’s ATO Payment Summary. No explanatory letter to the employee is required in this instance. 

Further details can be as follows: 

https://www.ato.gov.au/rates/schedule-5---tax-table-for-back-payments- commissions-bonuses-and-similar-payments/ 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments