Bank Entry Screen (E-Statements)

  1. Open Common Services > Bank Services > Bank Transactions > Reconcile E-Statements.
  2. Click Bank Entry.

Bank Services displays the amount of the transaction in the bank's statement currency for your information.

The bank code identifies the bank account and determines the general ledger accounts that Bank Services updates when you post a bank entry.

In multicurrency systems, the bank code determines the currency for the transaction. (The program displays the bank statement currency in the Currency field on the Bank Entry screen.)

For new bank entries, the program displays the default bank code specified on the Bank Services Options screen, and it displays the description for the bank in the next field. You can change the code until you add a detail for the entry. You cannot leave the bank code blank.

Specify whether the bank entry you are adding is a deposit or a withdrawal.

Enter a descriptive comment for the entry, up to 250 characters.

The program displays the reference from the downloaded transaction as the default description for the bank entry, but you can change the description to suit your company's requirements.

Specify the distribution code that includes the general ledger account you want to update when you post the entry or transfer.

Displays the description for the specified distribution code.

Bank Services automatically assigns an entry number to each new entry you add using the Bank Entry screen, and the number forms part of the audit trail for the bank entry.

To add a new entry, click the New New button button beside the Entry Number field.

You also use the Entry Number field to select an existing entry if you want to view, edit, or delete it. If you delete an entry, you cannot reuse its number.

If a distribution code is specified, this field displays the general ledger account associated with the distribution code. The field to the right displays the description for the general ledger account.

You can change the account, if necessary.

The program displays the reference from the downloaded transaction as the default description for the bank entry, but you can change the description to suit your company's requirements.

Bank Services displays the amount of the transaction in the source currency, for your information.

Specify whether or not an entry is taxable. You specify Yes or No by double-clicking the field.

Note: This field is available only for withdrawals.

This button appears on the Bank Entry screen that you use to designate an unmatched transaction as a bank entry (such as a bank service charge or an interest charge).

Once you have entered the required information for the bank entry, including the distribution code and the G/L account, click the Process button to mark the transaction Cleared.

The program adds the bank entry to the Reconciliation tab on the Bank Reconcile Statements screen, and clears the transaction on the Bank Reconcile E-Statements screen.

When you next click Refresh on the Reconcile E-Statements screen and process the reconciliation entries, the program removes the bank entry from the list of downloaded transactions.

Overview

Use the Bank Entry screen opened from the Reconcile E-Statements screen to record and post an entry in Sage 300, match the bank transaction to the posted entry, and clear the entry all at once.

Note: This screen includes only the fields you need for a single bank entry with one detail.

This screen lets you record certain types of bank entries as you reconcile electronic statements, without having to leave the Bank Reconcile E-Statements screen. You can:

When you open the Bank Entry screen, the program displays the default distribution on the first line of the grid, if you specified a default distribution code in the Bank Options screen. If you need to add a different type of entry, or one that uses a different currency, delete the default distribution line, and then enter the distribution you need.

When you post the reconciliation, Bank Services creates a General Ledger transaction batch for bank entries.