Prerequisites
Before running the Book to Bank Reconciliation process, verify that you have correctly configured your general ledger accounts and external bank accounts. Note the following configuration considerations:
-
Define your external bank accounts so that there are no duplicate general ledger business unit and general ledger account combinations.
-
Do not define the same bank ID and account number multiple times either under the same SetID or under different SetIDs. This type of setup causes reconciliation issues.
Note:
There can be up to three ledger cash accounts per external bank account (one each for Payables, Receivables, and Treasury applications) as illustrated in this table:
| Bank | Account | GL Business Unit | Ledger Type | GL Account |
|---|---|---|---|---|
|
USBK1 |
0001 |
BU001 |
A - AP Cash |
111111 |
|
USBK1 |
0001 |
BU001 |
C - AR Cash |
111111 |
|
USBK1 |
0001 |
BU001 |
H - TR Cash |
111111 |
|
USBK1 |
2222 |
BU001 |
A - AP Cash |
222222 |
|
USBK1 |
2222 |
BU001 |
C - AR Cash |
333333 |
|
USBK1 |
2222 |
BU001 |
H - TR Cash |
444444 |
|
USBKZ |
WXYZ |
BUXXX |
A - AP Cash |
111111 |
|
USBKZ |
WXYZ |
BUXXX |
C - AR Cash |
222222 |
|
USBKZ |
WXYZ |
BUXXX |
H - TR Cash |
333333 |
-
Ensure that the same currency code that you specified for the general ledger account is used by the bank account.
If you configure the bank account with a different currency code than the general ledger account, the bank account displays balances that are revalued in the base currency of the general ledger account in the Book to Bank Reconciliation component. This might result in currency rounding errors.
-
Run the Journal Generator and Journal Edit and Journal Post processes in General Ledger.