Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
N
newolduser
March 14, 2019
Question

Conversion issues from Online back to Desktop...help?

  • March 14, 2019
  • 3 replies
  • 3 views

Hello,

I've searched the community and cannot find an answer, so I thought I would ask here...can you help? 

 

We are a small business and were using QBO and decided to return to the desktop version that we had used previously (2018 Pro). We spoke with our accountant and followed the directions to convert from QBO to QBdesktop. 

 

Almost everything converted correctly except a few things. Our biggest issue is reconciliation.

 

When we *reconcile* all the previous cleared expenses/checks going back to 2004 show up as not cleared. We don't know how to fix this. We attempted to reconcile and leave the difference but, obviously, that didn't work b/c QB forced a journal entry for the difference, which now messes up our register. If we leave the previous expenses uncleared, we have to wade through 5000 entries each time we want to reconcile. 

 

Can anyone point us in the right direction?

 

Thanks in advance!

3 replies

IamjuViel
IamjuViel
Level 8
March 14, 2019

Appreciate the complete details of your concern, @newolduser.

 

Allow me to furnish you with information on how QuickBooks Desktop handles your QuickBooks Online company file when undergoing the conversion process.

 

When exporting your QuickBooks Online information to QuickBooks Desktop, there are some information that will not be included. Reconcile reports, due to their special nature as a static report, are not exported.

 

For a more comprehensive list on the limitations of exporting process, you may check out this article: Export limitations - QuickBooks Online to QuickBooks Desktop.

 

To resolve your reconciliation concerns, you may visit this page: Reconcile an account for multiple months or years of transactions and financial statements.

 

Please don't hesitate to visit us here in the Community if you have other questions about converting your QuickBooks Online company file.  I'm always here to help.

    L
    Lain
    March 14, 2019

    Woah. That's unfortunate. And the reply from the QB rep is even more unfortunate.

     

    If you were my client, what I would probably do is take the bank statement from 12/31/2017 and try to reconcile the bank account to that bank statement. Check the box that said "Hide all transactions after the statement date". Then select all the charges from the beginning of the account through 11/31/17. Then go through an individually select all the charges for the Dec 2017 statement. With any luck, you can reconcile it through that date. If worst comes to worst, enter your own transaction (check/deposit) to get the account to reconcile to the 12/31/17 statement. Its not ideal, but at the end of the day you can't spend months trying to re-reconcile the whole account and your taxes have already been filed for 2017. After you reconcile to the 12/17 statement, go through all 12 months of 2018 and reconcile those by month. I would say its more critical to get those reconciliations by month in QB since you may still need to file your 2018 taxes.

    If you have already filed your 2018 taxes, you can try to method I mentioned above but use the 12/31/18 bank statement. Get the 2018 balance sheet from your accountant and enter a journal so that your balance sheet and P&L match their records.

      N
      newolduserAuthor
      March 15, 2019

      Hi Lain,

      Thank you for your detailed response! This is a bit overwhelming since I am a newer user - I'm going to print out your reply and break it down piece by piece so I understand. It's extremely frustrating since we asked the accountant if there would be issues about moving from QBO to Desktop, he said it was doable and no mention of issues. We new there would be some conversion issues and I read about them online but I haven't seen anyone mention having an issue like this!

       

      I don't mind re-reconciling. I think the concern (for me) is that it goes back to 2004 - so I'm not sure exactly how reconciling to 12/31/17 will fix the issues before then...but I'm probably not fully understanding it so I'm going to read it over and try and understand it before I ask any more questions - I don't want to waste your time! Thank you!

       

       

      L
      Lain
      March 15, 2019

      So, the reason I suggested the 12/31/2017 banks statement is because of all the unreconciled deposits and charges going back to 2004. You have to get all those reconciled again and it would be too time consuming to try and reconcile every month since 2004. So, if you do one giant reconciliation from 2004 thru 12/31/17, that will get all those items reconciled so they don't keep showing up every time you go to reconcile a recent bank statement. In theory, since everything was reconciled, you should be able to reconcile 2004-2017 without much discrepancy. And, since your 2017 taxes are already filed, if you have to do an adjusting entry to get 2004-2017 reconcile just let your accountant know what happened and the adjusting entry you entered. With 2004-2017 transaction reconciled, you can move forward with 2018 monthly reconciliations and make sure those are correct as you prepare to file your 2018 taxes.

        J
        jadec38
        April 18, 2020

        PLEASE let me know how you resolved this.  We had quickbooks do the conversion for us after I made sure the books for 2019 were closed and to the accountant.  The conversion has been an absolute nightmare.  Quickbooks will not help me at all.  Now they have told me to speak with the accountant or a pro advisor to fix the errors.  The checking account reverted back to 2011 and is unreconciled and came over with  a zero beginning balance.  The employees info all had to be put in again.  Today I tried to post the payments made by credit cards and that goes way back.   I have used Quickbooks for 15 years and have always been happy.  This is such a bad experience.  We are still paying for both Enterprise and Online as I do not dare to cancel online yet. I am trying to get some sort of help and/or refund--not getting any response at  this point. HELP!

        AlexV
        AlexV
        Level 10
        April 18, 2020

        I'm joining this thread to share additional details about conversion, jadec38.

         

        I understand the effect of converting data especially if you have a bigger company file.

         

        There may be some changes when you convert your company data. There are some data that won't be converted since the QuickBooks Online and QuickBooks Desktop are two different versions and they also have different features. You can see in this article the limitations when you convert from QuickBooks Online to QuickBooks Desktop.

         

        We can fix the incorrect beginning balance and unreconciled transactions by reconciling multiple months at the same time.

         

        Once done, you can pull up the  Profit and Loss report for both QuickBooks Online and QuickBooks Desktop. This is to make sure that your books match after this process. You can see this report in the Reports tab in QuickBooks Online and Reports menu > Company & Financial in QuickBooks Desktop.

         

        I'm just a post away if you need more help with this. Stay safe!

        Need QuickBooks guidance?
        Log in to access expert advice and community support instantly.
        Terms & ConditionsAccessibility statement