Skip to main content
Question

Reconciling the Annual Earnings by Employee Report to Payroll Summary

  • January 5, 2026
  • 5 replies
  • 32 views

I am working on our annual 401K census data and have run into a bit of a snag in the reports I am using.

I used the Earnings by Employee report and then the Deductions and Benefits by Employee report (for 401K, 401k Match, and Roth) to get the information to include on my reporting.  These reports however don’t provide a total figure to use as a double check to what I entered to make sure I keyed everything properly.  I am using the parameter of the 2025 year as that is all it asks for.

I thought I would just run a Payroll Summary report in order to get a quick view at my totals as a double-check, but the totals don’t match? I am running it for a transaction date of 1/1/2025-12/31/2025.

My total wages, hours, and even the deductions don’t match. The payroll summary has more somehow?  The only one that matched exactly was the Deductions and Benefits by Employee for the 401K. Why would this be? 

5 replies

Sonia Echols
Acumatica Moderator
Forum|alt.badge.img+1
  • Acumatica Moderator
  • January 5, 2026

Hi @Kerrim,

That is a great question.  Please open a case.

Thank you,

Sonia Echols


  • Author
  • Freshman I
  • January 5, 2026

Hi @Kerrim,

That is a great question.  Please open a case.

Thank you,

Sonia Echols

How do I do that? We are relatively new to Acumatica and the community so I haven’t done that before.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • January 5, 2026

Hi ​@kerrim - It appears CLA is your partner. In that case you would contact them for support.


  • Author
  • Freshman I
  • January 7, 2026

I was able to figure it out without their help, but they still can’t explain to me why the 3 voided payroll adjustments I identified as the issues aren’t pulling into the payroll summary report but are in released status and are pulling into all of the other payroll reporting.  Is this something you can help with? ​@Chris Hackett 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • January 7, 2026

Hi ​@kerrim - While I manage the community, I am not a product expert. We rely on the various member experts to weigh in on questions.