Banks Field List
For help with fields in the Banks window, click the following topics:
The name of the bank account, up to 60 characters. If you have more than one account with the same bank, you may want to distinguish between the accounts by adding a description after the name, for example Current Account, Savings Account, Japanese Yen Account.
Type the number of the bank account (assigned to the account by your bank). This is an optional field unless you will be importing downloaded statements. The number can be up to 22 characters, including punctuation; however, do not use punctuation (including dashes, periods, spaces) if you will be importing statements downloaded from your bank's website.
This option allows you to set a minimum time to keep transactions after they are reconciled.
The program removes only transactions for which a reconciliation was posted at least this number of days before you run Bank Clear History.
The maximum amount that you will accept without investigating the cause of the error.
If the bank clears a check or deposit with an amount that differs from your records, and the difference is less than or equal to the spread, the Bank Services program posts the discrepancy to the General Ledger Clearing Errors account.
If the discrepancy is greater than the spread, you still have the choice of clearing the difference to the Clearing Errors account, but you can also mark it Cleared with Bank Error, which flags the discrepancy as pending further action (such as phoning the bank to request that they correct the error, or making an adjustment entry if the discrepancy is due to a data entry error).
Select this option to set the bank record inactive. The date you set the record inactive displays beside the option.
You can select the Inactive option at any time. For example, you might set the bank Inactive after you close the bank account or if you decide not to use it any more. You could temporarily mark the bank inactive if the account is low on funds, to prevent additional payments from the bank.
You cannot set a bank inactive if there is an unposted reconciliation or any printed and unposted payment checks for the bank.
After you set a bank Inactive, you can finish processing existing transaction batches that involve the bank. However, you cannot use the bank code in new transactions in Bank Services or in other programs or specify the bank as the default for Bank Services. Also, you cannot reconcile or import OFX statements for an inactive bank.
The program automatically updates this field with the Windows system date when you save a new record or make changes to an existing record.
Type the number that you want Bank Services to assign to the next deposit batch for this account.
When you create a deposit batch in Accounts Receivable or in another subledger, Bank Services assigns this number to the batch, as a means of differentiating between deposit batches.
If you use pre-numbered deposit slips, type the number of the next deposit slip that you will use for this bank account.
Type the banking industry code that identifies this bank. This is an optional field unless you will be importing downloaded statements.
The operating account for this bank.
The account to which are posted small discrepancies between the bank statement and the general ledger.
In a multicurrency bank, if the transaction currency is not the same as the statement currency, errors are posted to the Exchange Gain/Loss accounts as chosen on the Currency tab, rather than to the Write-Off account.
The account that is used for writing off credit card charges applied to a deposit. The charges will be written off during bank reconciliation in the same way that bank errors are written off.
Type the bank's address, using up to 60 characters in each address line.
Type the name of the city where the bank is located, using up to 30 characters.
Type the name of a general contact person or position in the bank using up to 60 characters.
Type the name of the country where the bank is located, using up to 30 characters.
Type the company's fax number, up to 30 characters. (The same formatting conditions apply as for Telephone.)
Type the name of the state or the province where the bank is located, using up to 30 characters.
Type the company's telephone number. If you selected Format Phone Number on the Company Profile window in Common Services, type 10 numbers and the program will automatically insert parentheses and hyphens. Otherwise, type up to 30 characters.
Type the bank's zip or postal code, using up to 20 alphanumeric characters.
If you print advices only, or advices following checks, enter the file name of the report specification for the advice form. Click
to locate the file if you are not sure of the file name of the report.Enter a number for the printed detail lines that will fit on the advice form or in the advice section of the check form (for combined checks and advices). Lines that exceed this amount will be printed on subsequent advice pages or combined check/advice forms.
If you print checks only, or checks combined with advices, type the file name of the SAP Crystal Reports report specification for the check form. If you are not sure of the file name, click to display a list of files by drive and folder.
If you are setting up check printing information for a bank, type a unique code, up to six alphanumeric characters, to identify your check stock. The check stock is composed of the physical check forms, combined with report specifications and the check language.
When you print checks for your program, select one of the check stock codes defined for the bank. The description for the code and its type are displayed in the Print Checks window.
Type a description (name) for the check code, using up to 60 characters.
Select one of the installed languages to print the body of the check (that is, the date, written amount, and numerical amount).
If you are setting up check printing information for a bank, type the number that you want to assign to the next check drawn on this account. When you print checks, the program assigns numbers sequentially to the checks in the batch, beginning with this number. When you post the checks, the program updates the next check number in the bank record.
You can edit the number at any time, if necessary.
Select one of the four following physical stock types:
- Combined Check and Advice. Select this type if your printed check forms contain the advice portion on the same page as the check.
- Checks Then Advices. Select this type if you use different forms for checks and advice slips. The program prints all the checks first, prompts you to load the advice forms, then prints the advices.
- Checks Only. Select this type if you want to print checks only.
- Advices Only. Select this type if you want to print advices only.
The Taxes tab on the Banks window displays the tax authorities associated with the tax group specified for the selected bank.
You cannot add or delete a tax authority on this tab. However, you can change the tax class for a tax authority, or you can change the tax group used for the bank.
This is the tax class associated with the tax authority for the tax group you chose for this bank. Click the Finder in the field to select the vendor tax class, or leave the default.
In this field, use the Finder to select a default tax group to use for this bank when you enter taxable bank entries during bank reconciliation.
Tax groups specify the authorities that tax the services for which the bank charges, and they assign your tax class for each authority. (Tax classes determine the specific classification for a tax — such as the tax rate to apply or whether you are tax-exempt.)
The total of the previous three fields.
This is a quick figure intended to give you a rough idea of your current bank balance. Because the figure includes post-dated items, and because Bank Services does not know which items have cleared the bank yet, the figure may not match your actual balance as calculated by the bank.
The closing statement balance from the last bank statement to which the account was reconciled.
The date to which the most recent reconciliation was posted.
The fiscal year and period of the most recent posted reconciliation.
The date of the most recent statement.
A lump sum of all payments and withdrawals outstanding at the time of the most recent reconciliation, plus payments and withdrawals issued since that date. This figure includes post-dated checks that you have entered in Sage HRMS Payroll, if any.
A lump sum of all deposits outstanding at the time of the most recent reconciliation, plus deposits recorded since that date. This figure includes post-dated deposits that you have entered in Sage HRMS Payroll.