Reconcile a Bank Account in Quickbooks Pro 2012
To begin reconciling a bank account:
o From the Home Screen choose the reconcile icon or from the menu bar choose:
o Banking
o Reconcile
Quickbooks will then display the Begin Reconciliation dialog box as shown below.
1) Select the account that you want to reconcile from the Account drop down list.
2) Enter your statement ending date exactly as shown on your bank statement.
3) The beginning balance should be the reconciled (ending) balance from the prior period and should match the beginning on your bank statement.
4) Next enter your ending balance shown on the current statement that you are to reconcile.
5) Use the Service Charge and Interest Earned boxes for items of this type that appear on the bank statement and have not already been posted to the check register. For tracking purposes, enter the date and the corresponding expense account number, for i.e. Bank Service Charges and Interest Income for the Interest earned.
6) Review all information from the statement and verify that it has been entered correctly, then press the continue button to proceed to the next step.
Once you have pressed continue QuickBooks will display the Reconcile Window.
The Reconcile Window displays two lists of transactions: In the left column, a list of checks and payments will appear. In the right column, a list of deposits and other credits will appear. When you click a transaction, Quickbooks marks the transaction with a check mark.
The checkmark indicates that a transaction has cleared the bank. If you want to mark all transactions as cleared, click on the MARK ALL button at the bottom of the Reconcile Window; to unmark all transactions choose the UNMARK ALL button.
A transaction without a check mark next to it has not yet cleared the bank.
If you find an error while reconciling, you can doublclick on the transaction to open it in a new window and correct it accordingly.
To begin reconciling:
1) Identify the checks and payments transactions by clicking on the transactions that have cleared the bank; by clicking on the transaction, Quickbooks will place a check mark next to the cleared transaction.
2) Proceed to identify the deposits and credits and click the cleared transactions in the same way to place a check mark next to the cleared transactions.
3) If while you are reconciling and you find an error, for i.e. an incorrect amount for the service charge, interest earned and/or the ending balance amounts you can make corrections by choosing the Modify button. Once opened, make the necessary corrections, then choose continue to return to the Reconcile Window and proceed with the reconciliation.
4) Once all items have been verified and cleared, the cleared balance should equal the ending balance.
5) If the ending balance equals the cleared balance, click the Reconcile Now button. Quickbooks will permanently record the cleared transaction in the check register.
6) If at any time you need to leave the Reconciliation Window, for i.e., you can’t reconcile or you just need to quit and return later to finish it, choose the Leave button and Quickbooks will save the reconciliation; which allows you to return later to complete it.
Final Step:
After completing the reconciliation click on the Reconcile Now button to complete the bank reconciliation. Next, you will have an option to print or display the report.