cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Analec
Level 1

Migration

A client wants to migrate from Quickbooks Pro desktop to Quickbooks online but they want to only bring over the files beginning January 2022, is possible to select a starting point when migrating?

Solved
Best answer February 12, 2023

Best Answers
LollyNino_C
QuickBooks Team

Migration

Thank you for posting here, @Analec.

 

First, we'd like to know your answer to Fiat Lux - ASIA clarifying questions. This helps us address your concern and provide further information related to it.

 

We can utilize the Condense Data feature in your company file to help you to reduce the size of your file. Note: Condensing data in your account is irreversible.

 

  1. Select File, then Utilities, and then Condense Data.
  2. As illustrated below, choose the first choice. Please note that the system will inform you of the approximate file reduction.
  3. Click Next and the message Working on your file now will show. When the optimization is finished, a window appears, informing you of the total file size reduction as well as the location of the backup file created before the optimization.

 

Afterward, let's reimport the data into your QuickBooks Online account.

 

Also, you can check about moving data from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO): 

 

 

Get back to us if you have any other questions while migrating data from QuickBooks Online to QuickBooks Desktop. I'm always here to help you sort things out.

View solution in original post

7 Comments 7
Fiat Lux - ASIA
Level 15

Migration

You may have 3 options:

1. Convert your data and utilize a deleter tool to remove all transactions prior to 1/1/2022.

https://get.transactionpro.com/qbo

 

2. Use a migration tool. i.e TP Exporter for Desktop and TP Importer for Online

https://get.transactionpro.com/qbo

 

3. Purchase a 3rd party conversion service

Analec
Level 1

Migration

Thanks very much, this was helpful

Fiat Lux - ASIA
Level 15

Migration

I missed the 4th option. If you are using QBD US version, use the Condense Data utility to remove all transactions before 1/1/2022.

LollyNino_C
QuickBooks Team

Migration

Thank you for posting here, @Analec.

 

First, we'd like to know your answer to Fiat Lux - ASIA clarifying questions. This helps us address your concern and provide further information related to it.

 

We can utilize the Condense Data feature in your company file to help you to reduce the size of your file. Note: Condensing data in your account is irreversible.

 

  1. Select File, then Utilities, and then Condense Data.
  2. As illustrated below, choose the first choice. Please note that the system will inform you of the approximate file reduction.
  3. Click Next and the message Working on your file now will show. When the optimization is finished, a window appears, informing you of the total file size reduction as well as the location of the backup file created before the optimization.

 

Afterward, let's reimport the data into your QuickBooks Online account.

 

Also, you can check about moving data from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO): 

 

 

Get back to us if you have any other questions while migrating data from QuickBooks Online to QuickBooks Desktop. I'm always here to help you sort things out.

Simply_jer
Level 1

Migration

Is it possible to only bring in 2021 transactions and not have it overwrite current? We had one year not get imported and now trying to figure out how to get all that information into QuickBooks online. 

Carneil_C
QuickBooks Team

Migration

Yes, it is, @Simply_jer. I'd gladly guide you on how it works in QuickBooks Online.

 

We can enter your 2021 bank transactions into QBO without overwriting the current transactions by manually uploading them.

 

First, choose a start date. Then, ensure you know the date of the oldest existing transactions of your current account to avoid duplicates. Here's how:

 

  1. Go to the Bookkeeping menu, then select Chart of accounts.
  2. Choose the bank or credit card account you want to upload the transactions.
  3. Click View register.
  4. Find and write down the date of the oldest transaction. The oldest transaction is usually the opening balance.

 

From there, we can now get the transactions from your bank. I'll show you how:

 

  1. Sign in to your bank or credit card's website.
  2. Follow your bank's instructions for how to download CSV files of your transactions to your computer. Every financial institution has different steps.
  3. Verify the date range for the download. It should be at least one day before the date of your oldest transaction.
  4. Download your transactions and save them somewhere you can easily find them, like your computer's desktop.

 

Then, open and review the file from your bank and ensure it's in the correct format before uploading it.

 

Once you're ready, you can now start uploading your transactions manually. For the detailed procedures, you can check out this article to further guide you in the process For accounts connected to online banking and For accounts not connected to online bankingManually upload transactions into QuickBooks Online.

 

On top of that, these handy resources can help you organize your transactions flawlessly in the future:

 

 

I’m always ready to assist you with other questions or concerns about managing your bank transactions. Tag me in your reply, and I'll get back here as soon as possible to help you again. Take care always.

Fiat Lux - ASIA
Level 15

Migration

@Simply_jer 

You can use the migration tool as I mentioned earlier or purchase a 3rd party migration service.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up