Figuring New Monthly Sales & Commissions

This will typically be done by the person who runs payroll for us.

Note: This calculation of sales commission is based on ACTUAL CASH that’s come in this month and NOT on sales revenue that was sold.

1) Get the PayPal Sales Total

- Log into Paypal > Activity > All Reports > Reports

- Click the date range > Change the dates to the previous month > Submit

 - Document the sales total (this net sales total is the gross sales minus refunds) and put it in the Sales Spreadsheet under the Overall Tab and under the correct cells under Salesman Commissions

2) Get the Square Sales Amount  

- Log into Square > Reports > Team Sales

- Click the date range > Change the dates to the previous month

- Subtract the Installments from the Team Member Sales Total to find the Net Net New Total (this total is the gross sales minus refunds and installments)

-Next, go to Transactions page on Square > Set the date range > Change types to refunds > Figure out which refunds came from which team member

-Take total sales for that team member and subtract the refunds that belong to them

 - Document the sales total (this net sales total is the gross sales minus refunds) and put it in the Sales Spreadsheet under the Overall Tab and under the correct cells under Salesman Commissions

3) Figure Their Commissions for the Payroll Run

Subtract the Eval Pro’s sales quota from his sales total, then multiply the remainder (if any) by his commission percentage. For example, if his quota is $50,000 and he sells $70,000 then the math would look like this:

$50,000 - $70,000 = $20,000 x 10% = $2,000 sales commission.

4) Email These Totals for Later Documentation Purposes

- Since these numbers can be easily changed by anyone or accidentally erased, AND since we need to report to the management team the final tallies, AND since the Eval Pro will need to request his payroll, we need to send these numbers to the COO, City/Regional Manager & the Eval Pro’s.