General Ledger Client Questionnaire.

S.No	Questionnaire for GL	Process type
1	What does your current chart of accounts look like.	Setup
2	Do you plan to have a new chart of accounts	Setup
3	Are your account values in any order or range pattern	Setup
4	What are the account parent or grandparent structures	Setup
5	Do you use unique accounts to capture statistics	Setup
6	Who is going to maintain the segment values once entered	Setup
7	Is there a need for a mapping from an old COA to a new COA	Setup
8	Are certain segment   values onlyy valid with specificother segment values	Setup
9	Do you use multiple currencies in your business	Setup
10	How many currencies do you use and what are they	Setup
11	What is your policy on changing currency rates	Process
12	What is the primary currency you have	Setup
13	Do you enter data in multiple currencies	Process
14	When is the beginning of your year	Setup
15	What is the period type. How many periods in a year.	Setup
16	Do all the companies have the same calendar	Setup
17	Do you have a naming convention for the periods	Setup
18	What accounting periods are in your quarters	Setup
19	How do you close an accounting period for Procurement	Process
20	Do you accrue your receipts to the General Ledger	Process
21	Does your company prepare budgets	Process
22	What types of budgets do you prepare  (for example, revenue & expenses, balance,     sheets, capital, project, and so on)	Process
23	Do your company’s key performance indicators drive the budgets	Process
24	How many budgets do you prepare for an individual fiscal year	Metric
25	Do you prepare more than one budget per Set of Books	Process
26	What is the range of accounting periods for each budget	Process
27	At what organization level (for example, cost center, division, or region) do you budget	Process
28	Do budgets require approval	Process
29	What levels of approvals are required for budgets	Process
30	How many budget "organizations" do you have	Metric
34	Will budget organization security be required in the future	Setup
36	At what account level do you currently budget	Process
37	Is your budgeting process centralized or decentralized	Setup
40	Do you require consolidated budgets	Setup
41	Are all budgets prepared in the same currency	Setup
42	Do you use Lotus, Excel, or another spreadsheet program to prepare budgets	Process
43	Which spreadsheet products and which version do/will you use	Setup
44	How do you close or "freeze" a budget once it is approved	Process
45	Is the process to close or "freeze" a budget once it is approved documented	Process
46	How long does it take to close or "freeze" a budget	Process
47	How long should it take to close or "freeze" a budget	Process
48	Is closing or "freezing" a budget a hard close or a soft close	Process
49	Who performs the tasks associated with closing or "freezing" the budget	Process
50	How are adjustments to closed periods and/or frozen budgets handled	Process
51	Are budgets altered frequently during the fiscal year	Process
52	Do you need to retain original (prerevision) budgets throughout the year	Setup
53	Is a budget download required to facilitate budget creation or maintenance	Setup
54	Do you derive any type of forecast from budgets	Setup
55	Does your company prepare financial forecasts	Process
56	What types of financial forecasts does your company prepare	Process
57	How do you prepare financial forecasts	Process
58	Is the financial forecasting process documented	Process
59	How long does it take to prepare financial forecasts	Process
60	How long should it take to prepare financial forecasts	Process
61	Are financial forecasts a hard or soft close	Process
62	Who performs the tasks associated with preparing financial forecasts	Process
63	How many forecasts do you prepare during an individual fiscal year	Metric
83	How do you maintain your Financial Reporting data	Process
84	How do you audit your Financial Reporting data	Process
85	Which operations/processes do you want to streamline for Financial Reporting	Process
86	Which operations/processes do you want to eliminate for Financial Reporting	Process
87	Are there any time-intensive Financial Reporting operations/processes that need to be addressed	Process
88	How do you close an accounting period for Financial Reporting	Process
89	Is the schedule to close an accounting period for Financial Reporting documented	Process
90	How long does it take to close an accounting period for Financial Reporting	Process
91	How long should it take to close an accounting period for Financial Reporting	Process

 

Account Monitor in Oracle Fusion General Ledger

 Account Monitor, one of the new feature introduced in Oracle Fusion Financials, provides Oracle Fusion General Ledger users with a tabulation of self-selected accounts and balances, with self-defined deviations from standards for those balances. The users can see anomalies against the thresholds that they define.

1. Navigation - General Accounting > General Accounting Dashboard

2.  View > Account Group > Create

 

3. Fill all the information and create the account group

4. Once Created It will appear on the dashboard

The amount appearing under month are drillable and we can drill down to the invoice/transaction level

1.      Click on the amount to drill down

1.      5. Further click the amount to drill to transaction level