Bank Account Screen Field Reference

General tab

Field

Description

Bank Name

Enter the name of the bank associated with the account.

Status

Click to select the status of the bank account.

  • Active - The bank account is available for use and appears in lookup lists.

  • Inactive - The bank account is not available for use and does not appear in lookup lists on other screens. However, it persists in previous selections.

Memo

Enter any comments or notes about the bank account.

Check Setup

Use For Payroll

Specify whether this bank account will be used for payroll. If this field is set to No, the Use For Accounts Payable field must be set to Yes.

Note: This field is only available if the general ledger account associated with the bank account is a cash account.

Use For Accounts Payable

Specify whether this bank account will be used for activities such as vendor payments and expense reimbursements. If this field is set to No, the Use For Payroll field must be set to Yes.

Use Separate Check Ranges for AP and Payroll

If you selected to use this bank account for both payroll and accounts payable, select the checkbox to indicate that you will use separate ranges of check number for payroll and accounts payable checks. Deselect the checkbox to indicate that you will use the same range of check numbers for payroll and accounts payable checks.

Payroll Last Used Check Number

Enter the last used check number for this bank account. If no checks have been issued from this account, enter 0.

If the account is used for both payroll and accounts payable and you did not select the Use Separate Check Ranges for AP and Payroll checkbox, the number you enter here also displays in the Accounts Payable Last Used Check Number field.

Accounts Payable Last Used Check Number

Enter the last used check number for this bank account. If no checks have been issued from this account, enter 0.

If the account is used for both payroll and accounts payable and you did not select the Use Separate Check Ranges for AP and Payroll checkbox, the number you enter here also displays in the Accounts Payable Last Used Check Number field.

Payroll Check Format

Click to select the format for payroll checks for this bank account.

Tip: You can use the Modify Forms screen to modify the format and layout of the payroll check form.

Payroll Advice Format

Click to select the format for payroll advices for this bank account.

Tip: You can use the Modify Forms screen to modify the format and layout of payroll advice form.

Vendor Payment Format

Click to select the format for vendor payment checks for this bank account.

Tip: You can use the Modify Forms screen to modify the format and layout of vendor payment form.

Supplemental Stub Format

Click to select the format for supplemental stubs for vendor payments for this bank account.

Tip: You can use the Modify Forms screen to modify the format and layout of supplement stub form.

Currency Terms for Checks

Monetary Unit

Displays the monetary unit to appear on checks for the bank account. The default value is Dollars. If needed, enter another monetary unit.

Fractional Monetary Unit

Displays the fractional monetary unit to appear on checks for the bank account. The default value is Cents. If needed, enter another fractional monetary unit.

Direct Deposit tab

Enter details on this tab that will be used to create the direct deposit transfer file that you send to your bank for direct deposits. If you are unsure of the values to enter on this tab, contact your bank.

Field

Description

Bank Routing Number

Enter the nine-digit bank routing number for the account. You can typically find the bank routing number at the bottom of one of your checks.

Institution Number

Enter the 3-digit institution number for the account.

Branch Number

Enter the 5-digit branch number (also known as the transit number) for the account. Note that the first four digits may be the branch number and the fifth digit may be a geographic locator. You can typically find the branch number at the bottom of one of your checks.

Bank Account Number

Enter the bank account number for the account. You can enter up to 20 alphanumeric characters. You can typically find the bank account number after the bank routing number at the bottom of one of your checks or on one of your bank statements.

Company ID

If you entered a bank routing number, defaults to 1 plus the first 9 characters of the company's federal tax ID. If needed, enter the ACH identification number for the bank account. Included in record type 5, position 41-50 in the NACHA file.

Note some banks require the first character of this field indicate the payroll cycle frequency. In this case, use 1 for weekly or 2 for bi-weekly.

Reference Code

Enter the reference code for the bank account, if needed. You can enter up to eight alphanumeric characters. Included in record type 1, position 87-94 in the NACHA file.

Company Name Override

Enter the company name for the bank account. You can enter up to 23 alphanumeric characters. If you leave this field blank, the first 23 characters of the company name associated with the account is used for the NACHA file. Included in record type 1, position 64-86 in the NACHA file.

Entry Purpose

Enter details about the purpose for the transaction. You can enter up to ten alphanumeric characters. For example, you might enter Payroll or VndPmnt. Included in record type 5, position 54-63 in the NACHA file.

Immediate Origin

If you entered a bank routing number, defaults to 1 plus the first 9 characters of the company's federal tax ID. If needed, enter the ACH identification number for the bank account. Included in record type 1, position 14-23 in the NACHA file.

Prenotification

Indicates whether the NACHA file is for prenotification. Prenotification allows you to create a test NACHA file that you can send to your bank for verification. When you send a prenotification file to your bank, no money is sent to employees' bank accounts. Select the checkbox to enable prenotification for the bank account.

Account Type for Balance Entry

Click to select the account type of the balancing entry for the bank account. A balancing entry is the offsetting debit for the total of all deposits (credits). This is the amount that will be deducted from the company's bank account. Your bank may require a balancing entry.

  • No Balancing Entry Required

  • Checking Account (27)

  • Savings Account (37)

Record Type 6 Discretionary Data

Enter the record type 6 discretionary data as needed for the NACHA file. You can enter up to two alphanumeric characters. Included in record type 6, position 77-78 in the NACHA file.

Employee ID Format

Click to select how employee IDs appear in the NACHA file.

  • Employee Number

  • Follow Payroll Settings for Social Security Number Format

  • Full Social Security Number

  • Blank

Direct to Federal Reserve

Select the checkbox to include Federal Reserve information in the NACHA file in place of Bank ID in record types 1 and 6.

File ID Modifier A

Select the checkbox to include an A character in record type 1, position 34 of the NACHA file.

Routing Number Sign

Select the checkbox to include a # symbol in record type 6, position 12 of the NACHA file.

Trace Numbers

Select the checkbox to include trace numbers in record type 6 in the NACHA file. The trace number is comprised of the first eight digits of the bank routing number followed by a sequential number beginning with 0000001 for each direct deposit in the posting group. Your bank may require trace numbers in the NACHA file.

End of File Indicator

Select the checkbox to include the hexadecimal value 1A at the end of record 9 of the NACHA file.

Divisional Security tab

Use this tab to set division-level security for the bank account. If you allow posting to the bank account for a division, you can select the bank account when creating entries for the division on certain screens. If you don't allow posting to the bank account for the division, the bank account will not be available on these screens when you create entries for the division.

The bank account is secured by division on the following screens:

Financial

  • Create Journal Entry

  • Recurring Journal Entry

  • Bank Reconciliation

  • Bank Reconciliation Report

  • Check Listing

  • Check Register

Customers

  • Enter Cash Receipts - Cash Account

  • Void Cash Receipts - Cash Account

Vendors

  • Enter Vendor Invoice - Cost Account

  • Adjust Vendor Invoice - Cost Account

  • Recurring Vendor Invoice Setup - Cost Account

  • Generate Recurring Vendor Invoices - Cash Account

  • Select Vendor Invoices for Payment - Cash Account

  • Enter Vendor Pre-Payment - Cash Account

  • Enter Purchase Order - Cost Account

  • Enter Subcontract - Cost Account

  • Enter Subcontract Change Order - Cost Account

  • Void Vendor Payment - Cash Account

Employees

  • Start a Payroll Cycle - Cash Account

  • Create Direct Deposit Transfer File - Bank Account

  • Void Payroll Checks & Advices - Account

CAUTION: There are exceptions to this security. Some screens allow posting to the bank account for a division even if the Allow Posting checkbox is not selected for the division. For example, if a user has permissions to the Enter Stock Receipts screen, that user can enter stock receipts for the division, select the bank account as the offset account, and post the receipts. If you want to prevent this user from posting to this account, set the screens to No Access on the Functions Permissions tab of the Users screen.

The bank account is not secured by division on the following screens:

  • Enter Stock Receipts - Offset Account

  • Enter Inventory Adjustments - Offset Account

  • Enter Inventory Counts - Offset Account

  • Enter Time Card by Employee - Cost Account

  • Employee - Cost Account

Field

Description

Division

Displays the code for the division.

Division Name

Displays the name of the division.

Allow Posting

Select the checkbox to allow posting to the bank account for this division. Deselect the checkbox to prevent posting to the bank account for the division.

The checkbox is selected by default.