Method and apparatus for storing and generating financial information employing user specified input and output formats

• US 5,189,608 A
• Filed: 02/15/1990
• Issued: 02/23/1993
• Est. Priority Date: 06/01/1987
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: IMRS Operations Incorporated
• Inventors: Nolan, Kevin F., Lyons, Richard J., Chu, Wah C.
• Primary Examiner(s): Hayes, Gail O.
• Application Number:
  US07/480,701
• Time in Patent Office: 1,104 Days
• Field of Search: 364/400, 364/401, 364/408, 11/11, 395/148
• US Class Current: 705/30
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

An advanced financial reporting and analysis software package is described. The package collects, organizes, manages and consolidates financial data and provides user defined capabilities for creating financial and corporate reports. Financial data is organized into four business classifications or dimensions: Schedule, Entity, Period and Type. Data is stored in the system in such a way that all data associated with a particular Schedule, Entity, Period and Type is identified by that particular SEPT value. To accommodate automatic data entry, a mapping means or template is provided that specifies for each different input spreadsheet the location of the first data cell in the spreadsheet and the size of the spreadsheet. Data is read from the data store by various report and spreadsheet generating functions which convert data associated with particular SEPT values to desired output formats.

Claims

1. In a computer, a method of storing and generating financial information of the type used in financial schedules comprising the steps of:

storing financial information in a first format in a storage means in which format each of a plurality of financial data values is associated with a set of at least three identifying attributes and some data values are associated with a set of attributes different from that associated with other data values;

specifying by user input to said computer a plurality of second formats in which are received data values to be stored in said storage means, each of said second formats associating each of a plurality of financial data value with one of said sets of at least three identifying attributes, whereby a plurality of user-defined data input templates are defined;

using said data input templates to convert data values received in each of the plurality of second formats into said first format and storing such data values in said storage means in said first format;

specifying by user input to said computer a plurality of third formats in which data values stored in said storage means are to be provided for output, each of said third formats associating a plurality of financial data values stored in said first format and associated with a first set of at least three attributes with a plurality of financial data values stored in said first format and associated with second set of at least three attributes, whereby a plurality of user-defined of data output templates are defined; and

using one of said data output templates to convert data values stored in said storage means to said third format.

2. The method of claim 1 wherein the identifying attributes are a financial schedule in which the financial information appears, a business entity to which the financial information pertains, and a period of time to which the financial information pertains.

3. The method of claim 2 wherein the identifying attributes further include a fourth attribute defined by the user.

4. The method of claim 1 wherein said financial information is output by:

specifying a particular type of schedule,

specifying a combination of attributes such as entity, period and type;

specifying a number of rows and columns in which to display output data, and

specifying the locations of the attributes on the display of output data.

5. The method of claim 1 wherein input data may be stored in multiple schedules.

6. The method of claim 1 wherein integrity checks and currency conversions are performed at time of input.

7. Apparatus for the storage and generation of financial information of the type used in financial schedules comprising:

means for storing financial information in a first format in which format each of a plurality of financial data values is associated with a set of at least three identifying attributes and some data values are associated with a set of attributes different from that associated with other data values;

first means for specifying by user input to said apparatus a plurality of second formats in which are received data values to be stored in said storing means, each of said second formats associating each of a plurality of financial data values with one of said sets of at least three identifying attributes;

means for using said first specifying means to convert data values received in each of the plurality of second formats into said first format and for storing such data values in said storing means in said first format;

second means for specifying by user input to said apparatus a plurality of third formats in which data values stored in said storing means are to be provided for output, each of said third formats associating a plurality of financial data values stored in said first format and associated with a first set of at least three attributes with a plurality of financial data values stored in said first format and associated with a second set of at least three attributes; and

means for using said second specifying means to convert data values stored in said storing means to said third format.

8. The apparatus of claim 7 wherein the identifying attributes are a financial schedule in which the financial information appears, a business entity to which the financial information pertains, and a period of time to which the financial information pertains.

9. The apparatus of claim 8 wherein the identifying attributes further include a fourth attribute defined by the user.