cancel
Showing results for 
Search instead for 
Did you mean: 
Megaec12
Level 2

Reconciled - even in History, but system is starting over at the beginning of the year

My bank account is reconciled through August 2021.  I was out sick and couldn't reconcile the last 4 months of the year until this month.  However, when I click register, it says the last date reconciled is "date ending 12/31/2020".  BUT the history shows the reconciliations complete through August 2021.  Any ideas how to fix this?  I'm not planning to re-reconcile everything because the history shows the account is mostly reconciled - so somewhere the system knows it was completed (plus the 'un-reconciliaiton nightmare' we all know about).

 

To recap:  account reconciled through August 2021.  History confirms reconciliations complete.  When attempting to reconcile the rest of the year, the system says last reconciliation was 12/31/2020.  

 

Thanks in advance.

4 Comments 4
Kurt_M
QuickBooks Team

Reconciled - even in History, but system is starting over at the beginning of the year

I appreciate you for reaching out here in the Community, @Megaec12. I'll share some insights about your concern along with the steps on how to fix it.

 

There are possible reasons why this occurs, it could be because of the amount of a transaction changed, or Someone unreconciled a transaction in the register, it could also be that someone added a transaction to a past reconciliation, usually this is by accident, and then lastly is that someone deletes a transaction, and that can really affect your reconciliation.

To fix this, we'll have to do these:

 

  • Review the original opening balance.
  • Check your bank statement.
  • Match and categorize downloaded transactions.
  • Review any discrepancy reports.

In reviewing the original opening balance, always know that the opening balance is the starting point for accounts in QuickBooks. If this is incorrect, this will affect all the following reconciliations.

 

You'll want to make sure your opening balance is correct before you go to check your beginning balance.

 

To check your bank statement, here's how:

  1. In QuickBooks online, go to the Accounting menu and then select Reconcile.
  2. Review the account you selected in the Account dropdown menu.

Make sure you're reconciling the correct account if you have multiple accounts at the same bank or many accounts of the same type. Once done, we can now proceed to categorizing and matching downloaded transactions.

 

Before you begin reconciling, match and categorize all of your downloaded transactions if your account is connected to online banking. To get your final correct beginning balance, you need categorize everything.

 

You'll then want to review any discrepancy reports. To begin, these are the steps:

  1. Click the Gear icon and then under the Tools column, select Reconcile.
  2. You'll then see an alert if you have a problem with your opening balance.
  3. Select the hyper link We can help you fix it. to look at your discrepancy report.
  4. Under the column CHANGE TYPE, you'll find some information that will let you know how to solve your problem.

Once you've determined that your beginning balance is correct, you can proceed to start the reconciliation. In case you see any issues along way of your reconciliation, you can visit this page to know what you should review.

 

You might also want to give this article a visit, this contains an instructional video of how to fix issues for accounts you've reconciled in the past in QuickBooks Online (QBO).Additionally, I'll be adding these articles to help you in the future:

Don't hesitate to get back to me if you have further clarifications about this. I'll be more than happy to provide additional assistance. Keep safe! 
 

Megaec12
Level 2

Reconciled - even in History, but system is starting over at the beginning of the year

Thank you for your reply, but it did not answer my question.  All of the reconciliations from Jan thru August 2021 are correct, and in the history.  There are no discrepancies or issues with the previously completed reconciliations.  The dates, beginning and ending balances are all fine, as are the transactions (presumably because there are no reports or errors, corrections, etc...).  So, the previous reconciliations seem clean and proper.

 

However, when I try to reconcile the September 2021 statement, the system is pre-populating the last date of reconciliation as the last statement for December 2020.  This is despite the fact that the previous clean reconciliations for 2021 are present in the history.  

MarsStephanieL
QuickBooks Team

Reconciled - even in History, but system is starting over at the beginning of the year

Thank you for giving us an update on your concern, @Megaec12. Allow me to share more details on how to troubleshoot this error.

 

Since you've confirmed that the possible reasons stated by my colleague are not applicable, we may proceed with troubleshooting the browser. There are times that the program will react abnormally because of outdated data.

 

You can start with using an incognito browser to check if this is a data-related issue. If it shows the correct date while using an incognito, you can go back to the regular browser and clear the cache to avoid getting the same issue in the future.

 

Then, try to check if the last reconciliation date pop-up is still on December 2020. If that's so use another browser. To know the supported browser, you can check out this article: Clear cache and cookies to fix issues when using QuickBooks Online.

 

Then, you can proceed to the reconciliation process if it's all good. If not, I'd recommend contacting our Customer Care Team to have a better look at the issue. They also have the tools to verify your account and further check on the issue with their designated tools.

 

I've got your back if you have any questions about QuickBooks Online. Just comment back so I can assist you further. Take care.

Megaec12
Level 2

Reconciled - even in History, but system is starting over at the beginning of the year

Thank you for your suggestions.  I tried it in 3 browsers, all in private (incognito) mode and the same date continues to appear.  I will contact the customer care team, as suggested and see if they can resolve the issue.

 

Thank you for your reply.  Even though it didn't work, it was informative and I'm sure will help someone else.

 

Need to get in touch?

Contact us