Report: Direct Bill Entry Statement
This report displays the transactions enter on the selected Direct Bill Entry Statement(s).
Access this report in one of two ways:
- Select from Quick Reports in the Company Center sidebar.
- On the 360Toolbox menu, click Classic Reports to open Reports - All where you can make your selection.
The table below gives you an explanation/definitions for the fields in the Direct Bill Entry selection form.
Fields/Options | What is this? | ||||||
---|---|---|---|---|---|---|---|
Company Type | Select the Company Type for your report. The default is All. Your choices are:
| ||||||
Company | The Company list fills based on your Company Type selection. Select one or all companies you wish to report on. | ||||||
Division | Select one or all divisions you want to report on. This field is always available. The default is All. Divisions in the list are subject to the users security. | ||||||
Refresh | Refreshes the statements available in the Statement list, based on your Insurance and Division selections above. | ||||||
Statement | Choosing a specific statement is only available if you select to report on one Insurance or one Brokerage company. It is necessary to click refresh after making your insurance/brokerage company and division choices. | ||||||
Statement Date Range |
| ||||||
Status | Select the Status of the statement(s) you wish to report on. Your choices are:
| ||||||
Primary Sort | Select the Primary Sort for your report (e.g., Customer). Then, choose the Secondary Sort for your report (e.g., Policy number). Your data is sorted by customer. Within customer, the data sorts by policy number. | ||||||
Secondary Sort | |||||||
Override Transactions Only | To use this report as an audit report check this box to include only those transactions where the Direct Bill Entry Statement defaults were overridden/changed.
| ||||||
Include Statement Adjustments | Check this box to include only those transactions where an adjustment was made outside the Direct Bill Entry Statement process.
| ||||||
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. |
The table below gives an explanation/definition for all of the totals on the Direct Bill Entry Statement.
Report Totals | What is this? | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Company Statement Amount | This is the total premium and non-premium amount specified on the company generated commission statement. | ||||||||||
Agency Statement Amount | This is the total agency premium and non-premium amount entered on the Direct Bill Entry form. This should eventually equal the Company Statement Amount. | ||||||||||
Difference | This is the difference between the Company Statement Amount and the Agency Statement Amount. This total should be 0.00 before the statement is posted. | ||||||||||
Company Statement Commission | This is the total agency commission amount specified on the company generated commission statement. | ||||||||||
Agency Statement Commission | This is the total agency commission entered on the Direct Bill Entry form. This should eventually equal the Company Statement Commission. | ||||||||||
Difference | This is the difference between the Company Statement Commission and the Agency Statement Commission. This total should be 0.00 before the statement is posted. | ||||||||||
Commission Received By Income Group | As you enter direct bill entry transactions, the transaction is assigned to an income group based on the policy LOB. All of the individual income group totals should balance to the Agency Statement Commission total because these totals all accumulate as you enter transactions.
|
The table below gives an explanation/definition for all of the detail on the Direct Bill Entry Statement.
Report Fields | What is this? |
---|---|
Name | This is the name of the customer, firm name and/or last name, first name for the direct bill entry transaction. |
Policy/BU | Policy The top line specifies the Policy Number on the direct bill entry transaction. BU Immediately below the policy number are the short names of the activated business unit(s) for this transaction. The Division (reported in header) and Department are required. Branch and Group are optional setups in Business Unit Setup.
|
Writ | The writing company on the direct bill entry transaction. |
EffDate | This is the transaction effective date on the direct bill entry transaction. |
LOB/Chg | The direct bill entry transaction reports the line of business for premium and the charge type for non-premium. |
Tran | This is the Tran (e.g., NBS, RWL) reported for the direct bill entry transaction. |
Class | This is the short name for the class of personnel assigned to the direct bill entry transaction.
|
ShortN | This is the short name of the personnel assigned to the direct bill entry transaction. |
Persn% | This is the commission rate for the personnel on the direct bill entry transaction. |
M'd | This is the commission method short name for each personnel on the direct bill entry transaction.
|
PersnComm | This is the commission amount for the personnel on the direct bill entry transaction. |
Agcy% | This is the agency commission rate for the direct bill entry transaction. |
AM'd | This is the commission method short name for the agency commission on the direct bill entry transaction.
|
AgcyComm | This is the agency commission amount on the direct bill entry transaction. |
Amount | This is the premium, fees, or taxes on the direct bill entry transaction. |
Ov'd | A Yes in this column indicates that a commission change/override was made to the agency commission for this direct bill entry transaction. A No indicates no changes were made. |
The table below gives you definitions/explanations for the columns in the Direct Bill Entry CSV file.
CSV Columns | What is this? |
---|---|
Company | This is the Parent Company name for the direct bill entry transaction. |
Division | This is the Division assigned to the direct bill entry transaction. |
StmtDate | This is the date entered into the Statement Date field in the Direct Bill Entry data entry form. You should enter the statement date from the company generated direct bill statement into this field. |
Status | This is the Status of the statement.
|
Description | This is the description of the statement, entered into the Description field on the Direct Bill Entry form. The object is to make this description meaningful so you can tell the difference between the AMS360 Direct Bill Entry Statements. |
GLDate | This is the date entered into the GL Date field in the Direct Bill Entry Statement, and the date that the statement posts to the general ledger. |
TotCoStmtAmt | This is the total premium and non-premium amount specified on the company generated commission statement. |
TotCoStmtAgCm | This is the total agency commission amount specified on the company generated commission statement. |
TotAgStmtAmt | This is the total agency premium and non-premium amount entered into the Direct Bill Entry form. This should eventually equal the TotCoStmtAmt. |
TotAgStmtAgCm | This is the total agency commission entered into the Direct Bill Entry form. This should eventually equal the TotCoStmtAgCm. |
Name | This is the Customer's firm name and/or last name, first name for the direct bill entry transaction. |
Policy | This is the policy number on the direct bill entry transaction. |
Deptname | This is the Department short name associated with the direct bill entry transaction. |
WritName | This is the Writing Company name on the direct bill entry transaction. |
TranEffDate | This is the Transaction Effective Date on the direct bill entry transaction. |
TranDesc | This is the transaction description, (e.g., NBS, RWL, PCH). |
LOB | This is the Line of Business on the direct bill entry transaction. |
Plan | This is the company Plan assigned to the direct bill entry transaction. |
TypeOfBus | Based on the line of business, this is the type of business on the direct bill entry transaction. The options are:
|
IncomeGroup | This is the Income Group assigned to the direct bill entry transaction. As you enter the transactions onto the statement, based on the Line of Business, the transactions are assigned an Income Group.
|
PolEffDate | This is the Policy effective date of the policy, on the direct bill entry transaction. |
PolExpDate | This is the Policy expiration date of the policy, on the direct bill entry transaction. |
Agcy% | This is the agency commission percent on the direct bill entry transaction. |
AM'd | This is the agency commission method used on the direct bill entry transaction. |
AgcyComm | This is the agency commission amount for the direct bill entry transaction. |
Amount | This is the total premium or non-premium for the direct bill entry transaction. |
Ov'd | A Yes in this column indicates that a commission change/override was made to the agency commission for this direct bill entry transaction. A No indicates no changes were made to the agency commission for this direct bill entry transaction. |
Branch | If business unit Branch was activated in Business Unit Setup, this is the Branch assigned to the direct bill entry transaction. Otherwise, this field is blank. |
Group | If business unit Group was activated in Business Unit Setup, this is the Group assigned to the direct bill entry transaction. Otherwise, this field is blank. |
Polid | The Polid is an internal code representing the Policy # for this direct bill entry transaction. |