CREATE EFTPS FUTA QTRLY TAX DEP 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 will report 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. You should transmit the file to your financial institution one business day before the due date. The bank will electronically transmit the tax payments on the tax due date, and your records for the IRS will be 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 in the Direct Deposit Setup screen, you can create the EFTPS FUTA Quarterly Tax Deposit File.

After you have created payroll, reviewed the Payroll Edit Report, and printed paychecks and/or direct deposit advices, you can generate the FUTA Quarterly Tax Deposit File that will contain 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. Once 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.

Select

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

Taxable Entity

Enter, or use Lookup to select, the taxable entity ID for which you are creating the EFTPS FUTA Quarterly Tax Deposit File. This is a required field.

Effective Deposit Date

Enter 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/02 for the first quarter tax period of 2002.

Pay Cycle

Enter, or use Lookup 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 in the Payroll Settings screen, it will display in this field. This is a required field.

DD Setup

Enter, or use Lookup to select, the direct deposit settings record that you have previously set up for your tax deposits. This is a required field.

Tax Period

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

Deposit

Select this radio button if you are creating a deposit file.

Prenote

Select this radio button if you are creating a prenotification file.

Check Date Range

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

From

Enter 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." This is a required field.

To

Enter the ending check date for the range of paychecks to be included in this tax deposit. The system format for the date is "MM/DD/YYYY." This is a required field.

Financial Agent Bank

Use this group box to select the bank to which your financial institution will be electronically paying the tax deposit. The bank you select depends on your location in the United States.

Bank One

Select this radio button 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.)

Bank of America

Select this radio button 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.)

Reporting Source

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

Payroll Table

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

Earnings Table

Select this checkbox if you have payroll records that have been posted to the General Ledger that you wish to include in the tax deposit.

Reporting Information

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

FUTA Accrued

Select the Calculate pushbutton 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         

Enter the one-digit numeric value that will precede 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).  Enter "1" if only one identifier is needed or if each unit has a unique IRS employer ID number.  Enter "9" if each unit does not have a unique IRS employer ID number or if batches are varied because of unique settlement accounts.

EFTPS File Name

Enter the FUTA Quarterly Tax Deposit File name and path in this required field. If no path is given, the file will be written to your default directory. Every time you create the FUTA Quarterly Tax Deposit File, a new file is written.

Note: 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.

Note: When you change any of the print options or selection criteria after printing the report the Create the EFTPS Tax Deposit file button on the toolbar is grayed out. You will have to print the Tax Deposit report again before creating the Quarterly Tax Deposit File. If you select the Process/Print button on the toolbar after having changed a parameter, the report prints automatically as part of the creating process.

Create the EFTPS Tax Deposit file

When you first enter this screen, this button on the toolbar is grayed out. The button becomes available after you have printed the Tax Deposit report. If you select this button, you will receive a message box asking if you really intend to create the tax deposit file. If you answer "OK," the EFTPS FUTA Quarterly Tax Deposit File will be created.

Calculate

Select this pushbutton to populate the FUTA Accrued field in the Reporting Information group box.

Process/Print

This button on the toolbar is available at any time. If you select it, you will receive a message asking if you really intend to create the EFTPS FUTA Quarterly Tax Deposit File. If you answer OK, the tax deposit report prints and the file is created immediately after.

After the system begins creating the file, a "DO NOT INTERRUPT" message and a message showing records processed will display.

Report Sources

Direct Deposit Settings - DIR_DEP_SETTINGS

Maintain Payroll Edit Table - EMPL_PAYROLL

Maintain Employee Earnings Table - EMPL_EARNINGS

Pay Period - PAY_PD

State - STATE

Taxable Entity - TAXBLE_ENTITY