CREATE QUARTERLY EFTPS FUTA TAX FILE 

Use this screen to create the EFTPS FUTA Quarterly Tax Deposit File based upon the employer FUTA accrued totals in the tables of the selected reporting source(s). The program adds the amounts in the reporting source(s) and performs no other calculations. The process does not verify that the amounts are correctly calculated. For example, if an employee's FUTA accrued amount is not the correct amount according to the current year's rate, the process reports the amount that is in the record, rather than the correct amount. For this reason, you should ensure that the amounts are correct before performing this process.

The FUTA Quarterly Tax Deposit File is a single text file that you can submit to the IRS electronically after each payroll, monthly or quarterly. Transmit the file to your financial institution one business day before the due date. The bank electronically transmits the tax payments on the tax due date, and your records for the IRS are automatically updated. This file is directly related to the Federal Form 940 and reports FUTA accrued. You can select records from the Payroll table and/or Earnings table, depending on your reporting requirements.

After you have set up your financial institution information on the Configure Direct Deposits screen, you can create the EFTPS FUTA Quarterly Tax Deposit File.

After you create payroll, review the Payroll Edit Report, and print paychecks and/or direct deposit advices, you can generate the FUTA Quarterly Tax Deposit File that contains the payment data to be transmitted to the bank for the tax period you are reporting, if you have selected Payroll Table in the Reporting Source group box. You must create this file before posting the Payroll Journal. After the Payroll Journal is posted, the data required for creating the FUTA Quarterly Tax Deposit File is no longer available unless you select Earnings Table in the Reporting Source group box.

There are two ways to work with export files in Costpoint:

If you decide to use the first option, click in the File Location field to select the alternate file location to which you want to save the file. If you choose the second option, leave the File Location field blank when you export the file.

Location

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 are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

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 in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in 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 in 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 FUTA Quarterly Tax Deposit File.

Taxable Entity

Use these fields to enter taxable entity information.

Option

This field always displays One.

Start

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

Effective Deposit Date

Use these fields to enter effective deposit date information.

Option

This field always displays One.

Start

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

Pay Cycle

Use these fields to enter pay cycle information.

Option

This field always displays One.

Start

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

Direct Deposit Setup

Use these fields to enter direct deposit information.

Option

This field always displays One.  

Start

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

Tax Period

Use these fields to enter tax period information.

Option

This field always displays One.

Start

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

Check Date

Use these options to enter the range of checks that is included in this tax deposit. The check dates must be within the period selected in the Tax Period group box and may be checks in the Payroll Edit table and/or Employee Earnings table, depending upon your selection in the Reporting Source group box.

Option

This field always displays Range.

Start

Enter, or click to select, the starting check date for the range of paychecks to be included in this tax deposit. The format for the date is MM/DD/YYYY.

End

Enter, or click to select, the ending check date for the range of paychecks to be included in this tax deposit. The format for the date is MM/DD/YYYY.

Options

Transaction Type

Use this drop-down list to select the type of transaction for the file. Options include:

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:

File Location

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

or

You can create the FUTA Quarterly Tax Deposit File as many times as necessary before transmission takes place. Each time this is done, the old FUTA Quarterly Tax Deposit File is overwritten by the new one. If you select the Payroll Table reporting source, any recreation of the FUTA Quarterly Tax Deposit File must take place before you post the Payroll Journal.

File Name

Use this field to specify the name of the FUTA Quarterly Tax Deposit File. Every time you create the FUTA Quarterly Tax Deposit File, a new file is written.

Overwrite File

Select this check box to overwrite an existing file, if it has the same file name.

Reporting Source

Use this drop-down list to select the source of the paychecks you wish to include in the tax deposit. You must select one or both of the check boxes.

Reporting Information

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

FUTA Accrued

Click the Calculate button to populate this field with the total FUTA accrued by the employer. If you wish to report an override amount, enter the amount in this field. This is a required field.

Leading Value for Tax ID         

Use the drop-down list to 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). Select 1 if only one identifier is needed or if each unit has a unique IRS employer ID number.  Select 9 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 FUTA Accrued field in the Reporting Information group box.

Create EFTPS Tax Deposit file

When you first enter this screen, you cannot click the arrow to the right of and select Create EFTPS Tax Deposit File. The option becomes available after you print the Tax Deposit report. If you select this option, you receive a message box asking if you really intend to create the tax deposit file. If you click OK, the EFTPS FUTA Quarterly Tax Deposit File is created.

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.

Print/Create EFTPS Tax Deposit File

If you click the arrow to the right of and select Print/Create EFTPS Tax Deposit File, you receive a message asking if you really intend to create the EFTPS FUTA Quarterly Tax Deposit File. If you click OK, the tax deposit report prints and the file is created immediately after.

After the program begins creating the file, a DO NOT INTERRUPT message and a message showing records processed displays.