Use this form to perform bank reconciliations. Bank reconciliation can be done for both posted and unposted transactions. In this form, you can also register posting operations that have no associated payment journals.

Open the form

  1. Click Bank> Common Forms> Bank Account Detailsto open the Bank accountsform.

  2. Press CTRL+N to create a new line.

  3. Click Functions> Account reconciliationto open the Bank account statementform.

  4. Enter the required information.

  5. Click Transactionsto open the Account reconciliationform.

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Unposted operations

View the unposted transactions for the current bank account with statuses Sent, Received, or Approved.

Posted operations

View the posted account transactions for which the Reconciledfield is blank.

Buttons

Button

Description

Functions

Select from the following options:

  • Reconcile account– Reconcile and post the unposted transactions.

  • Posting– Post the unposted bank transactions that are not reconciled.

  • Transit account– Change the transaction date to a later one.

Inquiries

Select from the following options:

  • Original document– Open the Original documentform to view the original documents.

  • Voucher– Open the Voucher transactionsform to analyze ledger transactions.

Print

Print the Reconciliation summaryor the Bank reconciliationreport.

Fields

Field

Description

( Posted operationstab and Unposted operationstab) Cleared

This check box is selected when the bank transactions are reconciled.

( Posted operationstab and Unposted operationstab) Bank transaction type

The type of bank transaction that is specified in the bank transaction.

( Posted operationstab and Unposted operationstab) Date

The date of the bank transaction. This value can be modified.

( Posted operationstab and Unposted operationstab) Check number

The number of the payment document.

( Posted operationstab and Unposted operationstab) Amount currency

The total currency amount in the open source journal line for the bank transaction.

( Posted operationstab and Unposted operationstab) Amount

The transaction amount in standard currency.

( Posted operationstab and Unposted operationstab) Bank amount

The amount in the bank account in currency.

( Unposted operationstab) Account type

The type of account that corresponds to the bank account.

( Unposted operationstab) Account

The number that corresponds to the bank account.

( Posted operationstab and Unposted operationstab) Currency

The currency code for the bank account.

( Unposted operationstab) Voucher

The voucher number.

( Unposted operationstab) Journal number

The number of the journal.

( Unposted operationstab) Line No

The number of the unposted bank transaction line in the source journal.

( Unposted operationstab) Sales tax group

The code of the sales tax group that is specified for the bank operation.

( Unposted operationstab) Item sales tax group

The code for the item sales tax group that is specified during bank transaction.

( Posted operationstab and Unposted operationstab) Department

The dimension value that is posted with the bank transaction.

( Posted operationstab and Unposted operationstab) Cost center

The dimension value that is posted with the bank transaction.

( Posted operationstab and Unposted operationstab) Purpose

The dimension value that is posted with the bank transaction.

( Posted operationstab) Correction amount

The amount of correction for the original transaction.

( Posted operationstab) Ledger account

The ledger account that is used for posting corrections or new transactions that are created during bank reconciliation.

( Posted operationstab) Registration currency

The currency in which the amount was originally registered.

( Posted operationstab) Registration amount

The registration amount specified during reconciliation in registration currency.

( Posted operationstab) Transaction text

The explanatory text that was entered manually when new transactions were generated during bank reconciliation.

( Posted operationstab) Sales tax amount

The sales tax amount that is calculated for the bank operation.

( Posted operationstab) Bank account

The identification of the bank account.

( Posted operationstab) Manual

This check box is selected when a line is entered manually in the Bank account statementform.

( Posted operationstab) Method of payment

The method of payment for the bank transaction.

( Posted operationstab) Payment reference

The payment reference.

( Posted operationstab) Voucher number

The voucher number for the bank transaction.

( Posted operationstab and Unposted operationstab) Bank transaction groups

The bank transaction group.

( Posted operationstab and Unposted operationstab) Description

The description for the bank transaction group.

( Posted operationstab and Unposted operationstab) Transactions

The number of vouchers in the bank transaction group.

See Also