Hello there, DKieferCPA.
It’s nice to see new faces here in the Community. I’m here to share insights about exporting and importing bank transactions in QuickBooks Online.
The program allows you to export and import bank entries via a CSV, QFX, QBO, or OFX format. However, you’ll only be able to map three fields upon importing them. Those are Date, Description, and Amount (which has separate fields for Income and Expenses).
To Export:
- Log in to your existing QBO account.
- Go to Accounting, then Chart of Accounts.
- Locate the Checking account you need, choose View Register.
- Click the Export to Excel icon above the Balance column.
- Open the downloaded Excel file, then save it as CSV or any recommended file type.
To Import:
- Log in to your new QBO account.
- Go to the Gear icon, then Import Data.
- Choose Bank Data, and click Browse and Next.
- Select the Bank Account you need to move the transactions, and Next.
- Choose the 2 column radio button, then map these transactions accordingly and Next.
- Review those transactions to import, and Next, then Yes and Let’s go!.
The option to add more fields including the Categories field is unavailable. You need to manually select which ones you need to use.
We do have a wide selection of third-party applications you can use to move your transactions with all the details you need. To explore the list:
- Visit this link: https://appcenter.intuit.com/app/apps/home.
- In the Search field, enter importer.
- You can click which one you want to use (for example https://appcenter.intuit.com/app/apps/appdetails?shortName=b-importer).
- Check the Overview and Reviews sections to know if it matches your need.
Also, if this is something you want to see within QuickBooks Online, share more of your thoughts about this to our product engineers. You can let them know by clicking Help, then selecting Feedback Online.
Any suggestions and feedback entered there are considered for future updates. If you need anything else, don't hesitate to reach back to me. I'm here to help anytime.
