1) Watch Demo Video
2) Follow Step by Step process
1. Login in to your Excel2Tally.in account
2. Select Template "Receipt Voucher"
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
The Column Names given in RED are compulsory where as the column names given in BLACK are optional.
| COLUMN NAME | EXPLANATION | EXCEL TEMPLATE EXAMPLE |
| Date | It is the day on which we have received cash/goods from the customer and acknowledged it has a receipt. Tally is very flexible and thus allows the user to present the date in various formats but it will be expressed/represented in tally as DD/MM/YYYY OR DD-MM-YYYY. | Recommended formats are 01/02/2018 OR 01-02-2018 |
| Voucher Number | In Tally, voucher numbers are automatically set by default. They are used with some words or are of greater digits such as 101 or A-101 or TAX-101 and so on. You can select the required Method of voucher numbering from the voucher type creation/alteration screen. The Methods of Numbering list appears as shown below: 1)Automatic 2) Automatic (manual over ride) 3) Manual 4) Multi-user Auto | VN-R1 |
| 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 parts 1) ACCOUNTING VOUCHER 2) INVENTORY VOUCHER 3) PAYROLL VOUCHER 4) 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 |
| Is Advance Receipt | Whenever you take advance payment from a customer for a sale that will happen in the future, then there will be a GST levied on that advance receipt too. That’s why you have to issue an advance receipt. That receipt has to contain all the details about your customer and item, except the HSN Code. | |
| Credit Ledgers | Name of the customer or a ledger to be credited | Ganesh Traders,Balaji Traders,Sai Traders |
| Party Name | The name of the customer – used for GST Advance Receipt | Atom customer |
| Address1 | Address of the customer – used for GST Advance Receipt | |
| Address2 | Address of the customer – used for GST Advance Receipt | |
| Address3 | Address of the customer – used for GST Advance Receipt | |
| State | State where your business is being registered for making sales transactions – used for GST Advance Receipt | Maharashtra |
| Place of Supply | It is the registered place of business of the recipient/customer – used for GST Advance Receipt | 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. |
| Registration Type | Registration types are assigned as Regular, Composition, Consumer & Unregistered – used for GST Advance Receipt | Regular, Composition, Consumer, Unregistered |
| GSTIN | All of these businesses will be assigned a unique Goods and Services Tax Identification Number (GSTIN). (It should not exceed 15 characters) used for GST Advance Receipt | 24AABCV123EDG54 |
| Cash / Bank Ledger | This will be your bank or cash ledger in which receipt to be recorded | State Bank of India, HDFC, Branch Cash, Office Cash, Petty Cash, ICICI Bank |
| Bill Name | Ideally this will be the Invoice number against which sales has been made and to be knocked off as against reference | |
| Amount | This is a GROSS AMOUNT of the product before taxes, other charges & discounts | RS 24000/- |
| Ledger / Item | In Tally ERP 9 Account a ledger is the actual account head to identify your transactions and are used in all accounting vouchers. Item referes to the product you are selling. used for GST Advance Receipt | Methanol – A332, Thermostat- 54325, Cotton fabric – L1121 etc… |
| Taxable Value | This is the value on which tax will be calculated. used for GST Advance Receipt | |
| CGST Rate | This will be the tax rate of Central Goods & Service tax. used for GST Advance Receipt | 2.5%, 9%, 14% |
| 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) used for GST Advance Receipt | Rs 1250/- |
| SGST Rate | This will be the tax rate of State Goods & Service tax. used for GST Advance Receipt | 2.5%, 9%, 14% |
| SGSTAmount | 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) used for GST Advance Receipt | Rs 1250/- |
| IGST Rate | This will be the tax rate of Integrated Goods & Service tax. used for GST Advance Receipt | 18%, 28%, 5% |
| IGST Amount | IGST Amount stands for Integrated Goods & Services Tax amount payable. IGST rate will be applicable on inter-state transactions (between the state) , used for GST Advance Receipt | Rs 2500/- |
| Instrument Type | The type of instrument can be Cheque, e-fund transfer, etc | Cheque, e-Fund Transfer |
| Instrument Number | Instrument number is the cheque number, online transaction reference number, etc | 111111 |
| Instrument Date | This is the date on which the cheque has been issued by the party | Recommended formats are 01/02/2018 OR 01-02-2018 |
| Issued Bank | This will be the bank of the issuing party | |
| Branch | Branch here is the branch of the bank | Mumbai |
| 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) Important Note
– Please make sure that the ledger masters already exist in your tally data
– If possible create separate receipt 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
In case of any query, kindly write us on support@excel2Tally.in
For more details visit www.excel2tally.in