There is no question that account reconciliation is a dreaded chore. So much so that many small business people don’t do it. QuickBooks’ reconciliation tools and its ability to import transactions from your banks make this activity less painful. They also allow you to make reconciliation an ongoing process rather than a once-a-month marathon. But it still takes time and strict attention to detail, and you still have to sit down with your bank statement once a month.
Making account reconciliation a habit is strongly recommended. Doing so has numerous benefits. For example, you will be able to:
- Have confidence that your bank balance in QuickBooks is accurate.
- Match payments to invoices.
- Make sure that your bill payments get posted.
- Catch errors sooner.
- Detect unauthorized access to your accounts.
Before you even attempt a reconciliation using QuickBooks, there are actions you can take ahead of time to minimize the time required and make the process less frantic and frustrating. Here are some tips:
Match Your Real-Life Accounts With Quickbooks Accounts
If you are new to QuickBooks or you haven’t set up accounts that mirror your real-life bank and credit card accounts, you’ll need to do so. We try to avoid sending you to the Chart of Accounts, but you’ll have to create accounts there to store your downloaded transactions.
Open the Company menu and select Chart of Accounts. Click the down arrow next to Account in the lower left corner and select New. This window will open:
Figure 1: QuickBooks needs one account for each bank account or credit card you plan to reconcile.
You are going to want to reconcile your checking account(s), so select Bank and click Continue. Complete the fields on the screen that opens and save the account.
Warning: It is critical that you enter the correct Opening Balance. This is the beginning balance printed on the statement you’re going to reconcile. After you’ve gone through the process once, QuickBooks will supply this for you.
Keep Your Quickbooks Transactions up to Date
If you have connected your QuickBooks file to your online bank, this will be easier. You’ll want to enter any cleared transactions from your statement that are missing in QuickBooks. If you haven’t set up a link to your financial institution, you should do so now. Otherwise, you will have to sign on to your online bank account and locate each cleared transaction for each account. Please call if you need help with this step.
Be clear about the process
Reconciling an account in QuickBooks is similar to how you used to do it using a paper statement and your checkbook register. You will be matching the transactions in one to the other and clicking the ones that correspond. When you’ve finished, QuickBooks should show a $0.00 difference between the two. The software makes suggestions about what to do if it doesn’t – which may or may not work.
This is the most difficult step in reconciling: ending up with a zero difference. We can troubleshoot your reconciliation if you’re not able to complete it correctly.
Enter Interest Earned and Service Fee Amounts
Figure 2: QuickBooks will prompt you, but don’t forget to enter any Service Charges or Interest Earned.
These will probably seem like small amounts, but your reconciliation will not work if you don’t enter any interest earned or bank service charges. These fields will appear at the bottom of the window when you open the Banking menu and select Reconcile.
Back Up Your Quickbooks Company File
Before you begin the reconciliation process, you must back up your QuickBooks company file. If you get hopelessly tangled up in your reconciliation, you want to be able to go back to where you started. Click File | Backup Company |Create Local Backup. You have two choices here: Online backup (cloud-based storage; fees apply) or Local backup (like a USB drive). You should be backing up your QuickBooks file regularly, so do not hesitate to call if you are unsure what to choose or how to set it up.
Once you’ve gone through a reconciliation successfully, the next ones should be easier. But doing it for the first time can be a major challenge. Fortunately, a QuickBooks expert is available to help you through the process or even take over your reconciliation chores completely. If you would like to discuss this further, please call the office.