Report: Company Accounts Payable

The Company Accounts Payable report provides a register of company payables. All invoice activity that is open during the reporting date range is reported.

All invoice activity that is open during the report date range is reported.
All invoice activity that meets the report date range, but has been paid in full prior to this date range is not reported.
All invoice activity that meets the report date range, but is partially paid prior to or during the date range has all activity (billing/payment) reported.
All invoice activity that meets the report date range, and is paid in full during the date range is reported, because activity occurred during the selected date range.

The Company Accounts Payable report is also available as a Quick Report from the sidebar menu on the Customer Center.

Report Selections

When the report is accessed as a quick report, some settings are pre-filled on the selection form. The customer or company selected cannot be changed; the other settings can be changed, if desired.

Report Selections

What is this?

Report Date Range

Options	What is this?
From List	Use this option to select a pre-defined date range from the list. The default is All. All includes dates beyond the current system date.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From List option.

Additional Selections

Fields	What is this?
Customer	The default is (All), or you can search for and select a specific customer. When a specific customer is selected through the Search option, the Policy and Invoice options are enabled. Narrow the search by selecting a specific policy and invoice to review payments to a company for a single item. Customer Search is subject to your business unit security.
Division	The default is (All), or you can select a specific division.
Company Type	The default is All company types. This selection is disabled if a single customer is selected. You can choose: All Brokerage Company Fee Company Insurance Company
Company	The companies included in the list depend on the Company Type selected. This selection is disabled and blank if a single customer is selected.

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

Company beginning balance journal entries (BJE) entered at startup in AMS360 appear in the Company Accounts Payable report:

BJE is the Type.
The Agency Gross field will be 0.00.
The Net Payable will be the amount of the BJE.
The TotalPaid will be the amount of the BJE.

Report Fields	Description
Division/Company	This report sorts first by division and then by company. The Division/Company header is followed by report detail for that division/company combination.
Customer	The customer name (firm name, if available; if not, then last name, first name).
Policy/Description	Policy Number for an invoice, and Description for a check, receipt or journal entry transaction.
Type	Accounting Transaction Code.
Inv/Ref#	Invoice number, or a system reference number for a check, receipt or journal entry.
Check #	If payment was rendered by check, the number assigned to the check when printed. If the check is not printed, the check number is "unassigned".
EffDate	Invoice effective date.
GLDate	General ledger posting date.
PaidToCo	The amount paid to the company for an invoice via a check, receipt, or journal entry transaction.
AgencyGross	Gross premium/non-premium for the invoice. For Company BJE's (Beginning Balance Journal Entry), the AgencyGross will be 0.00.
NetPayable	Net premium/non-premium payable to the company for the invoice. For Company BJE's (Beginning Balance Journal Entry), the BJE amount prints in the NetPayable field.
Total Paid	Total of payments made to the company on the invoice.

CSV Columns

CSV Columns	Description
Division	General ledger division name.
Company	Company name.
Customer	Customer name
Policy	Policy number.
Description	Description of the transaction.
Type	Accounting Transaction Code.
InvNo	Invoice number.
Ref#	Reference number assigned to the source transaction (check, journal entry or receipt).
Check#	Check number, if applicable. If the check is not printed, the check number is "unassigned".
InvEffDate	Invoice effective date.
GLDate	Date transaction posted to the general ledger.
PaidToCo	The amount paid to the company for an invoice via a check, receipt, or journal entry transaction.
AgencyGross	Gross premium/non-premium for the invoice. For Company BJE's (Beginning Balance Journal Entry), the AgencyGross will be 0.
NetPayable	Net premium/non-premium payable to the company for the invoice. For Company BJE's (Beginning Balance Journal Entry), the BJE amount prints in the NetPayable field.
TotalPaid	Total of payments made to the company on the invoice.