General Ledger Reports: A to Z
This table lists the General Ledger reports, sorted alphanumerically by report ID.
Note: You may see both of the terms XML Publisher (XMLP) and BI Publisher, depending on the version of your PeopleTools installation and the Bundle version of your application. As of PeopleTools 8.52, references to XML Publisher (XMLP) have changed to BI Publisher. This does not denote a change to the reports; only the naming convention has changed.
|
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
|---|---|---|---|
|
FIN1001 Message Log Report |
Prints message logs for a process instance ID and batch report type, similar to the online query that is available for each background program. Displays job ID, program name, date, time, sequence number, logged message, and explanation for each process instance ID. (SQR) |
|
RUN_FIN1001 |
|
FIN2001 Journal Entry Detail Report |
Displays all journal entries that were entered in the system for a business unit and ledger within the date range specified. Prints the journal entries in ascending ID order within the ledger and shows the journal date, the source, whether a reversal entry was created, journal status, posted date (if any), and a description. For each line that is included in the journal entry, lists the line number of the entry, the account number, a description, the department, product, and project ChartField values, and debit and credit detail. Also prints statistical information where included in a journal entry. (SQR) |
|
RUN_FIN2001 |
|
FIN2005 Journal Entry Detail Report with Attributes |
This report is similar to the Journal Entry Detail Report, except that this report also lists the ChartField attribute values. (SQR) |
|
RUN_FIN2005 |
|
FIN5001 Reconciliation by System Source |
This report consists of detailed subsystem and General Ledger (GL) journal transactions that are aggregated to the business unit, subsystem source, ledger, account or alternate account, fiscal year, and accounting period level. For example, it lists the data at the system source level, such as accounts payable (AP), and then lists all the activity for AP, including what was posted and not posted, for one or more selected ChartFields that appear in the data that you loaded. (SQR) |
|
RUN_FIN5001 (RUN_GLRCN_RPTS) |
|
FIN5005 Reconciliation by ChartField report. |
Lists the data based on one or more selected ChartFields that appear in the data that you loaded. Each of the subsystem amounts that fall within the ChartField combination is listed on the report along with the total amounts for the ChartFields and the related ledgers. (SQR) Run control parameters allow you to select a ChartField value or a tree with the ChartField values to report. The run control parameters allow you to include vs. exclude system sources. |
|
RUN_FIN5005 (RUN_GLRCN_RPTS) |
|
FSX5101 Ledger Translation Errors report (BI Publisher) |
Lists the errors from ledger translation. (BI Publisher) |
|
RUN_FIN5101 (RUN_GLRCN_RPTS) |
|
FSX0007 SpeedTypes Report |
Lists all valid SpeedTypes and corresponding information, including the ChartField values that are defined for each SpeedType (BI Publisher report). |
|
RUN_FIN0007 |
|
FSX0011 Valid Department Codes Report |
Lists all valid Department values and related information (BI Publisher report). |
|
RUN_FIN0011 |
|
FSX0012 Valid Product Codes Report |
Lists all valid Product values and related information (BI Publisher report). |
|
RUN_FIN0012 |
|
FSX0013 Valid Project IDs Report |
Lists all valid Project ID values and related information (BI Publisher report). |
|
RUN_FIN0013 |
|
GLX1000 Summary Ledger Definition Report (BI Publisher) |
Displays information about summary ledgers, including a description, the detail ledger that it summarizes, record names, and a listing of the ChartFields that are associated with the ledger. (BI Publisher) Transactions that have been journalized will be differentiated between those transactions that have not been journalized. Any ChartField changes that have been made between journalized transaction and the accounting line value will be reported. Information is provided on journals in suspense that originated in the system source. |
|
RUN_GLC1000 |
|
GLX1001 Valid Ledger Codes (BI Publisher) |
Displays information about valid ledger codes including associated book codes. (BI Publisher) |
|
RUN_GLC1001 |
|
GLX4001 Summary Calendars (BI Publisher) |
Displays information about summary calendars. Includes a description as well as a listing of the periods that you have defined for the calendar. (BI Publisher) |
|
RUN_GLC4001 |
|
GLX4003 Combination Group (BI Publisher) |
Displays information on ChartField combination edit groups for a selected SetID. (BI Publisher) |
|
RUN_GLC4003 |
|
GLX4007 Journal Entry Template (BI Publisher) |
Displays Journal Entry Templates by the security applied that is available to a user. (BI Publisher). Use this report if you have configured ChartFields to avoid manual changes. |
|
RUN_GLC4007 |
|
GLX4008 Journal Class Report (BI Publisher) |
Displays the journal class name and a description of each for a selected SetID. (BI Publisher) |
|
RUN_GLC4008 |
|
GLX5002 Translation Calculation Log |
Lists translation calculation details by process instance and translation step. (BI Publisher) |
|
RUN_GLS5002 |
|
GLX5003 Revaluation Calculation Log |
Lists revaluation calculation details by process instance and revaluation step. (BI Publisher) |
|
RUN_GLS5003 |
|
GLX5004 Translate in Ledger Calculation Log |
Lists translation within ledger calculation details by process instance and translate within ledger step. (BI Publisher) |
|
RUN_GLS5004 |
|
GLX5501 ADB Calculation Report (BI Publisher) |
Lists ADB calculation details, including averaged period, date, and time. (BI Publisher) |
|
RUN_GLC5501 |
|
GLX6001 Allocation Group (BI Publisher) |
Lists detail information that is associated with a particular allocation group. (BI Publisher) |
|
RUN_GLC6001 |
|
GLX7501 Journal Entry Detail (BI Publisher format) |
BI Publisher reports (formerly XMLP) do not require manual changes to support ChartField configuration. Shows journal entry detail information by business unit, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. It also shows line number, account, description, amount, rate type, exchange rate, foreign amount, base amount, and totals for the journal. (BI Publisher) |
Select the Print Journal (XMLP) value in the Process field, and click the Process button. Click the Report Manager button and then click the Journal Entry Print link for the GLX7501 report. Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLX7501 report. |
RUN_GLC7501 |
|
GLX7502 Journal Entry Detail (separate debit and credit) (BI Publisher) |
BI Publisher reports do not require manual changes to support ChartField configuration. Shows journal entry detail information for separate debit credit by business unit, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. It also shows line number, account, description, amount, rate type, exchange rate, foreign amount, base amount, and totals for the journal. (BI Publisher) Note: You must have configured you system for separate debit credit to use this report. |
Select the Print Journal (XMLP) value in the Process field, and click the Process button. Click the Report Manager button and then click the Journal Entry Print link for the GLX7502 report. Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLX7502 report. |
RUN_GLC7502 |
|
GLX9001 Amortization Reconciliation Report |
Displays information about the amortization reconciliation. Includes the details of the Amortization ID, Business Unit, Amortization Type, Amount, Voucher details, along with a detailed information of all the amortization schedules. |
|
RUN_GLX9001 |
|
GLS1001 Summary Ledger Detail |
This is a template for designing reports based on user-specific ledger definitions. This is based on the summary ledger (PS_S_LEDGER_SUM), which you can find in the DEMO database. The record definition set consists of the following ChartFields: ACCT, OPERATING_UNIT, DIVISION, PRODUCT_AREA, and PROJ. Contains one statistics code field named STATS. (SQR) |
|
RUN_GLS1001 |
|
GLS1002 Closing Rules |
Displays information about closing set rules. It prints a description of the close set, identifies the name of the account ChartField, and shows the ChartField to which that profit and loss account will be closed. Also shows the option for retaining earnings in the ChartField. (SQR) |
|
RUN_GLS1002 |
|
GLS1003 Closing Trial Balance |
Summarizes all entries on the ledger by account type. Prints beginning and ending balances for the year, totals for the period, adjustments, and closing entries. (SQR) |
|
RUN_GLS1003 |
|
GLS1004 Journal Closing Status |
Displays the journal line details for journal lines with various closing statuses. (SQR) |
|
RUN_GLS1004 |
|
GLS1005 Translate Ledger Reconciliation |
Reconciles the amounts in the currency translation ledger to the amounts in the primary ledger within a Multibook ledger group. (SQR) |
|
RUN_GLS1005 |
|
GLS1006 Ledger In-Sync |
This report searches the currency translation ledger within a multibook ledger to determine whether any data (for a particular year) is violating the required ledger structure. (SQR) |
|
RUN_GLS1006 |
|
GLS2000 Elimination Set Definition |
Displays all elimination set definitions for financial consolidations. Lists accounts to which differences will post if the set doesn't eliminate and shows the ChartFields (such as ACCOUNT and BUSINESS_UNIT) and the ChartField values that make up the elimination set, as well as a description of those values. (SQR) |
|
RUN_GLS2000 |
|
GLS2001 Minority Interest Set Definition |
Displays the minority interest set definitions for financial consolidations. Lists for each minority interest set a description, tree structure ID, the subsidiary entity, and percent of ownership. Also lists the accounts to which differences will post if the set doesn't eliminate, as well as the ChartField, manner specified, tree name/level, and the values that make up the parent/subsidiary accounts. (SQR) |
|
RUN_GLS2001 |
|
GLS2002 Consolidation Set Report |
Displays the options and controls that tell General Ledger how to process a consolidation. Lists the journal ID mask, source, and relative elimination reversal date for elimination journals, the ChartFields included in the elimination journals, whether all elimination sets that are defined for the consolidation tree will apply, which elimination sets will be used, whether all minority interest sets apply, and which minority interest sets will be used. (SQR) |
|
RUN_GLS2002 |
|
GLS2003 Consolidation Out of Balance Report |
Displays the elimination sets and ledger amounts that were processed for a consolidation request. The elimination sets are totaled and any out-of-balance amount is displayed. The out-of-balance amounts are also summarized at the node and tree levels. (SQR) |
|
RUN_GLS2003 |
|
GLS2004 Minority Interest Eliminations and Adjustments |
Displays the results of minority interest calculations for a consolidation request based on the combination of business units that are present in the consolidation tree. The elimination and adjustment entries are grouped by minority interest set. (SQR) |
|
RUN_GLS2004 |
|
GLS2005 Audit Elimination Sets |
Displays the elimination sets and audit information, including account and business unit. (SQR) |
|
RUN_GLS2005 |
|
GLS2006 Equitization Rules |
Displays the definition information and purpose for the equitization rule, including component, ChartField, value, and description. (SQR) |
|
RUN_GLS2006 |
|
GLS2007 Subsidiary Ownership Sets Report |
Shows the ownership, set status, effective date, description, entity ChartField, subsidiary entity, parent, ownership percentage, and controlling equitize. (SQR) |
|
RUN_GLS2007 |
|
GLS2008 Equitization Calculation Log |
Lists equitization calculation details by process instance. (SQR) |
|
RUN_GLS2008 |
|
GLS3000 Open Item Listing |
Lists open Items for the accounts specified, including a description of the accounts, the OpenItem key field, and a detailed listing of the journal lines that have an open status up to the as of date. The journal lines are subtotaled by key field value. Journal lines containing OpenItem accounts are matched together based on the OpenItem edit field. (SQR) |
|
RUN_GLS3000 |
|
GLS3001 InterUnit Activity |
Displays reconciliation information by business unit, ChartField, primary and balancing values, and variance. (SQR) |
|
RUN_GLS3001 |
|
GLS4000 Schedules |
Prints a list of the schedules that you have defined for a SetID. The report includes a description of each schedule and the definition of its frequency. (SQR) |
|
RUN_GLS4000 |
|
GLS4002 Combination Rule |
Displays information on a selected ChartField combination edit rule. (SQR) |
|
RUN_GLS4002 |
|
GLS5000 Translation Definition |
Displays the details and rules of each currency translation step. For each translation step, the report shows the description, ledger information, output and journal options, and gain and loss ChartFields. In addition, detailed information is displayed for every translation rule that is used by the translation step. (SQR) |
|
RUN_GLS5000 |
|
GLS5001 Revaluation Definition |
Displays the details of each currency revaluation step, including revaluation step description, ledger and TimeSpan information, exchange rate type, output and journal options, gain and loss ChartFields, and detailed revaluation ChartField information. (SQR) |
|
RUN_GLS5001 |
|
GLS5002 Translation Calculation Log |
Lists translation calculation details by process instance and translation step. (SQR) |
|
RUN_GLS5002 |
|
GLS5003 Revaluation Calculation Log |
Lists revaluation calculation details by process instance and revaluation step. (SQR) |
|
RUN_GLS5003 |
|
GLS5004 Translate in Ledger Calculation Log |
Lists translation within ledger calculation details by process instance and translate within ledger step. (SQR) |
|
RUN_GLS5004 |
|
GLS5005 Translate in Ledger Report |
Displays the details and rules of each translation step within the ledger calculation log. For each step, the report shows the description, ledger information, output and journal options, and gain and loss ChartFields. (SQR) |
|
RUN_GLS5005 |
|
GLS5500 ADB Definition report (average daily balance definition) |
Prints ADB details, including description, purpose, and ChartField information. (SQR) |
|
RUN_GLS5500 |
|
GLS6000 Allocation Step Report |
Lists detailed information for allocation steps. (SQR) |
|
RUN_GLS6000 |
|
GLS6002 Allocation Calculation Log |
Lists the allocation calculations that were performed for a given process step within a specified process instance. Displays the pool, basis, and target amounts. (SQR) |
|
RUN_GLS6002 |
|
GLS6003 Budget Copy Calculation Log |
Lists the Budget Copy Process calculations that were performed for a given process step within a specified process instance. For each process step, the report shows the sequence, business unit, account, department, product, project status, year, period, pool amount, basis amount, basis total, target amount, and offset amount. (SQR) |
|
RUN_GLS6003 |
|
GLS7001 Standard Journals report |
Lists standard journal entries and their status. (SQR) |
|
RUN_GLS7001 |
|
GLS7002 Ledger Activity report |
Lists the beginning and ending ledger balances by ChartField combination and account. Also lists the detailed journal line activity that is posted against the ledger for the accounting periods that are specified. (SQR) |
|
RUN_GLS7002 |
|
GLS7003 Ledger Summary Report |
Summarizes journal totals within a ledger by ChartField. |
|
RUN_GLS7003 |
|
GLS7009 Posted Journal Summary |
Provides the ability to report on journals that were posted during a specific run of the Journal Post process. The Journal Post process updates all journals that were posted with the value of the Process Instance. The Process Instance is part of the search criteria that is used by the Posted Journals - Summary report. (SQR) |
|
RUN_GLS7009 |
|
GLS7010 Ledger vs Journal Integrity |
Checks for any discrepancy between Ledger and Journal tables within a specified period range. (SQR) |
|
RUN_GLS7010 |
|
GLS7011 Journal Edit Errors |
Provides detailed information about journal edit errors: period, journal ID, date, source, reference number, error type, line, line description, field name, and error message. (SQR) |
|
RUN_GLS7011 |
|
GLS7012 Trial Balance |
Combines detail and summary balance information. Shows the ending ledger balances for the specified year and period by ChartField combination. Also displays subtotals by ChartField. Prints a final total for debits and credits. (SQR) |
|
RUN_GLS7012 |
|
GLS7015 Journal Suspense Activity |
Provides detailed information about suspended journals. (SQR) |
|
RUN_GLS7015 |
|
GLS7016 Ledger Activity with Attributes Report |
Lists the journal activity and the associated attributes for one or more specific ChartFields in a ledger for one or more periods, including beginning and ending balances. (SQR) |
|
RUN_GLS7016 |
|
GLS7017 General Ledger Activity with Fund and Account Attributes |
Generates a FACTS II report for a specific business unit, ledger, fiscal year, period range, adjustment period information, and FACTS tree group. The Program Reporting Category (PRC column heading) can display values for Category A and Category B apportioned funds. You can also indicate that the numeric field can be 23 integers and 3 decimal places long. (SQR) |
|
RUN_GLS7017 |
|
GLS7500 Ledger File Creation |
Reads all entries on the ledger and gives the ending balance for the year and period by account. Output is routed to an ASCII file in the specified format. (SQR) |
|
RUN_GLS7500 |
|
GLS8012 Journal Line/Accounting Entry Reconciliation |
Compares journal entry lines with accounting entries. (SQR) |
|
RUN_GLS8012 |
|
GLS8303 FACTS II Accounting Edit Validation |
Includes validation edits for account attributes, also includes footnote check to Edit10 when balance is negative, and Edit 8 validation. Shows Program Reporting Category (PRCs) for Category A and B. |
General Ledger, Federal Reports, FACTS II Review, Validate FACTS II Data |
RUN_GLS8303 |
|
GLS8310 FACTS I Validation report |
This report is generated when you run the FACTS I Validation process. It describes any outstanding issues for each FACTS I edit that is run for your FACTS I accumulated data. (SQR) |
|
RUN_CNTL_FACTSI |
|
GLS8311 FACTS I Trial Balance report |
This report displays the status of the General Ledger account balances along with the corresponding USSGL account attributes based on each Treasury Symbol. (SQR) |
|
RUN_CNTL_FACTSI |
|
GLS8312 FACTS II Trial Balance |
This report displays the status of the General Ledger account balances along with the corresponding USSGL account attributes based on each Treasury Symbol. (SQR) |
|
F2_RUN_GLS8312 |
|
GLS8400 SF224 Transaction Detail Report |
This is a monthly report that includes the detail transactions that make up the totals on the SF224 - Statement of Cash Transactions report. The detail report supports both regular SF224 and partial SF224 reporting. |
|
RUN_GLS8400 |
|
GLS8410 SF224 Business Activity Exception Report |
Displays transactions that should not be recorded for a particular ALC based on the Business Activity Type code for that ALC. For example, if the ALC is classified with a GWA Business Activity of IPAC Only, then the report reflects any transactions erroneously recorded for CA$HLINK and TDO Payments. The report reflects data from Accounts Receivable and Accounts Payable. General Ledger journal entry activity is not included in the report. |
General Ledger, Federal Reports, SF224/1219/1220, SF224 Bus Activity Exceptions |
RUN_GLS8410 |
|
GLS8411 ALC GWA Reporting Options Report |
Displays Agency Location Codes by SetID and prints the ALC, agency Name, Business Activity Type, and all related GWA Reporter Category Codes by descending effective date and status. |
|
RUN_GLS8411 |
|
GLS8500 Federal Trial Balance report |
This is a summary trial balance report. This report displays a beginning balance, the total amount of debits and credits, and an ending balance. The data is generated for the specified ChartField combination for the fiscal year, accounting periods, and adjustment periods. This report also displays subtotals by ChartField and grand totals by TAS/TAFS levels. Displays the fiscal year grand total. (SQR) |
|
RUN_GLS8500 |
|
GLS8501 Federal Transaction Register |
This is an online report that displays values at the fund, department, and TAS/TAFS levels for each accounting period along with each ChartField's attributes and attribute values. Displays the Program Reporting Category serving Category A and Category B and also accumulates and displays subtotals by ChartField and grand total. (SQR) |
|
RUN_GLS8501 |
|
GLS9500 Fund Balance Reconciliation |
This report is run after you run the Fund Balance Reconciliation process, which compares account activity and trial balance data that is imported from the U.S. Treasury to a federal agency's cash activity. It contains any differences between a federal agency's and the U.S. Treasury's data. (SQR) |
|
RUN_FBRECON_RPT |
|
GLSF224P Statement of Cash Transactions |
SF224 is a monthly report to the U.S. Treasury that identifies the dollar amounts of confirmed disbursements and collections by Treasury Symbol, Agency Location Code, and fiscal month. This report is used by the U.S. Treasury to ensure that the agency agrees with the internal U.S. agencies that perform disbursements through the U.S. Treasury. This option enables you to create a flat file of the report to submit electronically through GOALS, and to print a hard copy of the report. SF224 functionality supports both regular and partial reporting. |
|
RUN_SF224_SF1220 |
|
GLSF1219 Statement of Accountability |
This report is used to determine the accountability of disbursing officers for funds that are held outside the Department of Treasury (cash on hand) by U.S. Treasury Regional Finance Centers (RFCs) and other nonmilitary agencies that do not do their own disbursing. This option prints a hard copy version of this report. This report is very similar to the SF1220 report. These two reports are treated as one report when submitted electronically and processed by GOALS using the SF1219/1220 Create option to create the file. |
|
RUN_SF1219 |
|
GLSF224P Statement of Transactions According to Appropriations, Funds, and Receipt Accounts report |
Provides the U.S. Treasury with a monthly statement of payments and collections that are performed by agencies that do their own disbursing. This option prints a hard-copy version of this report. This report is very similar to the SF1219 report. These two reports are treated as one report when submitted electronically and processed by GOALS using the SF1219/1220 Create option to create the file. |
|
RUN_SF224_SF1220 |