Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Report: Payroll Activity Summary - Expand report columns (pre-tax and post tax deductions...)

Partner

243Posts

464Kudos

0Solutions

243 Posts
Partner
Australia

I find the payroll reports in MYOB don't make reconciliations as easy as what they could be i.e. all deductions/expenses are just lumped in together.  My suggestion would be to use the report columns as follows:

(I believe there is work being done in this area - feel free to enlighten me about it if you know)

 

Gross Wages

Salary Sacrificed Super

Other

Pre-Tax Deductions

Post

Tax Deductions

Tax*

Net Pay

Superannuation Expenses

Other Expenses

 

* I wonder if MYOB can have an ETP process whereby the ETP tax actually shows under tax as opposed to a deduction (which can be overlooked by a client when preparing their BAS).

 

Any updates/feedback welcome.

 

"Payroll reports need to enable easier reconciliations"

Current Status: Open
Last Changed: September 2013

Thank you for the Idea and the comments. This does appear to be a popular Idea. We have brought it to the attention of our Developers for it to be considered in a future release.

11 Comments
Jace_IT_Figures
Valued Partner
132 Posts
Valued Partner

I've had a query from an Accountant client of mine with regards to Salary Sacrifice being incorrectly reported as "Gross Wages". Now I think it's arguable from both angles but I guess maybe there needs to be an option for which payroll categories to include (or deduct) for the Gross Wages column on say the Payroll Activity Summary report?

 

The issue is, the accountant wants to be able to look at said report and cross check the total figure to the wages account on the P&L and to the total of the PAYG Payment summaries, which in this case were lodged incorrectly as the client had not ticked the box to include salary sacrifice superannuation as being part of the Gross Wages on the payment summary. Her defense was, "Well it matched the report".

Julie_A_C
Partner
3,363 Posts
Partner

Hi Jace it

 

The payroll activity summary would have agreed with the P & L but should not have agreed with Payment summaries until the sal sacrifice was deducted.  The payment summaries would also not have agreed with what should have been reported to the ATO on the BAS, but I assume these were done wrong each quarter.

 

Salary Sacrifice in whatever form (expense payments, super etc) needs to have it's own column on the activity report to be able to distinguish the amount to reduce gross wages by when reporting on the BAS and to assist at year end reconciling and to get it out of being lumped with other deductions (eg child support, loan repayment etc).

ASWatCR
Partner
243 Posts
Partner

I agree. I have requested the layout of the payroll report be changed too.  Refer to my idea dated 07.12.12  and vote for it so we can finally get this changed.

 

ps I voted for yours too!

Rosiel
8 Posts
Cover User

Need additional columns for payroll reports. Currently all deductions are lumped together in the one column, whether it's for a super deduction, pre or post tax, or a non salary deduction. Same with payments - need to separate wages and other payments for better identification.

ASWatCR
Partner
243 Posts
Partner

Hi Rosie,

 

I have posted this idea already - and totally agree with you! 

 

I have voted for yours, and ask you vote for mine also - perhaps others will too and we can get this report fixed/more user friendly.

 

Just click on my name and it will bring up a list of all of my ideas - this idea is called "Payroll reports need to enable easier reconciliations".  Feel free to vote for any of my ideas that you like!

Lyn_BAS
Partner
26 Posts
Partner

I use another report for this information. It is under Payroll Categories Heading and is called Payroll Summary. Not sure if this is what you are after but lists separate deductions, super etc

ASWatCR
Partner
243 Posts
Partner

Thanks for your idea Lyn.  I do know this report and it is very useful for end of of payroll year reconciliations.

 

However this report does not break it down into individual staff, unless you end up with a massive number of pages.  I was thinking the activity report should have these few extra columns just so it would be more user friendly when using it for each pay run i.e. to check each staff amounts etc.

Matthew_W
MYOB Staff
2,173 Posts
MYOB Staff

Hi ASWatCR, thanks for your suggestion to have this combined with your original post.

 

In looking through your posts for the 7/12/12 I'm not able to find one that seems related to this feature. Could you please provide a link to your original post so that Jace_IT_Figures is able to vote and comment on it to show support for it?

Kind Regards,
Matthew - MYOB Client Support.

ASWatCR
Partner
243 Posts
Partner

Hi Matthew/Jace,

 

Here is the link below - I posted it just after midnight, so the date was actually 08/12/12!

 

http://community.myob.com/t5/AccountRight-Idea-Exchange/Payroll-reports-need-to-enable-easier-reconc...

 

Here is a copy of my post:

 

I find the payroll reports in MYOB don't make reconciliations as easy as what they could be i.e. all deductions/expenses are just lumped in together.  My suggestion would be to use the report columns as follows:

(I believe there is work being done in this area - feel free to enlighten me about it if you know)

 

Gross Wages

Salary Sacrificed Super

Other

Pre-Tax Deductions

Post

Tax Deductions

Tax*

Net Pay

Superannuation Expenses

Other Expenses

 

* I wonder if MYOB can have an ETP process whereby the ETP tax actually shows under tax as opposed to a deduction (which can be overlooked by a client when preparing their BAS).

 

Any updates/feedback welcome.

Jace_IT_Figures
Valued Partner
132 Posts
Valued Partner

Definitely a great layout ASWatCR. Especially a fan of the 'Super' vs 'Other' expenses as soooo many clients refuse to believe until I prove it to them that (in most cases) their 'Other Expenses' column is actually their superannuation expense.

 

Thanks for getting our ideas combined. Hopefully this gets off the ground soon! Sick of accountants whinging at me about it. ;P

 

As to comments on my thread here - http://community.myob.com/t5/AccountRight-Idea-Exchange/Payroll-Reporting/idc-p/202334#M2215. The example I gave was for someone who wasn't a client and prepared their own BAS and yes they did prepare it incorrectly as Julie_A_C suggested and then incorrectly prepared their PAYG Payment summaries as they were under the impression that because it added up and agreed to the report that it was all fine.