Create a transaction history record

Transaction History is used for Editing or Entering employee payroll history data values for:

• Accruals
• Advances
• Benefits
• Deductions
• Earnings
• Expense Reimbursements
• Taxes
• Make changes or adjustments to historical data anytime after setup

To enter or edit historical data:

1. Go to Payroll, Tasks, Transaction History.
2. Use the navigation buttons/Finder to find and select the employee record needed.
3. At the Date field, enter the date value you need to enter balances (Note: These amounts can be for any period of time you choose: quarterly, monthly, year-to-date)
4. Choose the payroll code values needed and complete the fields that apply to all the historical amounts you need. You have to check the report to see if the field is overwritten or amended. Taxes are amended so math has to be done to calculate the correct number to add or deduct.
5. Select Add to finish the process.

NOTE: The ceiling wage and no ceiling wages will need to be adjusted for the information to show on the W-2 and the tax calculation analysis.

To be able to edit no ceiling wages for local taxes, you’ll need to access the local tax within Setup, Payroll, and Local/Other Tax Codes. Select the local tax code and click Calc Base Tab and enter an amount for the Annual Maximum Earnings and Annual Minimum Earnings. This will allow you to enter the no ceiling wages when creating the transaction history record. This will flow to the W2 and the Tax Calculation Analysis report.

On federal or state tax codes, you can only edit ceiling wages or no ceiling wages if that type of wage applies to the tax. Example: The USFIT doesn’t have a ceiling wage because there’s no limit to this tax, so an edit can only be made to the no ceiling wages.

To update the Deduction amount, Update the Employee Extended Amount field to update the Employee Base Earnings/ Deduction Base amount

To update an employer portion of a deduction or benefit, use the Employer Extended Amount.

Additional Information:

Before and after saving the Transaction History record run reports, using the date range of the entire year, to display the current values and the values after the adjustment: 

• For Earnings and Deductions, run the Transaction Report, Earnings/Deduction Summary
• For the Taxes, run Tax Calculation Analysis