www.TallyERP9Help.Com

Importing Dealer Excise Opening Stock - After Splitting the Data in Tally.ERP 9

In case where you are using Excise for Dealers module of Tally.ERP 9 and split the company data follow the below mentioned procedure to account the Closing Stock as the Opening Stock after splitting the data.

The excise closing stock details are now be available in the Dealer Excise Closing Stock report. Dealer Excise Closing Stock report displays the pending quantity of the excise stock items as on a particular date.

To view the Dealer Excise Closing Stock report

Go to Gateway of Tally > Inventory Info. > Update Excise Info. > Dealer Excise Closing Stock

 
[Img-45]

The Dealer Excise Closing Stock report is displayed as shown


[Img-46]

 

Procedure to account the Closing Stock as the Opening Stock after splitting the data.

The procedure of Importing Data is different for -

  1. The company which has data of one Financial Year

  2. The company which has data for multiple Financial Year

Procedure to Import Excise opening stock for a company data with one financial year

Step 1: Export the Data

Before splitting the company data export the excise closing stock details in XML format.

Press Alt + E or click on the E: Export button to export the details


[Img-47]

Note: Before exporting the data ensure that the date specified for the Closing Stock Statement report should be the last day of the split period.

 

Example: if the data is of F.Y. 2008-2009 and it is split into Two periods of 1-4-2008 to 30-9-2008 and 1-10-2008 to 31-3-2009, in the closing stock statement report set the period to 1-4-2008 to 30-9-2008 to view the report as on 30-9-2008 and export the data.

The exported Tally.xml file will be placed in the Tally.ERP 9 directory

 
[Img-48]

Step 2: Split Company Data

To split the company Data

Go to Gateway of Tally > Alt+F3: Company Info. > Split Company Data

 
[Img-49]

From the Company Info. menu select Split Company Data option to view Split Company Data screen

In the Split Company Data screen

  • In the Name field select the company to split the data. e.g. ABC Company

  • In the Split from field enter the date from when you want the data to be split. e.g. 01-10- 2008

The completed Split Company Data screen is displayed as shown

 
[Img-50]

  • Press Enter to split the company data.

Step 3: Selection of Company

After splitting the data select the ABC Company with the period 1-Oct-2008

 
[Img-51]

Note: Ensure the Current Period of the company is 1-10-2008 to 30-9-2009

Step 4: Import of Data

Go to Gateway of Tally > Import of Data

 
[Img-52]

In the Import of Data menu

  • Select the option Vouchers to view the Import of Vouchers screen

In the Import of Vouchers screen

  • In the Import File Name (XML) field enter the file name as Tally.xml (To import the excise closing stock details as the opening stock of the split company from 1-Oct-2008)

  • In the Type of Vouchers field select Dealer Excise Opening Stock from the Type of Import list

 
[Img-53]

  • Press Enter to Import the vouchers.

After Import of Data check the Dealer Excise Closing Stock report for the Imported Stock Details.

Go to Gateway of Tally > Inventory Info. > Dealer Excise Closing Stock


[Img-54]

Note: The opening stock accounted by Importing the Excise Opening Stock will update the Excise Stock Register only .

 

To affect the books of accounts Opening stock quantities and Rate needs to be updated in the Stock Item Master separately.

2. Procedure to Import Excise opening stock for a company data with multiple financial year

Step 1: Split Company Data

 Go to Gateway of Tally> press ALT + F3: Company Info.

Select the option Split Company Data and select the Company whose data is to be split.

Tally recommends the split-off date based on the data existing. It is recommended that the Split Point is set as the beginning of the latest financial year though Tally permits any date as the split point.

Splits occur in sets of two periods. Start with the latest. For example assuming that two years data from 1-4-2008 to 31-03-2010 for a company is required to be split into two separate 'companies' each with a financial year. First, select the beginning of the latest financial year (1-4-2009, that is what Tally.ERP 9 would prompt you to do).

 
[Img-55]

On confirming the activity, two new companies will be created one with data from 1-4-2008 to 31-03-2009 and the other with data from 1-4-2009 to 31-03-2010.

Note: Do not quit or close any company or Tally.ERP 9

Step 2: Create a new company

Creation of new company is required where in the parent company

  • Purchased the Excise goods in one Financial Year and sold in the second Financial Year

Example: Purchased 100 Nos of Item X  on 10-4-2008 (FY 1-4-2008 to 31-3-2009) and cleared all the 100 Nos on 15-5-2009 (in the FY 1-4-2009 to 31-3-2010)

  • Purchased the Excise goods in one Financial Year and cleared in Multiple Financial Year

Example: Purchased 100 Nos of Item X  on 10-4-2008 (in the FY 1-4-2008 to 31-3-2009) and cleared 40 Nos on 12-6-2008 (in the FY 1-4-2008 to 31-3-2009) and 60 Nos on 18-8-2009 (in the FY 1-4-2009 to 31-3-2010)

and on splitting the data, if you import the Dealer Excise Closing Stock from the parent company to second child company the bill reference of the transactions of the cases explained above will be treated as new transactions in the second child company. So creation of new company is mandatory.

Go to Gateway of Tally > F3: Company Info. > Create Company

Specify the period i.e., financial year of second child company (from 01-04-2009 ) with same F11: Features.

 
[Img-56]

Step 3: Select second child company (from 01-04-2009 to 31-3-2010 -got created after splitting of company data)

Go to Gateway of Tally > Display > List of Accounts > Alt + E (Export) > Select the Language (Default (All Languages)) > Select the format XML > Give the file name > Select 'All Masters' > Accept the screen.


[Img-57]

Step 4: Select newly created company - Import Data

 Go to Gateway of Tally > Import of Data > Masters > Specify the file name as Master.xml (which you specified while exporting the Masters) > in Treatment of entries already existing field select - Modify with new data


[Img-58]

Step 5: Select first child company (from 01-04-2008 to 31.3.2009)

Go to Gateway of Tally > Inventory Info. > Update Excise Info. > Dealer Excise Closing Stock > Alt + E (Export) > Select the Language (Default (All Languages)) > Specify the path where you want to store the file > Select the format XML > Give the file name > Accept the screen.

Note: Before exporting the data ensure that the date specified for the Closing Stock Statement report should be the last day of the split period i.e. 31-3-2009

Example: if the data is of F.Y. 2008-2010 and it is split into two periods of 1-4-2008 to 31-3-2009 and 1-04-2009 to 31-3-2010, in the closing stock statement report set the period to 1-4-2008 to 31-3-2009 to view the report as on 31-3-2009  and export the data.

 
[Img-59]


[Img-60]

Step 6: Select newly created company- Import Data

Go to Gateway of Tally > Import of Data > Vouchers > Specify the file name Closing Stock.xml (which you specified while exporting Dealer Excise Closing Statement) > In the Type of Vouchers field select Dealer Excise Opening Stock from the Type of Import list > Accept the screen.


[Img-61]

Step 7: Select second child company (from 01-04-2009 to 31-3-2010)

Go to Gateway of Tally > Display > Daybook > Select the period > Press ALT + E (Export) > select the format as XML > Specify the file name > Export.

Step 8: Select newly created company

Go to Gateway of Tally > Import of Data > Vouchers > Specify the file name which you specified while exporting Daybook from second child company > In the Type of Vouchers field select Default from the Type of Import list > Accept the screen.

Note: Henceforth, newly created company should be used for further maintenance of accounts.

 

The opening stock accounted by Importing the Excise Opening Stock will update the Excise Stock Register only .

 

To affect the books of accounts Opening stock quantities and Rate needs to be updated in the Stock Item Master separately.

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications