There is an hierarchy of where Sage 100 will look for the expense account to post earnings.
The G/L account defined in Labor Code Maintenance is the first place Sage 100 will look for the account number. If there is no General Ledger account defined in Labor Code Maintenance, it then looks in Earnings Code Maintenance, if the earnings code is NOT set to post by Department it will look for the G/L Expense account defined in Earnings Code Maintenance. If the earnings code is set up to Post by Dept, it will then look in Department Maintenance. In Department Maintenance it will first look on the Earnings tab then if earnings code is not defined there it will use the G/L account defined in the Standard Payroll field on the Main tab
To set up posting to use the G/L Account in Labor Code Posting, follow these steps:
- Open Payroll, Setup, Labor Code Maintenance
- In the Labor Code field, select the code
- In the Wage Expense Account field, select the General Ledger account for this labor code
- Click Accept
NOTE: Reports can still be run for Labor Codes if they do not have the G/L Expense account.
If Wage Expense Account defined in Labor Code Maintenance is blank, it then looks to Earnings Code Maintenance
- Open Payroll, Setup, Earnings Code Maintenance
- Select the Earnings Code from look up
- In the Expense Account field, select the General Ledger account for these type of earnings OR select Post Exp by Dept
- Click Accept.
If the Post Exp. by Dept. check box is selected in Earnings Code Maintenance, it looks at Department Maintenance (Earnings tab):
- Open Payroll, Setup, Department Maintenance.
- In the Department Maintenance field, select the department.
- Click the Earnings tab.
- In the Earnings Code field, select the type of earnings.
- In the Expense Account field, select the General Ledger account, and then click OK.
- Click Accept after all accounts are assigned.
If the specific earnings code is not defined on the Earnings tab in Department Maintenance, it looks at the Standard Payroll field on the Main tab in Department Maintenance:
- Open Payroll, Setup, Department Maintenance
- Select the Department Number look up
- In the Standard Payroll field, select the appropriate General Ledger account. This is the default account for earnings posted by department.
Note: If an employee had earnings in a different department than his home department, (i.e. a different department code was used on Payroll data entry earnings lines), than you must verify the G/L accounts used for that department as well. The payroll tax amounts will post to the department where the earnings were posted to.
DocLink: