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

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

 
3 Comments 3
KlentB
Moderator

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.

twirlztime
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?) 

KlentB
Moderator

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.

Need to get in touch?

Contact us