Difference between revisions of "Report: GL Inquiry"
(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 ''' | + | 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.
Contents
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 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.
| 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
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.
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.
