User's beginning balance in BillQuick Plus is different from the opening balance on his bank statement.
You need to reconcile your accounts to match the balances for your bank statement and BillQuick account. This is a two-step process in BillQuick Plus.
First you must compare the beginning balance on your bank statement to the beginning balance in BillQuick and verify the information for the account you want to reconcile in BillQuick. Second, you have to compare individual transactions and then reconcile your accounts.
Note: If you clear a transaction directly in the account register, the beginning balance shown in the Reconcile Accounts screen may not match the opening balance on your statement. Instead, clear transactions when you are reconciling accounts in BillQuick for a more accurate beginning balance.
To reconcile your accounts:
1. Go to the Accounting menu>Reconcile Accounts.
2. Choose or enter the Account you want to reconcile.
3. In the Statement Date field, enter the date of the bank statement you are trying to reconcile.
4. Compare the amount shown in the Beginning Balance field to the opening balance shown on your bank statement. How you handle the mismatch depends upon whether or not the accounts have been reconciled in the past.
First-time Reconciliation
You may have entered your opening balance incorrectly when creating a new account (bank or credit card). If you have never reconciled your account, you can change the opening balance in the following way:
1. Select Accounting menu > Chart of Accounts.
2. Find the account's opening balance transaction in the register (usually the first one) or look for Opening Balance Equity in the Account field of the register.
3. Change the amount to the correct opening balance.
4. Click Record and exit.
Reconciliation Done Before
If your beginning balance in BillQuick is different from the opening balance on your bank statement in your previously reconciled accounts, you need to find the cause of the discrepancy. Some of the reasons that may cause a discrepancy include:
- You may have un-cleared a transaction in the account register by mistake. If yes, your beginning balance will be off by that amount. You can see this in the Reconciliation Discrepancies report.
- You have changed or deleted a previously cleared transaction. To fix this, you must undo the previous reconciliation and then reconcile again with the correct transactions.
You have an option to ignore the discrepancy for now. When you finish reconciling, BillQuick adds an adjustment transaction to the Reconciliation Discrepancies account. However, you should not ignore a large discrepancy because then you will be adding a large adjustment that may remain unaccounted.
1. Find the ending balance on your bank statement and enter it in the Ending Balance field.
2. Enter any Service Charge or Interest Earned that you have not yet entered in BillQuick.
3. In the Account field for Service Charge, enter the name of the expense account that you use to track service charges.
4. In the Account field for Interest Earned, enter the name of the income account that you use to track interest income.
5. Click Next to display all the checks/payments and deposits/credits to be cleared.
6. Next, complete the reconciliation by selecting Reconcile Now.