Skip to main content
D
ddoyle1
October 9, 2021
Question

After nearly ten years, I would like to leave Quickbooks Online because of the relentless up-selling. I just want to work, not be sold to. How can I export all my data?

  • October 9, 2021
  • 4 replies
  • 0 views
Original commenter did not share additional details

    4 replies

    J
    JonpriL
    October 9, 2021

    Let me walk you through the steps on how to export your data, @ddoyle1.

     

    You can export your lists and reports to transfer your data from QuickBooks Online. I'll show you how.

     

    1. Go to the Gear icon.
    2. Under TOOLS, select Export Data.
    3. On the Reports tab, select the appropriate date range.
    4. Select to turn on all the selections to transfer all your data.
    5. Click Export to Excel.

     

    I'm adding this article to learn more about how you can export your data: How to Download your Data from QuickBooks Online?

     

    You may also read this reference that'll help export any specific transaction data: How to Export Reports from QuickBooks Online?

     

    It'll always be my pleasure to help if you have any other questions besides this exporting concern. I'll be here to lend a hand. Take care and stay safe!

    541955088
    541955088
    October 28, 2021

    I tried this several times yet there seams to be no combination to make it work. What are the parameters to make exporting ALL my own data possible?  Do I need to export one year at a time? One month at a time? 

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    October 10, 2021

    @ddoyle1 

    Do you need to migrate to QB Desktop or another accounting app?

    541955088
    541955088
    October 28, 2021

    Did you find an online replacement for QBOL? or are you moving to a desktop version?  

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    October 29, 2021

    @541955088 

    The same question. Do you prefer to migrate data to QB Desktop or another cloud-based accounting app?

    541955088
    541955088
    October 29, 2021

    Anything other than an Intuit product or anything based on Qucikbook base programing.  To many issues to trust QB, QBOL or anything Intuit has touched. 

      541955088
      541955088
      October 28, 2021

      I found this on another support thread and thought it could be useful to you.  

       

      Rustler
      Rustler
      Level 15
      ‎March 06, 2020 03:43 AM
       
       
       

      @maroneysforeign 

      QBO does not have a back up at all from the user perspective. And when you close your account Intuit will only save the company data as a read only file for one year, then it is deleted - which does not help if an audit occurs in year 2 or 3.

      Intuit backs the servers up, but can not restore your specific file from that back up

       

      US Versions ONLY: Both of the QBO export options to the desktop do not work accurately, not everything is exported, inventory item types are changed with no history, payroll checks are just expense checks, and the make local copy can not be used or opened from desktop. These known problems have existed for over 9 years.

       

      All Versions:
      The only real option to get all your data for archiving against a future audit is to have an accountant log in and print or export to excel the general journal. (Or invite yourself as the accountant, create the log in, and log in as the accountant so you can use the accountant tools.) Due to QBO's limited data handling capability that will probably have to be done in date segments. Of course that may not help in the event of an IRS audit since they have stated that the actual software data file is what they want, and an excel spreadsheet is not satisfactory.


      (Note: simple start does not have a true general journal report at all.)

      QBO data handling capability for reporting is not adequate, if there is more than 5K records it times out and reports that you have too much data. You will have to do a journal report in date range segments, like Jan-Feb, Mar-Apr, etc etc.


      How many months you can span per report is a guessing game since the report can not deal with more than 5K transactions.

       

      Note that in the app store there is now some "backup" apps you can subscribe to, one subscription per company file.  What these do is take a "snapshot" of your QBO data so you can restore it if needed.  But in terms of a standalone back up file that you can access, or save against a future audit,  no there is none.

      Terms & ConditionsAccessibility statement