Wednesday, June 4, 2008

Shares Sales/Purchase transactions

Here's a sample Excel file that contains "Shares sale and purchase" transactions which are to be imported into Tally.

Follow these steps to Import the Excel sheet data into Tally Software.

1) Download and unzip the files into "c:\udi-magic" folder.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.

2) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project

3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) Run UDIMagic utility, select option "Excel to Tally >> Voucher".
6) Next, select the XML-tags file and the Excel sheet when prompted.
Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.

7) Next, follow the instructions given in the wizard-screen to import data into Tally.

ZIP file contents
1) shares-sales-purchase-transactions.xls (Excel sheet)
2) shares-sales-purchase-transactions-xml-tags.xml (XML tags file)
3) shares-sales-purchase-transactions-macro.txt (contains macros)

Remarks:-

1) The following settings / options have been kept for Stock-Item masters:-
a) COSTING METHOD: FIFO
b) MARKET VALUATION METHOD: Avg. Cost
This can be changed as per requirement.

2) The Shares (per unit) cost is computed as follows:-
Purchase Price + Brokerage + ServiceTax + STT

3) The Shares (per unit) net Sales-realization value is computed as follows:-
Sales Price - Brokerage - ServiceTax - STT

4) The Firm-name (Share Broker-firm name) can be changed as per requirement.


No comments: