Create Entries Tab of the Bank Statement Reconciliation Form

Use this tab to create bank statement entries for bank fees and bank interest if there are user-defined bank entries set in Accounting > Configuration > Banks.

Contents

Field Description
Transaction Date Enter a transaction date or click to select a transaction date.
Replace existing unposted cash entries of same file names Select this check box if you previously created a bank entry for the transactions that is not yet posted, and you want to replace it with this new entry. The transaction file that contains the bank statement entry must have the same file name as the transaction file that you are replacing. You enter this name in the Cash Receipt Batch name field or Cash Disbursement Batch name field.
Cash Receipt Batch Name Enter the transaction file name for the cash receipt entry. It prefills with "<Bank code> <Transaction Date entered on this tab> <Code for your company in Vision>." You can change the name.
Cash Disbursement Batch Name Enter the transaction file name for the cash disbursement entry. It prefills with "<Bank code> <Transaction Date entered on this tab> <Code for your company in Vision>." You can change the name.
Diary

This field displays only if you have set up a diary in Accounting System Settings Configuration for the fiscal period or fiscal year in which you are entering transactions.

Use this field to select a diary code for the current transaction or the group of transactions if you are processing a group of transactions, such as an accounts payable payment processing run. The diaries are used to generate diary reports that contain a set of sequentially numbered transactions that have been posted to the general ledger during the fiscal year or to specific fiscal periods. You can assign different diaries (that have different diary types) to different types of transactions.

The Diary drop-down list contains three columns. The first column displays the diary code. The second and third columns display the diary type for the diary code and the description of the diary type.

The drop-down list contains all the diaries that you set up on the Diary Auto Numbering tab in Configuration > Accounting > System Settings that have the same fiscal period or fiscal year in which you are entering transactions, or no fiscal period or year entered for them.

If you have multiple companies, the Diary drop-down list includes only the diary codes that are set up for the current company. The list also includes IC - Intercompany Diary to capture intercompany transactions.

You cannot delete a transaction after it has been saved with a diary number. If a transaction is incorrect, you can enter zero amounts for the transaction, or enter a reversing transaction.

Reference Number Enter the reference number for the bank entries. The values for this field identify the bank entries in the Transaction List report.
Post Transaction File When Created Select this check box to automatically post the bank entry transaction file when it is created.

This option only displays if your security access rights include Full Access to all Transaction Types or the Post option selected for Bank Reconciliation transaction type, and the company, on the Accounting Tab of Configuration > Security > Roles.

Create Bank Statement Entries Button Click this button to create the bank entry (cash receipt or cash disbursement).

Review the bank entry in Transaction Center > Transaction Lists. Then post it in Transaction Center > Transaction Posting.