Software : Finance : Automated Entry and Control in Excel : Extended Accounting

Extended Accounting (add-in for Excel 97 or greater)

Automated data entry into almost arbitrary Excel list (spreadsheet) and more. Allows to save a work time with Excel spreadsheets.

Features :

1.Input Wizard allowing the following:
- input automation of your data;
- seeing the list of hierarchical restrictions for sorting columns during input after entering the higher sorting column value. To enter value, you can click on it in the list;
- seeing the list of main and dependent columns possible values during the input. To enter value, you can click on it in the list;
- automatic input of dependent columns of the list;
- automatic data control during input.

 
2. Report Wizard allowing easy creation of the complex pivot tables and/or  adding subtotals to your list. This tool also allows to copy the source list to inserted worksheet, find the error values on this worksheet automatically (using hierarchical control and control of accordances) and mark them by red color. Then
you can find the red color values automatically. Extended Accounting allows to create the following control types of your data:
- hierarchical control of all sorting columns values. You can define restrictions of values for any sorting column for defined higher sorting column value and so on.
- control of accordances. Extended Accounting allows defining dependent columns in a source list. If you will define them, their values will become controllable.
- other control types.

3. An ability of work with external data bases (Access, Visual FoxPro and others).

View Screenshots

More MRP Systems     More Finance Software for Excel  

More Finance Software