Maintains financial information for an unlimited number of fiscal years with unlimited fiscal periods. User can define account segments up to 32 characters in length. Statistical accounts can be used to track non-financial information. Intercompany transactions automatically balance between companies. The G/L supports powerful allocation by percent, units or variable. Fully customizable financial reports can be created from user defined row, column and entity templates. Drill-down is available from financial reports to the actual source documents in any application component.
|Powerful Inquiry via Drill Down||
Financial reports allow you to drill-down into a report to get a list of account balances from which the report was generated. Drill-down further to reveal the G/L transactions from which the summary amounts were produced. Then drill-down to the actual journal entries and the original source documents in any application component to quickly analyze business activity.
Account inquiry shows the periods in which financial activity occurred for a specific account in any open fiscal year, historical fiscal year, or budget. Drill-down into any period to get a list of transactions which occurred during the selected period. Transaction inquiry shows a list of all transactions within a date range for a specific account. Drill-down directly to the G/L journal entry or source document in any application component. User defined sorting and filtering criteria can be used to quickly locate transactions.
|Graphs of Account Activity||View changes in account activity or balances as a bar graph to quickly identify trends.|
|Flexible Account Structure||Define an account format up to 32 chars in length with any number of segments. Define whether numeric or alphanumeric characters are allowed at each character position. An optional segment separator can be specified between each segment. The sort order of accounts on financial reports can be different then the order in which the segments appear in the account format.|
|Account Mass Modification||
Account mass modification allows create, delete, copy, or modify on a group of accounts. Hundreds of accounts can be created based on a range of possible segment values. Allows the accounts in one department to be used as a template to create accounts in a new department. Reassign a range of accounts to a new account category without having to select each account individually.
|User Defined Fiscal Calendar||Unlimited open fiscal years can be kept online with full transactional detail. Unlimited historical fiscal years can be kept for reporting purposes. Each fiscal year can have from 1 to 366 periods. No fiscal period or year closing process is required at any time. Transactions can be entered into any period which has not been locked by the administrator. Periods can be locked by individual module. Transactions entered in prior fiscal years will be rolled forward into subsequent years automatically. Financial reports can be produced for any fiscal year or period at any time.|
|User Defined Account Categories||Account categories are used to classify accounts for reporting purposes. Categories are especially useful when designing financial reports as they allow grouping of accounts by category.|
|Visual Financial Report Writer||
Create an unlimited number of complex financial reports by combining a row template, a column template and an entity template. Row and column templates can be edited using a What You See Is What You Get (WYSIWYG) editor which allows very precise control over the look of a financial report. Presentation quality reports can be created by specifying numeric formats, text color, font name, font size, bold, italic, and underline attributes. A row template defines how rows will appear on the report. A row can display account categories and/or a range of accounts, totaling expression, text, or underline. A column template describes how a column is to be formatted on the report. Up to 255 columns can be defined by each template. Columns can include amounts from statistical and financial accounts, open fiscal years, historical fiscal years and budgets. Columns can also be based on a mathematical expression.
An entity template is used to control whether a report is based on the entire organization or specific financial reporting units. Entity templates can be used to define hierarchical relationships between financial reporting units such as departments, divisions, regions, funds, and companies. Multiple entity templates can be defined to facilitate reporting on an organization from different business perspectives.
Transactions originating in any application component generate G/L journal entries which are then processed in the general ledger. Journal entries can be posted automatically from other components or individually under manual control. Posting can be performed to preserve full transaction detail or in summary to reduce the amount of data. Validation checks prevent the entry or posting of invalid data into G/L such as unbalanced transactions or invalid accounts.
|Auto Reversing Journal Entry||Allows auto-reversing journal entries which will reverse the amounts on a specific date in the future. Financial journal entries are used with financial accounts where debits must equal credits.|
|Statistical G/L accounts||Statistical accounts can be used to track non-financial information such as number of employees, square feet, production quantities, etc. Statistical accounts can appear on reports to show their relationship with the financial activity of the organization. Statistical journal entries are used with statistical accounts and allow entry of single sided transactions.|
|Allocation Methods||Define an unlimited number of allocation methods. Allocation types supported include percent, amount/units and variable allocation. Allocation methods are used on allocation transactions to distribute balances in one or more accounts.|
|Multi-Company Consolidation||Consolidate financial data of multiple companies stored in separate databases. Databases consolidation can be performed on one server or multiple servers located across the country. The G/L account structure in each database can be different in length and number of segments.|
|Inter-Company Transactions||Automatically creates inter-company receivable and payable entries when posting transactions involving more than one company. Allows complete control over the use of inter-company accounts.|
|Fund Accounting||Fully supports fund accounting for non-profit and governmental organizations in all application modules.|
An unlimited number of budgets can be defined for any fiscal year. Budget amounts can be edited in a spreadsheet style grid. Budget amounts can be derived from an open fiscal year, historical fiscal year, or budget using various calculation methods.
|Budget Import/Export||Budget data can be easily exported to a text file for loading into Microsoft Excel or another application. Using Microsoft Excel to build budget using complex formulas then import the data into the system for use in financial reporting.|