Home

General Ledger (FGL) User Manual

1. C Back Period Entry Allowed Node GL C Blocked El Transfer Balance on MIS Reclassification C Revaluation Split Required Currency Restrictions Single Currency All Foreign Currencies All Currencies Currency Po laz Reconciliation Direct Reconciliation O Split Reconciliation Statement Position GL Maintenance MIS Group Linkages IBAN Account Number Other GL Linked To This Parent Child GL For The Current GL Fields Input By Authorized By Modification Authorized Date Time Date Time Number Open You can capture the following details pertaining to the GL Category GL category can be specified only for a GL head A Head GL can be assigned any of the following categories e Asset e Liability e Contingent Asset e Contingent Liability e Income e Expense 4 3 ORACLE e Position e Position Equivalent Two Head GLs can have the same category All GLs that fall under a Head GL will essentially belong to the category defined for the Head Each category can have any number of GLs under it But the category allocated to a GL should be assigned at the head of any GL stream all nodes and leaves by default take the category of the Head GL to which they report General Ledger Type Based on the way they are used in accounting FGLs are classified into different tyoes Choose one of the following from the option list e Miscellaneous Credit e Miscellaneous Debit e Inter Branch e
2. 4 8 Start Date This is the first day of the corresponding period End Date This is the last date of the corresponding period End date of a period should always end ona month end Maintaining Transaction Codes Transaction codes are attributes at accounting entry level that identify the nature of an entry An attribute specific to an accounting entry can be a part of the transaction code You can maintain transaction codes using Transaction Code Maintenance screen in Oracle FLEXCUBE On this screen you need to capture the following details Transaction Code Enter a unique code to identify the transaction Description Enter a brief description on the nature of the accounting entry Once you have specified the above details save it Any attribute specific to the entry can form a part of the transaction code Identifying External Systems You need to maintain information on all external systems that post entries to a Oracle FLEXCUBE General Ledger You can set your preferences specific to such external systems in the External Systems screen You can invoke this screen by typing EGDSORCE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 External Systems Detailed source Code source description Generate Position Entries Balancing Check Move Balances on SDE Value Date Balancing Change Check haker Date Time Mod Ho Checker Date Ti
3. e Balance Attributes For auto generated entries Oracle FLEXCUBE generates system accounts based on balances Balance attributes are used in defining SDE classes for Revaluation Profit and Loss GLs Revaluation into GLs Position GLs and Year End PNL GLs In FGL you can have the following balance attributes as system defined elements gt Balance GL Balance System Account Financial Cycle Financial Period Balance Currency Yv Y V WV You can select the appropriate element type from the above Based on the selection the system displays the description Element Code Enter a unique code to identify the element that you are maintaining You can modify the element code for transaction attributes However if you are maintaining an MIS code the system defaults the MIS class as the transaction code In that case you cannot modify it However you may modify the description Data Type Specify data type to be used You can select one of the following from the dropdown menu e Date e String e Number Max Length Specify the maximum number of characters that can be used in the attribute However for MIS attributes you can set this length to a maximum of 9 Minimum Length Specify the minimum number of characters to be used in the attribute 5 2 ORACLE 9 1 2 Range Required Check this option to capture the value in range of buckets When you define an attribute of type Number or Date you may configure t
4. Opening Balance Debit Balance Debit Movement Debit Balance LEY Debit Movement LEY Credit Balance Credit Movement Credit Balance LEY Credit Movement LEY Closing Balance Debit Balance Debit Turnover Debit Balance LCY Debit Turnover LEY Credit Balance Credit Turnover Credit Balance LCY Credit Turnover LOY Here you can view the following details e Debit and credit opening balances and movements of the general ledger e Debit and credit current balances and turnovers in the general ledger You can query the general ledger balances by the following parameters e Branch Code e GLCode e GAAP Code e Currency Code e Value Date 5 19 ORACLE 5 2 4 Viewing Transaction Details You can view the latest transactions and MIS details using View Transaction Details screen You can invoke the View Transaction Details screen by typing EGDTXINF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Transaction Attribute Reference Transaction detail 10 Dm Attribute Code Attribute Description Attribute Value AAA L Using this screen you can query the transaction details as well as transaction MIS details based on the transaction attribute reference number 5 20 ORACLE 5 2 5 Viewing Customer MIS Details You can view the MIS details for a customer using View Customer Details screen You can invoke the View
5. 13 ORACLE Balances for the quarter Q2 will be as follows Balance Type Balance Branch Code CHO System Account Currency Financial Cycle FY2000 O N C o U h U Financial Period GL Code GAAP Code Opening Debit Balance Opening Credit Balance Opening Debit Balance in Local Currency Opening Credit Balance in Local Currency Opening Debit Movement Opening Credit Movement wese T a Opening Debit Movement in Local Currency Opening Credit Movement in Local Currency Debit Balance Credit Balance Debit Balance In Local Currency Credit Balance In Local Currency Debit Movement Credit Movement fo Debit Movement In Local Currency oO Credit Movement In Local Currency oO 5 1 8 Tracking General Ledger Balances General ledgers in Oracle FLEXCUBE are the consolidation points of system accounts Balance tracking for general ledgers is hence same as that of system accounts 5 14 ORACLE For details with illustration please refer the section Tracking Balances of System Accounts in this chapter For FGLs the system can track the following balances e Balances gt Opening Balance gt Opening Balance in Local Currency gt Current Balance gt Current Balance in Local Currency e Turnovers Opening Debit Turnover Opening Debit Turnover in Local Currency Opening Credit Turnover Opening Credit Turnover in Local Currency Debit Turnover Debit Turnover in Local Currency Credit Turnover Credit Turnover
6. Movement in Local Currency Opening Credit Movement in Local Currency Debit Balance Credit Balance Debit Balance In Local Currency Credit Balance In Local Currency Debit Movement Credit Movement Debit Movement In Local Currency 10000 Credit Movement In Local Currency oO Assume that the following entry is posted into 1 GAAP DR CR Branch GL Code System Account Posting Date Amount 5 12 ORACLE This is a back period entry As a result the system will update Posted into Past Period turnovers for the period Q3 and Posted from Future Period turnovers for period Q2 Following is the balance of the system account S1 for Q3 Balance Type Branch Code CHO System Account Currency Financial Cycle FY2008 Financial Period Q3 GL Code GAAP Code Opening Debit Balance Opening Credit Balance Opening Debit Balance in Local Currency 5000 Opening Credit Balance in Local Currency Opening Debit Movement Opening Credit Movement Opening Debit Movement in Local Currency Opening Credit Movement in Local Currency Debit Balance Credit Balance Debit Balance In Local Currency Credit Balance In Local Currency Debit Movement Credit Movement Debit Movement In Local Currency Credit Movement In Local Currency This entry has updated the Posted into Past Period turnovers of the balance record for period Q3 Since it is a back dated entry the system has changed the opening balance to 5000 Debit 5
7. branch entries the system resolves the inter branch accounting setup and passes extra pairs of entries Example Consider the following entries passed by the external system DR CR Account Branch Account Currency Posting Date Amount Oracle FLEXCUBE general ledger will resolve the inter branch maintenance and pass extra pairs of entries to balance the books at each branch Now suppose that the inter branch scheme is DIRECT the system will pass the following entries In the books of BR1 DR CR Account Branch Account Currency Posting Date Amount 6 8 ORACLE DR CR Account Branch Account Currency Posting Date Amount fem four fuse fmo fromm In the books of BR2 ncn Aco eranen co coran posing Anau o fee arme uso ms fioo If the inter branch accounting scheme is THRURO or THRUHO the system routes the inter branch entries through Regional Office or Head Office respectively On such circumstances the number of system generated entries will be more 6 3 2 3 Position Accounting In Oracle FLEXCUBE you may track the currency positions by passing position entries Position GLs are linked to FGLs using Chart of Accounts screen Each general ledger can have multiple sets of position and position equivalent GLs for different currencies If you have not linked a position GL the system uses the position GLs maintained on the Currency Maintenance screen Example Suppose that the l
8. codes that are applicable for the organization using GAAP Maintenance screen in Oracle FLEXCUBE You can invoke this screen by typing EGDGPMST in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 15 ORACLE 4 9 1 GAAP Maintenance GAAP Code Description haker Date Time Mod Ho Checker Date Time Record Status Authorization Status Here you need to specify the following details GAAP Code Specify a code to identify the GAPP that you are maintaining This code will be the unique identifier for the GAAP GAAP Description Enter a brief description of the GAAP Once you have specified the above details save the maintenance Linking a Branch to GAAP Codes You can link one or more GAAP codes to a specific branch using Branch GAAP Linkage screen Using this screen you may even link each branch to all the GAAP codes maintained You can invoke this screen by typing EGDBRNGP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 16 ORACLE 4 Branch GAAP Linkage Detailed Branch Code Branch Name GAAP Details 10f1 DET OO OOOO LI haker Date Time Mod Ho Checker Date Time Record Status Authorization Status Here you need to specify the following details Branch Code Specify the code to identify the branch to which you wish to link the GAAPs The option list displays all va
9. invoke the screen click System Account Elements button on the System Accounts Detailed screen 5 7 ORACLE System Account Elements System Account Elements 1011 B Element Code Element type Flement Name Flement Description Element Value LI 5 1 5 Processing System Account Generation The parameters for system accounts generation are maintained for a combination of GL and GAAP codes The following illustration will help you comprehend the process of system account generations in FGL Example Consider the following details e Transaction attributes1 and 2 are mapped to PRODUCT and TENOR respectively e SDE class INCOME is a set of transaction attributes PRODUCT and TENOR e SDE class INCOME is attached to the combination of the general ledger GL1 and GAAP G1 e Tenor in terms of range are as follows gt 0000 360 BCKT1 gt 861 999 BCKT2 e A number range class LDTNR is maintained for the above ranges and is attached to the tenor in SDE class INCOME Entry 1 GAAP DR CR Account Branch Account Currency Posting Date Amount Following are the transaction attributes PRODUCT LDO1 TENOR 300 Days This is the first entry to the GL The system generates a new system account S1 and posts the balance to it Entry 2 GAAP DR CR Account Branch Account Currency Posting Date Amount 5 8 ORACLE 5 1 6 9 1 7 Following are the tran
10. position GL to be used for the selected currency The option list displays all valid GLs maintained in the system You can choose the appropriate one Position Equivalent GL Specify the position equivalent GL to be used for the selected currency The option list displays all valid GLs maintained in the system You can choose the appropriate one In case you do not provide the above details the system takes the position GL and position equivalent GL information maintained at the Currency Definition level 4 8 ORACLE 4 4 4 3 4 Viewing Hierarchy Details You can view the hierarchy of the general ledgers connected to the current GL under the Hierarchy Details tab Child GL For The Current GL Child GL For The Current GL Imcacose Pesce pa Other GL Linked To This Parent GL Details E e o This tab displays all child GLs connected to the current GL It also displays a list of GLs that are linked to the parent GL of the current GL Maintaining Inter branch Parameters You can maintain inter branch parameters for passing inter branch entries You need to set the inter branch IB currency for each branch in the Interbranch Parameters Maintenance screen Here you need to capture the following details 4 9 ORACLE 4 5 Branch 1 and Branch Name Specify the code that identifies the first branch for passing interbranch entries Based on the branch code specified the system displays the branch name
11. 2 e Tenor is considered in the following ranges gt 0000 360 BCKT1 gt 361 999 BCKT2 e A number range class LDTNR is maintained with the above ranges It is attached to the tenor in SDE class INCOME 5 15 ORACLE 9 2 Entry 1 GAAP DR CR Account Branch Account Currency Posting Date Amount Following are the transaction attributes PRODUCT LDO1 TENOR 300 Days This is the first entry to the GL The system generates a new system account S1 and posts the balance to it Now suppose that the loan contract has been amended with an increase in the tenor The new tenor is 500 The external system will send this information during such an amendment and accordingly the system will adjust the balances by passing relevant adjustment entries As GL2 does not have any SDE class attached to it for GAAP G1 system does not pass any adjustment entry to adjust the balance in GL2 Whereas GL1 is attached to SDE class INCOME for GAAP G1 INCOME has TENOR as one of its attributes and that will result in a change in the system account to be used FGL determines the new system accounts and posts the balances to those accounts Assume that the new system account is S2 In the above scenario the system will generate the following entries GAAP DR CR Account Branch Account Currency Posting Date Amount Querying Balances In FLECUBE you can query and view the following balances e General Ledger Balance e Syst
12. Branch 2 and Branch Name Specify the code that identifies the second branch for passing interbranch entries Based on the branch code specified the system displays the branch name Due to Branch 1 This is the general ledger in Branch 2 into which the system passes the credit accounting entries Due from Branch 1 This is the general ledger in Branch 2 into which the system passes the debit accounting entries IB Currency for Branch 1 Specify the interbranch currency to be used for branch 1 The dropdown menu displays the following options e Account Currency e Transaction Currency If you select Account Currency as the IB Currency the system will pass inter branch entries in the account currency Otherwise it passes the entries in the transaction currency Due to Branch 2 This is the general ledger in Branch 1 into which the system passes the credit accounting entries Due from Branch 2 This is the general ledger in Branch 1 into which the system passes the debit accounting entries IB Currency for Branch 2 Specify the interbranch currency to be used for branch 2 The dropdown menu displays the following options e Account Currency e Transaction Currency If you select Account Currency as the IB Currency the system will pass inter branch entries in the account currency Otherwise it passes the entries in the transaction currency Descriptions The system displays the descriptions for each gen
13. Cash e Normal e Revaluation Parent GL and Description Specify the parent GL to which the current GL is associated Select the appropriate one from the option list Based on the parent GL selected the system displays the description 4 3 1 1 Specifying Position Accounting Details Positioning Required If you check this option the system will pass position entries for the specific general ledger If you uncheck it system will not pass any position entries Display on Report With You may opt to report the currency position under any of the following heads o Asset e Liability e Separate Here Separate an independent head other than Asset or Liability for reporting currency positions 4 3 1 2 Specifying the Restriction Details You may impose certain restrictions on the usage of the general ledger Oracle FLEXCUBE allows you to set the restrictions in the following fields Currencies You may create a GL that takes entries in terms of e A single currency e All foreign currencies e All currencies 4 4 ORACLE 4 3 1 3 4 3 1 4 Select the appropriate option from the dropdown menu If you choose to impose restriction on a single currency you have to specify the restricted currency Restricted Currency If you have chosen to impose restriction on a single currency specify that currency here The option list displays all valid currencies maintained in the system Select the appropriate one Branch Restricti
14. Class Details screen You can invoke this screen by typing EGDNORNG in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 5 4 ORACLE Number Range Class Details Class Code Class Description Number Range Details 101 OIT Tonumber OO OOO OOOO Maker Date Time Mod Mo Checker Date Time Record Status Authorization Status Here you can capture the following details Class Code Specify a class code to identify the number range class Class Description Enter a brief description on the nature of the number range class Add the bucket IDs to the list using add icon button Further enter the From Number and To Number to indicate the number range 5 5 ORACLE In order to define the date range class invoke Date Range Class Details screen You can invoke this screen by typing EGDDTRNGQ in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Date Range Class Details Class Code Class Description Class Details 101 TIE EA LI Maker Date Time Mod Ho Checker Date Time Record status Authorization Status Enter the following details Class Code Specify a unique code to identify the date range class Class Description Enter a brief description on the nature of the class Add more rows to the class details using add icon button Enter the bucket IDs in the space pro
15. Customer Details screen by typing EGDCMINF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button gt View Customer Details Customer MIS Reference Customer MIS Details 10 B MIS Class Class Description MIS Code Code Description heee You can query the MIS details based on customer MIS reference number The system will display the MIS classes codes and respective descriptions on this screen 5 21 ORACLE 9 3 Processing End of Day Operations During end of the day you can run a batch program for account revaluation for Oracle FLEXCUBE general ledgers As a result of the batch the system revalues the system account balances and posts the revaluation profit or loss into a predefined account You can set your preferences pertaining to account revaluation using Account Revaluation Setup screen You can invoke the Account Revaluation Setup screen by typing EGDRVSTP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Account Revaluation Setup GLSL Description Revaluation Details Re value into Transaction Code Revalue into SL Description Description Rate Type Netting Indicator Profit GL Lass GL Profit Description Description Trading Profit Account Trading Loss Account Description Description haker Date Time Mod Ho Checker Date Time Record Status Auth
16. Oracle FLEXCUBE General Ledger Oracle FLEXCUBE Universal Banking Release 11 3 83 02 0 April 2014 Oracle Part Number E53607 01 ORACLE FINANCIAL SERVICES Oracle FLEXCUBE General Ledger Table of Contents L OT Naa icono ela cocleares 1 1 1 1 INTRODUCTION neo 1 1 1 1 1 Audience uo ceccccccccccc na eseseececeee nae eeeeeeeeeeeaeeeeseeeeeeeaaaeeeeeeeeeGGaseeeeeeeeeeesaaeeeeeeeeeeeaaaeeseeeeeeeaaeaaaasseseeeeaaaaaaeeeess 1 1 1 1 2 OPCION oi 1 1 1 1 3 Related DOCUMENIS isa 1 2 1 1 4 CLOS Oy TOONS Susi R cad 1 2 2 ORACLE FLEXCUBE GENERAL LEDGER AN OVERVIEW ssssssssscccccccccccccssssseececececccccecccsssssssssee 2 1 2 1 INTRODUCTION paper popa 2 1 2 2 FEATURES OF ORACLE FLEXCUBE GENERAL LEDGER ccccccccccccncnncononanancnnnnnnnnncnnnnnnnnnnnnnnnnnnnnnnnnnnnccnnnnnnos 2 1 3 MAINTAINING GENERAL LEDGER PARAMETERS cccssscssccccccccccccccsssssssssssscsccsccesssssssesees 3 1 3 1 INTRODUCTION ara 3 1 4 SETTINGUPTHECHARTOF ACCOUNTS eisssssccssscencccesnstecsssacees cusnsteeseacenecdusnsticeoecsnec dusseitecsuesdvensteavteases 4 1 4 1 INTRODUCTION rrollo loose leen 4 1 Ae MAINTAINING CHART OB ACCOUNTS erre top aaia 4 2 4 3 SPECIFYING GENERAL LEDGER DETAILS paa 4 3 4 3 2 Linking a GL to the GAAP Cod S occcccocooooonncccnnnonononanononnnnnnnnnannnnnnnnonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnincnnnnnnnnnns 4 6 4 3 3 Speci yino Postion Detaili asias 4 7 4 3 4 Viewing Hierarchy Details ooooeeeeeeennnnennsseeeeeenenes
17. P In the above scenario MIS balance will be adjusted as shown below The net profit 10 000 will be adjusted in the ration of current balances LCY adjustment for MIS Code TMISCODE1 10 000 50 000 x 20 000 LCY adjustment for MIS Code TMISCODE2 10 000 50 000 x 30 000 If n case it gets a differential the system will adjust the same by rounding it off against the MIS code with the maximum balance In the above scenario the MIS code will be TMISCODE2 Automatic Financial Closure Oracle FLEXCUBE automatically triggers Oracle FLEXCUBE General Ledger financial closure on the last day of the financial cycle You have maintained year end profit and loss GLs in the Chart of Accounts Maintenance screen The system moves the income and expense balances into those year end profit and loss GLs respectively The system applies the break up schemes defined at the same level while generating system accounts for PNL entries This process is initiated within the financial period FIN of the financial cycle For Oracle FLEXCUBE general ledgers the system attaches an SDE class of type Balance to the year end profit and loss GLs The system uses this SDE class and the attributes of the balance being transferred to generate the system accounts However for such entries if the SDE class is of any type other than Balance the system displays an error message Web Services Available for FGLs In case of general ledgers you may use t
18. T O O EST O CI mic CT O CO oma O CS O Customer Accounts Amount in Posting Currency NUMBER Y for foreign currency only E A E currency only E CA EEE mower IN Transaction Attribute Reference VARCHAR2 50 N Number Customer MIS Reference VARCHAR2 6 6 ORACLE lt lt lt lt 6 3 2 Posting Journal Entries You can use FGL to post entries into the general ledgers using Journal Entries Detailed screen You can invoke the Journal Entries Detailed screen by typing EGDJRENT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Journal Entries Detailed Batch Reference Branch Code Source Code Branch Name Entries 10f1 B Serial Number Account Number System Account Number Value Date Amount In Posting Curre d Balancing Check Transaction Details Customer MIS Details Maker Date Time Mod No Checker Date Time Record Status Authorization Status On this screen you need to capture the following details Batch Reference As you select New from the action menu the system generates a batch reference number Source Code If the entry is posted through front end system displays the source code as Oracle FLEXCUBE Otherwise it displays the source code of the external source Branch Code The system displays the branch code of the current branch Branch Name Based on the branch code specified the s
19. alance online However you may push this activity to the end of the day by unchecking this option System Account Update Online The system updates the system accounts by default However you may push this activity to the end of the day by unchecking this option Value Date Balancing Check If you check this option the system will check for date wise currency debit credit balance mismatches during EOD processes In case of mismatch the system will display an error Move Balances on SDE Change There can be cases wherein a change in the transaction attributes or MIS cause a change in the system accounts associated with an entry Under such circumstances if you have checked this option the system will adjusts the accounting entries posted for that particular transaction 3 2 ORACLE 4 Setting up the Chart of Accounts 4 1 Introduction Oracle FLEXCUBE supports a multilevel structure for your bank s Chart of Accounts You can create broad groups of accounts in the categories of assets liabilities income expenses etc and further divide these groups into several levels The groups at each of these levels are referred to as GLs However there is no limit to the number of levels that can be maintained in the hierarchical structure of GLs In Oracle FLEXCUBE you may create a GL structure as follows GLO1 Ultimate Asset Node level L GL11 Cash in Hand Node Level 1 GL12 Comporate Assets Node Level 1 GL21 C
20. ancial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2005 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to
21. ash Ledger Vault1 GL22 Cash Ledger Vault2 GLA Trade Assets Node Level 2 GL25 Lending Assets Node Level 2 gt L31 Trade Assets Purchased GL32 Trade Assets Discounted 4 1 ORACLE 4 2 Maintaining Chart of Accounts You can maintain a multilevel GL structure using the Chart of Accounts Maintenance screen You can invoke this screen by typing GLDCHACT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button To define the details of a new GL click new icon on the toolbar Chart of Accounts Maintenance GL Code nnnannnnnn Description GL Details SL Linkages Reporting Lines C Revaluation C Report As Accrual C Avg Bal Required PHL Revaluation Details C EOD Reval Of FCY Entries Single Entry C EOD Reval Of FCY Entries Entry Pair Fi EOD Reval Of FEY Reversals C Repost FCY Entries in LCY Intraday Posting GL az Branch Restriction O Head Office GL Branch GL Both External Code Customer Internal GL C Customer GL Internal GL GL Type v GL Category f v Position Accounting Details _ Positioning Required Display On Report With Asset Liability O Separate Posting Restrictions Direct Posting Indirect Posting C Back Period Entry Allowed Leaf GL Currency Restrictions Currency Reconciliation Leaf GL Node GL C Blocked C Transfer Balanc
22. bar and clicking the adjoining arrow button 5 17 ORACLE GL Book Dated Balance Detailed Branch Code Currency Code Description Description GL Code Category Description Book Date GAAP Code Description Local Currency Parent GL Opening Balance Debit Balance Debit Movement Debit Balance LCY Debit Movement LEY Credit Balance Credit Movement Credit Balance LCY Credit Movement LEY Current Balance Debit Balance Debit Turnover Debit Balance LCY Debit Turnover LEY Credit Balance Credit Turnover Credit Balance LCY Credit Turnover LOY Here you can view the following details e Debit and credit opening balances and movements of the general ledger e Debit and credit current balances and turnovers in the general ledger You can query the general ledger balances by the following parameters e Branch Code e GL Code e GAAP Code e Currency Code e Booking Date 5 18 ORACLE 5 2 3 Viewing General Ledger Value Dated Balances You can view the balances in a general ledger and query it based on value date using GL Book Date Balance Details screen You can invoke the GL Book Date Balance Details screen by typing EGDGLVDB in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 GL Value Dated Balance Detailed Branch Code Currency Code Description Description GL Code Category Description Value Date GAAP Code Description Local Currency Parent GL
23. ccordingly Example Consider the following details Balance in the customer account 100 USD Credit Reporting GL credit G1 Reporting GL debit G2 Now suppose that the following entry is posted to the customer account Dr Customer Account 150 USD The system identifies the balance flip in the customer account and moves the balance from G1 to Q2 Then the system treats the above entry as shown Dr G1 100 USD Dr G2 50 USD This entry manages the movement of the account balance from the general ledgers G1 to G2 Tracking Balances of System Accounts FGL tracks the balances in system accounts general ledgers and MIS classes maintained in the system 5 9 ORACLE System accounts are the lowest level of entry points to the books of accounts General ledger balance is a consolidation of total balances of all such system accounts FGL tracks the following balances for each system account e Balances gt Opening Balance gt Opening Balance in Local Currency gt Current Balance gt Current Balance in Local Currency e Turnovers Opening Debit Turnover Opening Debit Turnover in Local Currency Opening Credit Turnover Opening Credit Turnover in Local Currency Debit Turnover Debit Turnover in Local Currency Credit Turnover Credit Turnover in Local Currency Y Vv VV VV WV WV The balances that the system updates could be e Book dated balances The system receives the branch date of the account branch and updates the b
24. e on MIS Reclassification C Reval Split Required Single Currency All Foreign Currencies All Currencies FH Direct Reconciliation Split Reconciliation i 1 BIC Statement Position GL Maintenance MIS Group Linkages Input By DOC4 Date Time Modification Number E Authorized IBAH Account Humber Other GL Linked To This Parent j Child GL For The Current GL Fields Cancel Authorized By Date Time Mi open GL Code In Oracle FLEXCUBE a GL is identified by a code Enter a unique code to identify the GL that you are creating The length and composition of the code depends upon the GL Mask defined in the Bank wide Parameters Screen The code that you enter can have a maximum of nine alphanumeric characters Description You can enter a brief description of the GL in this field You can use this description for the internal reference of your bank Level Oracle FLEXCUBE GL can be created in two levels e Node GL e Leaf GL A Node GL is one that reports to another GL and has other GLs reporting to it In the reporting relationship if a GL reports to another GL but no GLs report to it then it is a Leaf GL A Head GL is a Node that does not report to another GL The Chart of Accounts Maintenance screen is designed with four tabs 4 2 ORACLE e General Ledger Details Under this tab you can set up a GL indicate its type set the restrictions and def
25. ected the system displays the description You may add more rows to the list using add icon 6 3 ORACLE 6 2 1 Maintaining Customer MIS Details You can capture customer MIS details using Customer Details Detailed screen You can invoke the Customer Details Detailed screen by typing EGDCMSAT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Customer Details Operation Reference Customer MIS Reference Customer MIS 01 Customer MIS 06 Customer MIS 02 Customer MIS 07 Customer MIS 03 Customer MIS 08 Customer Mls 04 Customer MIS 09 Customer MIS 05 Customer MIS 10 haker Date Time Mod Noa Checker Date Time Record Status Authorization Status Here you need to capture the following details Operation Reference The system displays the operation reference number Customer MIS Reference Specify the customer MIS reference number The system will use this reference number while posting entries for FGL You can maintain a maximum of 10 MIS codes corresponding to 10 MIS classes However if you wish to modify the data sent you will have to provide all existing information along with the modifications If the MIS information undergoes any change the system automatically adjusts the system account and MIS balance You can even capture the customer MIS information as name value pairs You can invoke the Customer Details Detailed scree
26. ed into the following chapters Chapter 1 About this Manual Gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Oracle FLEXCUBE General Ledger An Overview is a snapshot of the features and functionality that the module provides Chapter 3 Maintaining General Ledger Parameters Comprehends the steps involved in maintaining various parameters for Oracle FLEXCUBE general ledgers Chapter 4 Setting up the Chart of Accounts Details the procedure to set up a GL structure for your bank Chapter 5 System Accounts Comprehends the process of setting up system accounts and help you get a break up of the GL balances which provide the details on the various attributes of each transaction Chapter 6 Processing FGL Entries Details out the steps involved in the process of posting entries and the role of FGL in easing the task 1 1 ORACLE 1 1 3 Related Documents e The Oracle FLEXCUBE Procedures User Manual e The Oracle FLEXCUBE Operations User Manual e The Oracle FLEXCUBE Core Services User Manual e The Oracle FLEXCUBE Core Entities User Manual 1 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons New Delete Unlock Close ENE p Reverse Template E Roll over Hold Authorize Exit Help Add row ORACLE Option List Enter Query Execute Query Refer the Procedures User Manual for furt
27. eesecccccnaseceeeccnaseseccceaeeeccceassesccscaseesccsaaseescceeaseeseeseaes 5 8 5 1 6 Processing General Ledgers for CUStOMETS oocooocooononnnnnnnnnnnononnncnnnnnnnnnnnccnnnnnnnnnnnrnnnnnnnnnnnnncnnnnnnnnnnns 5 9 LT Tracking Balances of System CCOUNES oooncccnncnnonnonnnnonnnnnnnnnnnanonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnncnnnnnnnnnnnos 5 9 5 1 8 Tracking General Ledger Balances oooooooocoooooononononnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnannnnnnnnnos 5 14 5 1 9 Tracking MIS Balances ainia tii eR 5 15 5 1 10 Adjusting Balances ainia 5 15 32 OUPRENG BALANCE e A E 5 16 5 2 1 Viewing General Ledger Balances oooccccccnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn ono aaa ESSE EEES 5 17 3 2 2 Viewing General Ledger Book Dated Balances oooccccnoonnoonnnnnnnnnnnononnnnnonnnnnnnnnnnnnncnnnnnnnnnnnacnnnnnnnnos 5 17 5 2 3 Viewing General Ledger Value Dated Balances oooooonncnnccnnnnnncnnnnnnnonnnannnnnnnnnnnnnnnnnnnnnnnnnnnannnnnnnnnnss 5 19 5 2 4 Viewing Transaction Details oooonnccnnnnnnoonnnnnonnnnnnnnnonononnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnrnnnnnnnnnnnnnnnnnnnnnnnnos 5 20 D250 Viewing Customer MIS Details ccccccccccsscccccccccccccseseseeceeeeeeaeseseeeeeeeeaaeesseseeeeeeseaaaeeeeeeeseesaaaeeeeeeeeeeaas 5 21 5 3 PROCESSING END OF DAY OPERATIONS si ccsscecestcasssoustiaonastasiatontsassuansvauarteesanecestsdleneasnauansseuesecensaanouenodoned 5 22 5 3 1 Tracking MIS Balances fo
28. em Account Balances e MIS Balances In this section we will examine how Oracle FLEXCUBE helps you view these balances 5 16 ORACLE 5 2 1 Viewing General Ledger Balances You can view the period wise balances in a general ledger using GL Period Balance Details screen You can invoke the GL Period Balance Details screen by typing EGDLINE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Reporting Line Maintenance Branch Code Type of Line Head Office Line Line Code Central Bank Line Line Description Line Level Leaf Line Category Mode Line Parent Details Farent Line Line Description haker Date Time Mod No Checker Date Time Record Status Authorization Status Here you can view the following details e Debit and credit opening balances and movements of the general ledger e Debit and credit current balances and turnovers in the general ledger You can query the general ledger balances by the following parameters e Branch Code e GLCode e GAAP Code e Currency Code e Financial Year e Period Code 5 2 2 Viewing General Ledger Book Dated Balances You can view the balances in a general ledger and query it based on booking date using GL Book Dated Balance Detailed screen You can invoke the GL Book Dated Balance Detailed screen by typing EGDGLBDB in the field at the top right corner of the Application tool
29. eral ledger selected in the respective fields Maintaining Currency Positions FGL provides you an option to maintain position general ledger and position equivalent general ledger for a currency In case position information is not maintained in Chart of Accounts Maintenance screen system picks up the details of position and position equivalent GL from Currency Position Details screen 4 10 ORACLE gt Currency Position Details Currency Code Currency Mame Position GL Position Equivalent GL Description Description Waker Date Time Checker Date Time hod Mo Record Status Authorization Status Enter the following details Currency Code and Name You may define the position GL and position equivalent GL for each currency Select the code that identifies the currency for which you wish to specify the details The system displays the Currency name accordingly Position GL and Description Specify the position GL to be used for the selected currency The option list displays all valid GLs maintained in the system You can choose the appropriate one Based on the GL selected system updates the description Position Equivalent GL and Description Specify the position equivalent GL to be used for the selected currency The option list displays all valid GLs maintained in the system You can choose the appropriate one Based on the GL selected system displays the description 4 11 ORACLE 4 6 4 7 Ma
30. ferent account for posting these entries Select it from the option list which displays all GLs maintained in the system The system displays the description based on the GL selected Profit GL and Description If the result of GL revaluation is a profit the system credits the profit amount to the profit GL that is specified here Similarly if you have opted for revaluation split for the GL then the revaluation profit as opposed to the trading profit is posted into this profit GL On revaluation split the system segregates the revaluation profit loss into e Trading Profit Loss Profit or loss due to revaluation of FCY entries posted into the GL during the current day e Revaluation Profit Loss Profit or loss due to revaluation of opening FCY balances excludes current day s turnover Trading Profit Account and Description If you have opted for revaluation split you need to specify the trading profit account into which the profits of trading revaluation should be posted The system displays the description based on the account selected Loss GL and Description If the result of revaluation is a loss the system debits the loss amount to the loss GL specified here If you have opted for revaluation split then the revaluation loss as opposed to trading loss will be posted into this GL Trading Loss Accounting and Description If you have opted for revaluation split you need to specify the trading loss account int
31. for generating system accounts Class Description The system displays the description of the selected SDE class Similarly you may add more rows to the list and link any number of GAAP codes to the GL Once you have specified the above details save the linkage maintenance As a result the system posts all entries to the GL in the books of linked GAAPs 4 18 ORACLE 5 1 5 1 1 5 System Accounts Introduction System accounts are the lowest level at which accounting entries are posted in Oracle FLEXCUBE The system stores FGL balances at this level System accounts help you get a break up of the GL balances which provides the details on the various attributes of a transaction You may configure all such parameters for the generation of system accounts in Oracle FLEXCUBE System Defined Elements You need to set certain parameters called System Defined Elements for generation of system accounts You can map a system defined element to an actual transaction using SDE Maintenance Detailed screen Oracle FLEXCUBE collects the data required for system account generation from the details maintained on this screen You can invoke this screen by typing EGDSDMST in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button System Defined Element Details System defined Elements ea gt Element Type Element Id Description Element Code Data Type Maximum Length Minimum Lengt
32. h Range Required Active Maker Date Time Mod Ho Checker Date Time Record Status Authorization Status Here you need to capture the following details Element ID Select an element ID from the dropdown menu However if the element type is chosen as transaction attribute you may maintain a maximum of 30 elements in FGL Similarly you may maintain a maximum of 20 elements of transaction MIS code and 10 elements of customer MIS code Element Type and Description For an FGL you may set one of the following system defined element types e Transaction Attributes In FGL you can maintain a maximum of 30 elements of transaction attributes Oracle FLEXCUBE has placeholders for transaction attributes You can map these attributes to the actual transaction details 5 1 ORACLE e Transaction MIS Codes You may maintain a maximum of 20 elements of transaction MIS codes for FGL Every transaction MIS class that you define for FGL will be considered as a system defined element e Customer MIS Codes The system converts all customer MIS classes that you create for FGL to system defined elements You can maintain a maximum of 10 elements of customer MIS classes for FGL e Entry Level Attributes Apart from the above the following entry level attributes influence the generation of system accounts gt Related Reference Related Account Financial Cycle Financial Period Posting Date Book Date Posting Currency Y Vv VW V V Y
33. he system to consider the value in ranges buckets Active Once the SDE is mapped the system checks this option and updates the status Based on the selected attributes and MIS codes Oracle FLEXCUBE generates the system accounts These system accounts belong to a specific GAAP Defining SDE Classes You can define System Defined Element Class which consists of various SDE codes in the SDE Class Details screen You can invoke this screen by typing EGDSDCLS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button SDE Class Details Class Code Element Class Type Class Description Element Class details 101 B Element ld Element Code Element Description Range Class LI Maker Date Time Mod Mo Checker Date Time Record Status Authorization Status Here you need to capture the following details Class Code Specify a unique code to identify the class Class Description Enter a brief description on the nature of the class Element Class Type You need to specify the type of SDE class that you are defining Select a type from the dropdown menu For FGL you may define the following element class types e Direct You may choose this class if you wish to post the entries directly If you choose this option the system will not generate the entries by itself Nor will it generate the entries as part of batch processes You may add the following elements to D
34. he web services provided by Oracle FLEXCUBE for the following purposes e To accept entries into the system e To provide GL balances to external systems The web services available for Oracle FLEXCUBE general ledgers are listed below e Entry Upload e Transaction Details Upload e Customer MIS Upload e GL Details Query e GL Balance Query gt Period Wise balance gt Book Dated Balances Value Dated Balances e System Account Balance Query gt Period Wise Balance gt Book Dated Balances gt Value Dated Balances e MIS Balance Query gt Period Wise Balance gt Book Dated Balances gt Value Dated Balances 5 25 ORACLE 6 1 6 2 6 Processing FGL Entries Introduction Oracle FLEXCUBE General Ledgers FGL eases the process of posting entries by capturing the entries transaction details and the customer MIS details separately yet maintaining a linkage FGL also identifies the entries posted from a deal in an external system Additionally FGL reduces the quantity of data to be exchanged while uploading files For every contract you may often have to post accounting entries at various stages However the transaction and MIS information of the contract may remain the same at those stages FGL helps you capture the transaction and MIS data initially and use the same information whenever similar entries are posted You may even capture transaction and MIS information along with each entry in Oracle FLEXCUBE In thi
35. her details about the icons T ORACLE 2 Oracle FLEXCUBE General Ledger An Overview 2 1 Introduction Oracle FLEXCUBE General Ledger FGL system is the pillar on which various functional components of Oracle FLEXCUBE rest Through this single entity you can consolidate and maintain balances and turnovers of all types of accounts your bank holds In addition this module helps you retrieve the information on the FGLs maintained for your bank FGL is a standalone general ledger system with the ability to define chart of accounts You may also use this module to keep a complete track of the ledger balances of your organization You need to create FGL structure at the bank level and maintain the same at different branches This structure helps you consolidate the GL balances and turnovers across modules and products You may further retrieve relevant information on the same online 2 2 Features of Oracle FLEXCUBE General Ledger Flexible GL structure Based on various types of accounts that you maintain at your bank GLs have been classified into the following categories e Asset e Liability e Contingent Asset e Contingent Liability e Income e Expense e Position e Position Equivalent A Head GL can be assigned any of the above categories Two Head GLs can have the same category All GLs that fall under a Head GL will essentially belong to the category defined for the Head Each category can have any number of GLs under it b
36. in Local Currency 5 1 9 Tracking MIS Balances MIS balance is the breakup of the general ledger balance based on MIS codes and MIS classes The sum of all MIS balances for a particular class will reflect the total GL balance The external system provides the details of MIS codes However if it does not provide the MIS code the system will consider the code as UNDEFINED The MIS balances will be updated accordingly 5 1 10 Adjusting Balances FGL identifies any change in the transaction data provided The change in the transaction data has an impact in the system account balances In that case the system may consider the balances as invalid if it is posted with the old data Hence whenever there is such a change the system readjusts the system account balances FGL will reverse the balances posted and rebook the balances in a new set of system accounts V Y VV VV WV WV This is an optional feature You can set your preferences related to the same at the Source Preferences level Example Consider the following details e The transaction attributes 1 and 2 are mapped to PRODUCT and TENOR respectively e SDE class INCOME is a set of transaction attributes PRODUCT and TENOR e SDE class attached for the combination of the general ledger GL1 and the GAAP G1 is INCOME e No SDE class is attached to the general ledger GL2 and GAAP G1 It indicates that the balance breakup of G2 is not required There will only be one system account for G
37. ine the debit and credit reporting lines e GAAP Linkages Using this tab you can link the GL to various GAAP codes e Position Details Under this tab you can define the position GL to be used for currencies e Hierarchy Details You can view the GL hierarchy connected to the GL that you are creating 4 3 Specifying General Ledger Details To define details for a GL click the tab General Ledger Details button on the Chart of Accounts Maintenance screen The details that you can specify for a GL depend on the type of GL that you create If a particular field is disabled it means that the field is not relevant to the type of GL that you are creating ES Chart Of Accounts Maintenance GLCode External Code LeafGL Leaf GL Description GL Details GL Linkages Reporting Lines C Revaluation C Repor As Accrual C Average Bal Required PNL Revaluation Details C EOD Revaluation Of FCY Entries Single Entry EOD Revaluation Of FCY Entries Entry Pair EOD Revaluation Of FCY Reversals C Repost FCY Entries in LEY Intraday Posting GL eal Branch Restriction Head Office GL Branch GL Both Customer Internal GL Customer GL Internal GL GL Type vi GL Category Position Accounting Details C Positioning Required Display On Repot Asset With Liability Separate Posting Restrictions Direct Posting Indirect Posting
38. intaining MIS Class Details In Oracle FLEXCUBE you can maintain MIS classes using MIS Class Maintenance screen Each MIS class that you maintain may contain a number of MIS codes based on the type of MIS that you choose Here you need to specify the following details MIS Class Enter a unique code to identify the MIS class that you are maintaining Description Enter a brief description on the nature of the MIS class You may use this description later to refer to the MIS class MIS Type Specify the type of MIS class that you are maintaining In Oracle FLEXCUBE you may maintain the following types of MIS classes e Transaction Class e Customer Class You may maintain a maximum of 20 Transaction MIS classes Similarly you can maintain a maximum of 10 Customer MIS classes in Oracle FLEXCUBE Each such MIS class maintained may contain several MIS codes MIS Code Specify the MIS code that you wish to add to the MIS class You may add more rows to the list of MIS codes using add icon on the screen Code Description Enter a brief description on the nature of the MIS code selected Maintaining Accounting Periods Oracle FLEXCUBE allows you to maintain various period codes that correspond to a specific financial cycle for Oracle FLEXCUBE general ledger You can use the Period Code Maintenance screen to do the same You can invoke this screen by typing STDACPER in the field at the top right corner of the A
39. ion Details you can add more information on transaction attributes You can add more attributes to the list using add icon Here you need to specify the following details Attribute Code Specify the attribute code Attribute Description Based on the attribute code the system displays the description 6 2 ORACLE Attribute Value Specify a value for the selected attribute code FGL generates system account number based on this value For instance in case of Attribute PRODUCT attribute value will be LD However you need to define the same based on the parameters set in SDE Class Definition screen Similarly you can capture the transaction MIS details on this screen To enter the details click Transactions MIS Details button on Transaction Details Detailed screen gt Transaction Details Operation Reference Transaction Attribute Reference Transaction detail Transaction MIS details Transaction MIS details 101 B MIS Code Code Description MIS Class Class Description _ a LI Maker Date Time Mad No Checker Date Time Record Status Authorization Status You need to capture the following details pertaining to transaction MIS MIS Class and Description Specify the MIS class for the transaction Based on the class code selected the system displays the description MIS Code and description Specify the MIS code that you wish to add to this operation Based on the MIS code sel
40. irect class 5 3 ORACLE Transaction Attributes Transaction MIS Codes Customer MIS Codes gt Entry Level Attributes Vv V WV e Derived You may use this class when external systems post the entries Inter branch entries generated by the system is an instance of this You may add the following SDEs to Derived class gt Transaction Attributes gt Transaction MIS Codes gt Customer MIS Codes gt Entry Level Attributes e Balance When system accounts are generated based on the balances you need to define a Balance class You can add all balance attributes to the Balance class You need to attach Balance SDE class for Revaluation Profit and Loss GLs Position Position Equivalent GLs and Year Profit and Loss GLs Element Code Specify the element codes that you wish to add to the class The option list displays respective valid element codes maintained in the system You can select the appropriate one You may add more rows to the list of element codes using add icon Element Description The system displays the description based on the element code selected Range Class Specify a range class to which the selected element code belongs Select the appropriate one form the option list Defining Number and Date Range Classes You can define number range classes and date range classes for FGLs in Oracle FLEXCUBE using the Number Range Class Maintenance screen To define a number range class invoke Number Range
41. lid branch codes maintained in the system Choose the appropriate one Branch Name Based on the branch code specified the system displays the name of the branch GAAP Code Specify the GAAP code that you wish to link to the branch The option list displays all valid GAAP codes maintained in the system Choose the appropriate one Description Based on the GAAP code selected the system displays the description Once you have specified the above details save the linkage maintenance As a result the system posts the entries in the books of GAAPs that are linked to the specific branches 4 17 ORACLE 4 9 2 Linking a GL to the GAAP Codes You may link a general ledger to one or more GAAP codes using GAAP Linkage tab of Chart of Accounts Maintenance screen Chart of Accounts Maintenance GL Code Level Leaf Description Mode General Ledger Details GAAP Linkages Position Details Hierarchy Details GAAP Details 101 MY GAAP Code Description SDE Class Description Maker Date Time Checker Date Time hod Ho Record Status Authorization Status You need to specify the following details on this screen GAAP Code Specify the GAAP code that you wish to link to the selected GL The option list displays all valid GAAP codes maintained in the system Select the appropriate one GAAP Description Based on the GAAP code selected the system displays the description SDE Class Specify the SDE class to be linked
42. me Record Status Authorization Status On this screen you need to capture the following details 4 14 ORACLE 4 9 Source Code Specify the source code of the external system The preferences that you have set on this screen will be applied to this system Source Description The system displays the description of the source code specified Generate Position Entries If you wish Oracle FLEXCUBE to generate the position entries check this option If you uncheck it the external system will handle the position entries Move Balances on SDE Change There can be cases wherein a change in the transaction attributes or MIS cause a change in the system accounts associated with an entry Under such circumstances if you have checked this option the system will adjusts the accounting entries posted for that particular transaction Balancing Check If you check this option the system will check for debit credit balancing of the batch of entries sent by the external system Value Date Balancing Check If you check this option the system will check for balances based on the value date Batch of entries sent by the external system will balance for debit credit by the value date If there is a mismatch the system will display an error message or a warning based on the configurations set Once you have set your preferences save the settings Maintaining GAAP FGL is a multi GAAP accounting system You can maintain various GAAP
43. n Authorized Date Time Date Time Number Open You need to specify the following details under this tab GAAP Code Specify the GAAP code that you wish to link to the selected GL The option list displays all valid GAAP codes maintained in the system Select the appropriate one GAAP Description Based on the GAAP code selected the system displays the description SDE Class Select the SDE class to be linked to the GL for generating system accounts Class Description The system displays the description of the selected SDE class You may add more rows to the list and link any number of GAAP codes to the GL Once you have specified the above details save the linkage maintenance As a result the system posts all entries to the GL in the books of linked GAAPs Specifying Position Details You can enter the details on position accounting under the Position Details tab If you have checked the option Position Accounting Required under the General Ledger Details tab you have to specify the details pertaining to the position accounting 4 7 ORACLE Position GL Maintenance GL Code Position GL Maintenance E currency Position GL Position Equivalent ol las Here you can capture the following details Currency Code You may define the position GL and position equivalent GL for each currency Select the code that identifies the currency for which you wish to specify the details Position GL Specify the
44. n by typing EGDCMSDT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 6 4 ORACLE 6 3 Customer Details Operation Reference Customer MIS Reference Customer MIS Details 10 MIS Code Code Description MIS Class Class Description _ lt gt LI haker Date Time Mod Mo Checker Date Time Record Status Authorization Status You can enter the following details MIS Class and Description Specify the MIS class for the transaction Based on the class code selected the system displays the description MIS Code and Description Specify the MIS code that you wish to add to this operation Based on the MIS code selected the system displays the description You may add more rows to the list using add icon Uploading Entries Oracle FLEXCUBE general ledger receives entries uploaded in specific formats lt can receive entries from external systems through Entry Upload Request of Web Services FGL will process such entries You can send the entries directly to the system accounts However an external system can post such entries only to manually created system accounts FGL can receive all attributes along with each entry Separate records with unique reference number may also be sent Such records can be linked with respective entries 6 5 ORACLE 6 3 1 Upload Details You can upload the following details anm CC CA ESTE wowe po TI E o E
45. o which the losses of trading revaluation should be posted The system displays the description based on the account selected Based on the preferences set on Account Revaluation Setup screen the system books profit and loss to the Profit GL and Loss GL respectively You may also direct the revaluation entries into another GL in order to stabilize the balance in the GL under revaluation For this purpose you may use the option Revalue into GL 9 3 1 9 3 2 9 4 Based on the revaluation results the system adjusts the position balances as well The system takes into account the positioning preferences of the GL under revaluation for this purpose Tracking MIS Balances for Revaluation Entries During GL revaluation the system updates the local currency balances of the GL This requires an adjustment in the MIS balance breakup of the GL To tackle this the system has been configured in such a way to update the MIS balance for the revaluation entry For all MIS codes under each MIS class the system splits the net balance posted into the GL This splitting is based on the ratio of the current balances of the MIS codes Example Consider the following details Local currency USD Net profit posted into revaluation profit GL G1 in GBP 10 000 USD Current GBP balance of the GL 50 000 GBP MIS breakup for the transaction MIS Class TMIS1 is shown below MIS CODE Balance TMISCODE1 20 000 GBP TMISCODE2 30 000 GB
46. ocal currency for branch BR1 is USD The external system passes the following entries DR CR Account Branch Account Currency Posting Date Amount Suppose that the inter branch scheme is DIRECT The system will post the entries as follows In the books of BR1 CS Position Equivalent GL 1 Jan 08 8 000 6 9 ORACLE 6 3 2 4 Debit Credit Balancing Check You may perform a debit credit balancing check when data is received from an external system By default the option is enabled in FGL However you can modify it The system verifies the debit credit balances and displays an error message if it finds a mismatch For each GAAP FGL ensures the balancing of batches by branch 6 3 2 5 Posting Date wise Balancing Check For data received from external systems you can configure Oracle FLEXCUBE to check the balances by posting date However you need to set the configurations in the external system Further to completion of the check the system displays an error in case of errors and a warning in case of successful configuration 6 10 ORACLE 7 Screen Glossary 7 1 Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description GLDCHACT Chart of Accounts Maintenance STDACPER Period Code Maintenance 7 ORACLE ORACLE Oracle FLEXCUBE General Ledger April 2014 Version 11 3 83 02 0 Oracle Fin
47. on You can restrict access to the GL for e Branches only e Head office only e Both branches and head office Choose the appropriate option as applicable Blocked You may opt to restrict the entries from being posted to a GL by checking this option You can aptly use this option to stop entries to a GL temporarily No entries can be posted into a GL while it is blocked You can open a GL marked with blocked status by unchecking the blocked status box This feature is useful as you need not close the GL Blocking is temporary whereas closure is permanent Back Period Entry Allowed Using this option you can regulate the posting of entries into past periods Check this box to allow the system to post entries into back periods Specifying Revaluation Details You need to set your preferences as to revaluation for all leaf GLs Revaluation Check this option to enable revaluation of foreign currency balances You can revalue the balances of asset liability contingent asset and contingent liability GLs You can also revalue the balances in Income Expense GLs If you indicate that revaluation is applicable Oracle FLEXCUBE will revalue the GL during End of Day EOD processes Reval Split Required Check this option to indicate that you require trading split for the leaf GL Specifying Year End Profit and Loss Accounts In case of income and expense GLs the system will move the balances in the GLs to year end profit and los
48. ook dated balance e Value dated balances FGL updates the value dated balances based on the posting date sent by the external system e Period balances Based on the posting date the system receives the financial cycle and period code and updates the period balances The system maintains the opening balance based on the type of balance For instance in case of period balance opening balance refers to the balance at the beginning of the period 5 1 7 1 Handling of Back Dated Entries FGL receives back dated entries and updates the balances accordingly The following example illustrates the period balance tracking mechanism for back dated entries Example Consider the following system data Current Business Date 01 AUG 2008 Current Financial Cycle FY2008 Current Financial Period Q3 Balance of System Account S1 Balance Type Branch Code System Account 5 10 ORACLE Balance Type Balance Financial Cycle FY2000 Financial Period QT3 G1 Assume that the following entry is posted into S1 sp Balance in the system account S1 is updated as follows Balance Type kk ORACLE Balance Type Balance Branch Code System Account Currency Financial Cycle FY2008 Financial Period Q3 GL Code GAAP Code Opening Debit Balance Opening Credit Balance Opening Debit Balance in Local Currency Opening Credit Balance in Local Currency Opening Debit Movement Opening Credit Movement Opening Debit
49. orization Status Here you need to capture the following details GL SL Specify the code to identify the general ledger account for which you wish to set the parameters Description Enter a brief description of the general ledger account for which you wish to set the revaluation parameters Transaction Code and Description Specify the transaction code under which the accounting entries are posted to the revalued general ledger account Based on the transaction code the system displays the description Rate Type Specify the rate type that you wish to use for revaluation of the general ledger Netting Indicator You may wish to net the entries for all accounts linked to the GL code If you check this option the system will pass single consolidated entries each for profit and loss 5 22 ORACLE Revalue into GL and Description Specify the GL into which you wish to pass the revaluation entries The system will use this GL instead of the GL being revalued for passing the entries As a result the revaluation entries will not affect the balance in the GL that under revaluation The system will debit this GL account is if the result of revaluation is a profit On the other hand it will credit this GL if the result of revaluation is a loss By default this is the GL under revaluation For all non contingent GLs belonging to the asset or liability categories the system defaults to the GL being revalued You can specify a dif
50. pplication tool bar and clicking the adjoining arrow button 4 12 ORACLE 4 Period Code Maintenence Description fe Financial Cycle Period Group r 55 rr To TS OL E Input By Authorized By Modification Authorized Date Time Date Time Number Open Here you need to capture the following details 4 7 1 1 Specifying Financial Cycle Details Cycle Specify a unique name to identify the financial cycle corresponding to which you wish to maintain the period codes Description Enter a brief description of the financial cycle Start Date Specify the date of beginning of the financial cycle End Date Specify the day on which the financial cycle ends 4 7 1 2 Adding Period Codes The financial cycle defined above can be divided into different accounting periods To define individual accounting periods click on the first row under period code The system creates a period called FIN This is an open ended period coinciding with the last day of the financial cycle You can maintain the following parameters for each accounting period within a financial cycle Period Code Enter a code to identify the accounting period For example if your period length is a quarter you can enter Q1 for the first period Q2 for the second Q3 for the third and so on If your period length is a bimonthly you can enter BM1 BM2 If your period length coincides with a month you can input M1 M2 4 13 ORACLE 4 7 2
51. r Revaluation Entries coccoooooonnnnnnnnnnnnononannnnnnnnnononanononnnnnnnnnnnncnnnnnnnnnnnnos 5 24 5 3 2 Amtomate Financial ClOSIY 6 criin a aa Aaa 5 24 54 WEB SERVICES AVAILABLE FOR FOLS ici 5 24 6 PROCESSING FGL ENTRIES sesecscsesecscsecsecsesecccsecseoccsecccsesecccsesesecsesecsesescesesececsescosesesecsesessesesessesessosesesees 6 1 6 1 NL O E E E E A E T E E 6 1 6 2 MAINTAINING TRANSACTION DETA S dis 6 1 6 2 1 Maimaiming Customer MIS Detalls aiii A RARAS 6 4 6 3 a EAEE 6 5 6 3 1 OO D a S E a AO ERO E ONE EOE EOE O TEO E EEEN 6 6 6 3 2 a I AE a ED RARA ados 6 7 Ta SCREEN GLOSSARY serrana a a 7 1 7 1 FUNCTION ID EST a aiii 7 1 ORACLE 1 About this Manual 1 1 Introduction This Manual is designed to help you quickly get acquainted with the Oracle FLEXCUBE General Ledger FGL system of Oracle FLEXCUBE It provides an overview to the module and takes you through various steps involved in setting up FGL structure Maintenance of system accounts and processing of FGL entries You can obtain further information specific to a particular field by placing the cursor on the relevant field and striking lt F1 gt on the keyboard 1 1 1 Audience This manual is intended for the following User User Roles To define the FGL structure Operations Managers Officers Authorization functions Financial Control To generate reports on FGLs MIS Operators Generation of reports 1 1 2 Organization This Manual is organiz
52. r to include a GL under a Head Office reporting line you should associate it with debit and credit reporting line Debit Line The Head Office debit line indicates the line to which an account under a GL should report if in debit Credit Line You can indicate the line to which an account under a GL should report if in credit You can select the reporting lines from the option list The option list displays all lines maintained in the Reporting Line Maintenance screen The system displays the description of each reporting line based on the selection The debit and credit reporting lines you define for a leaf can be the same Once you have made the required entries save the maintenance Linking a GL to the GAAP Codes You may link a general ledger to one or more GAAP codes using GAAP Linkage tab of Chart of Accounts Maintenance screen 4 6 ORACLE 4 3 3 4 Chart Of Accounts Maintenance GLCode External Code LeafGL Leaf GL Description O Node GL GL Details GL Linkages Reporting Lines Previous Year Adjustment GL Previous Year m Adjustment GL Year End Profit amp Loss Accounts Profit Account Loss Account m Parent GL Parent GL Description Category Statement Position GL Maintenance MIS Group Linkages IBAN Account Number Other GL Linked To This Parent Child GL For The Current GL Fields Input By Authorized By Modificatio
53. s accounts at the end of every financial cycle You need to specify the accounts in the following fields 4 5 ORACLE Profit Account and Description Specify the profit account to which you wish to move the GL balances at the end of the year The option list displays all valid profit accounts maintained Select the appropriate one Based on the account selected the system displays the description Loss Account and Description Specify the loss account to which you wish to move the GL balances at the end of the year The option list displays all valid loss accounts maintained Select the appropriate one Based on the account selected the system displays the description 4 3 1 5 Specifying Central Bank Reporting Lines 4 3 1 6 4 3 2 For Central Bank reporting purposes you should associate a GL with a debit and credit reporting line Debit Line and Description The Central Bank debit line indicates the line to which an account under a GL should report if in debit Credit Line and Description You can indicate the line to which an account under a GL should report if in credit You can select the reporting lines from the option list The option list displays all lines maintained in the Reporting Line Maintenance screen Based on the selection the system displays a description of each reporting line The debit and credit reporting lines you define for a leaf can be the same Specifying Head Office Reporting Lines In orde
54. s chapter you will find more information on processing of various transactions in Oracle FLEXCUBE general ledgers Maintaining Transaction Details You can maintain details pertaining to transaction attributes for FGL using Transaction Details Detailed screen You can invoke the Transaction Details Detailed screen by typing EGDTXNAT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button gt Transaction Details Operation Reference Transaction Attribute Reference Transaction detail Transaction MIS details Transaction Attribute 01 Transaction Attribute 02 Transaction Attribute 03 Transaction Attribute 04 Transaction Attribute 05 Transaction Attribute 06 Transaction Attribute 07 Transaction Attribute 08 Transaction Attribute 09 Transaction Attribute 10 Transaction Attribute 11 Transaction Attribute 12 Transaction Attribute 13 Transaction Attribute 14 Transaction Attribute 15 Transaction Attribute 16 Transaction Attribute 17 Transaction Attribute 18 Transaction Attribute 19 Transaction Attribute 20 Transaction Attribute 21 Transaction Attribute 22 Transaction Attribute 23 Transaction Attribute 24 Transaction Attribute 25 Transaction Attribute 26 Transaction Attribute 27 Transaction Attribute 28 Transaction Attribute 29 Transaction Attribute 30 haker Date Time Mod No Checker Date Time Record Status Authorization Status On this screen
55. saction attributes PRODUCT LDO1 TENOR 370 Days Primarily the system resolves the number range bucket as BCKT2 and checks whether a system account has been generated for that combination Again for such combination the system generates a new system account S2 and posts the balances to it Entry 3 GAAP DR CR Account Branch Account Currency Posting Date Amount Following are the transaction attributes PRODUCT LDO1 TENOR 250 Days Initially the system resolves the number range bucket as BCKT1 and checks whether a system account has already been generated for this combination In the above case system account S1 has already been generated for the GAAP G1 with the same transaction attributes Hence the system posts this entry to the system account S1 itself Processing General Ledgers for Customers Based on the parameters set for customer accounts Oracle FLEXCUBE sends customer account balances to asset and liability general ledgers based on their nature For an external system that reports the balances Oracle FLEXCUBE provides the following options e Receive the customer GL and update the balance e Directly receive the entries into the customer accounts along with the current balance of the account and its reporting GLs In the latter case based on the current balance and the entry FGL senses a difference in the account balance and adjusts the balances in the reporting GLs a
56. sssssssssssssseeerersssssssssssssssetereesssssssssssssssssseceereereesss 4 9 4 4 MAINTAINING INTER BRANCH PARAMETERS cccceeeeeeeeeesennnceeeeeeeceeeeeeeseeeeeesnaaceeeeeeeeeeeeeeeeeeeeeeeeeaaaeeeees 4 9 4 5 MAINTAINING CURRENCY POSITIONS eeeessseesseeesssssssrreesssssstrtesssssssereesssssssrreeesssseetteessssserreeessssseeeeeessssee 4 10 40 MAINTAINING MIS CLASS DETAILS urticaria 4 12 4 7 MAINTAINING ACCOUNTING PERIODS sirena cdta oran 4 12 4 7 2 Maintaining Transaction Codes ococcooooooonnccnnnnnnnnnnnnononnnnnnononnnnnnnnnnnnnnnnnnnnnnnnn nn ona nnnnnnnnnnnnnnnancnnnnnnnnnns 4 14 48 ADENTIPYING EXTERNAL SYSTEM Sada 4 14 Be NANA AA iio O E 4 15 4 9 1 Linking a Branch to GAAP Codes oocccooocoonnncnncnnnnnnnnnonnnnnnnnnnnnnnonnnnnnnnnnnnnnnnnnnnnnnnnnnrncnnnnnnnnnnnannnnnnnnss 4 16 4 9 2 Linking a GL to the GAAP Codes coin iia eds 4 18 3 IAS MEM ACCOUNTS is 5 1 5 1 INTRO OI k EI PTEE E A E seni ceased EAEE AE EE AA OAE 5 1 Dad System Defined Elements cccccccccssssssccecccccnansssececeecaaasseeeeeceaaaasseeeeeeesaaaaaseeeceeeaaagaaseeceesssaanaseeseeseaas 5 1 d2 Demne SDE CHG GCS aaa orita 5 3 5 1 3 Defining Number and Date Range Classes oooooooooonnncnnnnnonnnnnonnnnnnnononannncnnnnnnnnnannnnnnnnnnnnnnnnnnnnnnnnnnnos 5 4 5 1 4 Generating System Accounts MANUALLY ooccccnnooonannncconnnonononnncnnnnnononnnnnnonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnninnnnos 5 6 ye ee Processing System Account Generation cccccc
57. take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
58. ut the category allocated to a GL should be assigned at the head of any GL stream All nodes and leaves by default take the category of the Head GL to which they report At no other level you can assign a category Leaf GLs are merely points of contact through which all entries are passed to the nodes It is at the nodes that consolidation of all accounting takes place Therefore any specification like the Currency type or GL type though specified at the leaf GL will be applicable only for the respective node of that leaf Peripheral activities like linking a customer account to a GL or posting to a GL can be done only at the leaf All your profit and loss entries can be passed in LCY only however for reporting purposes you can also maintain a record of these in any FCY or even in all currencies This makes it possible to have multi currency GLs Along with this revaluation of currencies has also been provided 2 1 ORACLE 3 1 3 Maintaining General Ledger Parameters Introduction In Oracle FLEXCUBE you can maintain GL parameters using General Ledger Parameters Maintenance screen You can invoke the General Ledger Parameters Maintenance screen by typing EGDGLPRM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Enterprise GL Parameters Head Office Branch Reversal Indicator Flip DriCr C Consider Position Negative Entry Accounting Bank Le
59. vel Consol Handoff Default Transaction Code fae External Suspense General i Ledger UDF Details Input By Authorized By Modification Authorized Ki Date Time Date Time Number Open Here you need to specify the following details GL Period Check You can set GL period check to All or Current Based on your selection the system checks for debit credit mismatch in the balances of the financial periods If you select All the system runs the check for all period Similarly if you select Current the system runs the check for the current period alone Year End PNL GL Specify the code that identifies the Year End PNL GL The system uses the said GL for PNL transfer at the end of the year All balances in Income and Expense GLs will be moved to the selected GL in financial period FIN of every financial cycle Year End PNL TRN Code Specify the transaction code to be used while passing PNL entries at the end of the year 3 1 ORACLE Auto Gen Position Entry You may opt for position accounting in general ledger by checking this option If you check this the system will proceed with position accounting and generate the accounting entries GL Update Online If you check this option the system will update the GL balances regularly by default However you may push this activity to the end of the day by unchecking this option MIS Update Online If you check this option the system will update the MIS b
60. vided and specify the range 5 1 4 Generating System Accounts Manually You can manually generate system accounts using System Accounts Detailed screen Entries can be directly posted to these manually generated accounts You can invoke this screen by typing EGDSYSAC in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 5 6 ORACLE System Accounts Detailed system Account Number GAAP Code Description GL Code Description system Generated Alternate System Account Number system Account Description System Account Elements haker Date Time Mod No Checker Date Time Record Status Authorization Status The system displays the following details of the account e The system account number e The GL code associated with the system account and description e The GAAP code associated with the system account and description e Whether the account is generated manually or by the system If it is generated by the system the check box System Generated remains checked However you may modify the following details Alternate System Acc Number You can enter an alternative system account number and use the same for your reference System Account Description You can enter a brief description on the nature of the system account You can view the details of system defined elements and their corresponding values in the System Account Elements screen To
61. you need to capture the following details Operation Reference The system displays the operation reference number 6 1 ORACLE Transaction Attribute Reference Specify the transaction attribute reference You can use this reference while posting entries to pass on transaction data The system uses this reference number for all entries of the same nature so that you need not send the transaction data along with every entry However Oracle FLEXCUBE adjusts the system account balances only if the transaction data is sent separately with a transaction attribute reference This screen consists of two tabs e Transaction Details This section captures details of transaction attributes You can define a maximum of 30 attributes on this screen e Transaction MIS Details This section captures the details of transaction MIS You can define a maximum of 20 attributes You can even capture these details as name value pairs You can invoke the Transactions Details Detailed screen by typing EGDTXNDT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Transaction Details Operation Reference Transaction Attribute Reference Transaction detail Transaction MIS details Transaction detail 101 Nm Attribute Code Attribute Description Attribute Value EEE d Maker Date Time Mod Ho Checker Date Time Record Status Authorization Status Under the tab Transact
62. ystem displays the branch name Based on the preferences set the system processes the entries in the following order e Resolve inter branch entries e Prepare position entries e Run balancing check based on source preferences e Run a check for currency and value date balancing based on source preferences e Explode GAAP entries e Update the system account GL and MIS balances 6 3 2 1 Exploding GAAP Entries External systems may send entries to FGL for specific GAAPs as well as for all the GAAPs The following example illustrates how FGL handles GAAP entries 6 7 ORACLE Example Consider the following entries passed by an external system GAAP DR CR Account Branch Account Currency Posting Date Amount In the above table GAAP indication has been set to AL Hence the system resolves all applicable GAAP indicators for the combination of the branch BR1 and the general ledger GL1 Now assume that Applicable GAAPs for BR1 are G1 G2 and G3 Applicable GAAPs for GL1 are G1 G2 and G4 In such case the system resolves the applicable GAAPs as G1 and G2 as these are common for both BR1 and GL1 Further system prepares the GAAP wise entries as follows aso once en Bann Aon cureney posing bue Anan er fo far CCE me ce fo CO CCE froo 6 3 2 2 Inter Branch Accounting FGL passes inter branch entries based on source level preferences If external system preferences are configured in such a manner to generate inter

General Ledger (FGL) User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents