Page History

...

Field Description - header

1. The Bank Account field - is  is used to select the bank account you want to perform bank reconciliation.
2. The Statement Date field - is  is used to enter the date shown in your Bank Statement.
3. The Bank Name field - shows  shows the bank where the bank account selected in the Bank Account field is associated.
4. The G/L Account field - shows  shows the G/L cash, checking or savings account assigned for the bank account.
5. The G/L Balance field - shows  shows the G/L current balance appearing on General Ledger Account Detail for the bank account selected and at the date set in the Statement Date field.
6. The Bank & GL Balance Difference field - shows the difference at a point in time between the account balance recorded in the General Ledger Account Detail screen > Ending Balance field and the balance recorded in the Cash Management screens > Balance field. This helps you identify whether or not, your GL numbers match that of Cash Management numbers.

Field Description - Payments and Debits panel

1. The Magnifying glass button before the Clear checkbox when clicked will open the actual transaction.
2. The Clear checkbox is Clear checkbox - is used to select/deselect the transaction to be cleared.
3. The Date field - shows  shows the date the transaction was posted.
4. The Number field - shows  shows the Check Number for Miscellaneous Check transactions.
5. The Payee field - shows  shows the recipient to whom the check is to be issued.
6. The Transaction Type field - shows  shows the type of cash management transaction.
7. The Payment field - shows the amount entered for the Miscellaneous Check, Bank Transaction or Bank Transfer.
8. The Payments Cleared field - shows  shows the total of the payments/debits selected to be cleared.

Field Description - Deposits and Credits panel

1. The Magnifying glass button before the Clear checkbox when clicked will open the actual transaction.
2. The Clear checkboxClear checkbox - is used to select/deselect the transaction to be cleared. 
3. The Date field - shows the date the transaction was posted.
4. The Number field - is  is not necessary as this field is only for Miscellaneous Check, which is on Payments and Debits panel.
5. The Payor field -  is used to enter the name of an individual or company who pays in the form of deposit. Can be a customer or can be a memo for what the Receipt of cash is for.
6. The Transaction Type field - shows the type of cash management transaction.
7. The Deposit field - shows the amount entered for the Bank Deposit, Bank Transaction or Bank Transfer.
8. The Deposits Cleared field - shows  shows the total deposits/credits selected to be cleared.

Field Description - bottom part

1. The Prior Reconciliation Ending Balance field - shows  shows the balance of the previous reconciliation. If this is the first time the bank account is to be reconciled, you may enter the previous bank statement balance. 
2. The Cleared Payments field - shows the total payments/debits selected to be cleared.
3. The Cleared Deposits field - shows the total deposits/credits selected to be cleared.
4. The Ending Balance Per Reconciliation field - this shows  shows the amount derived after deducting the Cleared Payments and adding the Cleared Deposits from the amount entered in the Prior Reconciliation Ending Balance field. Notice that the formula is shown on the Bank Reconciliation to help you visualize how the amount was computed. The formula is: Prior Reconciliation Ending Balance - Cleared Payments + Cleared Deposits = Ending Balance Per Reconciliation. 
5. The Bank Statement Ending Balance field - this is  is used to enter the Ending Balance appearing in your Bank Statement.
6. The Uncleared Payments field - shows  shows the total payments/debits awaiting clearing and will not be part of the current reconciliation. These are transactions that will to be left in the bank reconciliation screen and will soon be reconciled.
7. The Uncleared Deposits field - shows the total deposits/credits awaiting clearing and will not be part of the current reconciliation. These are transactions that will to be left in the bank reconciliation screen and will soon be reconciled.
8. The Bank Account Balance field - shows  shows the bank account Balance appearing in most Cash Management screens.
9. The Difference field - this shows  shows the amount derived after deducting the Uncleared Payments, adding Uncleared Deposits and deducting Bank Account Balance from the amount entered in the Bank Statement Ending Balance field. Notice that the formula is shown on the Bank Reconciliation to help you visualize how the amount was computed. The formula is: Bank Statement Ending Balance - Uncleared Payments + Uncleared Deposits - Bank Account Balance = Difference. This amount also will tell you whether or not your book record is consistent with your bank record, which if that is the case, resulting amount should be 0.00.

The following topic/s will guide you on how to use the Bank Reconciliation screen.