Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Good morning,
I need help with mapping bank register entries from desktop to online via CSV or Excel. I already completed the migration but some of the bank registers didn't move over to online and now I need to export from desktop and import to online manually. I need the mapping to show Date, Number, type, payee, account, memo, payment, deposit and balance. I've tried it before but it doesn't show me all of the fields and data that I'm needing.
What do I need to do? How do I fix this? TIA!
Can you download the historical data directly from your bank? What file format does your bank provide? e.g csv, pdf
no because the bank account has been closed for a while now. That's why I'm needing to export my desktop register via CSV to QBO. I just downloaded 3rd party Moneythumb csv to qbo converter but I'm having trouble mapping the columns, since the columns and descriptions are different. Of course, Moneythumb doesn't have a support phone number or chat support feature.
You will need 2 migration tools
TP Exporter for Desktop and csv2qbo.
<link removed by moderator>
TP Exporter = $299 one time license and you can buy it via a partner to get $100 cashback.
Welcome to the Community, @coachdennis.
I will share some useful information about mapping bank register entries from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO) using CSV or Excel files.
Each bank's CSV file format is different which means that you may not be able to import CSVs from certain banks because they don't have the format that QuickBooks requires. However, if your bank does not export to a CSV file, you can still upload your statements to QuickBooks Online using Quicken (.QFX), QuickBooks Online (.QBO), or Microsoft Money (.OFX) files, as long as they follow the required format.
At present, the ability to map date, number, type, payee, account, memo, payment, deposit, and balance in the data field of CSV is not yet available in QuickBooks. If you would like this feature to be added, I recommend sending a feature request in the Feedback section within QuickBooks.
Your feedback is valuable to us, and our product development team will review your suggestion and may consider adding it in future updates. To submit your suggestion, follow these steps:
Moreover, if you have tried the steps mentioned in manually uploading transactions into QuickBooks Online but are still unable to import your file, here are a few things you can do to check for common errors for importing bank transactions using CSV in QuickBooks Online.
Let me know whenever you have more queries about bank register entries from desktop to online via CSV or Excel QuickBooks, coachdennis. We're always around to assist you further. Stay safe and well!
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