Show TOC

Object documentationReconciliation Bank Statement Window: AU, BR, CA, CN, CY, GB, IN, JP, KO, NZ, SG, US, and ZA Locate this document in the navigation structure

 

Note Note

For the following localizations, you can verify the transactions recorded in SAP Business One against the balance received from the bank and create adjustments if required: Australia, Brazil, Canada, China, Cyprus, India, Japan, Korea, New Zealand, Singapore, South Africa, United Kingdom, and United States.

End of the note.

This window displays all the open deposits and payments in which the account you chose in the External Bank Reconciliation – Selection Criteria window is involved.

To open the window, choose   Banking   Bank Statements and External Reconciliations   Manual Reconciliation  . In the External Bank Reconciliation – Selection Criteria window, specify the relevant account information and choose OK.

General Area
Account Code

Displays the account code selected in the External Bank Reconciliation – Selection Criteria window.

Display

Determines what transactions are displayed. Select one of the following display options:

  • All – Both cleared and uncleared transactions

  • Cleared – Only cleared transactions

  • Uncleared – Only uncleared transactions

Find

Enables you to find a specific transaction in a sorted column.

Example Example

To find a transaction according to its number, sort the Trans. No. column. Then in the Find field, specify the relevant number. SAP Business One highlights the first transaction that matches the value entered.

End of the example.

Note Note

By default, the Date column is sorted.

End of the note.
Statement No.

Specify the number of the statement you received. This number is unique for each account. This means you can assign the same number to statements created for different accounts; however, you can assign the same number only to one statement in each account. You can create a statement without a number.

Note Note

If a reconciliation is canceled, its statement number becomes available again and can be used for a new reconciliation.

End of the note.
Last Statement Balance

Displays the balance of the previous statement.

Payment, Deposit: Total No., Total Amount

The Total No. field displays the total number of selected transactions on the debit side (Payment) and on the credit side (Deposit). The Total Amount field displays the cumulative debit amount and credit amount.

Cleared Book Balance

Displays the total cleared amount, considering the selected transactions.

Statement Ending Balance

Displays the value entered in the Ending Balance field in the External Bank Reconciliation – Selection Criteria window.

Difference

Displays the difference between the Cleared Book Balance and the Statement Ending Balance. This value depends on the selected transactions.

Save

Saves the current reconciliation so that you can continue working on it later. The next time you choose the same account in the External Bank Reconciliation – Selection Criteria window, the Reconciliation Bank Statement window displays the saved selection.

Adjustments

Enables you to create any required bank adjustments by opening the Adjustments window. For more information, see Creating Adjustments: AU, BR, CA, CN, CY, GB, IN, JP, KO, NZ, SG.

Table Area
Cleared

Select to indicate that the transaction has been cleared.

Type

Displays the transaction type:

  • PS – represents payments, that is, transactions in which the selected account is credited

  • DP – represents deposits, that is, transactions in which the selected account is debited

Date

Displays the posting date of the transactions.

Trans. No.

Displays the number of the transaction and provides a link to the journal entry.

Reference No.

Displays the reference number as it appears in the Ref. 1 field in the Journal Entry window.

Payment

Displays the amount on the debit side in the transaction.

Deposit

Displays the amount on the credit side in the transaction.

Cleared Amount

After you select the transaction, the amount in the Payment/Deposit column is displayed here.