cancel
Showing results for 
Search instead for 
Did you mean: 
jane_straightupb
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

 
33 Comments 33
Kristine Mae
Moderator

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello there, Jane_straightupb.

 

When you convert your data from QuickBooks Desktop to the Online version, some information may not be transferred. This is due to the import limitations and feature differences between the two.

 

What we're gonna do is to compare the Profit and Loss and Balance sheet reports of QuickBooks Desktop and the Online version. If there are missing transactions, you'll have to add them manually to the system. Then, reconcile the account.

 

Feel free to drop by if you need more help. 

BrkClrk
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hi Kristine,

 

I have the same issues but I am wondering if it matters of we had our account reconciled before we transitioned from QB Desktop to QB online.  

 

Thank you!

Brook

MirriamM
Moderator

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Glad to have you here with us, BrkClrk,

 

I'd be glad to help share additional information about converting data from QuickBooks Desktop to QuickBooks Online.

 

As what my colleague Kristine Mae mentioned, there are data that may not be transferred during conversion. Reconciliation reports are one of that information that won't be imported. 

 

In the meantime, just save your reconciliation reports in QuickBooks Desktop then access it later. While in QuickBooks Online, just continue reconciling where you stop.

 

To guide you with the task in reconciling, I've got here a great resource that you can check on for guidelines:

If you need further help in reconciling your data, I’d recommend contacting our Customer Care Team. A specialist will be able to further assist you via secured remote access session.

 

Here's how to reach them:

  1. Click Help icon on the top right.
  2. Click Contact Us button at the bottom.

Keep me posted if you have further questions converting your data, I'm always here to help. Have a great day!

Cara2
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

I have the same issue.  Where is QBO pulling the beginning balance from because it does not show previous reconciliation?  It does not match any previous reconciliations, bank statements, ect.  So how do I know which month to reconcile or where to start to re-reconcile the months.    The recs were only one month behind in our desktop version.  Please help. 

Aphylis
Moderator

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello there @Cara2,

 

Let me guide you on your reconciliation.

 

The Opening Balance is the transaction reconciled in your Bank Register.

 

Migrated from QuickBooks Desktop to QuickBooks Online needs to reconcile the Bank Account again, The reconciled status does not carry over when importing to Quickbooks Online.

 

Firstly, check the Opening Balance transaction (If any) in your Bank Register, this will be automatically created once you initiated a connection for Online Banking within the Banking page.

 

On the other hand, I suggest to check your bank QuickReport in QuickBooks Desktop and compare to QuickBooks Online. Make sure that both reports are sorted by date and the running balance matches.

 

Also, go to your QuickBooks Online's bank register and look for a transaction that is marked as R. That transaction builds up your Opening balance for the current reconciliation.

 

See screenshot for example:

Picture2.jpg

 

Please read this article for further information on fixing your Opening Balance.

 

Drop us a comment for further question.

Cara2
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Thank you for the options although neither are making sense with my issue.  The beginning balance when I go to reconcile doesn’t match.  

 

The desktop version had 10 years of transactions in the checking account I’m trying to reconcile which was reconciled through April 2019 before the migration to QBO.   Is it trying to pull the opening balance from when the account originated or when?  No where in the journal register even  shows $-7.61 as the beginning balance does.

 

I went through and all the transactions show R.

 

what else can I do?

Catherine_B
QuickBooks Team

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello there, Cara2. 

 

The opening balance is originated in our desktop account. That means, the opening balance in your desktop version should be the same with the online account. 

 

You can check your reconciliation report which you can get in your desktop account to review the transactions that are reconciled.

 

There are export limitations that might cause the difference of your beginning balance. 

 

Let me know if you need anything else. 

Cara2
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

None on the info is helping..., please see below,

 

-opening balance in QBD is $600 from 2006

 

-QBD has been reconciled through March 31, 2019

 

- OBO is showing a beginning balance on -717 (and no date) when I try to reconcile 

 

- QBO I have manually gone through and corrected any duplicate entries from the migration.  So the journal register is correct to date.

 

- in the journal entries there are R next to the entries through 3/31/19 which were reconciled in QBD

 

What do I do now?

 

 

 

 

FritzF
Moderator

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Thanks for that information, @Cara2.

 

If you had reconciled through 3/31/19 in the desktop, the transactions display as reconciled in the registers, but not within your reconciliation reports in QBO.

 

After confirming that the transactions have an "R" in the register for entries through 3/31/19, you can simply re-reconcile them again. As long as your beginning balance is correct as of 4/1/19, you should then be able to move forward.

 

However, if it's incorrect, I suggest contacting our Phone Support team so they can check your account using their screen-sharing (remote access) tool and fix this for you.

 

Here's how to reach them:

 

1. Log into your QBO account.
2. Click the Help (question mark) icon at the upper right.
3. Select Contact Us at the bottom to connect with our support.

 

After contacting them, I'm confident that you'll be able to reconcile your account. For future reference, consider checking out these articles:

 


Keep me posted on how the call goes. I'll be here should you have any follow-up questions or concern. Have a good one.

SDunn1
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello Cara,

 

I'm currently experiencing this same issue, was QB's able to help you resolve this?

SDunn1
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello Cara,

 

I'm currently experiencing this same issue, was QB's able to help you resolve this?

EZeender
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

I have the same issue as well.

 

Reconciled accounts before exporting over from Desktop to Online, and my bank balance is millions over where it was in desktop.

 

I saw my bills reaching back years were not marked paid when they were paid in desktop.  I manually paid them all and the balance was still off.  This sounds like a re-import issue to me, is it?  Something must have been off in Desktop before converting to Online

KlentB
Moderator

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello there, EZeender.

 

Let me share additional information about the migration process.

 

When you move your company file from QuickBooks Desktop to QuickBooks Online, you may notice that some of your transactions and data are missing due to import limitations. Take note that your past reconciliation reports won't be converted, and all your reconciled transactions in the register will have an in the cleared column.

 

To isolate this case, you'll want to 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 may need to recreate them. Then, manually reconcile them in the bank register to correct your opening balance. I'll show you how:

 

  1. Go to the Accounting menu, then choose Chart of Accounts.
  2. Find the account on the list, then select View register history to get more details.
  3. Click the transactions you've added to expand the view.
  4. Review the check column, then keep click the checkbox until you see a letter R.
  5. Click Save, then repeat steps 3 to 4 for the payments you've applied to the open bills earlier.

Once done, try performing an initial reconciliation in QBO based on final reconciliation in QBDT. If the beginning balance is still off, I'd recommend getting in touch with our technical supports. This way, we'll be able to look into your account and further guide you in reconciling your accounts. Here's how:

 

  1. Go to the Help icon.
  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:

 

Keep us posted if have any other concerns or further questions about this bank reconciliation. Wishing you all the best.

KariD1
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

This is so over my head... now I'm wishing I hadn't switched to QB online... our year end is Sept 30th and my accountant can't do year end/bank recs from July 1st cause we can't see past bank recs with my QB online version... I tried the steps noted from other replies, but this is way too complicated.. I'm not an accountant nor now what timelines to run these reports to compare from DT to Online... can someone please help me??

KlentB
Moderator

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

I'll help you fix this. KariD1.

 

As I've mentioned above, you may notice that some missing transactions and data when you move your company file from QBDT to QBO due to import limitations. Additionally, your past reconciliation reports in the desktop version won't be converted, instead, your reconciled transactions in the bank register will have an R status in the Check column.

 

You should then be able to move forward and continue reconciling your accounts as long as your beginning balance for the month of July is accurate. However, if the balance is off, you'll want to compare the transactions in your financial reports on both platforms to ensure that everything is imported correclty.

 

 If there are any missing entries, you'll have to need to manually recreate and mark them and mark them as reconciled in your bank register. Feel free to check the steps I've listed above for reference.

 

You can also contact our Customer Care Team if you're not confident in performing the procedures. Our representatives can perform a screen sharing session and further guide in resolving this issue. Here's how:

 

  1. Go to the Help icon.
  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.

Lastly, here are some articles that will help you resolve common reconciliation errors and mistakes in QuickBooks Online:

 

We're open here 24/7, so please don't hesitate to visit us again if you have any other concerns or follow-up questions about bank reconciliation. 

KariD1
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

HI KlentB

 

Thanks for getting back to me.. to be honest, since switching to QB online a few days ago, it's been a nightmare.  I'd prefer to stay with Desktop Pro and get help for my accountant who's having issues updating her 2021 version to 2022 so that I can send her a copy of my back up files so she can do our 4th quarter and year end.  She gets an 'the website cannot display' error.  Or set up  my desktop pro to a multi user so she can access with no issue at her office.. if that's possible.

How do I get an appointment made for a tech to contact my accountant and assist with the downloading issues?

Ethel_A
QuickBooks Team

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Allow me to help you from here, @KariD1.

 

I'm excited to share information that can help you fix this issue with your accountant's copy so she can get back to business.

 

First, check if you have an updated QuickBooks Desktop to the latest release.

 

Second, since you're having issues sending an accountant's copy, you can perform troubleshooting steps to fix the error.

 

Next, set up multi-user mode with your QuickBooks Desktop if your accountant is in the same building as you are. If not, you can set up hosting instead.

 

Check these articles as your reference:

 

Finally, let's get an appointment for a tech to assist your accountant with the downloading issues. They can perform a screen-sharing session to guide and resolve the issue.

 

Here's how:

 

  1. Sign in to your QuickBooks Online account.
  2. Go to Help.
  3. Select Contact Us.
  4. Enter your concern, then select Let's talk.
  5. Choose a way to connect with us:
  • ​​​​​​Start a chat with a support expert.
  • Get a callback from the next available expert.

 

Here is an article your accountant can check on converting the accountant's copy to a working file: Use an Accountant's Copy working file in QuickBooks Desktop.

 

If there's anything else that I can help you with about an accountant's copy, let me know in the comment section below. I'm always ready to help.

KariD1
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hi Ethel_A.

 

Thank you for your help.  Responses to your suggestions:

First, check if you have an updated QuickBooks Desktop to the latest releaseI do have the most updated version of 2022

 

Second, since you're having issues sending an accountant's copy, you can perform troubleshooting steps to fix the error. Not having an issue there - the accountant copy emails fine to her.  The issue is she can't update her 2021 version to the 2022 version I just updated to a week or so ago.  Can I still book her an appointment for her with a tech via my desktop version (I'm seriously thinking of cancelling the new online version I subscribed to and going back to desktop) or do I have to get her an appt via my online version?

 

Also - if I send her an accountant copy from my 2022 version can she open/work on and send back a copy to me from her 2021 version?  She doesn't have an accountant version - she simply uses the same version as me (up until a week ago when I updated to 2022), we email back up copies to each other and upload to our version to work on.

 

Thanks

Kari

 

Next, set up multi-user mode with your QuickBooks Desktop if your accountant is in the same building as you are. If not, you can set up hosting instead.  How do I do this if I've already installed QB Desktop 2022 version?  Can I switch to 'network' somewhere?

AlexV
QuickBooks Team

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hello KariD1!

 

Thanks for the additional info. Allow me to further assist you with the accountant's copy and upgrading QuickBooks Desktop.

 

First, I'd like to know what's the error when your accountant tries to upgrade. You'll want to advise your accountant to download and install the QuickBooks Tool Hub. This can fix any installation issues. Check these articles for the detailed steps:

 

When using an accountant's copy, it'd be best if the client and accountant are using the same version of QuickBooks Desktop. If not, the accountant must have the more recent version than the client. For example:

  • Client (You): QuickBooks Desktop Enterprise 2019
    Accountant: QuickBooks Desktop Enterprise Accountant Edition 2019 or 2020

 

However, based on your description, it seems that you're not using an accountant's copy since your accountant is not using the accountant version. If you're simply sending a backup file, you both should have the same version of QuickBooks Desktop.

 

With regards to our Support Team, I suggest you inform your accountant to contact them using his/her QuickBooks Desktop.

  1. Go to Help, then select QuickBooks Desktop Help.
  2. Select Contact Us.
  3. Enter "Upgrade to 2022", select Let's talk and then choose a way to connect.

 

For the multi-user, QuickBooks Desktop 2022 still supports this feature. You'll need an additional license for your accountant so that you both can work on the same file simultaneously. Also, QuickBooks Desktop offers a hosting service to allow your accountant to access the file remotely.

 

Here are the articles you'll need in setting up a multi-user:

 

Once everything's good, you can now cancel your QuickBooks Online subscription.

 

If you need to run reports and customize them in QuickBooks Desktop, you can check these links:

 

Leave a comment again here if you need more help in setting up your QuickBooks Desktop file. Take care always!

calvin-cstt-com
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Hi 

I converted a few months ago from desktop to online and a few of my accounts are way off.  Like GL 1499 is around $30000 in Desktop but in QBO is $2,800,000.00 and my Accounts Receivable is similar.  

 

RCV
QuickBooks Team
QuickBooks Team

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

Let me share some information about converting your data, calvin-cstt-com. 

 

When converting your data to the Online version, some information may not be transferred. This is due to the import limitations and feature differences between QuickBooks Online (QBO) and the Desktop versions. QBO doesn't have the same reports as QuickBooks Desktop. Where QBO accrual basis reports will match your reports in Desktop and cash basis reports may not match. 

 

To find out what data doesn't convert when you migrate to QuickBooks Online, just check out this article: What to expect when you switch from QuickBooks Desktop to QuickBooks Online. If there are missing transactions, you'll have to add them manually to the system. Then, reconcile the account.

 

Feel free to visit our Import data page for more details about bringing your data into your account. 

 

The Community always has your back, and I'm just a post away should you ever need anything. Just leave a comment below and I'll get back to you. Have a great day ahead.

DM06
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

I am having the same issue!!! Can anyone help?

EZeender
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

I think the system can only handle so much historical data.

 

I had a large file with about 8 yrs of data and had to re-import only the past year and everything came in correctly.

 

Just have to keep those older records in QB Desktop

DM06
Level 1

Just converted from QB desktop to QB online and trying to reconcile accounts, beginning balance way off can someone help?

I believe that is what I may have to do, I have over 13 years in my company file. How do I reimport and essentially start over? I have already discontinued my desktop license. Will I need to re open that? I have only been on QBO for 1 month. 

Need to get in touch?

Contact us