Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Mark343
Level 1

Preassigning Categories during Data Import in QuickBooks Online

Dear all, Is it possible to select your account while importing data in QuickBooks Online, similar to the way it works in the desktop version? Currently, I only see fields for date, description, and amount, and I have to manually choose the category afterward. Is there a way to preassign the category?

3 Comments 3
4Gal
Level 11

Preassigning Categories during Data Import in QuickBooks Online

What transaction type do you need to import? Bank statements or else?

Nicole_N
QuickBooks Team

Preassigning Categories during Data Import in QuickBooks Online

I see the importance of streamlining your workflow and ensuring accuracy in categorizing transactions, @Mark343.
 

Please know that the option to select an account during the import process isn't possible since it's not included in the CSV file. However, we can use the bank rules feature that allows you to automatically categorize imported transactions based on specific criteria. 

 

To set up Bank Rules, you can follow these steps:

 

  1. Log in to your QBO account.
  2. Go to the Gear icon, then choose Rules.
  3. Select New Rule and enter a name.
  4. From the Apply this to transactions that are ▼ dropdown, select Money in or Money out, then choose a bank or credit card account.
  5. You can set a single rule with up to 5 conditions by selecting + Add a condition.
  6. In the Conditions fields, specify whether the rule applies to Description, Bank text, or Amount. Then select Contains, Doesn't contain, or Is exactly to decide how QuickBooks applies the rules.
  7. Select the settings for the rule. Select the Transaction Type, Category, Tags, and the Payee to apply.
  8. Select Save.

 

Once done, QuickBooks automatically applies your rules to transactions in the For review tab. This can save you time and effort in manually assigning categories to each transaction. That said, it's important to review them daily.


To keep your QuickBooks transactions in line with your bank and credit card statements, we recommend reconciling your accounts monthly. This helps maintain accurate and balanced accounts.

 

If you have clarifications about importing transactions in QBO, feel free to ask by posting down below. I'd be more than happy to answer them for you. 

Jeremytlim
Level 1

Preassigning Categories during Data Import in QuickBooks Online

I just had the same issue, we tried to see where the category was on the export file, and based a trial on the import file which worked.

 

We put the category in the same cell as the product name like so: Category:Product name (no spaces in between the colon on both sides. For example: General Merchandise:Wallet, or Housewares:12 Inch Pan.

 

When it was imported, the item showed up in its corresponding category.

 

Hope this helps others.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us