Showing posts with label Oracle GL. Show all posts
Showing posts with label Oracle GL. Show all posts

Tuesday, 10 September 2019

Basic Terms and concepts in Ledger.

Legal Entities:

 An organization that represents a legal company for which you prepare fiscal or tax reports. You assign tax identifiers and other relevant information to this entity.



Operating Units:

 An organization that partitions data for subledger products (AP, AR, PA, PO, OE). It is roughly equivalent to a single pre-Multi-Org installation.



Ledgers :

 The accounting system which tracks the journal entries that affect each account.



Reporting Currencies:

 The currency you use for financial reporting. If your reporting currency is not the same as your functional currency, you can use foreign currency translation to restate your account balances in your reporting currency.





Subledger Accounting:

 A subledger is a ledger containing all of a detailed sub-set of transactions. The total of the transactions in the subledger roll up into the general ledger. For example, a subledger may contain all accounts receivable, or accounts payable, or fixed asset transactions



Intercompany Balancing:

 Intercompany Balances means the intercompany accounts receivable and accounts payable between any member of the ABC Group, on the one hand, and any member of the XYZ Group, on the other hand.



Intercompany account:

 A general ledger account which you define in an Accounting Flexfield to balance intercompany transactions. You can define multiple intercompany accounts for use with different types of accounts payable journal entries.



Intercompany journal entry:

 A journal entry that records transactions between affiliates. Oracle General Ledger keeps your accounting records in balance for each company by automatically creating offsetting entries to an intercompany account you define.



Sequencing (Accounting and Report Sequencing):

 When the journal entries recorded manually we usually assign unique sequence number for each entry and transfer the entries to GL.

 Sequence numbering the JE simplifies this cumbersome task of tracing the journal entires.

Foreign Currency Concepts in GL

Foreign Currency Concepts

Below are the three key foreign currency concepts in GL

Conversion
• When foreign currency transactions that are immediately converted at the time of entry to the ledger currency of the ledger in which the transaction takes place refers as Conversion of currency.
Revaluation
•There might be fluctuation in the Exchange rate between the time when the transaction was entered & the end of the period, in this scenario Revaluation concept of Currency helps to adjust the liability or asset accounts that may be understated or overstated at the end of the period.
Translation
• Translation refers to reset an entire ledger or balances for a company from the ledger currency to a foreign currency.

General Ledger Accounting Cycle

General Ledger Accounting Cycle
Below are the steps for the Accounting Cycle of GL
1. Open period
2. Create/reverse journal entries
3. Post
4. Review
5. Revalue
6. Translate
7. Consolidate
8. Review/correct balances
9. Run accounting reports
10. Close accounting period

We will study each step in coming posts... :) 

Monday, 9 September 2019

Oracle General Ledger Overview

Oracle General Ledger Overview.


  • GL is the Central repository of accounting information.
  •  All accounting information in oracle application is centrally stored in General ledger module
  •  Main purpose of a general ledger system is to record financial activity of a company.
  •  GL is also widely used to produce financial and management reports.

Oracle General Ledger is a comprehensive financial management solution that enables you to:
  • Record and Review Accounting Information
  • Import data from subsidiary ledgers, or enter journals to record actual or budget transactions directly into Oracle General Ledger.
  • Enter encumbrance journals to track encumbrances through the purchase process and to control spending against budgeted amounts.
  • Review account balances online or through reports.
  • Manipulate Accounting Information
  • Correct actual, budget, and encumbrance information.
  • Revalue and translate balances denominated in foreign currencies.
  • Consolidate balances from multiple sets of books.
  • Analyze Accounting Information
Function & Features of GL

Information Access
• Access information stored in the GL through online reporting and analysis tools.
Financial Controls
• Use security features to control access to specific areas and functions of General Ledger.
Data Collection
• Collect data from Oracle subledgers and non-Oracle feeder systems.
Financial Reporting and Analysis
• Select from a variety of Standard Reports and Listings.
• Use the Financial Statement Generator to build customized reports with reusable report objects.
• Use Web ADI (Web Applications Desktop Integrator) Report Manager to build reports and drilldown on balances within a spreadsheet environment.