Populating cells of an electronic financial statement
First Claim
1. A computer-implemented method of populating a financial statement having columns and rows, comprising:
- identifying an input database having columns as a source of input data for the financial statement, where data in the columns corresponds to a database period unit of time;
determining the database period unit of time;
receiving a statement period unit of time for base columns of the financial statement, where the statement period unit is greater than the database period unit;
comparing the statement period unit of time to the database period unit of time;
dynamically computing for each base column of the financial statement a correspondence to more than one column of the input database based on the comparison; and
populating cells of the base columns of the financial statement with cell formula expressions derived from the correspondence.
5 Assignments
0 Petitions
Accused Products
Abstract
A computer-implemented method of populating row and column cells of an electronic financial statement document containing with formulas and data, and related apparatus. A formula for a cell in a financial statement is generated from a row definition for the row and a column definition for the column of the cell, where the row definition defines a term of the statement and the column definition specifies a period of time. The resulting statement is displayed to a user, and new formula expressions can be generated to reflect changes in the statement. The statement can have three kinds of columns, namely base columns, subtotal columns, and grand total columns. Data in columns of an input database corresponds to a database period of time, and the base columns in the statement have statement period unit. For each base column of the statement, a correspondence to more than one column of the input database can be computed dynamically. The cells of the statement column can be populated using data from the corresponding database columns. The cells can be repopulated in response to a change in the statement period unit.
35 Citations
16 Claims
-
1. A computer-implemented method of populating a financial statement having columns and rows, comprising:
-
identifying an input database having columns as a source of input data for the financial statement, where data in the columns corresponds to a database period unit of time; determining the database period unit of time; receiving a statement period unit of time for base columns of the financial statement, where the statement period unit is greater than the database period unit; comparing the statement period unit of time to the database period unit of time; dynamically computing for each base column of the financial statement a correspondence to more than one column of the input database based on the comparison; and populating cells of the base columns of the financial statement with cell formula expressions derived from the correspondence. - View Dependent Claims (2, 3, 4, 5, 6, 13, 14)
-
-
7. A computer program residing on a computer-readable medium for causing a processor executing the computer program to populate an electronic financial statement having columns and rows, the computer program comprising instructions to:
-
identify an input database having columns as a source of input data for the financial statement, where data in the columns corresponds to a database period unit of time; determine the database period unit of time; receive a statement period unit of time for base columns of the financial statement, where the statement period unit is greater than the database period unit; compare the statement period unit of time to the database period unit of time; dynamically compute for each base column of the financial statement a correspondence to more than one column of the input database based on the comparison; and populate cells of the base columns of the financial statement with formula expressions derived from the correspondence. - View Dependent Claims (8, 9, 10, 11, 12, 15, 16)
-
Specification