Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
BethR_Ballentine
Level 2

Transactions

I just migrated from Quickbooks Desktop to Online (Advanced) and will need to enter the banking transactions in both databases through the end of the year.  I don't use bank syncs; I enter everything manually.  There are approximately 50 different banks, 6 different currencies and 500 transactions/month.  What report can I run in QB Desktop to get a list of all the transactions (that also includes the memo field, exchange rates, foreign currency, and split detail) and then how can I upload this information into QB Online?  Manually entering all of this information into both databases will take too long.  Is there a way to automate this?

Solved
Best answer August 14, 2023

Best Answers
Mich_S
QuickBooks Team

Transactions

I know a way how you can upload your QuickBooks Desktop data to QuickBooks Online Advanced without doing it manually, BethR.

 

You can run the custom report to get a list of all your transactions. Then, customize it to display the memo field and the split detail. Here's how:

 

  1. Open the Reports menu.
  2. Go to Custom Reports.
  3. Select Transaction Detail.                                                                                                                                                                                                                 
  4. Click on the Customize button.
  5. In the Display tab, check the field for Split and Memo.
  6. Once done, click on OK.

 

 

As for the foreign currency information, it will be transferred to your QBO company as long as the Multi-currency feature is enabled and necessary accounts with the right currencies are created.

 

In addition, you have the option to export your QuickBooks Desktop transactions using an IIF file. Afterward, you can search for a third-party converter that can be integrated with QBDT, as this specific file format can't be directly imported into QBO. Here are the steps to follow:

 

For QuickBooks Desktop for Windows:

 

  1. Sign in to your company file as an admin.
  2. Note: If you’re in Multi-user mode, go to the File menu, then tap Switch to Single-user Mode.
  3. Go to the File menu, then choose Utilities.
  4. Select Export, then hit Lists to IIF Files.
  5. Pick the lists you want to export, then select OK.
  6. In the Save in dropdown, select a location to save your IIF file.
  7. Enter a file name, then select Save.

 

For QuickBooks Desktop for Mac:

 

  1. Log in to your company file as an admin.
  2. Open File, then select Export.
  3. Hit Lists to IIF File, then select the list you want to export.
  4. Click on OK, then enter a name for your IIF file.
  5. In the Where dropdown, select a location to save your IIF file, then select Save.

 

See this link for more information about the process: Export, import, and edit IIF files: Export, import, and edit IFF files.

 

If none of this works, you'll have to acquire a CSV of your bank transactions with their respective currencies and manually upload them to QBO. Here's a guide for the procedure: Manually upload transactions into QuickBooks Online.

 

Feel free also to read these extra modules to find out what features/data are transferred to QBO:

 

 

Comment back to get further assistance about this topic or QuickBooks in general. Keep safe!

View solution in original post

2 Comments 2
Mich_S
QuickBooks Team

Transactions

I know a way how you can upload your QuickBooks Desktop data to QuickBooks Online Advanced without doing it manually, BethR.

 

You can run the custom report to get a list of all your transactions. Then, customize it to display the memo field and the split detail. Here's how:

 

  1. Open the Reports menu.
  2. Go to Custom Reports.
  3. Select Transaction Detail.                                                                                                                                                                                                                 
  4. Click on the Customize button.
  5. In the Display tab, check the field for Split and Memo.
  6. Once done, click on OK.

 

 

As for the foreign currency information, it will be transferred to your QBO company as long as the Multi-currency feature is enabled and necessary accounts with the right currencies are created.

 

In addition, you have the option to export your QuickBooks Desktop transactions using an IIF file. Afterward, you can search for a third-party converter that can be integrated with QBDT, as this specific file format can't be directly imported into QBO. Here are the steps to follow:

 

For QuickBooks Desktop for Windows:

 

  1. Sign in to your company file as an admin.
  2. Note: If you’re in Multi-user mode, go to the File menu, then tap Switch to Single-user Mode.
  3. Go to the File menu, then choose Utilities.
  4. Select Export, then hit Lists to IIF Files.
  5. Pick the lists you want to export, then select OK.
  6. In the Save in dropdown, select a location to save your IIF file.
  7. Enter a file name, then select Save.

 

For QuickBooks Desktop for Mac:

 

  1. Log in to your company file as an admin.
  2. Open File, then select Export.
  3. Hit Lists to IIF File, then select the list you want to export.
  4. Click on OK, then enter a name for your IIF file.
  5. In the Where dropdown, select a location to save your IIF file, then select Save.

 

See this link for more information about the process: Export, import, and edit IIF files: Export, import, and edit IFF files.

 

If none of this works, you'll have to acquire a CSV of your bank transactions with their respective currencies and manually upload them to QBO. Here's a guide for the procedure: Manually upload transactions into QuickBooks Online.

 

Feel free also to read these extra modules to find out what features/data are transferred to QBO:

 

 

Comment back to get further assistance about this topic or QuickBooks in general. Keep safe!

Fiat Lux - ASIA
Level 15

Transactions

@BethR_Ballentine 

Can you get *.qbo files from your banks? You can use the same file to import into your QB Desktop file and QB Online account. You don't need to bother migrating data manually from QBD to QBO.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us