NetSuite PAYG withholding reconciliation proves that three things agree: the tax your payroll provider withheld, the journals it posted to NetSuite and the amounts you report at W1 and W2 on the BAS or IAS. Date each pay run on its pay date, report from a saved search over the payroll journals and roll the PAYG withholding payable account forward to the ATO payment every period.
Most Australian teams already check each pay run. The gap is the activity statement period. Pay runs straddle month-end, accruals land on the liability account, no-ABN withholding mixes with wages tax and W1 and W2 figures pre-filled from Single Touch Payroll (STP) get accepted unchecked.
Our posts on NetSuite superannuation and payroll liability reconciliation and connecting NetSuite to a payroll provider cover the liability accounts and journal design. For the activity statement, one more split matters.
Amounts withheld from wages belong at W2. Amounts withheld from suppliers who did not quote an ABN belong at W4. Other withholding, such as from certain payments to foreign residents, goes to W3. The three add up to W5, which is carried to label 4 in the summary.
If accounts payable posts no-ABN withholding to the same account payroll uses, the balance still matches what you owe, but the labels do not. Give W4 its own sub-account under PAYG withholding payable and post it from the vendor bill or bill payment, never from a month-end journal. The vendor ABN flags in our NetSuite TPAR reporting guide are the same data you need to catch a missing ABN before the payment goes out. The ATO sets a 47% rate on the invoice amount with some exceptions, so confirm unusual cases with your tax adviser or the ATO.
PAYG withholding is reported in the period you pay the employee, not the period the work was done. A fortnight ending 27 September and paid on 1 October belongs on the October statement.
Date each payroll journal on the pay date and carry the pay run ID, so a search by date range returns exactly the runs paid in the period. If finance accrues wages at month-end, post the accrual to an accrued wages account and set it to reverse on the first day of the next period. Keep it off PAYG withholding payable. An accrual that credits the payable inflates the balance you think you owe the ATO and, if your report reads that account, inflates W2 as well. The routine in NetSuite reversing journals and accrual rollforwards works for payroll accruals too.
Off-cycle runs follow the same rule. A commission, termination or correction run has its own pay date and period.
Pre-fill and payroll reports are useful comparisons, but the figures you sign should trace to the ledger. Build one transaction saved search over the payroll journals, filtered on a pay run ID field or a dedicated journal form, with the statement's date range. Return gross, salary sacrifice, PAYG withheld and net pay by pay run.
W1 is not simply your wages expense account. The ATO excludes amounts under salary sacrifice arrangements and super contributions from W1. It includes items that may sit elsewhere in your chart, such as director fees, termination payments, unused leave paid out and commission paid through payroll. Map every pay item to a W1 treatment once, keep the mapping with a version date and have your tax adviser review it. Then the search does the same arithmetic every month.
W2 comes from credits to the wages withholding account on journals in the period. W4 comes from its sub-account. If either search returns a line with no pay run ID or vendor bill behind it, stop and find out why before you lodge.
Each STP pay event reports gross and withholding to the ATO. For small and medium withholders, the ATO uses that data to pre-fill W1 and W2 in its online services, and its guidance is to change the pre-filled amounts only if they do not match your records. That makes your records the check.
Compare three figures for each pay date: STP, the NetSuite search and the provider's payroll register. When STP and NetSuite differ, the usual causes are a pay run posted twice or not at all, a correction reported through STP but never journaled or a pay item mapped to the wrong account. Our post on NetSuite Single Touch Payroll explains the pay category mapping behind most of these. Fix the mapping rather than posting a top-up journal.
Large withholders pay within days of each pay event and complete different labels, so confirm your withholder status and labels with your tax adviser or the ATO.
Reconciling the labels proves the report. Rolling the payable forward proves the cash. For each period, take the opening PAYG withholding payable, add the amounts withheld at W2, W3 and W4, subtract payments to the ATO and compare the result with the closing balance. For a monthly withholder, the closing balance should equal that month's W5, which is generally due on the 21st of the following month. Nothing older should remain.
The ATO payment usually covers more than withholding. One bank payment can settle GST, PAYG withholding and PAYG instalments together. Split it in NetSuite by activity statement label, with the lodged statement as support, so each liability clears by the right amount. Our guide to tracing Australian GST from NetSuite transactions to the BAS covers the GST side of the same payment.
An older balance usually means a payment was coded elsewhere, a correction was never paid or a statement was revised. Find it before the ATO account shows a debt.
When payroll corrects someone's pay after the event, three records can move: the STP report, the NetSuite journal and the lodged activity statement. Agree the order in advance. A workable rule is that payroll corrects and reports through STP, the provider posts a correction journal dated on the correction pay date with a reference to the original run and finance decides whether the lodged statement needs revising.
Do not reopen a closed period to edit the original journal. A reversal and a new journal leave a trail. An edited journal in a closed period leaves a reconciliation that no longer matches what was lodged. Year-end works the same way: STP finalization, due by 14 July for most payees, should agree with twelve months of these searches. The NetSuite EOFY checklist for Australian finance teams covers the rest of that sequence.
This example is hypothetical and simplified. An Adelaide food manufacturer with 64 employees pays fortnightly through an external payroll provider, which posts one journal to NetSuite per pay run. It withholds about A$850,000 a year, so it is a medium withholder lodging a monthly BAS. The September 2026 statement is due on 21 October.
Payroll paid three runs in September:
STP and the pre-fill show W1 of A$319,000 and W2 of A$68,235. The first NetSuite report, built on the wages expense accounts and the PAYG withholding payable account for the September posting period, showed W1 of A$359,800 and W2 of A$79,235. The controller traced the gap to four causes:
After the fixes, W1 is A$319,000, W2 is A$68,235 and W4 is A$1,410, so W5 and label 4 are A$69,645. The rollforward agrees: August's A$66,980 was paid on 21 September, and A$69,645 withheld in September leaves exactly A$69,645 owing for 21 October. Before the fix the account showed A$79,235.
Lodging from the first report would have overstated W5 by A$9,590 and put A$1,410 at the wrong label. The rebuilt report also cut the monthly check from about six hours of spreadsheet work to 90 minutes. At A$95 an hour, that is about A$5,100 a year.
For each period, keep the saved search output by pay run, the STP totals for the same pay dates, the version of the W1 mapping used, the payable rollforward, the lodged statement and the payment split. It should fit on one page with links to the sources. The controller signs it before lodgment, not after.
CuriousRubik's NetSuite managed support services can help Australian finance teams set up the W1 mapping, the pay-date searches and the monthly PAYG withholding rollforward, then run the check with you before each lodgment. See our NetSuite work in Australia for more.
Not usually. The figures come from payroll and STP, and most teams lodge through ATO online services or their tax agent. NetSuite holds the journals and searches that prove the figures, so confirm what your account and localization support.
Only after checking them. The ATO pre-fills from STP data and expects you to change the figures if they do not match your records. A NetSuite search by pay date is the record to compare against.
For a monthly withholder it should not be zero at month-end. It should equal the current month's withholding, which you pay the following month. Anything older is the item to investigate.
At W4, not W2. Post it to its own sub-account from the vendor bill or payment so the label split comes from the ledger. The rate and the exceptions are set by the ATO, so confirm unusual cases with your tax adviser.
How to set the payroll system boundary, give every pay run a stable identity and reconcile a pay run from journal to bank and super.