How to Deal With Single Touch Payroll Post Conversion

How to Deal With Single Touch Payroll Post Conversion

Please see here for how payroll information is converted - this applies to Australian conversions only. 

Moving from an STP solution

You should report YTD information to the ATO from your previous STP enabled solution and commence using STP in Xero post-conversion.

Changes in Xero

  1. In the Payroll menu, select Pay employees, then click Single Touch Payroll Settings.
  2. Select the Opening Balances tab, then select Year-to-date values were reported via STP or PSAR.
  3. Click Save changes.

Moving from a NON-STP solution

The STP opening balances values will not be included in STP filings (they will be used in YTD payslips and PAYG Payment Summaries).
The expectation is that the organisation should be using an STP compliant solution from 1 July 2018 (unless a deferral is granted).  

Changes in Xero:

  1. In the Payroll menu, select Pay employees, then click Single Touch Payroll Settings.
  2. Select the Opening Balances tab, then select Year-to-date values that were not reported, or were reported as nil amounts.
  3. Click Save changes.

Reporting STP for Transactions Prior to Conversion

If you selected a conversion with transactional history your pay runs will appear in Xero as "paid off" bills this represents the actual payments and transactions processed in your file. Due to this, you are unable to retrospectively report STP for pay runs prior to the date the file was converted. Please see the options below:

Work Around: 

Process pay runs in Xero and these pay runs can be reported in an STP compliant way. If this is elected there is additional work needed so that the PAYG figures are not duplicated in Xero. Please see below:

Recreating individual Payruns in Xero:

If you prefer to see each individual pay run in the Xero file you will need to complete the following steps in the Xero organisation.

This will enable you to refer to the Payroll Activity Summary for the payroll figures for each quarter.

Please pay particular attention to the notes.

STEP 1: For each employee remove the 'Employee Opening' balances in the Employee set up

STEP 2: For permanent employees amend each employee's Annual Leave and Sick Leave balance to be the balance as at the pay run prior to entries you are about to make

STEP 3: Remove & re-do all of the 'Payments' and 'Bills' In Xero associated with Payroll
  1. Note 1 - By removing the payments and bill will impact the following:
    1. The bank account balance from which the wages are paid from
    2. The profit and loss figures associated with Wages expense
    3. The PAYG Payable, Superannuation Payable and the Wages Payable
    4. Any other accounts typically used by your organisation in regards to payroll
  2. Note 2 - To bring some of the information from the source file to Xero we have to use clearing accounts during the conversion. These accounts are called:
    1. Conversion Clearing Account (199)
    2. Conversion Clearing Bank Account (198)
    3. GST Clearing Account (standard MYOB code)
These accounts enable us to reproduce the data from your old accounting package as accurately as possible. When you receive the Xero Subscription these accounts are balanced to 0 and archived. If you have to delete any transactions, make sure you also delete any of the associated clearing transactions. Each transaction in the conversion clearing account has a Debit amount and corresponding Credit amount.

Once you have deleted the Payments and the Bills as required if you have a balance in the conversion clearing account this usually indicates that you have deleted, voided or amended a transaction that has direct reference to the conversion clearing account - however, you have not deleted the corresponding amount.
  1. Note 3 - To identify all of the 'Bills' associated with payroll please complete the following:
    1. Select Accounts > Purchases > See All > Use the search function and enter 'Payroll'
STEP 4: Re-create each pay run in the Xero organisation
  1. Note 1 - In most instances, Xero will not allow you to select a date/payment date prior to 90 days so you may need to contact Xero support to see if they can offer a workaround for this issue.   
  2. Note 2 - It is important to keep in mind that due to software differences between MYOB/Reckon and Xero there is no way to guarantee that over this period of time the pay run totals between the two systems will match. That is why we prefer to bring in the Employee's opening balances to avoid such discrepancies. To ensure that the payrun data in Xero will match the source file you may need to complete manual adjustments to ensure each line associated with the Payrun is correct for example: Ordinary hours, PAYG, Superannuation, Deductions, Reimbursements and Leave Accruals.
STEP 5: Allocate Payment from the bank account to the correct liability account. In Xero, the Wages Payable will sit as a liability on the balance sheet until the payment has been coded from the bank account. The liability account is usually the 804 - Wages Payable account. However, if you are unsure please check the 'Payroll settings'.

STEP 6: Complete a bank reconciliation for the bank account that you usually pay wages from to ensure that the bank reconciles as per your paper form bank statement.

Not Required to Use STP 

  1. YTD figures will be included in Payment summaries.

    • Related Articles

    • Payroll

      Please note payroll is currently only available for Australian conversions. Furthermore, payroll for MYOB Essentials & QBO Australia is not brought in as a bill, it is brought in as a manual journal. Payslips will not be converted to Xero During the ...
    • Running Payroll Reports Post Conversion

      When setting up payroll in Xero, most employees will have opening balances so that payment summaries can be created out of Xero easily. The downside is that the reporting for the first quarter/ month after conversion does not easily give the correct ...
    • Changing Accounting Basis in Xero Post Conversion

      Warning: We recommend that you do not use the file until it has been corrected. Unless you understand the full accounting implication of the above steps there is a very high chance that the integrity of the data may be impacted by changes you make in ...
    • Post Conversion Queries

      Amending Conversion Balances Please see here for more information on how to Amend Conversion Balances Figures in Conversion Clearing Account Please see here for more information regarding conversion clearing accounts. Why do I have a Reconciliation ...
    • Conversion Support

      You have a variety of support options to choose from, depending on what works best for you. Pre-conversion Prior to converting your file, we encourage you to get in touch to discuss your conversion needs.  You can email us at ...