This will guide you through the process of reconciling an account with all Checks and Payments and Deposits and Credits transactions checked/selected. This will have the Unreconciled Difference field a zero balance.
1. Enter the Ending Balance appearing on your bank statement in the Statement Ending Balance field at the bottom of this form.
2. Go over your bank statement and check the transaction in the Bank Reconciliation form that match it.
Let us assume that all transactions shown in the Company’s record are shown in the bank statement, that is why these transactions are all checked/selected.
Notice this field is updated after entering Statement Ending Balance:
•Unreconciled Difference field - will show the Total amount after computing the fields before it. The formula being used to compute for the Unreconciled Difference is shown clearly before each field caption. For this illustration, the formula is shown below.
Statement Ending Balance - Uncleared Checks and Payments + Uncleared Deposits and Credits - Account Balance = Unreconciled Difference
3.Click Reconcile button. A confirmation of the success of reconciliation will be shown. Click OK button.
Another message will be shown. Click Yes if you would like to print a Bank Reconciliation report.
4. The Print Bank Reconciliation form will be shown. In here, you will see the Display the current reconciliation is checked by default. Once this option is checked, this will only print the reconciliation you just made.
Click Print button.
This is how the Bank Reconciliation form be like.
Each information on this report is described below.
Date Reconciled will show the date of reconciliation.
Cleared Transactions will be shown in the first section of the report showing all cleared transactions.
Outstanding Transactions section will show all transactions not selected/cleared but are present in the Bank Reconciliation form when we did the reconciliation. In this case, since all were selected/cleared, then no Outstanding Transaction section is shown.
Statement Ending Balance will show the amount you entered that is the same amount shown in your Bank Statement.
Uncleared Checks and Payments will show the Total Checks and Payments under Outstanding Transactions section. In this case, since all were selected/cleared, then zero is shown here.
Uncleared Deposits and Credits will show the Total Deposits and Credits under Outstanding Transactions section. In this case, since all were selected/cleared, then zero is shown here.
Account Balance is the same amount appearing in the General Ledger form > Balance field using a filtered date equal to As of ‘date of reconciled’. In this example, As of 10/31/2011.
Unreconciled Difference at this point will show 0.00 since we have already created the transaction for the out of balance.
Note that it is only in Bank Reconciliation form where you can reconcile or mark a transaction as cleared. The previous way of doing it in Bank Register form, i.e. checking the Clr checkbox to manually reconcile it without undergoing the process of reconciliation in the Bank Reconciliation form had been removed to managed the Ending balance properly based on the date when it was reconciled.