Contents of the Create EFTPS Payroll Tax Deposit File Screen

Use the fields and options to configure the Create EFTPS Payroll Tax Deposit File screen.

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use this group box to define the parameters for creating the EFTPS Payroll Tax Deposit File.

Taxable Entity

Use these fields to enter taxable entity information.

Field Description
Option

This field displays One as the range option.

Start

Enter, or click to select, the ID for the taxable entity for which you are creating the EFTPS Payroll Tax Deposit File. Establish taxable entity information on the Configure Company Information screen.

Effective Deposit Date

Enter deposit date information.

Field Description
Option

This field displays One as the range option.

Start

Enter, or click to select, the first day of the month, in date format, of the effective deposit date of the Payroll Tax Deposit File. For example, enter 04/01/16 for the first quarter tax period of 2016.

Pay Cycle

Enter pay cycle information.

Field Description
Option

This field displays One as the range option.

Start

Enter, or click to select, the pay cycle for which you want to create the Payroll Tax Deposit File (you can create only one pay cycle at a time). If you have selected a Default Pay Cycle on the Configure Payroll Settings screen, it displays in this field.

Direct Deposit Setup

Enter direct deposit information.

Field Description
Option

This field displays One as the range option.

Start

Enter, or click to select, the direct deposit settings record that you have previously set up for your tax deposits.

Tax Period

Enter tax period information.

Field Description
Option

This field displays One as the range option.

Start

Use the drop-down list to select the tax period for which you are making this tax deposit.

Check Date

Use the fields in this group box to enter the range of checks to be included in this tax deposit. The check dates must be within the period selected in the Tax Period field and can include checks in the Payroll Edit table and/or Employee Earnings table, depending upon your reporting source selection.

Field Description
Option

This field displays Range as the range option.

Start

Enter, or click to select, starting check date for the range of paychecks to be included in this tax deposit.

End

Enter, or click to select, the ending check date for the range of paychecks to be included in this tax deposit.

Options

Field Description
Transaction Type

From the drop-down list, select the transaction type. Valid options are:

  • Deposit: Select this option to create a deposit file.
  • Prenote: Select this option to create a prenotification file.
Financial Agent Bank

Use this drop-down list to select the bank to which your financial institution is electronically paying the tax deposit. The bank you select depends on your location in the United States. Options include:

  • Bank One: Select this option if your company is in the Northern and Western United States. Refer to your EFTPS Payment Instruction Booklet for details. (Bank One was formerly First Chicago.)
  • Bank of America: Select this option if your company is in the Southern and Southwestern United States. Refer to your EFTPS Payment Instruction Booklet for details. (Bank of America was formerly Nations Bank.)
File Location

Enter the location of the file you are creating. There are two ways to do this:

  • In the File Location field, enter, or click to select, the alternate file location where you want to store the export file. Alternate file locations are set up on the Manage Alternate File Locations screen.
  • Leave the File Location field blank. When you execute this application, the export file is saved to the Costpoint database. Use the Export Files application to retrieve it and save it to a location on the network.
File Name

Enter, or click to select, the name of the file being created.

Overwrite File

Select this check box to overwrite an existing file with the same file name.

Reporting Source

Use this group box to select the source of the paychecks you want to include in the tax deposit. You must select one or both of the check boxes.

Field Description
Payroll Table

Select this check box if you have payroll records that have not been posted to the General Ledger and you want to include these paychecks in the tax deposit.

Earnings Table

Select this check box if you have payroll records that have been posted to the General Ledger that you want to include in the tax deposit.

Reporting Information

This group box contains the tax deposit information that is used to print the report and create the tax deposit file. You can populate the fields in this group box by clicking the Calculate button. If your tax deposit amounts differ from the calculated amounts, you can override them. If you enter any override amounts in the fields, **** prints in the Override column of the report.

Field Description
Social Security Withheld

Click the Calculate button to populate this field with the total social security tax withheld from employee paychecks. To report an override amount, enter the amount in this field.

Social Security Accrued

Click the Calculate button to populate this field with the total social security tax accrued by the employer. To report an override amount, enter the amount in this field.

Federal Tax Withheld

Click the Calculate button to populate this field with the total federal income tax withheld from employee paychecks. To report an override amount, enter the amount in this field.

Medicare Withheld

Click the Calculate button to populate this field with the total Medicare tax withheld from employee paychecks. To report an override amount, enter the amount in this field.

Medicare Accrued

Click the Calculate button to populate this field with the total Medicare tax accrued by the employer. To report an override amount, enter the amount in this field.

Leading Value for Tax ID 

From the drop-down list, select the one-digit numeric value that precedes the tax ID in the Company Identification field of the EFTPS file's Batch Header Record (column 41) and Company/Batch Control Record (column 45). Valid options are:

  • 1: Select this option if only one identifier is needed or if each unit has a unique IRS employer ID number.
  • 9: Select this option if each unit does not have a unique IRS employer ID number or if batches are varied because of unique settlement accounts.
Calculate

Click this button to populate the fields in the Reporting Information group box.

Print

Click to print the tax deposit report.  

Note: When you modify any of the print options or selection criteria after printing the report, you cannot create the Payroll Tax Deposit File. You must print the tax deposit report again before creating the Payroll Tax Deposit File.
Print and/or Create the EFTPS Tax Deposit File

Click the arrow to the right of and select one of the following options:

  • Print/Create EFTPS Tax Deposit File: Select this option to print and create the FUTA Quarterly Tax file based on employer FUTA accrued totals. Costpoint displays a message asking if you really intend to create the EFTPS FUTA Quarterly Tax Deposit File. Click OK to print the tax deposit report and create the file. You can also select this option from the print menu.  After the program begins creating the file, a DO NOT INTERRUPT message and a message showing records processed displays.
  • Create EFTPS Tax Deposit file: Select this option to create the EFTPS Tax Deposit file after you have first printed the file. This option becomes available after you print the Tax Deposit report. When you receive a message asking if you really intend to create the tax deposit file, click OK.
Note: When you modify any of the print options or selection criteria after printing the report, you must print the Tax Deposit report again before creating the Quarterly Tax Deposit File. If you click after changing a parameter, the report prints automatically as part of the creating process.
  • Calculate Amounts: Select this option to populate the fields in the Reporting Information group box. You can also click the Calculate button.
  • Batch Mode/Print/Create EFTPS Tax Deposit File: Select this option to schedule when to print the report and create the FUTA Quarterly Tax file based on employer FUTA accrued totals. You can also select this option from the Print menu.