Querying Accounting Data

Overview


In order to analyze accounting data, one must be able to filter and aggregate the data. The structure of accounting data is usually fairly simple. It is generally organized as a table.

In Javascript, a table is econded as an array of objects. (see Javasript Tutorial)

Information on querying and transforming data can be found at : Querying and Transforming Data

Most accounting systems will maintain a chart of accounts. Such a chart is usually structured as a tree. When analyzing accounting data, it is often required to group accounts or transactions using the chart of accounts. This requires being able to use and query a tree structure. (see tree map library for information on the tree-mpa api)

Examples


Contents