Question

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

Forum|Forum|3 years ago
October 3, 2022
1 reply
24 views

we just converted QBO products.

QuickBooks Online

Level 6

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:

Go to the Accounting menu from the left pane.
Choose Reconcile.
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:

Go to Settings and select Audit Log.
Choose the Filter button.
Under Events, choose Reconciliations and select Apply.
Locate and select the transaction to open it.
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.

S

shanny_2-hotmailAuthor

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.

M

Maybelle_S

QuickBooks Team

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:

Go to the Accounting menu, and then Chart of accounts.
Choose the account on the list, then select View register to get more details.
Click on the transactions you added to expand the view.
Review the check column, then click the checkbox until you see a letter R.
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.

Go to the Help menu.
Select "Talk to a human."
Enter Talk to a human again in the search bar.
Choose I still need a human, then click Contact us.
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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO