Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 28, 2020
Question

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

  • March 28, 2020
  • 1 reply
  • 2 views
No text available

1 reply

Level 8
March 29, 2020

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.

March 29, 2020

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

Level 8
March 29, 2020

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.