Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI 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! Go to Solution.
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:

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:
For QuickBooks Desktop for Mac:
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!
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:

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:
For QuickBooks Desktop for Mac:
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!
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here