Skip to main content
S
Susan607
February 14, 2024
Solved

Appending uploaded file

  • February 14, 2024
  • 2 replies
  • 0 views

I have a client who has an online account where he generates invoices.  His previous bookkeeper did not give me that file.  I constructed a new company file on my QBDT for Mac for his 2023 year.  The online file had prior year's, mid-2021 and all of 2022 and a few months of 2023 on it.

 

I would like to upload my file to his QB online file for that company.  How will that work?

Will there be duplicates for the 2023 entries?  Will my file, upon upload, erase the prior entries already in the file or will it append to what's there?  If I have a customer list with different information, for instance, addresses where she had none or vice versa, how will that be treated upon upload?

 

Many thanks for addressing this perplexing difficulty.

 

Best answer by RhoiceW

Hi there, Susan. Thank you for reaching out to the Community. I'd be glad to provide some steps on how to move your files from QBDT Mac to QBO.

 

Here's how:

 

  1. Sign in to your QuickBooks Desktop file as the admin.
  2. Select File, Export, and then To QuickBooks Online.
  3. Click Get started. Tick Export all your company file data or Export specific data.
  4. If you use inventory, you can choose whether you want to move inventory or not.
  5. If you already have a QuickBooks Online account hit Yes, sign me in, and enter the credentials.
  6. If you don't have a QuickBooks Online account, click No, I need to create a new one and create a new account.
  7. Choose the QuickBooks Online company to move your data to, then select Continue.

 

Please know, that when you start migrating, your QBDT data will replace the existing data in QBO.

 

I'll leave this article for you to have detailed steps on how to move your files from QuickBooks Desktop for Mac to QuickBooks Online.

 

In the meantime, you can manually upload your bank transactions to QBO by following these steps if you don't want your transactions to be removed: Manually upload transactions into QuickBooks Online

 

In addition, you can check on this article to learn how to connect your bank and credit card accounts to QuickBooks Online: Connect bank and credit card accounts to QuickBooks Online


Feel free to leave a comment if you have further questions about moving your files to QuickBooks Online. I'm always here to lend a hand.

2 replies

4
4Gal
February 14, 2024

You can purchase a third party service just to migrate data from your QB Desktop file to their existing QBO account.

S
Susan607Author
February 14, 2024

That really doesn't answer my question.  Are you saying I need to go to a third party vendor in order to have my questions answered?

4
4Gal
February 15, 2024

@Susan607 

You're using QB Desktop for Mac, correct? The problem is that none of the migration tools support this edition. If you prefer to go the extra mile to avoid third-party solutions, you may consider the following steps:

1. Find a Windows machine and convert your data from the existing QBO account to QB Desktop

2. Convert and open the QB Desktop file on your Mac.

3. Migrate the 2023 data from your QB Desktop file to another file.

4. Convert the merged QB Desktop file to a new QBO account.

 

Otherwise, you should reconsider purchase a 3rd party migration service as I mentioned.

R
RhoiceWAnswer
February 14, 2024

Hi there, Susan. Thank you for reaching out to the Community. I'd be glad to provide some steps on how to move your files from QBDT Mac to QBO.

 

Here's how:

 

  1. Sign in to your QuickBooks Desktop file as the admin.
  2. Select File, Export, and then To QuickBooks Online.
  3. Click Get started. Tick Export all your company file data or Export specific data.
  4. If you use inventory, you can choose whether you want to move inventory or not.
  5. If you already have a QuickBooks Online account hit Yes, sign me in, and enter the credentials.
  6. If you don't have a QuickBooks Online account, click No, I need to create a new one and create a new account.
  7. Choose the QuickBooks Online company to move your data to, then select Continue.

 

Please know, that when you start migrating, your QBDT data will replace the existing data in QBO.

 

I'll leave this article for you to have detailed steps on how to move your files from QuickBooks Desktop for Mac to QuickBooks Online.

 

In the meantime, you can manually upload your bank transactions to QBO by following these steps if you don't want your transactions to be removed: Manually upload transactions into QuickBooks Online

 

In addition, you can check on this article to learn how to connect your bank and credit card accounts to QuickBooks Online: Connect bank and credit card accounts to QuickBooks Online


Feel free to leave a comment if you have further questions about moving your files to QuickBooks Online. I'm always here to lend a hand.

S
Susan607Author
February 16, 2024

Hello RhoiceW -  The salient feature of what you had to say is the piece about the replacement of the existing data.  This lets me know that an append does not take place.  

 

I'm going to follow 4Gal's advice about migrating and merging data on a PC version of QB.  I hope to be able to gather the previous data kept on QBO prior to 2023 and bring it into my desktop file which only has 2023 data.  After this is done, I can then upload the completed file to QBO which will replace the current online file. Many thanks for your reply and thoughtful response.

4
4Gal
February 16, 2024

@Susan607 

Which QB Desktop Mac year version do you have?

Terms & ConditionsAccessibility statement