Commission Reports
Simple Accounting lets you print two types of reports to determine sales commissions for your representatives. These are both run from Main Menu by going to Sales & A/R, then selecting Commissions, then Reports.
The Commission Reports are similar to the Sales Summary and Transaction Detail reports available from the Sales Order Browse but are always subtotalled by Employee ID (and also, optionally by Customer ID.)
TipThe reports generate a page break after each representatives totals, making this in effect a series of individual reports; one for each rep.
The Summary Report lists one detail line for each invoice. Use this report if you pay commissions on a fixed percentage by customer or Employee ID.
The Detail Report lists each item (product) sold. Use this report if you pay commissions based on information entered on each sales order line item, such as Product ID, Product Type, or Vendor ID.
You determine which records are printed using the Query Window. The PROFIT, PROFIT PERCENTAGE and COMMISSION columns for each record are determined by your settings in Setup Sales Order Options.
Split Commissions (commissions shared between two salespeople are also calculated if you enter an EMPLOYEE ID #2 for your sales orders. The split is calculated depending on the COMMISSION CALCULATION METHOD you entered into Setup Sales Order Options. If you do have a split for an order, then you will see it appear on the report two times: once for each salesperson.
LOCKING AND UPDATING COMMISSIONS
When you print a commission report the amount listed may be calculated as the report is printed, or be read from the Sales Order itself. If the commission amount is calculated, you have the option to automatically store this value in the Sales Order, in effect locking that commission amount in place. This prevents the commission amount for the order from changing even if the order changes later on (due to extra costs for example).
The commission for each line on the report is only calculated if the Sales Orders commission is not locked. The commission amount for an order may be locked simply by running this report (as just described) or because you entered a Manual Commission Override . If the commission has been manually overridden, or was locked during a previous report run, then this is indicated in the rightmost column of the report as follows”
M Manual Override
A Automatic Calculation, locked in place.
By default, Simple Accounting does not include sales discounts in the commissionable portion of sales. (You can override this behavior globally in Security Extensions under the Custom Settings menu.)
This may not apply if you have custom-written reports installed.
To override this behavior for an individual Sales Order, you would need to override the commission on the affected order from the Sales Order Browse.
People or organizations owed royalties are listed on the commission report as any other salesperson due commission. Put another way, you should set up a separate Employee ID, for each commissionable entity; which means both sales people and vendors to whom you pay commissions. Commissions are calculated for royalty payments in exactly the same manner as other commissions.
However, royalty commissions should always be assigned to Employee ID #3 or Employee ID #4 on sales order. This is done by setting up a Commission Table which you then assign to each appropriate Sales Order.
At the Period Update, commissions (royalties) due each vendor are summarized and automatically posted as a single A/P Vendor Invoice with one line item for each commissionable invoice. Therefore, it is important to verify the correctness of these commissions before closing the month. If an incorrect commission was assigned to a vendor, you can, of course, edit the A/P Invoice to correct the royalty payment, however this will not reverse the sales commission.
Some Examples
Example #1: This example shows how to use the Filter Options Window to view sales commission information for only paid invoices for the current month. Save this query and you can re-use it every month.
1) Select A/R, then Comission Reports, then Summary from the Main Menu
2) Press the [Build New Query] button from the Query Browse.
3) In Criteria #1 of the filter section select Payment Date from the list box.
4) In Operator field, directly to the right, select M from the list box. (This means, everything in the current Month.)
5) Leave the Value field for Criteria #1 empty.
6) In Criteria #2, select Paid In Full from the list box. (We need this second criteria to ensure that were not selecting invoices for which only partial payments were received within the month.)
7) In Operator field, directly to the right, select = from the list box.
8) In the Value field, enter Y.
9) Press [Proceed].
10) The Save A New Query Window appears. In the Description field, type Paid Invoices For The Current Month.
11) Press the [Save] button.
12) From the Query Browse, press the [Select Saved Query] button to run the report.
Since you have saved this query, you can go directly to step #12, next time to run a report of invoices paid within the current month, whenever you like!
For a Fixed Range of Dates: If you need to view invoices for a range of dates, you can create another query and enter this range of Payment Dates in the Filter Options Window. Since the range will change every month, you can run the query without saving it.
