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

Data migration

Looking for the best approach to take converting to a new QBO system.

 

I have been using QBO to create invoices and receive payments from my clients over the last 5 years.  My bookkeeper was using their own QB Desktop version to enter journal entries and then that was submitted to my accountant.  

1. It was suggested to me to create a new QBO system and import the journal entries from QB desktop which I have now done and the numbers match accordingly.  

2. I have now exported all the invoices & details from the existing QBO system and want to import them into the new QBO system.  However, I can't seem to find where I can get the payments from for the invoices that have been paid.  Note that journal entries have been completed up to my 2020 year end.  

 

Does anyone have any suggestions on the best approach to finish this migration off?

 

 

9 Comments 9
carolineambrozio
Level 4

Data migration

Hi @cfburke03 ,

It's great to hear that you're thinking of converting to QuickBooks Online. You'll enjoy the ease and convenience of using the program anywhere you have an internet connection. The corresponding mobile app allows you to snap pictures of the receipts and track mileage on the go. I can provide you with the information you're looking for.

 

All the details for converting are included in this article: Migrating from QuickBooks Desktop to QuickBooks Online. 

 

f you have any questions about the process, you can always reach out. I'll be here. Have a great evening!

Noelia Nievas
Level 4

Data migration

Hi @cfburke03 

 

Welcome to the community! We are more than happy to help. The community is a great place to get answers and receive support.

 

I recommend this article, click here, to make sure all steps have been followed.

 

If you require more assistant, please do not hesitate to reach back out.

 

Noelia

Fiat Lux - ASIA
Level 15

Data migration

@cfburke03 

Utilize an exporter tool with your old QBO account to export the Receive Payments data with the followig template

RefNumberTxnDatePaymentRefNumberCustomerPaymentMethodDepositToAccountInvoiceApplyToLineAmountPrivateNoteCurrencyExchangeRate
128/11/202050245Janice JohnsonCheckChecking101100.00   
228/11/20204908Leonard Walker IncCheckChecking102138.78   
328/11/20204908Lisa SmithCheckChecking103126.50   

 

then utilize an importer tool on your new QBO account later.

https://transactionpro.grsm.io/qbo

 

cfburke03
Level 1

Data migration

My question is more specific than what is in the link you provided.  Please advise a solution specific to my particular post. There is nothing in the link you provided that addresses my issue.

Fiat Lux - ASIA
Level 15

Data migration

@cfburke03 

Did you address your respond to which one? You may migrate Invoice data between QBO accounts. But you may need to utilize a 3rd party tool migrate Receive Payments data to match with your migrated Invoice data. 

cfburke03
Level 1

Data migration

Thank-you!  that looks like it might work. I just had a quick look at the exporter tool.  What method will I use to import the payment data?  I'm not sure I have seen the option to import payment information into QBO.

 

Many thanks for your reply

 

 

Fiat Lux - ASIA
Level 15

Data migration

@cfburke03 

Connect the exporter tool to your old QBO account and the importer tool to your new QBO account. The same product but different function.

 

cfburke03
Level 1

Data migration

Thank-you! you have been very helpful

 

Another question but this may be more of an accountant question.  

 

My original bookkeeper used journal entries on her QB Desktop system for my business.  She exported those JE for me to import into a the new QBO system.  I entered all my invoices and client payments into my existing/old QBO system.  I have now exported all those invoices that go back as far back as JE's.  Importing the invoices and payments to the new QBO will skew my sales.  Do you have a suggestion on how to rectify that in the new QBO system?  Should I create a JE to reverse the additional sales from the imported invoices?

 

 

JamesM4
QuickBooks Team

Data migration

Hi there. Making sure you're recording your transactions properly is an essential step for maintaining clean books. Based on what you've described, I'd recommend reaching out to an accounting professional for expert advice on how to record the transactions on your account. If you're not in contact with a professional, don't worry, you can search for one using this link here

 

I'll also leave this question open in the Community so other accountant users can share their advice. Otherwise, feel free to ask other questions, I've got your back. 

Need to get in touch?

Contact us