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.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Can you create summaries of all restaurant expenses, for example?

 
3 Comments
QuickBooks Team

Can you create summaries of all restaurant expenses, for example?

Yes, you can definitely do it, twirlztime.

 

We can create a create summaries of all expenses expenses by customizing the Transactions table. I'll guide you in doing it:

 

  1. Select Transactions from the sidebar menu.
  2. Choose Spending from the Type drop-down menu.
  3. Select the desired type of expense.

Once done, the program will show all the transactions associated to that type of expense. We can simply click the Download icon on top right portion of the table to export it to an Excel file, then summarize the amount from there.

 

Aside from this, we also view the totals of your expense by pulling up the Business and Personal Expense Report or Profit and Loss Report

 

I've also added an article that will guide you in assigning and categorizing your transactions in QuickBooks.

 

You can always find me here if you need more help in managing your bank transactions in QuickBooks. Stay safe and healthy.

Level 1

Can you create summaries of all restaurant expenses, for example?

Thanks!  I see that both the transactions I assigned to this type and a bunch of others are in this group (Accurately). Do we know if AI got 'em all or do I have to go through all transactions to assign them (any quick hacks there?) 

QuickBooks Team

Can you create summaries of all restaurant expenses, for example?

Thanks for coming back to this thread, twirlztime.

 

Once we apply that specific filter to the transaction table, the program will automatically search and show all the transactions associated with that filter.  I would recommend going through all the transactions to assign them to ensure that your records are accurate.

 

You can select the Unreviewed and uncategorized or Unreviewed income in the Type drop-down menu for more convenient tracking of all your uncategorized transactions.

 

You'll want to create a bank rules to speed up the review process. We can create rules that automatically categorize transactions for you. The more QuickBooks uses your bank rules, the better it gets at categorizing. This feature can even scan transactions and add details like payees.

 

I encourage you to visit this article about setting up bank rules to automatically categorize transactions from your bank: How to set and use banking rules for downloaded transactions.

 

If I can be of any additional assistance, please don't hesitate to come back to this thread. It's always my pleasure to help.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us