Financial statement management with Excel template is a tool for defining the desired presentations of financial statements in a simple way using a tool familiar to many: Excel. Thus, authorized users of DCision ERP can define their own presentation of financial statements and other financial analysis of all kinds.
Most of you already use a spreadsheet such as Excel to make their financial statement presentations. They carry the numbers in their spreadsheet by importing data files generated by their financial system or worse, using the « copy and paste » functions from these files or other reports. These often heavy and laborious mechanisms are very vulnerable to the risk of error handling. Managing Financial Statements with Excel Templates allows you to modify your current presentation of financial statements and turn it into a template that will be reused each time you want to produce financial statements. This management takes care of calculating and entering into a reusable templates the financial data. It therefore becomes a quick and easy report to use without manipulation, thus avoiding the risk of errors.
Easy to use : Templates are defined by users using keys identifying the columns in which they want to see data, for example amounts for the current period, year to date, etc., (20 possible choices) for the actual and for budgets. At row level, selection filters on the gl or groups of gl are defined. A row can thus represent a single general ledger account or several accounts. When generating the financial statements, the system uses the template requested by the user and push the calculated data requested, either at the level of cells whose row contains a groups / GL filter and the column contains a key. Since templates are Excel files, macros, formulas and all other Excel features can be used and kept in templates.
Consolidated Financial Statements
It is possible to use these financial statement templates to generate consolidated financial statements, by identifying the desired company on each sheet of the spreadsheet. After having calculated the financial statements of the companies, the system automatically enters the results in the sheets corresponding to these companies. The consolidated data are obtained in other sheets with simple formulas referenced on the sheets containing the results of the companies.
Ask us for a small demonstration to allow you to realize the power and the simplicity of this financial analysis tool !