Skip to main content
October 7, 2020
Question

QBO Conversion from desktop Open Invoice beginning balance

  • October 7, 2020
  • 2 replies
  • 0 views

Earlier this year, we converted from Desktop to QBO. The file was very large (20+years) so Intuit did the data import for the past 5 years. Of course, it didn't carry over beginning balances so we were instructed to make Beginning Balance JE to adjust and correct. In doing so, we have a $102k "open invoice" JE from 5 years ago. How do we correct this? All deposits are correct.

2 replies

November 28, 2020
  1. Select Sales, then select Customers.
  2. Select the customer.
  3. Select the Opening Balance Invoice.
  4. In the Product/Service column, select the ▼ dropdown and choose another item.
  5. Select Save Great Lakes Login
March 21, 2023

Does this mean you can only convert the past 5 years??? We do 10-15 year comparisons and use more than 10-15 years for some reporting. I hope you can convert as many years as you want.  Please respond.

March 21, 2023

it wasn't about time, it was about the file size.  It was a huge issue and created a domino of challenges for the next year. It only imported the invoices or the payments for the time frame - nothing that was prior to the five years (meaning if an invoice was in year six prior and the payment was year 5 prior, the transaction was broken. All of our beginning balances were wrong. We now have rogue JE to correct the beginning balances that Intuit would not/could not assist with. it was the messiest conversion we ever had in any software migration.

March 21, 2023

Sorry you went through that.  We're thinking about moving from Desktop to Online as well.