Set up commission payroll item and reports
This article describes how to track commissions paid to employees. Make sure you have already set up employees in QuickBooks, and you know how much commission you would like to pay.
The following art the tasks you will have to perform in QuickBooks:
If you have different types of commissions that you want to track separately in your reports, use a separate payroll item for each commission type.
In QuickBooks, click Lists > Payroll Item List.
At the bottom left of the Payroll Item List, click the Payroll Item dropdown button, and choose New.
Select Custom Setup and click Next.
In Payroll item type choose Wage. Click Next.
From the Wages list, choose Commission. Click Next.
Enter the Item Name which prints on payroll checks and reports. Click Next.
Enter an Expense Account. Click Next.
If you want to set a rate, in the Default Rate window, enter an amount or percentage to calculate this commission. To enter a percentage, type a percent sign (%) after the number. You can change this figure whenever you use the commission item.
From the QuickBooks menus at the top, click Employees > Employee Center.
Double-click on the employee's name.
Click the Payroll Info tab.
Add the item under Earnings by clicking in the white box under item name and choosing the item from the drop-down list.
Enter the rate in the rate column.
When creating payroll:
When preparing payroll, you should see the commission item in the Preview Paycheck window for your commissioned employees. You must enter an amount in the Rate and Quantity columns.
- If you set up the commission item using percent (%) in the rate column, in the quantity column enter the amount the commission is to be calculated upon for the period. QuickBooks will compute the commission based on the percent and quantity.
From the menu on top, click Reports> Custom Transaction Detail Report.
Click on Customize Report in the upper left corner.
On the Display tab, check Name and Source Name.
On the Filter tab, in choose filter, set the Transaction Type to Paycheck.
Set the Payroll Item to the commission item used on paychecks.