Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 9, 2020
Question

I have numerous transactions that have been categorized upon import from my bank incorrectly. How can I bulk update a group of transactions expense category?

  • May 9, 2020
  • 1 reply
  • 0 views
No text available

1 reply

Level 9
May 9, 2020

Welcome to the Community, heybrettwilliam.

 

We can re-categorize the transactions that have been incorrectly categorized from your bank. If they are from the Banking page, we can Undo them and re-categorize, and then add them back to your bank. Here's how:

 

  1. Go to Banking and choose the Banking page.
  2. Select your bank account and click the In QuickBooks tab.
  3. Select the affected transactions and click the Undo button.
  4. Go to the For Review tab and select the transactions that should have the same category. You only want to select the transactions from the same payee.
  5. Click on Batch Actions, and choose Modify Selected.
  6. Choose a Payee and a Category.
  7. Click Apply.

For expenses, we can categorize them in the Expenses menu. Here are the steps:

 

  1. Go to Expenses and choose the Expenses tab.
  2. Select the expenses that can be categorized in batch under the same account. They are the ones with categories placed in a box with a down arrow.
  3. Click Batch Actions and choose Categorize Selected.
  4. Choose an account and click Apply.

Here are links you can check for additional information:

I'd also encourage setting up bank rules to automatically categorize your transactions from your bank.

 

Please tag me directly if you have any questions about the process. I'll be here to help you out.