How do I determine the source of an expense account for my payroll entries?
Description
Cause
Resolution

Review the following reports to determine if the entry was from Labor or Burden:

  • Reports, Reconciliation, Labor Cost by Account and Job
    1. Enter the the Accounting date noted above in the from and through fields.
    2. Click Conditions, select the condition And Job NE "" and click Delete.
    3. Click Add and add a condition for Expense Account Equal to and enter the Account number noted above.
    4. Review the report for employees with time entries that are posted to the Account noted above.
  • Reports, Reconciliation, Burden by Debit account
    1. Enter the Accounting date noted above in the from and through fields.
    2. Click Conditions, click Add and add a condition for Expense Account Equal to and enter the Account number noted above.
    3. Review the report for employees with Fringe or Tax entries that are posted to the Account noted above.
  • If you use Equipment Cost with Payroll, Inquiry, Check Information, EQ Detail
    • Add condition for Debit Account Equal To and the Account number noted above.

The expense account for payroll entries follows an account retrieval hierarchy based on the Job Cost and Payroll settings.

For Payroll costs that apply to a job, the expense account is retrieved first from Job Cost. To review these settings, from the Job Cost File menu, select Company Settings, JC Settings and click GL Entry:

In the Cost account section, the Retrieval method determines which expense account prefills for an invoice as follows:
Note: If the Retrieve account prefix from job checkbox is checked, the GL prefix specified on the job is combined with the base account based on the retrieval method.

  • By job : The expense account prefills from the Job Setup window (Setup, Jobs - AP and GL tab). If there is no account specified on the job, then the expense account prefills from the Default account (File, Company Settings, JC Settings, GL Entry).
  • By Cost Code : The expense account prefills from the Cost Code Setup window (Setup, Cost Codes - General tab). If there is no account specified on the job, then the expense account prefills from the Default account (File, Company Settings, JC Settings, GL Entry).
  • By category (if used) : The expense account prefills from the Category Setup window (Setup, Categories - General tab). If there is no account specified on the category, then the expense account prefills from the Default account (File, Company Settings, JC Settings, GL Entry).
  • Use default account : The expense account prefills from the Default account (File, Company Settings, JC Settings, GL Entry).
  • Use hierarchy : The expense account prefills from the first Job Cost source that contains an account in a search hierarchy as follows:
    1. Category (If categories are used)
    2. Cost Code
    3. Job
    4. Default Account

For entries that do not apply to a job, or if a valid account is not retrieved from Job Cost, the expense account is retrieved by the payroll expense account retrieval hierarchy. Follow these steps to determine the expense account retrieved for entries not related to a job.

Determine if you are set to retrieve prefixes for your GL Accounts:
  1. From the Payroll File menu, select Company Settings, PR Settings.
  2. Click GL Entry Settings and note the check box for Retrieve prefixes.

If Retrieve Prefixes is checked, the GL prefix and base account can be retrieved separately. The prefix is retrieved and combined with the base account as follows:

  1. Equipment Cost
    Note: The full account is retrieved from the Equipment Cost module.
  2. The pay, fringe, or Tax setup Expense account field.
    Note: The full account or just base account can be specified.
  3. The Department from the payroll time entry.
  4. The Pay Group assigned to the check.

If Retrieve Prefixes is not checked, the expense account is retrieved as follows:

  1. Equipment Cost (if applicable)
  2. The Pay, Fringe, or Tax Setup Expense Account field
  3. The Department (Setup, Departments, Pay Expense Account or Burden Expense Account.)
  4. The Pay Group (Setup, Pay Groups, Pay Expense Account or Burden Expense Account.)
  5. The Default Earnings expense account or Burden expense account (File, Company Settings, PR Settings, GL Entry Settings)
If the entry is related to EQ Detail:
DocLink: Payroll debit entries are going to the wrong General Ledger account

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles