Report: Subsidiary Aged Ledger

The Subsidiary Ledger Report provides an aged itemized list of entries for certain AMS360system accounts by subledger.

The primary difference between this report and the Subsidiary Ledger report is that this report displays data sorted into aging 'buckets' based on the Receivable Aging Categories settings in Agency Setup > Accounting Options.

Report Selections

What is this?

Reporting End Date

Options	What is this?
From List	Use this option to select a pre-defined end date from the list. The default is Through Current Date.
Select Date	Use this option to type in a specific end date not covered by the choices in the From List option.

Account Numbers/Sub-ledgers

Field

What is this?

Numbers

The default is (All) or you may select a specific or multiple general ledger account numbers.

Sub-ledgers

The default is (All) or select a specific subledger type from the list.

This option is available only when a single general ledger number is selected.

Broker
Company
Employee

Depending on the specific subledger entity selected in the Sub-ledgers field, the corresponding field label appears. Select the appropriate entity from the list to further narrow the reported data.

Field Label	Subledger
Broker	Specific Broker
Employee	Specific Employee
Company	Specific Brokerage Company Specific Fee Company Specific Finance Company Specific Insurance Company

Customer

This field only becomes available if Specific Customer is selected as the sub-ledger for selected general ledger accounts, and where the subledger by customer has available data.

Example

Selecting Specific Account Number = #11212000 (AR-Agency Business), then selecting Specific Customer as the Sub-ledger type opens the Customer field where you may Search for and select a specific customer.

Division

The default is (All) or you may select a specific or multiple divisions.

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.

Prompt

To set a report reminder that certain selections need to be changed before the report is run, do the following:

Mark the Prompt check box.
Enter the reminder message in the Selections to Verify text box, for example "Check selected Customer b/4 running report."
Save and close the report.

The next time you attempt to print, print preview or create a CSV file for this report, you will get a reminder message that particular selections need to be checked before the report can be run. Open the report selections and modify as necessary. Then, run the report.

Report Fields

There are a few output formats for this report based on the system account selected. Each type of report contains a combination of the fields listed below. Not all fields are used in any one report.

Report Fields	What is this?
Customer	Customer last name, first name, or firm name if it exists.
TranDate	Transaction date.
Tran	Accounting transaction code.
Ref#	Source reference number.
Policy	Policy number.
Inv#	Invoice number.
Aging Categories	The aging categories are based on the Receivable Aging Categories setup in the Accounting Options section of Agency Setup. The age of each invoice is based on the later of the invoice date or the invoice effective date, relative to the As Of date.
GL Balance	Total general ledger balance for this invoice, for the selected general ledger account.
GL Cust Balance	General ledger balance for the selected customer. This data is available in reports using Direct Bill Deposit(GL #21121000, 21122000, and 21125000) accounts only.

CSV Columns

CSV Columns	Description
Division	Division name.
Department	Department name.
Acct#	General ledger account number.
AccountName	General ledger account name.
Subledger	Name of general ledger subledger entity.
CustLastName	Customer last name.
CustFirstName	Customer first name.
CustMidName	Customer middle name.
PolicyNo	Policy number.
ChargeType	Charge type description.
Inv#	Invoice number.
InvDate	Invoice date.
InvEffDate	Invoice effective date.
CompanyGross	Total company gross billed amounts for the invoice.
Prem/NonPrem	Total of premium/non-premium amounts for the invoice.
AgencyComm	Total agency commission for the invoice.
NetPayable	Total net company payable for the invoice.
P/BComm	Total producer/broker commissions for the invoice.
GLBalance	Total general ledger balance for this invoice, for the selected general ledger account.
TranDate	Transaction date.
Tran	Accounting transaction code.
Ref#	Source reference number.
Description	Transaction description.
Amount	Debit or credit amount. This data is available in reports using Direct Bill Deposit (GL #21121000, 21122000, and 21125000) accounts only.
GLCustBalance	General ledger balance for the selected customer. This data is available in reports using Direct Bill Deposit (GL #21121000, 21122000, and 21125000) accounts only.
ReceivableBal	Account balance for invoice/company. This data is available in reports for Deferred Income accounts only.
Age	In days old, the age of the Receivable Balance based on the later of the Invoice Date or Invoice Effective Date.