OBJECTIVE

To provide a very easy to use and powerful software Tool that would primarily allow for Trade or Receipts / Issues matching, i.e. matching a set of Buys / Sells or Receipts / Issues Transactions in any one of the selected methods out of:

§     First In First Out

§     Last In  First Out

§     AVERAGE

The Tool provides:

§     The Gain/Loss

§     The Balances

§     The Mark to market Value

§     Value Added Tax  Payable (VAT)

All the above can be calculated as of any given point in time which can be historical or current.

The most important aspect of the Software is its Integration with  the Ubiquitous and Extremely Powerful Microsoft Excel! .Thus the Tool appears as an option in EXCEL  & hence  the  Power of this Tool for Traders, Accountants / Auditors, Individual Investors, Managers etc for managing their business is unlimited. The package is named AAATMA - Achuta Auditors Accountants Traders & Managers Assistant. 

            Usually well organized Companies will have Computerized Systems that would provide for Trade Matching / Inventory matching Reports, as a part of their Company wide information System. However most organizations will not have the flexibility to provide such information quick enough repeatedly and in a format that is easy for Managers / Accountants / Traders to analyze further in a time frame that is available for valuable Decision Making. This TOOL fills such a GAP and can result in enormous benefits to the Organization. The tool can also be used as an Operational System by medium sized organizations. Additionally, the Tool can be used

§     As an aide in deciding the Method to be adopted

§     In verifying a matching already obtained

§     In working What Ifs etc

§     Provides Balances & Mark To Market positions

§     Provides Gains / Losses

§     Can  provide matching information for any period

§     Usable for any trade  & receipts / issue  matching:

o        Equities, Commodities, Currencies, Any financial instruments that are tradable, Stocks & inventory management

§     Is a part of ubiquitous excel & the complete power of excel is available for manipulating, analyzing input & output

§     Establishes links from output to input & output to closing balances

§     Provides facility to compare gains/losses against manual calculations held against each sold / issue record

§     Any two/all methods can be used for verification of output

§     Any Change/Error in the input can be incorporated/corrected & recalculation done very quickly

§     Can be used to track any component of price that needs to be recovered at actuals

§     Last but not the least, VERY ATTRACTIVELY PRICED

SKILLS REQUIRED

The User should have Basic skills of Using Microsoft Excel Spread Sheet. User should understand basic ideas of Managing Trade and Inventory.

What is expected for getting the necessary Outputs?

The Package expects the Transactions Data to be available in Excel Record Format, in the chronological order in which the Transactions Occurred. Some amount of flexibility is provided in handling the input Data and hence the records can contain the necessary fields in any position of the Record within a reasonable range in a given File.

TYPICAL OUTPUT

§     The Matched Output based on  LIFO, FIFO & AVERAGE methods, with  Gains /  Loss

§     A Facility to Sort the above Out Put,  Item Number wise

§     The Closing Balances of the Items at the end of matching  period & their Book Value

§     The Mark To Market Value of the stocks  (Closing Balances)

§     Item wise  breakup of Loss/Gain of the matched  Trade & the  Closing Stock

§     The VAT payable

§     Inconsistencies in the Input Records

§     Manually Matched set of Records