Urgently need help with the new Payslip Summary

1

It came to my attention that there is a new design in the payslip summary from this discussion - Payroll Summary layout problems

Honestly, we do prefer the previous payslip summary where we can view each line for each employee - Name, Gross Pay, Total Deductions, Net Pay, Total Contributions.

Now with the new layout, which group them by category, thus making it very difficult to view each employee in a row and no longer looking like a summary. The most important part of the summary, “Net Pay,” missing from the report.

We use the Payroll Summary (the previous layout) nearing the payroll day to actually make export data to Microsoft Excel and then convert it to the required format before submitting it to the banking system to make the payroll transfer. We also make printout copy to crosscheck the payments made against the “Net Pay” are actually correct.

The new layout doesn’t provide the “Net Pay,” and our years of workflow stopped with the new layout. We cannot be printing individual payslip or looking through one-by-one and typing the “Net Pay” data into Excel file. The steps of getting the “Net Pay” are getting not friendly user anymore.

Also, there was mentioning of Report Transformation as the means to customize the way we want for the Payslip Summary. However, since I am not technical in HTML, this is becoming more troublesome. Probably, @lubos and Manager team should provide some templates for the Report Transformation like the Payslip Summary (the previous layout), the Contribution Report, the Deductions Report to allow non-technical person like me a straight-cut solution. I would understand that @Tut would say get someone to do the HTML (as he had said that many times to many people), but as a lay user, we can’t be hiring people to do HTML, when the Manager had been providing us that reports, only that the new layout took over and the basic stuff missing from the reports.

I hope something can be done soon as per next week is the payroll week. Or something like a guide that I can grasp easily without hiring a programmer to customize a report for my needs.

Thank you for the helps.

1 Like
2

Have you looked at the Employee Summary report? Could you export those for each employee and add a net pay calculation line to our spreadsheet?

3

The Employee Summary report is an accumulative report for individual employees, with the capability to set a date range. Not a great report for monthly Payroll.

@Tut Employee Summary report doesn’t provide the “Net Pay.” It is better to go to payslip tab and look for individual payslip for the “Net Pay.”

For the record, I am providing the comparison between the previous Payslip Summary with the current:

This is the previous Payslip Summary layout (our printout copy). A report of all the employees in a single page.

Previous%20Payslip%20Summary
Previous%20Payslip%20Summary1280×570 104 KB

The following is the new Payslip Summary layout. Group them by category and list individuals who will receive the payment in that category. The list is overwhelming long if printed.

New%20Payslip%20Summary_LI
New%20Payslip%20Summary_LI811×640 57.3 KB

By comparison between the previous and the new layout, big changes being made.

Actually, personally, not much of usage for the new layout report. We don’t need to view all employees in their categories of payment. Only the individual employee would like to see his/her payment category. The Payslip or the Employee Report is sufficient for their viewing.

For us, business owners, care the most is the final total amount of the employees in which we have to make payment. Therefore, the previous Payslip Summary layout with the Name, Gross Pay, Total Deductions, Total Contributions and Net Pay provides the best answer to all business owners’ needs.

(I understand that there are others had commented wanting to have landscape view of the Payslip Summary with detailed data across, but again the whole idea or bottomline is still the Gross Pay, Deductions, Contributions, and the Net Pay.)

I really hope @lubos would reconsider to bring back the simple yet effective previous Payslip Summary report, Deductions report and the Contribution report back to the Manager. Those are the very basic reports. Any upgrade to these 3 reports or making 3-in-1 report must consider how to put them together in a way none of the important information missing from the report.

4

I can hear your scream, mate.
Althought Manager is good in many ways, inconsistency is an ultimate issue with this software.
I didn’t update it for many months (when I was using it), only because of unpredictability and unpleasant surprises it can bring. Features that I was relying on, could be easily scrapped overnight and that wasn’t a big deal to do this. For some companies this can be too expensive pleasure, so I could not rely on this program, stopped using it and switched to paid software.

Payroll reports are one of good examples of that inconsistency. These were perfectly fine general reports - zero effort to produce any breakdown of figures or transformt it into anything you need, so I didn’t get the reason of removing these. It is fine if you are about to add new reports/layouts, but why to remove? New reports are useless in that term.

I guess Managers development got to the point where it is unable to satisfy one user needs by sacrificing others’ needs, so why not to think of localization packages that adjust Manager to specific needs or addons for particular features or more universal tools (like Custom Reports, but I am not sure if it is working at all, I didn’t manage to produce any meaningful report with it).

S.

5

For the update, our payroll this month went through some extra works. Though we managed to submit the data to the banking system and make the transfer, but it wasn’t easy for my finance staff. They discovered a way through the Payslip tab and its main page provides the similar outlook to the previous Payslip Summary layout. However, the list of names is not in alphabet order, and we had to highlight those we wanted for selective printing. The printing spread out to several pages as the columns and rows are much wider. The export function worked, but some manipulation works done in the Excel.

Bottomline, I still believe in the Manager, so I would not comment further. What I really like to suggest to @lubos if there is any possibility of improving the reports, these are my suggestions:

  1. Bring back the Payslip Reports, Contribution Reports, Deduction Reports
  2. If not, a guide for the report transformation
  3. Provide templates or templates’ codes for customization.

Thank you

2 Likes
6

Hi Lubos

Just checking if there is a chance to get back one day those scrapped payroll summary reports?

S

7

@lubos Another month end for salary. Wish to have the former payroll summary reports back in the Manager.

8

I gave this a lot of thought. I came to conclusion that any report which has pre-defined columns is essential and belongs to Reports tab. This means it was wrong to remove the classic payslip summary report (regardless how it’s used). This has been now rectified in the latest version (19.7.71).

The expanded payslip summary report has been renamed to Payslip Totals per Item and Employee which is more appropriate name for the report.

4 Likes
9

Thank you, Lubos.

10

I searched for help on this topic so I hope this is the way present my query .

On the Payslip Totals per Item and Employee Report the year to date totals are correct but the actual weekly totals are always double what they should be with the exception on the first week of the year .

Is there a reason for this ?

The STPR totals are correct so I have been lodging the reports but with another BAS due need confirmation everything is in order here .

11

If you are referring to the Single Touch Payroll or the untransformed report: you need to define two intervals. If the pay period included two payslip but the year to date interval was correct it would cause the report you described.

That may also mean the W1 and W2 you have reported with single touch payrolls is double actual. A problem at BAS / tax time

12

the untransformed report … can I assume this is the report created when the STPR create button is pressed , which seems to be the Payslip Total Per Item and Employee report ?

Sooo … all I can see is the payweek totals are x 2 but the totals in all reports seem to be correct .
The STPR that I lodge is ok I think …

13

Login to the ATO business portal, goto “Manage Employees”
You will be able to see all the STP you have lodged. Total up the W1 (total gross pay) W2 (total tax withholding). Confirm it is the same as the business year to date totals.

14

Ok , rhoigght . The W1 & W2 totals in the Portal are twice what they should be .

I have checked the recurring payslips and they are correct …

And again from what I can make out it is only the weekly totals that are wrong . Not the year to date totals in the Business . But when you multiply out W1&W2 amounts over the year they are double what they should be . So the STPR report must pick up the pay week totals as the core information which in my case are x 2 for some reason .

And also if I create a STPR for the entire quarter the W1&W2 totals are correct but if just a weekly report they are x 2

15

When you use the “Single Touch Payroll Worksheet” it requires

ie

I believe the “Payroll period” you have been using each time has spanned two pay runs each time. As a result the businesses total W1 and W2 have double counted pay slips, double reporting to the ATO.

16

Your screen shot didn’t come through …
:smiley:
But I am setting the pay period and the year to date period ?
And in the report the pay period is just one week .

17

  • To look an image in a linked post you need to click on the link to see the image. In the above example click on lubos post will show it in it’s thread.

  • The pay periods must be non overlapping; in particular first day of a new pay period should be the day after the last day of the last pay period.
    For example if your pay week finishes on a Friday and that is your pay day then the pay period is from the prior Saturday to the current Friday. Not the prior Friday to the current Friday.

18

Would it not be easier to ask him to post a screen shot of the dates as he has entered them?

19

Thanks , got it about the link …

Hmmm … will see what difference changing the dates has so they don’t overlap.

20

Payweek and year to date

This is what the dates look like …