Comprehensive List of GL Accounts in SAP

List Of Gl Accounts In Sap

The GL account numbers in the SAP system consist of the last six digits of your account number. These numbers are used to categorize revenues, expenditures, and transfers. They are grouped into different categories such as revenue, revenue transfers, cost of goods sold, salaries, wages and benefits, supplies, equipment, and expense transfers.

Here is a compilation of GL account numbers along with their corresponding descriptions, outlining the purpose of each account.

5XXXXX – Revenue

– 510200 Course Fees – Ext

– 510300 Admission Fees – Ext

– 510400 Orientation – Student Fees – Ext

– 510500 Credit by Examination – Ext

– 510600 Correspondence Course Fees – Ext

– 510800 Orientation – Parent Fees – Ext

– 510900 Graduate School Application Fee-On Campus 1 – Ext

– 511000 Undergraduate Application Fee-On Campus 1 – Ext

– ​511200 Graduate Fees for Grad School – External

​511300 Program Change Fees – Grad School – External

​511400 Late fees – External

SAP GL Accounts List

Here are some examples of GL accounts in SAP: 512100 for Spring tuition, 512200 for Summer I tuition (extended), 512300 for Summer II tuition (extended), and 512400 for Fall tuition (extended).

State appropriations

514000 State of Michigan Appropriation can be described as the allocation of funds made by the government of Michigan.

SAP GL Account List

Here are some examples of GL accounts in SAP: 516700 for Private Gifts – Operating – Ext, 516710 for Private Gifts – Endowment Permanent – Ext, and 516720 for Private Gifts – Capital – Ext.

Educational Activities – Sales and Services

– 520200 Sales Taxable – Ext

– 520300 Sales Non-Taxable – Ext

You might be interested:  SAP ABAP: Reporting Events in ALV

– 520400 Sales – Theatre – Ext

– 520500 Sales Inter-University – Int

– 520800 Workshop Fees – Ext

– 521000 Fines

– 521100 Replacement Fees – Ext

– 521200 Miscellaneous Fees – Ext

– 521400 Vending – Ext

– 522200 Sales-Miscellaneous –Ext

-522301Sales-Miscellaneous –Int

Athletics

526000 – 527998 (Exclusively for Athletics Purposes)

Auxiliary Activities – Motor Pool

534500 – 535800 (Exclusively for Motor Pool Usage)

Other revenue

536000 – 538255 (Exclusively for Student Activity Center)

540200 Cash Over – Cash Short – External

540300 Miscellaneous Income – External

540305 Commissions Revenue – External

540310 Miscellaneous Income – Internal

540320 – 540399 Police Revenue (Exclusively for Public Safety)

540600 Equipment Rental – External

540610 Rental Income – Internal

540800 Lease Income – External

541000 Grant/Contract Program Income – External

List of GL Accounts in SAP

545500 – 565900 (Exclusive to Public Broadcasting)

Auxiliary Activities – Sales and Services

560100 – 565900 (Exclusively for Auxiliary Services)

562000 Sales Taxable – Ext

562100 Sales Nontaxable – Ext

562150 Sales Nontaxable – UBIT – Ext

562200 Inter-University Sales – Int

562201 – 562256 Printing Services Revenue (Restricted to Printing Services)

562270 – 562281 Res Life Sign Shop Revenue (Exclusive to Res Life Sign Shop)

563100 – 563900 Bookstore Revenue (Reserved for Bookstore Use Only)

565000 – 565312 Athletics Revenue (For Athletics Purposes Only)

Telecommunications resources

566000 – 566900 (Exclusively for Telecommunications Purposes)

Inventory of GL Accounts in SAP

567000 – 567900 (Exclusively for the purpose of central energy consumption)

SAP GL Account Listing

569100 – 569999 (Exclusively for University Events)

59XXXX ​- Revenue transfers

Here are some GL accounts in SAP that are exclusively used for accounting services:

– 599800 Balance Carryforward (Restricted to Accounting Services)

– 599801 Commitment Carryforward (Reserved for Accounting Services)

– 599803 Gift Carryforward (Designated for Accounting Services)

Revenue Transfers

The range of GL accounts from 599931 to 599960 is exclusively designated for the use of accounting services.

60XXXX – ​Cost of goods sold

601000 – 609900 represents the expenses related to the cost of goods sold.

How can I export a GL list in SAP?

Select the relevant SAP System from the drop down and enter a valid SAP user name and password.Select the SAP Table Data Read Tool from the drop down list.Enter a file name T001_Company_Code_MD. This will be used later in Power BI.Enter the Table Name.Click on Search.Select the required fields.Click on Save.

61XXXX – 62XXXX – ​Salaries, wages, & benefits

– 613200 Faculty Salaries – This category includes Instructors, Professors, Librarians, Coaches, and Counselors.

– 613300 Faculty – Department Chairperson Salaries

– 613400 Faculty – Summer Salaries

– 613500 Faculty – Temporary Salaries

– 613600 Graduate Assistants Salaries – These are students who work in academic areas to gain credit and practical experience by assisting in teaching or research.

You might be interested:  Guide on Verifying Badi in Sap

– 613700 Course Instructor

– 613800 Ttrl/Monitor/Review

– 613900 Wkshop/Spkr/Prctr

– 614000 Advising Earnings

Fringe benefits

620900 Expenditure Credit (to be utilized for manual entries in the journal)

Payroll for Temporary Employees and Student Assistants

– 623000 Other Compensation

– 623100 Overtime

– 623200 Shift Differential

– 623300 Work in Higher Classification

– 623400 Callback Pay

– 623500 Wage Recharges (for manual journal entries)

– 623501 Wage Recharges – Student (for manual journal entries)

Student assistants – work-study

624200 CWS – College Work Study and 624300 MWS – Michigan Work Study are two examples of GL accounts in SAP.

Temporary Employees and Student Assistants: A List of GL Accounts in SAP

– 625200 Benefits for Temporary Employees

– 625300 Benefits for Temp Salaried Employees

– 625900 Miscellaneous Fringe Benefits

– 626000 Payment for Retirement Service Award

Number of GL accounts in SAP

The fourth type is “Revenue.” This account records income earned by selling goods or services. Revenue accounts vary depending on the nature of business operations—for example, sales revenue for a retail store or service revenue for a consulting firm.

The fifth type is “Expenses.” Expenses represent costs incurred during normal business operations. Examples include salaries/wages paid to employees, rent expenses for office space, utility bills, advertising expenses, etc.

Lastly, there are special types of GL accounts known as “Control Accounts” and “Reconciliation Accounts.” Control accounts summarize detailed information from sub-ledgers or subsidiary modules within SAP ERP system. Reconciliation accounts help in reconciling data between different accounting areas like general ledger with sub-ledger balances.

63XXXX – 7XXXXX – ​Supplies

820200 to 895999 is designated exclusively for use by the Facilities Management department. On the other hand, the range from 896000 to 898999 is specifically allocated for utilization on AUC Internal Orders.

If you have any queries about the utilization of equipment GLs, feel free to contact Hillary Pierce from Accounting Services at extension 1280.

Using FS10N in SAP: A Guide for Efficient Financial Reporting

To access the FS10N display for G/L totals, follow the menu path provided. Enter the necessary information such as the G/L account, company code, and fiscal year. After entering this information, click on execute to generate the report. The report will then display the balance carryforward, which represents the balance from the previous year.

List:

1. Access FS10N display for G/L totals using a specific menu path.

2. Input required details like G/L account, company code, and fiscal year.

3. Click on execute to run the report.

4. The generated report will show the balance carryforward from the previous year

9XXXXX – Expense Transfers

9XXXXXX Transfers exclusively for accounting purposes.

Exporting GL to Excel in SAP: How can it be done?

To export a report to Microsoft Excel, follow these steps:

1. Open the desired report.

You might be interested:  Tcode for OData Service in SAP: A Comprehensive Guide

2. Click on the Export to Excel icon.

3. If your report consists of multiple sheets, choose one of the following options:

– Export all sheets

– Export current sheet

4. Once downloaded, open the Excel file.

Tcode for displaying GL account line items

The SAP General Ledger is a feature that allows businesses to manage their financial transactions and track their expenses, revenues, assets, and liabilities. One of the key functionalities within the General Ledger is the GL Account Line Item Display, which can be accessed using the T-code FBL3N.

When you use this T-code in SAP, it provides you with a list of all the line items associated with a specific GL account. A line item refers to an individual transaction record that contains details such as date, amount, description, and reference number. By accessing this list through FBL3N, users can easily view and analyze detailed information about each transaction related to a particular GL account.

– The SAP General Ledger helps businesses manage finances effectively.

– The GL Account Line Item Display (T-code: FBL3N) provides a list of transaction details for specific GL accounts.

– This feature enables better auditing and analysis of financial records for decision-making purposes.

What does GL account group mean in SAP?

One important aspect controlled by GL account groups is the arrangement of numbers in a range according to their nature or purpose. This helps streamline financial reporting processes as well as facilitates easier analysis and tracking of transactions.

Furthermore, GL account groups play a crucial role in determining which fields are mandatory or optional when creating new accounts within a particular group. For example, if an organization wants to create a reconciliation account, they can make it compulsory to fill out specific information such as “Recon Account for Account Type” in the control data tab.

The meaning of SKA1 in SAP

SKA1 (G/L Account Master (Chart of Accounts)) is a standard table in SAP R\3 ERP systems.

Does the general ledger contain a comprehensive list of all accounts?

The chart of accounts in SAP, also known as the list of GL (General Ledger) accounts, plays a crucial role in organizing and categorizing financial transactions within an organization. It serves as a comprehensive directory that includes all account titles along with their corresponding folio numbers and account categories.

Every transaction recorded in the general ledger is assigned to a specific GL account based on its nature and purpose. The chart of accounts provides a systematic framework for classifying these accounts according to various criteria such as asset, liability, equity, revenue, or expense. This classification enables efficient tracking and analysis of financial data.

P.S: The chart of accounts not only simplifies financial management but also enhances transparency by providing a standardized structure for recording transactions across different departments or business units within an organization.