Commission Statement

Selected from the Vendor or Representative forms’ <Reports> drop lists,  the vendor version of this report can be used to show what orders do not have invoices (open orders) and those that have invoices but no payment, or to reconcile a commission.  The representative’s commission statement shows the rep’s commissions split (share) of vendor payments made to the agency.

Sending a commission statement to a vendor can expedite payment or help to resolve a disputed amount. This report can also be used as an effective sales analysis tool based on report grouping, filtering, and sorting.  If for example, all the orders placed at a fall show are entered with an order type of 'Fall Show', the report can be grouped by Order Type; then, select 'Fall Show' as the filter to see a listing of orders placed at the show. Previously paid orders are excluded from the statement unless the Paid (VPaid for vendors or RPaid for reps) check box is checked.

To print a commissions statement:
1) Select "Commissions Statement" from the <Reports> list drop list on the vendor or rep forms
2) Remove the check mark from the <Detail> check box if you don't want a line entry for each order. If you do so, sorting and variances will be ignored.
3) Place a check in the <VPaid> check box for a vendor statement or the <RPaid> check box to include orders that have been previously paid by the vendor or to the rep respectively.
4) Change the percentage <Variances> value if you want to adjust the tolerance for flagging variance that exceed this amount. Changing this to 0% will disable flagging. Noting variances and their causes is one of the most valuable managerial decision making tools available.
5) Select which field you would like the report to be grouped by from the <Group By> drop list. The default is "Customer."
6) If the report is to be filtered to a value in the field you have chosen to group by, select it from the drop list immediately to the right of the <Group> control. Selecting "Status" or "Type" can be used to filter the report by values you have entered in these fields like 'Disputed' or 'Fall Show.'
7) Select a field to sort the report by from the <Sort> drop list and whether the report should be sorted in ascending or descending order. Sorting by ship date in descending order (default) will place the oldest orders at the top of the report.
8) Select a date range if you would like to restrict the report to a particular time period.
9) Preview and then print the report.

Vendor Commission Statement

All open orders and invoices that have not been paid are shown on the report by default.  The superscript footnote at the upper right of the anticipated amount shows what the basis for this amount is.  You can change the <Group> to "Status" and choose a status such as "Pending" for orders without invoices, or "Invoiced" for orders that have been invoiced but that you have not been paid for yet.  The screen at right shows the settings for a report that would show invoices and the anticipated amounts for invoices that payments have not been applied to.

Rep Commission Statement

The following formulas are used to calculate the total due to a rep.

For orders without a rep payment:
Sum (Vendor Payment x Share%) = Current Share Due

For previously paid orders with a RpmtNo:
Sum (Vendor Payment x Share%) – Rep Payment = Adjustments

Current Share Due + Adjustments = Total Due to Rep

Adjustments
Changes to payments applied for a vendor, rep payment changes, or the rep’s commission split (share), partial payments, and rounding errors contribute to adjustments. For example, an adjustment would be apparent when a rep is paid based on an initial, disputed, vendor payment and a later payment is received and added to the first.

Adjustments may be negative. If a rep’s commission share% were reduced after the rep’s payment had been posted to the order, a negative adjustment would be apparent. A rep commission statement for a date range that includes the order and RPaid (Rep Paid) is checked would show a negative balance for the commission due for that order and influence the Current Balance. If RPaid is not checked the adjustment’s influence may affect the prior balance. Adjustments are summed and their values are noted as current or prior adjustments at the bottom of the report.