Oracle General Ledger

Oracle General Ledger ‘FSG’ Financial Statement Generator Training Course Overview

FSG Training : Course Aims • FSG features and Capabilities • Writing FSG components • Building FSG reports • ADI as a reporting Tool • Advanced reporting features • FSG strategy & procedures

Today’s Agenda • Overview of GL Set-up • Overview of FSG reports • Running reports in Oracle & ADI • Using different components • Standard examples of FSG reports • Basic Report Components • Row Sets • Column Sets

Overview of GL Set-up • Some terminology • Set of Books • Functional Currency • Accounting Calendar • Chart of accounts

Set of Books • Oracle terminology for the complete accounts systems of different business’s within the same system • One accounting calendar • One base currency • One chart of accounts(accounting structure)

Calendar • Year runs from 1st May to 30th April • 18 Periods in a year • 12 monthly periods • 4 Quarterly adjusting periods • 2 Year end adjusting periods • Once a period has been closed, should not be re-opened. • Reports can be run for any period including Adjusting • At year end the P&L is automatically swept to Retained Earnings

Management Accounting Calendar

Currencies • Each set of books has one functional currency (e.g... GBP) • This is the default currency for reports & transaction entry • All foreign currency entries are automatically included in functional currency balance • You cannot get a balance just for balances in functional currency, but you can report on balances of foreign entered currencies • Report in many entered currencies one report • ‘Translation’ allows reporting of whole TB in Foreign Currency

Currencies - Exchange Rates • Foreign -> functional currency • e.g... Euro - Sterling • Create a rate for each day • Standard Corporate Rates loaded automatically • Rate set on last day of previous month • Month end revaluation rates entered manually • Loaded to system via Reuters

Chart of Accounts • Accounting Flexfield • Account code security • The Chart of Account Structure

Accounting Flexfield • Oracle terminology for database field • Key flexfield (fundamental) • Max 30 segments • Specify a balancing segment • Specify a natural account segment • revenue, expense, etc.. • Segments independent of each other • Segments combined to form unique account codes ( CCID’s)

Account code security • Cross Validation Rules • Restrict how segments are combined • Security Rules • Restrict which values a user can use

Your Chart of Accounts Structure • Seg Name Default • Entity From Logon • Office From Logon • Group none • Account none • Local 000000 • Partner 0000 • Project 00000 • Year 0000 • Tax Year 0000 • Spare2 0000 Example of a full account combination 85.70.0000.16603.000000.0000.00202.0000.0000.0000

Chart of accounts - standards • All segments are global apart from the ‘Local’ segment • Cannot add values to the set-up without world firm approval • New combinations of existing segment values are created automatically • Parent accounts exist on main segments for reporting ( Group & Account )

FSG : Financial Statement Generator • Build your own custom reports without programming. • Define reports with complete control over the accounts, periods, calculations & submission

FSG : Features • Generate financial reports, such as income statements and balance sheets • Apply security rules to control financial information • Define your reports with reusable report objects • Design custom financial reports to meet specific business needs.

FSG : More Features • Print as many reports as you need, simultaneously. • Print the same report for multiple companies, cost centres etc, in a single submission. • Schedule reports to run automatically. • Produce ad hoc reports whenever you need them.

Basic Report Building Principles • Re-usable report components ( objects) • Row and Column set is required minimum. • Build advanced options into simple reports • Content Sets, Display Sets, Row Order & Level of detail.

Using Report Components

Oracle General Ledger