Skip to main content
OnTrack Team
OnTrack Team
February 14, 2024
Question

QBO File/Data Copy/Backup Issue

  • February 14, 2024
  • 3 replies
  • 0 views

Hi all:

 

We have an issue with a QuickBooks Online file that could not be copied or backed up.

The file goes back to end of 2015, it has 144k transactions and 296k transaction lines.

The account is Advanced.

 

I first tried exportqbodatatoqbdt to downgrade to Desktop, which is our original ultimate goal.

And I keep getting this error: "Sorry, but something went wrong on ... when you requested that a company file be created for downloading. Please click Start Over to try again."

 

exportmybooks said: "Unfortunately, the conversion did not succeed because the company file data is too large for export out of QuickBooks Online for the chosen start date of 2015-01-01"

 

The QBO Copy feature did not work either.

 

Intuit Data Services said after mentioning the above error:

It is a combination of a) The file being too large and b) Some of the data being stored in the backend tables using an older format.

 

Rewind stopped their QBO Copy feature a while back.

They exported and shared a backup. It comes in JSON files, a file per entry.

As they said, I would then have to use a knowledgeable developer to restore it to another file.

The current issue is that the export is missing most transaction types after trying twice.

 

I made a Skyvia backup of the list data only and restored it into another QBO file.

Some of the products had an error saying: "Required parameter ExpenseAccountRef or IncomeAccountRef is missing in the request". I added those using Spreadsheet Sync.

I was going to use the Skyvia Import Integration to transfer each transaction type at a time, but I lack the required knowledge for it. I do not expect it to run very smoothly anyway.

I have scheduled a demo with them.

 

Exporting and importing using tools like SaasAnt and Transaction Pro is of course last resort.

 

And now I am here seeking some recommendations from the experts in the Community.

 

Thank you,

Joel

 

Notice:

This post is about a unique and uncommon problem.

Before responding, please make sure that you are addressing the issues mentioned above.

Leave out any instructions and explanations that relate to the standard use of QuickBooks.

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

About OnTrack:

    3 replies

    OnTrack Team
    OnTrack TeamAuthor
    February 14, 2024

    @BigRedConsulting

    @Pete_Mc

    @john-pero

     

    I would appreciate your input.

    Thanks in advance!

    BigRedConsulting
    BigRedConsulting
    February 14, 2024

    RE: I would appreciate your input.

     

    As your description of your efforts supports, QuickBooks Online is a steaming pile.

     

    Technically weak. Feature weak. Functionally weak. Probably spaghetti code, given the plethora of bugs Intuit introduces with every update.

      OnTrack Team
      OnTrack TeamAuthor
      February 14, 2024

      @BigRedConsulting

      RE: QuickBooks Online is a steaming pile...

       

      Well said!

        4
        4Gal
        February 14, 2024

        Consider purchasing a third-party service to migrate the last 2 years of data (1/1/2023 to date) to a new QBO account as a pilot project. Then you will try to convert it to QB Desktop. If all goes well, migrate another year to convert the data again to QB Desktop until the converter refuses to continue. You will create another new QBO account to migrate the remaining data and convert it to QB Desktop. This will definitely take time.

          OnTrack Team
          OnTrack TeamAuthor
          February 14, 2024

          @4Gal,

          Re: migrate the last 2 years of data

           

          Great idea!

          Right on it. I will keep you posted.

          OnTrack Team
          OnTrack TeamAuthor
          February 16, 2024

          Update:

           

          exportmybooks was successful with a 2022 start date!

          I haven't converted it to desktop yet, and I will rather assume that this part wouldn't be the issue, than paying the $248 fee now.

           

          Another update is that I learned from the client that what they need most importantly for now is a file containing the years 2020-2022.

           

          So I kicked in another export starting from 2020 and will see how that goes.

          I don't expect it to be ready before next week.

           

          Will update you further.

           

          Thank you!

          Joel

          OnTrack Team
          OnTrack TeamAuthor
          March 5, 2024

          I now have a full export from Rewind Backups.

           

          It took us some time to figure out that the ZIP file they shared with all the files didn't extract fully using the Windows 10 ZIP extractor. WinRAR did it.

           

          And now that I have a full set of JSON files from Rewind I don't know where to go from here and I would appreciate any advice.

          How do I get a bunch of JSON files uploaded to QBO?

           

          Do you know anyone having JSON-QBO experience and would be available to be hired for this?

           

          In the other hand, exportmybooks is still working on getting me exported data for QBD earlier than 2020.

           

          Thank you,

          Joel

           

            Terms & ConditionsAccessibility statement