Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...
3. Excise for Dealer-Sale @ Tally.ERP9 ...

Example :

Swayam Industries sold the following Items to Reliance Engineers.

 

Item Descriptions

Copper Rolled Coils-10 mm

Qty ( Mts)

250

Rate

600

VAT

4%

 

 

Solutions :

Step-1 :

Create Voucher Type for Excise Sale under Sales.

    • Go to Gateway of Tally.ERP à Accounting Info à Voucher Types à Create
    • Enter Excise-Sale as name of the Voucher Type
    • Select the Type of Voucher as Sales from the list of Voucher Types.
    • Type the Abbr. as Ex-Sal.
    • Select the Method of Voucher Numbering as Automatic.
    • By default, Use Common Narration is set to Yes.
    • Set Use for Dealer Excise to Yes.
    • Accept other fields as default.

Step 2 :

  1. Create Ledger : ‘Reliance Engineers’ under ‘Sundry Debtor’
    • Set Maintain Balances bill-by-bill to YES.
    • Set Excise Details to Yes.
Ensure the Excise Details screen displays as shown :

 

    • Press Enter to accept the Excise Details screen.
    • Press Y or Enter to accept the Reliance Engineering Ledger creation.

     2. Create Ledger : Sales-Excisable Goods ( under Sales Account)

    • Set Used in VAT Returns to YES.
    • Select Sales @ 4% from the VAT/Tax Class.
    • Press Y or Enter to accept the Sales-Excisable Goods Ledger Creation.

    3. Create Ledger : Output VAT @ 4% ( under Duties & Taxes)

    • Types of Duty/Tax : VAT
    • VAT/Tax Class : Output VAT @ 4%.

Step 3 :

Make an Entry of the transaction in a Sales Invoice.

 

Go to Gateway of Tally.ERP àAccounting Vouchers à Press F8 à Select the Voucher Type as Excise-Sales

 

  1. Party’s A/c Name : Reliance Engineers
  2. Accepts Supplier’s Details by default
  3. Select: Copper Rolled Coils-10mm as the Name of the Item.
  4. The Supplier Details screen displays as shown.
  • Select the relevant Invoice No from the List of Purchases
 
 
Text
 
 
Company Information @ Tally.ERP9
 
Group & Ledger

Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES

Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
Tally.ERP9 MIS and Other Reports
Statutory & Taxation
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

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. This Website is not associated with any product or vendor mentioned in this Website.

 
GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com