Payroll module
 Payroll for Advantage

Welcome to Payroll for Advantage. The Payroll module lets you perform the following functions:

Automatically or manually process your firm's payroll.

Produce payroll posting logs.

Generate employee paychecks.

Complete direct deposit processing.

Process and print W-2 forms.

Print worksheets that help you fill out state unemployment insurance reports, quarterly state income tax reports, and federal Forms 940 and 941.


Choosing an Installation Date

Because the Payroll module accumulates quarter-to-date and year-to-date wage and withholding amounts, it is important that you choose an installation date that will ensure your payroll amounts are reported correctly.

You should keep the cash-basis nature of payroll in mind when choosing an installation date. Technically, a payroll takes place on the day that paychecks are distributed, which is not necessarily the same as the payroll period end date.

For example, if you pay employees on January 1, 2000, for their labor during the second half of December, the payroll technically belongs in the month of January. It should be included, for payroll and accounting purposes, in the first quarter of 2000, and should appear on the employees’ 2000 W-2s. We suggest that you handle this situation in the same way you always have.

Options and times for installing Payroll for Advantage:

Beginning of W-2 Year

Beginning of W-2 Quarter

Middle of W-2 Quarter or any other time during the W-2 Year

 Notes


Installation and Setup

If you are installing the Payroll application at the same time as all of your other Deltek Advantage applications, you can follow the installation steps you received with your Deltek Advantage software.

To install the Payroll application after you have installed your other Deltek Advantage applications:

1.	Select Utilities, Module Installation from the Deltek Advantage main menu. Deltek Advantage displays the Deltek Advantage Module Installation form.

2.	Click on the box next to Payroll in the Deltek Advantage Licensed Modules section of this form.

3.	Enter the password for the Payroll application. If you have not received a password for this application, contact Advantage Application Support immediately at 617.492.4410.

After you install the Payroll module, you need to set up Deltek Advantage to process your payroll data. There are several steps and issues you need to decide on during this process. You need to complete the following procedures:

•	To order paychecks and W-2 forms, see Ordering Check Stock for Deltek Advantage.

•	To set up Payroll related accounts to your chart of accounts, see Setting Up Payroll-Related Accounts.

•	To set up general payroll parameters, see Payroll Setup Maintenance.

•	To set up firmwide withholding codes, see Payroll Withholding Code Table Maintenance.

•	To enter history about your past payrolls, see Payroll Journal.

 Related Topics


Types of Payroll Hours

The Payroll module consists of the following types of payroll-related hours:

Timesheet Hours

Pay Hours

Deltek Advantage also tracks benefit hours, through the Benefit Accrual feature of Deltek Advantage Project Control.

 Note

 Related Topics


Ordering Check Stock for Advantage
Ordering Check Stock for Deltek Advantage

In order to produce checks using Deltek Advantage, you need to obtain check stock. You can obtain check stock from:

•	Emily Business Forms at (800) 392-6018.

•	Deluxe Business Systems, Inc. at (800) 328-0304.

Prior to ordering check stock, test the printer on which you will be running checks to determine whether the printer draws paper from the top or the bottom of the tray. Both Emily and Deluxe can sort your check stock accordingly, for example, using a check sort of 1-100 for printers that draw paper from the top or a check sort of 100-1 for printers that draw paper from the bottom.

You can also order W-2 Forms for your printer from Emily Business Systems or Deluxe Business Systems or from almost any business forms supplier. The W-2 Forms often change from year to year. A notice of any W-2 Form changes is included with the year-end Payroll system announcement, which you receive at the end of December.

 Note


Setting Up Payroll-Related Accounts

The Payroll module makes postings to a number of general ledger accounts. In order to make these postings, the Payroll module requires that these accounts be set up in your Chart of Accounts. You reference these accounts later in the installation process, when you enter payroll parameters.

The Payroll-Related Account Categories that Deltek Advantage uses may differ from the accounts used by your firm.

 Related Topics


Customizing the Chart of Accounts

Before you set up any Payroll accounts:

1.	Check the current Chart of Accounts to see if you have an account for each payroll account.

2.	Use Chart of Accounts Table Maintenance to add any accounts that are missing. If you make changes to your Chart of Accounts, the changes must be reflected in the automatic posting account numbers in Payroll Setup Maintenance.

If you change any account in your Chart of Accounts, you must change the account on the setup form on which you specify the account. You can modify payroll accounts in Payroll Setup Maintenance and Withholding Code Table Maintenance.

 Related Topics


Payroll Setup Checklist

Prior to using the Payroll module, you must enter/define certain firmwide information to be used for all employees in your firm. You can specify most of this setup information on an employee-by-employee basis. However, this information is necessary to collect the default information to use with employees.

Payroll Setup Checklist

The following checklist describes the process to perform in order to set up the Payroll application for users in your firm. Each step is described later in this section. Print out this page and check off each item as they are completed.

Completed	Step
___________	Add Payroll accounts (Salaries Payable, Withholding Accounts, etc.)
___________	Specify general information for payroll (frequency, Salaries Payable account, etc.)
___________	Enter Payroll withholdings (Federal, FICA, State, etc.)
___________	Specify general employee Payroll information.
___________	Enter withholding codes for your employees.
___________	Enter direct deposit information for your employees.
___________	Enter payroll history for your employees.


Payroll Setup Maintenance

Payroll Setup Maintenance lets you enter miscellaneous payroll data to be used by your firm. This routine collects the basic information about how your firm uses the Payroll module. While you should enter this information as a first step in using the Payroll application, you can also modify this information as necessary.

To enter general payroll setup parameters for your firm:

1.	Select Utilities, Setup Table Maintenance, Payroll, Payroll Setup from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Setup form.

2.	Complete the fields on the Payroll Setup form referring to the context-sensitive help  on the form.

Payroll Frequency
Bank Code
Post net payroll directly to bank
Salaries Payable Account
FICA Project/Task
FICA Account
Bonus Cost Project/Task
Bonus Cost Account
Other Pay Cost Project/Task
Other Pay Cost Account
Payroll Check Template
Direct deposit for bonus/adjustments
Allow changes to payroll history
Supress SSN on Payroll List and Journal Reports
3.	Click on the Save button to save your changes.

4.	Click on the Close button to exit Payroll Setup and return to the Deltek Advantage main menu.

 Related Topics


Defining a Bank Code and Salaries Payable Account in Payroll Setup Maintenance

If you are posting salaries payable directly to a cash account (for example, 101.00), you must enter a bank code. This bank code will cause the checks to be recorded in Bank Statement Reconciliation.

If you are posting salaries payable to a liability account (for example, 231.00), one of the following can occur:

a)	If you do not reference the bank code, a check will be recorded in Bank Statement Reconciliation at the time you enter the Cash Disbursement. One check is listed for the total payroll.

b)	If you do reference the bank code, the individual check appears in Bank Statement Reconciliation as a payroll check. If you use this method, use a Journal Entry to debit the liability and credit cash because the Cash Disbursement causes the checks to double in Bank Statement Reconciliation.

 Note


Payroll Withholding Setup

Payroll Withholding Setup enables you to collect and enter information about your firm’s withholdings that apply to your employees. During this setup routine, you establish a firmwide pool of withholdings. (You identify the withholdings that apply to each employee during Employee Payroll Withholding Table Maintenance.)

You can establish an unlimited number of withholdings in the Payroll module. However, your paychecks can only show detailed information for up to 17 withholdings.

To have Deltek Advantage automatically compute FICA withholdings, using an internal table that is automatically updated when you install a year-end payroll update, set the method for all FICA withholdings to System in both Payroll Withholding Setup and Employee Payroll Withholding Table Maintenance.

Field Descriptions

Code	Default withholding for new employees
Description	Suppress when processing payroll
Credit account	Exclude 401(k) amounts
Type	Exclude cafeteria plan amounts
Method	Print withholding amount on W02 statement
Locale	Reset limit at time of W-2 initialization
Amount/percent	Default withholding amount to zero for bonus payroll
Wage base	Print on paycheck
Link to Calculate Overall Limit
What do you want to do?

Add a new withholding code.

Modify an existing withholding code.

Delete a withholding code.

 Related Topics


Adding a Withholding Code

There is no limit to the number of withholding codes you can have defined for your firm. However, your paychecks can only show detailed information for up to 17 withholdings.

Withholding codes can be added at any time.

To add a withholding code:

1.	Select Utilities, Setup Table Maintenance, Payroll, Payroll Withholding Setup from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Withholding Setup form.

2.	Click on the Add button located at the bottom of the Payroll Withholding Setup form. Deltek Advantage displays a blank Payroll Withholding Setup form.

3.	Complete the fields on the Payroll Withholding Setup form, referring to the context-sensitive help on the form.

4.	Click on the Save button to save your changes.

5.	Click on the Close button to exit Payroll Withholding Setup and return to the Deltek Advantage main menu.


Modifying a Withholding Code

You can change most data in Payroll Withholding Setup at any time. For example, you can edit the method or the options for the withholding code.

To modify a withholding code:

1.	Select Utilities, Setup Table Maintenance, Payroll, Payroll Withholding Setup from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Withholding Setup form.

2.	Scroll to the withholding code to modify.

3.	Modify the withholding code’s information as desired by completing the fields on the Payroll Withholding Setup form, referring to the context-sensitive help on the form.

4.	Click on the Save button to save your changes.

5.	Click on the Close button to exit Payroll Withholding Setup.


Deleting a Withholding Code

You can delete a withholding code using Payroll Withholding Setup only if there has never been any activity posted to the withholding code. For example, when you first set up and add withholding codes to the database, you may use Payroll Withholding Setup to delete codes that have no activity posted to them yet.

To delete a withholding code using Payroll Withholding Setup:

1.	Select Utilities, Setup Table Maintenance, Payroll, Payroll Withholding Setup from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Withholding Setup form.

2.	Scroll to the withholding code to modify.

3.	Ensure that this withholding code has not yet been referenced by a posting or processing session.

4.	Click on the Delete button. Deltek Advantage displays the following message:

Delete withholding code <withholding code name>?

5.	Click on the Yes button. The withholding code is deleted from your database.

6.	Click on the Close button to exit Payroll Withholding Setup.


Standard Withholding Codes

All firms in the United States have withholdings for federal tax and FICA. Many have withholdings for state and local taxes as well. Deltek Advantage includes all state and several local tax withholdings and calculates them according to tax law. For further information, see Withholding Types.

In addition most firms also have a number of withholdings for health plans, retirement plans, charities, and other miscellaneous deductions. Deltek Advantage breaks out these other withholdings in two separate groups:

•	401(k) and 125/Cafeteria Plans - 401(k) and 125/Cafeteria withholdings are unique because contributions made to these plans are usually not considered taxable wages. Therefore, the Payroll module does not apply federal and most state and local taxes to 401(k) and 125/Cafeteria contributions. 125/Cafeteria plans are not subject to FICA withholdings.

•	All Other Withholdings - The rest of a firm’s withholdings are made according to the firm’s specifications.


Choosing a Code

On paychecks and on the Payroll Journal, Deltek Advantage prints withholdings in alphanumeric order by code. For example, a withholding with the code 401K will come before a withholding ARKANSAS, and ARKANSAS will come before FEDERAL.

However, most firms prefer to have taxes listed before other withholdings. Therefore, we suggest a coding sequence as follows:

Code	Meaning
FEDERAL	Federal Tax
FICA-HI	FICA - Hospital Insurance
FICA-OASDI	FICA - Old-Age, Survivors, and Disability Insurance
SARKANSAS	State tax, Arkansas
W125	125/Cafeteria withholding
W401K	401(k) withholding
WBLUECROSS	Blue Cross withholding


Withholding Types

When you set up a withholding, you must specify the type of withholding:

Federal Withholding Type

FICA-HI Withholding Type

FICA-OASDI Withholding Type

State Withholding Type

Local Withholding Type

401(k) Withholding Type

125 Cafeteria Withholding Type

Other Withholding Type

 Notes


ADP Labor Codes Setup Maintenance

Deltek Advantage requires labor codes for all timesheet transactions to define and organize labor activity. Because labor codes vary with each firm, these codes are not defined in Deltek Advantage.

You enter special labor codes to indicate pay rates that vary from an employee’s regular salary or wage. If, for example, you have an employee working on a project that requires special hazard pay, you can use a special labor code to associate these hours with a pay rate that is different from the employee’s usual salary or hourly wage.

To enter ADP labor codes for your firm:

1.	Ensure that you have enabled ADP in General System Setup.

2.	Select Utilities, Setup Table Maintenance, Payroll, ADP Labor Codes from the Deltek Advantage main menu. Deltek Advantage displays the ADP Special Labor Codes form.

3.	Complete the fields on the ADP Special Labor Codes form, referring to the context-sensitive help on the form.

4.	Click on the Save button to save your changes.

5.	Click on the Close button to exit ADP Special Labor Codes Setup and return to the Deltek Advantage main menu.


Establishing Employee Payroll Information

In Employee Table Maintenance, you provide information about your employee’s pay rate and type, withholdings, and direct deposit status.

To enter employee payroll information:

1.	Select Tables, Employees from the Deltek Advantage main menu. Deltek Advantage displays the Employee Table Maintenance form.

2.	Complete the fields on the Payroll tab of Employee Table Maintenance, referring to the context-sensitive help on the form.

3.	Click on the Save button to save your changes.

4.	Click on the Close button to exit Employee Table Maintenance and return to the Deltek Advantage main menu.

To gain access to withholding and direct deposit information for the employee, see:

Employee Payroll Withholding Table Maintenance

Employee Payroll Direct Deposit Table Maintenance

 Tip


Employee Payroll Withholding Table Maintenance

The Employee Payroll Withholding form of Employee Payroll Table Maintenance, allows you to enter tax and other withholding information for your employees. Consult the appropriate Deltek Advantage Tax Facts sheet for applicable fields and settings. You enter some or all of the following information for each withholding:

To enter information on the Withholding form of Employee Payroll Table Maintenance:

1.	Select Tables, Employees from the Deltek Advantage main menu. Deltek Advantage displays the Employee Table Maintenance form.

2.	Click on the Withholdings button on the Payroll tab of Employee Table Maintenance. The Employee Payroll Withholding Table Maintenance form appears.

3.	Complete the fields on the Employee Payroll Withholding Table Maintenance form, referring to the context-sensitive help on the form.

4.	Click on the Close button to return to the Payroll form.

5.	Click on the Save button to save your changes.

6.	Click on the Close button to exit Employee Table Maintenance and return to the Deltek Advantage main menu.


Employee Direct Deposit Table Maintenance
Employee Payroll Direct Deposit Table Maintenance

You can use the Payroll Direct Deposit feature to automate the direct deposit of your employees’ paychecks. When you process direct deposit, Deltek Advantage:

•	Generates a disk file using Automated Clearing House (ACH) format, which is generally accepted by most banks and other financial institutions. You send this file to your bank after you process payroll for the period.

•	Generates a Direct Deposit report. This report lists the employee number, employee name, social security number, bank ID, bank account number and type, direct deposit status, and direct deposit amount for each employee included in the direct deposit run.

The Direct Deposit feature provides you with the functionality to either directly deposit the employee’s entire net pay to one or more bank accounts, or to deposit only a portion of the employee’s net pay to one or more bank accounts.

You can set up direct deposit for your employees in one of the following ways:

Deposit an Employee's Entire Paycheck to a Single Account

Deposit an Employee's Entire Paycheck to Multiple Accounts

Deposit a Portion of an Employee's Paycheck to a Single Account

Deposit a Portion of an Employee's Paycheck to Multiple Accounts


Direct Deposit Processing Setup Checklist
Employee Payroll Direct Deposit Processing Setup Checklist

Print out this page and use it when processing Payroll Direct Deposit for your employees.

Completed?	Step
_________	Determine if bonuses and adjustments should be directly deposited. This flag is located in Payroll Setup Maintenance.
_________	Specify the following information for each employee on the Direct Deposit form in Employee Table Maintenance:
	__________	Bank ID. An eight-character identification number for this bank.
	__________	Account Number. Account to which amount is deposited.
	__________	Account Type. Checking or Savings account.
	__________	Status. The employee’s direct deposit status, Add, Wait, or Active.
	__________	Payroll Method. The method, amount or percentage, used to calculate the direct deposit amount
	__________	Payroll Amount/Percent. The amount or percent of the total check being deposited to this account.
	For a detailed description of all the fields listed above, see the context-sensitive help for the Employee Direct Deposit Table Maintenance form. Note that you can specify payroll direct deposit and expense payment direct deposit information for a single account on the same line on the Employee Direct Deposit Table Maintenance form. However, the Employee Reimbursement Method and Employee Reimbursement Amount/Percent fields do not have to be completed if you plan to process only payroll direct deposits.


Directly Depositing an Employee's Entire Paycheck to a Single Account

To directly deposit an employee’s entire paycheck to a single account:

1.	Select Tables, Employees from the Deltek Advantage main menu. Deltek Advantage displays the Employee Table Maintenance form.

2.	Click on the Direct Deposit button on the Payroll tab of Employee Table Maintenance. Deltek Advantage displays the Employee Direct Deposit Table Maintenance form.

3.	Complete the following fields on the Employee Direct Deposit Table Maintenance form, referring to the context-sensitive help as needed.

Bank ID

Account Number

Account Type

Status

4.	Leave the Payroll Method and Payroll Amount/Percent fields blank. This tells Deltek Advantage to deposit the employee’s entire net pay to the account specified.

5.	Click on the Close button to return to the Payroll form.

6.	Click on the Save button to save your changes.

7.	Click on the Close button to exit Employee Table Maintenance and return to the Deltek Advantage main menu.

Example

 Note


Direct Deposit Setup Example

The following is an example of the setup for depositing an employee’s entire paycheck to a single account.


Directly Depositing an Employee's Entire Paycheck to Multiple Accounts

To directly deposit an employee’s entire paycheck to multiple accounts:

1.	Select Tables, Employees from the Deltek Advantage main menu. Deltek Advantage displays the Employee Table Maintenance form.

2.	Click on the Direct Deposit button on the Payroll tab of Employee Table Maintenance. Deltek Advantage displays the Employee Direct Deposit Table Maintenance form.

3.	Complete the following fields on the Employee Direct Deposit Table Maintenance form, referring to the context-sensitive help as needed.

Bank ID	Status

Account Number 	Payroll Method

Account Type	Payroll Amount/Percent

4.	Enter the information for each bank account on a separate line.

Note that, when depositing an employee’s entire net pay to multiple accounts, the total amount or percentage you enter on the form must equal the total amount or 100% of the employee’s paycheck.

5.	Click on the Close button to return to the Payroll form.

6.	Click on the Save button to save your changes.

7.	Click on the Close button to exit Employee Table Maintenance and return to the Deltek Advantage main menu.

Example

 Note


Direct Deposit Setup Example

The following is an example of the setup for depositing an employee’s entire paycheck to multiple accounts.


Directly Depositing a Portion of an Employee's Paycheck to a Single Account

To directly deposit a portion of the employee’s paycheck to a single account:

1.	Select Tables, Employees from the Deltek Advantage main menu. Deltek Advantage displays the Employee Table Maintenance form.

2.	Click on the Direct Deposit button on the Payroll tab of Employee Table Maintenance. Deltek Advantage displays the Employee Direct Deposit Table Maintenance form.

3.	Complete the following fields on the Employee Direct Deposit Table Maintenance form, referring to the context-sensitive help as needed.

Bank ID	Status

Account Number 	Payroll Method

Account Type	Payroll Amount/Percent

Note that, when depositing a portion of an employee’s net pay to a single account, the total amount or percentage you enter on the form does not have to equal the total amount or 100% of the employee’s paycheck. The balance will be paid to the employee via check.

4.	Click on the Close button to return to the Payroll form.

5.	Click on the Save button to save your changes.

6.	Click on the Close button to exit Employee Table Maintenance and return to the Deltek Advantage main menu.

Example

 Note


Direct Deposit Setup Example

The following is an example of the setup for depositing a portion of an employee’s paycheck to a single account.


Directly Depositing a Portion of an Employee's Paycheck to Multiple Accounts

To directly deposit a portion of the employee’s paycheck to multiple accounts:

1.	Select Tables, Employees from the Deltek Advantage main menu. Deltek Advantage displays the Employee Table Maintenance form.

2.	Click on the Direct Deposit button on the Payroll tab of Employee Table Maintenance. Deltek Advantage displays the Employee Direct Deposit Table Maintenance form.

3.	Complete the following fields on the Employee Direct Deposit Table Maintenance form, referring to the context-sensitive help as needed.

Bank ID	Status

Account Number 	Payroll Method

Account Type	Payroll Amount/Percent

4.	Enter the information for each bank account on a separate line.

Not that, when depositing a portion of an employee’s net pay to multiple accounts, the total amount or percentage entered on the form does not have to equal the total amount or 100% of the employee’s paycheck. The balance will be paid to the employee via check.

5.	Click on the Close button to return to the Payroll form.

6.	Click on the Save button to save your changes.

7.	Click on the Close button to exit Employee Table Maintenance and return to the Deltek Advantage main menu.

Example

 Note


Direct Deposit Setup Example

The following is an example of the setup for depositing a portion of an employee’s paycheck to multiple accounts.


Overview of Payroll Processing

After you finish posting and reviewing all employee timesheets for the current pay period, you can process employee checks automatically or manually. When you process employee checks, Deltek Advantage creates a check for the employee and recognizes the time posted for the period as being paid. From the Payroll Processing form, you can:

Select to process payroll automatically or manually.

Review and modify employees prior to processing checks.

Initiate a draft run to produce a Draft Payroll Journal.

Process checks.

Cancel the payroll run.

Deltek Advantage uses the hours from the employee’s timesheet. When you post timesheets, Deltek Advantage makes this information available to the Payroll module. Timesheet information is processed for both hourly and salaried employees.

For this reason, you should enter and post any outstanding timesheets if you plan to use timesheet hours to process payroll. In addition, prior to performing payroll processing, ensure the following:

•	Your initializations (accounting period, fiscal year, quarter, and W-2 year) are up-to-date.

•	Your database information is up-to-date (that is, all employees exist in Employee Table Maintenance, you have made any pay rate or withholding changes, etc.).

•	You make a database backup.

If timesheets have been posted for all employees, you can process payroll using Automatic or Manual Select processing. If you do not have timesheets for all of your employees, you can still process payroll for those employees.

 Note

 Related Topics


Payroll Processing Checklist

Prior to processing payroll for your employees, you must perform certain steps to make the data available to be processed. Payroll Processing offers you many options for creating checks for your employees.

Payroll Processing Checklist

The following checklist describes the process you will perform to process Payroll for your employees. Print this page and check off each item as you complete it.

Completed?	Step	Where Entered
_________	Choose a selection type: Automatic or Manual Select	Initial Payroll Processing form
_________	Review employees for the session	Employee Review
_________	Select/Deselect employees for processing	Employee Review
_________	Modify an employee's hours, if desired	Employee Review
_________	Specify other pay amounts for the employee, if desired	Employee Review
________	Override withholdings for the employee, if desired	Employee Review
_________	View detail for the employee, if desired	Employee Review
_________	Run Draft Payroll, make changes if necessary	Initial Payroll Processing form
_________	Process Checks	Initial Payroll Processing form
_________	Post Payroll	Payroll Check Printing
_________	Post to record other Payroll-related disbursements	Cash Disbursements Data Entry
_________	Process Payroll Direct Deposit	Direct Deposit Processing


Processing Payroll for Employees Without Timesheets

If you do not have a timesheet for an employee, you can still process payroll for that employee.

To process payroll for an employee with no timesheet:

1.	Post the timesheets for the employees that you have.

2.	For each employee who did not enter a timesheet, estimate the number of hours that the employee worked.

3.	Click the Review Employees button from the Payroll Processing form. Deltek Advantage displays the Employee Payroll Lookup form.

4.	Select an employee from the list and click OK. Deltek Advantage displays the Employee Review form for the selected employee.

5.	Review the information as usual. When you come to an employee who has no timesheet information, enter the estimated number of hours for that employee in the Pay Hours field.

6.	When the employee actually enters a timesheet, check to see if the estimated hours were accurate. If not, you can use the Adjustments feature to correct the stored Payroll information and adjust the employee’s pay basis hours, withholdings, and pay as necessary.

7.	Make adjustments to the pay basis hours for the next regular payroll run to exclude the actual posted hours from processing.


Performing Payroll Functions in Prior Accounting Periods

Sometimes, it may be necessary for you to run reports, review W-2 data, or reprint posting logs for a payroll processing run for a prior accounting period. If you need to perform any of these functions, you can enter a prior accounting period. By doing this, you are reporting on data that was applicable during that period. If you reprint a posting log in a prior period, for example, the quarter-to-date and year-to-date amounts reflect the current data as of that run for that period.

To produce reports for data in a previous period, select the period in which to process. You can do this by selecting the prior period when entering Deltek Advantage or by selecting the Change Periods option from the Utilities menu. You then select the type of reporting to perform and proceed as usual.

 Note


Canceling a Payroll Processing Run

You can cancel a payroll processing run at any time by clicking the Cancel Run button from the initial Payroll Processing form or from the Payroll Check Printing and Numbering form.

When you click this button, the following dialog box appears:

Click on the Yes button to cancel the run and return all data to the way it appeared prior to any modifications made using Employee Review in Payroll Processing. If you cancel the run, Deltek Advantage exits from Payroll Processing and returns you to the Deltek Advantage main menu. No database changes are made if you cancel the run.

If you do not want to cancel the run, click on the No button. Deltek Advantage returns to Payroll Processing where you can continue as normal.

 Notes


Regular Payroll Processing Overview

Use the regular payroll feature to process a normal payroll run for your employees. You can process a regular payroll run for one or more selected employees, or all the employees in your firm.

After you finish entering and posting all outstanding timesheets and/or labor adjustments, you can process payroll automatically or manually. When you process checks, Deltek Advantage creates a check for each employee included in the run and recognizes the employee as being paid. From the Payroll Processing form, you can:

Choose a selection type for the regular payroll processing session: automatic or manual select.

Review your employees using Employee Review prior to processing payroll.

Run a draft payroll to check the information prior to processing.

Process checks for the employees included in the processing run.

Cancel this payroll processing run.

 Notes

 Related Topics


Running a Regular Payroll

When running a regular payroll, you must select the employees (and enter the amounts) to include in the processing run. The following steps outline this procedure.

To run a regular payroll:

1.	Select Processing, Payroll, Payroll Processing from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Processing form.

2.	Select Automatic (to select all active employees) or Manual Select as the Selection Type and Regular as the Run Type on the Payroll Processing form.

3.	Enter a check date, payroll date, sort selections, and profit center selections in the appropriate fields on the Payroll Processing form.

4.	Click on the Review Employees button. Deltek Advantage displays the Employee Payroll Lookup form.

5.	Select an employee from the list and click OK. Deltek Advantage displays the Employee Review form for the selected employee.

Automatic Payroll Processing

If you are performing an automatic payroll run, Deltek Advantage automatically enables the regular, overtime, and secondary overtime pay hours, other pay, and withholding fields on the Employee Review form for the selected employee. You may enter override information in any/all of these fields. If an override is specified, it appears on the Payroll Journal with an asterisk (*) next to the override amount.

Manual Select Payroll Processing

If you are performing a manual select payroll run, you must click on the Select button on the Employee Review form to enable regular, overtime, and secondary overtime pay hours, other pay, and withholding fields on the form for the selected employee. Clicking on the Select button also automatically includes the selected employee in the manual select payroll run. You must manually select each employee you want to include in this regular payroll run.

To review/select an additional employee, click on the Employee button and select an employee from the Employee Payroll Lookup list. Or, use the arrow buttons on either side of the Employee button to scroll to another employee record.

You may review employees, make any necessary changes, and perform Draft Payroll runs multiple times (and over multiple sessions) prior to processing checks.

6.	Click on the Close button after you finish modifying employee information and/or selecting the employees to include in this regular payroll run.

7.	Click on the Draft Run button. Deltek Advantage produces a Draft Payroll Journal for this regular payroll run including the information that will be processed during this run.

8.	Review the Draft Payroll Journal for the regular run and modify any necessary information.

9.	Process checks as normal.

10.	Process payroll direct deposit, if applicable.

 Related Topics


Accruing Benefit Hours Automatically

You have the option of accruing employee benefit hours automatically each time you process a regular payroll.

Deltek Advantage will calculate the number of benefit accrual hours each pay period by dividing the annual number of benefit accrual hours by the number of pay periods in the year. For example, if an employee earns 120 hours of vacation per year and you process payroll twice a month, Deltek Advantage will divide the 120 hours by the 24 pay periods, and accrue 5 hours each pay period.

To use this feature:

1.	Display the Timesheets tab of General System Setup.

2.	Select the Accrue benefit hours when payroll is processed field.


Payroll Adjustments Processing Overview

The Payroll Adjustment feature enables you to make changes to a payroll that has already been processed. You can use this feature to adjust pay, withholdings, regular, overtime, and secondary overtime pay hours, and accrued benefit hours.

This feature is useful to:

•	Correct your payroll database after overpaying or underpaying an employee, and then generate an adjustment check.

•	Enter payroll-based information that you have processed manually, apart from the Payroll application.

The Adjustments feature allows you to calculate and post payroll information at any time without processing an entire payroll.

Paycheck Adjustments

If you are making a positive adjustment to a payroll record for which a check has already been printed and processed, refer to the original printed paycheck and process an adjustment check for the additional amount, using the Payroll Adjustment feature in Payroll Processing. The Payroll module posts the applicable changes.

If you are making a negative adjustment to a payroll record for which a check has been printed and processed, refer to the original printed paycheck and enter an adjustment to offset the overpayment amount, using the Payroll Adjustment feature in Payroll Processing. The Payroll module posts the applicable changes. However, you may have to record a receipt for the amount of the overpayment.

Voiding a Payroll Check

If you need to void a payroll check, use the Void Check Processing feature. When you void a payroll check, Deltek Advantage posts a voided check amount to the general ledger and reverses the effect of the original check posting. Voiding a payroll check also reverses any withholdings, sick time, and accrued vacation time associated with the original check.

Entering a Withholding

If you want any amounts withheld from the amount of the gross adjustment, you must enter the withholding data. Specify the withholding adjustment as a fixed amount.

If you want to make an adjustment to a withholding but you do not want to modify gross pay, enter zero for gross pay. You can then enter the withholding amount.

 Related Topics


Running a Payroll Adjustment

When running a payroll adjustment, you must select the employees (and enter the appropriate amounts) to include in the processing run. The following steps outline this procedure.

To run a payroll adjustment:

1.	Select Processing, Payroll, Payroll Processing from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Processing form.

2.	Select Adjustments as the run type on the Payroll Processing form. When you select Adjustments as the run type, Deltek Advantage automatically changes the Selection Type from Automatic to Manual Select. You can only run a payroll adjustment for manually selected employees.

3.	Enter a check date, payroll date, sort selections, and profit center selections in the appropriate fields on the Payroll Processing form.

4.	Click on the Review Employees button. Deltek Advantage displays the Employee Payroll Lookup form.

5.	Select an employee from the list and click OK. Deltek Advantage displays the Employee Review form for the selected employee.

6.	Click on the Select button on the Employee Review form to enable regular, overtime, and secondary overtime pay hours, other pay, and withholding fields on the form for the selected employee. Clicking on the Select button also automatically includes the selected employee in the manual select payroll run. You must manually select each employee you want to include in this payroll adjustment run.

7.	Enter the number of pay hours, gross pay amount, other pay amount, benefit hours, or withholding information to adjust.

8.	To review/select an additional employee, click on the Employee button and select an employee from the Employee Payroll Lookup list. Or, use the arrow buttons on either side of the Employee button to scroll to another employee record.

9.	Click on the Close button after you finish selecting the employees to include in this payroll adjustment run.

10.	Click on the Draft Run button. Deltek Advantage produces a Draft Payroll Journal for this payroll adjustment run including the information that will be processed during this run.

11.	Review the Draft Payroll Journal for the adjustment run and modify any necessary information.

12.	Process checks as normal.

13.	Process payroll direct deposit, if applicable.


Bonus Payroll Processing Overview

Use the Bonus Payroll feature to automate the process of giving your employees bonuses. This feature allows you to process a payroll for which:

•	You enter the gross pay for each employee (Regular and/or Other).

•	No timesheet hours are required.

•	State and local tax withholdings are calculated according to an effective rate.

When running a bonus payroll, you should review all withholding calculations. Some withholdings, such as health insurance premiums, would not be taken on a bonus payroll. In addition, tax withholdings are not based on the tax tables since they presume a timeframe for the calculations; a bonus payroll takes place outside of any payroll period. For these reasons, Deltek Advantage does the following:

•	Calculates the federal tax withholding as the current percentage recommended for supplemental wage payments. (Refer to Circular E: Employer’s Tax Guide, Government Publication 15.)

•	Calculates state and local tax withholdings using an effective rate, which is equal to the Year-to-date Amount of State or Local Withholding divided by the Year-to-date Amount of Gross Pay Subject to the State or Local Tax Withholding.

For example, if an employee has year-to-date gross wages of $5,000, which are subject to a state income tax withholding of $500 year-to-date, the effective rate is 500/5,000 or 10%. Ten percent is applied to the gross bonus pay amount to calculate state income tax withholding for the bonus amount.

All other withholdings are calculated as normal.

You can override any withholding amount automatically calculated, whether or not it defaults to zero. In Payroll Withholding Code Table Maintenance, you determine which withholdings need to be taken on bonus payrolls (at the Default withholding amount to zero for bonus payroll field). If this option is selected for a withholding, the withholding will appear for the employee with an amount of zero. If this option is not selected for a withholding, Deltek Advantage calculates the withholding as usual for the employee (as defined in Employee Payroll Withholding Table Maintenance).

 Related Topics


General Ledger Posting for Bonus Payrolls

The transactions involved in a bonus payroll must be made in the same way as those for a normal payroll. However, no labor distribution takes place because no timesheet hours are posted, and certain withholding accounts receive larger or smaller amounts than they normally would.

You may want to record the cost of bonuses in a dedicated account other than the Job Cost Variance account. To do this, specify the desired account at the Bonus Cost Account in Payroll Setup Maintenance and then enter the bonus amount as Gross Pay for each employee.

Or you may want to record the cost of bonuses as Other Pay and have it tracked in that way for each employee. To do this, specify the desired account at the Other Pay Cost Account in Payroll Setup Maintenance, and then enter the bonus amount as Other Pay for each employee.

 Related Topics


Running a Bonus Payroll

When running a bonus payroll, you must select the employees (and enter the appropriate amounts) to include in the processing run. The following steps outline this procedure.

To run a bonus payroll:

1.	Select Processing, Payroll, Payroll Processing from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Processing form.

2.	Select Bonus as the Run Type on the Payroll Processing form. When you select Bonus as the run type, Deltek Advantage automatically changes the Selection Type from Automatic to Manual Select. You can only run a bonus payroll for manually selected employees.

3.	Enter a check date, payroll date, sort selections, and profit center selections in the appropriate fields on the Payroll Processing form.

4.	Click on the Review Employees button. Deltek Advantage displays the Employee Payroll Lookup form.

5.	Select an employee from the list and click OK. Deltek Advantage displays the Employee Review form for the selected employee.

6.	Click on the Select button on the Employee Review form to enable gross pay, other pay, and withholding fields on the form for the selected employee. Clicking on the Select button also automatically includes the selected employee in the bonus payroll run. You must manually select each employee you want to include in this bonus payroll run.

7.	Enter the bonus amount in either the Gross Pay and/or Other Pay field for the selected employee.

If you enter the bonus amount in the Gross Pay field, Deltek Advantage posts the amount to the account specified at the Bonus Cost Account field in Payroll Setup Maintenance. When you do this, Deltek Advantage categorizes the pay as ‘bonus pay’ for the employee.

If you enter the bonus amount in the Other Pay field, Deltek Advantage posts the amount to the account specified at the Other Pay Cost Account field in Payroll Setup Maintenance. When you do this, Deltek Advantage categorizes the pay as ‘other pay’ for the employee.

You can specify a portion of the bonus as Gross Pay and the rest of the bonus as Other Pay.

8.	Review and/or modify the employee’s withholding information. Only withholdings set up to be applied during bonus payrolls have associated amounts. This information is determined through Payroll Withholding Code Table Maintenance.

9.	To review/select an additional employee, click on the Employee button and select an employee from the Employee Payroll Lookup list. Or, use the arrow buttons on either side of the Employee button to scroll to another employee record.

10.	Click on the Close button after you finish selecting the employees to include in this bonus payroll run.

11.	Click on the Draft Run button. Deltek Advantage produces a Draft Payroll Journal for this bonus payroll run including the information that will be processed during this run.

12.	Review the Draft Payroll Journal for the bonus run and modify any necessary information.

13.	Process checks as normal.

14.	Process payroll direct deposit, if applicable.

 Related Topics


Choosing a Selection Type: Automatic vs. Manual Select

Deltek Advantage enables you to process payroll either automatically or manually:

•	Automatic Payroll Processing allows you to process all salaried employees and all hourly employees with hours posted during the current payroll period. You can only run an automatic payroll for a Regular processing run. Although information in an automatic run is automatically selected, you have complete control over what is ultimately processed with this option.

•	Manual Select Payroll Processing allows you to select the employees you want to process during this payroll processing run. You can run a manual payroll for a Regular, Adjustment, or Bonus processing run.

 Notes

 Related Topics


Entering Selection Criteria for an Automatic Payroll Processing Run

If you want to limit the employees to include in this processing run, you can enter selection criteria based on profit center and/or any employee select code value.

To set up auto selection criteria for an automatic payment processing run:

1.	Open Payroll Processing. Select Processing, Payroll, Payroll Processing from the main menu. If an active payroll processing run is in process, Deltek Advantage displays the Select Posting Run form and you must select the existing run. If not, Deltek Advantage displays the Payroll Processing form.

2.	Ensure that the Automatic option is selected on the main Payroll Processing form. (This is the default option. Deltek Advantage will automatically open a new run with this option selected).

3.	Determine the type of selection criteria that employees will need to meet in order to be included in this Payroll Processing run. Your options are:

Profit Center

Employee Select Codes

4.	Proceed with the Payroll Processing session as desired.

 Notes


Sorting the Checks Generated in this Processing Session

Whether you choose automatic or manual employee payroll processing, you have the ability to sort the checks generated during the session. You can specify up to three sorts for checks processed in this session. Deltek Advantage saves your sort selections for the run across sessions.

Some common sort options include the following:

•	Employee Number (default). Deltek Advantage sorts all checks processed during this session in numerical order by the employee’s number.

•	Employee Name. Deltek Advantage sorts all checks processed during this session alphabetically by the employee’s last name.

•	Employee Status. Deltek Advantage sorts all checks by employee status: Active, Inactive, and then Terminated.

•	Profit Center. Deltek Advantage sorts all checks processed during this session by profit center code.

•	Profit Center Levels. Deltek Advantage sorts all checks processed during this session by profit center level.

•	Employee Sort/Select Codes. Deltek Advantage sorts all checks processed during this session by the specified sort/select code.


Reviewing Employees for a Payroll Processing Session

By default, automatic processing selects all employees to be included in the session. Manual processing does not select any employees; you must select the employees to include.

After you select the type of processing you want to perform (automatic or manual), you can review or select the employees for whom you want to process checks.

To review or select employees for whom you want to process checks:

1.	From the Payroll Processing form, click on the Review Employees button. Deltek Advantage displays the Employee Payroll Lookup form.

2.	Select an employee from the list and click OK. Deltek Advantage displays the Employee Review form. This form displays all current payroll information for each employee (pay hours, gross pay, other pay, withholdings, and net pay).

Automatic Payroll Processing

If you are performing an automatic payroll run, Deltek Advantage automatically enables the regular, overtime, and secondary overtime pay hours, other pay, and withholding fields on the Employee Review form for the selected employee. You may enter override information in any/all of these fields. If an override is specified, it appears on the Payroll Journal with an asterisk (*) next to the override amount.

Manual Select Payroll Processing

If you are performing a manual select payroll run, you must click on the Select button on the Employee Review form to enable regular, overtime, and secondary overtime pay hours, other pay, and withholding fields on the form for the selected employee. Clicking on the Select button also automatically includes the selected employee in the manual select payroll run. You must manually select each employee you want to include in this regular payroll run.

3.	Perform any changes to the employee’s setup information. From the Employee Review form you can perform the following functions:

Modify an employee's regular and overtime pay basis hours.

Specify other pay amounts for the current pay period

Override automatically calculated withholding amounts for the current pay period.

View the hours and pay, withholdings, benefit hours, and direct deposit detail for each employee.

Select and/or deselect an employee for processing (manual select only).

To review/select an additional employee, click on the Employee button and select an employee from the Employee Payroll Lookup list. Or, use the arrow buttons on either side of the Employee button to scroll to another employee record.

4.	Click on the Close button to return to the Payroll Processing form.

 Note

 Related Topics


Selecting/Deselecting an Employee for Processing

This topic only applies to Manual Select Payroll Processing:

When you are reviewing employees in a Manual Select Payroll Processing session you must manually select/deselect employees for the current processing run.

To select/deselect employees:

1.	Click on the Review Employees button on the Payroll Processing form. Deltek Advantage displays the Employee Payroll Lookup list.

2.	Select the employee to process and click OK. Deltek Advantage opens the Employee Review form displaying the selected employee’s information.

3.	Click on the Select button on the Employee Review form for the desired employee. When you do this, Deltek Advantage enables fields on the form according to the processing run type specified.

Processing Run	Fields Enabled
Regular	Deltek Advantage enables the regular and overtime pay hours, other pay, and withholding fields for the selected employee. If you use the secondary overtime feature, Deltek Advantage also enables the secondary overtime pay hours field.
Bonus	Deltek Advantage enables the gross pay, other pay, and withholding fields for the selected employee.
Adjustments	Deltek Advantage enables the regular and overtime pay hours, other pay, and withholding fields for the selected employee. If you use the secondary overtime feature, Deltek Advantage also enables the secondary overtime pay hours field. Deltek Advantage also displays a list of the benefit plans set up in your database, so that you can adjust benefit hours.
4.	To select an additional employee, click on the Employee button and select an employee from the Employee Payroll Lookup list. Or, use the arrow buttons on either side of the Employee button to scroll to another employee record.

5.	After you have selected all the employees to include in this run, click on the Close button to return to the Payroll Processing form.

You must select all employees to include in the payroll run. If you do not ‘manually’ select an employee, that employee will not appear in the payroll run. You should always generate the Draft Payroll Journal prior to processing to ensure all desired employees are included in this run.

 Note

 Tip

 Related Topics


Modifying an Employee's Regular and Overtime Pay Basis Hours

During Manual Select or Automatic Payroll Processing, you can use the Employee Review form to modify an employee’s regular and/or overtime pay hours.

The Payroll application tracks timesheet hours entered for each employee since the last time payroll was processed. The timesheet hours appear on this form for your review.

To enter/modify regular or overtime pay basis hours for an employee, enter the desired number of hours in the appropriate Pay Hours field (regular, overtime, and/or secondary overtime). Repeat this step for each employee whose regular or overtime pay basis hours you want to modify.

•	When you enter hours for hourly employees, Deltek Advantage calculates a new gross pay figure based on the pay rate entered on the Payroll tab of Employee Table Maintenance. It then calculates the proper withholding amounts for the employee, based on the withholdings defined for the employee in Employee Payroll Withholding Table Maintenance.

•	When you enter hours for salaried employees, the net pay figure does not change unless the salaried employee has overtime hours and an overtime rate greater than zero.

 Notes


Specifying Other Pay Amounts for the Current Pay Period

The Other Pay field is a user-defined, one-time, pay amount that is added to the gross and net pay amounts for your employees.

You can enter another (or additional) pay amount for the employee for the current processing session (during Manual Select or Automatic Payroll Processing) through the Employee Review routine. Other pay figures are tracked in a separate category and are represented separately on reports.

When you enter an other pay figure for employees (hourly or salaried), Deltek Advantage adds this figure to the employee’s base pay (Regular/Salary + Overtime + Secondary Overtime) and adjusts the withholdings accordingly.

To enter an additional pay amount for an employee:

Enter the desired amount in the Other Pay field. When you do this, Deltek Advantage automatically checks the Override box next to the Other Pay field. If you decide you do not want to enter/modify this amount, click on this box. This action ‘undoes’ the override and returns the field to the original default amount.

Note that the override check box does not appear for Bonus or Adjustment runs since there is no automatic ‘other’ pay for these run types. That is, there is no distinction between default and override other pay amounts.

 Notes

 Related Topics


Overriding Withholding Amounts for the Current Pay Period

Deltek Advantage calculates each withholding according to the employee’s withholding setup and/or any system tax tables on file.

To override a withholding amount through Employee Review:

You can override automatically calculated withholding amounts for the employee for the current processing run through the Employee Review routine.

You can override any or all of the withholding amounts for selected employees.

•	In a Manual Select Payroll Processing run, you must first click on the Select button to select the employee for processing. Then, enter the desired amount in the Current field for the withholding to override. Deltek Advantage automatically selects the Override box to the right of the Current field for the withholding. If you decide later that you do not want to enter/modify this amount, click on this box again. Deltek Advantage displays the previous amount in this field.

•	In an Automatic Payroll Processing run, enter the desired amount in the Current field for the withholding to override. Deltek Advantage automatically selects the Override box to the right of the Current field for the withholding. If you decide later that you do not want to enter/modify this amount, click on this box again. Deltek Advantage displays the previous amount in this field.

You can suppress individual withholdings for an employee by clicking on the Withholdings button from the Payroll tab of Employee Table Maintenance. Then, during payroll processing, this withholding is disabled. When you disable a withholding, Deltek Advantage stops tracking the associated pay basis. If you want to withhold a zero amount, you should explicitly override the withholding with a zero amount. If you suppress a withholding in Employee Table Maintenance, the Suppressed box is checked in Employee Review.

To suppress a withholding through Employee Payroll Table Maintenance:

1.	Select Tables, Employees from the Deltek Advantage main menu.

2.	Click the Payroll tab. Deltek Advantage brings you to the Employee Payroll Table Maintenance form.

3.	Click on the Lookup button and select the employee whose withholding amounts you want to suppress.

4.	Click on the Withholdings button from the employee whose withholding amounts you want to modify. Deltek Advantage displays the Employee Payroll Withholding Table Maintenance form.

5.	Click on the Suppress box for the withholding to suppress.

6.	Click on the Close button to return to Employee Payroll Maintenance.

7.	Repeat steps 3 through 6 to suppress withholdings for additional employees.

 Notes


Viewing Detail for the Employee

From the Payroll Processing, Employee Review form, you can view details regarding the results of the hours/pay, withholdings, benefit hours, or direct deposit information that will be processed for the current employee. You cannot modify the information in these routines. However, you can use these routines to verify that the information to process is correct and will yield the expected totals.

From the Employee Review form, you can view:

Hours and pay detail for the employee.

Withholding detail for the employee.

Benefit hours detail for the employee.

Direct deposit detail for the employee.


Viewing Hours and Pay Details for the Employee
Viewing Hours and Pay Detail for the Employee

Prior to processing payroll, you can review an employee’s current, quarter-to-date, and year-to-date hours and pay. These totals reflect the results you will receive if this run is processed.

To view hours and pay for your employees prior to processing payroll:

From Employee Review, click on the Hours and Pay button. Deltek Advantage displays a window listing the employee’s current, quarter-to-date, and year-to-date hours (regular, overtime, and secondary overtime) and pay (regular, overtime, secondary overtime, and other).

 Note

 Related Topics


Viewing Withholding Details for the Employee

Prior to processing payroll, you can review an employee’s current, quarter-to-date, and year-to-date withholdings. This routine also provides you with any limit(s) set up for this withholding. These totals reflect the results you will receive if this run is processed.

To view withholding information for your employees prior to processing payroll:

From Employee Review, click on the Withholdings button. Deltek Advantage displays a window listing the current, quarter-to-date, and year-to-date amounts for the employee’s withholdings. Deltek Advantage also displays the method, amount/percent, and/or limit for this withholding.

 Note

 Related Topics


Viewing Benefit Hours Detail for the Employee

Prior to processing payroll, you can review an employee’s earned/taken balances for benefit hours. These totals reflect the results you will receive if this run is processed.

To view benefit details for your employees prior to processing payroll:

From Employee Review, click on the Benefit Hours button. Deltek Advantage displays a window listing the Earned, Taken, YTD Earned, YTD Taken, and Balance amounts for each of the employee’s accrual codes.

 Note


Viewing the Employee's Direct Deposit Details

Prior to processing payroll, you can review an employee’s direct deposit details. These totals reflect the results you will receive if this run is processed.

To view direct deposit information for your employees prior to processing payroll:

From Employee Review, click on the Direct Deposit button. Deltek Advantage displays a window listing the Bank Id, account number, account type, method (and amount/percent if applicable), amount to be allocated for the current run, and direct deposit status for the employee.

 Note

 Related Topics


Running Draft Payroll

Before you process the selected payroll session, you should review all the employees to be processed by running a Draft Payroll. To run a Draft Payroll Journal, click on the Draft Run button from the main Payroll Processing form.

The Draft Payroll Journal consists of the same information as the Payroll Journal. However, by running this report prior to processing checks and posting payroll, you can verify the postings to be made by the payroll run and make any necessary modifications prior to processing the payroll.

You can run the Draft Payroll Journal for regular, bonus, and adjustment payroll processing runs. After you run this report and verify the information, you can process checks.


Processing Checks

To print and post the payroll checks, click on the Process Checks button on the Payroll Processing form. Deltek Advantage brings you to the Payroll Check Printing and Numbering Form.

To process checks:

Print the Checks

Assign Check Numbers

Post Payroll

 Notes


Printing Checks

In print preview mode, Deltek Advantage creates a check file of the data that prints on the check. When you actually print this file, Deltek Advantage produces a check for all of the employees included in the run.

To print the checks:

1.	Select the bank for which to print checks.

2.	Ensure that the correct check stock is loaded in the printer.

3.	Click the Print button. Deltek Advantage displays the checks included in the bank file in print preview mode. This allows you to review checks prior to printing them, or print a range of employee checks.

4.	While the print preview version of the checks is on your screen, select Print from the File menu. Deltek Advantage prints all the checks. After you print the check file, Yes appears in the Printed column.

 Notes


Assigning Check Numbers

Deltek Advantage does not retain an internal check reference number. To update the program with the actual check number, you must assign the check number.

After successfully printing checks, you can assign the numbers to the printed checks. This number should match the pre-printed, micro-encoded number on each check. This number is stored with the posted check for tracking and inventory purposes. You can assign check numbers for the remaining checks or for a single check.

 Notes

 Related Topics


Assigning Check Numbers for Remaining Checks

If the check numbers for all checks printed are in sequential order (for example, 5320 through 5330), you may assign the check numbers.

To assign check numbers:

1.	Click the Assign Numbers Button.

2.	Select the Remaining checks option.

3.	Enter the starting check number in the Check number field.

4.	The first check is automatically selected. If you do not want to start numbering with this check, click on the first check in the series at the bottom of the form.

5.	Click the Assign button.

 Notes


Assigning a Check Number for a Single Check

If the printer jams during check printing or any other type of printing problem occurs, you may need to reprint a check. For this reason, you may also need to assign the check number for that check individually.

To assign a check number for a single check:

1.	Click the Assign Numbers button.

2.	Select the Single check option.

3.	Click on the specific check in the list.

4.	Enter the number of the newly printed check in the Check number field.

5.	Click the Assign button.


Posting Payroll

Deltek Advantage does not recognize a processed payroll run until it is posted.

When you post payroll, Deltek Advantage recognizes the payroll expense, the employer’s FICA expense, and the withholding amounts from the paychecks.

The payroll posting, by default, debits the Job Cost Variance account and Employer’s FICA account and credits the Salaries Payable account as well as a series of withholding liability accounts. For example, assume the following postings:

Account	Debit	Credit
Labor Credit Account (Job Cost Variance)	$10,000.00
Employer’s FICA Expense	600.00
Salaries Payable or Checking Account		$7,600.00
Federal Withholding		700.00
FICA Payable		1,200.00
State Withholding		600.00
Health Care Insurance Withholding		500.00
Totals	$10,600.00	$10,600.00

After Deltek Advantage posts the labor distribution credit and Job Cost Variance debit, the Job Cost Variance account contains a balance. This balance is the difference between the labor expense that was costed to projects and the amount actually paid to employees.

 Notes

 Related Topics


Posting to Record Other Payroll-Related Disbursements

With each payroll run, you accumulate withheld amounts in liability accounts. When you write a check to pay for federal taxes, FICA, health insurance, etc., you should record the disbursement through Cash Disbursements Data Entry. The cash disbursement should debit the liability account and credit the checking account.

 Note


Effect of Posting Payroll on the General Ledger

When you post payroll, Deltek Advantage performs postings to your general ledger. These postings are used to post the gross payroll cost, employer FICA expense, net payroll disbursement (or liability), and withholding liabilities.

Labor Distribution Postings (user-defined)

Paycheck Records Postings (user-defined)

Distribution of Withholding Amounts Postings (user-defined)

Deltek Advantage includes all automatic postings to the general ledger in the General Ledger Account Analysis. This report lists all transactions and opening and closing balances for each account. Payroll related entries are represented on this report by a PY in the transaction type column of the report.


Labor Distribution Postings

When you post a set of timesheets, Deltek Advantage distributes the labor on the timesheets across the direct and indirect labor accounts set up in Employee Types Setup Maintenance. During this process, Deltek Advantage performs a series of debits and credits to your expense accounts and Job Cost Variance account. For example, assume the following debits and credits.

Account	Debit	Credit
Direct Labor - Principals	$2,000.00
Direct Labor - Employees	6,000.00
Indirect Labor - Principals	1,000.00
Indirect Labor - Employees	3,750.00
Vacation, Sick, and other indirect expense accounts	1,250.00
Labor Credit Account (Job Cost Variance)		$14,000.00
Totals	$14,000.00	$14,000.00

The above example details a possible labor distribution. Note that the credit to the Labor Credit (Job Cost Variance) account is equal to the sum of the debits to the direct and indirect expense accounts.


Paycheck Records Postings

You do not need to create a cash disbursement for net payroll if you are posting the payroll directly to an asset account and you do not enter a bank code in Payroll Setup Maintenance, or if you are posting the payroll to a liability.

You must record employee paycheck amounts in Deltek Advantage through cash disbursements. This process is manual because firms approach this step differently. For example, some firms draw paychecks from their main checking account; others have a separate account for payroll to ensure confidentiality.

If you use a separate account or if you specify your main Checking account as your Salaries Payable account (in Payroll Setup Maintenance), payroll information does not appear on the Cash Journal.

To record the cash disbursement If you are using a separate checking account:

1.	Process Payroll as normal. That is, review employees, print checks, assign numbers, and post payroll.

2.	From the Payroll Journal (printed when you post payroll), locate the net payroll amount. This amount appears in the Run Totals section at the end of your Payroll Journal.

3.	Write a check, drawn on your main Checking account, for the net payroll amount.

4.	Select Processing, Data Entry, Cash Disbursements from the Deltek Advantage main menu. Deltek Advantage displays the Cash Disbursements form.

5.	Enter your cash disbursement (debit your Salaries Payable account and credit your main Checking account). For more information, see Entering Cash Disbursements.

6.	Post the cash disbursement.

7.	Prepare and distribute the paychecks.

If you are using your main Checking account and that account is specified at the Salaries Payable account in Payroll Setup Maintenance, you do not need to enter a cash disbursement. This is because your main Checking account is automatically credited during posting.


Viewing the Payroll Posting Logs

Deltek Advantage produces two posting logs each time you post payroll. They are:

•	Payroll Processing Posting Log - This summary lists the general ledger accounts that were affected by the posting. The report shows the total amounts debited and credited to each account.

•	Payroll Journal - The employee posting detail, including the rate in effect at the time of posting, benefit hours, direct deposit information, and so on.

 Notes


Payroll Journal

The Payroll Journal provides you with an audit trail for all payroll information processed while posting payroll. The primary purpose of this journal is to provide employee-level detail of the payroll postings and many W-2 quarter-to-date and year-to-date figures as of this run.

The Payroll Journal is similar for regular, adjustment, and bonus runs. However, the Payroll Journal for bonuses does not include information about employees’ hours.

The Payroll Journal is made up of two main sections:

•	Employee Information: Displays employee information by employee number, current hours, quarter-to-date hours, year-to-date hours, gross pay, withholdings, and current period net pay.

•	Run Totals: Displays run totals for hours, gross pay, net pay, withholdings, and direct deposit.

The following list discusses the data shown on the Payroll Journal:

•	Employee Number, Name, and SS number - General employee information from Employee Table Maintenance appears for identification purposes.

•	Rate - The rate at which the employee is paid for regular hours, as well as whether the rate is hourly or salaried (per pay period).

•	Ovt Pct - The percentage applied to the employee’s regular pay rate to arrive at an overtime pay rate. This information is entered in Employee Table Maintenance.

•	Ovt-2 Pct – The percentage applied to the employee’s regular pay rate to arrive at a secondary overtime pay rate. This information is entered in Employee Table Maintenance.

•	Hours - The employee’s regular, overtime, and secondary overtime hours for the current period, quarter-to-date, and year-to-date.

•	Pay - The employee’s current, quarter-to-date, and year-to-date regular, overtime, secondary overtime, and other pay (before withholdings). These amounts are based on the gross pay computation for salaried employees as follows:

Salary per period + [Ovt pct * ((Salary per period * Pay periods in a year)/2080) * Ovt hrs] + [Secondary ovt pct * ((Salary per period * Pay periods in a year)/2080) * Secondary ovt hrs] + Other]

These amounts are based on the gross pay computation for hourly employees as follows:

(Rate per hour * Regular hours) + (Ovt pct * Pay rate * Ovt hours) + (Secondary ovt pct * Pay rate * Secondary ovt hours) + Other

The gross pay amount includes pay from automatic and manual select regular payroll runs, as well as for bonuses and adjustments.

•	Net Pay - The employee’s current period gross pay, minus the employee’s current withholdings.

•	Check Amt - The total amount of the check made out to this employee during this payroll processing run.

•	Check # - The check number assigned to this employee during payroll processing.

•	Withholdings - The current, quarter-to-date, and year-to-date amounts withheld for this employee.

•	Code - The withholding’s code.

•	Method - The method by which the withholding is computed for this employee:

•	System - Indicates that the withholding was calculated based on the firmwide default method specified in Payroll Withholding Code Table Maintenance.

•	Amount - Indicates that a fixed amount for this employee was used rather than the firmwide default method. The amount used appears in the Amount/Pct field.

•	Percentage - Indicates that a specified percentage of the employee’s wages was used rather than the firmwide default method. The percentage used appears in the Amount/Pct field.

•	Amount/Pct - This field is used in conjunction with the Method field. It gives the fixed amount or percentage of wages withheld. If the employee uses the firmwide default method, no entry appears in this field.

•	Limit - The limit, if any, for this withholding as entered in Employee Payroll Withholding Table Maintenance.

•	Withheld - The amount withheld includes withholdings posted during all payroll processing runs (regular, bonus, and adjustments). Deltek Advantage displays withheld amounts for:

•	Current - The amount withheld during this payroll run.

•	Quarter-to-Date - The total amount withheld this quarter.

•	Year-to-Date - The total amount withheld this year.

•	Benefit Hours

•	Plan - The name of the employee’s benefit plan(s).

•	Earned - The number of hours earned (or accrued) by this employee for this benefit plan since the last time a regular payroll was processed for this employee.

•	Taken - The number of hours taken by this employee for this benefit plan since the last time a regular payroll was processed for this employee.

•	Balance - The current balance of benefit hours for this employee for this benefit plan.

 Notes


Overview of Direct Deposit Processing
Overview of Payroll Direct Deposit Processing

You can use the Direct Deposit feature to deposit your employee’s paychecks directly to their personal bank accounts. The Direct Deposit feature produces:

•	A direct deposit transfer file in Automated Clearing House (ACH) format. You send this file to your bank.

•	A Direct Deposit report. This report lists the employee number, employee name, employee social security number, status, bank ID, bank account number and type, direct deposit status, and direct deposit amount for each employee included in the direct deposit run.

Direct Deposit Processing Checklist

The following checklist describes the steps you must perform to use the direct deposit feature for your employees. Each step is described later in this section. Print out this page and check off each item as you complete it.

Check When Completed	Step	Where Entered
____________	Determine if net payroll should be posted directly to the bank	Payroll Setup Maintenance
____________	Determine whether bonus and adjustment runs should be directly deposited	Payroll Setup Maintenance
____________	Set up direct deposit for each employee	Employee Table Maintenance
____________	Process Payroll Direct Deposit	Payroll Direct Deposit Processing
____________	Review the Direct Deposit report	Payroll Direct Deposit Processing
 Related Topics


Direct Deposit Processing
Payroll Direct Deposit Processing

When an employee elects to receive his or her pay using direct deposit, you must assign a status of Add or Wait to the employee and then process an initial direct deposit to submit the appropriate employee account information to the bank. After the employee’s bank has confirmed the account information, you can change the employee’s status to Active in Employee Direct Deposit Table Maintenance, and then process regular direct deposits for the employee.

To process payroll direct deposits:

1.	Select, Processing, Payroll Processing, Direct Deposit from the Deltek Advantage main menu. Deltek Advantage displays a form listing the payroll runs during this period.

2.	Select a payroll run to process. Note that Deltek Advantage allows you to select only one payroll run.

3.	Enter/review the information on the Direct Deposit Processing form.

Immediate Destination Number	Company ID
Immediate Destination Name	Entry Description
Immediate Origin Number	Routing Number
Immediate Origin Name	Account Number
Credits Only	Account Type
Credits and Debit	Effective Entry Date
Company Name	Output File Name
4.	Click on the Advanced Options button to display the Advanced Setup Options.

5.	Make changes to the direct deposit information or processing options, as needed.

•	If you did not enter a bank code in Payroll Setup Maintenance, you can modify direct deposit information and processing options using the fields on the Direct Deposit Processing form.

•	If you did enter a bank code in Payroll Setup Maintenance, you must click on the Bank Code Maintenance button and modify direct deposit information and processing options using the Bank Codes Setup form. Refer to the context-sensitve help on the form, as needed.

Note that if you make any changes on the Bank Codes Setup form, you must close the selected payroll run and re-open it for the changes to take effect.

6.	Click on the Report button to review all employees and amounts to be processed.

7.	Click on the Process button to create the file that you will send to the bank. Deltek Advantage processes direct deposits for employees who were set up for direct deposit when this run was posted.

Deltek Advantage generates the direct deposit file using the filename and location that appears in the Output File Name field. This file and location can vary from session to session.

8.	Review the direct deposit file and send it to the bank. You can send the file to the bank by either mailing a disk copy or attaching it to an e-mail.

9.	Click on the Close button to exit the Payroll Direct Deposit processing routine.

 Notes

 Related Topics


Direct Deposit Report

The Direct Deposit Report lets you review the direct deposit transactions for a payroll processing run or an expense payments processing run. You can run this report before or after you process direct deposits and create the file to be sent to the bank. The Direct Deposit report should not be sent to the bank; it is for your records.

The Direct Deposit report contains the information for each employee who has selected to have any portion of their payroll or expense payments directly deposited and who was included in the selected payroll or expense payments processing run. Therefore, you can print the report prior to processing direct deposits to ensure that each employee’s direct deposit information is correct.

The following data appears on the Direct Deposit report:

•	Employee Number, Name, and Social Security number - General employee information from Employee Table Maintenance. It is used for identification purposes.

•	Bank ID - The bank identification number as entered through Employee Direct Deposit Table Maintenance.

•	Bank Account - The employee’s bank account number as entered through Employee Direct Deposit Table Maintenance.

•	Type - The employee’s bank account type as entered through Employee Direct Deposit Table Maintenance.

•	Status - The employee’s direct deposit status.

•	Amount - The amount deposited to the employee’s bank account.

 Related Topics


Overview of ADP Processing

The ADP interface allows you to automatically export payroll related timesheet information from Deltek Advantage for processing in the ADP PC/Payroll for Windows product.

All timesheet information for one or more selected postings will be included in an export. Timesheet information, which requires special processing within ADP, can be associated with special ADP codes within the export file; these special ADP codes can be associated with specified projects and/or specified labor codes. A special ADP code could, for example, be associated with the vacation project. A special ADP code for a premium pay rate could be associated with a specified labor code.

A single export file will be created for each ADP company code. ADP company codes can be specified by employee and/or employee profit center.

Once created, the export files must be transmitted to ADP for processing.

ADP Processing Checklist

The following checklist describes the process to perform in order to export your company’s payroll information using the ADP Export feature. Each step is described later in this section. Print out this page and check off each item as it is completed.

Completed?	Step	Where Entered
__________	Enable the ADP feature.	Timesheets tab of General System Setup Maintenance
__________	Enter ADP special labor codes.	ADP Labor Codes Setup Maintenance
__________	Enter ADP information for your projects.	ADP Tab of Project Table Maintenance
__________	Enter ADP information for your employees.	Payroll Tab of Employee Table Maintenance
__________	Set up a profit center for ADP.	Setting up an ADP Company Code for a Specific Profit Center
__________	Export the ADP file.	ADP Export Processing


General ADP Processing Steps

The following general process occurs whenever you export timesheets to ADP.

1.	Employees enter timesheets in Deltek Advantage.

2.	The payroll administrator selects timesheet files to export to ADP.

3.	Deltek Advantage creates a file on disk.

4.	To enable ADP in Deltek Advantage, you must complete ADP setup using the following forms:

Form	Description
General System Setup	Enable the ADP interface feature and enter the default ADP company code.  For further information, see General System Setup for ADP.
Project Table Maintenance	Use the ADP tab to associate ADP codes with projects that require special processing in ADP. These codes are commonly used for entering sick, vacation, and holiday time. For further information, see ADP Setup in Project Table Maintenance.
ADP Special Labor Codes	Enter special labor codes to indicate for multiple pay rates. Hazard pay, for example, may require a special pay rate that varies from the regular rate of payment.  For further information, see Setting up Special Labor Codes in ADP.
Individual Profit Center Setup	Use this form to define ADP company codes for specific profit centers.
Employee Table Maintenance	Enter the employee specific ADP file number, ADP company code, and rate code for each employee.  For further information, see ADP Setup in Employee Table Maintenance.
 Note


ADP Tab of Project Table Maintenance

The ADP codes for special tasks are commonly used for sick, vacation, and holiday time, which ADP must deduct from the allotted totals.

To complete this portion of the ADP setup:

1.	From the Tables menu, select Projects, Project Table Maintenance. The Project Table Maintenance form appears.

2.	Click on the ADP tab.

3.	Deltek Advantage allows you to define special tasks in the ADP fields only from the task level. The button in the upper right corner of the form is labeled either Project or Task. If the Task label appears on this button, click on it.

4.	For projects with tasks, if the ADP Special Task field is not checked, click on the blank box. A check mark appears in this field, and Deltek Advantage activates the rest of the ADP special task fields.

5.	Enter data in the following fields, completing the ADP fields in the Project Table Maintenance form. When needed, refer to the context-sensitive help on the form.

Note that all fields require data entry even if you are not currently making use of them. You may, for example, require special codes for regular hours but do not require or need them for overtime hours. You must still complete entries in the overtime fields.

For further information on Project Table Maintenance, see Project Table Maintenance.


Setting up an ADP Company Code for a Specific Profit Center

To enter an ADP company code for a specific profit center, go to Utilities, Setup Table Maintenance, Profit Centers, Individual Profit Center Setup. Enter a code at the ADP Company Code field. The code that you enter applies to all employees associated with the specific profit center except for those employees for whom an ADP company code has been entered in Employee Table Maintenance.

For further information on individual profit centers, see Individual Profit Center Setup Maintenance.


Exporting an ADP file

The Export Timesheets to ADP form allows you to send all timesheets that require automated data processing to ADP for the period specified. The columns included on the Export form are described on the following list:

•	Type - The files listed on this form can be one of three types:

•	Timesheets (TA) for files that contain timesheets ready for processing.

•	Labor Adjustments (LA).

•	Billing – Labor (BL).

•	Seq - The posting sequence numbers for each period.

•	Name - Indicates who posted the file. These fields might, for example, include the abbreviation Admin, indicating that the payroll administrator posted the file(s).

•	Posted - Indicates the date and time at which each file was posted to this list for processing.

•	Comment - This system-generated field indicates the number of timesheet records included in and the period ending date for an export file. This field also indicates whether the file includes billing-labor or labor adjustments records.

•	Processed - Indicates the status of the file in conjunction with ADP. A file can fall into one of three statuses: Processed, Unprocessed, or Incomplete. A file would receive a status of Incomplete, for example, if, when running the export function, your company experienced a system crash so the export did not run successfully.

•	Period - The pay period for which you are processing the timesheet, adjustment, or billing labor file.

To export a file to ADP:

1.	Enter a pay period or periods in the Range of periods field. Deltek Advantage allows you to enter more than one period because you may want to export timesheets that overlap periods.

2.	If, in addition to timesheets, you want to select from labor adjustments, transfers, or postings already exported to ADP, enter a check mark in the appropriate fields.

3.	In the Specify Location for ADP Export Files field, specify where you want the processed (i.e., exported) files stored.

4.	Click on the files that you want to export to ADP.

5.	Click on the Export button. Deltek Advantage automatically generates a report log that includes the following information for each employee listed on the export file:

•	Employee number

•	ADP Employee number

•	Employee name

•	Employee Social Security number

•	Hours for regular, overtime, and special labor codes

The report also includes the following information for all employees listed on the export file:

•	Company Code number

•	Employee totals for regular, overtime, and special labor codes.

•	Print a copy of the export file; otherwise, you will have to reprocess the ADP file if you later require a printout.

6.	After transmitting a copy of the export file to ADP, you should delete the file from your system to avoid sending old files for the current period. You could, for example, have created two files (A and B) for the previous week’s payroll and only one file (A) for the current payroll. When you transmit your payroll to ADP, you could mistakenly send file A with information for this week’s payroll and file B with information for last week’s payroll; consequently, employees would receive incorrect amounts on their paychecks.

You can view the export file in Excel by clicking on the MS Excel button located on the toolbar.

If you have any questions regarding the export of your file, contact your ADP representative.


W-2 Forms
W2 Forms

Each year, we publish a year-end bulletin that helps you with your year-end activities.

W-2s are the means by which you report each employee’s earnings and tax withholdings for the calendar year. Almost all firms use six-part W-2s. The six copies are distributed as follows:

•	Copy A to the Social Security Administration.

•	Copy B to the employee for the employee’s federal tax return.

•	Copy C to the employee for the employee’s records.

•	Copy D to the employer for the employer’s records.

•	Copy 1 to the employee for the employee’s state, city, or local taxes.

•	Copy 2 to the employer for the employer’s state, city, or local taxes.

The Payroll module prints a W-2 for each employee who was paid any amount during the calendar year.

The IRS requires that you file a W-2 for an employee if you paid the employee any amount during the year or if you withheld income tax or social security for the employee.

When an employee leaves the firm, you are obligated to supply the employee with a W-2 within 30 days if the employee requests one.

The Payroll module lets you produce W-2s at any time during the year without affecting the database. You can print W-2s for as many or as few employees as you wish at any time.

You can print W-2s on W-2 Forms that are specially designed for use on computer printers. There are several steps involved in producing your W-2 forms. These steps are outlined below.

To produce W-2 forms:

1.	Fill in the information on the Form W-2 Processing form.

2.	Enter your employer state tax identification numbers for state withholdings for which you withheld taxes for your employees.

3.	Generate the work file to review the information collected by this routine.

4.	Make any modifications to the work file using the Form W-2 Editor.

5.	Print or print preview W-2 forms for desired employees, or transfer the information to magnetic media if you will be filing on magnetic media.

6.	Generate the W-3 Worksheet.

 Note

 Related Topics


W-2 Form Contents

The Internal Revenue Service has released final, usable versions of Form W-2, Wage and Tax Statement, and Form W-3, Transmittal of Wage and Tax Statements, for 2002, with instructions.

Highlights of the W-2 changes include the following:

•	Elimination of Code Q (Military employee basic housing, subsistence, and combat zone compensation) for Box 12.

The changes noted above refer only to the 2001 Forms W-2 and W-3 and do not affect the 2000 forms.

The following table discusses the contents of the W-2 Form:

Box	Field	Description
a	Control number	A sequencing number generated by Advantage for identification and control purposes. The control number of the first W-2 that you print is 1.
	Void	Select this option, using the Form W-2 Editor if you need to void the form because it is incorrect.
b	Employer’s identification number	Your firm’s federal tax identification number as entered on the Form W-2 Processing screen.
c	Employer’s name, address, and ZIP code	Your firm’s name, address, and zip code as entered on the Form W-2 Processing screen.
d	Employee’s social security number	The employee’s social security number as entered on the Address tab of Employee Table Maintenance.
e	Employee’s first name and initial Last name	The employee’s name as entered in Employee Table Maintenance.
f	Employee’s address and ZIP code	The employee’s address and ZIP code as entered on the Address tab of Employee Table Maintenance.
1	Wages, tips, other compensation	The employee’s gross wages for the calendar year, including a reduction by any 401(k) and/or 125/Cafeteria contributions.
2	Federal income tax withheld	The amount of federal income tax withheld from the employee’s wages during the year.
3	Social security wages	The amount of the employee’s gross wages, including a reduction by any 125/Cafeteria contributions, up to the social security wage base for the W-2 year, that is subject to social security tax. (The Social Security wage base changes from year to year.)
4	Social security tax withheld	The amount of social security tax withheld from the employee’s wages during the year.
5	Medicare wages and tips	The amount of the employee’s gross wages, including a reduction by any 125/Cafeteria contributions, that is subject to Medicare tax.
6	Medicare tax withheld	The amount of Medicare tax withheld from the employee’s wages during the year.
7	Social security tips	Advantage leaves this box blank, but you may fill it in using the Form W-2 Editor.
8	Allocated tips	Advantage leaves this box blank, but you may fill it in using the Form W-2 Editor.
9	Advance EIC payment	Advantage leaves this box blank, but you may fill it in using the Form W-2 Editor.
10	Dependent care benefits	Advantage leaves this box blank, but you may fill it in using the Form W-2 Editor.
11	Nonqualified plans	Advantage leaves this box blank, but you may fill it in using the Form W-2 Editor.
12		The following list explains the codes shown in box 12. You may need this information to complete your tax return.  Note: If a year follows code D, E, F, G, H, or S, you made a make-up pension contribution for a prior year(s) when you were in military service. To figure whether you made excess deferrals, consider these amounts for the year shown, not the current year. If no year is shown, the contributions are for the current year.  • A – Uncollected social security or RRTA tax on tips (Include this tax on Form 1040. See "Total Tax" in the Form 1040 instructions.)  • B – Uncollected Medicare tax on tips (Include this tax on Form 1040. See "Total Tax" in the Form 1040 instructions.)  • C – Cost of group-term life insurance over $50,000 (Included in boxes 1, 3 (up to social security wage base), and 5) • D – Elective deferrals to a section 401(k) cash or deferred arrangement. Also includes deferrals under a SIMPLE retirement account that is part of a section 401(k) arrangement.  • E – Elective deferrals under a section 403(b) salary reduction agreement  • F – Elective deferrals under a section 408(k)(6) salary reduction SEP  • G – Elective deferrals and employer contributions (including nonelective deferrals) to a section 457(b) deferred compensation plan  • H - Elective deferrals to a section501(c)(18)(D) tax-exempt organization plan (see "Adjusted Gross Income" in the Form 1040 instructions for how to deduct)  • J – Nontaxable sick pay (not included in boxes 1, 3, 5)  • K – 20% excise tax on excess golden parachute payments (see "Total Tax" in the Form 1040 instructions)  • L – Substantiated employee business expense reimbursements (nontaxable)  • M - Uncollected social security or RRTA tax on cost of group-term life insurance over $50,000 (former employees only) (see "Total Tax" in the Form 1040 instructions)  • N - Uncollected Medicare tax on cost of group-term life insurance over $50,000 (former employees only) (See "Total Tax" in the Form 1040 instructions.)  • P – Excludable moving expense reimbursements paid directly to employee (not included in boxes 1, 3, or 5)  • R – Employer contributions to your medical savings account (MSA) (See Form 8853, Medical Savings Accounts and Long-Term Care Insurance Contracts)  • S – Employee salary reduction contributions under a section 408(p) SIMPLE (not included in box 1)  • T – Adoption benefits (not included in box 1). You must complete Form 8839, Qualified Adoption Expenses, to compute any taxable and nontaxable amounts.  • V – Income from exercise of nonstatutory stock option(s) (Included in boxes 1, 3 (up to social security wage base), and 5). • W – Employer Contribution to a Health Savings Account (in position 364-374 of RW record and 250-264 of RT record). • Y — Deferrals under a section 409A non-qualified deferred compensation plan. • Z — Income under section 409A on a non-qualified deferred compensation plan. • AA — Employee contributions to a Roth 401(k). • BB — Employee contributions to a Roth 403(b). Do not report in Box 12 any items that are not listed as codes A-W. Also, do not report in Box 12 section 414(h)(2) contributions (relating to certain state or local government plans). Instead, use box 14 for these items and any other information you wish to give your employee. For example, union dues and uniform payments may be reported in Box 14.
13		• Statutory employee: Select this box using the Form W-2 Editor if the employee is a statutory employee. • Retirement plan: Select this box if the employee was an active participant in any of the following: • A qualified pension, profit-sharing, or stock bonus plan described in section 401(a) (including a 401(k) plan).  • An annuity plan described in section 403(a). • An annuity contract or custodial account described in 403(b). • A simplified employee pension (SEP) plan described in 408(k).  • A SIMPLE retirement account described in 408(p).  • A trust described in section 501(c)(18).  • A plan for Federal, state, or local government employees or by an agency or instrumentality thereof (other than a section 457 plan).  • Third-party sick pay: Mark this checkbox only if you are a third-party sick payer filing a Form W-2 for an insured’s employee.
14	Other	You may choose to print specific withholdings in this box through Payroll Withholding Setup Table Maintenance. These withholdings can be either 125/Cafeteria or Other withholdings. The withholding(s) description and total withholding’s amount withheld year-to-date prints in this box. This field is blank if you specify no withholding for printing on the W-2 form. (Advantage prints up to three withholdings per employee in this box.)
15	State, Employer’s state I.D. No.	The state locale (postal abbreviation) you entered in Payroll Withholding Setup Table Maintenance. The state tax identification number(s) are entered by clicking on the State IDs button from the Form W-2 Processing screen.
16	State wages, tips, etc.	The amount of the employee’s gross wages subject to state tax, including a reduction for any 401(k) plan and/or 125/Cafeteria contributions, if the state excludes them from gross wages for tax purposes.
17	State income tax	The amount of state income tax withheld from the employee’s wages during the calendar year.
18	Local wages, tips, etc.	The amount of the employee’s gross wages that is subject to local tax, including a reduction by any 401(k) and/or 125/Cafeteria contributions, if the locality excludes them from gross wages for tax purposes.
19	Local income tax	The amount of local income tax withheld for the employee.
20	Locality name	The local withholding description entered in Payroll Withholding Setup Table Maintenance. (Advantage prints up to two localities for each employee.)


Entering Data for Form W-2 Processing

To enter data for Form W-2 Processing:

1.	Select Processing, Payroll, Form W-2 Processing from the Deltek Advantage main menu

2.	Complete the fields in Form W-2 Processing form, referring to the context-sensitive help on the form.

3.	To generate the work file and enable the other functions, click on the Generate the Work File button.

4.	Click on the appropriate function button. You can regenerate the work file, edit the W-2 form, print the W-2 form, preview the printed form, create a magnetic media file, view the W-3 work sheet, enter state IDs, or close the file.


Entering State Identification Numbers

For each state for which you have withheld state taxes for employees, you must enter the state tax identification number(s).

To enter state tax identification numbers:

1.	Click on the State IDs button from the Form W-2 Processing form.

2.	In the State field, select the states in which you wave withheld taxes for employees.

3.	In the Employer’s I.D. No. field, enter the employer’s ID number.

4.	Perform Steps 2 and 3 for all state for which you have withheld state taxes for employees.

The state identification numbers appear in Box 16 of the W-2 form with any associated state wages and income tax withholdings that appear in Boxes 17 and 18 respectively.

 Note


Generating the Work File

Once you enter the information on the Form W-2 Processing form and establish the State IDs that you want to appear in Box 16 of the W-2 form, you generate a work file which contains a "snapshot" of all the pertinent W-2 data from the employee payroll database. Any changes made to W-2 data using the Form W-2 Editor affect the data in the work file only.

To create the work file, click on the Generate work file button from the Form W-2 Processing form. Deltek Advantage displays a message warning you that any payroll processing for the selected Processing W-2 year subsequent to generating the work file will not be reflected in the work file. Once the work file is generated, the following buttons are enabled:

Button	Use to
Edit	Edit and/or print W-2 forms for individual employees.
Print	Print W-2 forms for all employees in the work file not flagged on the Edit form to be excluded from W-2 Reporting.
Print Preview	Print preview W-2 forms for all employees in the work file not flagged on the Edit form to be excluded from W-2 Reporting.
Magnetic Media	Transfer the W-2 data in the work file to a disk file for magnetic media reporting.
W-3 Worksheet	Generate the Form W-3 Worksheet.

After generating the work file, you can regenerate the work file at any time by clicking on the Generate work file button. If you do this, Deltek Advantage overwrites all information, including any changes made using the Form W-2 Editor, in the previously generated work file.

 Related Topics


Modifying the Information in the Work File using the Form W-2 Editor

Once you generate the work file, you can modify W-2 data for individual employees. To do this, click on the Edit button. Deltek Advantage displays the Form W-2 Editor form. You can edit any information on this form by selecting the information and entering the desired changes.

You can switch easily from employee to employee in one of the following ways:

•	Use the Employee field in the bottom right corner of the form to enter the employee’s number for which you want to verify and/or modify W-2 information. Double click in this field to obtain a lookup of all the employees in your database.

•	Use the record selectors at the bottom of the form to scroll through the employees in the order in which they appear in the work file. Employees are sorted sequentially by employee number in the work file.


Printing/Previewing W-2 Forms

Once you have generated the work file and made any desired edits to your employee’s W-2 data, you can print the forms by clicking on the Print button from the Form W-2 Processing form. Prior to doing this, you should ensure that the appropriate forms are loaded in your printer.

 Notes


Advance Printing

To select an Advance Printing option:

1.	Click the Advance Printing button. Advantage displays the Advance Printing Options dialog box which provides two printing options.

2.	Do one of the following:

•	To set the top and left margins to the minimum allowed by your printer, select the Use Custom Layout option. The user should select this option if W2s do not align properly with the firm’s forms.

•	To use your firm’s default layout, select the Use Default Layout option. Most firms require the default layout option.


Magnetic Media Reporting

Deltek Advantage W-2 Magnetic Media Reporting conforms to Federal magnetic reporting guidelines and those states that comply with Federal guidelines.

To transfer W-2 information to magnetic media:

1.	Process W-2 forms. See W-2 Forms, Entering Data for Form W-2 Processing, Entering State Identification Numbers, and Generating the Work File for more information.

2.	Verify that all W-2 information generated for your employees is correct. See Modifying the Work File using the Form W-2 Editor for more information.

3.	Click on the Magnetic Media button from the Form W-2 Processing form. Deltek Advantage displays the Form W-2 Magnetic Media Reporting form.

4.	Complete the fields for magnetic media reporting:

Field	Description
Processing W-2 Year	The W-2 processing year for which you generated W-2 forms.
Computer Manufacturer	Enter the name of your computer’s manufacturer using up to eight alphanumeric characters.
File Name	Enter the name and path of the magnetic media report file. The default for this field is A:\W2REPORT.
Personal identification Number	Required. Enter the Personal Identification Number (PIN) of the person responsible for the file and attesting to its accuracy.  This is generally the same individual who signs the attestation statement on the Form W-3.  The PIN you enter here is inserted in the Personal Identification Number (PIN) field in the RA Record, position 12-28, and is used as your signature for the file. By entering this PIN, you attest that "under penalties of perjury, you declare that you have examined this file's data and that to the best of your knowledge and belief, it is true, correct, and complete."  For more information about the PIN, please refer to www.ssa.gov/employer.
Contact Name	Required. Enter the name of the person to be contacted by the Social Security Administration (SSA) concerning processing problems.
Contact Phone Number	Required. Enter the contact's telephone number, including area code.
Contact Phone Extension	Enter the contact's phone extension, if necessary.
Contact Email	Enter the contact's e-mail address, if any. This field is required if you select 1 from the Preferred Method of Notification Code field.
Contact FAX	Enter the contact's FAX number, including area code. This field is for United States and United States territories only.
Preferred Method Of Notification Code	Select one of the following codes to indicate how you would like to be contacted with questions:  1 (one) — EMail/Internet  2 — Postal Service
Resub Indicator	Select if this file is being resubmitted.
Resub Wage File Identifier	If you selected Resub Indicator, enter the WFID (Wage File Identifier) displayed on the notice sent to you by SSA.
Terminating Business Indicator	Select this option if you have terminated your business during this tax year.
5.	Click on the Create File button to create the magnetic media reporting file. Deltek Advantage creates the file in the location specified at the File name field on the Form W-2 Magnetic Media Reporting form.

Refer to "SSA Publication Number 42-007 Magnetic Media Reporting" for proper disk labeling and packaging instructions.

 Note

 Related Topics


Magnetic media fields not supported

Deltek Advantage does not support the following W-2 fields on magnetic media:

•	Foreign Address Indicator

•	Different Employment Types. The W-2 Magnetic Media Reporting program uses R (Regular) in all cases.

•	Establishment Number or Coverage Group/Payroll Record Unit (PRU) number

•	Limitation of Liability Indicator

•	Other EIN

•	Income Tax Withheld by Third-Party Payer

•	Non-Qualified Plan Section 457 Distributions

•	Local Tax Reporting


Generating the W-3 Worksheet

When you file your W-2 forms, you must also submit a W-3 form (Transmittal of Wage and Tax Statements) that includes totals of all your employees’ W-2 forms. The Payroll module lets you generate a worksheet to help fill out the actual Form W-3 by clicking on the W-3 Worksheet button from the Form W-2 Processing form. The worksheet includes totals of the W-2 forms you process.


Payroll Reporting

Deltek Advantage produces various reports to aid you in presenting and reviewing your payroll information.

The Payroll Reporting routine lets you print all of your payroll-related reports from one form using the same options for each report. From Payroll Reporting you can print (or view on-line) several reports:

Employee Payroll List

Withholdings by Category Report

State Unemployment Insurance Worksheet

State/Local Income Tax Worksheet

Form 941 Worksheet

Form 940 Worksheet

Payroll Check Register

What do you want to do?

E-mail, print, or submit the report from the Batch Printing tab.

Select specific data for the report on the Selection tab.

Determine in what order to print report data on the Sorting tab.

Define options for the Employee Payroll List.

Define options for the Withholdings by Category report.

Define options for the State Unemployment Insurance Worksheet.

Define options for the State/Local Income Tax Worksheet.

Define options for the Form 941 Worksheet.

Define options for the Form 940 Worksheet.

Define options for the Payroll Check Register

 Note


Sorting the Payroll Reports

You can set up sorting criteria which allows you to determine the way that information appears on reports. To access this form, simply click the Sorting tab at the top of the form. From this option form, you can specify to sort the reports using up to four sort codes.

If Profit Center Reporting is Installed

•	From this option form, you can specify to sort the reports using up to four levels of the profit center code. For example, if you have two levels defined in your profit center code: Office and Discipline, these appear as choices on which to sort. You can also choose to sort on the entire profit center.

If Profit Center Reporting is not Installed

•	From this option form, you can sort the employee detail by:

Employee Number

Last Name

Status

Select Codes

You can insert a page break after any or all of the sorts. If you do this, Deltek Advantage automatically page breaks when the sort changes. For example, if you insert a page break for the first sort, Office, and you have three offices (BO, CO, and SF), Deltek Advantage inserts a page break each time the office changes.

You can also print subtotals at the end of each sort. For example, if you sort on profit center, Deltek Advantage prints a subtotal for each profit center.


Defining Options for the Employee Payroll List

The Payroll List tab of Payroll Reporting lets you define and save multiple options for printing the Employee Payroll List.

To define options for the Employee Payroll List:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the Payroll List tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the Employee Payroll List.

3.	Choose the appropriate options for the report:

Reporting Period:

W-2 Year

W-2 Quarter

Show Range of Periods

4.	Click on the Print, Print Preview, or Submit button to generate this report.

 Notes

 Related Topics


Employee Payroll List

The Employee Payroll List shows all of the data currently in your employee payroll database. You use this report to review the data entered through Employee Table Maintenance and the cumulative postings that result from payroll processing.

This report contains extensive information for each employee in your firm. Therefore, print it only when there are extensive changes to the employee payroll table. Otherwise, you can view information for a few employees through Employee Table Maintenance.

This report contains three basic types of information about each employee:

•	General information, including social security number, pay rate, overtime percentage, and secondary overtime percentage.

•	Current fiscal period, quarter-to-date, and year-to-date hours and gross pay.

•	Current fiscal period, quarter-to-date, and year-to-date withholdings.

The following list describes the data shown on the Employee Payroll List:

•	Employee Number, Name, and SS number - General employee information from Employee Table Maintenance appears for identification purposes.

•	Rate - The rate at which the employee is paid for regular hours, as well as whether the rate is hourly or salaried (per pay period).

•	Ovt Pct - The percentage applied to the employee’s regular pay rate to arrive at an overtime pay rate. This information is entered in Employee Table Maintenance.

•	Ovt-2 Pct – The percentage applied to the employee’s regular pay rate to arrive at a secondary overtime pay rate. This information is entered in Employee Table Maintenance.

•	Hours - The employee’s current fiscal period, quarter-to-date, and year-to-date regular, overtime, and secondary overtime hours.

•	Pay - The employee’s current fiscal period, quarter-to-date and year-to-date regular, overtime, secondary overtime, and other pay.

•	Withholdings – For each withholding, the following information appears:

•	Code - The withholding’s code.

•	Supp - Indicates whether or not the withholding is currently being suppressed for this employee. If this option is selected, the withholding is suppressed.

•	Method - The method by which the withholding is computed for this employee:

•	System - Indicates that the withholding was calculated based on the firmwide default method specified in Payroll Withholding Code Table Maintenance.

•	Amount - Indicates that a fixed amount for this employee was used rather than the firmwide default method. The amount used appears in the Amount/Pct field.

•	Percentage - Indicates that a specified percentage of the employee’s wages was used rather than the firmwide default method. The percentage used appears in the Amount/Pct field.

•	Amount/Pct - This field is used in conjunction with the Method field. It gives the fixed amount or percentage of wages withheld. If the employee uses the firmwide default method, no entry appears in this field.

•	Add’l. Amount - If desired, specify an amount to withhold in addition to the amount automatically computed by Deltek Advantage. A common use of this amount is to supplement federal or state withholding amounts to guard against under withholding or to make up for any over/under withholding during prior payrolls.

•	Limit - The limit, if any, for this withholding as entered in Employee Payroll Withholding Table Maintenance.

•	Limit-to-date - For withholdings with limits, the amount withheld to date that is applied to the limit.

•	Withheld - The amount withheld includes withholdings posted during all payroll processing runs (regular, bonus, and adjustments). Deltek Advantage displays withheld amounts for:

•	This Pd. - The amount withheld during the current fiscal period.

•	Quarter-to-Date - The total amount withheld this quarter.

•	Year-to-Date - The total amount withheld this year.

The following fields apply only to certain required tax withholdings (such as Federal):

•	St. – (Status) The filing status of the employee for tax withholdings that require a filing status.

•	Ex. – (Exemptions) The number of exemptions claimed by the employee for tax withholdings that use exemptions.

•	Oe. – (Other Exemptions) This field contains the supplemental information about exemptions (that is, other exemptions), and is used only by tax locales that distinguish between types of exemptions.

 Notes

 Related Topics


Defining Options for the Withholdings by Category Report

The Withholdings by Category tab of Payroll Reporting lets you define and save multiple options for printing the Withholdings by Category Report.

To define options for the Withholdings by Category report:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the Withholdings by Category tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the Withholdings by Category report.

3.	Choose the appropriate options for the report:

Reporting Period:

W-2 Year

W-2 Quarter

Include Current Period

Show Range of Periods

Specific withholding code

4.	Click on the Print, Print Preview, or Submit button to generate this report.

 Note

 Related Topics


Withholdings by Category Report

The Withholdings by Category Report provides you with current, quarter-to-date, and year-to-date amounts for each (or a selected) withholding category in your database. For each withholding category, Deltek Advantage breaks out the withholding amounts by employee and then lists the totals for each category.

The following list describes the data shown on the Withholdings by Category Report:

•	Withholding Code - The withholding for which the Withholdings by Category Report is being run. You specify a withholding at the Specific withholding code field on the Options tab.

•	Employee Number and Name - General employee information from Employee Table Maintenance appears for identification purposes.

•	Method - The method by which the withholding is computed for this employee:

•	System - Indicates that the withholding was calculated based on the firmwide default method specified in Payroll Withholding Code Table Maintenance.

•	Amount - Indicates that a fixed amount for this employee was used rather than the firmwide default method. The amount used appears in the Amount/Pct field.

•	Percentage - Indicates that a specified percentage of the employee’s wages was used rather than the firmwide default method. The percentage used appears in the Amount/Pct field.

•	Amount/Pct - This field is used in conjunction with the Method field. It gives the fixed amount or percentage of wages withheld. If the employee uses the firmwide default method, no entry appears in this field.

•	Limit - The limit, if any, for this withholding as entered in Employee Payroll Withholding Table Maintenance.

•	Additional Amount - If desired, specify an amount to be withheld in addition to the amount automatically computed by Deltek Advantage. A common use of this amount is to supplement federal or state withholding amounts to guard against under withholding or to make up for any over/under withholding during prior payrolls.

•	Withheld - The amount withheld includes withholdings posted during all payroll processing runs (regular, bonus, and adjustments). Deltek Advantage displays withheld amounts for:

•	Last Payroll - The amount withheld during the last payroll run.

•	Quarter-to-Date - The total amount withheld this quarter.

•	Year-to-Date - The total amount withheld this year.

 Note

 Related Topics


Defining Options for the State Unemployment Worksheet

The SUI Worksheet tab of Payroll Reporting lets you define and save multiple options for printing the State Unemployment Insurance Worksheet.

To define options for the State Unemployment Insurance worksheet:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the SUI Worksheet tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the State Unemployment Insurance worksheet.

3.	Choose the appropriate options for the report:

Reporting Period: W-2 Year	Show Range of Periods
W-2 Quarter	Exclude 401(k) contributions
Include Current Period	Exclude 125/Cafeteria contributions
Wage Base	Exclude Specific 125/Cafeteria contributions
Percentage
State
4.	Click on the Print, Print Preview, or Submit button to generate this report.

 Note

 Related Topics


State Unemployment Insurance Worksheet

The State Unemployment Insurance Worksheet supplies you with most of the information you need to fill out your State Unemployment Insurance (SUI) report. (The actual name you use to submit this information varies from state to state. For example, it is the Employer’s Quarterly Contribution Report for Massachusetts, and the DE-3, Quarterly Contribution Return in California.)

Some states do not have an SUI, so you may not need to print the State Unemployment Insurance Worksheet.

Although SUI reports vary from state to state, they all tend to share the following characteristics:

•	The reports are filed quarterly.

•	The reports involve calculating the employer’s quarterly SUI contribution based on taxable wages paid to each employee, usually subject to a wage base, and the tax rate for employers in the state.

The following list describes the data shown on the State Unemployment Insurance Worksheet:

•	Locale - The locale for which the State Unemployment Insurance Worksheet is being run. You specify a locale at the State field on the Options tab.

•	Employee Number, Name, and Social Security number - General employee information from Employee Table Maintenance appears for identification purposes.

•	Gross Pay - The employee’s quarter-to-date and year-to-date gross pay amounts.

•	401(k) - The employee’s quarter-to-date and year-to-date 401(k) contributions.

•	125/Cafeteria - The employee’s quarter-to-date and year-to-date 125/Cafeteria contributions. If you select the Exclude Specific 125/Cafeteria contributions option on the SUI Worksheet, the Cafeteria column caption will be Selected 125/Cafeteria and the column will only display the Cafeteria amounts for those plans selected. If Exclude Specific 125/Cafeteria contributions is not checked, the Cafeteria column caption will be Total 125/Cafeteria and the column will display the entire Cafeteria amount (for all codes).

•	Gross Pay less exclusions - The net of the Gross Pay minus 401(k) and 125/Cafeteria amounts.

•	Subject to Tax - The total amount subject to tax. This amount equals gross pay less 401(k) and/or 125/Cafeteria contributions (based on the settings specified on the Options tab), up to the annual wage base also specified on the Options tab.

 Note

 Related Topics


Summary Information for the State Unemployment Insurance Worksheet

On the last page of the State Unemployment Insurance Worksheet, Deltek Advantage displays quarter-to-date and year-to-date summary information. The following list contains the summary information available for the quarter-to-date:

•	Total payments for services of employees - Includes all 401(k) and/or 125/Cafeteria amounts.

•	Exclusions - - The total of 401(k) and/or 125/Cafeteria amounts, depending on the setting of the Exclude 401(k) contributions and Exclude 125/Cafeteria contributions options on the Options tab of the Payroll Reporting routine.

•	Total payments less exclusions - The net of the Total payments for services of employees and the Exclusions.

•	Payments for services of more than <wage base> on a YTD basis - Calculated after excluding 401(k) and/or 125/Cafeteria amounts.

•	Total taxable wages - The net of the Total payments less exclusions and the Payments for services of more than <wage base>.

•	Gross tax (@%) - Calculated by applying the percentage to the Total taxable wages.

The following list reviews the summary information available for the year-to-date:

•	Total payments for services of employees - Includes all 401(k) and/or 125/Cafeteria amounts.

•	Exclusions - The total of 401(k) and/or 125/Cafeteria amounts, depending on the setting of the Exclude 401(k) contributions and Exclude 125/Cafeteria contributions options on the Options tab of the Payroll Reporting routine.

•	Total payments less exclusions - The net of the Total payments for services of employees and the Exclusions.

•	Payments for services of more than <wage base>  - Calculated after excluding 401(k) and/or 125/Cafeteria amounts.

•	Total taxable wages - The net of the Total payments less exclusions and the Payments for services of more than <wage base>.

•	Gross tax (@%) - Calculated by applying the percentage to the Total taxable wages.


How to Use the State Unemployment Insurance Worksheet

Enter the information from the worksheet in the appropriate space on your state unemployment form, as shown below:

Worksheet Information	State Form Information
total gross pay	total wages/compensation paid (less any 401(k) and/or 125/Cafeteria contributions)
total subject to tax (from the Summary)	total taxable wages/compensation
tax (from the Summary)	employer’s unemployment insurance contribution

If the form asks for wages in excess of the limit, use the total gross pay (less any 401(k) and/or 125/Cafeteria contributions, as appropriate) less the total subject to tax.

 Note


Defining Options for the State/Local Income Tax Worksheet

The State Tax Worksheet tab of Payroll Reporting lets you define and save multiple options for printing the State/Local Income Tax Worksheet.

To define options for the State/Local Income Tax worksheet:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the State Tax Worksheet tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the State/Local Income Tax worksheet.

3.	Choose the appropriate options for the report:

Reporting Period:

W-2 Year

W-2 Quarter

Include Current Period

Show Range of Periods

Specific tax locale

4.	Click on the Print, Print Preview, or Submit button to generate this report.

 Note

 Related Topics


State/Local Income Tax Worksheet

The State/Local Income Tax Worksheet supplies you with most of the information you need to fill out your state’s quarterly income tax form. This form, which often corresponds to Form 941, Employer’s Quarterly Federal Tax Return, reports the gross wages that your firm paid to employees during the previous quarter, any 401(k) and 125/Cafeteria withholdings, and the state or local income tax withheld. The worksheet contains both states and localities. (The actual name of the form you use to submit this information varies from state to state. It is the WR-1 for Massachusetts.)

Employees who had income tax withheld in more than one state and/or locality will have multiple listings on the worksheet. When you are completing your state’s quarterly tax return, be sure to fill in gross wages and withholdings that apply to that state/locality only.

The following list describes the data shown on the State/Local Income Tax Worksheet:

•	Employee Number, Name, and Social Security number - General employee information from Employee Table Maintenance appears for identification purposes.

•	Gross Pay - The employee’s year-to-date and quarter-to-date gross pay amounts.

•	401(k) - The employee’s quarter-to-date and year-to-date 401(k) contributions.

•	125/Cafeteria - The employee’s quarter-to-date and year-to-date 125/Cafeteria contributions.

•	Income Tax - The employee’s quarter-to-date and year-to-date income taxes withheld.

Subtotals also appear for each state/locality shown on the worksheet.

Note that if an employee is listed for more than one state and/or local withholding, the employee’s pay, 401(k), and 125/Cafeteria withholdings will be compounded in the total shown on the worksheet.

 Note

 Related Topics


How to Use the State/Local Income Tax Worksheet
How to Use the State/Local Income Tax

Enter the information from the worksheet in the appropriate space on your state quarterly income tax form, as shown below:

Worksheet Information	State Form Information
employee’s name and social security number	same
gross pay per quarter (for each employee)	gross wages paid this quarter
total gross pay for this quarter	total gross wages reported or paid
401(k) and 125/Cafeteria withholdings	401(k) and 125/Cafeteria withheld
tax withholdings	state or local tax withheld


Defining Options for the Form 941 Worksheet

The Form 941 tab of Payroll Reporting lets you define and save multiple options for printing the Form 941 Worksheet.

To define options for the Form 941 worksheet:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the Form 941 tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the Form 941 worksheet.

3.	Choose the appropriate options for the report:

Reporting Period:

W-2 Year

W-2 Quarter

Report Basis

4.	Click on the Print, Print Preview, or Submit button to generate this report.

 Note

 Related Topics


Form 941 Worksheet

The Form 941 Worksheet provides most of the information you need to fill out IRS Form 941, Employer’s Quarterly Federal Tax Return. Your firm must file Form 941 with the IRS quarterly to report:

•	The taxable wages your firm paid to employees during the quarter.

•	The amount of federal income tax withheld from employee’s earnings.

•	Your firm’s liability for FICA this quarter (FICA withheld from employees plus the employer contribution).

The Form 941 Worksheet includes information about your firm’s calculated FICA liability. The calculated liability is based on information, which is entered during the setup of FICA withholdings in Payroll Withholding Code Table Maintenance.

The following columns are included on the Form 941 Worksheet:

•	Employee Number and Name - The employee’s number and name as entered through Employee Table Maintenance.

•	Soc Sec No - The employee’s social security number as entered through Employee Table Maintenance.

•	Gross Pay - The gross wages paid to this employee this quarter.

•	Withholdings

•	401(k) - The total 401(k) contributions withheld for this employee this quarter.

•	125/Cafeteria - The total 125/Cafeteria contributions withheld for this employee this quarter.

•	Federal Income Tax - The total federal income tax amount withheld for this employee this quarter.

•	FICA Wages

•	Subject to HI -. Medicare. The total wages subject to FICA Hospital Insurance for this employee this quarter.

•	Subject to OADS - Social Security. The total wages subject to FICA Old-Age, Survivors, and Disability Insurance for this employee this quarter. ()

 Note

 Related Topics


Defining Options for the Form 940 Worksheet

The Form 940 tab of Payroll Reporting lets you define and save multiple options for printing the Form 940 Worksheet.

To define options for the Form 940 worksheet:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the Form 940 tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the Form 940 worksheet.

3.	Choose the appropriate options for the report:

Reporting Period: W-2 Year	Wage Base
W-2 Quarter  Report Format	Percentage
4.	Click on the Print, Print Preview, or Submit button to generate this report.

 Note

 Related Topics


Form 940 Worksheet

The Form 940 Worksheet provides most of the information you need to fill out the IRS Form 940, Employer’s Annual Federal Unemployment (FUTA) Tax Return.

You must file Form 940 with the IRS annually, along with your payment of federal unemployment tax. Many firms pay FUTA tax quarterly, so the worksheet also calculates the quarterly amount.

Your firm’s FUTA contribution is calculated by applying the current FUTA percentage (entered on the Options tab) to each employee’s gross wages, subject to the annual wage base (entered on the Options tab).

You are responsible for paying the total amount of your firm’s federal unemployment tax - employees do not contribute any portion. A credit can generally be taken against federal unemployment tax for amounts paid into state unemployment funds.

The following list describes the columns on the Form 940 Worksheet:

•	Employee Number, Name, and Social Security number - General employee information from Employee Table Maintenance and Employee Payroll Table Maintenance appears for identification purposes.

•	Gross Pay - The quarter-to-date and year-to-date gross wages paid to this employee.

•	125/Cafeteria - The employee’s quarter-to-date and year-to-date 125/Cafeteria contributions.

•	Subject to Tax - The quarter-to-date and year-to-date wages subject to tax appear.

 Note

 Related Topics


Summary Information for the Form 940 Worksheet

On the last page of the Form 940 Worksheet, Deltek Advantage displays quarter-to-date and year-to-date summary information. The following list contains the summary information available for the quarter-to-date:

•	Total payments for services of employees

•	Exempt payments - Calculated before excluding 125/Cafeteria amounts.

•	Payments for services of more than <wage base> on a YTD basis - Calculated after excluding 125/Cafeteria amounts.

•	Total exempt payments

•	Total taxable wages

•	Gross FUTA tax (@%)

The following list reviews the summary information available for the year-to-date:

•	Total payments for services of employees

•	Exempt payments - Calculated before excluding 125/Cafeteria amounts.

•	Payments for services of more than <wage base> - Calculated after excluding 125/Cafeteria amounts.

•	Total exempt payments

•	Total taxable wages

•	Gross FUTA tax (@%)


How to Use the Form 940 Worksheet

Enter the information from the Worksheet in the appropriate space on Form 940, Employer’s Annual Federal Unemployment (FUTA) Tax Return:

Worksheet Information	Form Information
Total payments for services of employees	Part I, Line 1
Exempt payments	Part I, Line 4
Total taxable wages	Part I, Line 5
FUTA tax (@ percentage)	Part II, Line 1


Payroll Check Register

Use the Payroll Check Register to display just payroll checks (rather than all types of checks). You can see checks by W-2 periods or by a range of accounting periods that you select. You can run the report in Portrait or Landscape mode.

See Defining Options for the Payroll Check Register.


Defining Options for the Payroll Check Register

The Payroll Check Register tab of Payroll Reporting lets you define and save multiple options for printing the Payroll Check Register.

To define options for the Payroll Check Register:

1.	Select Reporting, Payroll Reports from the Deltek Advantage main menu. Deltek Advantage displays the Payroll Reporting form.

2.	Click on the Payroll Check Register tab at the top of the Payroll Reporting form. Deltek Advantage displays the available options for the Payroll Check Register.

3.	Choose the appropriate options for the report:

Orientation

Reporting Period

4.	Click on the Print, Print Preview, or Submit!JI(`Ahmain.hlp>(w95sec)',`Printing_and/or_Submitting_a_Report_from_the_Report-Specific_Tab') button to generate this report.


Orientation (Check Register)
Orientation (Payroll Check Register)

Select one of two settings:

•	Portrait—Displays, by employee, the Check Period, Posting Sequence, W-2 quarter, Direct Deposit (yes/no), Check Number, Check Date, Gross Pay Amount, Total Withholding Amount, and Net Pay Amount.

•	Landscape—In addition to all the columns listed in the Portrait version, this version includes a breakout of the Total Withholding Amount into Federal, FICA, State, 410K, 125, and Other amounts.


Reporting Period (Check Register)
Reporting Period (Payroll Check Register)

Select one of two settings:

•	W-2 Year—If you select this option to see all payroll checks for a W-2 year, you must select the year from the corresponding drop-down field.

•	Range of Periods—If you select this option to see payroll checks for a range of accounting periods, you must use the corresponding drop-down fields to select the starting period and ending period.


Payroll Utilities

The Payroll module includes several utilities that enable you to setup and maintain your payroll system. The following utilities are available:

Payroll System Setup

Open a New W-2 Quarter

Withholding Code Key Conversion

Employee Payroll History

Employee Withholding History


Opening a new W-2 Quarter

You must open a new W-2 quarter to appropriately track any data accumulated by the Payroll module. This procedure affects payroll data only; it does not affect any other Deltek Advantage data.

You perform quarterly initialization at the end of each calendar quarter. You can  print a 940 Worksheet (if necessary), 941 Worksheet, State Unemployment Worksheet, and Quarterly State Income Tax Worksheet at any time for any quarter. You must, however, open a new W-2 quarter prior to processing the first payroll in that quarter.

To open a new W-2 quarter, simply select Open a new W2 Quarter from the Utilities menu. Deltek Advantage displays a form listing the current and next applicable W-2 quarter. Then, click the OK button.

Audit Trail Implications

When you open a new W-2 Quarter, Deltek Advantage records the opening of the quarter on the Posting Log Review report. The entry appears as an AL transaction type, indicating an audit log posting. This information will be useful as an audit trail for all changes that updated your database in a specific period.


Converting Withholding Codes

You can use the Withholding Code Key Conversion utility to change an individual withholding code.

Change a withholding code.

Learn more about setting up withholding codes.


Changing a Withholding Code

To change your withholding codes:

1.	Back up your Deltek Advantage database. See Performing a Database Backup for instructions.

2.	Select Utilities, Key Conversions, Withholding Codes from the Deltek Advantage main menu. Deltek Advantage displays the Withholding Code Conversion form.

3.	Complete the fields on the Withholding Code Conversion form, referring to the context-sensitive help on the form.

4.	Click on the Change button to change the bank’s code. Deltek Advantage displays the following message:

WARNING: This process makes permanent changes to the database.

We strongly recommend that you make a backup of your database before you proceed. Are you sure you want to continue?

5.	Click on the Yes button to continue. Deltek Advantage changes the bank code throughout the system. When complete, Deltek Advantage returns you to the Bank Code Conversion form.

6.	Click on the Close button to close the Bank Code Conversion form and return to the Deltek Advantage main menu.

 Note


Entering Employee Payroll History

Note that this data tells Deltek Advantage about the payroll-related transactions that occurred during the current W-2 year, before you installed the Payroll module. This step is not necessary if you install the Payroll module at the beginning of the new W-2 year.

You use Employee Payroll History to enter wage and withholding information for each of your employees.

To enter employee payroll history:

1.	Select Utilities, History Loading, Employee Payroll History from the Deltek Advantage main menu. Deltek Advantage displays the Employee Lookup window.

2.	Select the employee for which to enter payroll history. Deltek Advantage displays the current payroll information for the employee.

Note that this information is all the payroll information posted to this employee during the current quarter and year. If you installed the Payroll module at the beginning of the year, this information is complete and you do not have to enter payroll history for this employee. However, if you installed the Payroll module at a time other than the beginning of the year, this information is incomplete and you will have to enter payroll history for the employee.

3.	Complete the fields on the Employee Payroll History form, referring to the context-sensitive help on the form.

Note that if you have posted payroll for this employee prior to entering payroll history, the hours/amounts will appear in the appropriate columns. Also note that you are entering the totals for the year and quarter. For example, if an employee has worked 320 hours this quarter and 800 this year, and the Employee Payroll History form appears as follows:

You would enter 320 for the QTD Regular Hours and 800 for the YTD Regular Hours. Note that at the 240 and 680 hours were entered through the Payroll system after the time of installation. To adjust for the current W-2 and accrual year you need to enter the adjusted hours of 320 and 800.


Entering Employee Withholding History

Employee withholding amounts are tracked automatically by Deltek Advantage. However, if you are installing Deltek Advantage with a new database (that is, not converting from another Deltek product), you will need to manually enter prior withheld amounts and wages for each employee. The Employee Payroll Withholding History form lets you enter these amounts.

To edit an employee’s withholding history:

1.	Select Utilities, History Loading, Employee Payroll History from the Deltek Advantage main menu. Deltek Advantage displays the Employee List.

2.	Select the employee for whom to enter payroll history and click OK. Deltek Advantage displays the Employee Payroll History form listing the selected employee’s existing payroll history (if any).

3.	Click on the Edit button in the Withholdings section of the Employee Payroll History form. Deltek Advantage displays the Employee Payroll Withholding History form.

4.	Complete the fields on the Employee Payroll Withholding History form, referring to the context-sensitive help on the form.

5.	Click OK to exit Employee Payroll Withholding History and return to the main Employee Payroll History form.


Magnetic Media Quarterly Processing

To complete quarterly processing using magnetic media:

1.	Select Processing, Quarterly Processing from the Magnetic Media main menu. Deltek Advantage displays the Quarterly Processing form.

2.	Select the General tab.

3.	Complete the fields on the General form, referring to the context-sensitive help on the form.

The fields that are enabled vary according to the rules for each state. The fields on the Miscellaneous tab also vary from state to state. For information about the fields that appear on the Miscellaneous tab, see your state's magnetic media quarterly wage specifications guide.

4.	Click on the Close button to exit Quarterly Processing and return to the Magnetic Media main menu.


Generating the Work File for Quarterly Processing

Once you enter the information on the Quarterly Processing form, you generate a work file, which contains a "snapshot" of all the pertinent data from the employee payroll database. Any changes made to data using the Editor affect the data in the work file only.

To create the work file, click on the Generate work file button from the Quarterly Processing form. Deltek Advantage displays a message warning you that any payroll processing for the selected year and quarter subsequent to generating the work file will not be reflected in the work file. Once the work file is generated, Deltek Advantage enables the following buttons:

•	Edit - Edit and/or print quarterly earnings for individual employees.

•	Print - Print the report for all employees in the work file not flagged on the Edit form to be excluded from quarterly processing reporting.

•	Print Preview - Print preview forms for all employees in the work file not flagged on the Edit form to be excluded from reporting.

•	Magnetic Media - Transfer the data in the work file to a disk file for magnetic media reporting.

After generating the work file, you can regenerate the work file at any time by clicking on the Generate work file button. If you do this, Deltek Advantage overwrites all information in the previously generated work file.


Magnetic Media Contact Information

If you need additional information about quarterly reporting using magnetic media, you should obtain your state’s magnetic media quarterly wage specifications guide. Locate your state’s address and telephone number(s) on the list below:

•	Alaska Department of Labor
Research and Analysis Section
P.O. Box 25513
Juneau, Alaska  99802-5513

(in Alaska) 1-800-478-2771
(907) 465-2771

•	State of Alabama
http://www.ador.state.al.us/bus.html

•	State of Arkansas

http://www.arkansas.gov/dfa/income_tax/tax_wh_forms.html

•	Magnetic Media Coordinators, MIC 15
Employment Development Department
P.O. Box 826880
Sacramento, California  94280-0001

(916) 654-6845

•	Colorado Department of Labor and Employment
Division of Employment and Training
Unemployment Insurance Wage Unit
P.O. Box 8789
Denver, Colorado  80201-8789

(Denver-metro area) (303) 603-8410
(Toll-free) 1-800-480-8299

•	Department of Revenue Services
Taxpayer Services Division
25 Sigourney Street
Hartford, Connecticut  06106-5032

(in Connecticut) 1-800-382-9463
(860) 297-5962

•	Deleware

http://www.state.de.us/revenue

•	District of Columbia

http://otr.cfo.dc.gov/otr/cwp/view.asp?a=1330&Q=594086

•	Florida Department of Labor and Employment Security
Division of Unemployment Compensation
Bureau of Tax
Caldwell Building, Room G-29
Tallahassee, Florida  32399-0217

(850) 921-3568

•	Idaho

•	Illinois

•	Indiana Department of Workforce Development
10 North Senate Avenue
Indianapolis, Indiana  46204-2277

(317) 232-3452
(317) 233-6127

•	Magnetic Media Coordinator
401 SW Topeka Boulevard
Topeka, Kansas  66603-3182

(785) 296-8857
(Fax) (785) 296-0008
(email) magco@hr.state.ks.us

•	Kentucky

•	Louisiana Department of Labor
Office of Regulatory Services
P.O. Box 94094
Baton Rouge, Louisiana  70804-9094

Attn.: Wage Record Unit, Room 346

(225) 342-2827

•	Maine Department of Labor
Bureau of Unemployment Compensation
Wage Records Unit
20 Union Street
P.O. Box 309
Augusta, Maine  04332-0309

(207) 287-6245

•	Maryland

Maryland e-file office (410) 260-7753

http://taxpros.marylandtaxes.com/guides/businesstax/withholding/w2wagedata.asp

•	Massachusetts

•	Michigan

•	Magnetic Media Unit
Department of Economic Security
390 N. Robert Street
St. Paul, Minnesota  55101

(651) 296-3667
(Fax) (651) 297-5283

•	Mississippi

•	Missouri

•	Department of Revenue
UI Contributions Bureau
P.O. Box 6339
Helena, Montana  59604-6339

(406) 444-4269

•	Department of Employment, Training and Rehabilitation
Nevada Employment Security Division
Contributions Section
500 East Third Street
Carson City, Nevada  89713-0030

(702) 687-4487

•	New Hampshire Employment Security
32 South Main Street
Concord, New Hampshire  03301-4857

(603) 224-3311
(Fax) (603) 228-4145

•	New Jersey Division of Revenue
Alternate Filings
P.O. Box 191
Trenton, New Jersey  08646-0191

(609) 633-2154
(Fax) (609) 292-5264

http://www.state.nj.us/treasury/taxation/pdf/other_forms/git-er/nj_mmr.pdf

•	New Mexico Department of Labor
Employment Security Division
P.O. Box 2281
Albuquerque, New Mexico  87103

(505) 841-8563

•	New York State Department of Taxation and Finance

Taxpayer Contact Center
W.A. Harriman Campus
Albany, NY 12227

(888) 899-8810

(518) 485-2169

(800) 972-1233 – technical magnetic media information

•	Employment Security Commission of North Carolina
Unemployment Insurance Division
P.O. Box 26504
Raleigh, North Carolina  27611

(919) 733-9600
(Fax) (919) 733-1239
(email) TAX-WR@esc.state.nc.us

•	North Dakota

•	State of Ohio

http://tax.ohio.gov/online_services/index.stm

•	Oregon Employment Department
875 Union Street NE
Rm 107
Salem, Oregon  97311-0030

(503) 947-1545

•	Commonwealth of Pennsylvania

http://www.doreservices.state.pa.us/BusinessTax/MagneticMedia.htm?revenueNav=|3639

•	Rhode Island

•	South Carolina Employment Security Commission
1550 Gadsden Street
P.O. Box 995
Columbia, South Carolina  29202

(803) 737-3080

•	South Dakota Department of Labor
Unemployment Insurance Division
420 South Roosevelt
Box 4730
Aberdeen, South Dakota  57402-4730

(605) 626-2317

•	Tennessee Department of Employment Security
P.O. Box 101
Nashville, Tennessee  37202-0101

(615) 741-3121
(Fax) (615) 741-7214

•	Texas Workforce Commission
Magnetic Media Reporting
101 East 15th Street
Room 0326
Austin, Texas  78778

(512) 463-2222

•	Utah

•	Virginia

•	Texas State Capitol, W-400
1900 Kanawha Blvd. E
Charleston, WV 25305
(304)558-8123   (Local)

http://www.revenue.gov/

•	Wisconsin Department of Revenue

Customer Service and Education Bureau

P.O. Box 8949

Madison, WI 53708-8949

Phone: (609) 266-2776

Fax: (608) 267-1030

http://www.dor.state.wi.us

•	Wyoming Department of Employment
Employment Resources Division
P.O. Box 2760
Casper, Wyoming  82602

(307) 235-3200


Current W-2 Year

Required. The current W-2 year displays. The current W-2 year is associated with the transactions generated during payroll processing. You cannot edit this field; it is established at the time of installation.

Deltek Advantage uses this year to verify that your payroll processing falls within the current W-2 year. This field is automatically updated when you open a new W-2 quarter and it is the first quarter of a new W-2 year.


Current W-2 Quarter

Required. The current W-2 quarter displays. Deltek Advantage uses the current W-2 quarter to verify that your payroll processing falls within the current quarter. You cannot edit this field; it is established at the time of installation.

This field is automatically updated when you open a new W-2 quarter.


Payroll Frequency

Required. You can establish the frequency by which you process payroll. Your choices are weekly, biweekly, semimonthly, and monthly. The default for this setup option is biweekly. These are described below:

•	Weekly – A new payroll period begins each week, on the same day of the week. There are 52 pay periods per year.

•	Biweekly – A new payroll period begins every two weeks, on the same day of the week. There are 26 pay periods per year.

•	Semimonthly – Each month has two payroll periods, generally beginning on the first and the sixteenth. There are 24 pay periods per year.

•	Monthly – The payroll period generally runs from the first day of the month to the last day of the month. There are 12 pay periods per year.

It is essential that you enter the correct information in this field. The Payroll module uses the frequency to calculate the amount of federal and state tax to withhold from employees’ paychecks as well as the overtime and secondary overtime pay rates for salaried employees.


Bank Code

Optional. Enter the bank code to be used if you are posting net payroll directly to bank. If you do not use that option, enter the bank code to associate with checks during a processing run. If no bank code is specified, Deltek Advantage does not store the detail for your checks and the checks will not appear in Bank Statement Reconciliation. You must enter a bank code if the Post net payroll directly to bank option is selected.

We recommend that you enter a bank code. For more information, see the topic titled Defining a Bank Code and Salaries Payable Account in Payroll Setup Maintenance.


Post net payroll directly to bank

Optional. Select this option if you want to post the credit amount for net payroll to the asset account associated with the specified bank code. If you have profit center reporting installed, Deltek Advantage also associates this amount with the profit center specified for the bank code.

If you do not select this option, Deltek Advantage posts the credit for net payroll to the asset account or payroll liability account defined at the Salaries Payable Account field.

If you have cash-basis reporting enabled, Deltek Advantage makes cash-basis postings to your general ledger when this option is selected.


Salaries Payable Account

Required, if you are not posting payroll directly to the bank. When you process payroll, Deltek Advantage credits this account for the amount of the net payroll (gross payroll minus withholdings).

The default for this field is 231.00, the Salaries Payable account in the Standard Chart of Accounts.

Note that if you enter the number of your main checking account in the Salaries Payable account field, Deltek Advantage lists the net payroll as a disbursement on the Cash Journal automatically.

For more information, see the topic titled Defining a Bank Code and Salaries Payable Account in Payroll Setup Maintenance.


FICA Project/Task

Required. Enter the project/task that is charged for your firm’s portion of the FICA expenses. The default for this field is project number 1.00 (General Overhead in the Standard Chart of Accounts), task number 000.


FICA Account

Required. Enter the account that is debited during payroll processing for your firm’s portion of the FICA expenses. The default for this field is account 721.00 the employer’s FICA account.


Bonus Cost Project/Task

Required. Enter the project/task that is charged for your bonus cost expenses. The default for this field is project number 1.00, task number 000.


Bonus Cost Account

Required. Enter the account that is debited during payroll processing for your bonus payroll expenses. The default for this field is account 703.00, the Job Cost Variance account, but you may enter any Balance Sheet, Indirect Expense, or Other Charges account.


Other Pay Cost Project/Task

Required. Enter the project/task that is charged for your other pay cost expenses. The default for this field is project number 1.00, task number 000. This project/task field is used for regular payroll, bonus payroll, and adjustments.


Other Pay Cost Account

Required. Enter the account that is debited during payroll processing for your other pay expenses. The default for this field is account 703.00, the Job Cost Variance account, but you may enter any Balance Sheet, Indirect Expense, or Other Charges account.

This account field is used for other, non-bonus pay, such as car allowance.


Payroll Check Template

Required. Enter the check template to use when printing your employee paychecks. The default templates are:

•	CanDDMM — This template is for use in Canada. Select this template for a day, month, year format.

•	CanDDMMp — This template is for use in Canada. This template is the same as the CanDDMM template, except it prints the date format under the corresponding date digits on the check. This is useful if your check stock does not come pre-printed with the date format.

•	CanMMDD — This template is for use in Canada. Select this template for a month, day, year format.

•	CanMMDDp — This template is for use in Canada. This template is the same as the CanMMDD template, except it prints the date format under the corresponding date digits on the check. This is useful if your check stock does not come pre-printed with the date format.

•	CanYYMM — This template is for use in Canada. Select this template for a year, month day format.

•	CanYYMMp — This template is for use in Canada. This template is the same as the CanYYMM template, except it prints the date format under the corresponding date digits on the check. This is useful if your check stock does not come pre-printed with the date format.

•	Default – The default check template that is included with Advantage.

•	NoSSN – This template is similar to the default template but it does not print the employee’s social security number.

Contact your Deltek Advantage Support Representative for more information on check templates.


Direct deposit for bonus/adjustments

Optional. Select this option to use the Direct Deposit feature for bonuses and adjustments. This option is unselected by default.


Allow changes to payroll history

Optional. Select this option to allow changes to payroll history. If you select this option, Deltek Advantage gives you access to Employee Payroll History data after installation. We suggest that you deselect this option after installing Deltek Advantage to prevent the accidental alteration of data.


Code

Required. Specify the withholding code, using up to ten alphanumeric characters. This code appears on the printed check.


Description

Required. Enter a name for the withholding using up to 40 characters.


Credit account

Required. Identify the liability (or asset) account to credit for amounts withheld (for example, the FICA Payable account or the Federal Withholding account). When you process payroll, the account entered in this field receives the appropriate credit.


Type

Required. Identify the type of withholding. Your choices are: Federal, FICA-HI, FICA-OASDI, State, Local, 401(k), Cafeteria, Other.

For more information on the different types of withholdings, see Withholding Types.

If you select State or Local, the Locale field becomes enabled.


Method

Required. Specify the method for Deltek Advantage to use to calculate the withholding. You can enter one of the following options or leave this field blank:

•	Amount - Tells Deltek Advantage that a specified amount should be withheld from the employees’ wages each payroll period for this withholding. You enter the amount in the Amount/percent field.

We recommend that you set up a firmwide amount only if all or most of your employees have the same amount withheld. Medical insurance premiums can often be handled in this way.

•	Percentage - Tells Deltek Advantage that a specified percentage of the employees’ wages should be withheld each payroll period. You enter the percentage in the Amount/percent field.

We recommend that you set up a firmwide percentage only if all or most of your employees have the same percentage withheld.

•	System - Tells Deltek Advantage to use the tax table set up for the withholding. You can only indicate this method for withholdings that have tax tables defined.

If this is a State or Local withholding and you selected the system method for calculating this withholding, Deltek Advantage disables the following fields:

•	Exclude 401(k) amounts.

•	Exclude cafeteria plan amounts.

•	Print withholding amount on W-2 statement.

•	Reset limit at time of W-2 initialization.

•	None - Tells Deltek Advantage that no firmwide method of calculation should be used. Instead, calculations should be made on an employee-by-employee basis, as specified using Employee Payroll Withholding Table Maintenance.

If you leave this field blank, Deltek Advantage assumes this method.


Locale

Required, if you selected State or Local for the withholding type. Select the tax table to use when calculating this withholding.

Note that if you selected Federal as the withholding type, Deltek Advantage displays FE in this field. You cannot change this setting for federal withholdings.


Amount/percent

Required, if you specified Amount or Percentage for the Method. Enter the amount or percent to be used when calculating this withholding.

When you use Employee Payroll Withholding Table Maintenance to enter withholding information for individual employees, you can override the system-level method used for calculating a withholding by specifying an amount or percentage to be used for the employee.


Wage base

Required, for FICA-OASDI, 401(k), 125/Cafeteria, and Other withholdings only.

Enter the limit on the employee’s wages above which this withholding is not applied. For example, if you enter 20,000 in this field, the percentage or specified amount of wages is no longer withheld once the gross pay reaches this amount. If the year-to-date gross pay is $19,000 before the current payroll run, and the current gross pay is $2,000, the withholding is applied to the first $1,000 only.

For FICA-OASDI, you do not have to enter a wage base when using the System method to calculate the withholding.


Default withholding for new employees

Optional. Select this option if you want Deltek Advantage to automatically set up this withholding for all new employees. The default for this option is to not set up the withholding as a default.

Adding a new default withholding for existing employees must be done on an individual basis via Employee Payroll Withholding Table Maintenance.

Note that if you select this option, you can still use Employee Payroll Withholding Table Maintenance to suppress or delete the withholding for an employee.


Suppress when processing payroll

Optional. Select this option if you want Deltek Advantage to suppress this withholding during any subsequent payroll processing operations. The default for this option is to not suppress this withholding during payroll processing.

Note that suppressing also stops the tracking of ‘applicable’ or ‘gross pay basis’ wages.


Exclude 401(k) amounts

Optional. This option is enabled if you selected FICA-HI, FICA-OASDI, 401(k), 125/Cafeteria or Other for the withholding type. This option is also enabled when you select a withholding type that has a tax table (that is, State, Federal, or Local) and specify Amount or Percentage for the Method.

Select this option if you want Deltek Advantage to consider wages subject to this withholding as gross pay less any 401(k) deductions. If you do not select this option, Deltek Advantage considers wages subject to this withholding as gross pay including any 401(k) deductions.

Exclusion of 401(k) amounts also applies to the wage base if you enter one.


Exclude cafeteria plan amounts
Exclude 125/Cafeteria plan amounts

Optional. This option is enabled if you selected FICA-HI, FICA-OASDI, 401(k), 125/Cafeteria or Other for the withholding type. This option is also enabled when you select a withholding type that has a tax table (State, Federal, or Local) and you specify Amount or Percentage for the Method.

Select this option if you want Advantage to consider wages subject to this withholding as gross pay less any 125/Cafeteria deductions. If you do not select this option, Deltek Advantage considers wages subject to this withholding as gross pay including any 125/Cafeteria deductions.

Exclusion of 125/Cafeteria amounts also applies to the wage base, if you enter one.


Exclude Specific 125/Cafeteria contributions

Select this option if you want Advantage to consider wages subject to this withholding as gross pay less specific 125/Cafeteria deductions. If you select this option, Advantage displays a list box with all of the 125/Cafeteria contributions so that you can select the one to be excluded.


Print withholding amount on W-2 statement

Optional. This option is enabled if you selected FICA-HI, FICA-OASDI, 401(k), 125/Cafeteria or Other for the withholding type. This option is also enabled when you select a withholding type that has a tax table (that is, State, Federal, or Local) and specify Amount or Percentage for the Method.

Select this option if you want Deltek Advantage to print the withheld amount in a general information box on the W-2 form for any employee using this withholding. You can print up to three withholdings in this type of box. (If an employee has more than three withholdings to print in this box, Deltek Advantage only prints the first three it encounters for the employee.)

If you do not select this option, Deltek Advantage does not print the withholding information in the general information box on the W-2 form (this is the default).


Reset limit at time of W-2 initialization

Optional. This option is enabled if you selected FICA-HI, FICA-OASDI, 401(k), 125/Cafeteria or Other for the withholding type. This option is also enabled when you select a withholding type that has a tax table (that is, State, Federal, or Local) and specify Amount or Percentage for the Method.

Select this option if you want Deltek Advantage to reset the amount withheld against any limit set up for the employee at the time of the W-2 year initialization. If you do not select this option, Deltek Advantage does not reset the amount withheld against any limit at the time of the W-2 year initialization and continues to withhold the amount or percentage until the specified limit is reached.

This field allows limits set up for employees to automatically be restarted at the beginning of a new W-2 year.


Default withholding amount to zero for bonus payroll

Optional. Select this option if you do not want this withholding to be automatically computed for bonus payrolls. Note that you can still enter an override amount at the employee level through Employee Review during the setup for payroll processing.

If you do not select this option, Deltek Advantage automatically computes this withholding for employees during bonus payrolls (this is the default).

For example, assume an employee’s withholdings are Federal, State, 401(k), and Health Insurance. When you run a bonus payroll for this employee, you may want to withhold Federal, State, and 401(k) amounts, but you would generally not want to withhold Health Insurance for the employee. To do this, select this option for the Health Insurance code but do not select this option for Federal, State, and 401(k) withholdings.


ADP Labor Code Mask

Required. A mask identifies which labor codes you define for special processing. Each mask can contain one or more wild cards (or none at all):

•	If your database is JET, a wild card is represented by a question mark (?).

•	If your database is SQL Server, a wild card is represented by an underscore (_).

If, for example, you are billing labor to an architectural project (denoted by the letter A) for premium overtime (denoted by the letter B) using Jet, your entry in this field might be AB??. Note that the wildcard characters must be in the same positions for every labor code you create. In this example, all subsequent labor codes must include wild cards in the third and fourth positions.


Regular Hours Code

Required. Enter the codes for processing special tasks during regular work hours. Contact your ADP representative for the appropriate codes to enter in this field.


Regular Hours Field ID

Required. These standard ADP codes represent buckets (storage files) where Deltek Advantage stores regular hours entered for special tasks. Contact your ADP representative for the appropriate bucket in which to enter these hours.


Overtime Hours Code

Required. Enter the codes for processing special tasks during overtime work hours. Contact your ADP representative for the appropriate codes to enter in this field.


Overtime Hours Field ID

Required. These standard ADP codes represent buckets (storage files) where Deltek Advantage stores overtime hours entered for special tasks. Contact your ADP representative for the appropriate bucket in which to enter these hours.


Employee Number

If you choose to sort the Employee reports by employee number, Deltek Advantage sorts the Time Analysis and Employee List reports by ascending employee number (for example, number 00001, 00002, 00003, etc.).


Last Name

If you choose to sort the reports by last name, Deltek Advantage sorts your payroll reports alphabetically by the last name (for example, Apple, Bartlett, Harper, Shuman).


Status

If you choose to sort the reports by status, Deltek Advantage groups employees by status on your payroll reports


Select Codes

If you choose to sort the reports by a user-defined select code (for example, qualifications, affiliations, department, etc.), Deltek Advantage groups employees by the select code defined.


Other Pay

In Employee Payroll Table Maintenance, enter any additional pay amount that should be added to the employee’s normal pay amount each period. This amount can be due to overseas allowances, commissions, etc.

In Payroll Processing - Employee Review, enter any additional pay amount that should be added to the employee’s normal pay amount for this payroll processing run.


Check Date

The date that Deltek Advantage will print on all checks produced during this processing run. The current date is the default.

In Payroll Processing, this date appears as part of the heading of the Payroll Journal, the transaction date for any payroll transactions on the General Ledger Account Analysis or the Cash Journal.


Payroll Date

For Payroll Processing, the date on which the payroll period ended. This date will usually be the same as the check date, unless your payroll period ended on Friday but you do not run payroll until the following Monday. The current date is the default.


Sorting checks by employee number

Click on the Employee Number option to sort the checks processed through Payroll Processing by employee number.


Sorting checks by employee name

Click on the Employee Name option to sort the checks processed through Payroll Processing by employee name.


Auto selection criteria - profit center

To select employees for a Payroll Processing session based on profit center, click on the drop-down arrow in the Profit Center field and select the profit center on which to select employees.

If you enter a value for more than one auto selection, Deltek Advantage only includes employees that meet all of the selection criteria.


Auto selection criteria - employee select codes

To select employees for a Payroll Processing session based on an employee select code value, click on the drop-down arrow in the select code field to select the appropriate select code and then click on the drop-down arrow in the value column and select the value on which to select employees.

If you enter a value for more than one auto selection, Deltek Advantage only includes employees that meet all of the selection criteria.

Deltek Advantage saves your auto selections for the run across Deltek Advantage sessions.


Row-level security for Payroll Reports

If row-level security is implemented for your security workgroup, you can generate Payroll reports for employees in all profit centers to which your security workgroup has rights to view/modify.

If you manually enter an employee number (on the Selection tab of Payroll Reporting) that your security workgroup does not have access to, Deltek Advantage displays the following message:

Employee <employee number> does not exist or you do not have access.

In addition, lookups on the Selection tab of Payroll Reporting will only display the employees to which your workgroup has access.


Withholding Codes

Required, if you are changing a withholding code. Highlight the withholding whose code you want to change. This box lists all of the withholding codes in your database.


New Code

Required, if you are changing a withholding code. Enter the new withholding code.


Employee

Required. Enter the number of the employee for whom you want to specify payroll history. Double-click in this field to retrieve a list of employees defined in your database.

An employee must be set up in Employee Table Maintenance before you can enter history for the employee.


QTD Regular Hours

The total regular hours worked by the employee during the current W-2 quarter.


QTD Overtime Hours

The total overtime hours worked by the employee during the current W-2 quarter.


QTD Regular Pay

The total regular pay received by this employee during the current W-2 quarter.


QTD Overtime Pay

The total overtime pay received by this employee during the current W-2 quarter.


QTD Other Pay

The total other pay received by this employee during the current W-2 quarter.


YTD Regular Hours

The total regular hours worked by the employee during the current W-2 year.


YTD Overtime Hours

The total overtime hours worked by the employee during the current W-2 year.


YTD Regular Pay

The total regular pay received by this employee during the current W-2 year.


YTD Overtime Pay

The total overtime pay received by this employee during the current W-2 year.


YTD Other Pay

The total other pay received by this employee during the current W-2 year.


Code

Deltek Advantage displays the withholding code for reference purposes only.


QTD Withheld

Enter the quarter-to-date withheld amount for this employee withholding code.


YTD Withheld

Enter the year-to-date withheld amount for this employee withholding code.


QTD Wages

Enter the quarter-to-wages withheld amount for this employee.


YTD Wages

Enter the year-to-wages withheld amount for this employee.


Beginning of W-2 Year

This is the easiest time to install the Payroll module because you do not need to enter any payroll history information. You must install the Payroll module prior to your first payroll of the new W-2 year.

The quarter-to-date and year-to-date amounts all begin at zero.


Beginning of W-2 Quarter

This is the next best option because you only need to enter the previous quarter(s) amounts as year-to-date history. You must install the Payroll module before your first payroll of the new W-2 quarter.

You must be sure to enter previous quarter(s) amounts as year-to-date amounts correctly so the amounts are accumulated correctly during the year.


Middle of W-2 Quarter or any other time during the W-2 Year

This is the least attractive of the options because you have to enter both year-to-date amounts and current quarter amounts as history.

You must be sure to enter both the year-to-date amounts and the current quarter amounts correctly so the amounts are accumulated correctly during the year.

If you install the Payroll module after timesheets have been posted for the current payroll period, the payroll system will not include those hours in the first regular payroll run processed after installation. When you process your first regular payroll after installation, you will need to use the Manual Select mode to enter pay hours for all employees.


Timesheet Hours

All of the posted hours that the employee reported on his/her timesheet since the last regular payroll processing run that included the employee.


Pay Hours

When you first enter a payroll processing session, an employee's pay hours are equal to the employee's timesheet hours. Under the following conditions, you must modify these hours:

•	When you set up payroll after running a processing session that extends beyond the standard pay period.

•	When you run payroll early. You must modify hours for the current and subsequent pay periods.


Payroll-Related Account Categories

Balance Sheet (usually liabilities)

•	Salaries Payable (231.00): You may post the net payroll to a bank code that is associated with a checking account number so that it will appear as a cash disbursement on the Cash Journal. (In this case, no liability is incurred for salaries payable since the checking account is an asset.)

•	FICA Payable (232.00)

•	Federal Withholding (233.00)

•	State Withholding (234.00): You need a State Withholding account only if your employees are subject to a state tax.

•	Other Withholding (239.00): You may need a number of different accounts for additional withholdings. For example, a Health Care Insurance Withholding account or a 401(k) Withholding account.

•	Bonus Cost and Other Pay Cost accounts

Indirect Expenses

•	Employer’s FICA Tax (721.00)

•	Job Cost Variance (703.00)

•	Bonus Cost and Other Pay Cost accounts

Below the Line Accounts

•	Bonus Cost and Other Pay Cost accounts


Changing Accounts in Setup Maintenance

You can modify the following accounts in Payroll Setup Maintenance:

•	Salaries Payable

•	Employer's FICA Expense

•	Bonus Cost

•	Other Pay Cost

You can modify the following accounts in Withholding Code Table Maintenance:

•	Federal Payable

•	FICA Payable


Federal Withholding Type

Deltek Advantage calculates the federal tax withholding according to tax tables that are built into the Payroll module. The tax tables are based on those that appear in IRS publications: they are based on an employee’s wages, filing status, exemptions, etc.

The Payroll module comes with a federal tax withholding already set up and current federal tax tables already in place. If tax tables change in the future, we will notify you when the new tax tables are available.

For further information, see Tax Calculations.


FICA-HI Withholding Type

To calculate an employee’s FICA-HI withholdings for the pay period, Deltek Advantage multiplies the employee’s gross pay for the pay period by the FICA-HI percentage.

This withholding uses the System method for calculating the withholding. The System method uses an internal table to obtain the employee’s and employer’s percentage.

When the employee’s year-to-date gross pay reaches the FICA-HI wage base, no more FICA-HI tax is withheld. The Payroll module comes with the current year’s FICA-HI percentage and FICA-HI limit already in place.

For further information, see Tax Calculations.


FICA-OASDI Withholding Type

To calculate an employee’s FICA-OASDI withholdings for the pay period, Deltek Advantage multiplies the employee’s gross pay for the pay period by the FICA-OASDI percentage.

This withholding uses the System method for calculating the withholding. The System method uses an internal table to obtain the employee’s and employer’s percentage and a wage base for each component.

When the employee’s year-to-date gross pay reaches the FICA-OASDI wage base, no more FICA-OASDI tax is withheld. The Payroll module comes with the current year’s FICA-OASDI percentage and FICA-OASDI limit already in place.

For further information, see Tax Calculations.


State Withholding Type

Deltek Advantage calculates state tax according to built-in tax tables exactly the way it calculates federal tax. If your state does not have a state tax, you do not need to set up a state tax withholding.

For further information, see Deltek Advantage Tax Facts.


Local Withholding Type

Deltek Advantage comes with several local tax tables. These tax tables work in the same way as federal and state tax tables.

If an employee is subject to a local tax other than those built into Deltek Advantage, you can set up a local tax withholding that withholds a fixed amount or a percentage of gross pay each pay period.

For further information, see Deltek Advantage Tax Facts.


401(k) Withholding Type

A 401(k) is a tax-deferred compensation plan in which contributions are not taxed until they are withdrawn (usually after retirement). Therefore, Deltek Advantage deducts a 401(k) contribution from an employee’s gross pay before calculating federal and most state and local tax withholdings. Any 401(k) amount withheld is automatically printed on the W-2 Form.


125 Cafeteria Withholding Type

A 125/Cafeteria withholding allows an employee to select from a menu of benefits. The 125/Cafeteria withholding works the same way as the 401(k) withholding, except 125/Cafeteria plans are not subject to FICA withholdings.

(Some states do not allow 401(k) and/or 125/Cafeteria contributions to be deducted from gross pay for the purpose of calculating state income tax. If your state belongs to this group, Deltek Advantage calculates the state tax before deducting 401(k) and 125/Cafeteria contributions.)


Other Withholding Type

Any other tax/non-tax withholdings that do not fit in to the above listed elements, including medical insurance, charities, and savings plans are listed as other withholdings. These can be calculated in one of the following two ways: a fixed amount can be withheld from the employee’s wages each pay period, or a percentage of the employee’s gross wages can be withheld each pay period.


Pay Rate

Enter the pay rate for this employee for the payroll period. You specify the payroll period in Payroll Setup Maintenance.

If your pay rate and type are identical to the employee’s job cost rate and type (and the employee receives no bonus or other supplemental payments), there will be no variance in the Job Costing account for that employee (unless you have bonus or supplemental pay amounts).


Type

Enter the type for the pay rate you entered. You can specify hourly or salary.

If your pay rate and type are identical to the employee’s job cost rate and type (and the employee receives no bonus or other supplemental payments), there will be no variance in the Job Costing account for that employee (unless you have bonus or supplemental pay amounts).


Overtime Pct

Enter the percentage applied to the employee's pay rate to calculate overtime wages. You usually specify one of the following options.

•	0% = No pay for overtime hours.

•	100% = Straight-time pay for overtime hours.

•	150% = Time-and-a-half pay for overtime hours.

For hourly employees, Deltek Advantage calculates overtime pay using the following equation:

Overtime pay = (Overtime Hours) * (Pay Rate) * (Overtime Percentage)

For salaried employees, Deltek Advantage calculates overtime pay using the following equation:

Overtime pay = Ovt Hours * Ovt Pct * [(Pay Rate * # of pay periods in a year) / 2080]


Other Pay

Enter any additional pay amount that should be added to the employee’s normal pay amount each period. This amount can be due to overseas allowances, commissions, etc.


ADP File Number

This number defaults from the code that appears in the Employee field at the top of the form. Because this number has to consist of six digits for ADP, whenever you enter a file number that is fewer than six digits, Deltek Advantage automatically adds the necessary number of leading zeroes to complete this employee code. This is a required field.

ADP fields allow you to associate each employee with your company and rate codes for ADP Export Processing. If Payroll is turned off in Utilities, Module Installation, only the ADP fields are available on the Payroll tab in Employee Table Maintenance.


ADP Company Code

This code enables ADP to associate the employee specified with your company. Your company provides ADP with this code. This is an optional field.

ADP fields allow you to associate each employee with your company and rate codes for ADP Export Processing. If Payroll is turned off in Utilities, Module Installation, only the ADP fields are available on the Payroll tab in Employee Table Maintenance.


ADP Rate Code

This code indicates the employee’s pay rate (hourly or salary). ADP provides the standard rate code. This is an optional field.

ADP fields allow you to associate each employee with your company and rate codes for ADP Export Processing. If Payroll is turned off in Utilities, Module Installation, only the ADP fields are available on the Payroll tab in Employee Table Maintenance.


Employee No (Withholding)

The employee number for which you are entering payroll information appears. You cannot modify this information.


Name (Withholding)

The first and last name of the employee for whom you are entering payroll information appears. You cannot modify this information.


Withholding Code

Specify the withholding code(s) to apply to this employee.


Method

Specify the method for Deltek Advantage to use to calculate the withholding. You can enter one of the following options or leave this field blank:

•	Amount - Tells Deltek Advantage that a specified amount should be withheld from the employees’ wages each payroll period for this withholding. You enter the amount in the Amount/percent field.

We recommend that you set up a firmwide amount only if all or most of your employees have the same amount withheld. Medical insurance premiums can often be handled in this way.

•	Percentage - Tells Deltek Advantage that a specified percentage of the employees’ wages should be withheld each payroll period. You enter the percentage in the Amount/percent field.

We recommend that you set up a firmwide percentage only if all or most of your employees have the same percentage withheld.

•	System - Tells Deltek Advantage to use the tax table set up for the withholding. You can only indicate this method for withholdings that have tax tables defined.

If this is a State or Local withholding and you selected the system method for calculating this withholding, Deltek Advantage disables the following fields:

•	Exclude 401(k) amounts.

•	Exclude cafeteria plan amounts.

•	Print withholding amount on W-2 statement.

•	Reset limit at time of W-2 initialization.

•	None - Tells Deltek Advantage that no firmwide method of calculation should be used. Instead, calculations should be made on an employee-by-employee basis, as specified using Employee Payroll Withholding Table Maintenance.

If you leave this field blank, Deltek Advantage assumes this method.


Suppress

Select this option if you want to suppress the withholding for the employee during payroll processing. Note that this selection discontinues the tracking of the associated pay basis, which is important for tax withholdings. To withhold an amount of zero, specify zero in the Amount/Percent field.


Filing Status

Select the employee’s filing status for tax-based withholdings. When you enter a withholding code, Deltek Advantage generates a list of the applicable filing statuses. Consult the associated Deltek Advantage Tax Facts sheet for more information.


Exemptions

Enter the number of exemptions claimed by this employee, if applicable. Consult the associated Deltek Advantage Tax Facts sheet for more information.


Additional Amount

Specify an amount to be withheld in addition to the amount automatically computed by Deltek Advantage, if desired. A common use of this amount is to supplement federal or state withholding amounts to guard against under withholding or to make up for any over/under withholding during prior payrolls.


Other Exemptions

This field is used for other exemptions (Exemptions -2), if the state or locality has more than one exemption type. The actual meaning of this field varies. Consult the associated Tax Fact Sheet for more information.


Limit

Enter a limit for this withholding. This value should be a dollar amount. After the employee reaches this limit, no more money will be withheld.


Bank ID

Enter an identification code for the bank where the deposit will be made, using up to eight numeric characters. You should not use punctuation in the identification code.

If the employee’s Bank ID is nine digits long, enter only the first eight digits (the ninth digit is calculated by Deltek Advantage).


Account Number

Enter the employee's account number at the bank where the deposit will be made, using up to 17 characters.


Account Type

Use the drop-down arrow in this field to select the employee's bank account type. Your choices are Checking or Savings. The default for this field is Checking.


Payroll Method

To deposit an employee’s entire paycheck to a single account, leave the Payroll Method field blank. Advantage assumes that the full amount is applied to this account.

For all other direct deposits, select one of the following options:

•	Percentage — Advantage allocates a specified percentage of the employee’s net pay each pay period to the specified account. You enter the percentage in the Payroll Amount/Percent field.

•	Amount — Advantage allocates a specified amount of the employee’s net pay each pay period to the specified account. You enter the amount in the Payroll Amount/Percent field.

•	None — Advantage does not allocate any portion of the employee’s net pay to this account.


Payroll Amount/Percent

To deposit an employee’s entire paycheck to a single account, leave the Payroll Amount/Percent field blank. Advantage assumes that the full amount is applied to this account.

For all other direct deposits, enter a percentage or an amount in this field.

•	Percentage — When you enter a percentage, Advantage allocates the specified percentage of the employee’s net pay to the specified account. Note that you must also select Percentage in the Payroll Method field.

•	Amount — When you enter an amount, Advantage allocates the specified amount of the employee’s net pay to the specified account. Note that you must also select Amount in the Payroll Method field.


Employee Reimbursement Method

To deposit an employee’s entire expense reimbursement to a single account, leave the Employee Reimbursement Method field blank. Advantage assumes that the full amountis applied to this account.

For all other direct deposits, select one of the following options:

•	Percentage — Advantage allocates a specified percentage of the employee’s expense reimbursement to the specified account. You enter the percentage in the Employee Reimbursement Amount/Percent field.

•	Amount — Advantage allocates a specified amount of the employee’s expense reimbursement to the specified account. You enter the amount in the Employee Reimbursement Amount/Percent field.

•	None — Advantage does not allocate any portion of the employee’s expense reimbursement to this account.


Employee Reimbursement Amount/Percent

To deposit an employee’s entire expense reimbursement to a single account, leave the Employee Reimbursement Amount/Percent field blank. Advantage assumes that the full amount is applied to this account.

For all other direct deposits, enter a percentage or an amount in this field.

•	Percentage — When you enter a percentage, Advantage allocates the specified percentage of the employee’s total expense reimbursement to the specified account. Note that you must also select Percentage in the Employee Reimbursement Method field.

•	Amount — When you enter an amount, Advantage allocates the specified amount of the employee’s total expense reimbursement to the specified account. Note that you must also select Amount in the Employee Reimbursement Method field.


Status

Enter the appropriate status for this account:

•	Add — Indicates that you want to initiate the pre-notification step for this account during the next regular Payroll Processing run or Employee Advances and Expenses Processing run.

•	Wait — After you process Payroll or Employee Advances and Expenses 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 — Indicates that direct deposit transactions to this account have been approved by your bank.

The Status field governs both payroll direct deposit and expense payments direct deposit, if both features are being used. Therefore, if an account is Active for payroll direct deposit processing, it is also Active for expense payments direct deposit processing.


W-2 Year

Select the W-2 year for which to generate this report.


W-2 Quarter

Select the W-2 quarter for which to generate this report.


Report Format

This option determines how data is presented on the Form 940 Worksheet. From the drop-down list, select a format:

•	QTD/YTD—Presents quarter-to-date and year-to-date gross pay, 125/Cafeteria contributions, and total wages subject to tax for each employee on the report.

•	Current/QTD—Presents current accounting period and quarter-to-date gross pay, 125/Cafeteria contributions, and total wages subject to tax for each employee on the report.

•	Current/YTD—Presents current accounting period and year-to-date gross pay, 125/Cafeteria contributions, and total wages subject to tax for each employee on the report.


Report Basis

Select the time period for which data is presented on the Form 941 Worksheet:

•	W2 Quarter

•	Current Period


Specific withholding code

If you want to generate the Withholdings by Category Report for a specific withholding code, specify that code in this field.


Wage Base

Specify the annual wages per employee that are subject to SUI tax.


Percentage

Specify the SUI tax percentage to be applied to the taxable wages.


State

Select the state for which to print the State Unemployment Insurance Worksheet.

If you enter a specific state in the State field on the Options tab and the state does not have a withholding set up, Deltek Advantage will not generate this report. If this occurs, delete the state abbreviation appearing in the State field on the Options tab and run the report again.


Exclude 401(k) contributions

Select this option if 401(k) contributions should be excluded from the wages subject to tax.


Exclude 125/Cafeteria contributions

Select this option if 125/Cafeteria contributions should be excluded from the wages subject to tax.


Include Current Period

Select this option to include payroll data for the current accounting period.


Specific tax locale

If you want to generate the State/Local Income Tax Worksheet for a specific tax state/locality, specify that state/locality in this field.


Wage Base 940

Specify the annual wages per employee that are subject to FUTA tax.


Percentage 940

Specify the FUTA tax percentage to be applied to the taxable wages. The format for the percentage field is xxx.xxx.


State

Select the processing state for quarterly reporting. This field includes a drop-down menu from which you can make your selection.


Processing Year

Select the year for quarterly reporting. This field includes a drop-down menu from which you can make your selection.


Processing Quarter

Enter the quarter for quarterly reporting. This field includes a drop-down menu from which you can make your selection.


Employer's identification number (EIN)

The employer’s federal identification number. Deltek Advantage automatically formats the number that you enter.

The federal government assigns your company this number. If you do not know your company’s EIN number, contact the general help desk at the IRS.


State U. I. Account Number

The employer’s unemployment insurance account number. The state assigns your company this number.


Address line 1

Enter the first line of the employer’s address.


Address line 2

Enter the second line of the employer’s address.


City

Enter the city of the employer’s address.


State

Enter the state of the employer’s address.


ZIP

Enter the ZIP code of the employer’s address.


Wage Base

Enter the wage base limit, if any, on which the state unemployment insurance tax can be calculated. This figure applies to the annual – not quarterly – maximum.


S. S. Wage Base

Enter the wage base limit on which the Social Security tax is to be calculated. This figure applies to any annual – not quarterly – maximum.


Exclude 401K
Exclude 401(k)

To exclude 401K withholdings from state unemployment insurance total gross wages, select this option.


Exclude 125
Exclude Cafeteria

To exclude Cafeteria withholdings from state unemployment insurance total gross wages, select this option.


Transmitter Contact

Enter the name of the individual who is responsible for the accuracy of the quarterly report.


Transmitter Contact Title

Enter the title of the individual who is responsible for the accuracy of the quarterly report.


Telephone Number

Enter the telephone number of the individual who is responsible for the accuracy of the quarterly report.


Telephone Extension/Box

Enter the telephone extension or box number of the individual who is responsible for the quarterly report.


Return Tape To
Return Diskette To

Enter the name of the individual to whom the diskette should be returned.


Include Employees Specific to Processing State

To include only those employees who have state withholdings specific to the processing state on the quarterly report, select this option.


Run Type:  Regular

Enables you to process regular, current period payroll for all or selected employees.


Run Type:  Adjustments

Enables you to adjust gross pay, withholdings, regular hours, overtime pay hours, secondary overtime hours, and accrued benefit hours for selected employees. You can also use this type of payroll processing to do the following:

•	Correct your payroll database after over- or under-paying an employee.

•	Void a payroll check.


Run Type:  Bonus

Enables you to process bonuses for selected employees. This type of payroll processing requires, at a minimum, entry of the gross bonus amount for each employee.


Immediate Destination Number

Enter the identification number of the bank to which the direct deposit file will be sent.


Immediate Destination Name

Enter the name of the bank to which the direct deposit file will be sent.


Immediate Origin Number

Enter your company identification number as given to you by the bank.


Immediate Origin Name

Enter your company name.


Credits Only

Select this option if you want Deltek Advantage to generate a file containing only the credit entries (that is, the individual employee entries) for the direct deposit processing run.

This option is selected by default.


Credits and Debit

Select this option if you want Deltek Advantage to generate a file containing the credit entries (that is, the individual employee entries) and the debit entry to the company account for the total amount of the direct deposit processing run.

When you select this option, the Account Number and Account Type fields are enabled. Use these fields to enter the debit account information.


Company Name

Enter the name of your company, as you want it to appear on statements.


Company ID

Enter your nine-digit IRS Employee Identification Number (EIN). Or, enter a number based on the Data Universal Numbering System (DUNS) or a user assigned value.

If you enter a DUNS or user assigned number, you must change the qualifier in the Identification Code Designator (ICD) field in the Advanced Options section of this form, as appropriate.


Routing Number

Enter the eight-digit routing transit number assigned to your company.

If this routing number has nine digits, enter the first eight digits only. Deltek Advantage calculates the ninth digit.


Entry Description

Enter a description/purpose for this entry using up to ten characters. For example, you may enter Payroll or Reg Salary.


Account Number

Enter the company bank account number from which payment for the total amount of the direct deposit will be made. You can enter up to 17 numeric characters in this field.

This field is enabled only when you select the Credits and Debit file format option.


Account Type

Use the drop-down arrow in this field to select the account type for the company account entered in the Account Number field. Your options are Checking or Savings.

This field is enabled only when you select the Credits and Debit file format option.


Effective Entry Date

Enter the date on which entries are to be posted to employee accounts.

This field assumes no default value and must be specified prior to processing the file.


Output File Name

Specify the path and filename for the direct deposit file. The default for this field is a file named DIRDEP.TXT, located in the current default directory.

If you entered a bank code in Payroll Setup Maintenance, the information in the Output File Name field also appears in the Payroll File Name field on the Bank Codes Setup form.


Advanced Setup Options

Click on the Advanced Options button to display additional setup options for direct deposit processing. When you click on this button, the bottom portion of the Direct Deposit Processing form expands to display the additional setup options.

The additional setup options are:

Identification Code Designator (ICD)

Use the drop-down arrow in this field to enter a character that will be used to qualify the entry in the Company ID field. The ICD value is placed in byte 41 of the company/batch header record and in byte 45 of the company/batch control record, each of which precedes the Company ID value in the respective record. Predefined values for the ICD field are:

•	1 − IRS Employer Identification Number (EIN)

•	3 − Data Universal Numbering System (DUNS)

•	9 − User Assigned Number.

The default setting for this field is 1.

File Header Byte 4 Character

Enter a value in this field to be placed in byte 4 of the file header record, which is the first character in the space reserved for the value entered in the Immediate Destination Number field.

The default for this field is a blank character.

File Padding

Select this option to add dummy records (all 9s) to the direct deposit processing file, after the file control record, to force the total record count to be a multiple of 10 (if not already the case at the end of processing).

This option is selected by default.

Separate Batches for Credits and Debit

Select this option if you want Deltek Advantage to place the debit entry to the company account in a separate batch from the credit entries. If you do not select this option, Deltek Advantage will place the debit entry to the company account at the end of the batch containing the credit entries.

This option is enabled only when the Credits and Debit file format option is selected.

This option is deselected by default.

Restore Defaults

Click on the Restore Defaults button to reset the advanced setup options to their default values. Note that this button will restore the system defaults even if you use the Bank Codes Setup form to modify the advanced setup options.


Processing W-2 Year

Enter the W-2 processing year for which you want to generate W-2 forms. This defaults to the current W-2 year. If you are processing a prior W-2 year, select the appropriate year from the drop-down list.


Employer's Name

Your firm’s name (as entered in General System Setup Maintenance) appears for reference purposes only.


Employer's Address

Enter your firm’s address. The address appears in Box C of the W-2 form.


Social Security wage base

Enter the maximum taxable Social Security wages for the selected W-2 processing year.

This FICA-related field is automatically set by Deltek Advantage. If the W-2 year selected for processing is prior to 1995 or after 2003, it is not supported in this release of Deltek Advantage. A message box appears indicating this, and the setting defaults to zero. In this case, you should set the field manually to the appropriate value.


Social Security percentage

The Social Security percentage (employee portion) for the selected W-2 processing year.

Deltek Advantage multiplies this percentage by the employee’s Social Security wages to determine if the actual amount withheld was within $5.00 of the amount expected when generating the work file. If not, a message box appears for each employee whose actual withholding does not fall within the expected range. Any differences should be investigated.

This FICA-related field is automatically set by Deltek Advantage. If the W-2 year selected for processing is prior to 1995 or after 2003, it is not supported in this release of Deltek Advantage. A message box appears indicating this, and the setting defaults to zero. In this case, you should set the field manually to the appropriate value.


Medicare percentage

The Medicare tax percentage (employee portion) for the selected W-2 processing year.

Deltek Advantage multiplies this percentage by the employee’s Medicare wages to determine if the actual amount withheld was within $5.00 of the amount expected when generating the work file. If not, a message box appears for each employee whose actual withholding does not fall within the expected range. Any differences should be investigated.

This FICA-related field is automatically set by Deltek Advantage. If the W-2 year selected for processing is prior to 1995 or after 2003, it is not supported in this release of Deltek Advantage.  A message box appears indicating this, and the setting defaults to zero. In this case, you should set the field manually to the appropriate value.


Computer manufacturer

Enter the name of your computer’s manufacturer using up to eight characters of free text. This is an optional field.


File name

Enter the name and path of the magnetic media report file. The default for this field is A:\W2REPORT.


Employee No (Direct Deposit)

The employee number for which you are entering payroll information appears. You cannot modify this information.


Name (Direct Deposit)

The first and last name of the employee for whom you are entering payroll information appears. You cannot modify this information.


Displaying Withholding Detail on Paychecks

You can show up to 17 lines of withholding detail on the paycheck stub. If an employee has more than 17 withholdings, Deltek Advantage uses the first 16 lines to show withholding detail and uses the 17th to provide a summarized total. This total, labeled Other, includes the amounts for withholdings 17 and beyond, in withholding code order.

You can control which withholdings have a detail line on the paycheck stub by using the Print on Paycheck option on the Payroll Withholding Setup form. The Other amount includes the amounts of any withholdings not designated to "print on paycheck."


Print on Paycheck

Optional. Select this option if you want this withholding to appear as a detail line on the paycheck stub. The default for this option is to display the detail line.

You can show up to 17 lines of withholding detail on the paycheck stub. If an employee has over 17 different withholdings, you can show up to 16 detail lines; the amounts for withholdings 17 and above appear as a summarized total, labeled "Other."


QTD Overtime-2 Hours

The total secondary overtime hours worked by the employee during the current W-2 quarter.


YTD Overtime-2 Hours

The total secondary overtime hours worked by the employee during the current W-2 year.


QTD Overtime-2 Pay

The total secondary overtime pay received by this employee during the current W-2 quarter.


YTD Overtime-2 Pay

The total secondary overtime pay received by this employee during the current W-2 year.


Print on paycheck

Optional. Select this option if you want to print the accrual information on the paycheck stub. If you do not select this option, Deltek Advantage does not print this information on the paycheck stub (this is the default).


Printing an Internal File Copy of Checks

After printing your final checks and assigning check numbers, Deltek recommends that you print a file copy of the checks for your files.

To print an internal copy of checks for your records:

1.	Print payroll checks.

2.	Assign check numbers.

3.	From the Payroll Check Printing form, click the Print File Copy button. A copy of each check and check apron opens in a preview window. Each copy has the word Copy printed at the top. From this window you can review, download to Microsoft Word or Microsoft Excel, or print the file copy.


401K Update

Use the 401k Update utility to change the limit for all employees for this withholding. With this utility, you will not have to go through each employees file to update the limit.  For employees over 55, you will still need to manually adjust their limit after running this utility.

To update the 401K withholding limit for all employees:

1.	Select Utilities, Setup Table Maintenance, Payroll, 401K Update from the Deltek Advantage main menu. Deltek Advantage displays the 401K Update form.

2.	Select 401K from the Withholidng Code field.

3.	Enter the limit to apply to all employees in the Withholding Limit field.

4.	Click on the Update button. Advantage prompts you with this message:

You are about to update all employees’ withholding limits. Would you like to continue?

5.	Click Yes.

6.	When Advantage prompts you that all limits have been updated, click OK.

7.	Click on the Close button to exit the 401K Update form and return to the Deltek Advantage main menu.


Show Range of Periods

If you select this option and use the corresponding drop-down fields to specify a starting period and ending period for the range, data from the range you specify will display instead of quarterly or current information.


Undo a Posted Payroll Run

You can undo a posted payroll run, returning the payroll data, such as posted timesheet hours, to its status in the Payroll application prior to the run being posted.

For instructions on undoing a posted payroll run, see the Undo Posting Utilities topic.

Important Information about Undoing a Posted Payroll Run

•	When you undo a payroll posting run, all data related to the run, such as timesheet entries, accruals, General Ledger entries, and individual employee withholdings, is restored to its state in the database prior to your posting the run.

Note: Advantage does not check to see if payroll checks have been cashed or if direct deposits have been processed before allowing you to undo a posted payroll run. Verify that checks have not been cashed and direct deposits have not been processed before undoing a payroll run.

•	Please note that currently, you cannot undo the posting of voided payroll checks. To avoid doubling timesheet hours, do not void checks prior to running the Undo Posting routine for a payroll run. If you attempt to undo a posting that contains voided checks, Advantage will prompt you with a message to indicate this.

When you void a check, Advantage returns those hours to the database to again be processed. Advantage also returns the same timesheet hours for re-posting when you run the Undo Posting routine for posted payroll runs. If you first void checks, and then undo the posted payroll run, Advantage will store the timesheet hours twice, essentially doubling an employee's posted timesheet hours.

•	If you have not run Direct Deposit Processing for a particular payroll run, and then you undo a posted payroll run, the Direct Deposit file for that run will not be deleted from Direct Deposit Processing, but the file will contain no data and cannot be processed. If you try to process the Direct Deposit file, Advantage prompts you with a message indicating that there is no data.

Note: If rather than undoing a posted payroll run, you want to void any check in a payroll run, you can do so from Void Check Processing. Selecting the Payroll Check option from Void Check Processing lists all processed payroll and direct deposit checks from which you can select the ones to void. You must belong to a workgroup with the appropriate security rights to void a payroll check.


Void a Payroll Check

When you void a payroll check, Advantage posts a voided check amount to the General Ledger and reverses the effect of the original check posting. Voiding a payroll check also reverses any withholdings, sick time, and accrued vacation time associated with the original check.

You void a payroll or direct deposit check from the Void Check Processing form, using the same basic procedure to void other types of transactions. For instructions see the Overview of Void Check Processing topic.

Note: For payroll checks to be available for voiding from the Void Check Processing form the currently logged in user must belong to a workgroup with the appropriate security access.

Important Note

Please note that currently, you cannot undo the posting of voided payroll checks. To avoid doubling timesheet hours, do not void checks prior to running the Undo Posting routine for a payroll run. If you attempt to undo a posting that contains voided checks, Advantage will prompt you with a message to indicate this.

When you void a check, Advantage returns those hours to the database to again be processed. Advantage also returns the same timesheet hours for re-posting when you run the Undo Posting routine for posted payroll runs. If you first void checks, and then undo the posted payroll run, Advantage will store the timesheet hours twice, essentially doubling an employee's posted timesheet hours.


Suppress SSN on Payroll List and Journal Reports

Select this option to prevent the social security number from printing on the Payroll List and Payroll Journal reports.


Link to Calculate Overall Limit

Select one other withholding code whose amount you want Advantage to add together with the amount of the current withholding when determining if the employee has reached the overall limit. For example, you may want to link a 401(k) withholding with a Roth 401(k) withholding.

When you select a withholding code from this field, Advantage automatically enters the current withholding code in the Link to calculate Overall Limit field of the withholding code you selected. Advantage also automatically updates the amount in the Limit field on the Employee Payroll Withholding Table Maintenance grid for each record that uses the code any time the amount is changed in either of the linked withholding code records. For example, if you link the 401(k) and the Roth 401(k) codes and you update the 401(k) Limit field in the Employee Payroll Withholding Table Maintenance grid for a particular employee from 10,000 to 11,000, Advantage automatically changes the Roth 401(k) Limit to 11,000.

You can only link one particular withholding code with one other withholding code. Advantage will not allow you to link to a withholding code that is already linked to a separate withholding code (which would mean three withholding codes linked together).

Be aware that there are two fields available for selection from Box 12 on the W-2 form that relate to Roth 401(k) or 403(b) contributions. If you link these amounts using the Link to Calculate Overall Limit field, please enter the appropriate amount in the appropriate field on the W-2 form.

•	AA — Employee contributions to a Roth 401(k).

•	BB — Employee contributions to a Roth 403(b).

Read more information about Roth IRA contributions.


Note about Roth IRA and Advantage

Beginning in 2006, a 401(k) or 403(b) plan may permit an employee to designate some or all of his or her elective contributions under the plan as designated Roth contributions.

A designated Roth account is a separate account under a 401(k) or 403(b) plan to which designated Roth contributions are made, and for which separate accounting of contributions, gains, and losses is maintained. Designated Roth contributions are treated the same as pre-tax elective contributions for most purposes. For example:

•	They are subject to an annual individual elective contribution limit (aggregate of all designated Roth contributions and traditional, pre-tax contributions).

•	 They are included when determining the maximum employee and employer annual contributions.

To meet the requirement that both the amount of an employee's traditional pre-tax elective contribution and the amount of the Roth 401(k) contribution must be added together to determine when or if the yearly contribution limit is met, Advantage includes a Link to calculate Overall Limit field on the Payroll Withholding Setup form. This field allows you to link together any two withholding codes whose amounts will be added together when determining if the employee has reached the overall limit.

You can use this field to link any two (and only two) withholding codes together. If you attempt to link to a withholding code that is already linked to another code, Advantage displays an error message and prevents this.


Tax Calculations

Deltek Payroll for Advantage comes with a set of federal, state, and local tax tables. This feature saves you a great deal of time when you are processing your payroll.

When you calculate your federal, state, and local tax withholdings manually, you refer to the tax table that lists the amounts that should be withheld each pay period. The Payroll module, however, usually calculates withholdings on an annual basis, and then it divides the annual amount among the payroll periods.

Deltek Advantage uses exemption and filing status information to calculate the variables that it needs to determine the state or local tax withholding. These variables include:

•	standard deductions

•	additional deductions

•	allowances

•	credits

Deltek Advantage uses different methods to calculate the taxes due to each tax authority. The methods depend on information you have supplied and the automatically calculated variables already mentioned. There are three calculation methods used by most states and local tax authorities. The tax fact pages for each authority will identify which method Deltek Advantage uses to calculate the taxes for that locale.

The methods are:

Method 1	Wage Bracket
Method 2	Percentage of Taxable Pay
Method 3	Percentage of Federal Income Tax
 Note

 Related Topics


Tax Codes

Deltek Advantage uses two-character codes to identify state and local tax authorities. Use the standard two-character postal abbreviations for each state. For other tax authorities, use the following:

Tax Authority	Code
District of Columbia	DC
Maryland Non-resident	M1
New York City Resident	N1
New York City Non-resident	N2


Tax Calculation Method 1

Method 1 calculates the tax as a base amount for the wage bracket, plus a percentage of the excess over the base amount. Note that the following table provides a sample tax method. This tax table is not to use for calculating your taxes.

For example:

Taxable income is...	The computed tax is...
Over	But not over	% of Taxable amount over...    Plus
$0	$4394	1.0%	$0	+	$0.00
$4,394	$10,414	2.0%	$4,394	+	$43.94
$10,414	$16,435	4.0%	$10,414	+	$164.34
$16,435	$22,816	6.0%	$16,435	+	$405.18
$22,816	$28,835	8.0%	$22,816	+	$788.04
$28,835	$100,000	9.3%	$28,835	+	$1,269.56
$100,000	$200,000	10.0%	$100,000	+	$7,887.91
$200,000	and over	11.0%	$200,000	+	$17,887.91


Tax Calculation Method 2

Method 2 calculates the tax by multiplying the net taxable pay by a fixed percentage. Note that the following table provides a sample tax method. This tax table is not to use for calculating your taxes.

For example:

Taxable Pay	Fixed Percentage	Tax Withheld
$18,000.00	%5.5	$990.00


Tax Calculation Method 3

Method 3 calculates taxes in two stages:

1.	Calculates federal income tax withholding.
2.	Computes tax by multiplying the federal tax withholding amount by a fixed percentage.
 Note


Deltek Advantage Tax Facts

The following lists all of the available tax tables in Deltek Advantage:

Federal	Mississippi
Alabama	Missouri
Arizona	Montana
Arkansas	Nebraska
California	New Jersey
Colorado	New Mexico
Connecticut	New York
District of Columbia	New York City Resident
Delaware	New York City Nonresident
Georgia	North Carolina
Hawaii	North Dakota
Idaho	Ohio
Illinois	Oklahoma
Indiana	Oregon
Iowa	Pennsylvania
Kansas	Puerto Rico
Kentucky	Rhode Island
Louisiana	South Carolina
Maine	Utah
Maryland	Vermont
Massachusetts	Virginia
Michigan	West Virginia
Minnesota	Wisconsin

See also:

FICA-HI (Medicare) Tax

FICA-OASDI (Social Security) Tax


Federal Income Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for federal income tax:

Status	Enter the marital status claimed by the employee for Federal income tax purposes on Form W-4: • S for single • M for married • H for head of household Note: If you entered a status of Married, but withhold at a higher Single rate on the W-4 form, enter a status of S on the Employee Payroll Withholding Table Maintenance screen.
Exemptions	Enter the number of exemptions claimed by the employee on federal Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Federal tax calculations do not use the Other Exemptions field.
How Deltek Advantage Calculates Federal Tax

Deltek Advantage calculates an employee's federal tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) Plan contributions, and 125/Cafeteria Plan contributions from the employee's gross wages for the pay period to determine taxable income.

3.	Calculates the net income tax using Tax Calculation Method 1.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

Automatically Calculated Variables

Deltek Advantage automatically computes the Allowance, which is used in calculating the net income tax.

Allowance

The Allowance is based on the number of withholding exemptions entered in the first Exemptions field. It is determined by multiplying the number of Exemptions by $3,400.

Supplemental Wages

The tax rate for supplemental wages for bonus runs is 35%, when the bonus amount is over a million dollars. Otherwise the rate is 25%.


FICA-HI (Medicare) Tax

Deltek Advantage calculates the Medicare tax in the following manner:

•	Subtracts any 125/Cafeteria Plan contributions from the employee's gross wages.

•	Multiplies the resulting amount by 1.45%. There is no maximum wages amount.


FICA-OASDI (Social Security) Tax

Deltek Advantage calculates the Social Security tax in the following manner:

•	Subtracts any 125/Cafeteria Plan contributions from the employee's gross wages.

•	Multiplies the resulting amount by 6.2% to a maximum wages amount of $97,500 (tax year 2007).


Alabama Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Alabama:

Status	Enter the marital status claimed by the employee on the Alabama Employee’s Withholding Exemption Certificate, Form A-4:  • S for single, claiming self • M for married, claiming self and spouse • O for claiming no personal exemption (used when the employee did not submit Form A-4) • H for head of household
Exemptions	Enter the number of exemptions claimed by the employee on Form A-4. If the employee claimed no exemptions, enter zero.
Other Exemptions	Alabama’s tax calculations do not use the Other Exemptions field.
Automatically Calculated Variables

Deltek Advantage computes the following variables, which are used in determining the net income:

•	Standard Deduction

•	Allowance

•	Federal Income Tax Deduction

Standard Deduction

The Standard Deduction is a variable deduction applied to all employees. The deduction is based on annualized wages and depends on the employee’s filing status.

If Annualized Wages are between	Use the columns below for Standard Deduction based on Employee Form A-4 filing status
		M	H	S
$20,001	$20,500	$7,325	$4,565	$2,475
$20,501	$21,000	$7,150	$4,430	$2,450
$21,001	$21,500	$6,975	$4,295	$2,425
$21,501	$22,000	$6,800	$4,160	$2,400
$22,001	$22,500	$6,625	$4,025	$2,375
$22,501	$23,000	$6,450	$3,890	$2,350
$23,001	$23,500	$6,275	$3,755	$2,325
$23,501	$24,000	$6,100	$3,620	$2,300
$24,001	$24,500	$5,925	$3,485	$2,275
$24,501	$25,000	$5,750	$3,350	$2,250
$25,001	$25,500	$5,575	$3,215	$2,225
$25,501	$26,000	$5,400	$3,080	$2,200
$26,001	$26,500	$5,225	$2,945	$2,175
$26,501	$27,000	$5,050	$2,810	$2,150
$27,001	$27,500	$4,875	$2,675	$2,125
$27,501	$28,000	$4,700	$2,540	$2,100
$28,001	$28,500	$4,525	$2,405	$2,075
$28,501	$29,000	$4,350	$2,270	$2,050
$29,001	$29,500	$4,175	$2,135	$2,025
$29,501	$30,000	$4,000	$2,000	$2,000
If Annualized Wages are between	Use this column for Standard Deduction based on Employee Form A-4 filing status MS (Status 2 in Advantage)
$10,001	$10,250	$3,662
$10,251	$10,500	$3,574
$10,501	$10,750	$3,486
$10,751	$11,000	$3,398
$11,001	$11,250	$3,310
$11,251	$11,500	$3,222
$11,501	$11,750	$3,134
$11,751	$12,000	$3,046
$12,001	$12,250	$2,958
$12,251	$12,500	$2,870
$12,501	$12,750	$2,782
$12,751	$13,000	$2,694
$13,001	$13,250	$2,606
$13,251	$13,500	$2,518
$13,501	$13,750	$2,430
$13,751	$14,000	$2,342
$14,001	$14,250	$2,254
$14,251	$14,500	$2,166
$14,501	$14,750	$2,078
$14,751	$15,000	$2,000
Allowance

The allowance is based on the filing status claimed by the employee and the number of exemptions entered in the first Exemptions field.

If the status is	Then the maximum is
S or 2	$1,500 + (number of dependents other than spouse x $1000.00 if annualized wages are less than or equal to $20,000 or x $500 if annualized wages are greater than $20,000 but less than $100,000 or x $300 if greater than $100,000) for single or married filing separately employees, claiming one or more exemptions
M or H	$3,000 + (number of dependents other than spouse x $1000.00 if annualized wages are less than or equal to $20,000 or x $500 if annualized wages are greater than $20,000 but less than $100,000 or x $300 if greater than $100,000) for married or head of household employees, claiming one or more exemptions
O	0
Federal Income Tax Deduction

The Federal Income Tax (F.I.T) deduction is equal to the employee’s annual federal income tax as calculated by Deltek Advantage.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Alabama state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, annualized Federal Income Tax (F.I.T), 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the annual income tax using Tax Calculation Method 1.

4.	Divides the annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Arizona Tax

As of 12/25/04

The Arizona state tax is based on a percentage of the federal income tax withheld. Employees subject to the Arizona state tax must indicate whether they want the state to withhold 0%, 10%, 19%, 23%, 25%, 31%, or 37% of the federal withholding.

Important Information:

•	Employees with annualized federal gross incomes of $15,000 or more cannot choose less than the 19% state withholding percentage.

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Arizona:

Status	Arizona’s tax calculations do not use the Status field.
Exemptions	Enter the percentage of withholding desired by the employee, as indicated on Arizona Employee Withholding Certificate, Form A-4: • 0 for 0% or federal withholding  • 1 for 10% of federal withholding • 2 for 19% of federal withholding • 3 for 23% of federal withholding • 4 for 25% of federal withholding • 5 for 31% of federal withholding • 6 for 37% or federal withholding  Deltek Advantage does not check this field. Any number other than 0, 1, 2, 3, 4, 5, or 6 will be recognized as 0%. If the employee did not submit Form A-4, enter 0 (or enter 6 if the employee earns over $15,000 annually) in this field.
Other Exemptions	Arizona’s tax calculations do not use the Other Exemptions field.
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Arizona state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Calculates the employee’s federal income tax based on gross wages.

3.	Applies the withholding percentage indicated by the employee to the federal income tax, yielding the net income tax for Arizona.

4.	Divides the annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Arkansas Tax

As of 1/8/99

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Arkansas:

Status	Enter the marital status claimed by the employee on the Arkansas Employee’s Withholding Exemption Certificate, Form AR-4EC: • 1 for single • 2 for married, claiming self only • 3 for married, claiming self and spouse • 4 for claiming no personal exemption  If the employee did not submit Form AR-4EC, use the marital status claimed by the employee for federal income tax purposed on federal Form W-4.
Exemptions	Enter the number of dependents claimed by the employee on Form AR-4EC.  If the employee did not submit Form AR-4EC, enter the number of dependents claimed for federal income tax purposes on federal Form W-4.
Other Exemptions	Arkansas’s tax calculations do not use the Other Exemptions field.
Automatically Calculated Variables

Deltek Advantage automatically computes the following variables based on the exemptions claimed by the employee:

•	Standard Deduction

•	Credit

Standard Deduction

The Standard Deduction is a fixed amount deduction applied to all employees. The amount of the deduction is $2,000.00.

Credit

The Credit is based on the number of exemptions for dependents claimed by the employee. The number of exemptions for dependents is entered in the first Exemptions field.

To determine the amount of the credit, multiply the number of exemptions by $20.00.

How Deltek Advantage Calculates the Tax

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, and any 401(k) and 125/Cafeteria plan contributions from the employee's gross wages for the pay period to determine taxable income.

3.	Calculates the annual income tax, using Tax Calculation Method 1.

4.	Subtracts the Credit amount (if applicable) from the annual income tax to determine net annual income tax.

5.	Divides the net annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


California Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of California:

Status	Enter the marital status claimed by the employee on California Form DE 4: • S for single, dual income married, or married with multiple employers. • M for married. • H for head of household.
Exemptions	Enter the total number of regular allowances claimed by the employee on Line 1 of California Form DE 4.  If the employee did not submit Form DE 4, use the total number of allowances claimed by the employee for federal income tax purposes on Form W-4.
Other Exemptions	Enter the total number of regular allowances for estimated deductions claimed by the employee on California Form DE 4.  Each allowance reduces the amount of annual wages subject to California personal income tax by $1,000.00. If the employee did not submit any allowance for estimated deductions on Form DE 4, do not make any entry here.
Automatically Calculated Variables

Deltek Advantage automatically computes the following variables based on the exemptions and filing status claimed by the employee:

•	Standard Deduction

•	Additional Deductions

•	Credit

Standard Deduction

The Standard Deduction is a table-based deduction applied to all employees. The amount of the deduction depends on the number of regular exemptions claimed in the first Exemptions field and the employee’s filing status.

Status	Deduction Per Exemption
Single, dual income married or married with multiple employers	$3,254
Married (0-1 exemptions)	$3,254
Married (2 or more exemptions)	$6,508
Unmarried head of household	$6,508
Additional Deductions

Additional Deductions are based on the number of additional withholding allowances for estimated deductions entered in the Exemptions-2 field. It is determined by multiplying the number of Exemptions-2 by $1,000.

Credit

The Credit is based on the number of exemptions entered in the first Exemptions field. The amount of the Credit is determined by multiplying the number of exemptions by $91.

Low Income Exemption

Deltek Advantage compares the employee's wages, minus 401(k) Plan and 125/Cafeteria Plan contribution amounts, to an amount in the low income exemption table to determine eligibility for tax withholding. The amounts are based on the employee's marital status and the number of exemptions.

Status	Maximum Annual Amount for Exemption
Single, dual income married or married with multiple employers	$10,764
Married (0-1 exemptions)	$10,764
Married (2 or more exemptions)	$21,527
Unmarried head of household	$10,764
How Deltek Advantage Calculates the Tax

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Compares the employee’s annual gross wages to the low income exemption table. If they are less than or equal to the low income exemption, no tax is withheld.

3.	Subtracts the employee's Standard Deduction, Additional deductions, and annualized 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages.

4.	Calculates the annual income tax, using Tax Calculation Method 1.

5.	Subtracts a Credit (if applicable) from the annual income tax to determine the annual net income tax.

6.	Divides the net annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Colorado Tax

As of 12/12/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Colorado:

Status	Enter the marital status claimed by the employee on federal Form W-4: • S for single • M for married
Exemptions	Enter the total number of allowances claimed by the employee on federal Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Colorado’s tax calculations do not use the Other Exemptions field.
Automatically Calculated Variables

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the Exemptions field. It is determined by multiplying the number of exemptions by $3,400.

How Deltek Advantage Calculates the Tax

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and annualized 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages.

3.	Calculates the annual income tax, using Tax Calculation Method 1.

4.	Divides the annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Connecticut Tax

As of 1/15/07

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Connecticut:

Status	Enter one of the following in the Status field: • A for married and filing separately, or married with a combined income of $100,500.00 or less. • B for head of household. • C for married (spouse not working). • D for married (working spouse and combined income greater than $100,500.00), non-resident, or employees who want to avoid having too little tax withheld. • F for single filers. Though Advantage does not have a filing status of E, employees wishing to use filing status E can select a Method of Amount and enter 0 in the Amount/Percent field of Employee Payroll Withholding Table Maintenance (Payroll tab of Employee Table Maintenance) to arrive at the correct withholding amount.
Exemptions	Connecticut tax calculations do not use the exemptions field.
Other Exemptions	Connecticut’s tax calculations do not use the Other Exemptions field.
Automatically Calculated Variables

Deltek Advantage automatically computes the following variables based on the filing status of the employee:

•	Exemption Amount

•	Credit Percentage

Exemption Amount

The Exemption Amount is determined by applying the employee’s annual gross earnings (less any 401(k) and 125/Cafeteria contributions) to the table, based on the employee’s filing status. Note that Filing Status D has no exemption amount.

Credit

The credit amount is calculated using the state’s credit percentage table.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Connecticut state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Exemption amount, and annualized 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages.

3.	Calculates the annual income tax, using Tax Calculation Method 1.

4.	Determines the credit percentage based on the state's credit percentage table.

5.	Multiplies the annual income tax by one minus the credit percentage [Withholding amount x (1 - Credit Percentage)] to determine the net annual income tax.

6.	Divides the net annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. If the result is less than or equal to zero, no tax is withheld.


Delaware Tax

As of 1/17/00

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Delaware:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4: • S for single • 1 for married, filing separately • 2 for married, filing jointly
Exemptions	Enter the total number of regular allowances claimed by the employee on federal Form W-4, excluding the following federal exemptions: • child care credit • earned income credit • credit for the elderly If the employee did not submit Form W-4, enter zero for the number of exemptions.
Other Exemptions	Delaware’s tax calculations do not use the Other Exemptions field.
Automatically Calculated Variables

Deltek Advantage automatically computes the following variables based on the exemptions and filing status claimed by the employee:

•	Standard Deduction

•	Tax Credit

Standard Deduction

Deltek Advantage calculates the standard deduction using a table based on an annual deduction of $3,250 for single employees, $6,500 for married employees filing jointly, and 3,250 for married employees filing separately.

Tax Credit

Deltek Advantage calculates the credit based on the number of exemptions claimed in the Exemptions field. Deltek Advantage determines the amount of the credit by multiplying the number of exemptions by $110.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Delaware state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, and 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages.

3.	Calculates the computed tax, using Tax Calculation Method 1.

4.	Subtracts a Credit (if applicable) from the computed tax, to determine the net income tax.

5.	Divides the annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. If the result is less than or equal to zero, no tax is withheld.


District of Columbia Tax

As of 1/15/07

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of the District of Columbia:

Status	Enter the marital status claimed by the employee on the District of Columbia Employee’s Withholding Exemption Certificate, Form D-4: • A for single, or married and filing jointly • B for married and filing separately
Exemptions	Enter the number of exemptions claimed by the employee on Form D-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form D-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form D-4, enter zero in this field.
Other Exemptions	The District of Columbia’s tax calculations do not use the Other Exemptions field.
Automatically Calculated Variables

Deltek Advantage automatically computes the Allowance, which is used in determining net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the Exemptions field. It is determined by multiplying the number of exemptions by $1,500.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's District of Columbia tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine the taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Georgia Tax

As of 3/7/07

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Georgia:

Status	Enter the marital status claimed by the employee on Georgia Employee’s Withholding Exemption Certificate, Form G-4: • S for single • H for Head of Household • 1 for married and filing jointly, one spouse working • 2 for married and filing jointly, both spouses working • 3 for married and filing separately • 4 for married, filing jointly, and the employee OR spouse has reached the age of 65 by the end of the tax year OR the employee OR spouse is blind at the end of the tax year • 5 for married, filing jointly, and BOTH the employee and spouse have reached the age of 65 by the end of the tax year OR BOTH the employee and spouse are blind at the end of the tax year • 6 for married, filing jointly, and BOTH the employee and spouse have reached the age of 65 by the end of the tax year AND the employee OR spouse is blind at the end of the tax year  or  Married, filing jointly, and BOTH the employee and spouse are blind at the end of the tax year AND the employee OR spouse have reached the age of 65 by the end of the tax year • 7 for married, filing jointly, and BOTH the employee and spouse have reached the age of 65 by the end of the tax year, AND BOTH the employee and spouse are blind at the end of the tax year • A for Married, filing jointly, with both spouses working, and the employee OR spouse has reached the age of 65 by the end of the tax year OR the employee OR spouse is blind at the end of the tax year • B for Married, filing jointly, with both spouses working, and BOTH the employee and spouse have reached the age of 65 by the end of the tax year OR BOTH the employee and spouse are blind at the end of the tax year • C for Married, filing jointly, with both spouses working, and BOTH the employee and spouse have reached the age of 65 by the end of the tax year AND the employee OR spouse is blind at the end of the tax year or  Married, filing jointly, with both spouses working, and BOTH the employee and spouse are blind at the end of the tax year AND the employee OR spouse have reached the age of 65 by the end of the tax year  • D for Married, filing jointly, with both spouses working, and BOTH the employee and spouse have reached the age of 65 by the end of the tax year AND BOTH the employee and spouse are blind at the end of the tax year
Exemptions	Enter the total number of withholding exemptions claimed by the employee on Georgia Employee’s Withholding Exemptions Certificate (Form G-4). This figure includes personal exemptions for self, spouse, and dependents. This figure does not include exemptions for age or blindness.
Other Exemptions	Enter the number of exemptions for age or blindness claimed by the employee on Form G-4.
Summary of Deductions

Deltek Advantage automatically computes the following variables based on the exemptions and filing status claimed by the employee:

•	Standard Deduction

•	Personal and Dependent Allowances

Standard Deduction

The standard deduction is a table-based deduction applied to all employees. Deltek Advantage calculates the amount of the deduction using the employee's filing status, as follows:

Filing Status	Standard Deduction
S, H	$2,300
1, 2	$3,000
3	$1,500
4, A	$4,300
5, B	$5,600
6, C	$6,900
7, D	$8,200
Allowances

The Allowance is based on the number of withholding exemptions claimed in the Exemptions and Other Exemptions fields. The amount of the allowance is determined by multiplying the number of exemptions in the first field by $2,700 and the number of exemptions in the second field by $3,000.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Georgia state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Personal and Dependent Allowances, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages for the pay period to determine taxable income.

3.	Calculates the net income tax, by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld this pay period.


Hawaii Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following information for residents of Hawaii:

Status	Enter the marital status claimed by the employee on the Hawaii Employee’s Exemptions and Status Certificate, Form HW-4:  • S for single  • M for married • H for Head of Household If the employee did not submit Form HW-4, enter S for the marital status.
Exemptions	Enter the total number of allowances claimed by the employee on Form HW-4. If the employee did not submit form HW-4, enter zero.
Other Exemptions	Hawaii’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $1,040.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Hawaii state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax, by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Idaho Tax

As of 4/22/05

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Idaho:

Status	Enter the marital status claimed by the employee for federal income tax purposed on Form W-4:  • S for single  • M for married
Exemptions	Enter the number of allowances claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Idaho’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining net income tax.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $3,200.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Idaho state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax, by applying Tax Calculation Method 1 to the taxable income

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Illinois Tax

As of 11/23/99

Use Employee Payroll Table Maintenance to enter the following field information for residents of Illinois:

Status	Illinois tax calculations do not use the Status field.
Exemptions	Enter the number of exemptions claimed by the employee on line 1 of the Employee’s Illinois Withholding Exemption Certificate, Form IL-W-4.
Other Exemptions	Enter the number of exemptions claimed by the employee on line 2 of the Employee’s Illinois Withholding Exemption Certificate, Form IL-W-4.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the Exemptions fields. It is determined by multiplying the number of Exemptions entered in the first exemption field by $2,000.00 and the number of exemptions entered in the second exemptions field by $1,000.00.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Illinois state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 2 to the taxable income, using a percentage of 3.0%.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Indiana Tax

As of 11/24/99

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Indiana:

Status	Indiana’s tax calculations do not use the Status field.
Exemptions	Enter the number of withholding exemptions claimed by the employee on the Indiana Employee’s Withholding Exemption Certificate, Form WH-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form WH-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Indiana’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance based on the exemptions claimed by the employee.

Allowance

The Allowance is based on the number of exemptions entered in the Exemptions fields. It is determined by multiplying the number of exemptions entered in the first field by $1,000 and the number of exemptions entered in the second field by $1,500.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Indiana state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine the taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 2 to the taxable income, using a percentage of 3.4%.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Iowa Tax

As of 6/29/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Iowa:

Status	Iowa’s tax calculations do not use the Status field.
Exemptions	Enter the total number of exemptions claimed by the employee on the Iowa Employee’s Withholding Exemption Certificate, Form IA-W-4, #44-019. This figure includes: • personal exemptions for self and spouse not claimed on other Form IA-W-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form IA-W4, use the number the number of exemptions claimed by the employee for federal income tax purposes on Form W-4.
Other Exemptions	Iowa’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the following variables, which are used in determining the net income tax:

Standard Deduction

Federal Income Tax Deduction

Credit

Standard Deduction

The Standard Deduction is applied to all employees. The amount of the deduction depends on the number of exemptions claimed in the first Exemptions field as follows:

Number of Exemptions	Deduction
0 or 1	$1,640
2 or more	$4,060
Federal Income Tax Deduction

The Federal Income Tax Deduction (F.I.T.) is a variable deduction equal to the employee’s annual federal income tax as calculated by Deltek Advantage.

Credit

The Credit is based on the number of exemptions entered in the first Exemptions field. The employee is entitled to $40 for each exemption:

Number of Exemptions	Amount of Credit
0	$0
1	$40
2	$80
More than 2	$40 for each exemption
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates Iowa state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Federal Income Tax Deduction (equal to the employee’s federal tax payment), and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the computed tax by applying Tax Calculation Method 1 to the taxable income.

4.	Subtracts a Credit, if applicable, from the computed tax to determine the net income tax.

5.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Kansas Tax

As of 11/20/98

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Kansas:

Status	Enter the marital status claimed by the employee on the federal Form W-4:  • S for single and all others • M for married and filing a joint return
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Kansas’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $2,250.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Kansas state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Kentucky Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Kentucky:

Status	Kentucky’s tax calculations do not use the Status field.
Exemptions	Enter the total number of exemptions claimed by the employee on Kentucky Standard Withholding Certificate, Form K-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form K-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form K-4, enter zero in this field.
Other Exemptions	Kentucky’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the following variables, which are used in determining the net income tax:

Standard Deduction

Credit

Standard Deduction

The Standard Deduction is a fixed amount deduction applied to all employees. The amount of the deduction is $2,050.

Credit

The Credit is based on the number of exemptions entered in the first Exemptions field. The amount of the Credit is determined by multiplying the number of exemptions by $20.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Kentucky state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the computed tax by applying Tax Calculation Method 1 to the taxable income.

4.	Subtracts a Credit, if applicable, from the computed tax to determine the net income tax.

5.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Louisiana Tax

As of 12/20/02

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Louisiana:

Status	Louisiana’s tax calculations do not use the Status field.
Exemptions	Enter the number of personal exemptions claimed by the employee on the Louisiana Employee’s Withholding Exemption Certificate, Form L-4, L-4A, or L-4E. Use the following guidelines to complete this field. If the employee claimed: • No personal exemption - enter zero. • A personal exemption of $4,500 - enter 1. • A personal exemption of $9,000 for self and spouse - enter 2. If the employee did not submit Form L-4, L-4A, or L-4E, enter zero for the number of exemptions.
Other Exemptions	Enter the number of dependents claimed by the employee on L-4, L-4A, or L-4E.
Summary of Deductions

Deltek Advantage automatically computes the following variables:

•	Allowance

•	Additional Allowances

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field.

If the number of exemptions is	Then the allowance is
0 or 1	$4,500
2	$9,000
Additional Allowances

Additional Allowances are based on the number of dependents claimed by the employee in the Other Exemptions field. It is determined by multiplying the number of Other Exemptions by $1,000.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Louisiana state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee’s 401(k) and 125 Cafeteria plan contributions from the employee’s gross wages to obtain the employee’s taxable wages.

3.	Establishes a lower wage bracket amount and a higher wage bracket amount. If the employee is claiming an exemption of 0 or 1, the lower wage bracket is $12,500 and the higher wage bracket is $25,000. If the employee is claiming an exemption of 2, the lower wage bracket is $25,000 and the higher wage bracket is $50,000.

4.	Multiplies the employee’s taxable wages by .021 to obtain amount A. If the employee’s taxable wages are greater than the lower wage bracket, Advantage subtracts the lower wage bracket amount from the employee’s taxable wages and multiplies the result by .0135 to obtain amount B. If the employee’s taxable wages are greater than the higher wage bracket amount, Advantage subtracts the higher wage bracket amount from the employee’s taxable wages and multiplies the result by .0135 to obtain amount C.

5.	Adds the allowance amount to additional allowance amount and multiplies the result by .021 to obtain amount D.

6.	If the result of adding the allowance amount to the additional allowance amount is greater than the lower wage bracket amount, Advantage subtracts the lower wage bracket amount from the sum of the allowance amount and additional allowance amount and multiplies the result by .0135 to obtain amount E.

7.	Adds amounts A, B, and C together and subtracts amounts D and E to obtain the annualized tax withholding. If the result is greater than 0, Advantage divides the result by the number of pay periods to determine the amount to be withheld for the pay period.


Maine Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Maine:

Status	Enter the marital status claimed by the employee for federal income tax purposed on Form W-4:  • S for single • M for married Maine has eliminated the status of 2 (married with two incomes). Advantage treats the status of S and 2 the same.
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Maine’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage computes the Allowance based on the exemptions claimed by the employee.

Allowance

The Allowance is determined by multiplying the number of exemptions claimed in the first Exemptions field by $2,850.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Maine state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the computed income tax by applying Tax Calculation Method 1 to the taxable income.

1.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

2.	Round the final results of calculations to the nearest whole dollar.


Maryland Tax

As of 12/2/05

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Maryland:

Code	This is the withholding code, as set up in Payroll Withholding Setup Maintenance, associated with the appropriate Maryland tax locale. Maryland tax locales M1, M2, M3, M4, and M5 are described in the next section.
Status	Enter the appropriate code in the Status field. The following filing status is for non-resident employees.
Locale	Filing Status	County
M1	A	Non-Resident
	The following filing statuses are for withholdings associated with the MD county and tax locale.
Locale	Filing Status	County
M1	B	Baltimore City
M1	C	Allegany
M1	D	Anne Arundel
M1	E	Baltimore County
M2	F	Calvert
M2	G	Caroline
M2	H	Carroll
M2	I	Cecil
M2	J	Charles
M3	K	Dorchester
M3	L	Frederick
M3	M	Garrett
M3	N	Harford
M3	O	Howard
M4	P	Kent
M4	Q	Montgomery
M4	R	Prince George’s
M4	S	Queen Anne’s
M4	T	St. Mary’s
M5	U	Somerset
M5	V	Talbot
M5	W	Washington
M5	X	Wicomico
M5	Y	Worcester
Exemptions	Enter the total number of exemptions (from 0 to 99) claimed by the employee on Form MW-507.  This figure includes: • personal exemptions for self and spouse not claimed on other Form MW-507. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form MW-507, enter 1 for the number of exemptions.
Other Exemptions	Maryland’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and allowance, which are used in determining the net income tax.

Standard Deduction

The Standard Deduction is a variable deduction applied to all employees. It is 15% of the employee's annual gross wages, subject to a minimum of $1,500 and a maximum of $2,000.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $2,400.

Low Income Exemption

The Low Income Exemption applies to employees whose annualized gross wages are less than but not equal to $5,000. No withholding is applied in this case.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Maryland state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Massachusetts Tax

As of 12/13/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Massachusetts:

Status	Enter the marital status claimed by the employee: • S for single  • M for married • H for Head of Household Note that Head of Household is the only status currently in use.
Exemptions	Enter the total number of exemptions claimed by the employee on line 4 of the Massachusetts Employee’s Withholding Exemption Certificate, Form M-4. If the employee did not submit Form M-4, use the total number of regular exemptions claimed by the employee for federal income tax purposes on Form W-4.
Other Exemptions	Enter the total number of blind exemptions claimed by the employee on line 5 of the Massachusetts Employee’s Withholding Exemption Certificate, Form M-4. If the employee did not submit Form M-4, do not make an entry in this field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance and Credit based on the exemptions claimed by the employee.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined as follows:

$3,125.00 + ($1,000.00 x number of exemptions)

If the number of exemptions is zero, no Allowance is made.

Credit

The Credit is based on the number of blind exemptions entered in the Other Exemptions field. It is determined by multiplying the number of other exemptions by $116.60.

If an employee claims one or more exemptions in the Exemptions field and the employee’s taxable income is less than $8,000, no tax is withheld.

A Head of Household Credit of $119.25 is given if the employee’s status is H.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Massachusetts state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the amount withheld for FICA (up to $2,000 annually), Massachusetts, U.S., or Railroad retirement systems, the Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the computed tax by applying Tax Calculation Method 2 to the taxable income, applying a percentage of 5.30%.

4.	Subtracts a Credit, (if applicable) from the computed tax, to determine the net income tax withholding.

5.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Michigan Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Michigan:

Status	Michigan’s tax calculations do not use the Status field.
Exemptions	Enter the total number of withholding exemptions claimed by the employee on the Employee’s Michigan Withholding Exemption Certificate, Form MI-W4. This figure includes personal exemptions for self and spouse not claimed on other Form MI-W4.
Other Exemptions	This figure includes exemptions for dependents claimed by the employee on Form MI-W4. If the employee did not submit Form MI-W4, enter zero for the number of exemptions. Users will still be able to enter a value in the Other Exemptions field (Withholdings grid from Payroll tab in Employee Table Maintenance). However, Advantage will not use this value to calculate tax.
Summary of Deductions

Deltek Advantage automatically computes the Allowance based on the exemptions claimed by the employee.

Allowance

The Allowance is determined by multiplying the number of exemptions claimed in the first Exemptions field by $3,400.

Special Exemptions

Michigan no longer uses the Special Exemptions Allowance (previously determined by multiplying the number of exemptions claimed in the Other Exemptions field by $1,900).

Users will still be able to enter a value in the Other Exemptions field (Withholdings grid from Payroll tab in Employee Table Maintenance). However, Advantage will not use this value to calculate tax.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Michigan state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 2 to the taxable income, using a percentage of 3.9%.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Minnesota Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Minnesota:

Status	Enter the marital status claimed by the employee on Form W-4: • S for single • M for married
Exemptions	Enter the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form W-4, enter zero in this field.
Other Exemptions	Minnesota’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $3,400.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Minnesota state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Mississippi Tax

As of 6/28/04

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Mississippi:

Status	Enter the marital status claimed by the employee on the Mississippi Withholding Exemption Certificate, Form 89-350-98.  • S for single • M for married, both spouses employed • H for Head of household • 1 for married, one spouse employed
Exemptions	Enter the personal exemption claimed by the employee on Form 89-350-98; enter 1 if the employee claims a personal exemption, enter zero if the employee claims no exemption. If the employee did not submit Form 89-350-98, enter zero for the number of exemptions.
Other Exemptions	Enter the number of dependents claimed by the employee on Form 89-350-98.
Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and the Allowance, which are used in determining the net income tax.

Standard Deduction

The Standard Deduction is a variable amount deduction applied to all employees. The amount of the deduction depends on the employee’s filing status.

If the status is	Then the deduction is
S	$2,300
M	$2,300
H	$3,400
1	$4,600
Allowance

The Allowance depends on the amount of the personal exemption claimed in the first Exemptions field and the number of dependents claimed in the Other Exemptions field. The Allowance is determined by the following formula:

Amount of Personal Exemptions (see table) + ($1,500 * number of Other Exemptions)

If the number is	And the status is	Then the amount is
0	S, M, H, or 1	0
1 or more	S	$6,000
1 or more	H	$9,500
1 or more	M	$6,000
1 or more	1	$12,000
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Mississippi state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, and 401(k) and 125/Cafeteria Plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Missouri Tax

As of 12/13/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Missouri:

Status	Enter the marital status claimed by the employee on the Missouri Employee’s Withholding Exemption Certificate, Form MO-W4.  • S for single • H for head of household  • M for married and spouse works • 1 for married and spouse does not work
Exemptions	Enter the total number of allowances claimed by the employee on Form MO W-4. If the employee did not submit Form MO W-4, enter zero for the number of exemptions.
Other Exemptions	Missouri’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the following variables, which are used in determining the net income tax:

•	Standard Deduction

•	Allowance

•	Federal Income Tax

Standard Deduction

The Standard Deduction is a variable deduction applied to all employees. The amount of the deduction depends on the employee’s filing status.

Status	Deduction
S	$5,350
H	$7,850
M	$5,350
1	$10,700
Allowance

The allowance is based on the employee’s filing status and the number of allowances claimed in the first Exemptions field.

Number	Status	Amount
0	S, H, M, 1	0
1 or more	S, M, 1	• $1,200 for the first allowance  • $1,200 for each additional allowance
1 or more	H	• $3,500 for the first allowance  • $1,200 for each additional allowance thereafter
Federal Income Tax Deduction

The Federal Income Tax deduction is the federal income tax withheld. The limits are:

•	$5,000 on a single return (Status: S, H, M)

•	$10,000 on a combined return (Status: 1)

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Missouri state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, federal income tax withholdings, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine the taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Montana Tax

As of 1/17/05

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Montana:

Status	Montana’s tax calculations do not use the Status field.
Exemptions	Enter the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form W-4, enter zero in this field.
Other Exemptions	Montana’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance based on the exemptions claimed by the employee.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $1,900.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Montana state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

5.	Rounds this amount to the nearest dollar.


Nebraska Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Nebraska:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4: • S for single • M for married • H for Head of Household
Exemptions	Enter the total number of withholding exemptions claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Nebraska’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance based on the exemptions claimed by the employee.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $1,530.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Nebraska state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


New Jersey Tax

As of 12/2/04

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of New Jersey:

Status	Enter the appropriate rate variable (A, B, C, D, or E) for the New Jersey rate table to be used for the employee: • A for single, or married and withholding at a single rate on federal Form W-4; or, if Box 1 or 2 in Item 2 is checked on Form NJ-W4. • B for married on federal Form W-4; or, if Box 2, 4, or % is checked on Form NJ-W4.  • C for an optional table chosen by employee on Line 3 of Form NJ-W4. • D for an optional table chosen by employee on Line 3 of Form NJ-W4.  • E for an optional table chosen by employee on Line 3 of Form NJ-W4.
Exemptions	Enter a the total number of allowances claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness.
Other Exemptions	Enter the number of exemptions for dependents.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the Exemptions and Other Exemptions fields. It is determined by multiplying the number of exemptions in the first Exemptions field by $1,000, and the number of exemptions in the Other Exemptions field by $1,500.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's New Jersey state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance and 401(k) plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


New Mexico Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of New Mexico:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4:  • S for single • M for married • H for Head of Household
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents
Other Exemptions	New Mexico’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of Exemptions by $3,450.


How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's New Mexico state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


New York State Tax

As of 12/23/05

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of New York:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4:  • S for single • M for married
Exemptions	Enter the total number of withholding exemptions claimed by the employee on New York State Employee’s Withholding Certificate, Form IT-2104. If the employee did not submit Form IT-2104, use the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents
Other Exemptions	New York’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and an Allowance which are used in computing the net income tax.

Standard Deduction

The Standard Deduction (annualized exclusion) is a table-based deduction applied to all employees. The amount of the deduction depends on the employee’s filing status as follows:

Status	Deduction
Single	$6,975
Married	$7,475
Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $1,000.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's New York state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


City of New York, Non-resident Tax
City of New York, Nonresident Tax

As of 6/28/00

Elimination of Tax

The City of New York has eliminated the nonresident tax. For reporting purposes, the City of New York Nonresident locale remains active in Deltek Advantage.

To comply with the elimination of the tax and to prevent additional withholdings, we recommend that you:

1.	Display the Payroll Withholding Setup Form for your City of New York Nonresident withholding.

2.	Select the Suppress when processing payroll field.


City of New York, Resident Tax

As of 12/23/05

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of New York City:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4:  • S for single • M for married
Exemptions	Enter the total number of withholding exemptions claimed by the employee on New York State Employee’s Withholding Certificate, Form IT-2104. If the employee did not submit Form IT-2104, use the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents
Other Exemptions	The City of New York’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and an Allowance, which are used in determining the net income tax.

Standard Deduction

The Standard Deduction (annualized exclusion) is a table-based deduction applied to all employees. The amount of the deduction depends on the employee’s filing status as follows:

Status	Deduction
Single	$5,000
Married	$5,500
Allowance

The Allowance is based on the number of exemptions entered in the first Exemption field. The Allowance is determined by multiplying the number of exemptions by $1,000.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's City of New York Resident tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

The table used to calculate City of New York Resident tax is different from the table used to calculate New York State taxes.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


North Carolina Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of North Carolina:

Status	Enter the status claimed by the employee for federal income tax purposes on Form W-4:  • S for single • M for married • H for Head of Household • W for qualifying Widow/Widower
Exemptions	Enter the total number of withholding allowances claimed by the employee on the North Carolina Employee’s Withholding Exemption Certificate, Form NC-4.
Other Exemptions	North Carolina’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and an Allowance.

Standard Deduction

The Standard Deduction is a table-based deduction that applies to all employees. The amount of the deduction depends on the employee’s filing status as follows:

Status	Deduction
Single	$3,000
Married	$3,000
Head of household	$4,400
Qualifying widow/widower	$3,000
Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $2,500.

If the annual income equals or exceeds the following amounts for the employee’s filing status, it is determined by multiplying the number of exemptions by $2,000.

Status	Deduction
Single	$60,000
Head of Household	$80,000
Married	$50,000
Qualifying Widow/Widower	$50,000
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's North Carolina state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deductions, Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine the taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

5.	Round the final results of calculations to the nearest whole dollar.


North Dakota Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of North Dakota:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4. You must select S or M in Employee Payroll Withholding Table Maintenance before processing payroll.  • S for single • M for married
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	North Dakota’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes an Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $3,400.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's North Dakota state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. The amount is rounded to the nearest whole dollar.


Ohio Tax

As of 9/6/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Ohio:

Status	Ohio’s tax calculations do not use the Status field.
Exemptions	Enter the total number of withholding exemptions claimed by the employee on the Ohio Employee’s Withholding Exemption Certificate, Form IT-4.  This figure includes: • personal exemptions for self and spouse not claimed  on other Form IT-4. • exemptions for dependents. • If the employee did not submit Form IT-4, enter zero in  this field.
Other Exemptions	Ohio’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used to determine the net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $650.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Ohio state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Oklahoma Tax

As of 12/13/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Oklahoma:

Status	Enter the status claimed by the employee for federal income tax purposes on Form W-4:  • S for single • M for married
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Oklahoma’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the Exemptions field. It is determined by multiplying the number of Exemptions by $1,000.00.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Oklahoma state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Oregon Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Oregon:

Status	Enter the status claimed by the employee for federal income tax purposes on Form W-4:  • S for single and claiming fewer than 3 exemptions • M for married, or single and claiming 3 or more exemptions If the employee did not submit Form W-4, enter S in this field.
Exemptions	Enter the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit Form W-4, enter zero in this field.
Other Exemptions	Oregon’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes a Standard Deduction, Federal Income Tax Deduction and a Credit. These variables are used to determine net income tax.

Standard Deduction

The Standard Deduction is a table-based deduction applied to all employees. The amount of the deduction depends on the number of regular exemptions claimed in the first Exemptions field and the employee’s filing status.

Status	Deduction Per Exemption
Single	$1,870
Married	$3,740
Federal Income Tax Deduction

The Federal Income Tax Deduction is equal to the employee's annualized amount of federal tax withheld, up to a maximum of $5,500.

Credit for Dependents

The Credit is based on the number of exemptions entered in the first Exemptions field. The amount of the Credit is determined by multiplying the number of exemptions by $165.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Oregon state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Federal Income Tax Deduction, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the computed tax by applying Tax Calculation Method 1 to the taxable income.

4.	Subtracts a Credit (if applicable) from the computed tax to determine the net income tax.

3.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

4.	Rounds to the nearest dollar.


Pennsylvania Tax

As of 1/12/04

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Pennsylvania:

Status	The State of Pennsylvania’s tax calculations do not use this field for calculating state taxes.
Exemptions	The State of Pennsylvania’s tax calculations do not use this field for calculating state taxes.
Other Exemptions	The State of Pennsylvania’s tax calculations do not use this field for calculating state taxes.
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Pennsylvania state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Any contributions to 125/Cafeteria plans are subtracted from the gross wages to yield the taxable income.

3.	Applies Tax Calculation Method 2, to the gross wages using a fixed percentage of 3.07% to determine the net income tax.

4.	Divides the annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Puerto Rico Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Puerto Rico:

Status	The Status field is based on the employee’s marital status and how much of the personal exemption the employee is claiming.  Enter the status claimed by the employee on the employee’s Withholding Exemption Certificate: • S for single; or married, not living with spouse. • 1 for married, filing jointly and claiming all of the personal exemption for withholding, or head of household. • 2 for married, filing jointly, and claiming half of the personal exemption for withholding. • 3 for married, living with spouse, filing separately and claiming all of the personal exemption for withholding. • 4 for married, filing jointly and claiming none of the personal exemption for withholding.
Exemptions	Enter the total number of dependents claimed by the employee on the Withholding Exemption Certificate.
Other Exemptions	Puerto Rico’s tax calculations do not use the Other Exemptions field for calculating taxes.
Summary of Deductions

Deltek Advantage automatically computes an optional standard deduction, an allowance, and an deduction based on allowances.

Optional Standard Deduction

The Optional Standard Deduction is based on the employee’s filing status. The following amounts are used:

If the status is	Then deduct
S	$1,300
1	$3,000
2 or 3	$1,500
4	$0
Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $1,600.

Deduction for Allowances

The Deduction for Allowances is based on the amount of the employee’s Optional Standard Deduction. It is determined by dividing the Optional Standard Deduction by $500, rounding the result, and multiplying the rounded result by $500.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Puerto Rico tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Optional Standard Deduction, Allowance, Deduction for Allowances, and any 401(k) plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period. Deltek Advantage then rounds the withheld amount to the nearest dollar.


Rhode Island Tax

As of 1/15/07

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Rhode Island:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4: • S for single • M for married
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Rhode Island’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes an Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $3,400.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Rhode Island state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


South Carolina Tax

As of 12/2/97

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of South Carolina:

Status	South Carolina’s tax calculations do not use the Status field.
Exemptions	Enter the total number of withholding allowances claimed by the employee on the South Carolina Employee’s Withholding Exemption Certificate, Form 1602. This figure includes: • personal exemptions for self and spouse not claimed on other Form 1602. • additional exemptions for age and blindness. • exemptions for dependents. Notes If the employee did not submit a Form 1602, use the number of exemptions claimed for federal income tax purposes on Form W-4. If the employee did not submit a Form 1602 or a Form W-4, enter 1 in this field.
Other Exemptions	South Carolina’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes a Standard Deduction and an Allowance.

Standard Deduction

The Standard Deduction is a variable deduction based on the number of exemptions entered in the first Exemptions field and the employee’s gross annual wages.

Number of exemptions	Standard deduction
0	0
1 or more	10% of the gross wages, up to $2,600
Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $2,300.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's South Carolina state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Utah Tax

As of 12/11/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Utah:

Status	Enter the marital status claimed by the employee for federal income tax purposes on Form W-4: • S for single • M for married
Exemptions	Enter the total number of allowances claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Utah’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes an Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions in the first Exemptions field. It is determined by multiplying the number of exemptions by $$2,040.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Utah state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Vermont Tax

As of 12/8/06

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Vermont:

Status	Enter the marital status claimed by the employee on federal Form W-4:  • S for single • M for married
Exemptions	Enter the total number of withholding exemptions claimed by the employee on federal Form W-4.  This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4. • additional exemptions for age and blindness. • exemptions for dependents.
Other Exemptions	Vermont’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes an Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of withholding exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $3,400.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Vermont state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Virginia Tax

As of 1/13/05

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of Virginia:

Status	Virginia's tax calculations do not use the Status field.
Exemptions	Enter the total number of withholding exemptions claimed by the employee on line 5 of the Virginia Employee’s Withholding Exemption Certificate, Form VA-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form VA-4. • additional exemptions for age and blindness. • exemptions for dependents. If the employee did not submit a Form VA-4, enter zero for the number of exemptions.
Other Exemptions	Enter the number of exemptions for age (65 or older) or blindness that the employee has claimed on Form VA-4.
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Virginia state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Calculates the annualized tax to be withheld by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the annualized tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and an Allowance.

Standard Deduction

The Standard Deduction is a fixed amount deduction, which is applied to all employees. Deltek Vision calculates the deduction using a table based on an annual deduction of $3,000.

Allowance

The Allowance is based on the number of exemptions in the Exemptions and Other Exemptions fields. It is determined by multiplying the number of exemptions in the Exemptions field by $900.00, and the number of exemptions in the Other Exemptions field by $800.00.


West Virginia Tax

As of 1/17/02

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents of West Virginia:

Status	• For an employee with a filing status of two earners, enter 1. • For an employee with a filing status that is not two earners, enter 2.
Exemptions	Enter the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form W-4 • exemptions for dependents. Notes If the employee submitted West Virginia Employee’s Withholding Exemptions Certificate (Form W-4 or Form IT-104), use the number of exemptions claimed for federal income tax purposes on this form. If the employee did not submit Form IT-104 or Form W-4, enter zero in this field.
Other Exemptions	West Virginia’s tax calculations do not use the Other Exemptions field.
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's West Virginia state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages to determine taxable income.

3.	Determines the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemptions field. It is determined by multiplying the number of exemptions by $2,000.


Wisconsin Tax

As of 6/28/00

Use Employee Withholding Payroll Table Maintenance to enter the following field information for residents of Wisconsin:

Status	Enter the status claimed by the employee on Wisconsin Employee’s Withholding Exemption Certificate, Form WT-4: • S for single. • M for married. If the employee did not submit Form WT-4, use the marital status claimed by the employee for federal income tax purposes on Form W-4.
Exemptions	Enter the total number of exemptions claimed by the employee on Form WT-4. This figure includes: • personal exemptions for self and spouse not claimed on other Form WT-4. • additional exemptions for age and blindness. • exemptions for dependents. Notes If the employee did not submit Form WT-4, use the total number of allowances claimed by the employee for federal income tax purposes on Form W-4. If the employee did not submit a Form WT-4 or a Form W-4, enter zero in this field.
Other Exemptions	Wisconsin’s tax calculations do not use the Other Exemptions field.
How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's Wisconsin state tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Standard Deduction, Allowance, and any 401(k) and 125/Cafeteria plan contributions from the employee's annualized gross wages for the pay period to determine taxable income.

3.	Determines the computed tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the annual income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.

Summary of Deductions

Deltek Advantage automatically computes the Standard Deduction and an Allowance, which are used in determining net income tax.

Standard Deduction

The Standard Deduction is a variable deduction applied to all employees. The deduction is based on the employee’s gross wages and filing status.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemption field. It is determined by multiplying the number of exemptions by $400.


City of Detroit Resident and Non-Resident Tax

As of 6/24/04

Use Employee Payroll Withholding Table Maintenance to enter the following field information for residents and non-residents of Detroit:

Status	Detroit’s tax calculations do not use a Status field.
Exemptions	Enter the total number of withholding exemptions claimed by the employee on City of Detroit Income Tax Return, Form D-1040 (R) or D-1040 (NR). If the employee did not submit Form D-1040 (R) or D-1040 (NR), use the total number of exemptions claimed by the employee for federal income tax purposes on Form W-4. This figure includes: • personal exemptions for self and spouse. • additional exemptions for age, blindness, disabled, or deaf. • exemptions for dependents
Other Exemptions	The City of Detroit’s tax calculations do not use the Other Exemptions field.
Summary of Deductions

Deltek Advantage automatically computes the Allowance, which is used in determining the net income tax.

Allowance

The Allowance is based on the number of exemptions entered in the first Exemption field. The Allowance is determined by multiplying the number of exemptions by $750.

How Deltek Advantage Calculates the Tax

Deltek Advantage calculates an employee's City of Detroit Resident tax in the following manner:

1.	Multiplies the employee's gross pay per pay period by the number of pay periods in a year to determine annualized gross wages.

2.	Subtracts the employee's Allowance from the employee's annualized gross wages to determine taxable income.

3.	Calculates the net income tax by applying Tax Calculation Method 1 to the taxable income.

4.	Divides the net income tax by the number of pay periods in a year to determine the amount to be withheld for the pay period.


Notes about Choosing an Installation Date

If you are currently using another computer-based system, you may want to use both your old system and Deltek Payroll for Advantage for the first few payrolls. By running the first two systems in parallel, you can check the accuracy of the data entered when you set up Deltek Payroll for Advantage.


Note about Payroll Hours

You must associate Accrual Codes with any benefit-related projects in Time Analysis Setup before you post timesheets or run payroll, for hours taken to be reflected on the paycheck, Payroll Journal (Reporting, Posting Logs, Payroll Journal), and on the Accrued Time Report.


Note about Print Stock

You can use the same check stock for the Payroll and Accounts Payable applications.


Note about Defining a Bank Code

The option to Post net payroll directly to bank on the Payroll Setup Maintenance form lets you post the credit amount for net payroll to the asset account associated with the specific bank code. If you have Cash-basis Reporting enabled, Deltek Advantage makes cash-basis postings to your general ledger when this option is selected.


Notes about Withholding Types

•	The system allows you to delete a withholding code prior to processing a payroll run. For information on deleting a withholding code, see Payroll Withholding Code Table Maintenance.

•	To change a withholding code or to combine similar withholdings, enter a key conversion.


Note about Directly Depositing an Employee's Entire Paycheck to a Single Account

When you deposit an employee’s entire paycheck to a single account, Advantage prints a void check, which you can then give to the employee.


Note about Directly Depositing an Employee's Entire Paycheck to Multiple Accounts

When you deposit an employee’s entire paycheck to multiple accounts, Advantage prints a void check, which you can then give to the employee.


Note about Directly Depositing a Portion of an Employee's Paycheck to a Single Account

When you deposit a portion of an employee’s paycheck to a single account, Advantage prints a check for this employee. The amount on the check is equal to the employee’s net pay minus the direct deposit amount.


Note about Directly Depositing a Portion of an Employee's Paycheck to Multiple Accounts

When you deposit a portion of an employee’s paycheck to multiple accounts, Advantage prints a check for this employee. The amount on the check is equal to the employee’s net pay minus the direct deposit amount.


Note about Payroll Processing

You should perform a database backup prior to processing payroll.


Note about Performing Payroll Functions in Prior Accounting Periods

You can only process payroll in a prior period if the Allow processing in closed period option is selected for your security workgroup in Security Setup Maintenance.

You should not, however, process payroll in a previous period. Doing so could invalidate any data already processed in subsequent periods (for example, limits on withholdings, wage base considerations for withholdings, etc.). If you attempt to process payroll in a previous period, Deltek Advantage displays a message indicating that doing so may lead to unexpected results.


Notes about Canceling a Payroll Processing Run

•	The Payroll Processing session may be canceled after printing checks. If you do this, you need to destroy the checks created in the session. The system does not update the database.

•	The Posting Log Review report maintains an audit log of all canceled runs and the point at which the runs were canceled.


Notes about Regular Payroll Processing

•	Prior to processing, review the Draft Payroll Journal, make any necessary changes in employee information, and then review the Draft Payroll Journal again. This review can significantly reduce errors during processing.

•	Any draft changes will flow through to the final run unless you cancel the run completely.

•	You should perform a database backup prior to processing payroll.

•	Deltek Advantage can accrue employee benefit hours automatically when you process a regular payroll.


Notes about Choosing a Selection Type

•	You can only have one open payroll processing session. Once a payroll processing session is in progress, you can exit and re-enter payroll processing at the point where you left off.

•	During Automatic Payroll Processing, all employees are scheduled for processing. When reviewing employees, you do not have the option to deselect an employee for processing. If you do not want to process all employees, use Manual Select Payroll Processing.

•	Because Automatic Payroll Processing automatically schedules all employees with timesheet hours posted for processing, you should review employees prior to processing checks. This will allow you to modify pay rates, withholdings, etc., prior to making the data a permanent part of the system.

•	You can include employees with a zero pay rate in manual regular, bonus, and adjustment payroll processing runs. You cannot include these employees in an automatic payroll processing run.

•	You can only process payroll in a prior period if the Allow processing in closed period option is selected for your security workgroup in Security Setup Maintenance.

You should not, however, process payroll in a previous period. Doing so could invalidate any data already processed in subsequent periods (for example, limits on withholdings, wage base considerations for withholdings, etc.). If you attempt to process payroll in a previous period, Deltek Advantage displays a message indicating that doing so may lead to unexpected results.

•	If you process an employee with hours posted during this payroll time period and a payroll rate of 0.00, the system will process a blank check for this employee.


Notes about Entering Selection Criteria for an Automatic Payroll Processing Run

•	If you define multiple auto selections for a Payroll Processing session, the system includes only employees who meet all criteria in the processing run.

•	To sort checks by name, click on the Employee Name radio button. To sort checks by number, click on the Employee Number radio button.


Note about Reviewing Employees for a Payroll Processing Session

Any changes you make here will only affect the current payroll processing session. If you override an amount on the Employee Review form, the system displays an asterisk next to the override value on the Payroll Journal.


Note about Selecting/Deselecting an Employee for Processing

If an employee is already selected for processing, the Select button appears as Deselect. If an employee is not already selected for processing, the Deselect button toggles to Select.


Notes about Modifying an Employee's Regular and Overtime Pay Basis Hours

•	During Manual Select Payroll Processing, you must click on the Select button prior to modifying the hours. When you click this button, Deltek Advantage changes the background color of these fields, indicating they can be modified.

•	You can obtain a quick overview of current, quarter-to-date, and year-to-date hours and pay figures if you click on the Hours and Pay button.

•	Adjusting a salaried employee’s payroll hours only updates that employee’s individual payroll history total pay hours. To adjust a salaried employee’s pay, specify an amount in the Other Pay field.


Notes about Specifying Other Pay Amounts for the Current Pay Period

•	For regular payroll runs, the other pay amount defaults to the amount specified at the Other Pay field on the Payroll tab in Employee Table Maintenance. This field is used to supplement the base pay with an amount that does not vary from period to period. For example, this field may contain a living allowance or hazardous duty pay. When you override this amount, you replace (rather than add) that amount for the next run.

•	During Manual Payroll Processing, you must click on the Select button prior to specifying an other pay amount. When you click this button, Deltek Advantage changes the background color of this field, indicating it can be modified.

•	You can obtain a quick overview of current, quarter-to-date, and year-to-date other pay figures if you click on the Hours and Pay button.

•	You can enter recurring other pay amounts on the Payroll tab of Employee Table Maintenance.


Notes about Overriding Withholding Amounts for the Current Pay Period

•	If, in an Employee Review session, you try to override a withholding that is suppressed at the system level, the system displays a message.

•	A suppressed withholding will remain suppressed until you deselect the Suppress box in Employee Table Maintenance.

•	A suppressed withholding will not add to the gross wages on any report related to the withholding.

•	You can obtain a quick overview of current, quarter-to-date, and year-to-date withholding amounts if you click on the Withholdings button in Payroll Processing.


Note about Viewing Hours and Pay Details for the Employee

Timesheet hours are from the timesheet postings since the last payroll processing session that included this employee. You can modify pay hours on the Employee Review form.


Note about Viewing Withholding Details for the Employee

You set up these withholdings by clicking on the Withholdings button from the Payroll tab of Employee Table Maintenance. You can open Employee Table Maintenance with a payroll session in process to modify employee withholdings.


Note about Viewing the Employee's Direct Deposit Details

You set up these details by clicking on the Direct Deposit button from the Payroll tab of Employee Table Maintenance. You can open Employee Table Maintenance with a payroll session in process to modify employee direct deposit information.


Notes about Processing Checks

•	If you click on the Process Checks button and there are no employees selected for processing, a message appears indicating that there is no active payroll process. If you are manually selecting employees, you must select one or more employees prior to proceeding.

•	Payroll checks print on specific forms produced for Deltek. To obtain check stock for Deltek Advantage, see Ordering New Check Stock. You can use the same check stock for both Accounts Payable and Payroll checks.


Notes about Printing Checks

•	Prior to printing, Deltek Advantage produces the checks in Print Preview mode. If you see any mistakes, close out of Print Preview and cancel the run.

•	If a problem occurred during the printing of checks, you can re-click the Print button, locate the check(s) that you need to re-print, and select to print only that check or selected checks (from the File Menu select Print and specify a page range).

•	Deltek Advantage prints up to 17 withholding detail lines on an employee paycheck stub. If an employee has more than 17 withholdings, Deltek Advantage prints 16 detail lines and prints a consolidated total, labeled Other for withholdings 17 and above. The consolidated total, labeled Other, also includes the amounts of any withholdings not designated to "print on paycheck," as specified in Payroll Withholding Setup.

•	You must print checks prior to assigning check numbers. The print preview will not satisfy this requirement, so be sure to print the file to the printer!


Notes about Assigning Check Numbers

•	You may not assign check numbers until after checks have been printed.

•	You must assign numbers prior to posting.

•	If your checks printed successfully on the first try, assign numbers for remaining checks sequentially. If there is a gap in the printing due to a printer error, use the assign check number for a single check method.


Notes about Assigning Check Numbers for Remaining Checks

•	The sequential assignment can start with any check in the file. All of the checks following the selected check will be assigned sequentially. You can jump to any check to assign remaining check numbers from if there was a problem with the initial printing of the check file.

•	Ensure that your printed check numbers are sequential prior to choosing this option.

•	You must assign check numbers prior to posting the Payroll Processing file.


Notes about Posting Payroll

•	The Payroll Processing Log differs slightly depending on how you have your accounts set up in Payroll Setup Maintenance and Payroll Withholding Code Setup Maintenance. For example, you may set up your Salaries Payable account as an asset account such as your Checking account. Or, you may decide to specify a different FICA account.

•	You can post bonus and other pay amounts to their own cost accounts.

•	The system allows a liability for the Job Cost Variance account. See the Timesheets tab of General System Setup Maintenance for more information.


Note about Posting to Record Other Payroll-Related Disbursements

You can also set up this liability in the Accounts Payable module, and generate the check through this module.


Notes about Viewing the Payroll Posting Logs

•	You can either print the posting logs immediately after the posting or later by selecting the posting log(s) from the Reporting, Posting Logs menu.

•	You can print multiple payroll posting logs when reprinting the posting logs from the Reporting, Posting Logs menu.

−	To select multiple, sequential posting logs, hold down the <Shift> key and click on the first and last posting logs in the range to print.

−	To select multiple, non-sequential posting logs, hold down the <Ctrl> key and click on the individual posting logs to print.

•	An asterisk appears on the Payroll Journal to indicate a manual override on a value.


Notes about the Payroll Journal

•	The heading of the Payroll Journal indicates whether this report is for a bonus or adjustment payroll run. For example, if you run the Payroll Journal for an Adjustments run, the heading lists Payroll Journal (Adjustments). If this is a regular run, the system simply displays Payroll Journal as the heading.

•	If you overrode a withholding during Employee Review, the system places an asterisk (*) next to that withholding.

•	You can print multiple Payroll Journal posting logs when reprinting the posting logs from the Reporting, Posting Logs menu.

−	To select multiple, sequential posting logs, hold down the <Shift> key and click on the first and last posting logs in the range to print.

−	To select multiple, non-sequential posting logs, hold down the <Ctrl> key and click on the individual posting logs to print.


Notes about Direct Deposit Processing

•	If you select a payroll run that has no employees set up for direct deposit, Deltek Advantage displays a message indicating that there are no direct deposit transactions for the run.

•	Most of the fields on this screen only need to be set up for the first direct deposit processing run (that is, the system retains the values for these fields). However you need to enter an Effective Entry Date and Output File Name for each run.


Note about ADP Processing Steps

Whoever has access to your company’s Payroll system has access to the ADP setup fields in Deltek Advantage.


Note about W2 Forms

If desired, you can use Deltek Payroll for Advantage to print W-2 information on plain paper, and then transfer the information by hand or typewriter onto the W-2 Forms.


Note about Entering State Identification Numbers

You need to set up any state IDs prior to generating the work file. Any state IDs set up after generating the work file will not automatically be incorporated into the work file – this is to allow for total editing control of the data after generating the work file.


Notes about Printing/Previewing W-2 Forms

•	To help ensure proper form printing and alignment, you should fan (flip through the individual forms by hand) the forms before loading them into your printer. Fanning the forms helps to relieve contact between the forms, which can sometimes lead to inconsistent feeding of the forms by the printer, producing variation of the alignment of the printouts from page to page.

•	You should load more forms into the printer than you will actually need to print to help alleviate the inconsistent feeding into the printer sometimes experienced when the last form fed in the printer is followed by regular, blank paper stock.


Note about Magnetic Media Reporting

Deltek Advantage does not verify the correctness of information in the W-2 information file. You must review all W-2 information and make any necessary changes for individual employees using the Form W-2 Editor (accessed by clicking on the Edit button) prior to running the Magnetic Media Report program.


Notes about Defining Options for the Employee Payroll List

•	Reports run reflect the amounts up through and including the selected W-2 year and quarter as of the active fiscal period selected for the current Deltek Advantage session.

•	If row-level security is implemented, Deltek Advantage only displays employees on the reports according to your security workgroups access rights.


Notes about the Employee Payroll List

•	The Employee Payroll List does not include the wages subject to withholding for each withholding type. You can get this information by displaying Employee Payroll History for the desired employee(s).

•	If row-level security is implemented, Deltek Advantage only displays employees on the reports according to your security workgroups access rights.


Note about How to Use the State Unemployment Insurance Worksheet

If you enter a specific state in the State field on the Options tab and the state does not have a withholding set up, the system will not generate this report. If this occurs, delete the state abbreviation appearing in the State field on the Options tab and run the report again.


Note about Row-level Security for Payroll Reports

If row-level security is implemented, Deltek Advantage only displays employees on the reports according to your security workgroups access rights.


Note about Changing a Withholding Code

Because of payroll history implications, you cannot convert one withholding code into another.


Tips on Establishing Employee Payroll Information

To switch quickly from one employee to another, enter the desired employee number in the Select field. Double-click or press the F3 key in this field to perform a lookup.

Deltek Advantage remains on this field until you begin modifying the displayed employee information. Thus, you can switch from employee to employee and review the data displayed without leaving this field.


Tip on Selecting Employees

Another way to select an employee from the lookup list is to double-click on the employee’s name.


Note about Tax Calculations

We provide you with three yearly payroll updates: December, January, and July.


Note about Tax Calculation Method 3

Some states apply different fixed percentages depending on marital status and annual gross pay.