Hello
I am trying to put together a report showing my expenses (of all kinds, checks, bills, credit card payments, etc.) paid to each vendor, grouped by account, over a given time period.
The pre-existing "Expenses by Vendor Summary" report is almost what I need, but instead of 1 total column, I want columns for each account I select in my filter. When I try to use Custom Summary Report to re-create this, a "Retained Earnings" account (I have no idea what that is) shows up for every single vendor and messes with all the totals, making it unusable and ruining the "don't show 0 value columns/rows" filter.
Here's my use case: I have various subcontractors that we pay for construction work. I have a bunch of accounts for each type of work they may do (drywall, foundation, framing, plumbing, etc). Some subcontractors provide work in multiple unrelated accounts, so I need to quickly and easily see that I've paid, e.g., John $500 for plumbing and $1000 for drywall, and Henry $200 for foundation and $800 for plumbing. I can't use the total amounts paid (in this case, $1500 and $1000, respectively) because different kinds of work have different insurance/billing rates.
I do not want to see every individual transaction, and they must not be separated by Customer/Job. They must be totaled per account, across any arbitrary time period, even spanning multiple years.
I am using QuickBooks Desktop Contractor 2020 US.
