Skip to main content
J
JocelynC
January 16, 2020
Question

Report showing vendor invoice total with any deductions taken

  • January 16, 2020
  • 1 reply
  • 0 views

I am trying to figure out how to create this report, but cannot seem to do it.

I want a report showing any vendor who received a check last month that had a deduction from a certain Gen.Ledger account (worker's comp).  The report would need to show the total billed to the client, and the WC deduction amount removed from the vendor's check.

Example:

Enter Bill: -> Vendor Invoice for $1000.00 to Client A

No worker's comp insurance -> deduct under Expenses: WC account for 10% (100.00)

Check run to vendor -> $900.00

The report needs to show a $1000 column/row and a $100.00 column/row (as a split I'm guessing).

I can only get a report showing $100, but not what the vendor billed us for so it's useless as I need to know the starting invoice amount.

Any clue as to how to customize this? 

1 reply

L
LauraAB
January 16, 2020

Hello JocelynC,

 

It sounds like you're looking for a pretty precise report and I appreciate the details you've given here. Knowing more about the situation will help with figuring out whether there is a report that'll bring up the details you need, but I have a few suggestions to get you started with your customization.

 

Many reports, including vendor reports, can be customized to show specific transaction types as well as specific accounts that are being used. However, when you run a vendor report, it might be trying to pull the account that you paid the cheque from, rather than an account used on the transaction. For that reason, it may be better suited to run something like the Transaction Detail by Account report.

 

When you run this report, you can filter for the Workers Comp insurance account and for cheques as the transaction type. Also adjust the date range, and you should be good to go. The report will show you the cheques that used that account, the amount debited for that specific account, as well as the total for the cheque.

 

When you run the report, simply click Customize Report, then go to the Filters tab to choose the options you'd like. Click OK to run the report once you're done picking. I'll leave you with this article to help with the specifics of customizing: Customize reports in QuickBooks Desktop

 

To work with an agent directly and share more details of what you're looking for, reach out to the phone support team for assistance. Check out the Intuit QuickBooks Desktop software support policies page for information about how to get in touch.

 

Take care and enjoy your day!

Terms & ConditionsAccessibility statement