Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs there a way to produce a report which only includes expenses that I have designated as fixed?
Ideally, that report would include expenses like utilities, salary maintenance, etc. but exclude expenses like charity, travel etc. that are discretionary. If I could add a filter to the expense similar to the way classes works, I could produce a limited monthly report.
Solved! Go to Solution.
Thanks for reaching back out, @dadcowell.
I'm glad to hear you found a report that works for you! I can share some insights on this. Currently, getting the total for each category on your reports is unavailable. As a workaround, you can export it to Excel and do the calculation there!
Please let me know if you have any additional questions on this or anything else within QuickBooks. Have a great Wednesday!
Let me help you run the report you need, dadcowell.
In QuickBooks Desktop (QBDT), we have the Expenses by Vendor Detail report that you can pull up that shows a more detailed version of the expenses by vendor summary report. For each vendor, the report lists the expense and credit transactions that your company had with the vendor. From there, we can customize it to filter the expenses that you only want to show.
Here's how:
Check out these articles below to learn about customizing reports.
Feel free to visit the Community if you need anything else when running a report. We'll be happy to serve you. Have a great day!
Your response was very helpful. I deviated from it a little though. Instead of using "Expense by Vendor" I used total Profit and Loss and tailored it to only include the accounts I needed. It works fine, but I do have a follow-up question.
My resulting report provides all detail, every transaction. I only need the totals for main categories. For example, if my accounts include Utilities: Acct 100000 and sub accts like Power 110000, Water 120000 and Phone 130000, is there a way to only include the total for all sub accounts ie Utilities 100000? Presently, every transaction on every level is included.
Bill
Thanks for reaching back out, @dadcowell.
I'm glad to hear you found a report that works for you! I can share some insights on this. Currently, getting the total for each category on your reports is unavailable. As a workaround, you can export it to Excel and do the calculation there!
Please let me know if you have any additional questions on this or anything else within QuickBooks. Have a great Wednesday!
OK,
Thank you for clarifying. That saves me time. I'll manipulate in excel.
Bill
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.