Report: General Ledger

The General Ledger report is a listing of general ledger transaction detail and account balances for a selected date range. It can be used to audit posting activity for a particular account or to provide detail in support of the agency's financial statements.

If you run this report with detail for all general ledger accounts, you may note a performance degradation Since accounting data is not purged in AMS360, account details for auditing purposes can be obtained at any time.

Report Image

  1. On the 360Toolbox menu, click Classic Reports to open Reports - All where you can make your selection.

  2. Click General Ledger Report to preview the report, and print if desired.

     

Report SelectionsWhat is this?

Date Range

OptionsWhat is this?

From List

Use this option to select a pre-defined date range from the list. This is the default.

Select Dates

Use this option to type in a specific date range not covered by the choices in the From List options.

Account Numbers/Sub-ledgers

Group/FieldWhat is this?

Numbers

Defaults to (All). Other options are:

OptionWhat is this?

Balance Sheet Accounts

10000000 to 39999000.

Income & Expense Accounts

40000000 to 99999000

Range of Accounts

Choose this option and select a range of account numbers in the Beginning and Ending account fields.

Specific Account Number

Select an account number from the Specific Number field.

Specific Number

This field becomes available when the Numbers field above = Specific Account Number.

Select the general ledger number.

Subledgers

This field becomes available when the Numbers field above = Specific Account Number.

Select All or a Specific subledger. Depending on the specific sub-ledger selected, the following fields appear:

SubledgerWhat is this?

Broker

This field is only available when the Subledgers field above = Specific Broker. Select the appropriate broker from the list.

Company

This field is available when the Subledgers field equals:

Specific Brokerage

Specific Fee Company

Specific Finance Company

Specific Insurance Company

Select the appropriate brokerage, fee, finance or insurance company from the list.

Customer

This field is only available when the Subledger field = Specific Customer.

Search for the appropriate customer.

Employee

This field is only available when the Subledger field = Specific Employee. Select the appropriate employee from the list.

To report subledger detail for a specific employee, the general ledger account must be set to subledger by commissioned person before transactions are posted. See Workflow: Analyze General Ledger Activity - Commissioned Person or Vendor for more information.

Vendor

This field is only available when the Subledger field = Specific Vendor. Select the appropriate vendor from the list.

To report subledger detail for a specific vendor, the general ledger account must be set to subledger by vendor before transactions are posted. See Workflow: Analyze General Ledger Activity - Commissioned Person or Vendor for more information.

Beginning and Ending

These fields are only available when the Numbers field = Range of Accounts. Select the desired Beginning and Ending account numbers from the lists.

Business Unit

Click the link to open the Business Unit Selections form and make your selections.

Format

The available formatting choices are:

  • Sub-ledger Detail
  • Summarize by Account
  • Summarize by Sub-ledger

Printing a report with Sub-ledger detail for certain accounts, such as #11211000000-AR Agency Business or #21111000-Accounts Payable to Insurance Companies, can return a large amount of detail. You may want to Print Preview such reports to ensure the desired data is displaying before selecting Print.

Sort Order

Select the appropriate sort order for your report. The available options are dependent on your Business Unit Setup.

Include Unreplaced Binder Information

Check this box to include information for unreplaced binder activity. This option defaults as unchecked.

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:

  1. Mark the Prompt check box.
  2. Enter the reminder message in the Selections to Verify text box, for example, "Check Date Range Selection."
  3. 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 certain selections need to be verified before you run the report. Open the report selections and modify as necessary. Then, run the report.

Selections to Verify

 

Given the number of selection options and formats available for this report, a comprehensive listing of fields output in every report situation would be extensive. We suggest you use Print Preview as an output option to view various selection and format combinations on screen, prior to printing needed reports.

Once options and formats are decided upon, review the Adding, Editing, and Deleting Reports section of the Reports - All topic for information on saving desired formats for future use.

When you enter company, employee and broker beginning balance journal entries (BJE) when moving to AMS360, the items now appear in the General Ledger report under Company, Employee, and Broker accounts.

 

If accounts with zero balances are printing on your General Ledger and you don't want them to, check your settings in the Chart of Account setup for the account that is printing with a zero balance.

  • If the option Print zero balance is checked, then the account will print on the report even when it has a zero balance.
  • If the option Print zero balance is not checked, the account will not print if the account balance is zero and no activity occurred during date range selected bringing it to zero.

 

CSV ColumnsDescription

Account#

General ledger account number.

AccountName

General ledger account name.

Division

Division name.

Branch

Branch name.

Department

Department name.

Group

Group name.

SubledgerType

Internal subledger code that translates to the SubledgerName below.

Subledger TypeWhat is this?

NOSUB

When there is no subledger.

SCUST

When the subledger is a customer.

SEMP

When the subledger is an employee.

SINCO

When the subledger is an insurance company.

SBRCO

When the subledger is a brokerage company.

SFECO

When the subledger is a fee company.

SFICO

When the subledger is a finance company.

SBROK

When the subledger is a broker.

SVEND

When the subledger is a vendor.

SubledgerName

Translates SubledgerType to report the specific subledger name.

Subledger NameWhat is this?

NOSUB

Field is blank.

SCUST

Translates to specific customer.

SEMP

Translates to specific employee.

SINCO

Translates to specific insurance company.

SBRCO

Translates to specific brokerage company.

SFECO

Translates to specific fee company.

SFICO

Translates to specific finance company.

SBROK

Translates to specific broker.

SVEND

Translates to specific vendor.

Summary

Reports Y (Yes) if format is Summarize by subledger or Summarize by account. If the format is Subledger Detail, then N (No) reports.

GLDate

General ledger transaction date.

Description

General ledger transaction description.

BegBalance

Beginning balance of the account/subledger at the selected report beginning date.

Debit

Debit amount.

Credit

Credit amount.

FiscalPeriod

Fiscal period (e.g., January, March, May).

FiscalYear

Fiscal year (e.g. 2016, 2017)

SourceTran

Internal source code for the transaction.

Type

Source Type can be:

  • JE
  • Billing
  • Check
  • Receipt

SourceRefno

Reference number for checks, receipts and journal entries.

Customer

Customer name.

Cust#

Customer account number.

Policy

Policy number.

Invoice

Invoice number.

Payee

Payee name.

Check#

Assigned check number, if a posted/printed check; otherwise, blank. (If the check has not been printed yet, the check number is unassigned.)

Related Topics Link IconRelated Topics