TALLY 9.1
1. ABOUT THE SOFTWARE – 2. SC SCOP OPE E OF TALL TALLY Y KNOW KNOWLE LEDG DGE E 3. INSTALLAT INSTALLATION ION ,UPGRADATIO ,UPGRADATION N & TROUBLESHO TROUBLESHOOTING OTING 4. AC ACCO COUN UNTI TING NG CONC CONCEP EPT T 5. STAR STARTI TING NG WIT WITH H TALL TALLY Y 6. LANGUA LANGUAGE GE SETUP SETUP & CONF CONFIGU IGURAT RATION ION 7. COMP COMPAN ANY Y CRE CREAT ATIO ION N 8. CREATION CREATION & CONFIGURATI CONFIGURATION ON OF OF ACCOUNTI ACCOUNTING NG MASTER MASTERS S 9. TYPE TYPES S OF OF VOUC VOUCHE HER R 10. CONFIGURATI CONFIGURATION ON & CREATION OF VOUHER 11. VOUCHE VOUCHER R ENTRY ENTRY 12. TRIAL TRIAL BALANCE BALANCE 13. BANK RECONCIL RECONCILIATIO IATION N 14. FINAL ACCOUNTS ACCOUNTS 15. REPORTS REPORTS & REPORT PRINTIN PRINTING G 16. MOVING MOVING TO NEW FINANCIAL FINANCIAL YEAR YEAR 17. TAX ACCOUNTING ACCOUNTING 18. PAYROLL PAYROLL ACCOUNTING ACCOUNTING
Tally 9 – The Complete Business Solution S olution
As your business grows and transcends state and international borders, you need a business accounting software that keeps pace with your complex business demands and simplifies growth. The software you choose must offer you greater g reater speed, power and reliability, besides having the ability to adapt quickly to your business. Tally 9 was engineered to effectively fulfill these needs and help overcome the challenges of a growing business.
Designed for unmatched speed, power, scaleability and reliability Powered by Tally’s path-breaking proprietary technology - C:MuLate (Concurrent Multi-lingual Accelerated Technology Engine) – Tally 9 is the result of a perfect fusion between the Concurrent Multi-lingual Platform and Object Oriented Database Engine. This technology is what ensures the blazing speed, power, scaleability and world-class reliability that Tally 9 promises.
Features that will empower your business The dynamic features and MIS capabilities in Tally 9 are designed to simplify your business operations, while giving you complete control over your accounting, inventory and statutory processes. Multi-lingual and data synchronisation capabilities, allow you to transact business without language barriers or geographical boundaries.
Tally 9 is very simple to learn and even easier to use. And the advantages of using this robust product are apparent from the start. To learn more about how Tally 9 can enhance your y our productivity and profitability, do look through the features and benefits.
Tally's History The Late Shri S. S. Goenka, founder of the company Peutronics Pvt. Ltd. set up Tally’s software business in 1986. His able mentoring of his son Bharat resulted in the creation of software that would simplify the process of financial accounting and inventory. Determined to create and develop a simple business accounting software, Bharat spent months in the research and development of path breaking technologies, which would assist him in achieving his goals. His dedication and focus led to the development of a commercial product. It was at this stage that Peutronics Pvt. Ltd. metamorphosed into Tally Solutions – a company that would set new standards of excellence in business accounting and lead the market as India’s number one accounting software developer. Not content to rest on his laurels, Bharat Goenka, a technical prodigy with keen k een business acumen, continues to ensure that Tally keeps k eeps apace with new technologies that can be incorporated in our products to stay ahead of the pack. Today Tally has evolved from a basic Accounting and Inventory software to a Complete Business Solution catering across industry segments and verticals. For it’s simplicity in use, versatility in its technology – Tally is the recipient of a number of awards and accolades.
COMPREHENSIVE FINANCIAL ACCOUNTING All books of Accounts & Final Results Balance Sheet with various Schedules Daily / Monthly Summaries of Accounts, Groups and Cost Centres Outstanding Reports and Analysis Payment Reminder Letters Broker-wise Reporting Royalty Calculation Interest Calculation (Multiple Slabs based on Amount & Days) Depreciation Chart (as per Co. Act / IT Act) Bank Re-conciliation Cost Centres with Grouping MULTI-LOCATION INVENTORY MANAGEMENT All books of Inventory Stock Status Stock Valuation on multiple methods Daily / Monthly Summaries on the basis of Items and Item Groups Item-wise Gross Profit Primary and Alternate Unit for each item Multiple Material Centres with Grouping Batch-wise Inventory with Expiry Date Production / Unassemble
Bill of Material Production Planning Material Issue / Receipt Critical Level Controls Updation of Critical Levels based on Consumption Multiple Price-list for Items Party-wise Price Structure for Items / Item Groups
SALES / PURCHASE ORDER PROCESSING Pending Sales Orders (Party-wise / Item-wise) Sales Order-wise Statement (Party-wise / Item-wise) Pending Purchase Orders (Party-wise / Item-wise) Purchase Order-wise Statement (Party-wise / Item-wise)
USER-CONFIGURABLE INVOICING Option for Fonts, Colors & Images Option for pre-printed stationery VAT Invoicing (Tax / Retail) Tax Inclusive / MRP Billing Multiple-taxes in Single Invoice Mfg. Excise Invoicing Trading Excise Invoicing Invoice Barcode Printing
DOCUMENT PRINTING Fully User-configurable Option for Fonts, Colors & Images Sales Invoice Purchase Invoice Sales Return Invoice Purchase Return Invoice Receipt Payment Advice Debit Note Credit Note Sales Order Purchase Order Delivery Note Goods Receipt Note Stock Transfer Memo
SALES TAX REPORTS / REGISTERS Sales Tax Forms Receivables / Issuables Forms Received Register Forms Issued Register Forms Issued Annexure Sales Tax Summary Purchase Tax Summary Sales Tax Surcharge Sales Tax Account Register Sales Tax Forms Reminder Letters
Delhi Sales Tax Registers (ST-2A & 2B) UP Sales Tax Registers (Form-31 & OC Stamp) Rajasthan Sales Tax Registers (ST-18 Register) Haryana Sales Tax Registers (ST-38 Register ? Inward / Outward / Received) Pakistan Sales Tax Registers
VAT REPORTS / REGISTERS VAT Summary VAT Computation Party-wise VAT Summary Item-wise VAT Summary Party-wise CST Summary Item-wise CST Summary
VAT Invoicing (State-wise) Assam Himachal Pradesh Jammu & Kashmir Kerala Meghalaya Mizoram Punjab Tripura
VAT Returns (State-wise) Andhra Pradesh Arunachal Pradesh Assam Bihar Chhattisgarh Daman & Diu Delhi Goa Gujarat Haryana Himachal Pradesh Jammu & Kashmir Jharkhand Karnataka Kerala Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Orissa Punjab Rajasthan Tamil Nadu Tripura Uttarakhand
Form 46 Form 18, 19 & 20 Form 50 & 51 Form 8, 8A & 8B Form 32 Form 41 & 42 Form XXVI & XXVII Form 29
Form 200, CST VI, 226A, 226B, 227A, 227B & 228A Form FF-01 Form 13 Form RT-1 & Form 1 Form 17 DVAT 16 DVAT 16 & Form 1 Form III & Form 1 Form 201, 202, 205 & 3B VAT R-1 & Form 1 Form XV, XV-B & Form 1 Form 11 & 11A Form 200 & Form 1 Form 100, 110 & 115 Form 10 Form 10 Form 221 Form 10 Form 5 Form 5 Form 201 Form 15, 16, 17, 20 & Form 1 Form 10, 11 & Form 1 Form I, J, K & L Form 10 Form 3 & Form TT 66
Uttar Pradesh West Bengal
VAT Registers (State-wise) Arunachal Pradesh Assam Bihar Form Delhi Gujarat Haryana Himachal Pradesh Jammu & Kashmir Jharkhand Karnataka Meghalaya
Form 24, 24-A & Form-1 Form 14, 14A & 14B
Form FF-11 & FF-12 Form 44 & 45 D-XI, RT II-A & RT II-B DVAT 30, 31, 35B, 51, Form 4 & 7 Form 201A, 201B, 201C & 202A Form LS1- LS7, LS9, LP1- LP7, Form A-4 & C-4 Form LP-1 & LS-1 Form 48 & 49 JVAT 500 & 501 Form 170 Form 7 & 8
Mizoram Punjab Rajasthan
Form 21 & 22 Form 18 18, 19, 23, 24, 31, 32 & 36B Form 07, 08, 09, 12, 48 & 50
Tamil Nadu Tripura Uttarakhand Uttar Pradesh
Annexure I & II Form 37 & 38 Form 16, 28, 29 & Annexure 1 Annexure A & B
MFG. / TRADING EXCISE REGISTERS PLA Register RG23A-I Register RG23A-II Register Cenvat Return RG23C-II Register RG-I Register Excise Duty Register ER-1 Return RG-23D Register Form-2 Register
SERVICE TAX Input Service Tax Register Output Service Tax Register Service Tax Summary ST-3 (Service Tax Return)
TDS TDS Calculation TDS Warning Alarms TDS Challans TDS Certificate (Form 16-A) TDS Return (Form 26-Q) Annexures to Form 26-Q
e-TDS with TDS 27-A TDS Deduction Details Report
FRINGE BENEFIT TAX Mark Expenses as FBT Expense-wise Taxable Value Fringe Benefit Tax Report
M.I.S. REPORTS Cash Flow / Funds Flow Budgets / Targets Credit Limits Ratio Analysis Sales / Purchase Analysis Material Issue / Receipt Analysis An alysis Consumption Analysis Consolidated Final Results ABOUT SERVICE TAX - In a significant relief to service providers, the Central Board of Excise and Customs on Friday clarified that exported services on which service tax has not been paid will not be treated as exempted services for the purpose of availing Central value added tax (Cenvat) credit. This would imply that such service providers could continue to take input tax credit even if they do not pay service tax. Tax experts ex perts feel the circular will clear many issues, although there are a few more that need to be addressed. “This is a very important clarification that has cleared some doubts but there are a few more pending issues,” Pratik Jain director KPMG said. The CBEC clarification comes in the wake of amendments to the Cenvat Credit Rules in this year's Budget. Under the amendment, assessees opting not to maintain separate Cenvat credit accounts have two options for payment of the tax. They can pay 10% of the value of the exempted goods or 8% of the value of the exempted services. Alternatively they can pay an amount equivalent to the Cenvat credit attributable to inputs and input services used in manufacture of exempted exe mpted goods.We We are a company that has recently started manufacturing plastic products. We are paying excise duty on procurement of raw materials and equipment. We are also paying service tax on various services procured such as accounting, auditing, sales promotion, market research and goods transport. Such services do not directly pertain to the manufacture of goods. We understand that Cenvat credit can only be availed when duty-paid goods and services are used in relation to manufacture of excisable goods. What is the treatment of the service tax paid on such ancillary services? - ANS - The Cenvat Credit Rules define ‘input services’ as services used, directly or indirectly, in relation to the manufacture of excisable goods. The definition includes other services such a s those used in relation to setting up, modernisation and renovation of a factory, advertisement, sales promotion and market research. It also includes services relating to business such as accounting, auditing, financing, share registry, computer networking, security, coaching and training of employees. Accordingly, it is seen that almost all services used by a manufacturer of excisable goods would qualify as input services, and the service tax paid would be available for utilisation as Cenvat credit. Therefore, you may avail credit of the tax paid on ancillary services falling in the definition of input services and subject to other conditions. Q- We are a firm of contractors engaged in road construction in Delhi. We recently hired machinery from a rental agency in Delhi for carrying out excavations and surface flattening for a period of three months. During this period, the machinery was used and operated by our personnel. On receipt of the invoice from the rental agency, we noticed that it has charged value-added tax (VAT) on this transaction. We understand that VAT is levied only on sales transactions. Are we liable to pay VAT without having bought the machinery? ANS machinery? ANS - The definition of ‘sale’ under both the Central Sales Tax Act and state VAT VA T legislations has been expanded to include not only actual transfer of property in goods, goo ds, but also various other transactions referred to as ‘deemed sales’. Such deemed sales include ‘transfer of right-to-use goods’; ‘delivery of goods on hire-purchase basis’, and ‘supply of goods in the course of execution of works contracts’. Such category is chargeable to VAT in the same manner as normal sales. In your case, c ase, it appears that there has been a transfer of control, custody and possession po ssession of the machinery by...
CENVAT
Recently the Government has drastically amended the CENVATCredit. Rules 2004. The workshop aims to understand the impact of such changes as well as educate the industry on the variousissues relating to CENVAT Credit. Some of the topics under CENVAT will include:Impact of changes made in the definition of input service.Impact of changes made in Rule 6(3).Doubts and difficulties for implementing the Rule 6(3) &6(3A) & remedies thereof.Meaning of exempted services in the changing scenario SERVICE TAX Year after year the scope of levy l evy of service tax has been.expanded b een.expanded by the Government. As the revenue of Government has increased from 400 crores to 64,400 crores, so also the problemof the industries..The above informative session has been organized to guide and.resolve the problems being faced by the industry.This session would broadly discuss the below mentioned issues - such as: Issues in construction industry. Associated party transaction Calling for information / reports and multiple audits Impact of recent panel provisions Scheme under Service Tax to avoid penalties and proceedings Classification of taxable services Export and import of services Refund of Service Tax to exporter of goods VAT and Service Tax applicability on same transaction
Excise for Dealers - Introduction
A manufacturer of excisable goods can avail MODVAT (now CENVAT) credit of duty paid on the goods purchased from any dealer w.e.f. 04.07.94. The dealer intending to issue modvatable (now Cenvatable) invoices should get themselves registered with the jurisdictional Range Superintendent by following the procedure prescribed in Rule 9 of Central Excise (No.2) Rules, 2001. All the godowns /Store-rooms should be registered separately.A Central Excise Registered dealer should ensure that the prescribed register is maintained for the godown/ Store-room. All the consignments received/ issued from the godown h ave to be entered in the register (further details in Central Excise Rules and Manual). The Dealer shall issue the invoices in quadruplicate. The copies of the invoices issued by a first stage dealer and a second stage dealer shall be marked at the top as "FIRST STAGE DEALER" and "SECOND STAGE DEALER" respectively. The invoice issued by a first stage or second stage dealer in the case of imported goods and by a second stage dealer in the case of other goods, shall be duly authenticated by the officer. The Dealer shall issue one invoice for every consignment dispatched in one batch and at a given time. If a consignment is split into two or more batches, then each consignment is dispatched separately with separate invoices. Who is a Trader/Dealer?
A Trader/Dealer is someone who purchases and sells goods and maintains an inventory of goods. A registered Excise dealer is a dealer of Excisable goods who is registered under Central Excise rules, 1944 and on the strength of whose invoice Cenvat credit can be taken.
Who will be covered under Dealer Excise?
The following dealers are covered under u nder Excise for Dealer. First Stage Dealer
A First Stage Dealer is one who purchases goods directly from any of the following: •
• •
• •
The manufacturer under the cover of any invoice issued in terms of the provision of Central Excise Rules, 2002 or from the depot of the said manufacturer. Goods purchased from the premises of the consignment con signment agent of the said manufacturer. Goods purchased from any other premises from where the goods are sold by or on behalf of the said manufacturer. Goods purchased from an importer or from the depot of an importer. Goods Purchased from the premises of the consignment agent of the importer.
Second Stage Dealer
A registered dealer who purchases goods goo ds from the First Stage Dealer is called a Second Stage Dealer. Flowchart on Excise Dealer The categorization of a dealer d ealer as first stage or second stage is not predefined. It is decided during the purchase. Therefore, a dealer may be a first stage dealer or a second stage dealer depending on the type of purchase. Assume you are a First Stage Dealer D ealer and you buy the goods from the importer or Manufacturer. Importer Excise paid to be reflected on the bill --Manufacturer First Stage Dealer Sales
Excise to be
Excise to be passed on With duty details
Manufacturer
Second Stage Dealer
Not eligible to pass on passed on with duty details
Other
duty
The Invoice issued on sale of goods to the Manufacturer or Second Stage Dealer has to indicate the amount of Excise Duty passed on or proportionate value to the excise of the goods being sold. Example 2
Let us assume that you are a Second Stage Dealer and you purchase goods from a First Stage Dealer. Excise duty passed by the First Stage dealer has to be Reflected on the bill First Stage Dealer
.
Excise to be passed on
Manufacturer
Second Stage Dealer
Excise to be
Not eligible to pass on
passed on With duty details
Service provider
duty with duty details
Other Excise traders
Type of Duties and Method of Calculation The Duties for Excise can be calculated on Assessable value and on Duty Value. According to the Excise laws, find below the list of Excise duties with the method of calculation. Type of Duty
Method of Calculation Basic Excise On Assessable Duty Value Special Excise On Assessable Duty Value Additional Duty On Assessable of Excise (Goods Value of Special
Importance) AED (GSI) Additional Duty On Duty Value of Excise (Textile and Textile Articles) AED (TTA) Additional Duty
On Duty Value
Formula for Calculation
Assessable Value Assessable Value Assessable Value
BED + SED
BED + SED
of Excise (Tea and Tea Waste) AED (TTW) National Calamity Contingent Duty (NCCD) Countervailing Duty (CVD) On Import) Education Cess
Secondary Education Cess (SED) Education Cess on CVD Special Additional Excise Duty (SAD) Additional Duty of Excise (ADE)
On Duty Value
BED + SED + AED(GSI)
On Assessable Value
Assessable Value OR Assessable Value + BED
On Duty Value
BED + SED + AED(GSI)+ AED(TTA) +AED(TTW) + NCCD + ADE + SAD BED + SED + AED(GSI) + AED(TTA) + AED(TTW) + NCCD + ADE + SAD CVD Value
On Duty Value
On Duty Value On Duty Value
On Duty Value
BED + SED + AED(GSI) + AED(TTA) + AED(TTW) + NCCD + ADE BED + SED
Filing Excise Returns
Every registered dealer is required to maintain a Daily Stock Register of records of receipts of duty-paid goods and issue thereof, and submit quarterly return in the Form - 2. Excise for Dealers in Tally
The Excise for dealers feature in Tally supports the following, making it easy for computation: • • • • • • •
Easy to use Fast and error free voucher entry Complete tracking of Excise duty on each transaction Printing of Excise invoice with the Supplier & Manufacturer details as User configurable option Reports are generated as per Central Cen tral Excise Statutory requirements Generation of Quarterly Return in Form-2 Generation of Sales and Purchase Extract
Enabling Excise Excis e in Tally
You can enable Dealer - Excise in Tally, in the F11: Features screen. Go to Gateway of Tally > F11: Features > Statutory & Taxation The Company Operations Alteration screen appears as mentioned below 1. Set Enable Dealer – Excise to Yes.
2. Set Set/Alter Dealer – Excise Details to Yes. 3. The Company Excise Details sub-form appears as shown below. ECC/PAN Based Regn/Code No.: The 15-Digit PAN based registration number is an alphanumeric number mentioned in the Registration Certificate. The first part would be the 10-character (alphanumeric) Permanent Account Number [PAN] issued by the Income Tax Authorities to whom the registration number is allotted (includes a legal person).
The second part comprises a fixed 2-character alpha-code indicating the category of the Registrant. The third part is a 3-character numeric code. Commissionerate: The Commissionerate of central Excise is the division under which your registered premise is located.
Range Code: Enter the code of the range under which your company is registered. Name: Enter the name of the range under which your company is registered. Address: Enter the address of the Range under which your company is registered. Division Code: Enter the code of the division under which your company is registered. Name: Enter the name of the division under which your company is registered. Address: Enter the address of the division under which your company is egistered. CREATING MASTERS Creating a Supplier Ledger
Go to Gateway of Tally > Accounts Info > Ledgers > Create The ledger creation screen appears as shown below. 1. Enter the name of the Supplier in the Name field. 2. Sele Select ct the the grou group p Sundry Creditors in the Under field. 3. Set Maintain Balances Bill by Bill to Yes and enter the Default Credit Period 4. Inventory Values are affected is set to No 5. In the Mailing Details section enter the supplier contact details, Income Tax and the Sales Tax numbers . 6. Set Excise Details to Yes to display the Excise Details sub form. 7. Enter the Excise Registration Number of the supplier. 8. Enter the Range under which the supplier’s company is registered. 9. Enter the Division under which the supplier’s company is registered. 10. Enter the division under which which the premise of the Supplier’s Supplier’s company is registered. 11. Select the Defaul Defaultt Nature of Purchase from the Nature of Purchase list. The table lists the Type of Purchase , which can be changed during transactions.
Note: The Excise Details sub-screen appears for ledgers created under Sundry Creditors and Sundry Debtors only. Creating Customer Ledger
Creating Customer ledger is similar to that of creating the Supplier Ledger but it should be created under Sundry Debtors. Creating a Stock Item
Go to Gateway of Tally > Inventory Info > Stock item > Create The Stock Item Creation screen appears as shown below.
1. 2. 3. 4.
Enter Enter the the name name of the Stock Stock Item Item in in the the Name field. In the Under field, select the group under which the Stock Item is created from the List of Groups list. Select Select the the unit unit for the Stoc Stock k Item Item from from the the Units list. Set Excise Details to Yes to display the Duty Details sub form as shown below.
Tariff Classification number. 5. Enter the Tariff Classification Note: The Tariff Classification field is mandatory. The Excise Purchase/Sales/Credit Note and Deb it Note will list the Stock Items with Tariff Classification only.
6. 7. 8. 9.
Sele Select ct the the Type of Duty from the List of Duties Spec Specif ify y the the Rate of Duty Sele Select ct the the Method of Calculation After entering entering the details details accept accept Yes to save
Creating Ledgers for Excise Duty
The Ledgers for Excise Duty are used to Account the Excise Duty. Go to Gateway of Tally > Accounts Info > Ledgers > Create 1. Select Duties & Taxes from the List of Groups 2. Select Excise for Type of Duty/Tax 3. Sele Select ct the the appr appropr opria iate te Duty Head from the list 3. Set Inventory values are affected to Yes 4. Enter the Percentage of Calculation 6. Select th the Method of Calculation from the Type of Duty list Similarly, you can create Ledger Masters for different Rates of Excise Duties . Methods of Excise Accounting
The user can use any of the following two methods to account Excise Duty in Tally 1. On the Total Cost Basic Rate
Assessable Value + Taxes = Cost of the Item
The sum of the Total Assessable Value and the Excise Duty will form a part of the Cost of the Item Eg. Stock Item A costs
Rs. 50/ unit
100 nos of Stock Item A
Total Cost Rs. 5000(@ Rs. 50/unit)
Excise Duty@16%
Rs. 800/-
Education Cess@2%
Rs. 16/-
Secondary Education Cess @ 1%
Rs. 8/-
The Total Amount
Rs. 5824/-
The Total Purchase Cost/unit
Rs. 5824/100= 58.24
Note: The Excise Duty paid by the dealer becomes the cost for the dealer. 2. Approp Appropriat riation ion by Quantit Quantity y or or Value Value
Eg.
Stock Item A cost 100 nos of Stock Item A
Rs. 50/unit Total Cost Rs. 5000
Excise Duty@16%
Rs. 800/-
Education Cess@2%
Rs. 16/-
Secondary Education Cess @ 1%
Rs. 8/-
The basic Rate of the Stock Item is retained and the details of the Excise Duty are shown using the duty ledgers created under the purchase account. The appropriation is done by Tally and the duty against is added to the cost of the material. Creating Ledgers for VAT VAT ledgers are created to allocate Input and Output VAT on purchase and sales transactions. Go to Gateway of Tally > Accounts Info > Ledgers > Create 1. Select Duties & Taxes from the List of Groups 2. Select VAT for Type of Duty/Tax 3. Select th the Default VAT/ Tax Class from the List of VAT/Tax Class 4. By de default Inventory values are affected field is set to Yes 5. Set Percentage of Calculation , if required 6. Method of Calculation is set to On VAT Rate by default. Note: If the VAT/Tax Class is not selected at the ledger level, the same can be selected during voucher entry.
Creating Voucher Type
The Excise Voucher Type for Purchase , Sales, Credit Note and Debit Note has to be created before creating the invoices. Creating Purchase Voucher Type
Go to Gateway of Tally > Accounts Info > Voucher Type > Create
Name: Enter the name of the Voucher type. Type of Voucher: Select the type of voucher as purchase from the list of Voucher types . Abbreviation: You may abbreviate the Vouchers type as per your requirement. Method of Voucher Numbering: Select Automatic for the method of Voucher numbering. Use Advanced Configuration: Set it to Yes to specify the numbering method, if required. Use for Dealer Excise: Set this field to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.
Accept the screen to save after entering all the details. Note: The Use for Dealer Excise option will appear in Purchase/Debit Note and Sales/Credit Note only and if the Dealer - Excise is enabled in the F11 Feature F3 – Statutory & Taxation . Creating Sales Voucher Type
Creating Sales Voucher Type is similar to that of Creating a Purchase Voucher Type but it should be created under the Sales Type of Voucher. Creating a Debit Note Voucher Type
A Debit note Voucher type has to be created if a Debit Note has to be passed. The Voucher Type should be created under Debit Note type of Voucher. Creating a Credit Note Voucher Type
A Credit note Voucher type has to be created if a Credit Note has to be passed. The Voucher Type should be created under Credit Note type of Voucher. Creating an Excise Opening Stock
Tally allows you to maintain a record of Excise Opening Stock Balance of the Excise Stock Items Note: Excise Opening Stock option under the Inventory Info menu will appear only if you create an Excise Purchase voucher type with Use for Dealer Excise option set to Yes.
To create an Excise Opening Stock : Go to Gateway of Tally > Inventory Info > Excise Opening Stock
Creating an Excise Opening Stock You can track the Excise Opening Stock by entering the Stock Item Purchase details in the Excise Opening Stock . Let’s consider an Example: A user buys 100 nos of Stock Item A from King & Sons and 50 nos of Stock Item A from MICO Manufacturing Limited . The Opening Stock carried forward for the current year will be 35 nos of Stock A ( 25 nos. from king & Sons and 10 nos from MICO Manufacturing Limited ). To record this Excise Opening Stock balance, you need to follow the below procedure: Go to Gateway of Tally > Inventory Info > Excise Opening Stock 1. Ente Enterr the the purc purcha hase se Invoice Number of the Stock Item in the field Supplier Invoice No. 2. Select th the Party’s A/c Name from the List of Ledger Accounts 3. Enter the Party details in the Party Details sub form 4. Accept the above screen screen and select select the Nature Nature of Purchase Purchase from from the the list 5. Select th the Purchase Ledger from the List of Ledger Accounts 6. Select th the Stock Item from the List of Excise Stock Items for the Item Allocations screen to appear 7. Enter Enter the the Purcha Purchase se Quant Quantity ity in in the fiel field d Quantity , i.e. quantity purchased from the supplier 8. Ente Enterr the the purc purcha hase se Rate 9. Acce Accept pt the the above above scr scree een n and the the Excise Details screen to appear 10. Enter Enter the Supplier Invoice Number and Supplier Invoice Date 11. Enter Enter the PLA RG 23 Sl. No. if any 12. Enter Enter the Quantity on hand in the field Excise Opening Stock and accept the Excise Dealer sub form Note: For accurate Duty calculations , all the fields in the above screen have to be accepted.
13. Accept Accept the the above screen Similarly, the Excise Details sub form for the Stock Item purchased from MICO Manufacturing Limited appears as shown The Excise Opening Stock appears as shown Note: The Excise Opening Stock voucher is an optional voucher, which will not affect your Book of Accounts. They can be viewed under Exception Reports and Day Book.Accept the above screen Creating an Excise Purchase Invoice The Voucher Types created should be used for all the purchase and sales entries of Excise transactions. The Excise feature supports Multi Currency and Voucher Class. Go to Gateway of Tally > Accounting Vouchers > Select F9: Purchase 1.
Select Select the Excise Excise Purcha Purchase se as the Voucher Voucher Type Type from from the the list list of Vouche Voucherr type typess in in the the Invo Invoice ice mode. mode.
2.
Sel Select ect It Item Invoi nvoice ce on the righ rightt si side of the scree creen n
3.
Ente nter th the Su Suppl pplier Invoice No No. an and Da Date
4.
Sele Select ct the the appr appropr opria iate te Part Party’ y’ss A/c A/c Nam Namee fro from m the the lis listt disp displa laye yed d
The Party Details sub-form will appear as shown
5.
Supplier’s Details
This section will include the Consignee and supplier details like the contact details, Sales Tax nu mber and the Excise registration details. The details will appear automatically if they are provided during the Supplier Ledger Creation. Note: The Consignee and the Supplier details appear if Allow separate Buyer and Consignee Names in F12: Configuration is enabled 6.
Manufacturer/Importer De Details
If your supplier is not a Manufacturer, enter the name, address, Excise registration details Invoice number an d date of Invoice, of the Supplier Manufacturer /Importer. If you are not a Self Importer, you can enter the respective company details. After entering the above details, the Accounting Voucher Creation screen re appears. 7. Select Select the the Natur Naturee of Purc Purchas hasee from from the the list list of of Natur Naturee of Purc Purchas hase. e. This This field field defin defines es the the Suppl Supplier ier’s ’s role role in selling the product to us. Agent of Manufacturer is selected when the supplier is an agent of the manufacturer and the goods is directly sold from the manufacturer to the buyer. The buyer is a First Stage Dealer. In this case the excise invoice may be issued by the manufacturer or the agent. First Stage Dealer is selected when the goods are directly purchased from the First Stage Dealer. In this case the excise invoice is issued by the First Stage Dealer. Importer is selected when the goods are directly self imported. In this case the invoice is issued by the exporter. Manufacturer is selected when the goods good s are directly purchased from the manufacturer. In this case the excise invoice is issued by the manufacturer. Purchase from Importer is selected when the goods are purchased from the importer. In this case the invoice is issued by the importer. Second Stage Dealer is selected when the goods are purchased from the Second Stage Dealer. In this case the invoice is issued by the Second Stage Dealer.
Note: By default the Nature of Purchase selected in the Party Ledger appears in the above field which can be changed. 8.
Select the Purchase Ledger.
9.
Select the VA VAT/Tax Cl Class fr from the li list.
10. Select Select the the Stock Stock Item from from the the List List of Stock Stock Items Items table table to disp display lay the the Excise Excise Detai Details ls (Exci (Excise se Alloca Allocatio tions) ns) Screen. Note: The List of Stock Items displayed will list the the Stock Items with Excise feature enabled
11.
Select Select the Name Name of the Item Item and and the Item Item Exci Excise se All Allocat ocation ionss Scree Screen n appea appears. rs.
12. 12.
Enter nter the the Ord Order er Num Number, ber, if any any
13. 13.
Ente nter the Quant antity and and Rate
14.
Accept Accept the the Item Item Alloc Allocati ation on Screen Screen for for the Exci Excise se Detail Detailss sub-sc sub-scree reen n for the the stock stock item item will will appea appear. r.
16. The Supplie Supplierr Invoice Invoice No. is is automatic automatically ally captured captured from from the the Ref field in the the Voucher Voucher entry screen. screen. However, However, it is an editable field. Note: The Supplier Invoice No. is mandatory and can be alphanumeric. If the Ref No. is not entered in the Voucher creation screen, then the Supplier Sup plier Invoice No. field by Default will appear as Not Applicable and the cursor remains in the field until a valid number is entered. The Supplier Invoice Date is mandatory. The date has to be same or lesser than the Voucher date. 17. The Suppl Supplier ier Invoi Invoice ce Date Date and the Asse Assess ssabl ablee Value Value is automa automati ticall cally y capture captured. d. Howeve However, r, the above above field fieldss can be edited. Ensure that the Supplier Invoice Date is same as the Excise Purchase Invoice date. Any additional cost apart from basic value falling under the purview of Excise can also be included in the Assessable Value field. 18. 18.
Ente nter th the PL PLA RG RG Nu Number, if if an any
19.
The Type Type of of Duty Duty and the the Rate Rate of Duty Duty defaul defaults, ts, as as speci specifie fied d in the the Item Item Master Masterss Creat Creation ion scre screen en
Note: The entries for the Excise Duty have to be passed in Invoice mode only. 20.
Accept Accept the Excise Excise Detail Detailss sub sub scree screen n for for the the Vouch Voucher er Entr Entry y scree screen n to reappea reappear. r.
21. 21.
Sele Select ct the the req requi uire red d Exci Excise se Dut Duty y Led Ledge gers rs
2 2.
Accept th the In Invoice to to Sa Save
Creating a Non Excise Purchase Invoice for Excise Stock Item Go to Gateway of Tally > Accounting Vouchers > Select F9: Purchase 1.
Sele Select ct the the Pur Purch chas asee Vou Vouch cher er from from the the Lis Listt of of Vou Vouch cher er Type Types. s.
2.
Ente Enterr a Refe Refere renc ncee Num Numbe berr in in the the Ref Ref fiel field d if if requ requir ired ed..
3.
Sele Select ct the the appr appropr opria iate te Part Party’ y’ss Acco Accoun untt Nam Namee fro from m the the list list disp displa laye yed. d.
4.
Enter nter the the det detai aills in in the the Part Party y Det Detai aills sub sub for form.
5.
Sele Select ct the the Pur Purch chas asee Led Ledge gerr for for the the Led Ledge gerr All Alloc ocat atio ion. n.
6.
Sele Select ct the the Exc Excis isab able le Sto Stock ck Ite Item m fro from m the the Lis Listt of of Ite Item ms tab table le..
Note: The list of items will consist of Excisable Excisable and Non Excisable stock items 8.
The It Item All Allocat ocatio ion n scr scree een n app appea earrs as as sho shown wn bel below. ow.
9. Specif Specify y the the Quant Quantity ity and the Rate Rate of the Stock Stock Item Item and accept accept the the Item Item Allocat Allocation ion screen screen for the Purcha Purchase se Creation screen to reappear. 10. 10.
Ente nter Na Narrati ation if if re required.
12. 12.
Accept the vouche cher to Save. ve.
In the above scenario, credit cannot be passed on the stock item. Creating an Excise Sales Invoice To create a Sales Invoice, Go to Gateway of Tally > Accounting Vouchers > F8: Sales 1.
Sele Select ct Exc Excis isee Sale Saless Vouc Vouche herr type type fro from m the the lis listt of Vouc Vouche herr Type Types. s.
2.
Ente Enterr the the Sale Saless Inv Invoi oice ce Num Numbe berr in the the No. No. Fiel Field d if the the Vouch Voucher er typ typee is set set to to Manu Manual al..
3.
Sele Select ct the the Par Party ty’s ’s Ac Name Name from from the the list list disp displa lay yed. ed.
4.
The Par Party Deta Detaiils sub sub--for form app appea earrs as as bel below ow..
Note: The Buyer's Details will appear automatically if specified during the ledger creation. creation. 5.
Ente Enterr the the deta detail ilss in in cor corre resp spond ondin ing g fie field ldss and and accep acceptt the the scre screen en to save. save.
6.
Sele Select ct the the Sal Sales es led ledger ger for for all alloc ocat atio ion n on retu return rnin ing g to the the Vouc Voucher her Entr Entry y Scre Screen en..
7.
Sel Select ect the the Stoc Stock k It Item from rom the the list of Item tems.
8.
On select selecting ing the item, item, the Supplie Supplierr Deta Details ils sub-sc sub-scree reen n for for the item item appea appears rs as shown shown below. below.
9. Select Select the the appro appropri priate ate purc purchas hasee from from the the List List of Purc Purchas hases es tabl table. e. This This tabl tablee lists lists all the purchas purchases es made made for for the the Stock Item. 10.
Upon Upon selecti selecting ng a Purchas Purchase, e, the curso cursorr skips skips to Quant Quantity ity Util Utilize ized d field. field. The value value in this this file filed d can be alter altered. ed.
If the Purchased quantity is 100 and the Utilised quantity is 25, it can be specified in the above abov e field. Note: If the utilized quantity is more than the purchased quantity, Tally warns you with a message 11. On selec selectin ting g the second second entr entry, y, Tally Tally fil filter terss the List List of of Purcha Purchases ses to to displa display y the purc purchas hases es made made from from the Supplier and the nature of purchase specified in the first entry. Note: The Supplier Details sub-form can hold the details belonging to a Single Supplier and one type of purchase only. 12. After After selec selectin ting g the Suppli Supplier er Detail Details, s, the Item Item Alloca Allocatio tion n screen screen for the the Stock Stock Item Item appear appears. s. The detai details ls are are automatically captured from the supplier details sub form. However, the fields can be altered. 13. 13.
Acce Accept pt the the Inv Invoi oice ce to sav savee the the ent entry. ry.
14. Use Alt Alt+P +P from from the the Sales Sales Invoic Invoicee Screen Screen to disp display lay the the print print previ preview ew of the the Sales Sales Excis Excisee Invoic Invoicee (ISSUE (ISSUE OF OF INVOICE UNDER RULE 11 OF CENTRAL EXCISE RULES 2002). Set the print configuration co nfiguration for the Sales Excise Invoice by selecting the appropriate buttons 15. Press Press Alt+I Alt+I and and accept accept Yes Yes to print print prev preview iew the the Sales Sales Excis Excisee Invoice Invoice scre screen. en. The The previe preview w of Excis Excisee Sales Sales Invoice appears as shown below: The Excise Sales Invoice includes the Sales details of the Stock item sold, like the Quantity, Rate and Amount. The Excise Duty passed on credit information will contain Assessable Value, Rate of Basic Excise Du ty, Rate of Cess and Cess amount is printed in this section. To print the Purchase details and Excise duty breakup in the Excise Sales Invoice, click on F12: Configure. Set Print Trader Supplier info to Yes. Setting this option to Yes, the Excise details of the Stock item are printed in the Invoice with supplier and Manufacturer’s Excise details and Invoice No. and Date of Purchase. The preview of the Excise Sales Invoice appears as shown below. The Invoice can be printed in Neat Format only. The Excise Sales Invoice will include the Supplier and the Manufacturer’s details and the Customer details. This invoice provides you with the Purchase and Sales details of the Excise Stock Items, along with the Excise Duty paid on the Products. In the above screen, it is assumed that the Excise Stock Items are purchased from a First Stage Dealer. Hence, the Sales Excise Invoice is titled as Second Stage Dealer, which indicates the stage of this Transaction. The title of Excise Invoice printing will be as follows: If the Stock Items are purchased from a Manufacturer/Importer, then the sales invoice for that item will print as First Stage Dealer. If the Stock Items are purchased from a First Stage Dealer, then the sales invoice for that item will print as Second Stage Dealer. If the Stock Items are purchased from a Second Stage Dealer, then the Sales Invoice for that item will print as Second Stage and Subsequent Dealer. The Sales Excise Invoice prints the VAT/CST/ST registration details, captured from Company Creation Screen. Range/Code, Division / Code, Commissionerate The details specified in the Excise Details sub form of the Statutory & Taxation of F11: Features is printed in the corresponding fields. Buyer/Consignee details The Buyer/Consignee details specified in the P arty Details sub form is printed in this field. The details will also include the corresponding Excise and Tax registration details. Sales Section This section will print the Excise Stock Items sold. It displays the Quantity, Rate and the total Amount of the Stock Items sold.
Excise Duty passed on credit information will contain Description of goods, Assessable Value, Rate of Basic Excise Duty, Rate of Cess and Cess amount is printed in this section. If the quantity of Stock Items sold is less than the purchased quantity, then the proportionate Assessable Value of item is captured along with the Rate of Duty of Item and Education Cess from the Purchase Invoice. The Amount of Excise Duty and Amount of Cess is printed in words. Note: Similarly, if there is more than one type of duty, then the breakup of the duties are printed. VAT Declaration The VAT Declaration is printed if the VAT ledgers are allocated in the sales entry. e ntry. Purchase Section This section prints the purchase details of the Stock Items. The Supplier details like the Name and Address along with the Excise Registration details, of the Manufacturer/Importer, First Stage or the Second Stage Dealer is printed in this field. It also prints the Purchase Invoice number and the Date of the Purchase invoice issued by the Supplier and the Manufacturer. The Invoice will also print the PLA RG Serial numbers. The Excise Duty Section will list the Description of Goods, Tariff Classification number of the Stock Item and the Quantity of the Stock Item purchased. The Rate of Basic Excise Duty, Assessable Value, Duty per Unit, Total Duty Amount and Ed Cess amount is captured from the corresponding Purchase Entry. Note: Excise Sales Invoice as per Rule 11 should be a single page document. Therefore, it is recommended to use a maximum of Six Stock items and one ledger on an A4 size paper and seven stock items and one ledger on Legal size paper. The preview of a Sales Invoice for an Import transaction appears as shown. Note: The Excise Sales Invoice prints an Import Declaration for an Import Transaction. For Excise as well as Commercial invoicing with a Single sequence sequence of voucher numbers, refer Excise/Commercial Invoicing in single sequence. Creating a Sales Invoice without passing Excise Duty Tally allows you to sell an Excise Stock Item using an Excise Sales Invoice or Standard Commercial invoice where duty is not passed on to the buyer. For Example: Assume that you have 20 nos of Excisable Stock Item You can sell both 10 nos of Excisable Stock Item and 5 nos of Non Excisable Stock Item in a single sales invoice. The above example can be entered in a single Sales Invoice screen as displayed below: 1.
Go to Gate Gatewa way y of of Tall Tally y > Acco Accoun unti ting ng Vouc Vouche hers rs > F8: F8: Sale Saless
2.
Sel Select ect Sal Sales Invoi nvoice ce from from the Vouc Vouche herr Type Typess
3.
Enter nter the the ref refer eren ence ce num number ber in in the Ref Ref fiel ield
4.
Sele Select ct the the Par Party ty’s ’s A/c A/c nam namee fro from m the the List List of Ledg Ledger er Acco Accoun unts ts
5.
Sel Select ect the the Sal Sales ledge edgerr for for ledg ledger er all allocat ocatiion. on.
6.
Select Select the Stock Stock Item Item from from the the List List of Stock Stock Item Itemss table table to disp display lay the Suppli Supplier er Deta Details ils sub form. form.
7. The Purc Purchas hasee entri entries es passe passed d for for the the Stock Stock Item Itemss using using an Excise Excise Purcha Purchase se Vouch Voucher er Type Type is is displ display ayed ed in the the List List of Purchases table. 8.
Select the Pur Purcchase ase ent entrry fr from the li list.
Note: If you do not wish to select the purchase transaction with Excise duty value for the item, you may select Not Applicable, and then specify the Item quantity in the item allocation screen. 9.
On sel selec ecti ting ng the the ent entry ry,, spec specif ify y the the quan quanti tity ty to to be sol sold d in the the Qua Quant ntit ity y Util Utiliz ized ed fie field ld..
10.
You can sele select ct the the purch purchase ase entr entries ies belongi belonging ng to differ different ent Party Party’s ’s in in the the same same sub sub form. form.
11.
Acce Accept pt the the abo above ve scr scree een n for for the the Item Item All Alloc ocat atio ions ns scr scree een n to appe appear ar..
12.
If the the above above Stock Stock Item Item is is not Exci Excisab sable, le, then then speci specify fy the the same same in Quanti Quantity ty field field of the the Item Item Alloc Allocati ation on screen. screen.
Note: In the above screen, 10 items are Excisable and 5 items are Non Excisable. 1 3.
Accept th the sc screen to to Sa Save.
Creating an Excise Debit Note Go to Gateway of Tally > Accounting Vouchers > Debit Note (Ctrl + F9) F9 ) 1.
Sele Select ct the the Debi Debitt not notee cre creat ated ed for for Exci Excise se from from list list of Vouch Voucher er Type Types. s.
2.
Ente nter the Re Ref num number in in th the Re Ref field.
3.
Sele Select ct Part Party y’s A/c A/c Nam Namee fro from m the the list list of ledg ledger er acco accoun unts ts
4.
Spec Specif ify y the the requ requir ired ed deta detail ilss in in Par Party ty deta detail ilss sub sub form form..
5.
Sel Select ect the Pur Purchas chasee ledg ledger er for allo alloca cati tion on
6.
Sel Select ect the the Item Item from from the li list of Exci Excise se Stoc Stock k Ite Item ms
7.
The The Exc Excis isee Det Detai ails ls sub sub for form m for for the the Sto Stock ck Item Item appe appear ars. s.
8.
Sele Select ct the the Pur Purch chas asee Inv Invoi oice ce from from the the Lis Listt of of pur purch chas ases es..
9.
The cursor cursor then then skips skips to Quantit Quantity y Retur Return n field field.. Speci Specify fy the the quant quantity ity to be retu returne rned d to the suppli supplier. er.
10.
Acce Accept pt the the abo above ve scr scree een n for for the the Item Item All Alloc ocat atio ion n scre screen en to to appe appear ar..
11. 11.
Acce Accept pt the the Deb Debit it Note Note to save save the the ent entry ry..
Creating an Excise Credit Note Go to Gateway of Tally > Accounting Vouchers > Credit Note (Ctrl + F8) 1.
Sele Select ct the the Cre Credi ditt Not Notee cre creat ated ed for for Exci Excise se from from the the Lis Listt of of Vou Vouch cher er Types Types
2.
Ente nter the Re Ref num number in in th the Re Ref. field.
3.
Select the Party’s A/c Name
4.
Ente Enterr the the corr corres espo pond ndin ing g det detai ails ls in the the Par Party ty Deta Detail ils. s.
5.
Select the Sal Salees le ledger ger to to be be al allocated.
6.
Sele Select ct the the Nam Namee of the the sto stock ck item item from from the the lis listt of of Exc Excis isee Stoc Stock k Ite Items ms
7.
The The Supp Suppli lier er Deta Detail ilss sub sub for form m for for the the Stoc Stock k Ite Item m is is dis displ play ayed ed
8.
Ente Enterr the the Sale Saless Invo Invoic icee Num Numbe berr iss issue ued d to to the the cust custom omer er..
9.
The The Sale Saless Invo Invoic icee Date Date is auto automa mati tica call lly y capt captur ured ed..
10.
The corre correspo spondi nding ng Purchas Purchasee Invoice Invoicess are liste listed d and select select the the purchas purchasee invoice invoice from from the list list of of Purchas Purchases. es.
11. 11.
Ente nter th the Qu Quant antity re return urned.
12.
The Cred Credit it Note Note scre screen en reap reappea pears, rs, the the rate rate and the the amou amount nt is automa automatic tically ally captur captured. ed.
13. 13.
Accept the scre creen to save.
Creating a Non Excise Credit Note Go to Gateway of Tally > Accounting Vouchers > Credit Note or Ctrl + F8 1.
Sele Select ct defa defaul ultt Cre Credi ditt Not Notee fro from m the the List List of Vouc Vouche herr Typ Types es..
2.
If an an Excis Excisee Credi Creditt Note Note is sel selec ecte ted, d, then then Tal Tally ly prom prompt ptss you you with with the the foll follow owin ing g mess message age..
Therefore, only a default Credit Note has to be passed against a default Sales Invoice. 3.
Ente Enterr the the refe refere renc ncee num numbe berr in in the the Ref Ref fie field ld if requ requir ired ed..
4.
Select Party’s A/c Name
5.
Ente Enterr the the cor corre resp spon ondi ding ng deta detail ilss in in the the Part Party y Deta Detail ilss sub sub for form m
6.
Select the Sal Salees le ledger ger to to be be al allocated.
7.
Select Select the Stock Stock Item Item from from the List List of of Stoc Stock k Item Itemss to to disp display lay the Suppli Supplier er Deta Detail ilss sub sub form. form.
8. The Suppl Supplier ier Detail Detailss sub sub form form wil willl list list the the purch purchase asess for for Excis Excisee Stock Stock Item Itemss only, only, and and hence hence will will not list list the the Purchases. The Non Excisable Stock Item can be allocated in the Item Allocation screen 9. If the the Excis Excisabl ablee Stock Stock Item Itemss are are return returned, ed, then then the quan quantit tity y has to be be entere entered d in the the above above scre screen en by select selecting ing the appropriate Purchase from the table.
10.
If the the Non Non Excisa Excisable ble Stoc Stock k Items Items are are retu returne rned, d, then then selec selectt Not Applic Applicabl ablee in the the above above scre screen. en.
11.
The The Ite Item m All Alloca ocati tion on scre screen en appea appears rs as show shown n bel below. ow.
13. 13.
Ente nter th the re returned ned Qu Quanti ntity.
14.
On accept accepting ing the Item Item Allo Allocat cation ion screen, screen, the Credit Credit Note Note scree screen n reapp reappear ears. s.
EXCISE OR COMMERCIAL INVOICING IN SINGLE SEQUENCE NEXT To view Excise Reports Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise Reports The Dealer Excise Reports menu consists of •
Excise Stock Register
•
Excise Purchase Bill Register
•
Form RG 23D
•
Form 2
•
Sales And Purchase Extract
Excise Stock Register Every Registered Dealer has to maintain Stock Register recording the daily receipt and issue of Excisable goods ready for inspection by the officers of the department. dep artment. The Excise Stock Register in Tally gives the purchase and sales information. It has two sections, which are, the Receipt section for Purchases and Issues section for the Sales/Debit Note/Credit Note details. Go to Gateway of Tally > Display > Statutory Report > Dealer Excise Rep orts> Excise Stock Register Select the Stock Item from the list of items to view the report. The above screen lists the Purchase details. Receipt Invoice No. /Date: The number given to the Invoice. Name and Address of the Supplier: The field displays the Name and the Address of the Supplier. Nature of Purchase: Lists the Nature of Purchase as specified during the Invoice Entry. Quantity: Quantity purchased. Rate: The Rate at which the item is purchased. Assessable value: The Total Assessable Value of the product.
Duty per Unit: The Total Duty amount divided by quantity is printed in this field. Total Duty: The Total Duty for the Stock Item is displayed in this field. This field captures the total Duties paid. Cess per Unit: Excise Cess per item is displayed. Total Cess: Total Cess on the total Quantity of the Stock Item. Issue The Issue/Debit Note/Credit Note details in the Excise Stock Register are specified in the screen below. The F6: Date button lists all the Purchase and Sales transactions for a specified period. Toggle to F6: Purchase Date button to list the Excise Sales/ Excise Credit Note/ Excise Debit Note transactions, for the purchase bills as specified in the Purchase date range. Duty Details Duty Passed On/Duty not Passed on: on : This row displays the details of the Stock Items o n which the duty is passed or o r not passed. Balance Duty: The Balance available Duty Amount to be passed on is displayed in this field. Issued Quantity: The Total Quantity of Items Sold/Returned is d isplayed in this field. Total Duty: This Field displays the Total Duty utilized in whole or proportionate to the Quantity Issued/Returned. The return inward quantity is displayed in negative. Total Cess: The Total Cess Amount utilized is displayed in this field. Use Alt +F1: Detailed to get a detailed Report. The detailed Excise Stock Register appears as shown below. Vch Type/Invoice No./Date/: The Document type, Invoice number and date as specified in the Sales/Credit Note/Debit Note Invoice is displayed in this field. An additional column appears. Vch Type/Invoice No./Date: The Document type, Invoice Number and Date as specified in the Sales/Credit Note/Debit Note Invoice are displayed in this field and the Duty Details column displays the Name and Address of the Party. This Column also details the Duty Passed On, Duty not Passed On and the Balance Duty. Use the Alt + P key ke y or click on the Print option o ption to print your Report. The printed document do cument will appear as shown below. The preview of the Excise Stock Register on pressing Alt + F1 is as shown below. Note: The Excise Stock Register can be printed in Neat Mode format only. Excise Purchase Bill Register The Excise Purchase Bill Register provides the bill wise details o f all the purchase and corresponding sales invoices for each of the purchase invoices. The Register consists of two sections Receipt and issue.
Receipt This section details the Purchase details. Invoice No. / Date: This column displays Purchase Invoice number and Date. Particulars: This column displays the Stock Item purchased and its Tariff Number. Name and Address of the Supplier: This column displays the Name and the Address of the Supplier. Nature of Purchase: This column lists the Nature of Purchase as specified during the Invoice Entry. Entry. Quantity: This column displays the Quantity purchased. Rate: The Rate at which the item is purchased appears in this column. Assessable Value: The Total Assessable Value of the item ap pears in this column. Total Duty: The Total Duty for the Stock item is displayed in this column. Total Cess: The Total Cess Amount calculated on the purchased quantity is displayed in this column. Issue This section displays the Sales/Credit Note/Debit Note details. Duty Details Duty Passed On / Duty Not Passed On: This column displays the Duty details on the quantity sold. Balance Duty: The Balance Unutilized Duty Amount is displayed in this column. Issued Quantity: The Total Quantity of Items Sold/Returned is d isplayed in this column. Total Duty: This column displays the Total Duty Utilized in whole or proportionate to the qua ntity Issued/Returned. Total Cess: The Total Cess Amount utilized on the Stock items Issued/Returned On using Alt + F1: Detailed, an additional column displays the Voucher details column. Vch Type/ Invoice No. / Date: This column displays the details of the Voucher entries passed. Name and Address of the Party: On selecting Alt +F1 the Duty Details column displays the Name and address of the Party account. F2: Period displays all the Purchase entries corresponding to the date specified. The preview of the Excise Purchase Bill Register appears as follows The preview of the Excise Purchase Bill Register on pressing Alt + F1 is as sho wn below. Form RG 23D Form RG 23D details the Excise purchases an d the corresponding Sales transactions.
The preview of Form RG 23D 2 3D prints as shown. Invoice No. /Date: The Purchase Invoice number and the date are displayed in this field. PLA RG23 Sl. No.: The PLA RG23 serial number for the Purchase Invoice is printed in this field Name and Address of Manufacturer/ Importer including Central Excise Regn No/ Range/ Division/ Commissionerate Commissionerate The Manufacturer/ Importer details entered in the Party details sub form of the Purchase voucher is printed in this field. Quantity: The quantity of items purchased is printed in this field. Rate: The rate of the Stock Item purchased is printed in this field. Assessable Value: The Assessable Value of the Stock Items is printed in this field. Duty per Unit: The Excise Duty paid per unit is printed in this field. Excise Duty: The Excise Duty calculated ca lculated on the Assessable Value is printed in this field. Edn Cess per Unit: The Education Cess paid per unit is printed in this field. Education Cess: The total Education Cess Ce ss paid is printed in this field. Sec Edn Cess per Unit: The total amount of Secondary Education Cess paid per unit is printed in this field. Secondary Education Cess: The total amount of Secondary Education Cess paid is printed in this field. Total Duty: The Total Duty paid is printed in this field. Duty Passed on This row lists the Excise duty passed on to the corresponding Excise Sales Form - 2 Every Registered dealer is required to submit a return as per Excise Rules 2002 every quarter in Form - 2 Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise Reports > Form – 2 In the Form - 2 printing screen, Press Backspace and specify the From date and To date Form - 2 displays the details of the Stock item with the maximum duty value. va lue. To configure Form – 2 to show details of all stock items, from the above printing configuration screen press F12: configure and set Show All Items to Yes Form - 2 is divided into two sections. The Issue/ Sales section and the Receipt / Purchase section. The preview of Form - 2, Issue/ Sales section appears as shown.
Press Pg Down to view the Receipts/ Purchase section, Note: For invoices with more than one Stock item entries, Form - 2 captures the details of the Stock item with the maximum duty component value. 1.
Name Name of the First First Stage/ Stage/Seco Second nd Stag Stagee Deal Dealer: er: The name name of your your compa company ny is is prin printed ted in this this fiel field. d.
2. Excise Excise Regist Registrat ration ion Numb Number: er: The The Excis Excisee Regist Registrat ration ion Number Number of your your comp company any,, specif specified ied in in the F11: Feature Featuress screen is printed. 3.
Addres Address: s: The addres addresss of your your compa company ny speci specifie fied d in the Company Company Creati Creation on scre screen en is is print printed ed in in this this fiel field. d.
4.
Part Partic icul ular arss of of Inv Invoi oice ce issu issued ed by Firs Firstt Stag Stagee / Secon Second d Sta Stage ge Deale Dealer r
This section will list the Sales Invoices. Invoice Number with Date: The Date and the Invoice Number is printed in this field. Description of the Goods: This column list the Stock Items sold Central Excise Tariff Heading: The Tariff Number of the Stock Items are printed in this column. Quantity: The total number of Stock items sold is printed in this column. Amount of Duty: The total amount of Excise Duty passed on for the Stock Item is printed in this column. Amount of Ed Cess: The total amount of Education Cess passed on for the Stock Items is printed in this column. Amount of Sec Ed Cess: The total amount of Sec Education Cess passed on for the Stock Items is printed in this column. 5.
Part Partic icul ular arss of of the the Docum Document entss bas based ed on whic which h the the cred credit it is pass passed ed on
Invoice / Bill of Entry Number with Date: The Purchase Invoice number and date is printed in this field. Name and Address of the First Stage /Second Stage Dealer: This column displays the First Stage /Second Stage Dealer details specified in the Purchase Entries. Name and Address of the Manufacturer / Importer: This column displays the Manufacturer / Importer Importer details specified in the Purchase Entries. Description of the Goods: The description of the goods is printed in this column. Central Excise Tariff Heading: The Tariff the number o f the Stock Items are printed in this column Quantity: The quantity of goods purchased is printed in this column. Amount of Duty: The total duty paid on the Stock Items is calculated in this column. Amount of Ed Cess: The total amount of Education Cess paid on for the Stock Items is printed in this column. Amount of Sec Ed Cess: The total amount of Sec Education Cess passed on for the Stock Items is printed in this column. Sales and Purchase Extract
Excise Sales and Purchase Extract report displays d isplays the details of purchase and sales transactions of all exc isable goods (Excise Invoice as well as Commercial Invoice). Go to Gateway of Tally > Display > Statutory Reports > Dealer Excise Reports > Sales and Purchase Extract In the Sales and Purchase Extract printing screen, Press Backspace and specify the From date and To date The preview of Sales and Purchase Extract appears as shown.
