This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package. |
The Open Invoices by Company report provides information about invoices that still have a receivable balance, for each company selected by the user. You can use this report as a collection tool because it includes the customer’s name, telephone number, customer balance and information about how old the balance is.
Based on your knowledge of the company, you can also evaluate when to notify your customer that a policy will be cancelled for non-payment. It also includes payment information when an invoice is partially paid to the company.
You can run the report with invoice-level detail or totals only, summarized by company.
Accessing the Open Invoices by Company Report
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 Open Invoices by Company. This opens the Report - Open Invoices by Company selection form. Make your selections, pull down the File menu and select to:
Print Preview
Create CSV to export the report to the program of your choice.
Preview Cover Page
Report Selections |
What is this? |
||||||||
Invoice Balances and Aging as of |
|
||||||||
Invoice Age |
The aging categories are defined in Agency Setup. The age basis for distribution in aging categories is later of invoice date/invoice effective date, relative to the report "as of" date.
|
||||||||
Credit Balance Invoices |
|
||||||||
Company Type |
Default selection is (All). Can also select a report for only Insurance companies or only Brokerage companies. |
||||||||
Company |
Default selection is (All) or reports for a specific company can be created. The companies identified in the list depend on the company type selected above. |
||||||||
Business Unit |
Click the link to open the Business Unit Selections form and make your selections. |
||||||||
Representative |
The default is (All) or you can print a report for a specific customer service representative. |
||||||||
Executive |
The default is (All) or you can print a report for a specific executive. |
||||||||
Sort Order |
Select a sort order for output. Choices include:
|
||||||||
Report Totals Only |
Selecting this option produces a report showing totals, divided into aging categories, summarized by company. Use this format of the report to help predict required future cash flows. |
||||||||
Print Cover Page |
Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked. |
||||||||
Description |
Accept the default description, or enter a new one that describes the report you are requesting. |
As of v2.0, when we allowed company beginning balance journal entries (BJE) to be entered at startup on AMS360, they now appear in the Open Invoices by Company report for the payable totals (Net Payable and Payable Balance).
Report Fields |
Description |
||||||||||||||||||||||||
Customer/Account Information Fields |
|
||||||||||||||||||||||||
Policy/Receivable Information Fields |
|
||||||||||||||||||||||||
Totals |
These totals are printed for each company and then report totals are printed for the sum of all companies at the end of the report.
|
CSV Columns |
Description |
CompanyType |
Type of company (Insurance, Brokerage, etc.). |
Company Name |
Name of the company. |
CustomerName |
Customer name (LastName, FirstName or Firm Name). |
AccountNo |
Customer account number. |
CustResPhone |
Customer residence telephone number. |
CustBusPhone |
Customer business telephone number. |
InvExec |
Executive on the invoice. |
InvRep |
Representative on the invoice. |
PolicyNo |
Policy number. |
Broker |
Broker on the policy, if applicable, otherwise blank. |
Invoice |
Invoice number. |
ME Suffix |
If invoice is multi-entity, then print invoice number suffix. |
Balance |
Invoice balance. |
InvAge |
# of days since invoice date. |
EffAge |
# of days since invoice effective date. |
GLAge |
# of days since general ledger posting date. |
LateCharge |
Amount of late charge on the invoice. |
InvLastPmtDate |
Date of last payment on the invoice. |
InvLastPmtAmt |
Amount of last payment on the invoice. |
AgencyGross |
Gross amount of the invoice. |
NetPayable |
Net amount of the invoice. |
PaidToCompany |
Amount already paid to the company on the invoice. |
PayableBalance |
Amount remaining due to the company on the invoice. |
EffDate |
Invoice effective date. |
GLDivision |
General ledger division on the invoice. |
GLDepartment |
General ledger department on the invoice. |
PolicyID |
Unique internal policy identifier. |
PolicyType |
Policy type (Monoline, Package, BOP). See the Report Fieldssection of this topic for more information. |
CustExec |
Executive assigned to the customer. |
CustRep |
Representative assigned to the customer. |
CustLastPmtDate |
Date of last payment from the customer. |
CustLastPmtAmt |
Amount of last payment from the customer. |
GLBranch |
General ledger branch on the invoice. |
GLGroup |
General ledger group on the invoice. |
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 10:58 PM |