Financials

The functions within Aeros Vision - Financials allow you to create a wide array of customized reports for your General Ledger, Budgeting and Statics needs.

The basic pieces of Financials are Lines and Columns. Understanding their purpose and function will help you write powerful reports.

Lines - Creating Lines

The line setup is the area of the financial reporting where you’ll configure either single General Ledger accounts or groups of General Ledger accounts based upon the criteria provided. If you imagine a basic Trial Balance, the lines of a Trial Balance correspond to single General Ledger account. The line setup of a Profit & Loss Statement would be an example of where you might use multiple of General Ledger accounts.

Columns - Creating Columns

The column setup is where you will select what part of the General Ledger you would like to see along with the selection of Accounting Periods. Within the General Ledger, the system stores Closing Balances, Budget Data, Units, Period Activity, and more. In addition to the element of data you are looking to display, column configurations may be the current period the same period last year, or a twelve month net change (Income Statement accounts) or twelve month balance (Balance Sheet accounts).

Combining Lines & Columns - Running A Report

You can apply any line setup you create against any of the column setups you configure. As a result, you can have an unlimited number of combinations of showing the same line configuration with a different column configuration.

Formulas - Understanding Formulas

Within the line and column configurations, formulas can be defined. There are two types of formulas: Mathematical and Account Selection. For Mathematical, think of formulas similar to what you might define within an Excel cell; logic to add, subtract, divide, multiply other columns and lines together. For Account Selection, think of the filter criteria to locate specific lines within your General Ledger by Segment of the G/L Account # or Sub Type.