Appending uploaded file

Susan607 · ‎February 14, 2024

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.

RhoiceW · ‎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:

Sign in to your QuickBooks Desktop file as the admin.
Select File, Export, and then To QuickBooks Online.
Click Get started. Tick Export all your company file data or Export specific data.
If you use inventory, you can choose whether you want to move inventory or not.
If you already have a QuickBooks Online account hit Yes, sign me in, and enter the credentials.
If you don't have a QuickBooks Online account, click No, I need to create a new one and create a new account.
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.

View solution in original post

4Gal · ‎February 14, 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.

View solution in original post

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.

Susan607 · ‎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?

RhoiceW · ‎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:

Sign in to your QuickBooks Desktop file as the admin.
Select File, Export, and then To QuickBooks Online.
Click Get started. Tick Export all your company file data or Export specific data.
If you use inventory, you can choose whether you want to move inventory or not.
If you already have a QuickBooks Online account hit Yes, sign me in, and enter the credentials.
If you don't have a QuickBooks Online account, click No, I need to create a new one and create a new account.
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.

4Gal · ‎February 14, 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.

Susan607 · ‎February 16, 2024

4Gal - Yes, I have desktop for Mac. I do have the windows version on a PC which I will do the migration. Thanks for your astute observation.

I look forward to the data migration and merging of the new files. Stay tuned!

Susan607 · ‎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.

4Gal · ‎February 16, 2024

@Susan607

Which QB Desktop Mac year version do you have?

Susan607 · ‎February 16, 2024

4Gal · ‎February 16, 2024

You will face another challenge. You have to find QB Desktop 2023 Pro/Premier to convert data from QBO, then convert the file to your QB Desktop 2023 Mac. You can use the trial version of QB Desktop 2023 Enterprise to convert data from QBO but you need to purchase a third-party service to convert data from Enterprise to Mac. Another option, purchase a third-party service to convert data from QBO to QB Desktop Mac directly.

Topics

Training

Community

Resources

Appending uploaded file