Excel to Tally Prime importRead More
No Monthly Cost Pay Once Use Lifetime, Free Trial
Excel to Tally Prime import
Upload GSTR1 from Tally/Excel
GSTR 2A/2B Reconciliation
Trusted Technical Support
Excel to Tally Import Credit Note Vouchers Excel to Tally Import Debit Note Vouchers
Whats is Credit /Debit Note Vouchers
A debit note is a document a seller uses to remind the purchaser of current debt obligations, or a document produced by a purchaser when returning goods purchased on loan. The debit note may include information about an immediate payment or may serve as a reminder of current funds due.
The cumulative expected credit sum may be provided for items returned, along with an inventory of the items returned and the reason for the return.
You can Import Credit/Debit Note Voucher with Following details
How to import Credit/ Debit Note Voucher data using Excel-Tally Software in just a click
Invoice details
You can import data with Invoice Number, Invoice Date, Original Invoice number, Date & Reason code
Buyer Details
You can import data with Buyer Name, Address, state, City, Country & GSTN with place of supply
Consignee Details
You can import data with Consignee Name, Address, state, City, Country & GSTN with Destination
Dispatch Details
You can import Sales voucher with Delivery Note, Delivery Date, Doc No, Dispatched Through and Destination
Order Details
You can import data with Order No, Order Due Date, Tracking No, Other Ref Number,Mode of Payment
Transporter Details
Your can import data with Terms of Delivery, LR/RR No, LR/RR Date, Vehicle No
Stock Item Details
You can import data with Item Name,Item Desc, HSN CODE, Godown, Batch No, ExpiryDate, MFG DATE, QTY, UOM, Item Rate
Tax & Other Ledgers details
You can import data with 25+ other ledgers & Tax ledgers with Auto Creation options in single invoice or multi invoice mode
Cost Center & Narration
Your can import data Party ledger link with Cost center & Cost Category, Also import Narrations in single or Multi invoice mode
Step 1- Put Data In Template Using Smart Mapping
Excel-Tally software provides you smart data mapping functionality, that helps you to copy all your data from your file to a template without any mistakes.
or simply copy-paste your data column-wise from your sheet to the software template file.
STEP 2
Step 2- Now Match Ledger & Items with Tally Before Importing
Click on CONNECT & MATCH LEDGER WITH TALLY BUTTON
Software highlights you New Ledger by Red Color And Duplicate ledger by Green color by comparing with Tally data
(for detail ledger Creation use SHEET 2 OPTION while importing file using software)
Click on CONNECT & MATCH STOCK ITEMS WITH TALLY BUTTON
Software highlights you New Stock Items by Red Color And Duplicate Stock items by Green color by comparing with Tally data (for detail Stock items Creation use SHEET 3 OPTION while importing file using software )
STEP 3
Step 3- Now Use Create GST Ledger Button
Software Auto Creates GST Ledgers by comparing Invoice GST Number & Place of Supply, Accordingly Create Ledgers as SGST & CGST or IGST also calculate their amours as per TAX RATE Specified.
Software Create Other Ledger as per Headings specified in your data with its amounts in a single click.
STEP 4
Step 4- Now Select Template In Software & Click Import ...Done !
Open Excel-Tally Software, it will shows you Dashboard here you can select company in which you want to import data.
Now All set just select template file in software using Credit Note with Inventory Button & Click on Import Button,
check the software dashboard it will show you Count of Ledgers, Stock items,Invoice Records created.
check in tally all your records are imported successfully
follow Same 4 step to import Credit Note without Inventory & Debit Note with or Without Inventory data data using Excel-Tally Software
(Don’t use Create stock item button because without inventory data does not contains any stock items & all other procedure same as above steps)
- Excel to Tally import Ledger Masters
- Excel to Tally import item Masters
- Excel to Tally import Sale Vouchers
- Excel to Tally import Purchase Vouchers
- Excel to Tally import Bank statements
- Excel to Tally import Receipt Voucher
- Excel to Tally import Payment Voucher
- Excel to Tally import Journal Voucher
- Excel to Tally Import Amazon data
- Excel to Tally import Flipkart data
- Excel to Tally import Meesho data
- Excel to Tally Import Payroll Vouchers
Can Import Multi Currency data using Same voucher Template
You can import Multi Currency data in same Voucher template by Providing Amount , Foreign Currency Symbol, Rate Of Exchange
100% Accuracy & Guaranteed Technical Support
90% Renewal ratio rewards us with the Most promising Service we provide
Trusted, Happy & Satisfied Clients
Sales Team
9373335929 / 93229 56608
India -Mumbai
Office : 187, Powai Plaza Powai Mumbai - 400076
Support Team
9137888216 / 9359533218
UAE- Dubai
Office 114, 1st Floor, Al Abbal Building 2, Bank Street,Dubai
Operation Hours
Mon-Sat:10-6.30 (Sunday:off)
India - Ahmedabad
Office 502,Ashwamegh, Ahmedabad-380006
