Patent ID: 9020946
Filing Date: 2015-04-28
Classification: G06F,G06Q

Abstract:
1. A method of aggregating data in a computerized apparatus, the method comprising: obtaining a plurality of accounting records from a plurality of physical locations; storing the plurality of accounting records in a database associated with the computerized apparatus; extracting the plurality of accounting records from the database, each of the accounting records comprising an account identifier, an account name, and a parent account identifier, the parent account identifier comprising either: a top level account identifier, or a non-top level account identifier; for each of the plurality of accounting records, assigning that accounting record in the computerized apparatus as a top-level parent accounting record in a hierarchical structure when that accounting record comprises the top level account identifier, otherwise placing that accounting record into a data structure associated with the computerized apparatus; combining those top-level parent accounting records that share a common name using the computerized apparatus; for each of the plurality of accounting records placed into the data structure, when the parent account identifier associated with each accounting record matches the account identifier of the top-level parent accounting record, combining that accounting record into the hierarchical structure with its associated top-level parent accounting record using the computerized apparatus, otherwise leaving that accounting record in the data structure; for each of the plurality of accounting records whose parent account identifier does not match the account identifier of the top-level parent accounting record, combining that accounting record into the hierarchical structure when the parent account identifier for that accounting record matches the account identifier of an accounting record that has already been placed into the hierarchical structure using the computerized apparatus, otherwise leaving that accounting record in the data structure; repeating the act of combining the accounting record into the hierarchical structure using the computerized apparatus until no accounting records exist in the data structure; and generating a report using the computerized apparatus based at least on the hierarchical structure created.