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)

Background Processes, Print Process Report

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)

General Ledger, General Reports, Journal Entry Detail

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)

General Ledger, General Reports, Journal Entry with Attributes

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)

General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by System Srce

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)

General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by ChartFields

RUN_FIN5005 (RUN_GLRCN_RPTS)

GLC1000

Summary Ledger Definition Report

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. (Crystal)

General Ledger, Summary Ledgers, Summary Ledger Definition Rpt

RUN_GLC1000

GLC4001

Summary Calendars

Displays information about summary calendars. Includes a description as well as a listing of the periods that you have defined for the calendar. (Crystal)

Setup Financials/Supply Chain, Common Definitions, Calendars/Schedules, Summary Calendar Report

RUN_GLC4001

GLC4003

Combination Group

Displays information on ChartField combination edit groups for a selected setID. (Crystal)

Setup Financials/Supply Chain, Common Definitions, Design ChartFields, Combination Editing, Combination Group Report

RUN_GLC4003

GLC4008

Journal Class Report

Displays the journal class name and a description of each for a selected setID. (Crystal).

Set Up Financials/Supply Chain, Common Definitions, Journals, Class Report

RUN_GLC4008

GLC5501

ADB Calculation Report

Lists ADB calculation details, including averaged period, date, and time. (Crystal)

General Ledger, Average Daily Balance, ADB Calculation Report

RUN_GLC5501

GLC6001

Allocation Group

Lists detail information that is associated with a particular allocation group. (Crystal)

Allocations, Reports, Allocation Group

RUN_GLC6001

GLC7501

Journal Entry Detail

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. (Crystal)

General Ledger, Journals, Journal Entry, Create/Update Journal Entries, Journal Entry Lines Page

Select the Print Journal 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 GLC7501 report.

Reporting Tools, Report Manager, and click the Journal Entry Print link to access the GLC7501 report.

RUN_GLC7501

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)

General Ledger, Summary Ledgers, Summary Ledger Detail Report

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)

General Ledger, Close Ledgers, Closing Rule Report

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)

General Ledger, Close Ledgers, Closing Trial Balance

RUN_GLS1003

GLS1004

Journal Closing Status

Displays the journal line details for journal lines with various closing statuses. (SQR)

General Ledger, Close Ledgers, Journal Closing Status Report

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)

General Ledger, Process Multi-Currency, Reports, Translation Ledger Reconcile

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)

General Ledger, Process Multi-Currency, Reports, Translation Ledger In-Sync

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)

General Ledger, Consolidate Financial Data, Reports, Elimination Sets

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)

General Ledger, Consolidate Financial Data, Reports, Minority Interest Sets

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)

General Ledger, Consolidate Financial Data, Reports, Consolidation Set

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)

General Ledger, Consolidate Financial Data, Reports, Elimination Out of Balance

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)

General Ledger, Consolidate Financial Data, Reports, Minority Int Elim/Adjustment

RUN_GLS2004

GLS2005

Audit Elimination Sets

Displays the elimination sets and audit information, including account and business unit. (SQR)

General Ledger, Consolidate Financial Data, Reports, Elimination Sets Audit

RUN_GLS2005

GLS2006

Equitization Rules

Displays the definition information and purpose for the equitization rule, including component, ChartField, value, and description. (SQR)

General Ledger, Consolidate Financial Data, Reports, Equitization Rules

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)

General Ledger, Consolidate Financial Data, Reports, Ownership Sets

RUN_GLS2007

GLS2008

Equitization Calculation Log

Lists equitization calculation details by process instance. (SQR)

General Ledger, Consolidate Financial Data, Reports, Equitization Calculation Log

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)

General Ledger, Open Items, Open Item Listing Report

RUN_GLS3000

GLS3001

InterUnit Activity

Displays reconciliation information by business unit, ChartField, primary and balancing values, and variance. (SQR)

General Ledger, General Reports, InterUnit Activity

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)

Setup Financials/Supply Chain, Common Definitions, Calendars/Schedules, Schedules Report

RUN_GLS4000

GLS4002

Combination Rule

Displays information on a selected ChartField combination edit rule. (SQR)

Setup Financials/Supply Chain, Common Definitions, Design ChartFields, Combination Editing, Combination Rule Report

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 ChartKeys. In addition, detailed information is displayed for every translation rule that is used by the translation step. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation Step

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 ChartKeys, and detailed revaluation ChartKey information. (SQR)

General Ledger, Process Multi-Currency, Reports, Revaluation Step

RUN_GLS5001

GLS5002

Translation Calculation Log

Lists translation calculation details by process instance and translation step. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation Calculation Log

RUN_GLS5002

GLS5003

Revaluation Calculation Log

Lists revaluation calculation details by process instance and revaluation step. (SQR)

General Ledger, Process Multi-Currency, Reports, Revaluation Calculation Log

RUN_GLS5003

GLS5004

Translate in Ledger Calculation Log

Lists translation within ledger calculation details by process instance and translate within ledger step. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation in Ledger Calc Log (translation in ledger calculation log)

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 ChartKeys. (SQR)

General Ledger, Process Multi-Currency, Reports, Translation in Ledger, Translate in Ledger Report

RUN_GLS5005

GLS5500

ADB Definition report (average daily balance definition)

Prints ADB details, including description, purpose, and ChartField information. (SQR)

General Ledger, Average Daily Balance, ADB Definition Report

RUN_GLS5500

GLS6000

Allocation Step Report

Lists detailed information for allocation steps. (SQR)

Allocations, Reports, Allocation Step

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)

Allocations, Reports, Allocation Calculation Logs

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)

General Ledger, Maintain Standard Budgets, Budget Copy Calculation Log

RUN_GLS6003

GLS7001

Standard Journals report

Lists standard journal entries and their status. (SQR)

General Ledger, General Reports, Standard Journals

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)

General Ledger, General Reports, Ledger Activity

RUN_GLS7002

GLS7003

Ledger Summary Report

Summarizes journal totals within a ledger by ChartField.

General Ledger, General Reports, Ledger Summary

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)

General Ledger, Journals, Process Journals, Posted Journal Summary Report

RUN_GLS7009

GLS7010

Ledger vs Journal Integrity

Checks for any discrepancy between Ledger and Journal tables within a specified period range. (SQR)

General Ledger, General Reports, Ledger vs Journal Integrity

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)

General Ledger, Journals, Process Journals, Journal Edit Errors Report

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)

General Ledger, General Reports, Trial Balance

RUN_GLS7012

GLS7015

Journal Suspense Activity

Provides detailed information about suspended journals. (SQR)

General Ledger, Journals, Suspense Correction, Suspended Activity Report

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)

General Ledger, General Reports, Ledger Activity with Attributes

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)

General Ledger, Federal Reports, FACTS II Reports, Ledger with Attributes Report

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)

General Ledger, Ledgers, Export Ledger Data

RUN_GLS7500

GLS8012

Journal Line/Accounting Entry Reconciliation

Compares journal entry lines with accounting entries. (SQR)

General Ledger, General Reports, Journal Line/Acctg Reconcil (journal line/accounting reconciliation)

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)

General Ledger, Federal Reports, FACTS I, Generate FACTS I

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)

General Ledger, Federal Reports, FACTS I, Generate FACTS I

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)

General Ledger, Federal Reports, FACTS II, FACTS II Reports, FACTS II Trial Balance

F2_RUN_GLS8312

GLS8400

SF224 Transaction Report

This is a monthly report sent to the U.S. Treasury that identifies the dollar amounts of confirmed U.S. disbursements and collections for an agency by Agency Location Code and fiscal month. This report is used to ensure agreement between the agency's records of disbursement and collections and those of the U.S. Treasury. (SQR)

General Ledger, Federal Reports, SF 224/ 1219/1220, SF 224 Transaction Report

RUN_GLS8400

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)

General Ledger, Federal Reports, Federal Trial Balance

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)

General Ledger, Federal Reports, Federal Transaction Register

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)

General Ledger, Federal Reports, Fund Balance Reconciliation, Generate Reconciliation Report

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.

General Ledger, Federal Reports, SF224 / 1219/ 1220, Run SF224 Report/Create File

RUN_SF224_SF1220

GLS8400

SF224 Statement of Cash Transaction Details

This is a monthly report that includes the detail transactions that make up the totals on the SF224 - Statement of Cash Transactions report.

General Ledger, Federal Reports, SF224 / 1219/ 1220, SF224 Transaction Report

RUN_GLS8400

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.

General Ledger, Federal Reports, SF224/ 1219/ 1220, Run SF1219 Report

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.

General Ledger, Federal Reports, SF224/ 1219/ 1220, Run SF1220 Report

RUN_SF224_SF1220