cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

My reconciliations have disappeared. I reconcile my account every month and now they are missing after 4/2018?

 
22 Comments
QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Hi there, nathanevansplumb.

 

It will be my pleasure to help you get to the bottom of this and make sure you're able to upload to retrieve your reconciliation records.

 

I haven't received reports similar to this issue Usually, this sort of behavior is often the result of browser hang-ups which can be quickly resolved by clearing the browser cache.  However, I recommend accessing your account in a Private browsing window first to verify if this is caused by the system or your browser.

 

Here are the keyboard shortcuts that will help you accomplish this in all supported browsers:

  • Chrome: Ctrl+Shift+N
  • Internet Explorer: Ctrl+Shift+P
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

Check to see if your reconciliations are back. If they are, then your main browser may have too much historical data from previously visited websites which slows down internal processes and causes this kind of behavior.

 

To ensure this doesn't happen again, it's a good idea to clear the cache of the browser you're using. The following article contains additional insight, as well as steps for the supported browsers: Delete or disable cache and temporary internet files in your web browser

 

Let me know how it goes on your end. I'm determined to get this fixed for you. Thanks for coming to the Community, I'll be standing by for your response.

Experienced Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

I'm having the same problem.  I have three accounts.  I reconciled my 3 accounts on 3/8/19.  When I open reconcile in one of them it says last reconciled on 12/31/18.  The other two accounts show my last reconciliation on 3/8/19.  Clearing my browser history did not resolve the issue.  Any suggestions?

 

Experienced Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

I'm having the same problem.  I have 3 accounts.  I reconciled all 3 accounts on 3/8/19.  When I open one of the accounts to reconcile it says last reconciled 12/31/18.  The other two accounts show last reconciled 3/8/19.  I cleared my browsing history as you suggested but it didn't help.  Any more suggestions?

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Thanks for bringing this reconciliation concern to my attention, @Dee08.

 

Allow me to provide you with additional information about your missing reconciled transactions.

 

Here's the possible reason your reconciled transactions are missing from your reconciliation reports.

  • An accountant user undo the reconciliation or change the status of your reconciled transactions.
  • Your reconciled account is merged with a different transaction account.
  • The reconciled transactions were deleted from the reconciled account.

With QuickBooks, you have the ability to verify who made changes on your account by viewing the Audit Log. Here’s how to check:

  1. Go to the Gear Icon.
  2. Choose Audit Log.
  3. Click the Filter button.
  4. Select Reconciliations under Events.
  5. Click Apply.

 

Once you have reviewed the audit log, if the transactions were deleted, there would be a need to re-enter those transactions manually or reconcile it again.

 

 

That should do it! This will enable you to fix any discrepancy when running the reconciliation report.

 

Let us know here in the Community if you have other questions the reconciliation process in QuickBooks Online. I’m always here to help.

Experienced Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

I use QuickBooks Desktop Pro 2017.  There is no gear icon. How do I view reconciliation events with this version?

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Hello there, @Dee08.

 

Thank you for providing the QuickBooks version you’re using. I can walk you through the steps in viewing the Audit Trail Report.

 

This report shows all activities done on the company file with the name of the user who performed it. You can view the changes made on the bank reconciliation by following the steps below.

  1. Go to Reports at the top menu and select Accountant & Taxes.
  2. Choose Audit Trail.
  3. Click the Customize Report button.
  4. Go to the Filters tab.
  5. Select Account and choose the account from the list.
  6. Set Date by selecting Custom and entering the date range.
  7. Hit OK.

 

 

 

 

Here’s an article about customizing reports for more information: Customize reports in QuickBooks Desktop.

 

Once done, you should see if someone changed the status of the reconciled transactions. If so, redo the reconciliation.

 

Check out the following articles for reference: 

That should get you pointed in the right direction. 

 

Leave a comment below if you have questions, I’m always here to answer them. Have a good one!
 

Experienced Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Thanks for the reply.  I ran the Audit Trail report as you suggested.   can't see anything that says someone changed the status of a reconciled transaction.  It just shows every transaction I've
entered during the requested date range.  Also, I don't see a filter in
this audit trail report for reconciled transactions.  So, according to this
report and best I can tell there were no changes to my reconciliations.  I have printed reports
showing I reconciled In Jan, Feb and March.  I'm afraid to redo my
reconciliation reports if I don't know what caused this issue.  Any
suggestions?

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Thanks for the update, @Dee08.

 

I appreciate you checking into the Audit Trail Report to verify if there are changes on the reconciled transactions. Let’s make sure you’re accessing the most recent company file. 

 

It’s possible that the one you restored is a backup copy of the company file before the reconciliation happen. This could be the reason why it’s showing a different last reconciled date.


Locate the right file and restore it by following the steps below: 

  1. Click the File menu and select Open or Restore Company.
  2. Choose Restore a backup copy, then click Next.
  3. Select Local Backup, then hit Next.
  4. Search for the backup file from the Look In drop-down.
  5. From the folder, the file name should appear as [Company Name].qbb. Select it and click Open, then Next.
  6. Save the restored file on the location where you can find it easily.
  7. In the File name field, enter a new file name.
  8. Hit Save.

Here are screenshots from step 1-4 for visual reference:

restore 1.PNG restore 2.PNG restore 3.PNG restore 4.PNG

 

Refer to this article for more information: Restore a backup of your company file.

 

That should get you on the right track. 

 

Let me know if this works out for you, I'm always here to help. Have a good one!
 

Experienced Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Confirmed I'm using the most recent company file. I have 3 accounts.  Two of my accounts show my most recent reconciliation date.  One does not show my most recent reconciliation date although I have printed reports that show it has been reconciled as recent as March 8.  Is it safe to just go back and reconcile this account again starting in Jan?  The one I'm having problems with is my main business account.  I need to get this figured out soon...I'm beginning to get really nervous about this!!!

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Hello Dee08,

 

Thank you for getting back to us and providing additional information here in the Community. Allow me to step in and assist you with the strange behavior happening with your reconciliation in QuickBooks Desktop.

 

Usually, transactions get unreconciled only if there's a user that undo the reconciliation on your company file. Since you have a copy of the reports from the specific date that you've reconciled, I recommend doing it again.

 

Please also make sure to update your QuickBooks to ensure you'll have the latest release for the program. In case you need the steps, I'm adding them below for you:

 

  1. Click the Help tab at the top menu bar.
  2. Click Update QuickBooks Desktop.
  3. Go to the Update Now tab.
  4. Put a check mark beside Reset Update.
  5. Click Get Update.

For your future reference, I'm also linking an article with additional information on this, such as the detailed steps on reconciling account:

 

Reconcile in QuickBooks Desktop.

 

Please feel free to get in touch with me here for any additional assistance you need with the reconciliation. The Community always has your back.

Established Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

im having the same problem as Dee and resent having to do 3 months of bank recs again.   did a quick books update mess us up?

Established Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

I too had 3 months of bank recs disappear.  very unhappy.!!!!!!!!!! not sure what to do 

Moderator

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

It's nice to have you as part of the conversation, @nora rozin,

 

Allow me to join the discussion as I want to make sure you have the correct reconciliation history in QuickBooks.

 

Before anything else, may I know if you recently restored a back up? Any information you can share will help us drill down the issue.

 

If you have missing information on your company file, it's possible that you're opening a wrong file or restored an outdated back up. To get past this, you can do a global search on your computer to get the most recent *.qbw (company file extension) or *.qbb (back up extension) files. Let me guide you through the steps:

 

 Step 1: On your computer, perform a wild card search for all company files by typing one of the following into the search bar:

  • *.qbw (Working Files)
  • *.qbb (Back Up Files)
  • *.qba (Accountants Copy Files)
  • *.qbx (Accountants Transfer Files)
  • *.qby (Accountants Change Files)

Step 2: Open your file in QuickBooks 2016 depending on the type of your QuickBooks file.

  • Opening a company file (.qbw)
    1. Click the File menu.
    2. Choose Open or Restore Company.
    3. Hit Open a Company File, then click Next.
    4. Select the company file.
    5. Click Open.
  • Restoring a Backup (.qbb)
    1. From the File menu, select Open or Restore Company.
    2. Pick Restore a Backup File, then click Next.
    3. Choose Local backup.
    4. Select the company file, then click Next.
    5. Find the location where you wish to save the restored file, then click Save.

I'm confident that these steps will get you to the right direction. Please let me know how it goes. I look forward to your response about this. Have a good one!

Established Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are missing after 4/2018?

i have lost 3 months of bank reconciliations.  in the past i have lost check payments as well, even tho i have a hard copy back up of these things being completed.  how can i fix this?  i am the only one who uses qb desktop in my business.  i discover this missing issues at random, and have lots of new data entered after them.  is there a way to merge back ups if i can find an older version without things being deleted?

Established Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

i only have one company and i am the only one who uses qb desktop.  i enter data as business needs require.  3 months of reconciliations have disappeared.   i have to re do oct, nov, dec of 2018 even tho i have these done and printed out in my folder.   i don't know when these disappeared, but i have entered a significant amount of data since then.  can i merge back ups?

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Hello there, nora rozin.

 

Let's recover your missing reconciled transaction by using the Auto Data Recovery feature in QuickBooks Desktop. This feature can help us recover any loss or corrupted data.

 

For your reference, kindly check this article on how to recover lost data with QuickBooks Auto Data Recovery.

 

If the same thing happens, I'd recommend contacting our Customer Care team. They can help you further with this. Also, they can create a report and send it to our engineers. This way, our engineers can investigate the issue that you've experienced.

 

Here's how to contact them: 

  1. Go to Help and choose QuickBooks Desktop Help.
  2. Click Contact us.
  3. Enter a brief description in the Ask a question (or tell us what's wrong) field and click Continue.
  4. Choose an option in reaching our support team.

Please let me know how it goes by leaving a comment below. I'd get back to you as quickly as I can.

Experienced Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Me too! 3 months of reconcilliation gone.  Looks like MANY are having this problem all at the same time.  Can't blame the accountant.  Looks like a QB update issue.  What's the plan????

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Hi @davebacks,

 

You can check your Previous Reconciliation report and Audit Trail. Let me add some details about this and help you from there.

 

Checking you Previous Reconciliation report allows you to know if you've reconciled for those months. And your Audit Trail shows if someone did undo your reconciliation.

 

You can follow these steps in pulling up the Previous Reconciliation report:

  1. Click on Reports from the menu bar.
  2. Choose Banking.
  3. Select Previous Reconciliation.

Here's how you pull up the Audit Trail:

  1. Click on Reports from the menu bar.
  2. Choose Accounting & Taxes.
  3. Select Audit Trail.

Once you've verified that there were no changes and no one changed your reconciliation, you can redo the reconciliation.

 

To redo your reconciliation, kindly follow the steps below:

  1. Click on Banking from the menu bar.
  2. Click on Reconcile.
  3. Choose the account to reconcile.
  4. Select the Statement Date to reconcile.
  5. Enter the Ending Balance.
  6. Click on Continue.

Don't hesitate to let me know if you have any other concerns. I'll be here to help.

Active Member

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

I also just updated my Quickbooks Desktop and found afterward that my reconciliations were eliminated back to 1/31/19 (7 months).  

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Hi there, @molbrez.

 

Thanks for letting me know about this concern. I've got some additional information to share in fixing this reconciliation concern.

 

In QuickBooks Desktop, data won't be removed unless it was deleted manually. In cases like this, we can go ahead and run the verify your data. This can help fix data-related issues on a company file.

 

Before doing so, make sure to open the correct company file. Once verified, you can now start the process by following these steps below:

  1. Click on File at the top menu bar.
  2. Select on Utilities.
  3. Click on Rebuild Data.
  4. Select OK when you see Rebuild has completed.

After that, you can proceed with verifying the data:

  1. Click on File.
  2. Select on Utilities.
  3. Click on Verify Data.
  4. If you see QuickBooks detected no problem with your data, select OK. You may continue using your company file.

For detailed information about this, please see this link: Resolve data damage on your company file.

 

If doing this doesn't make a difference, you can pull up the restored copy of your company file and work it from there.

 

If the issue persists, I'd recommend reaching out to our Customer Care Team. They have the tools to look further into this matter and can open an investigation ticket if necessary. 

 

I'm still here to help if there's anything else that you need. Just leave a reply below and I'll get back to you. Have a lovely day ahead!

Community Contributor *

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

I just found that this happened to me also.  Several credit card accounts no longer reconciled back to January 2019.    Desktop Pro 2017.  This stinks.

QuickBooks Team

Re: My reconciliations have disappeared. I reconcile my account every month and now they are miss...

Thanks for joining this thread, @k105.


Let’s run the Verify and Rebuild Data Utilities to fix data damaged issues. I have a few simple steps to perform this task.


Verifying the data will check any damaged transactions or lists in your company file, and rebuilding it will resolve any problems detected in your account. Here’s how:

 

  1. Tap the File menu at the top to choose the Utilities tab and then select Rebuild Data.
  2. When the QuickBooks Desktop Information window pops-up, click OK to backup  the file.
  3. After creating one, QuickBooks will automatically perform the rebuild process.
  4. Once completed, click OK.

To verify:

 

  1. Go to the File menu to select Utilities and then pick Verify Data.
  2. When you see the QuickBooks detected no problem with your data window, hit the OK button.

However, if the Verify tool finds an issue with the data, you’ll be prompted to Rebuild Now or View Errors. To continue, follow the steps in this article and proceed to the Review Last Verify/Rebuild section: Resolve data damage on your company file.


Stay in touch if you need more help while working in QuickBooks. Please know I’m more than happy to assist further. Have a good one.