cancel
Showing results for 
Search instead for 
Did you mean: 
shanny_2-hotmail
Level 1

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

we just converted QBO products.
6 Comments 6
Carneil_C
QuickBooks Team

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

Thank you for using QuickBooks Online as your business partner, shanny. I'll further assist you with fixing your reconciliation issues.

 

The first thing we can do is to review your History by account from the reconciliation history to verify if you have chosen the accurate account when reconciling. It might be the caused why your reconciliation history is missing, and the beginning balance is zero. I'll guide you on how:

 

  1. Go to the Accounting menu from the left pane.
  2. Choose Reconcile.
  3. Click History by account.

 

Otherwise, we can verify those missing transactions from the Audit Log. It displays a history of all changes made to your transactions. Here's how:

 

  1. Go to Settings and select Audit Log.
  2. Choose the Filter button.
  3. Under Events, choose Reconciliations and select Apply.
  4. Locate and select the transaction to open it.
  5. Select More, and select Audit history.

 

Also, please know that there are differences in how your books appear if you've moved from QuickBooks Desktop to QuickBooks Online. Please visit this article to learn more about how your books are move: Learn how features and data move from QuickBooks Desktop to QuickBooks Online.

 

Additionally, here are some helpful resources to learn more about correcting issues when reconciling accounts, viewing details for missing reconciled transactions or reports:

 

 

If you have any other concerns with reconciling transactions in QBO, please let me know, and I'll do everything I can to help here in the Community.

shanny_2-hotmail
Level 1

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

Hi, 

When I follow both suggestions, no information comes up.  The checking account shows the correct register (from the original company file) but none of the reconciliation history is accessible, in the reconcile function or audit log.  

Maybelle_S
QuickBooks Team

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

I want to ensure this is taken care of, @shanny.

 

Reconciliation reports will be excluded when you convert data from QuickBooks Desktop to Online. It is due to the import limitations and feature differences between these products. However, the transactions will be marked as R in QuickBooks Online (QBO).

 

We can pull up your Profit and Loss and Balance Sheet reports in the desktop and online versions to review the reconciled transactions. If there are any missing entries, you'll have to recreate them. Then, manually reconcile them in the bank register to correct your opening balance.

 

Here's how:

 

  1. Go to the Accounting menu, and then Chart of accounts.
  2. Choose the account on the list, then select View register to get more details.
  3. Click on the transactions you added to expand the view.
  4. Review the check column, then click the checkbox until you see a letter R.
  5. Hit Save.

 

Once done, try performing an initial reconciliation in QBO based on the final reconciliation in QBDT. If the beginning balance is still off, I suggest reaching out to our Customer Support Team. This way, we can look into your account and further guide you in reconciling your accounts. I'll guide you on how.

 

  1. Go to the Help menu.
  2. Select "Talk to a human."
  3. Enter Talk to a human again in the search bar.
  4. Choose I still need a human, then click Contact us.
  5. Select "Get a callback" or "Send a message" to start a conversation.

 

In addition, here are some resources that you can browse to help keep your accounts accurate and up-to-date:

 

 

Please leave a comment below if you have further questions about this bank reconciliation. I want to make sure everything is taken care of.

shanny_2-hotmail
Level 1

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

The bank account has transactions going back before 2001 and not a single one shows R.  In the original file the account was reconciled through May of 2022.  There is a message that all data cannot be displayed and that I would have to export to excel.  So even if I took the time to add an R to every transaction, I would not be able to add an R to the data that does not come up without the export.

shanny_2-hotmail
Level 1

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

also we did not convert from desktop, we switched the online version.

MirriamM
Moderator

Reconciliation history is missing and when I start to reconcile the bank account the beginning balance is zero

Hello there, @shanny_2-hotmail. I want to ensure this gets resolved for you.

 

To ensure we're on the same page, can you verify what product you're using before you switch from QuickBooks Online (QBO)? Since when you move your company data, there is information that might not convert because every version in QuickBooks has different features. So if you just manually imported your transactions in QBO, you may need to review them to add them to your account. 

 

To guide you in managing your transactions, check out this article: Categorize and match online bank transactions in QuickBooks Online.

 

In addition, to help you with the reconciliation process, you can visit this resource: Learn the reconcile workflow in QuickBooks.

 

We are looking forward to hearing from you. Any extra information is appreciated. Have a great day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us