Commissions

Monthly commission is done only after the last day of the commission month. For example, August Commission could only be started Sept. 1 or later.

Note: Be VERY careful entering dates; every date needs changed. If it gets done wrong it takes HOURS to fix up.

Processing the Commission

*Go under “Sales”, “Options”

*Select the “Salesperson” Tab

*Do the following for each salesperson… (as of June 2018 JB Wagman Sales)

Select the salesperson’s name
Click the “properties” button to open the salesperson record.
Click the “commissions” tab
Click the transactions button (bottom right hand corner) to view the commission list. If prompted, post transactions.
If no transactions are listed, close the Commissions Transactions window and click cancel in the sales person window, and skip over remaining sub steps.
Set the commission payment date to the last day of the previous month. (PICKY!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!) Only commission transactions from invoices dated on or before the payment date will be displayed on the list.
Select Paid button to select only the commissions that were generated from sales invoices that are fully paid.
Review as many of the checked items as necessary for you to be reasonably sure that the correct items are checked.
Click the Process button to process commissions.
Click the Next button to continue to the next wizard page.
Enter the commission Payment date (last day of the previous month)
Click the Finish button.
Click close on the Commission transaction window.
Click yes to save changes
Click OK on the salesperson window.
Repeat these steps for each salesperson.
Click OK in the Sales “Options” window.

Printing the Report

*Printing the Commission Detail Report…

Go under “File”, “Reports”
Open the folders Reports>Sales>Sales Person, then in the right hand panel, double click “Commission Detail for Salesperson”
Set the “Commission Date” to the last day of the previous month.
Set the “Period Ending” to the same as the “Commission Date”
Set to print for ‘All Sales persons’ (or select range if you only wanted one salesman’s report)
Do not set to “Suppress Commissions and rates”
Set to “Print Invoice Totals Only”
Set to “New Page for Each Salesperson” (If printing for only one salesperson, then this setting does not matter.)
Hit Print. (it usually takes awhile for them all to process & print)

Making the Spreadsheet

*Repeat these sub steps for each salesperson…….

Open up the “Doc Library”, and double click on the salesman desired.
Scroll down until you see the icon for last month’s excel spreadsheet commission, double click to open it up.
Last month’s spreadsheet will display. In upper left-hand corner, click File, and under it hit “Save as”, “Excel Workbook” , and titled “YYYY_MM Month” of the commission month (Example: 2013_08 August). Save.
Now this spreadsheet that still remains on the screen has been renamed and can now be used for this month’s commission.
Delete all customers, dates, invoice #’s, gross sales, and the rates. DO NOT DELETE $0.00 Under FREIGHT & PKG.!! Fill in correct date. (Highlight all cells and tap the Delete button.)
Back on the Report (say ‘Print’ again, to bring up the print dialog again)> hit Export button>change the format to Microsoft Excel 97-2003- Data Only (XLS) > Save it in ScanSnap folder> (say OK to ‘Typical: Data is exported with default options applied). Now you can copy and paste by appropriate column into your report.
Using the “Commission Detail for Salesperson” report you saved in the ScanSnap folder, copy and paste in all the information in the spreadsheet, (customer name, date, invoice #, gross sales, and rate (rate as a decimal).) The freight & pkg. and commission amount will be auto-filled in. Each Commission amount will be slightly less than that on the Report.
Once all information has been filled in and everything looks correct, print the file.
Save and close out of the current spreadsheet and go on to the next salesman.

Approving the Commissions

*Paper clip the Commission Detail for Salesperson & the Excel Spreadsheet together for each salesperson.

*Take to Tim for him to approve. Make any changes, and if necessary, reprint the excel spreadsheet with the new adjustments.

Creating the Purchase Order

*Repeat these sub steps for each salesperson…

Go under “Expenses”, “Vendors”
Select the desired salesperson.
Select the “Invoices” Tab, and change the status to “Paid”
Double Click on the last paid Commission Invoice (look in the description column to be sure)
Invoice will pop up. In the upper left hand corner, go under “File”, and select “Copy Invoice”. The invoice will make a copy of itself.
Set the invoice # to yyyymm (example: 201308)
Set the date—the last day of the month for which commissions are being paid.
Set PO# to yyyymm (example: 201308)
Set Description to “yyyy mmm Commission” (example: 2013 August Commission)
Set ordered & received to 1
Set amount to the Commission total from the excel spreadsheet. Double check to make sure it’s correct!
Set G/L to 23200
Set received date to last day of the month
Change the due date to the 20^th of the month after the commission (example: the August commission would have a due date of Sept. 20)
Go under “File”, “Save”

*Scan reports and attach to PO in documents folder!

Hit Ctrl-P to process the PO.
Close out.
Once all Salesman’s PO’s have been entered & processed, go under ‘Expenses’, ‘Vendor payments’ and select each salesman’s Commission to pay. Continue with printing the checks (refer back to the SOP on printing payments if unsure.)
After the checks have been printed for the commissions, Send them to each respective salesman with a copy of the spreadsheet. Make sure you stamp the check! Mail them out so they can be received on the 20^th or before.

QBO Info

Run report; copy over only invoice (and credit memo) lines. Save in Doc Library>JB Wagman Sales. When deleting, do not delete Rate, Freight & Pkg, and Commission columns.

LL 6-4-18