Difference between revisions of "Report: GL Inquiry"

From Agency Systems Wiki
Jump to navigation Jump to search
(Created page with "Category:ReportsCategory:Month-End <table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-heig...")
 
(updated how to access only)
 
(2 intermediate revisions by 2 users not shown)
Line 36: Line 36:
  
 
== Access and Security Options ==
 
== Access and Security Options ==
The general ledger inquiry can be opened by selecting '''G/L -> General Leger Inquiry'''.  ''(Additionally, the report is available as an [[Automatic Reports|automatic monthly report]])''
+
The general ledger inquiry can be opened by selecting '''Reports -> General Ledger Inquiry'''.  ''(Additionally, the report is available as an [[Automatic Reports|automatic monthly report]])''
  
 
Access to the general ledger inquiry report is controlled through the [[Security System| security system]] '''G/L -> General Ledger Inquiry -> View''' setting.
 
Access to the general ledger inquiry report is controlled through the [[Security System| security system]] '''G/L -> General Ledger Inquiry -> View''' setting.
Line 89: Line 89:
 
The overrides will ignore the General Ledger profile settings, and use the selected options for the report instead.   
 
The overrides will ignore the General Ledger profile settings, and use the selected options for the report instead.   
  
Invoice GLs (1120, 1130 ,2110 ,2120 etc.) '''never provide full details''' unless [[Help:Contents|also enabled by Agency Systems Customer Support]].
+
Invoice GLs (1120, 1130, 2110, 2120 etc.) '''never provide full details''' unless [[Help:Contents|also enabled by Agency Systems Customer Support]].

Latest revision as of 18:21, 6 March 2019

Related Pages
Related Categories

The General Ledger Inquiry (GL Inquiry) is one of the financial statements for an agency that lists the balances at the beginning of the month, all activity during the month, and the balance at the end of the month for all General Ledger accounts.

The amount of detail provided for each individual account is determined by the GL Inquiry report options within the General Ledger Profile.

See automatic monthly reports for additional month-end reporting options.

Access and Security Options

The general ledger inquiry can be opened by selecting Reports -> General Ledger Inquiry. (Additionally, the report is available as an automatic monthly report)

Access to the general ledger inquiry report is controlled through the security system G/L -> General Ledger Inquiry -> View setting.

Report-gli-defaultoptions.png

Report Window Options

Department

The report can be run for one department, or all departments. To include all departments, remove the selected department filter by pressing the <delete> key.

Start Date and End Date

The G/L date range for the report. The start date determines the starting balance for each G/L account. All activity during the period is included with detail based on the GL Inquiry report options within the General Ledger Profile.

Start G/L and End G/L

By default, all general ledger accounts are included. To limit the report to a specific account range based on G/L type, enter the starting and ending values.

Guide for General Ledger Account Types
G/L Type G/L Code G/L Settings
Asset 1100 - 1999 Current, Fixed, Other
Liability 2000 - 2299 Current, Long-Term, Other
Capital 2300 - 2999 No Sub-Types
Income 4100 - 4999 Operating, Miscellaneous
Expense 5000 - 6999 Administrative, Sales, Other

Bank

Only available if the Start G/L and End G/L are both configured to GL 1100 - Cash In Bank. Enter a bank code to limit the report to a specific account.

Override Options

General Ledger Profile

By default, the detail levels are based on the GL Inquiry report options within the General Ledger Profile. Detail override options can optionally be enabled by Agency Systems Customer Support. If the overrides are enabled, the Totals Type and SubTotals Type for each General Ledger account can be modified on-the-fly.

Report-gli-alloptions.png

The overrides will ignore the General Ledger profile settings, and use the selected options for the report instead.

Invoice GLs (1120, 1130, 2110, 2120 etc.) never provide full details unless also enabled by Agency Systems Customer Support.