Back to results
US 8,510,182 B2Granted
Systems and methods for managing and reporting financial information
AssigneeSap SE
InventorsDanny Pannicke, Artur Berlinger, Georg Dopf
Life of this patent
Estimating the term…
Abstract
Methods and system consistent with the present invention facilitate the management of financial information. Such methods and systems may receive transaction data, store the transaction data as a line item in a day ledger, receive a request for a report, the request indicating a financial figure, such as an average daily balance, to be generated over a specified time interval, and generate, substantially in real-time or during run-time per the request, a report with the financial figure over the specified time interval using data from the day ledger.
Claims37
A computer-implemented method of managing financial information, the method comprising:
- receiving, by a transaction processor, transaction data through a program interface;
- storing the transaction data as line items in a day ledger in a database, the day ledger representing the transaction data on a daily basis, the database further storing characteristics of the transaction data in accordance with a multi-dimensional data structure;
- periodically calculating based on the transaction data and storing as part of the transaction data at least a yearly figure, a monthly figure, and a weekly figure;
- receiving a request for a report from a user, the request indicating an average daily balance to be generated over a user-specified time interval, a selection of at least one of the characteristics of the transaction data, and an output type for the report, the user-specified time interval comprising a set of days beginning on a user-specified first day and including a day for which the transaction data was stored in the day ledger;
- generating, according to the request, the average daily balance over the user-specified time interval using the transaction data from the day ledger, wherein the average daily balance is calculated by dividing an aggregate balance over the user-specified time interval by a number of days in the set of days;
- and
- generating the report during run-time according to the request;
- providing, by a drill-down processor, the report in the output type indicated by the request, the report comprising the generated average daily balance, average daily balance key figures, and the characteristic of the transaction data selected by the user, and the report providing a comparison of the average daily balance key figures over the user-specified time interval with other average daily balance key figures over a different time interval.
5 more elements
A monitoring system for presenting data, the system comprising:
- one or more processors;
- and
- a database, the database being adapted to store transaction data as line items in a day ledger and characteristics of the transaction data in accordance with a multi-dimensional data structure, the day ledger representing the transaction data on a daily basis;
- wherein the processors are configured to:
- receive the transaction data through a program interface;
- receive a request for a report, the request indicating average daily balance figures to be generated over a user-specified time interval, a selection of at least one of the characteristics of the transaction data, and an output type for the report, the user-specified time interval comprising a set of days beginning on a user-specified first day and including a day for which the transaction data was stored in the day ledger;
- periodically calculate based on the transaction data and store as part of the transaction data at least a yearly figure, a monthly figure, and a weekly figure;
- generate, in accordance with the request during run-time, the average daily balance figures over the user-specified time interval from the day ledger, wherein the average daily balance figures are calculated by dividing an aggregate balance over the user-specified time interval by the number of days in the set of days;
- and
- generating the report during run-time according to the request;
- provide a user with the report in the output type indicated by the request, the report comprising the generated average daily balance, average daily balance key figures, and the characteristic of the transaction data selected by the user, and the report providing a comparison of the average daily balance key figures over the user-specified time interval with other average daily balance key figures over a different time interval.
8 more elements
A tangible non-transitory computer-readable medium containing instructions to configure a processor to perform a method comprising:
- receiving transaction data through a program interface;
- storing the transaction data as line items in a database in a day ledger, the day ledger representing the transaction data on a daily basis;
- storing characteristics of the transaction data in accordance with a multi-dimensional data structure;
- periodically calculating based on the transaction data and storing as part of the transaction data at least a yearly figure, a monthly figure, and a weekly figure;
- receiving a request for a report of average daily balance key figures, the average daily balance key figures including an average daily balance, the request indicating a user-specified time interval for generating the average daily balance key figures and the user-specified time interval comprising a set of days beginning on a user-specified first day and including a day for which the transaction data was stored in the day ledger, the request further indicating a selection of at least one of the characteristics of the transaction data and an output type for the report;
- generating, substantially in real-time in response to the receipt of the request, the average daily balance key figures over the user-specified time interval using the transaction data from the day ledger, wherein the average daily balance is calculated by dividing an aggregate balance over the user-specified time interval by a number of days in the set of days;
- and
- generating the report during run-time according to the request;
- providing a user with the report in the output type indicated by the request, the report comprising the generated average daily balance, the average daily balance key figures, and the characteristic of the transaction data selected by the user, and the report providing a comparison of the average daily balance key figures over the user-specified time interval with other average daily balance key figures over a different time interval.
6 more elements
A system for managing financial information, comprising:
- a transaction processor for:
- receiving transaction data through a program interface via a communication channel;
- and
- periodically calculating based on the transaction data at least a yearly figure, a monthly figure, and a weekly figure;
- a database for:
- storing the transaction data as line items in a day ledger, the day ledger representing the transaction data on a daily basis;
- storing characteristics of the transaction data in accordance with a multi-dimensional data structure;
- and
- storing as part of the transaction data the yearly figure, the monthly figure, and the weekly figure;
- and
- a reporting processor for:
- receiving a user request for a report, the user request comprising a user-specified time interval having a set of days beginning on a user-specified first day and including a day for which the transaction data was stored in the day ledger, the user request further indicating a selection by a user of at least one of the characteristics of the transaction data and an output type for the report;
- generate an average daily balance by dividing an aggregate balance over the user-specified time interval by a number of days in the set of days, and
- generating the report during run-time according to the request;
- providing the report in the output type indicated by the request, the report comprising the generated average daily balance, average daily balance key figures, and the characteristic of the transaction data selected by the user, and the report providing a comparison of the average daily balance key figures over the user-specified time interval with other average daily balance key figures over a different time interval.
12 more elements
Dependencies are inferred from the claim text.