Accounting Tab of the Employees Form (Desktop)

Use the Accounting tab in the desktop application to enter, edit, or review an employee's accounting information.

This tab is available only if you use the Accounting module.

Contents

If you have multiple companies in Deltek, the following applies:

  • The data that you enter on this tab applies to the company that the current record is associated with.
  • The tabs and fields that display are based on the company that the current record is associated with. For example, if the employee is associated with four different companies but only one company has access to Payroll, the Payroll tab of the Employees form only displays when you are viewing that company's record.
  • The values that are available in the individual fields and lookups are based on the company that the record is associated with. For example, only timesheet groups that are associated with the current company are available in the Group field on the Time tab of the Employees form.
  • If the Automatically retrieve your record in Employee Hub/Employee Review check box is selected in My Preferences in the desktop application, the employee record that automatically loads is for the home company that is associated with the current record. If the record is associated with multiple companies, the home company record displays first.

Fields

Enter accounting information for an employee such as job cost rates, overtime rates, unposted labor rates, employee type and category information, and payroll information. The information that you enter in these fields is used when you process timesheets or payroll and when you generate reports.

Field Description
Job Cost Rate Enter the rate that you want to use to distribute the cost of the employee's labor hours to projects. When you post timesheets, Deltek associates a rate with each employee's labor charges. This rate displays in the general ledger and on your project reports. Typically, the job cost rate is a standard rate (the employee's annual salary / 2080 hours per year).

There are three methods to calculate an employee's job cost rate:

  • Fixed Hourly Rate (also known as a Standard Rate)
  • Payroll Rate
  • Direct Personnel Expense (DPE)

When you post employee timesheets, Deltek debits labor charges for each employee (by employee type) to the labor accounts specified on the Employee Types form (Settings > Advanced Accounting > Employee Types) and credited to the Job Cost Variance account (703.00). This method ensures that a consistent rate is posted to all projects for a given employee, regardless of the number of hours worked.

When you process your payroll, Deltek posts the gross payroll amount to the Job Cost Variance account. Any remaining balance in the Job Cost Variance account is the adjustment amount of the standard cost used for project reporting and the actual pay rate. Typically, there is an adjustment in this account due to employees working more or less than 40 hours per week (2,080 hours per year).

To enter a salaried rate in the Job Cost Rate field, you must select the Allow job cost rates to be salaries option on the Timesheets tab of Accounting Company Settings (Settings > Accounting > Company).

The job cost rate cannot exceed the maximum hourly rate entered on the Job Cost tab of General Accounting Configuration.

The job cost rate and job cost type should be consistent. For example, if you enter 35.00 in the Job Cost Rate field, you must select Hourly as the type in the Job Cost Type field.

You can use cost rate methods and tables to override the information entered in the Job Cost Rate field. You specify cost rate methods/tables for employees on the Time tab of the Employees form.

Job Cost OT Pct

Enter the percentage of the employee's hourly wage you want to apply to projects when the employee works standard overtime hours.

Each employee determines the amount of overtime worked in a given labor period. Deltek does not calculate overtime hours based on the hours worked. Overtime hours must be entered in Timesheets or Timesheets Transaction Entry to be considered overtime hours.

If you are using Accounting, the overtime percentage affects indirect expenses through the Job Cost Variance account. If you set employee job cost rates to rates greater than you pay your employees, your overhead costs are lowered by the excess amount of the job cost rate. This variance adjusts the Income Expense Statement to the actual payroll cost.

When posting timesheets, Deltek credits the Job Cost Variance Account (703.00), which offsets the labor expense posted. When you process your payroll, Deltek debits the Job Cost Variance account for the total payroll expense. The resulting variance amount is the difference between the posted timesheets and the payroll amount.

To cost all hours on a project but not pay your employees overtime, enter all hours worked in the regular hours fields on timesheets, regardless of the number of hours worked. Or, enter 100 in the Job Cost Ovt Pct field and enter overtime hours in the overtime hours fields on timesheets: the overtime hours entered will be costed at regular rates and you will be able to show the overtime hours separately on timesheets and project reports..

If you cost overtime hours but do not pay your employees overtime (in Payroll), you will most likely see a variance in the Job Cost Variance account. You can enter 0 in the Job Cost Ovt Pct field; however, your project reports will then show overtime hours but no cost for those hours.

Job Cost OT-2 Pct Enter the percentage of the employee's hourly wage you want to cost to projects when the employee works special overtime hours. Use this field if you need to cost certain overtime hours to projects at a rate that differs from the standard overtime rate.
Job Cost Type

Select the job cost type for the employee: Hourly or Salary. The job cost type that you select is used with the data that you enter in the Job Cost Rate, Job Cost Ovt Pct, and Job Cost Ovt-2 Pct fields, and the employee's timesheet entries, to calculate the employee's job cost rate for the hours charged to a project.

The job cost rate and job cost type must be consistent. For example, if you enter 35.00 in the Job Cost Rate field, you should select Hourly as the type in the Job Cost Type field.

Use Total Hours as Standard on Time Analysis

Use this check box to specify how standard hours or amounts are calculated for employees on the Time Analysis report.

If you select this check box, Deltek uses the total hours worked to determine the standard current (CUR), month-to-date (MTD), and year-to-date (YTD) hours or amounts.

If you do not select this check box, Deltek calculates the standard current (CUR), month-to-date (MTD), and year-to-date (YTD) hours or amounts using one of the following formulas:

Current

Deltek bases the standard hours calculation for current amounts on the job cost frequency. The job cost frequencies and formulas follow:

  • weekly (hours per day x 5)
  • biweekly (hours per day x 10)
  • semi-monthly (hours per day x 260 [52 weeks x 5 days per week] divided by 24 [two periods per month])
  • monthly (hours per day x 260 [52 weeks x 5 days per week] divided by 12 [one period per month])

Month-to-date

Deltek bases the standard hours calculation for month-to-date amounts on the following formula:

hours per day x number of workdays between the accounting period start or hire date and the "as of" date specified on the General tab for Time Analysis

Deltek increases the number of workdays to the nearest week. For example, if your employee completes 22 workdays for the current month, Deltek increases the figure to 25 to calculate standard hours for five complete weeks.

Year-to-date

Deltek bases the standard hours calculation for year-to-date amounts on the following formula: hours per day x number of workdays between the fiscal year start or hire date and the as of date specified on the General tab for Time Analysis.

Deltek increases the number of workdays to the nearest week. If, for example, your employee has completed 22 workdays for the current year, Deltek increases the figure to 25 to calculate standard hours for five complete weeks.

Employee Type If you select the Approved for use in processing option on the General tab, you must select an employee type. Use this drop-down list to classify the employee by type, such as Principal or Employee. Each employee type can be associated with a direct and indirect account. You define employee types using the Employee Types form (Settings > Advanced Accounting > Employee Types.
Labor Category Select a labor category for the employee such as Principals, Project Managers, or Architects.
Target Ratio

Enter the percentage of the employee's time that you expect will be charged to regular, revenue producing projects. This information displays on the Time Analysis report.

Use one of the following formulas to calculate a target ratio:

  • Gross Chargeable Ratio: Deltek calculates this ratio by dividing the total direct hours by the total hours worked. The average for all employees is typically about 65%.
  • Net Chargeable Ratio: Deltek calculates this ratio by dividing the total direct hours by the total hours charged or worked minus any benefit hours. The average for all employees must be higher than the Gross Chargeable Ratio.
  • Direct Hours divided by Standard Hours
  • Direct Hours divided by (Standard Hours minus Benefit Hours)
Utilization Ratio

Enter the maximum amount of time (expressed as that percentage) that you can assign the employee as a named resource on your firm's projects. For example, if you expect an employee to spend 75% of her time actively involved in project work, enter 75 in this field.

The Deltek Planning application uses the utilization ratio to determine an employee's availability for project assignments.

  • The Commitment field on the Named Resource tab of the Project Planning Resource Search contains a drop-down list of percentages that allows you to search for available resources based on the amount of free time an employee has during a specified time frame. This search option also allows you to identify employee's who are Over Used and Under Used. If the amount of time an employee is actually assigned as a resource: the employee’s utilization percentage: exceeds the employee’s utilization ratio, then the employee is over used and should not be assigned to additional projects. If the employee's utilization percentage is less than his utilization ratio, then the employee is under used and is therefore available for additional project work.
  • Employee utilization ratios display on the Utilization tab of the Project Planning Resource Search after you specify options and click Apply. This allows you to compare each employee's utilization ratio against his utilization percentage.

Absence Accruals Grid

Use the Absence Accruals grid to enter, copy, delete, edit, or review information about your company's absence accruals plans. You can set up an unlimited number of accrual codes, each of which represents a different absence type, such as vacation, sick leave, or personal time off.

Field Description
Absence Accruals Drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Insert Click this option to add an absence accrual to the grid.
Copy Click this option to copy absence accrual information from one row on the grid to a new row on the grid.
Delete Click this option to delete an absence accrual from the grid.
Absence Accrual Code Select the absence accrual that you want to add to the employee record. Accrual codes can be used company-wide to represent a specific benefit plan. You can define an unlimited number of accrual codes and you can add new codes at any time. You set up accrual codes on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form (Settings > Advanced Accounting > Time Analysis).
Method

Use this option to specify the calculate method for the accrual code.

  • Frequency: A method of frequency will calculate the accrued earned hours for each accrual process based on the Hours Earned per Year divided by the Accrual Frequency. For example, if the employee earns 80 hours a year and benefit accruals are run weekly, the employee will earn 1.54 hours per accrual process.
  • Schedule: A method of accrual schedule that allows you to accrue benefit hours at different rates for different periods of time.
  • Hours Worked: A method of hours worked will calculate the accrued earned hours for each accrual process based on the Hours Earned per Hour Worked times the total posted hours selected in the Accrual Process.

If you use multiple companies, and the company associated with the employee record does not have the Hours Worked feature enabled in Settings, then Hours Worked will not be available in as a method. The values in the drop-down list for this field may vary by company if some companies have the feature enabled and some companies do not.

Schedule

Use this drop-down list to select the accrual schedule that you want to use with the selected accrual type.

If you select a default schedule for the accrual type on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form (Settings > Advanced Accounting > Time Analysis), the default schedule code displays in this field when you select the Use Schedule option. You can change the default setting.

If the Schedule is set to calculate based on Hours Worked, the Hours Earned Per Year, Hours Earned Per Hour Worked, and Max Hours Earned Per Accrual Process fields are defined in the Accrual schedule and locked in this grid.

Hours Earned Per Year This field is enabled when the Method is set to Frequency or Hours Worked. Enter the number of hours per year the employee earns for this absence accrual.
Hours Earned Per Hour Worked

This field is enabled when the Method is set to Hours Worked.

Deltek calculates the Hours Earned Per Hour Worked based on the following information:

  • Hours/day: Personal tab of the Employees form
  • Working days per week: Non-Work Days tab of Time Settings
  • Number of weeks/year: 52
  • Hours Earned Per Year: [amount entered in this field]

The calculation is as follows:

Hours/day x Working days per week x Number of weeks/year. Then, divide that number by the Hours Earned Per Year.

For example:
  • Hours/day: 8
  • Working days per week: 5
  • Number of weeks/year: 52

8 x 5 x 52 = 2080

Hours Earned Per Year = 80

80 / 2080 = .038 Hours Earned Per Hour Worked

If you use multiple companies, this column only displays for companies that have the Method set to Hours Worked.

You can override the default calculation if the Hours Earned per Hour Worked should be a different value than those calculated based on Hours Earned per Year.

Max Hours Earned Per Accrual Process

This field is enabled when the Method is set to Hours Worked. Use this field to define the maximum number of hours to be earned within an accrual run.

For example, a firm did not allow an employee to accrue more benefit hours than an expected workweek, so the maximum hours entered was the expected accrual. Or, a firm did not allow an employee to accrue extra vacation time when they worked additional hours during a timesheet period, so they entered a maximum amount of hours allowed.

Change Date Specify the date on which the accrual will change. For example, if an employee will earn additional vacation time after being employed for a specified period of time, enter the date the employee should begin earning the additional time off. This date displays on the Accrued Time report, where you can use it as a reminder to update employee benefit information.
Has Maximum

Select the way that you want Deltek to determine the maximum number of benefit hours the employee can have at any given time.

For example, if you set a limit of 200 hours for the Vacation absence accrual, the employee can never carry a balance of more than 200 hours of vacation time. After the employee reaches the 200 hour limit, Deltek no longer accrues vacation hours for the employee. If the employee drops below the 200 hour limit, Deltek resumes vacation accrual.

The options are:

  • System: If you select this option, Deltek uses the maximum hours specified for the absence accrual on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form (Settings > Advanced Accounting > Time Analysis).
  • Yes: If you select this option, the Maximum field on the Absence Accruals grid is enabled. Use this field to enter the maximum benefit hours you will allow the employee to have at any given time. This selection overrides the maximum amount specified for the benefit accrual on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form.
  • No: If you select this option, there is no limit to the number of hours that the employee can accrue for this benefit. This selection overrides the maximum amount specified for the benefit accrual on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form.
Maximum

If you select Yes in the Has Maximum field, you must enter the maximum number of benefit hours the employee can have at any given time.

For example, if you set a limit of 200 hours for the Vacation benefit accrual, the employee can never carry a balance of more than 200 hours of vacation time. After the employee reaches the 200 hour limit, Deltek no longer accrues vacation hours for the employee. If the employee drops below the 200 hour limit, Deltek resumes vacation accrual.

This field is disabled if you select System or No in the Has Maximum field.

Has Carryover Limit

Select the way you want Deltek to determine the maximum number of benefit hours the employee can carry over from one benefit accrual year to the next.

For example, if you allow an employee to carry over 80 hours of sick time, and the employee has 90 hours at the end of the year, Deltek deducts 10 hours from the employee's sick time balance when you start the new benefit accrual year. The employee starts the new year with 80 hours of sick time.

The options are:

  • System: Select this option for Deltek to use the carryover limit specified for the benefit accrual on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form (Settings > Advanced Accounting > Time Analysis).
  • Yes: Select this option to enable the Carryover Limit field in the Absence Accruals grid. Use this field to enter the maximum number of benefit hours you will allow the employee to carry over from one benefit accrual year to the next. This selection overrides the carryover limit specified for the benefit accrual on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form.
  • No: If you select this option, there is no limit to the number of hours the employee can carry over from one benefit accrual year to the next. This selection overrides the carryover limit specified for the benefit accrual on the Absence Accrual Setup tab of the Time Analysis and Absence Accrual form.
Carryover Limit

If you select Yes in the Limit Carryover field, you must enter the maximum number of benefit hours the employee can carry over from one benefit accrual year to the next.

For example, if you allow an employee to carry over 80 hours of sick time, and the employee has 90 hours at the end of the year, Deltek deducts 10 hours from the employee's sick time balance when you start the new benefit accrual year. The employee starts the new year with 80 hours of sick time.

This field is not enabled if you select System or No in the Has Carryover Limit field.

Direct Deposit Grid

Use the Direct Deposit grid to maintain employee direct deposit information. The Employee Payments processing routine allows you to deposit all or a portion of an employee’s expense payments to one or more of the employee’s bank accounts.

After you enter direct deposit information, you use the Employee Payments processing routine in the Transaction Center to print checks, post payments, and process direct deposits.

Field Description
Direct Deposit Drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Insert Click this option to add direct deposit information to the grid.
Copy Click this option to copy direct deposit information from one row in the grid to a new row on the grid.
Delete Select a row and click this option to delete it from the grid.
Seq Enter the sequence number for the direct deposit. The sequence number determines the order in which direct deposits are made if you select multiple accounts.
Bank ID Enter the bank routing number of the bank for the employee's deposit.
Account Number Enter the employee's account number for the direct deposit. This is the account where you will deposit funds.
Account Type Select the employee's bank account type.
Status

Select a status for the employee’s direct deposit:

  • Add: This status indicates that you plan to initiate the pre-notification step for this direct deposit account with the next expense repayments processing run.
  • Wait: After you process payroll or employee expense repayments for all employees, any direct deposit accounts with a status of Add change to a status of Wait. This status indicates that you are waiting for bank verification of the employee's account. You must change the status to Active when you receive verification of the employee's account information.
  • Active: This status indicates that the employee's account information has been verified and your bank has approved direct deposit transactions to the account.
Payroll Method

This field is available if you use Payroll. Select the method that you want to use when depositing payroll funds for the employee.

The options are:

  • Amount: Deltek allocates a specified amount of the employee's total paycheck to this account when you process payroll. You enter the amount in the Payroll Amount/Percent field.
  • Percentage: Deltek allocates a specified percentage of the employee's total paycheck to this account when you process payroll. You enter the percentage in the Payroll Amount/Percent field. If the employee has funds deposited to more than one account, the total percentage for all accounts must equal 100%, unless you select Remainder as the Payroll Method for one of the accounts
  • Remainder: An employee can elect to make direct deposits to more than one account. If you select multiple accounts, you can designate one account to receive the balance remaining after specified amounts are deposited to the other accounts. Deltek allocates the amounts or percents specified for all the other accounts, and then allocates any remaining amount to the remainder account. One account must be designated the remainder if you are depositing funds to more than one account and you select Amount as the Payroll Method.
  • None: Deltek does not allocate any portion of the employee's total paycheck to this account when you process payroll for the employee.
Payroll Amount/Percent

This field is available if you use Payroll. If you specified Amount or Percentage in the Payroll Method field, enter the amount or percent that you want Deltek to use when calculating the direct deposit allocation for the account.

If you selected Remainder in the Payroll Method field, leave this field blank.

Expense Repayments Method

Select the expense repayments method to use when you deposit expense repayments for the employee:

  • Amount: Deltek allocates a specified amount of the total expense repayment to this account when you process an expense repayment for the employee. You enter the amount in the Expense Repayments Amount/Percent field.
  • Percentage: Deltek allocates a specified percentage of the total expense repayment to this account when you process an expense repayment for the employee. You enter the percentage in the Expense Repayments Amount/Percent field. If the employee has funds deposited to more than one account, the total percentage for all accounts should equal 100%, unless you select Remainder as the Expense Repayments Method for one of the accounts
  • Remainder: An employee can elect to make direct deposits to more than one account. If you select multiple accounts, you can designate one account to receive the balance remaining after specified amounts have been deposited to the other accounts. Deltek allocates the amounts or percentages specified for all the other accounts, and then allocates any remaining amount to the remainder account. One account must be designated the remainder if you are depositing funds to more than one account and you select Amount as the Expense Repayments Method.
  • None: Deltek does not allocate any portion of the total expense repayment to this account when you process an expense repayment for the employee.
Expense Repayments Amount/Percent If you specified Amount or Percentage in the Expense Repayments Method field, enter the amount or percent you want Deltek to use when calculating the direct deposit allocation for the account.

If you selected Remainder in the Expense Repayments Method field, leave this field blank.

Provisional Rates Section

The provisional cost and billing rates are used for the following:

  • Deltek Planning uses the provisional cost and billing rates to calculate planned cost or billing amounts when you select From Employee Provisional Rate as the Rate Method on the Rates tab of Project Planning. Deltek uses these provisional rates only until the timesheets are posted.
  • The Time Analysis report uses the provisional rates to calculate realization hours when you use the Employee Realization Reporting feature.
Field Description
Cost

Enter the rates and overtime percentages that you want Deltek Planning to apply to unposted timesheet entries when calculating labor charges for the employee at cost rates.

  • In the Cost Rate field, enter the amount that you want Deltek to use to calculate unposted amounts for regular hours.
  • In the Cost Ovt Pct field, enter the percentage that you want Deltek to use to calculate unposted amounts for standard overtime hours.
  • In the Cost Ovt-2 Pct field, enter the percentage that you want Deltek to use to calculate unposted amounts for secondary overtime hours.

Provisional rates are used only until the timesheets are posted.

Billing

Enter the rates and overtime percentages that you want applied to unposted timesheet entries when calculating labor charges for the employee at billing rates.

In the Billing Rate field, enter one of the following:

  • The amount that you want Deltek to use when calculating unposted amounts for regular hours.
  • The percentage that you want Deltek to use to when calculating unposted amounts for standard overtime hours.
  • The percentage that you want Deltek to use when calculating unposted amounts for secondary overtime.

Provisional rates are used only until timesheets are posted.

Direct Deposit Remittance Section

This section determines whether the employee should receive a direct deposit remittance email during the Employee Expense and Payroll Processing processes.

Field Description
Email Expense Select this check box if you want the employee to receive an email message about Direct Deposit Expense remittances. You can create and send an email message with remittance information from the Employee Expense application when the Employee Expense Direct Deposit file is created.
Email Payroll Select this check box if you want the employee to receive an email regarding any Direct Deposit Payroll remittance. You can create and send an email message with remittance information from the Payroll application when the Payroll Direct Deposit file is created.

External Payroll Information Section

The following fields depend on the type of Payroll interface selected on the Timesheets tab of Accounting Company Settings (Settings > Accounting > Company). : ADP, Paychex, or Ceridian.

Field Description
ADP File Number Enter an identification number for the employee's ADP files. If the employee's number is between 51 and 999999, Deltek defaults that number within this field. You must provide this number to ADP.

This field displays only if you enable the ADP interface on the Timesheets tab of Accounting Company Settings Configuration. Deltek uses the data in this field when you run the ADP Export utility.

ADP Company Code

This field displays only if you enable the ADP interface on the Timesheets tab of the Accounting Company Settings form. Deltek uses the data in this field when you run the ADP Export utility.

Enter a company code for the employee. ADP uses this code to associate the employee with your company. Your company provides ADP with this code.

  • If you entered a default company code on the Timesheets tab of the Accounting Company Settings form, you do no need to enter an ADP company code here.
  • If the employee is associated with an ADP company code for a specific organization on the General tab of Individual Organization Settings, you should not enter an ADP company code here. If you enter a code here, it will override the organization-level code.
ADP Rate Code This field displays only if you enable the ADP interface on the Timesheets tab of the Accounting Company Settings form. Enter the ADP code that indicates the employee's pay rate. ADP provides the standard rate codes. Deltek uses the data in this field when you run the ADP Export utility.
Paychex Employee Number This field displays only if you enable the ADP interface on the Timesheets tab of the Accounting Company Settings form. Enter an identification number for the employee's Paychex files. This number can be the same as the employee's number that is specified in the Employees hub. You must provide this number to Paychex. Deltek uses the data in this field when you run the Paychex Export utility.
Paychex Client Number

This field displays only if you enable the Paychex interface on the Timesheets tab of the Accounting Company Settings form. Deltek uses the data in this field when you run the Paychex Export utility.

Enter your company's Paychex client number. Paychex uses this number to associate the employee with your company. Your company provides Paychex with this number.

  • If you entered a default client number on the Timesheets tab of Accounting Company Settings, you do no need to enter a client number here.
  • If you associate the employee with a Paychex client number for a specific organization on the General tab of Individual Organization Settings, do not enter a client number here. If you enter a client number, it will override the organization-level number.
Paychex Code (Reg, OT, OT-2) Enter the Paychex codes for regular, overtime, and special overtime. Paychex provides your company with these codes.
Paychex Rate # This field is used to denote salary vs. hourly employees. Enter a Rate value from the drop-down list. You can enter a numeric value of 1 – 5, or enter a value of M to mark the hours as “memo” hours. Memo hours are consumed hours that are not considered as pay hours.
Ceridian Employee Number

This field displays only if you enable the Ceridian interface on the Timesheets tab of Accounting Company Settings Configuration. Deltek uses the data in this field when you run the Ceridian Export utility.

Enter an identification number for the employee's Ceridian files. This number can be the same as the employee's number that is specified in the Employees hub and can be a maximum of nine numeric characters. You must provide this number to Ceridian.

Ceridian Company Number

This field displays only if you enable the Ceridian interface on the Timesheets tab of Accounting Company Settings Configuration. Deltek uses the data in this field when you run the Ceridian Export utility.

Enter a company number for the employee, using seven alpha-numeric characters. This number must correspond with the department code already set up in Ceridian Powerpay. Your company provides Ceridian with this code.

  • If you entered a default company code on the Timesheets tab of Accounting Company Settings, you do no need to enter a Ceridian company number here.
  • If the employee is associated with a Ceridian company number for a specific organization on the General tab of Individual Organization Settings, you should not enter a Ceridian company number here. If you enter a code here, it will override the organization-level code.
Ceridian Distribution Code

This field displays only if you enable the Ceridian interface on the Timesheets tab of Accounting Company Settings Configuration. Deltek uses the data in this field when you run the Ceridian Export utility.

Enter the Ceridian distribution code that indicates the employee's pay rate, using exactly three numeric characters. Ceridian provides the standard rate codes.

ClieOps Section

Field Description
Account Number

If you select Ordinary Account in the Account Type field, enter the employee’s bank account number in the following format in this field: xxx.xx.xx.xxx

For ClieOp accounts, enter a seven digit account number. ClieOp accounts are typically used for payments made in Euros to recipients in the Netherlands.

Account Type Select Ordinary Account or, for a ClieOp account, select Seven Digit Account.

SEPA Section

These settings apply if you make employee expense payments to employees using export-to-text files with the SEPA file format. The SEPA (Single Euro Payments Area) .xml file format is commonly used in the Netherlands.

Field Description
IBAN Enter the international bank account number (maximum 34 characters) for an employee. This is used to transmit the payment to a payee when the .xml file is sent to the bank.
BIC Enter the bank identification code (either 8 or 11 characters) for an employee. This is used to transmit the payment to a payee when the .xml file is sent to the bank.