Software : Finance : Extended Accounting

MS Excel add-in for accounting with hierarhic data. You may define several levels of your hierarchy. For example: assemblies, units, packs, details, subdetails, and so on. This add-in contains about 250 VBA macros. Allows to set hierarchic and other dependencies between columns of your list(s). And when you enter your data, this add-in will track these dependencies and offer you to correct your data. Save your accounting time! Why have you to check your data manually? Additionally, allows easy accounting pivot tables creation & adding subtotals to your lists. Has also a timer.

How to Run the Extended Accounting

Simply open your worksheet and choose the item in the "EA" menu. You can see the sample of such worksheet below. Your worksheet can be arbitrary.

extenas.gif (19996 bytes)

The Extended Accounting can check your worksheet and select the erroneous cells by red color.

Sample of "Errors" worksheet with selecting the erroneous values by red color

extena.gif (18184 bytes)

Extended Accounting detected an error in the source list above : department 4 does not exist. How does Extended Accounting  know the erroneous cells? It simply finds available values of "Department" column on the "Hierh" worksheet ( please see below ). Note that the Extended Accounting does not change your worksheet. It inserts the new one with the name "Errors" instead and copies  your worksheet here.

"Hierh" ( hierarchy) Worksheet - Sample

 

extena1.gif (20765 bytes)

Another bug cell in the source list - E12 : the department 1 does not trade with a log. How does the  Extended Accounting  found this erroneous cell? It simply finds available values of "Goods" column on the "Hierh" worksheet ( please see above) while the value in the "Department" column = 1.

Please note that the Extended Accounting can check many columns of this worksheet by this way. For this purpose you will need only to create your own "Hierh" ( you may use another name) worksheet and define the link to it in the special form.

You can also use the Extended Accounting for the automated data entry on your worksheet. How can the  Extended Accounting automate your entry? It is simply. It offers to enter data into all columns of your list. If you enter the wrong value and the Extended Accounting "knows" that one is not valid, it offers to correct it. What is more, if there is only one valid value, the Extended Accounting enters it automatically. How can the Extended Accounting know the set of valid values for the current cell if this value depends of many other columns? It simply finds the available values of the current column on the "Hierh" worksheet (or other worksheets) while the values of other controlled columns of this worksheet(s) are the same as in the worksheet you create.

Please see the sample with sales below.

sales.gif (11589 bytes)

The Extended Accounting tracks here the "Depart." and "Ric Code" columns. The Automated Entry Procedure entered many columns automatically as it can calculate them using the formula from the previous row.  For example, the cell "J8" ("Total" column) is calculated by one using the following formula:

Qty * NetAmount * (1+Comission+StampDuty) + PtmLevy + ContractCharge

FAQ

Does the Extended Accounting takes up the computer memory while I do not use it? No.

Main Features:

Extended Accounting is the "vital Excel add-in designed for advanced accounting" - CNet Editor

System Requirements

Windows 9x/Me/NT/2000/XP or later & Excel 2000/XP or later

Order

Download Page

Additional Information: Extended Accounting
Without Source Code $29.95

Buy Online

With Source Code $59.95

Buy Online

More MRP Systems     More Finance Software for Excel  

More Finance Software    Home