QB Issue Resolution:
So, you’re reconciling and your opening balance in the reconcile window is incorrect? You can’t fix the problem without understanding how the opening balance is created.
When you open your check register within QBO, you’ll see a narrow column on the right hand side of the screen that has a check mark at the top of the column.. This column will indicate the status of each transaction.
The box is empty indicating the transaction has not been cleared or reconciled.
The box has a letter C indicating the transaction was marked cleared but not yet reconciled.
The box has a letter R indicating this transaction was reconciled.
Any transaction with the letter R in the check mark column is affecting the opening balance regardless of date, type, or amount of the transaction.
Any transaction with the status of C or blank in the check mark column has no bearing on the opening balance.
If the last reconcile balanced correctly, then one of the following actions has taken place:
Transaction(s) were directly edited in the register and the reconcile column was changed to show the wrong status as follows:
Unreconciled transactions were incorrectly marked with a R so they affect the opening balance (they should not).
Reconciled transactions were incorrectly marked a C or left blank so they no longer affect the opening balance (they should).
Someone has deleted a transaction(s) in the register that had a letter R.
The above scenarios cannot be created by QBO. Someone with access to your company has created this scenario.
Now that you understand what affects the opening balance, here are some first steps to troubleshoot:
Do you remember editing or deleting anything since the last reconcile?
If so, do you remember what transactions you edited or deleted?
Did you change the edited amount back to the original version or reenter the deleted transaction if applicable?
Was the status returned to its original state (R,C, or blank)? If not, please do this now and check your opening balance.
If you don’t remember changing anything, please continue to step 2.
You can use the Find feature in the upper right hand corner to look for the amount of the difference. If it is a single transaction that has been modified, you may be able to find it this way by searching for the amount. If you are able to locate the transaction, you can edit the original amount if necessary and/or correct the status in the register (R, C or Blank).
If you remember editing transactions recently (in the past week or two), you can search the activity log for transactions that are affecting the opening balance. To do this, choose Company > Activity Log. If you don’t remember editing transactions recently, we recommend skipping this step.
Using a report for comparison and troubleshooting:
If you have not located the transactions in question, you can run the following report to compare with the transactions at your bank. Be aware this process can be very time-consuming depending on the number of transactions and months you need to cover.
Begin by opening the reconcile window and writing down the opening balance.
Choose Company > Chart of Accounts.
Click on the account in question to highlight it.
In the lower right click on Report and an Account QuickReport will open.
Click on Customize.
Set the Transaction Date field to All Dates.
If you are using QBO Plus or QBO Edition:
Change the Sort In option to Descending order.
Scroll down to the Status section and change the Cleared drop-down arrow to Reconciled.
If you are using QBO Basic or QBO Simple Start, go to the Sort By field and select Clr.
Click Run the report.
You’ll need to print this report as well as a statement from your bank’s website and compare the two. If you are using QBO Basic or QBO Simple Start, look only at transactions that have a letter R in the Clr column.
If you see a corresponding transaction on both reports, cross them off and move to the next transaction.
If the report from QBO has a transaction that is not on the statement from the bank, click the letter R in the register to remove it.
If the report from QBO has a transaction that is on the statement from the bank, but a different amount, Edit the transaction to reflect the correct amount.
If the statement from the bank has a transaction that is not on the report in QBO, first check the register for the transaction.
If you find the transaction place a letter R on it and save it.
If the transaction is not in the register, add it to the register and place a letter R on it.
Go through the report and the bank statement and make the changes in QBO as necessary, then run and print the report again. If the report total matches what the opening balance should have been, you’ve found your problem and can continue the reconcile. If not, you need to repeat the process until you find the problem transaction.
Resolution for Issue 'Bank recon ending balance from last month does not match this months beginning balance.' available: Yes (Solved).
Source: Intuit Community forum.
Bank recon ending balance from last month does not match this months beginning balance.: this issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the issue yourself by looking for a resolution described below. If it is a complex issue or you are unable to solve the issue, you may contact us by clicking here or by using other support options.Support for ending
Quickbooks Repair Pro will resolve it efficiently and affordably. Guaranteed resolution of your issue, or you pay nothing!
Error Recovery for ending [Canada]
E-Tech is the #1 Quickbooks data migration and Conversion service provider.
Additional Support Options: