I think I can reverse it with a Journal entry, but how do I reverse the 101725 payroll entry and not the 100325 entry?

Before answering that question - This is a PR (Payroll Journal). 

• Was the payroll imported to payroll data entry then updated in the Payroll module?   Then was the Daily Transaction Register updated to post to the General Ledger?   If this happened, the Payroll import must be reversed into the Payroll data entry files so Payroll employee records match the GL Account totals.
• Was the payroll information imported into the General Ledger data entry files (using the PR journal) and never touched the Payroll module.  If this was the method used,  a one-click journal reversal may be all that you need to use in General Ledger.  How to perform a One-Click Journal Reversal.  Do NOT use this 2nd method if Payroll records are incorrect as the GL module will not write back to the Payroll, Job Cost, AP, or Bank Reconciliation files.  Therefore your subsidiary modules will NOT reconcile to the GL.

If you have additional questions, you may want to open a support ticket to insure the correct steps are done to fix the issue.   It is suggested you make a copy of the MAS_XXX (xxx=company code) to test in and a backup prior to doing any corrections.  

If this suggestion helps to provide direction, can you please select the .. . after the Reply button to Verify Answer.

• Was the payroll imported to payroll data entry then updated in the Payroll module?   Then was the Daily Transaction Register updated to post to the General Ledger?   If this happened, the Payroll import must be reversed into the Payroll data entry files so Payroll employee records match the GL Account totals.

Yes to both questions.

So, I believe I have to go into each payroll account and reverse the amounts that were imported, is this correct and then I can re-import the correct file to update the accounts? 

If the original payroll was imported into the payroll data entry files and the registers updated the employees, you can use the reverse check run feature in payroll versions 2.25 and higher.   After updating the registers in payroll, this feature will also update other files in reverse of the original incorrect payroll.  It will flow through to the GL however it will assign a NEW Journal number.  Then the payroll will need to be imported from the correct excel source file. 

Please do this in a test company and have a backup before performing on live company data.

If you need assistance, please open a support ticket as additional mistakes can be much more difficult to correct.

If the suggestion above worked for you, please do mark it as Verified  (by clicking the “…” button next to Reply on that post) — it really helps others in the community find solutions faster.

And if you try a different approach or make any tweaks that work even better, we’d love to hear back! Your experience could help other Sage 100 users tackling the same import setup. 

Thank you for being part of the Sage Community!

Thank you for the info.  We have an older version of Sage 100 (2017) and I don't see a payroll module and we don't use Sage Payroll services.  Our payroll company creates the csv file for us and we import it thru visual integrator into the various GL accounts.

Will check with our supervisor to see if they want to open a support ticket to correct this.

With enough security access, Sage has a button to create a GL journal reversal transaction for you, from Account Maintenance.

If you click on a Transaction row, the blue curved arrow should show up... if not, you don't have enough permission.

(The button only creates the journal entry.  You do have a chance to edit / review before posting).

This is exactly what was needed.  Thank you for your help!

Watch the posting date of the reversal.  In your old version it won't match the original transaction automatically.