DSA Reporting Packages
General Ledger Transactions
Source Data: GL Transaction History Files, which contain GL journal entries and the postings from other modules such as Accounts Payable and Accounts Receivable. The level of detail available through GL reporting varies by ERP package and setup options selected. I.E. Some systems post individual AR invoice information (such as customer number/invoice number) to the General Ledger, but most systems summarize posting batches. The Out-of-the-box reporting will only include the level of detail already included in the GL postings.
Common Uses: designed to provide analysis for what types of journals are posting to different accounts or account groups, account segments, dates, etc. It can also provide rudimentary financial statement information (account balances at different dates). Out-of-the-box, balance sheet account current balances assume that a complete posting history is available to compile for the current balance at a specified date (or some beginning balance correction entries can be added to the DataSelf data warehouse).
Common Customizations: journal entries may be linked back to source data, Option Fields (User Defined Fields), or comments expanded to include such information as Customer, for a Customer-based Profit and Loss.
General Ledger Financials
This module consists of two parts: GL Income Statement and GL Balance Sheet.
Source Data: GL financial statement balances files. The lowest level of detail is the debits, credits, and ending balances for each GL account per fiscal month. The Income Statement includes two budgets, either from the ERP or from DataSelf’s General Ledger Budget, to provide Budget versus Actual comparative analysis.
Data Format: The cube technology supports the more sophisticated data structure found in financial statements. Financial statements require that the accounts be grouped into a varying number of subheading levels, that credit accounts be shown as positive numbers, and various subgroupings be added or subtracted from one another. (The cube’s “Parent-Child” dimensions provide this functionality.)
Standard Financial Statements: Because of its flexibility and ease of formatting, MS Excel is the preferred front end for most financial statement presentation. The cube structures in combination with Excel allow users a great deal of flexibility to easily customize financial reports (rearranging account groupings, adding calculations, and fine-tuning the formatting).
Other Financial Analysis: Both Excel and DataSelf Analytics can provide additional financial analysis and graphics, such as graphing the trend of the relationship between open Accounts Receivable against Net Income.
General Ledger Budget
This write-back cube uses Excel as the user interface to allow one or more users to enter and maintain one or more GL budgets simultaneously. Security options include specifying which GL accounts an individual user can see the historical postings for and/or maintain budgets for. Budgeting changes (once saved) are immediately visible to all authorized users within this cube.
The budget data is stored in a special SQL table and will be incorporated (during the next full data refresh) into a GL reporting module (usually GL Income Statement Cube) for Budget versus Actuals financial reporting.