How do I print a W1 Wages Gross report that deducts SS Super Contribution amount and shows the adgus

Sah

My W1 Wages Gross report is incorrect. Am I correct in thinking that you report the Adjusted Gross Wages amount for W1? (employee has SS Super Contribution). How do I print a W1 Wages Gross report that deducts this SS Super Contribution amount?

Some background info: I recently amended this employee with SS super to be set up as tax tracking type 'Gross Payments' and selected 'PAYG Tax' for the Payroll Item. W2 Wages Group tax has reduced accordingly and STP is reporting correctly.

I will need to revise W1 amounts for BAS/IAS PAYG instalments but wanted to print the corrected W1 Wages Gross reports first.

Acctd4

Hi Sarah

 

You’ve posted under “All Problems” & haven’t specified … what Reckon product/program you’re using ?

 

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com

Acctd4

Hi Sarah

Yes, Adjusted Gross Wages is what goes at W1.

You’ve posted under “All Problems” & haven’t specified … what Reckon product/program you’re using ?

Assuming you’re using RA or RAH ……

I use a customised “Payroll Summary” report for W1/W2. 

You should already have this report in your Memorised Report List (access under Reports dropdown menu > Memorised Reports) as it’s one of the default ones.

This report shows you Gross Pay AND Adjusted Gross Pay.

 

I have it set to default to “Last Month” (for monthly reporting or “Last Payroll Quarter” for quarterly)

Click on the Modify Report * button (above date range along the top of the report)

On the Display tab, select “Total Only” from the dropdown list for “Display columns by”

Untick the Hours & Rate checkboxes

* I always have negative amounts (eg in this case, the PAYG) displaying in red as it makes them stand out.  This is a checkbox (“In Bright Red”) under “Show Negative Numbers” on the Fonts & Numbers tab of the “Modify Report” window.

You can also name it (eg “W1 & W2 Report”) on the Header/Footer tab in the “Report Title” box.

Once you’ve customised the report as required, “Memorise” (Next to the “Modify …” button) for future re-use.  It will retain all your customisation & you can just generate it for each BAS period

I have a “BAS Reports” Group in my Memorised Reports where I save several of my customised BAS reports for cross-referencing.    

I also use a modified version of this report for STP – with the columns set to the applicable pay date period (eg Week, Two Week etc”) & another at EOFY with the columns set to per Employee.

This ensures your STP accuracy each submission!

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com

Sah

Hi Shaz, thanks so much for your help. I did as you suggested and it worked well. I use RA. I now have 2 queries as a result of adjusting the BAS/IAS for the PAYG with the ATO. 1. How to record refunds from the ATO in RA to balance payroll liabilities account for overpayments of PAYG credited back to the business ATO account. 2. The ATO adjusted some CFB payments, these adjustments were debited from the above ATO account balance, resulting in a minimal amount remaining to be paid to the ATO. Any suggestions on how to record this to balance PL account? Thank you

Acctd4

Hi Sah

 

1. For full PAYGW refunds (& not a result of CFB/other credits) there is a specific section to record payroll liability refunds (eg refunds for PAYGW & Super):

Click on Employees (along top toolbar) > Payroll Taxes & Liabilities > Deposit Refund of Liabilities:

2. The entry for this depends how you have your Chart of Accounts set up eg whether you’re using a BAS Clearing Account (ATO ICA)

Either way, you will most likely just be recording additional lines on the Chq/Liability Chq to reflect the movements of these other liabilities & the CFB.

The below is an example of a balance payment of $ 1,100 via a Liability Cheque (PAYGW)  However a similar transaction would be applicable if there’s no PAYGW component, it would just be on a standard “Write Chq” instead):

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com