QuickBooks Desktop - Custom Commissions report
Budget: $30 – $250 USD
We need a custom report in Quickbooks Desktop using Advanced Reporting feature. We need to generate a sales commission report shows invoice details (by line item) with the following values: Customer Name, Invoice Number, Invoice Date, Item(s), Item Unit Cost, Extended Cost (unit cost * qty sold), Invoice Sell Price, Sales Rep Name.
We would also need to add a "Net Profit" column which would be ("Invoice Sell Price" - "Extended Cost") and "Commission" which would be the value of "Net Profit" * .2.
Results would be shown for a date range specified (as a parameter).
This report should be saved as a report in Advanced Reporting.
We would also need to add a "Net Profit" column which would be ("Invoice Sell Price" - "Extended Cost") and "Commission" which would be the value of "Net Profit" * .2.
Results would be shown for a date range specified (as a parameter).
This report should be saved as a report in Advanced Reporting.