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.

Report Image

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

Access this report by either of the following methods:

  • Select the report from the Quick Reports menu in the sidebar on the Customer Center or Company Center. The Company Accounts Payable report opens.
  • On the 360Toolbox menu, click Classic Reports to open Reports - All where you can make your selection.

Either method opens the Report Selections form.

 

  • From the Company Center, the quick report provides a means of quickly accessing open payable items for the selected company.
  • From the Customer Center, the quick report provides a means of quickly accessing open payable items for a selected customer or customer and policy.
  • The Company Accounts Payable report could function as an open payable report, rather than gathering all of the items on account currents.

 

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 SelectionsWhat is this?

Report Date Range

OptionsWhat 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

FieldsWhat 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.

 

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 FieldsDescription

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 ColumnsDescription

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.

Related Topics Link IconRelated Topics