Overview tab

Create and view the transaction lines that are part of the bank statement reconciliation.

General tab

For the selected transaction line, view additional information about amount, payment, voucher, and purchase sales tax.

Dimension tab

Enter or view the dimensions that apply to the transaction line.

Reconcile account

Post the transaction lines that reconcile company bank records with the bank statement, and record the bank statement as reconciled.

Mark check interval

Define an interval of consecutive checks for which you want to select the Clearedcheck box.

Deposit slip

View or edit the deposit slips of the bank account. You can enter a deposit slip number on the line, if appropriate.

Checks

View or edit the checks that have been issued on the bank account. You can enter a check number on the line, if appropriate.

Original document

View the original document that is the basis of the transaction line, if the program can identify it.

Voucher

View the voucher that is the basis of the transaction line, if the program can identify it.

Print

Print a reconciliation summary or the bank reconciliation report.

Bank amount

Enter the amount of the correction.

Show transactions

Select the type of transactions to view in the upper pane.

Opening balance

The balance of the bank account at the end of the last reconciliation.

Ending balance

The ending balance of the bank account as is entered in the Account reconciliationform.

Unreconciled

The amount to be accounted for in the bank statement reconciliation. When you include transactions in the reconciliation by selecting the Clearedcheck box – or by creating new transactions, for which this check box is automatically selected – the amount in this field is continuously recalculated. When the unreconciled amount is zero, and you have included all the transactions that appear on the bank account statement, you can post the account reconciliation.

Note
Click Reconcile accountto post the account reconciliation.

Cleared

Select to include the transaction in the account statement that you are reconciling.

Note
This check box is not available if the transaction has a status of Pending cancellation. Transactions might have this status if your system is set up to require that reversals or cancellations be sent to review before they are posted. For more information, see Check reversals lines (form)or Deposit slip payment cancellations lines (form).

Bank transaction type

Select or revise the transaction type of each transaction as you perform the bank statement reconciliation. The transaction type allows you to sort and make calculations on various kinds of bank transactions.

Date

View or enter the date of the transaction. When you create a new transaction in this form, the default for this field is the date that you entered in the Bank account statement datefield in the Account reconciliationform, but you can change the date if necessary.

Transaction date

The posting date when the company gains knowledge of the transaction.

Note
(ITA) This field is available only if the configuration key for Italy is selected, and the Transaction date reference to competence datefield is selected in the General ledger parametersform.

Check number

The check number of the transaction, if applicable.

Deposit slip

The deposit slip in which the transaction is included.

Amount currency

The transaction amount in the currency specified for the bank account. If you enter a new transaction, enter the transaction amount in this field.

Note
The amount of a posted transaction cannot be changed. To correct the transaction amount, enter a correction amount in the Correction amountfield. The correction amount must be entered in the currency of the bank account.

Correction amount

Enter a correction amount to the original transaction amount, if appropriate.

Ledger account

Enter the ledger account that is offset by a bank transaction (either a new transaction or a correction amount) that you create during reconciliation. Select an appropriate offset account, either a posting account or an account according to the account type.

Note
To see the offset ledger account for one of the transactions that is already posted to the bank account, click Voucher.

Transaction text

Enter a short description of the transaction or the correction that you have created.

Sales tax group

The sales tax group that is attached to the bank transaction that is selected on the Overviewtab.

Item sales tax group

The item sales tax group that is attached to the bank transaction that is selected on the Overviewtab.

Bank account

The unique identifier of the bank account for which you are performing the bank statement reconciliation.

Manual

This check box is automatically selected when you create a transaction in this form to reconcile the bank statement.

Currency

The currency code of the bank account.

Amount

The transaction amount in the company currency. The company currency is specified in the Company information form.

The currency value is calculated automatically using the exchange rate that is specified in the Exchange rates form for the transaction date.

Note
The amount of a posted transaction cannot be changed. To correct the transaction amount, enter a correction amount in the Correction amountfield. The correction amount must be entered in the currency of the bank account.

Registration currency

The currency code of the currency in which the transaction amount was posted. This currency is the currency of the bank account.

Registration amount

The amount in the currency of the bank account (registration currency).

Method of payment

The payment method of the transaction, if the transaction is posted as a payment in a journal.

Payment reference

A reference to the specific payment transaction. The payment reference is copied to this field when the journal is posted. You can identify reconciliation transactions easily by the value in this field.

Voucher number

If a transaction is recorded in the daily journal, the transaction voucher number is automatically copied to this field.

Note
When you create a transaction manually during reconciliation, it is automatically assigned a voucher number from the appropriate number sequence, and the Clearedfield is automatically selected.

Department

The dimension value that is posted with the bank transaction.

Cost center

The dimension value that is posted with the bank transaction.

Purpose

The dimension value that is posted with the bank transaction.

Bank transaction groups

The bank transaction groups of the transactions that are included in the bank statement reconciliation. A bank transaction group can contain several bank transaction types.

Description

The description of the bank transaction group.

Transactions

The number of transactions that are selected as included in the bank statement reconciliation in the upper pane. For a transaction to be included in the bank statement reconciliation, the Clearedfield on the transaction line in the upper pane must be selected.

Cleared

The sum of the transaction amounts for the transactions that are included in the bank statement reconciliation, and that belong to the bank transaction group.