主权项 |
1. A computer system comprising:
a processor; at least one system interface operative to retrieve financial data of an organization according to a first schedule from at least one financial information management system, the financial data including transaction records for a plurality of accounts of the organization, each transaction record of the plurality of accounts associated with a corresponding invoice and a corresponding aging date, each corresponding invoice specifying an amount due, the transaction records identifying payments, adjustments and refunds; a data aggregation system operative to calculate for each of the invoices and transaction records of the plurality of accounts an age of the corresponding amount due relative to the corresponding aging date associated with the transaction record, an age of any corresponding payment relative to the corresponding aging date associated with the transaction record, an age of any corresponding adjustment relative to the corresponding aging date associated with the transaction record, and an age of any corresponding refund relative to the corresponding aging date associated with the transaction record, and according to predetermined rules to aggregate the invoices into corresponding invoice buckets based on the age of each invoice, the transaction records of the payments into corresponding payment buckets based on the age of each payment, the transaction records of the adjustments into corresponding adjustment buckets based on the age of each adjustment, and the transaction records of the refunds transaction records into corresponding refund buckets based on the age of each refund, the data aggregation system operative to aggregate the invoices and transaction records of the amounts due, payments, adjustments, and refunds according to a second schedule so that the invoice buckets, payment buckets, adjustment buckets and refund buckets remain substantially current and independent of whether a report generation request has been received; and a report generation system operative to receive the report generation request after the data aggregation system aggregates the invoices and transaction records of the amounts due, payments, adjustments, and refunds into the corresponding invoice buckets, payment buckets, adjustment buckets, and refund buckets, and to generate a financial report in response to receipt of the report generation request, the financial report being based on the invoices and the transaction records of the amounts due, payments, adjustments, and refunds as aggregated in the corresponding invoice buckets, payment buckets, adjustment buckets, and refund buckets, the financial report for assisting in evaluating a financial state of the organization. |