Report: Commission Payable Statement

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. If you wish to email the report, you can create a report PDF file and attach it to an email.

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

The Commission Payable Statement is also available as a quick report from the Broker Center or Employee Center.

Report Selections

When the report is accessed from a Quick Reports menu, some selections are pre-filled by default. You can change default entries as needed.

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 Type is Employee. 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 Type broker 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 List option.

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.

Report Fields

Employee and broker beginning balance journal entries (BJE) entered at startup on AMS360 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 Commission check box 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

CSV Columns	Description
Division	Division Name
TemplateName	The name of the commission template on a policy.
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 Date used when building the commission payable statement.
IncPaidInFullToAgcy	Y/N When building the statement, was the "Include Invoices Paid in Full to the Agency" check box checked?
IncPartPdToAgcy	Y/N When building the statement, was the "Include Invoices Partially Paid to the Agency" check box checked?
IncUnPdToAgcy	Y/N When building the statement, was the "Include Invoices Unpaid to Agency" check box checked?
ProRateDef	Y/N When building statement, was the "Set Pay Amounts to Payable Balance with partially paid invoices set to a prorated amount..." check box checked?
IncPartUnPdToAgcy	Y/N When building the statement, was the "Include Invoices Partially Paid or Unpaid to the Agency" check box, checked?
IncPaidInFullToCo	Y/N When building the statement, was the "Include Invoices Paid in Full to the Company" check box, checked?
IncPartUnPdToCo	Y/N When building the statement, was the "Include Invoices Partially Paid or Unpaid to the Company" check box, checked?
IncDBFullRec	Y/N When building the statement, was the "Direct Bill Invoices Paid in Full to the Agency" check box, checked?
IncDBPartUnRec	Y/N When building the statement, was the "Direct Bill Invoices Not Paid in Full to the Agency" check box, checked?
IncBndrPaidInFullToAgcy	Y/N When building the statement, was the "Binders Paid in Full to the Agency" check box, checked?
IncBndrPartUnPdToAgcy	Y/N When building the statement, was the "Binders Partially Paid or Unpaid to the Agency" check box, 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.