Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowDear 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?
What transaction type do you need to import? Bank statements or else?
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:
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here