17 Nov Ask the Expert – Calculating Commissions
Ask the Expert – Calculating Commissions
Q – How do I setup QuickBooks 2002 to automatically calculate (then display in a report) commissions due to employees and 1099 contractors?
A – QuickBooks does not automatically calculate commissions. The best alternative is to use the sales rep field on invoices for tracking amounts sold then create a sales report by rep (either cash or accrual basis). This report can then be used to manually calculate the amounts of commission due, or use the Excel interface (available with Pro or higher) to automate the calculation.