I'm taking over the bookkeeping for a client who had good intentions, but has no accounting background and has managed to make a mess of the company's QBO accounts. There are negative bank balances galore, among other issues. She has spent a lot of time coding bank feed transactions to proper expense categories and since that part is mostly correct, I don't want to lose what she's spent many hours doing (nor do I want to spend the time to re-do it myself). If I create a new QBO company file and export just the 1 checking account from the old company file to the new, will it maintain the income and expense categories to which the transactions have already been assigned? Thanks for any input!
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).
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.
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:
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.