1. Home
  2. How do I Import Data From Excel to Tally
  3. How do I Import Credit Note With Inventory from Excel to Tally

How do I Import Credit Note With Inventory from Excel to Tally

watch demo video

Follow step by step process

1. Login in to your Excel2Tally.in account

 

2. Select Template “Credit Note 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.

Column wise Explanation

Column Name Explanation Excel Template Explanation
Voucher Date This will be the voucher date Recommended format are
01/02/2018  OR  01-02-22018
Voucher No 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
Original Invoice No This will be the Original customer invoice number against which we are crediting the customer account
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 buyer
Tally 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 are
01/02/2018  OR  01-02-2018
Reason Code This will be the code specified by the GST department to be presented while issuing the debit note
Following are the predefined list of reason codes
01-Sales Returns
02-Post Sales Discount
03-Deficiency in Service
04-Correction in Invoice
05-Change in POS
06-Finalization of Provisional Assessment
07-Others
01, 02, 03,04,05,06,07
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
Address 2 Address of the customer
Address 3 Address of the customer
State State where your business is being registered Maharashtra
Place of Supply This will be the place to which supply has been made 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 No 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. 2744587275V
CST No CST (Central Sales Tax) ) is a form of indirect tax imposed only on goods sold from one state to another state. 2744587275C
GSTIN/UIN All of these businesses will be assigned a unique Goods and Services Tax Identification Number (GSTIN). (It should not exceed 15 characters)
Registration Type GST registration types are assigned as Regular, Composition, Consumer & Unregistered Regular, Composition, Consumer, Unregistered
Buyers Debit Note No Debit note is a document informing the seller by the purchaser that he is debiting seller account in his books of accounts due to some reasons The debit note is an intimation and a legal document accompany with the purchase return
Basically it is the number on that debit note
GT-001
Buyers DN Date It is the day on which the seller issues the debit note to the buyer.
Tally 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 format are
01/02/2018  OR  01-02-22018
Delivery Note No A document accompanying a shipment of goods that lists the description, and quantity of the goods delivered
In tally The Delivery Note Voucher is used for recording goods delivered to the supplier
DN-9008
Delivery Date The date goods have to be delivered
Delivery date is used for recording goods delivered to the supplier
Recommended format are
01/02/2018  OR  01-02-22018
Order No Number of the order
In 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 Purchase 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
Term of Payment Number of days
In 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 bottle
3) 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…
Item Description Item description is basically detailed information about the specific item  like nature,size,colour and so on Best Quality, Size – 12, Color – Blue
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…
Batch No Batch No means a specific quantity or material that is intended to have uniform character and quality, within specified limits, and is produced according to a single manufacturing order during the same cycle of manufacture. B-123
QTY Qty is defined as an abbreviation for “quantity” and means the number or amount of something that quantifies that you wanted to Sell or Purchase 5 Nos, 5 KGS, 5 Ltrs, 5 Pcs
UOM UOM stands for UNIT OF MEASURE.
A unit of measure is assigned to all inventory items and must be defined before a product can be entered. Each product will have a stocking unit of measure a purchasing unit of measure.
Pcs, Nos, Kgs, Ltrs, Box, etc
Rate A fixed price paid or charged for Goods or Services Per Unit Rs 12500/-
Amount This is a GROSS AMOUNT of the product before taxes, other charges & discounts  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_1 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 2800/-
Other Charges_1 Ledger Purchase and sales are part of trading account; hence these are most important ledgers in overall accounting process.                                                                                                                                                         Tally ERP 9 by default provides Purchase Account as group.You can create unlimited Purchase ledger based on your business  Purchase @ 18%, Purchase  Interstate @ 18%, purchase Local @ 28%, etc
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 Shipping Charges,Delivery Charges,Packing Charges 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 and business requirements CGST @5% , CGST @9%, CGST @10%
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 and business requirements SGST @5% , SGST @9%, SGST @10%
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 and business requirements IGST @10% , IGST @18%, SGST @20%
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 transaction                                                        Basically 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
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
Godown Godown 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  godowns but however by default tally creates single godown i.e. MAIN LOCATION
Main location, Bhiwandi Warehouse, Amazon FBA, etc
Narration A small brief explanation. Being Goods Returned Quality Issue

Important Note

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

– If possible create separate credit note 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

Updated on August 4, 2018

Article Attachments

Was this article helpful?

Related Articles

Add A Comment

Help-Desk