Report: Commission Payable Statement

This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package.

Use this report to manage and report commission amounts due to your employees and/or brokers. The employee/broker name, address, business phone and email address are included on the report.

In addition, you can sort the information on this report by customer name (default), policy number, or bill method.

Before you can print a Commission Payable Statement, you must generate it first. For more information on creating commission payable statements, see Pay Commissions - Statement Modifiers.

This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox>Reports takes you to the Reports - All list, where you can make your selection.

Click Commission Payable Statement. This opens the Report - Commission Payable Statement selection form. Make your selections, pull down the File menu and select to:

Print
Print Preview
Create CSV to export the report to the program of your choice.
Preview Cover Page

Report Selections

What is this?

Statement Person/Division

Fields	What is this?
Commission Person Type	Select All (default) to include commission payable statements for the commission person types listed below: Employee Broker When All is selected, the Employee, Broker, and Statement fields are disabled.
Employee	This field is enabled only when the Commission Person TypeisEmployee. Select the employee you want to run the commission statement for.
Broker	This field is enabled only when the Commission Person Type is Broker. Select the broker you want to run the commission statement for.
Division	Choose One or All (default) divisions. The divisions appearing in the list are subject to division security. If the user has access to any of the departments in the division, then they have access to all of the commission payable statements in that division. If All divisions are selected for printing, the report only includes commission payable statements belonging to divisions for which the user has security rights.
Statement	Statement Selection You can select a specific statement or All statements. The Statement combo is disabled when the Commission Person Type = All. Select the Commission Person Typebroker or employee. Select a specific employee or broker from the appropriate list. The Refresh button is enabled. Click Refresh to fill the Statement combo with only those statements belonging to the selected employee/broker and divisions. Sort Order The statements in the list are sorted by Statement Date (oldest to newest), then by Division, then by Payment Status (In Progress, Paid and Posted, Ready to Pay), and then by Description.

Statement Date Range

Options	What is this?
From List	Use this option to select a pre-defined date range from the list. The default is Current Date.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From Listoption.

Status

If you want to select only those statements with a specific status, select either:

In Progress
Paid and Posted (default)
Ready to Pay
Voided

This field is disabled and blank if a specific statement is selected.

Show Agency Commission

This box defaults as checked meaning that agency commissions appear on the report. Uncheck this box to suppress the agency commission report column.

Totals Only

Check this box to report statement totals only, without invoice-level detail.

Include Invoices with 0.00 Pay Amounts

Check this box to report invoices for which no Pay Amounts are entered.

Use this feature to report all invoices included in the statement build, even if no Pay Amount is entered for the invoice. This is helpful when running a report for an In Progress statement to determine if additional invoices should be paid to the employee.

Filter Offsetting Items

Check this box to hide rows for backed out invoices and their corresponding offsetting rows.

Sort Order

This field gives you the opportunity to re-sort the commission payable statement detail before printing, by:

Customer Name (default)
Policy Number
Bill Method

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

As of v2.0, when we allowed employee and broker beginning balance journal entries (BJE) to be entered at startup on AMS 360, they now appear on the Commission Statement report:

The LOB/Chg and Tran fields will be blank.
The Agency Gross and Agency Comm fields will be 0.00.
The Rate has no percentage amount.
The Net Payable will be the amount of the BJE.

Report Fields	Description
Insured Name	The name of the insured.
Policy	The policy number.
Bill	The Accounting Transaction Code.
A/R	Indicates whether or not the invoice has an open accounts receivable balance.
Inv#	The invoice number.
Eff Date	The invoice effective date.
LOB/Chg	The line of business code for premium or the charge type code for non-premium.
Tran	The Policy Transaction Code.
Rate	Employee/Broker Commission Rate. Then, the symbol to the right of the rate denotes the commission method. A = % of Agency P = % of Premium/Non-Premium F = Flat Rate
Agency Gross	This is the gross premium or charge amount.
Agency Comm	This is the agency commission dollar amount. This column on the commission statement can be suppressed if the Show Agency Commissioncheckbox on the selection form is unchecked.
Net Payable	This is the net commission amount payable to the employee/broker.
Payable Bal	This is the commission payable less any previously paid amounts.
Pay Amount	The current payment amount.

CSV Columns	Description
Division	Division Name
PersonType	Employee or Broker
PersonName	The name of the employee/broker.
StatementDate	Statement Date
Description	Statement Description
Status	Status of the statement: In Progress Paid and Posted Ready to Pay Voided
ThruDate	This is the Through Dateused when building the commission payable statement.
IncPaidInFullToAgcy	Y/N When building the statement, was the "Include Invoices Paid in Full to the Agency" checkbox checked?
IncPartPdToAgcy	Y/N When building the statement, was the "Include Invoices Partially Paid to the Agency" checkbox checked?
IncUnPdToAgcy	Y/N When building the statement, was the "Include Invoices Unpaid to Agency" checkbox checked?
ProRateDef	Y/N When building statement, was the "Set Pay Amounts to Payable Balance with partially paid invoices set to a prorated amount..." checkbox checked?
IncPartUnPdToAgcy	Y/N When building the statement, was the "Include Invoices Partially Paid or Unpaid to the Agency" checkbox, checked?
IncPaidInFullToCo	Y/N When building the statement, was the "Include Invoices Paid in Full to the Company" checkbox, checked?
IncPartUnPdToCo	Y/N When building the statement, was the "Include Invoices Partially Paid or Unpaid to the Company" checkbox, checked?
IncDBFullRec	Y/N When building the statement, was the "Direct Bill Invoices Paid in Full to the Agency" checkbox, checked?
IncDBPartUnRec	Y/N When building the statement, was the "Direct Bill Invoices Not Paid in Full to the Agency" checkbox, checked?
IncBndrPaidInFullToAgcy	Y/N When building the statement, was the "Binders Paid in Full to the Agency" checkbox, checked?
IncBndrPartUnPdToAgcy	Y/N When building the statement, was the "Binders Partially Paid or Unpaid to the Agency" checkbox, checked?
StmtAgcyGross	Total gross premium, and charge amounts for the commission payable statement.
StmtAgcyComm	Total agency commission for the commission payable statement.
StmtComm	Total employee/broker commission for the commission payable statement.
StmtPayBal	Total payable balance due the employee/broker (total commission due, less previous payments) on all invoices included in the commission statement.
StmtPayAmt	Total amount paid on the commission payable statement.
Insured	Customer Firm Name, or Last Name/First Name.
PolNo	Policy Number
Writing Company	The writing company name.
EffDate	Invoice Effective Date.
Tran	Policy Transaction Code.
LOB/Chg-description	Line of business for premium or charge description for non-premium transactions.
LOB/Chg-Short Name	The short name for the line of business for premium, or the short name of the charge description for non-premium transactions.
Plan	Company plan.
Agency Gross	Gross premium or charge amount.
Agency Comm	The agency commission amount.
P/B Comm Method	Commission method used to pay the employee/broker. A = % of agency P = % of premium/non-premium F = Flat rate
P/B Comm Rate	Commission rate for the employee/broker.
P/B Comm	Dollar amount of commission for the employee/broker.
P/B Payable Bal	Net amount of commission due the executive/broker less previous payments, if any.
P/B Pay Amount	Amount of commission to the employee/broker on this statement.
InvNo	Invoice number.
InvDate	Invoice Date.
InvType	1 = Agency Bill Invoices (ABI) 2 = Direct Bill Statement Invoices (DBI) 3 = Customer Service Direct Bill Invoices (CSI)
GL Post	The general ledger transaction posting date.
Binder	Prints: Binder - for an unreplaced binder. Replaced - for a replaced binder.
ARBal	Accounts receivable balance for the invoice.
APBal	Accounts payable balance for the invoice.
DBRecBal	Direct bill reconciliation balance. The balance is included only for DBI invoices, not ABI or CSI invoices.
Branch Name	Business unit branch name applicable to this transaction.
DeptName	Business unit department name applicable to this transaction.
GroupName	Business unit group name applicable to this transaction.

My Vertafore Support | Vertafore University | NetVU Network | Vertafore.com

© 2015 Vertafore, Inc. and its subsidiaries. All Rights Reserved. Vertafore, the Vertafore design, AMS360, Vertafore Producer Advantage, Producer Plus, AgencyEDGE, ReferenceConnect, BenefitPoint, Engage, and WorkSmart are registered trademarks of Vertafore, Inc. or its subsidiaries. Third party marks belong to their respective holders. AMS360 Classic Help updated 5/18/2016 11:01 PM