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.
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.
Access this report by either of the following methods:
- Select an employee or broker in the Broker Center or Employee Center, then select the report from the Quick Reports menu in the sidebar for the appropriate center. (The report is not available unless and employee/broker is selected.)
- On the 360Toolbox menu, click Classic Reports to open Reports - All where you can make your selection..
Either method opens the Report - Commission Payable Statement selection form.
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 |
| ||||||||||||||
Statement Date Range |
| ||||||||||||||
Status | If you want to select only those statements with a specific status, select either:
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:
| ||||||||||||||
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. |
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 | |
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 | |
Rate | Employee/Broker Commission Rate. Then, the symbol to the right of the rate denotes the commission method.
|
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 | 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:
|
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 | |
Tran | |
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.
|
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 | |
InvType |
|
GL Post | The general ledger transaction posting date. |
Binder | Prints:
|
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. |