cancel
Showing results for 
Search instead for 
Did you mean: 
WeThotUWasAToad
Level 1

Import bank transaction categories from Excel to QuickBooks online

Hello,

 

I'm brand new to QuickBooks Online (QBO).

 

I want to import a large number of transactions from an Excel CSV file into QBO. However, the online Help section says something about only being able to import four columns (date, description, credit amount & debit amount). In other words, it implies that it is not possible to import categories or memos for the individual transactions.

 

Is that really true or am I looking in the wrong place or at the wrong thing?

 

If it is true, are there any possible workarounds?

 

Thanks

1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

Import bank transaction categories from Excel to QuickBooks online

Thanks for choosing QuickBooks Online (QBO) in running your business. Let me share some information about importing bank transactions, WeThotUWasAToad.

 

When importing bank data using Excel CSV (comma-separated values) files, it will provide you either a 3-column or 4-column format. The option to include the Category and Memo columns in the CSV template format is unavailable. You can check out this article for more details: Import bank transactions using Excel CSV files

 

However, you'll see the Category and Memo field once you downloaded the transactions in QBO. See the screenshot below:

 

category.PNG

 

This way, you can categorize or edit the transactions before adding them to your register. 

 

Here's how:

 

  1. Go to the Banking page.
  2. Click For Review tab.
  3. Double-click the transaction.
  4. Tick the Category drop-down and choose a tax category.
  5. In the Memo field, you can edit it if you want to add more details.
  6. Tap Add.

b1.PNG

 

For more details about this one, check out this article: Categorize and match online bank transactions in QuickBooks Online.

 

If you need to import more than 90 days of bank transactions, just refer to this article for the steps and details: Manually upload transactions into QuickBooks Online.

 

To give you more insights about managing your bank feeds, check out this link: https://quickbooks.intuit.com/learn-support/en-us/banking/07?product=QuickBooks%20Online. From there, you'll see related articles in the Subtopics section.

 

I'm just one post away if you need a hand with reconciling your accounts r any QBO related. I'll be here to ensure your success. Take care always. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us