Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 1

Exporting a bank account to new QBO file

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!

1 Comment
QuickBooks Team

Exporting a bank account to new QBO file

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:

  1. Log in to your existing QBO account.
  2. Go to Accounting, then Chart of Accounts.
  3. Locate the Checking account you need, choose View Register.
  4. Click the Export to Excel icon above the Balance column.
  5. Open the downloaded Excel file, then save it as CSV or any recommended file type.

To Import:

  1. Log in to your new QBO account.
  2. Go to the Gear icon, then Import Data.
  3. Choose Bank Data, and click Browse and Next.
  4. Select the Bank Account you need to move the transactions, and Next.
  5. Choose the 2 column radio button, then map these transactions accordingly and Next.
  6. 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:

  1. Visit this link:
  2. In the Search field, enter importer.
  3. You can click which one you want to use (for example
  4. 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.

Need to get in touch?

Contact us