Submit your Suggestions for Spectrum

Make Payroll Liability Reconciliation Report part of the payroll processing reporting

The payroll liability rec report is extremely useful to us & I love that you can print a date range. I still want that ability but I would also like the report to be part of processing reports in payroll. We have a weekly payroll and sometimes have to do special check runs...there's currently no way to run the report for individual payrolls that post on the same date. For example, our Christmas bonus check run will be on the same day as our regular payroll...I would really like to be able to generate the report for the two check runs separately.

  • Rachel Meyer
  • Nov 20 2024
Company Neuman Pools
I need it... Yesterday...Come on already
  • Attach files
      Drop here to upload
    • Rachel Meyer commented
      24 Jul 17:40

      Hi Geoff - Sorry I haven't had time to get back to this. To answer your question on how I use the report...I'm not doing anything special. Since the Pre-Check Register does not provide a comprehensive totals page at the end, I am using the Payroll Liability Reconciliation as a substitute for that. In my opinion, every payroll should have this information as one of the report options during processing. I use it to verify all of my payroll check figures and I use it to create monthly, quarterly and year end check figures. It is a great report...I don't have complaints about the report other than I wish it were available within the post-calc payroll processing report options. Within payroll processing, you have a detailed add-on report, a detailed deduction report, a detailed tax report, etc. Why not this report as well? Or simply put detailed totals on the pre-check register:). I would still like it as a stand alone report in which I can run date ranges but I really want it within the payroll processing so I have the information for that specific payroll. It works fine if I don't have to run multiple payrolls with the same date but it loses it's effectiveness (to me) when I do have to run multiple payrolls.

    • Admin
      Geoffrey Falk commented
      14 Jul 20:47

      Thanks for writing me back!

      Based on your comments, I have to agree that the G/L report won't be helpful to you.

      I'd like to ask how you are using the PR Liability Recon Report today? The reason I ask is that the report's original design was the following:

      Clients need additional tools to reconcile and review their payroll records. Specifically, they need an easier way to reconcile payroll accruals back to the G/L.

      Spectrum will be enhanced to provide a new report in Payroll showing key totals for the designated check date range, for assistance in balancing the General Ledger payroll liability accounts. The Payroll Liabilities Reconciliation Report will contain tax amounts, deduction and add-on totals and net cash outlay.

      Note to Reader: This report will also offer a selection for ‘Cost group’. This will allow the user to filter the report based on the ‘Check cost center’ assigned during the pay cycle, in order to include values from employee checks for a particular segment of the company. It is anticipated that in future development, the underlying payroll reports referenced in the Appendix will also be enhanced to offer this selection.

      When I look at the Liability Recon report, I see it as a way to tie out my numbers as well as how much I need to remit to the tax authorities, regardless of the number of payrolls I have processed. What am I missing?

      There must be a neato-keen way you want to use the report, so please let me know your thoughts.

      I cannot give you a reason why the Pre-Check Register totals the way it does. It has always done it this way for as long as I've been here (30 years)...and the folks that would know why it is that way have since retired.

      But tell me more about how you'd use the PR Liability Report by pay cycle.

      Thanks!

      Geoff








    • Rachel Meyer commented
      30 Jun 22:00

      Hi Geoff - The g/l report might work for some companies but not for us. We have numerous g/l numbers and cost centers so as an example, our SUTA expense appears on our g/l report as 14 rows...we would need to add up those 14 amounts to see what our total SUTA was for that payroll. Additionally, the g/l does not show tax jurisdiction so even if we did add up the amounts, it wouldn't tell us how much was WI vs. IL vs. TX, etc. With that logic, why do you have any totals on the last page of the pre-check register at all? The last page shows totals for different types of wages as well as total gross wages, totals for FIT, employee portion of soc sec/medicare, SIT but then summarizes add-ons & deductions. Why are the totals shown on the last page deemed important enough to break out but everything else gets summarized? Every total for wages, add-ons and deductions has a value to me and the payroll liability rec is the only report provides each of those totals. Last week, I had to run two payrolls (both dated June 27th)...I can't run a payroll liability rec for each of the payrolls because they were dated the same. In 25 years of doing payroll, this is the only system I've used that didn't provide a full, detailed payroll register with a summary of all amounts at the end. I'm not sure if I'm explaining this well so reach out if you want more detail.

    • Admin
      Geoffrey Falk commented
      27 Jun 20:26

      Hello!

      Doesn't the G/L journal entry in the pay cycle give you this same information? What am I missing here?

      Thanks

      Geoff

    Dear Viewpoint Suggestion Box contributor;

    We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

    1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

    © 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.