Work Instruction
Functional Area: General Ledger / Run General Ledger Account Balances Report
PurposeGeneral Ledger Management - Project Creation and Management
Use this procedure to produce the General Ledger (G/L) Account Balance report.
Trigger
Perform this procedure when you need to see month and year-to-date usage for individual G/L accounts.
Prerequisites
None
Menu Path
Use the following menu path to begin this transaction:
  • Select Accounting Financial Accounting General Ledger Information System General Ledger Reports Account Balances General G/L Account BalancesG/L Account Balances to go to the G/L Account Balances screen.
Transaction Code
S_ALR_87012277
Helpful Hints
  • The R/O/C column in the field description tables below defines whether the field is required (R), optional (O), or conditional (C).
  • On certain screens you may have to scroll to view some data entry fields.
  • Use the drill-down, filtering, sorting and other display functionality provided by SAP to customize your report.
  • Use the valid from-valid to feature of the search screen to access a series of data, such as 2006 to 2008.
  • The G/L Account Balances report shows the following monthly figures: balance carried forward at the beginning of the fiscal year, total of the period or periods carried forward, debit and credit totals of the reporting period, and debit or credit balances at the close of the reporting period.
  • Data may be sorted by G/L account number, and business area.
  • The report is intended for use by a central office when a global G/L view is needed.
  • Use transaction FS10N Display Account Balance to see a period-by period break-down. However, individual totals are not displayed if you enter a series of G/L accounts.

Work Instruction
Functional Area: General Ledger / Run General Ledger Account Balances Report
Procedure
1. / Start the transaction using the menu path or transaction code.
G/L Account Balances

2. / As required, complete/review the following fields:
Field / R/O/C / Description
Chart of accounts / Required / A classification scheme consisting of a group of general ledger (G/L) accounts; A chart of accounts provides a framework for the recording of values, in order to ensure an orderly rendering of accounting data.
Example:
UC
G/L account / Required / Code identifying the account in the general ledger where this item will post; Collection of balance sheet and profit and loss statement accounts; Includes Assets (1), Liabilities (2), Fund Balance Accounts (3), Revenue Sources (4), Expense Accounts (5), GAAP Only Accounts (6), Budget Reserves (7), Transfer Accounts (8) and CO Secondary Postings (9)
Example:
100010
Company code / Required / Organizational unit within Financial Accounting
Example:
UC
Fiscal year / Required / The fiscal year for which this transaction is relevant
Example:
2005
Business area / Optional / Business Area is the campus to which the cost center is assigned
Example:
U
Leaving this field blank will generate a report with data across all campuses.
Reporting periods / Optional / Identifies month and year-end periods; For the July-June fiscal year the reporting periods are 1-July through 12-June. Periods 13-16 are set aside for year-end closing.
Example:
1 (July)
Account currency / Required / Currency in which the account is managed
Example:
USD
Summarization level (0-4) / Optional / Levels that can be used for all types of account sorting; can be used to restrict output to the relevant data only
Example:
0
Subtotal at level (1) / Optional / Identifies the number of digits of the G/L to group G/L postings to be subtotaled
Example:
3
If the G/L account number changes at the specified digit, then the subtotals of the subtotals group currently being processed are issued. This calculation is based on a 10-digit G/L account number. The amounts of all G/L accounts from 0010000000 to 0019999999 are contained in the subtotals group 001*******. Since this parameter is offered three times, you can request the system to create a sub-total at three digits within the G/L account number. These can be entered in any sequence. The smallest digit entered between '1' and '9' determines the top subtotals control break, and the largest digit the lowest control break.
Subtotal at level (2) / Optional / Identifies the number of digits of the G/L to group G/L postings to be subtotaled
Example:
Leave Blank
Subtotal at level (3) / Optional / Identifies the number of digits of the G/L to group G/L postings to be subtotaled
Example:
Leave Blank
/ Narrow all searches as much as possible using specific selection criteria when known. Use the Form field for a single search, both the From and To fields for a range, and the arrow to the right of each row for combination of single entries and ranges. If no selection criteria is specified, the system will conduct a lengthy search that may yield large volumes of unnecessary data.
3. / Select to the left of Print accounts not posted.
/ Selecting this box includes G/L accounts in the report that have not been posted to.
4. / As required, complete/review the following fields:
Field / R/O/C / Description
Additional heading / Optional / User defined custom header that will be presented on the report
Example:
Department Operating Expense Review
Enter a user-defined report name. Maximum 40 digits.
G/L Account Balances (2)

5. / Review the displayed information.
6. / You have completed this transaction.
7. / Click until you return to the SAP Easy Access screen.
11/20/2017
Ver: / 08_GL_SALR87012277_Run GL Acct Bal Rpt_R1_GLMgmt_02.udc
© University of Cincinnati / 1/6
Work Instruction
Functional Area: General Ledger / Run General Ledger Account Balances Report
Result
You have displayed the balance of a G/L account for a specified period.
Comments
None
11/20/2017
Ver: / 08_GL_SALR87012277_Run GL Acct Bal Rpt_R1_GLMgmt_02.udc
© University of Cincinnati / 1/6