Skip to main content

Attaché Payroll (Australia): Reconcile the Single Touch Payroll batch gross total

Updated over 3 months ago

The STP Batch Gross value is the total salary, wages and other amounts that now reports directly into W1 of the BAS. These values can be manually adjusted before submitting for payment. If STP batches are not submitted for one reason or another then the total amount for the month or quarter may need to be adjusted manually.

The STP batch gross and YTD Gross on the Income Statement are not the same since the implementation of STP Phase 2. The Income Statement Gross is disaggregated showing leave, overtime, allowances and other components separately. Please refer to the STP Reconciliation report to reconcile the YTD gross to the Pay Totals History report in Attache.

To reconcile the STP Batch Gross total to the Attache Pay Totals History report use the following formula:

Pay Totals History Report Gross for the period (Attache)

Less:

  1. Allowances (After Tax).

  2. Deductions (Before Tax) e.g. Salary Sacrifice Super.

Add:

  1. Lump Sum D on Termination.

  2. Eligible Termination Payments (Non-Taxable).

Equals: STP Batch Gross Amount.


Example:

Pay Total History Report Gross = $100,000.
Less:

Car Allowance $5000 (After tax).
Salary Sacrifice Super Deduction $12,000 (Before Tax).

Plus:

Lump Sum D Termination $500
Eligible Termination Payment (Non-Taxable) $500.

Equals STP Batch Gross amount = $84,000.


Printing the Pay Totals History report to use for the reconciliation:

  1. Go to Payroll, Reports, History, Pay Totals.

  2. Enter the Date Range for the current pay.

  3. Select Yes for all Itemise Totals options.

  4. If using Multi-Locations, untick Location Totals.

  5. Export the report to Excel.

  6. Identify the Gross Wages Total amount, the before tax Deductions, the after-tax Allowances, all Termination amounts (Lump Sum D or Eligible Termination Payment Non-Taxable).

  7. Use the Pay Elements Details reports in Payroll, Reports, Pay Element Details to identify the before or after-tax setting for each deduction and allowance code.

  8. Use the formula above to reconcile the amounts.

Did this answer your question?