Payroll > Payroll Processing > Special Adjustments > Expense Only
This tab is used to create a special adjustment transaction that moves user-defined expense amounts from one account code to another account code. Adjustment transactions can only be made for pay dates that have been processed and that have occurred within the current school year. This tab page would be used to reclassify expenses from one expense account to another.
Amounts displayed in the grid reflect history transactions for the From Job Code, From Account Code, and Pay Date Range fields selected. When entering amounts to be moved, the user cannot exceed the amount displayed in the corresponding grid field. When all the amounts are zero in the grid for the selected pay date range, job code, and account code, no values can be entered in the amount fields. This can occur when the selected pay date range involves checks that have been issued and voided.
When moving amounts for G account types, the To Job Code field and associated distribution codes must already exist in Maintenance > Staff Job/Pay Data > Distributions tab before processing can take place. For all other account types, the Finance Chart of Accounts list displays in the To Account Code drop-down list and is available for selection. This process enables the user to easily move specified amounts between account numbers and/or funds (i.e., move transaction amounts from fund 211 to fund 199 or vice versa). The from and to account types must match for the Special Adjustments program to be successful.
Notes:
❏ The system recognizes funds that are set up in the Fund to Grant code table.
❏ This tab does not create a general journal that can be processed through the Interface Processing page. A general journal is created and automatically interfaces to finance when Interface to Finance is selected, and the adjustment is processed. Each time an account is processed through this tab, an adjustment number is assigned for that pay date. A maximum of 999 adjustments are allowed for each pay date. This maximum includes adjustments made on the Percent and Accruals Only tabs, Payroll Adjustments (check voids and issues), Zero School YTD, and Accrual Variance.
❏ The TRS Federal Deposit and TRS Federal Care amounts are calculated when the account codes are associated with a grant code.
Example of Federal to Nonfederal with accruals: The user removes distribution account code 224/7 and adds distribution account code 199/7 to an employee’s master distribution record. The 199/7 distribution account code should have been expensed since the beginning of the school year. In this case, the TRS 3 and TRS 489 reports have included this employee, and they need to be corrected. The YTD Expenditure Account Distribution Journal displays fund 224/7 with a total expense of $18,574.92, a TRS 3 amount of $1,222.23, a TRS 489 amount of $185.74, and Emplr Care amount of $102.18. The expense of $18,574.92 needs to be transferred to fund 199.7. During the special adjustment by expense process, the TRS 3 and TRS 489 fields are automatically calculated based on the Expense Pay field and are marked as Void. The voided amount in this case equals $1,407.97 (TRS Fed Deposit $1,222.23 + TRS Fed Care $185.74). When the expense adjustment is processed, the system automatically interfaces to Finance and credits the federal fund 211/7 object code 6119 for the expensed amount of $18,574.92 and 6146 for the total amount of $1,510.15 (TRS Fed Deposit $1,222.23 + TRS Fed Care $185.74 + Emplr Care $102.18) and debit cash. It then debits the nonfederal fund 199/7 object code 6119 for $18,574.92 and 6146 in the amount of $102.18 (Emplr Care) and credit cash. The system does not make any transfers to the Payroll Clearing Account; the offsetting entries to the clearing fund are the responsibility of the user.
Note: Since this employee accrues, the system is unable to determine what correction needs to be made to the TRS 3 and TRS 489 reports. The next time payroll is processed, the user needs to make the necessary adjustments to the total amount sent to TRS on the TRS 3 and TRS 489 reports.
Example of Nonfederal to Federal with accruals: The user removes distribution account code 199/7 and adds distribution account code 211/7 to an employee’s master distribution record. The 211/7 distribution account code should have been expensed since the beginning of the school year. In this case, the TRS 3 and TRS 489 reports have not included this employee, and they need to be corrected. The YTD Expenditure Account Distribution Journal displays fund 199/7 with a total expense of $18,574.92 and Emplr Care amount of 102. The expense of $18,574.92 needs to be transferred to fund 211.7. During the special adjustment by expense process, the TRS 3 and TRS 489 fields are automatically calculated based on the Expense Pay field and are marked as Issue. The issued amount in this case equals $1,407.97 (TRS Fed Deposit $1,222.23 + TRS Fed Care $185.74). When the expense adjustment is processed, the system automatically interfaces to Finance and credits the nonfederal fund 199/7 object code 6119 for the expensed amount of $18,574.92 and 6146 for the TRS Emplr Care amount of $102.18 and debit cash. It then debits the federal fund 211/7 object code 6119 for $18,574.92 and 6146 in the amount of $1,510.15 (TRS Fed Deposit $1,222.23 + TRS-Care $185.74 + Emplr Care $102.18) and credit cash. The system does not make any transfers to the Payroll Clearing Account; the offsetting entries to the clearing fund are the responsibility of the user.
Note: Since this employee accrues, the system is unable to determine what correction needs to be made to the TRS 3 and TRS 489 reports. The next time the payroll is processed, the user needs to make the necessary adjustments to the total amount sent to TRS on the TRS 3 and TRS 489 reports.
Field | Description |
---|---|
Employee |
Begin typing the employee name or number. As you type the data, a drop-down list of corresponding data is displayed. Select an employee and click Retrieve. Or, click Directory to perform a search in the Employees directory. |
❏ Under Post Options, select from the following options:
Post to Master | Select to update only Human Resources tables. |
---|---|
Post to Master and Interface to Finance | Select to update Human Resources tables; automatically creates and posts the transactions to Finance. |
JV Number | This field is only enabled when Post to Master and Interface to Finance is selected. Users can type the journal voucher number for the Finance transactions. Leading zeros are not required. If left blank, the default format for the journal voucher number is P + current year pay frequency + month and day of the calculation date in the To field. |
Interface Transaction Date | This field is enabled only when Post to Master and Interface to Finance is selected. The system is set to the current system date, but users can change the date. This date is applied to transactions that are created for finance and is displayed in the Date field on the general ledger. |
❏ Under Accounting Period, if Post to Master and Interface to Finance is selected, select from the following options:
Post to Current Acct Period | When you click Execute, the following may occur: If Finance end-of-month processing is being performed against any file ID, then you may not post to either accounting period. If the current and next accounting periods are the same and the current accounting period is closed, a message is displayed indicating that the current accounting period XX is closed and that the next accounting period is also set to XX. You are not allowed to post at this time. Click OK; then click Cancel to return to the Expense Only tab. If the current accounting period is closed, a message is displayed indicating that the current accounting period XX is closed. You are not allowed to post at this time. Click OK and then click Cancel to return to the Expense Only tab. You can select the next accounting period for posting. |
---|---|
Post to Next Acct Period | This option is selected by default if the current accounting period is being closed. When you click Execute, the following may occur: If the current and next accounting periods are the same, a message is displayed indicating that the current account period XX is closed and that the next accounting period is also set to XX. You are not allowed to post at this time. Click OK, and then click Cancel to return to the Expense Only tab. |
❏ Under Pay Date Range, both From and To are required fields. Pay dates displayed in the drop-down lists are based on the pay dates associated with the current school year.
Only columns that have had associated expenses can be accessed.
Expense Pay | Type the expense pay adjustment for the new account code. |
---|---|
Unemployment Ins | Type the unemployment tax adjustment for the new account code. |
FICA/Med Tax | Type the FICA and Medicare tax adjustments for the new account code. |
Workers' Comp Ins | Type the workers' compensation insurance adjustment for the new account code. Refer to Calculations for information on how to calculate workers' compensation. |
Emplr Health Ins Contrib | Type the employer health insurance contribution adjustment for the new account code. |
TEA Health Ins Contrib | Type the TEA health insurance contribution adjustment for the new account code. |
Emplr Annuity Contrib | Type the employer annuity contribution adjustment for the new account code. |
Emplr Dependent Care | Type the employer dependent care adjustment for the new account code. |
Emplr 457 Contrib | Type the employer 457 contribution adjustment for the new account code. |
TRS Federal Deposit and TRS Federal Care | These fields cannot be modified and are automatically calculated based on the following calculations: TRS Federal Deposit = Expense Pay * District Rate TRS Federal Care = Expense Pay * TRS Care Rate |
Emplr TRS Pension Surch | Type the employer TRS pension surcharge adjustment for the new account code. |
Emplr TRS Care Surch | Type the employer TRS-Care surcharge adjustment for the new account code. |
Emplr TRS Care Contrib | Type the employer TRS-Care contribution adjustment for the new account code. |
Emplr New TRS Contrib | Type the employer TRS contribution for new employees. |
HSA Employer Contrib | Type the employer Health Savings Account contribution for the new account code. |
Emplr 403B FICA Contrib | This field cannot be modified and is automatically calculated based on the expense pay entered if the original 403B FICA contribution was not zero. |
❏ Click Recalc Grts/403B to recalculate based on the expense pay entered if the original 403B FICA contribution was not zero.
❏ Click Execute. A Special Adjustment Report is displayed with a listing of the current adjustments.
If Post to Master is selected under Post Options, the Special Adjustments for Expenses Only Report is displayed with a listing of the current adjustments.
If you click Process before you print, the process report is lost and cannot be retrieved.
❏ Click Process to accept the adjustments.
❏ If Post to Master and Interface to Finance is selected under Post Options, the General Journal Transactions Report is displayed with a listing of the current adjustments. Do one of the following:
❏ Click Process to accept the adjustments.
❏ Click Execute to execute the process.
❏ Click Cancel to terminate the special adjustment without saving the changes and to close the dialog box.
If all amounts for the voided totals and issued totals are zero, Process is disabled. This can occur when the selected pay date range involves checks that have been issued and then voided.
To adjust another job code for the same employee, click in the From Job Code field to select the employee's next job code.
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.