1) Watch Demo Video




2) Follow Step by Step Process


1. Login in to your Excel2Tally.in account


 



2. Select Template “Sales With Inventory”


 


3. Click “Process Data”



 


4. Add Company & Select Template.


 


5. Download Sample file format


 


6. Once you are ready with your excel data then Choose file and Upload Excel


STEP – 1




 


7.Now Click Process Excel

 

STEP – 2


 


8. Now Click Download XML


STEP – 3



 

9. Now import the converted XML to Tally, using option import data > Vouchers





10. In case data is not imported in Tally than check Tally.imp file for data import log report.




3) Column Wise Explanation


Here are the column wise explanation to help you how it will be imported in your Tally data


The column names given in RED are compulsory and are required to be filled where as  the column names given in BLACK are optional.

COLUMN NAME
EXPLANATION
EXCEL TEMPLATE EXAMPLE
INVOICE DATE
Invoice date is the date on which an invoice for goods is issued, which is usually the same day on which the goods are sent to the buyerTally is very flexible and thus allows the user to present the invoice date in various formats but it will be expressed/represented in tally as
DD/MM/YYYY OR DD-MM-YYYY.
Recommended formats are01/02/2018 OR 01-02-2018
INVOICE NO.
The invoice number is any number (or any other character) assigned to that bill by the issuing company so they can track it laterYou can set the invoice number as per your choice tally also supports prefix suffix. In Tally invoice can be represented as First part : Prefix – ST/
Second Part :Invoice Number – 00085
Third Part is : Suffix – /2015-16 After the introduction of GST Government has mended the invoice number length should not exceed 16 characters (as per GST recommendation) but however tally is flexible and will support more than 16 characters also.
INV/GST/00112/1819, INV/DEL/112/1819
BILL REFERENCE NO.
A reference number is a unique identifier assigned to each transaction.In tally bill wise detail is used to know about parties outstanding detail.
There are four types of bill wise detail:-
1) New reference: – at the time of sales/purchases.
2) Against reference: – at the time of cash received.
3) Advance: – cash received as advance.
4) On account: – at the time of interest charged.
By default Excel2Tally software generates the New Reference
VOUCHER TYPE
Voucher type pertains to Accounting, Inventory and Payroll. These are used for recording various transactions according to the user needs.
In Tally ERP9 Voucher type is the data entry form or screen where we are entering different types of transactions like Sales,Purchase,Receipt etc.
There are 18 vouchers already created in Tally Software,which is divided into four parts1) ACCOUNTING VOUCHER2)INVENTORY VOUCHER3) PAYROLL VOUCHER4) ORDER VOUCHER(THE ABOVE VOUCHERS WILL BE DISPLAYED BASED ON THE FEATURE YOU HAVE ENABLED)
Sales FY 18-19, Sales Delhi, Sales Amazon,
Sales Local
CUSTOMER NAME
The name of the customer / buyer
ATOM Enterprises Pvt. Ltd.
B2C CUSTOMER NAME
B2C, or business-to-consumer, is the type of commerce transaction in which businesses sell products or services to end consumers.
Dhaval Goradia has bought something from amazon or retail shop. Here Dhaval Goradia will be treated as B2C
ADDRESS 1
Address of the customer
Line 1
ADDRESS 2
Address of the customer
Line 2
ADDRESS 3
Address of the customer
Line 3
STATE
State where you are business is being registered for making sales transactions.
Maharashtra
PLACE OF SUPPLY
It is the registered place of business of the recipient
Brad Cars Pvt Ltd’s registered place of business is in Jaipur, Rajasthan. It supplies cars to Ravindra Automobiles, whose registered place of business is in Udaipur, Rajasthan.
COUNTRY
Country in which your business is being registered
India
TIN NUMBER
TIN stands for Taxpayer Identification Number, is unique number allotted by Commercial tax department of respective State. It’s an eleven digit number to be mentioned in all VAT transactions and correspondence. TIN number is used to identify dealers registered under VAT.
11111111111A
CST NO.
CST (Central Sales Tax) ) is a form of indirect tax imposed only on goods sold from one state to another state.
1111111C
GSTIN/UIN
All of these businesses will be assigned a unique Goods and Services Tax Identification Number (GSTIN). (It should not exceed 15 characters)
24AABCV123EDG54
GST REGISTRATION TYPE
GST registration types are assigned as Regular, Composition, Consumer & Unregistered
Regular, Composition, Consumer, Unregistered
DELIVERY NOTE NO.
A document accompanying a shipment of goods that lists the description, and quantity of the goods deliveredIn tally The Delivery Note Voucher is used for recording goods delivered to a customer.
DN-9008
DELIVERY DATE
The date goods have to be deliveredDelivery date is used for recording goods delivered to the customer
Recommended format are
01/02/2018 OR 01-02-22018
LR NO.
LR number represents a receipt which is known as Lorry Receipt (LR)
LR-12332
TRANSPORTER NAME
Name of the transporter who is going to transport the goods
DTDC, V-Trans, Blue Dart
DESTINATION
The end place. the place where the goods have to be delivered
Delhi
ORDER NUMBER
Number of the orderIn tally a order number is the reference to have a link between transactions. For example, if order Number is being selected in the Delivery Note, it will help you to automatically display the details of the items in the Sales Invoice.
The tracking number pop-up list appears after you have entered the name of the item.
ORD-25964A
ORDER DATE
The date of the specific order.
It is a written authorization for a vendor to supply goods or services at a specified price over a specified time period.
Recommended format are
01/02/2018 OR 01-02-22018
TERMS OF PAYMENT
Number of daysIn tally,Payment terms are the length of time that a customer has to pay your invoices. This number, in days, is the length of time after the invoice date or month end the payment needs to be paid by. This will be the payment due date. For example; payment terms of 14 days and the invoice issue date is 01/01/2013, then the invoice due date with be 15/01/2012.
30 days
TERMS OF DELIVERY
Terms of delivery is a information/Instruction given by a customer to the supplier. There are multiple types of terms of delivery which can be explained as
1) If customer is demanding fragile goods he/she would want it in a bubble wrap.2) If any liquid pack in 1 liter bottle3) Dispatch the goods to my warehouse etc
4) COD
Ex-Works, Despatch through XYZ transporter, COD
ITEM NAME
Item Name is basically the name of the product you are selling
Methonal – A332, Thermostat- 54325, Cotton fabric – L1121 etc…
TAX RATE
It is a tax rate specified for the product every product has a different tax rate
5%,18%,21%,25%and so on…
AMOUNT
This is a GROSS amount of the product before Taxes and other charges
RS 24000/-
SALES LEDGER
Sales Account is a part of trading account; hence it is a most important ledgers in overall accounting process.This indicates your turnover.
Tally ERP 9 by default provides sales Account as a default group.You can create unlimited sales ledger based on your business/accounting requirement
Sales @ 18%, Sales Interstate @ 18%, Sales Local @ 28%, etc
OTHER CHARGES_1AMOUNT
Other Charges is a amount which is charged over and above the gross value of the product. Other charges can be positive or negative.For Eg discount can be negative.
Rs 2800/-
OTHER CHARGES_1LEDGER
Other charges in Tally are ideally created under Sales or Expenses group based on accounting requirements
Shipping Charges,Delivery Charges,Packing Charges and so on…
OTHER CHARGES_2 AMOUNT
Other Charges is a amount which is charged over and above the gross value of the product. Other charges can be positive or negative.For eg discount can be negative.
Rs 4200/-
OTHER CHARGES_2 LEDGER
Other charges in Tally are ideally created under Sales or Expenses group based on accounting requirements
Gift Wrapping Charges, Fast Delivery,Shipping and so on
CGST AMOUNT
CGST stands for Central Goods & Services Tax which is a component of the tax reform that will be levied by the Central government on all services and goods.
CGST rate will be applicable on intra-state transactions (within state)
Rs 1250/-
CGST LEDGER
This is a Tax ledger, ideally created under Duties & Taxes group in Tally. You can give name of the ledger as per your preference / accounting requirement
CGST @ 9%, CGST @ 2.5%, CGST @ 14%
SGST AMOUNT
SGST stands for State Goods & Services Tax which is a component of the tax reform that will be levied by the State government on all services and goods.
SGST rate will be applicable on intra-state transactions (within state)
Rs 1250/-
SGST LEDGER
This is a Tax ledger, ideally created under Duties & Taxes group in Tally. You can give name of the ledger as per your preference / accounting requirement
SGST @ 9%, SGST @ 2.5%, SGST @ 14%
IGST AMOUNT
IGST Amount stands for Integrated Goods & Services Tax amount payable. IGST rate will be applicable on inter-state transactions (between the state)
Rs 2500/-
IGST LEDGER
This is a Tax ledger, ideally created under Duties & Taxes group in Tally. You can give name of the ledger as per your preference / accounting requirement
IGST @ 18%, IGST @ 28%, IGST @ 5%
CESS AMOUNT
CESS is a compensation cess levied under section 8 of The Goods and Services Tax (Compensation to State) Act, 2017
Rs 24000
CESS LEDGER
This is a Tax ledger, ideally created under Duties & Taxes group in Tally. You can give name of the ledger as per your preference
250.5
ROUND OFF AMOUNT
Round off means to bring to balance or completion to the transactionBasically in round off if the value in Paise is 50 Paise or more, it is rounded upward to the nearest Rupee, and, if the value in Paise is less than 50 Paise, it is rounded downward to the nearest Rupee.
0.85, -0.15
ROUND OFF LEDGER
Round off ledger ideally created under Sales/Expenses/Purchase group
Round Off
GODOWN
Go down is a place where stock items are stored. You can specify where the stock items are kept.
Tally is very user friendly and thus provides you options to create multiple go downs but however by default tally creates single go down i.e. MAIN LOCATION
Main location, Bhiwandi Warehouse, Amazon FBA, etc
COST CENTER
A part of an organization to which costs may be charged for accounting purposes. The cost center in Tally.ERP 9 refers to an organizational unit to which costs or expenses can be allocated during transactions while the cost category is used to accumulate costs or profits for parallel sets of cost centers.
HR Department,
Sales Department,Engineering Department
NARRATION
A small brief explanation.
Being goods sold



4) E-Way Bill Helper



Column Name
Recommended Value
Sub Type
Exhibition or Fairs

Export

For Own Use

Job Work

Lines Sales

Others

Recipient Not known

SKD/CKD

Supply


Document Type
Tax Invoice

Bill of Entry

Bill of supply

Challan

Credit Note

Others

Tax Invoice


Status of E-way Bill
Cancelled by me

Generated by me

Generated by other party on my GSTIN

Rejected by me

Rejected by other party


Mode
Road

Air

Rail

Ship



5) Important Note


– Please make sure that ledger masters are already exist in your tally data

– If possible create separate sales voucher types with voucher numbering method manual & prevent duplicate = YES

– Option “Ignore errors during data import” should be YES. Find this option on Gateway of Tally > Press F12 > General



For any queries write us on support@excel2tally.in