Expanded General Ledger Reports

Access this report using Reports>General Ledger Analysis>Expanded General Ledger.

Use this report to print your general ledger. It contains opening balance and complete detail for any report range selected and for all account codes selected.

The Expanded General Ledger report displays each account segment in its own column. In addition, it allows you to select transaction information columns (such as Transaction Source or Transaction Description) that are not available on the Standard General Ledger.
Since the General Ledger is basic to your accounting records and is a must for auditors, you will want to print an archive copy each month after all adjustments are entered and posted of either the Standard General Ledger or the Expanded General Ledger (depending on the presentation style preferred).
This report also contains additional items, columns, and filters if any user defined fields were created by the Administrator. Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page. User defined fields with a field type of Currency follow the formatting of the organization's functional currency.

These are the System Default reports available for Comparative Trial Balance:

Expanded General Ledger - This Month
Expanded General Ledger - This Year
Fiscal Year Opening Balances in Detail
GL Transaction Detail Subtotaled by Month

Note: Additional Expanded General Ledger reports may be available depending on your MIP implementation.

Setup

Use this tab to assign:

Balance Dates
Current Transaction Dates
Report Groups
Columns
Items by Page (Page Breaks)

Balance Dates

The Balance Dates for the report display.

See Report Builder Setup Tab for more information on adjusting Balance Dates.

Current Transaction Dates

The Current Transaction Dates for the report display.

See Report Builder Setup Tab for more information on adjusting Current Transaction Dates.

Report Groups

Selecting a Report Group in Columns, Items by Page (Page Breaks), or Filter displays the Select\Edit Group Code dialog box.

See Report Builder Setup Tab for more information on working with Report Groups.

Columns

The current column configuration for the reports displays.

See Report Builder Setup Tab for more information on adjusting report columns.

These are the available columns with their descriptions for Expanded General Ledger reports.

Note: Fewer or additional report columns may be available depending on your MIP implementation.

Column	Description
{Segment Name} Code	The code assigned to the segment. The report prints the account code, such as 201, 05, or 45001. The system displays one column for each of these code types, such as Fund Code or GL Code.
{Segment Name} Title	The title associated with each code above. The system displays one column for each of these code types, such as Fund Title or GL Title.
{Segment Name} Short Title	The short title for the title above (15 characters or less). The system displays one column for each code types, such as Fund Short Title.
{Segment Name} Group Code	The group code assigned to the segment. The report prints a column for each group code, such as Fund Group Code.
{Segment Name} Group Title	The title associated with the group code above. The report prints one column for each group segment.
{Segment Name} Group Short Title	The short title for the group title above (15 characters or less). The report shows one column for each group segment, such as Fund Group Short Title.
Transaction Source	The document's transaction type, such as APC, API, APM, APR, APS, APV, ARB, ARC, ARM, ARP, ARR, ARS, ARV, BD, BDH, CD, CDS, CR, CRS, CL, CSR, ENC, ENH, ENL, IAR, IAA, IVR, IAM, IAS, IAF, IAC, IAB, JV, JVA, JVD, JVH, PRC, PRS, PRV, or VCK.
Session ID	The Session ID assigned to the batch of documents.
Session Date	The date of the session.
Session Description	The description for the session above.
Document Number	The document number that was entered on the transaction entry form.
Document Date	The date of the document.
Due Date	The invoice date specified on the Transactions>AP Invoices or AR Invoices transaction entry forms.
Document Description	The description of the document.
Reversed Invoice	A designation of Yes or No, determining whether the AP invoice/credit has been automatically reversed in the system using the Reverse Session Form.
Reversed Invoice Date	If the Accounts Payable module is installed, the date the invoice was reversed during transaction entry using the Reverse Session Form.
Deposit Number	The deposit number from the cash receipt, if applicable.
Document Amount	For functional currency, the document amount entered during transaction entry, such as the check or invoice amount. For non-functional currency, the Source Document Amount times the Exchange Rate.
Source Document Amount	For non-functional currency, the document amount entered during transaction entry.
Matching Document Number	The number assigned to the related document.
ID	If the Accounts Payable, Accounts Receivable Reporting, or Payroll modules are installed, this is the Vendor ID, Customer ID, or Employee ID assigned.
Name	The name on checks. If the Accounts Payable or Accounts Receivable Reporting modules are installed, this information was set up using the Maintenance>Vendors or Customers forms.
Payment Type	The payment type associated with the document—either Check or Voucher.
Source	A source of Customer, Vendor, Employee, or Payroll Processing Group. The report shows C, V, E, or P.
Effective Date	The line item's effective date.
Entry Type	The entry type chosen during transaction entry—Normal, End of Year Adjustment, Adjust Opening Balances, or Beginning Balance. The system prints an N, A, AO, or UO. For opening balances in Detail, the system prints System Opening Balances (SO).
Transaction Description	The description entered for the transaction line item.
Posted	Yes or No displays in this column depending on if the detail transaction was posted or unposted.
Debit	For functional currency, the debit amount entered during transaction entry. For non-functional currency, the Source Debit times the Exchange Rate.
Credit	For functional currency, the debit amount entered during transaction entry. For non-functional currency, the Source Credit times the Exchange Rate.
Exchange Rate	The exchange rate associated with the transaction. Exchange rates were entered using the Maintain>Multicurrency>Exchange Rates form. This is only used with non-functional currency sessions.
Source Debit	The debit amount entered during transaction entry.
Source Credit	The credit amount entered during transaction entry.
Invoice Debit	The invoice debit amount used in Accounts Payable or Accounts Receivable transaction lines.
Invoice Credit	The invoice credit amount used in Accounts Payable or Accounts Receivable transaction lines.
Check Address Code	The vendor’s check address code, such as Main or Austin Office.
Payment Method	The form of payment selected on the Write Receipts form using Transactions>Write Receipts or AR Receipts form using Transactions>Receipts.
{User Defined Field} - Vendors	A vendor type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Customers	A customer type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Transaction Documents	A transaction documents type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Transaction Lines	A transaction lines type user defined field and its data. There is a separate column for each field.

Items by Page (Page Breaks)

The current data arrangement per page for the report displays.

Use Items by Page to divided report items onto separate pages, starting a new page for each item.

See Report Builder Setup Tab for more information on separating report pages.

These are the available columns with their descriptions for Expanded General Ledger reports.

Note: Fewer or additional report columns may be available depending on your MIP implementation.

Column	Description
{Segment Name} Code	The code assigned to the segment. The report prints the account code, such as 201, 05, or 45001. The system displays one column for each of these code types, such as Fund Code or GL Code.
{Segment Name} Group Code	The group code assigned to the segment. The report prints a column for each group code, such as Fund Group Code.
Payment Type	The payment type associated with the document—either Check or Voucher.
{User Defined Field} - Vendors	A vendor type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Transaction Documents	A transaction documents type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Transaction Lines	A transaction lines type user defined field and its data. There is a separate column for each field.

Filters

The current column filtering for the reports displays.

Use filtering to narrow down and more explicitly define the data to include in the report.

See Report Builder Filter Tab for more information on adjusting report filters.

These are the available columns with their descriptions for Expanded General Ledger reports.

Note: Fewer or additional report columns may be available depending on your MIP implementation.

Column	Description
Transaction Source (Posted)	The document's transaction type, such as APC, API, APM, APR, APS, APV, ARB, ARC, ARM, ARP, ARR, ARS, ARV, BD, BDH, CD, CDS, CR, CRS, CL, CSR, ENC, ENH, ENL, IAR, IAA, IVR, IAM, IAS, IAF, IAC, IAB, JV, JVA, JVD, JVH, PRC, PRS, PRV, or VCK.
Transaction Source (Unposted	The document's transaction type, such as APC, API, APM, APR, APS, APV, ARB, ARC, ARM, ARP, ARR, ARS, ARV, BD, BDH, CD, CDS, CR, CRS, CL, CSR, ENC, ENH, ENL, IAR, IAA, IVR, IAM, IAS, IAF, IAC, IAB, JV, JVA, JVD, JVH, PRC, PRS, PRV, or VCK.
Session ID (Posted)	The Session ID assigned to the batch of documents.
Session ID (Unposted)	The Session ID assigned to the batch of documents.
{Segment Name} Code	The code assigned to the segment. The report prints the account code, such as 201, 05, or 45001. The system displays one column for each of these code types, such as Fund Code or GL Code.
ID	If the Accounts Payable, Accounts Receivable Reporting, or Payroll modules are installed, this is the Vendor ID, Customer ID, or Employee ID assigned.
Source	A source of Customer, Vendor, Employee, or Payroll Processing Group. The report shows C, V, E, or P.
Effective Date	The line item's effective date.
Entry Type	The entry type chosen during transaction entry—Normal, End of Year Adjustment, Adjust Opening Balances, or Beginning Balance. The system prints an N, A, AO, or UO. For opening balances in Detail, the system prints System Opening Balances (SO).
{Segment Name} Code	The code assigned to the segment. The report prints the account code, such as 201, 05, or 45001. The system displays one column for each of these code types, such as Fund Code or GL Code.
{Segment Name} Group Code	The group code assigned to the segment. The report prints a column for each group code, such as Fund Group Code.
Account Type
Payment Type	The payment type associated with the document—either Check or Voucher.
Document Number	The document number that was entered on the transaction entry form.
Reversed Invoice	A designation of Yes or No, determining whether the AP invoice/credit has been automatically reversed in the system using the Reverse Session Form.
Payment Method	The form of payment selected on the Write Receipts form using Transactions>Write Receipts or AR Receipts form using Transactions>Receipts.
Check Address Code	The vendor’s check address code, such as Main or Austin Office.
{User Defined Field} - Vendors	A vendor type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Transaction Documents	A transaction documents type user defined field and its data. There is a separate column for each field.
{User Defined Field} - Transaction Lines	A transaction lines type user defined field and its data. There is a separate column for each field.

Options

Use this tab to set up any Available Options for the report.

See Report Builder Options Tab for more information on adjusting report options.

These are the available options with their descriptions for Expanded General Ledger reports.

Options	Description
Include\|Year-End Adjustments	Select this option to include year-end adjustments on the report. This entry type was designated during transaction entry.
Include\|Opening Entries in Detail	Select this option to include opening balances (system or user opening entries) in detail. This entry type was designated during transaction entry.
Include\|Unposted Transactions	Select this option to include unposted transaction sessions, except for sessions related to transaction sources ENC (Encumbrances), ENL (Encumbrance Liquidations), and BD (Budget). You can view how unposted transactions affect the detail balance information. Additionally, you can filter for specific unposted session IDs and transaction sources using the Filter tab.
Miscellaneous\| Summarize Amounts	Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.
Miscellaneous\| Suppress Lines with All Zeros	Select this option, along with the Summarize Amounts option, so that documents with zero amounts do not print. If the debit and credit on the same line nets to zero then it is suppressed. For example, there is a GL code with a debit of $100 (USD) and a credit of $100 (USD) and it is on the same line with no other entries. The GL code will not appear on the report. This option only works with transaction line type user defined fields with a field type of currency.
Miscellaneous\| Subtotal Detail by Calendar Month	Select this option to subtotal the detail by a calendar month. This subtotal always calculates according to calendar month end, (1-31) not the month end of the Fiscal Year.
Security\|Do Not Allow Changes to this Report	Select this option to lock the report and disallow changes.

Layout

Use this tab to change the font and page setup for a report.

See Report Builder Layout Tab for more information on adjusting the report layout.