EXCEL TO TALLY DATA IMPORT AND FREE DEMO

Excel to Tally Single Addon

Excel to Tally import Ledger Masters with all this details using single template

 
You can import ledger master with GST number, Registration type, Name, Address with state city country EXCEL TO TALLY DATA IMPORT AND FREE DEMO
 

You can import Name Alias,detail address, Contact Person, PhoneNo, MobileNo, Email, Website & more

 

Balance Details

Your can import Debit Credit Opening Balance of Ledgers Also  Credit period & Cost center details if needed EXCEL TO TALLY DATA IMPORT AND FREE DEMO
 
 
Tax Ledgers in details

You can import Tax ledger with Tax Rate as CGST, SGST, IGST, Nature of transactions & Applicable date 

 

Ledger Group wise import

Your can import import Ledger master in specified group name with Alias Name 

 

Excel to Tally import ITEM Masters with all this details using single template EXCEL TO TALLY DATA IMPORT AND FREE DEMO

 

GST details

You can import Item master with HSN Code with HSN description 

 

Item Details

You can import Item Name with different types of Alias code , Part No

 

MRP & Standard Price

Your can import Stock item with MRP & Standard Price with Applicable date

 

Batch & MFG date

You can import item master with Batch, Godown & MFG dates 

 

GST rate details

You can import Item with Tax Rate, CGST, SGST, IGST & Applicable date 

 

Opening Quantity & Rate

Your can import import team master with Opening Quantity & Rate

 

Excel to Tally import Sales Vouchers with or Without inventory

Excel to Tally import Credit note Vouchers with or Without inventory

Excel to tally imports vouchers entries with Multi inventory in one single voucher mode with following details EXCEL TO TALLY DATA IMPORT AND FREE DEMO

Excel to Tally import Purchase Vouchers with or Without inventory

Excel to Tally import Debit note Vouchers with or Without inventory

Excel to tally imports vouchers entries with Multi inventory in one single voucher mode with following details EXCEL TO TALLY DATA IMPORT AND FREE DEMO

 

Invoice details

You can import data with Invoice Number, Invoice Date, Bill ref number & invoice Voucher Type.

 

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 

 
” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/006-online-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Excel to Tally import Bank Statement with Auto reconciliation

Excel to tally import Bank statement of any bank using simple Excel template. from single template software auto create voucher types as per debit Credit amount respectively Receipt & Payment vouchers. 

All Ledger in template are auto created & according to Ledger groups software auto Creates Contra voucher type 

Bank & Cheque details as instrument number, Date & Bank data also import from Excel file 

 

Transaction details

You can import data with transaction date, Transaction id & Descriptions

 

Cheque Details

You can import data with cheque Number, Date, Bank Name & Branch

 

Ledgers details

You can import data with Party, bank , Cash, Suspense Ledgers 

 

Payment Vouchers

You can import data with Payment voucher as per Debit Amount

 

Receipt Vouchers

You can import data with Receipt Voucher as per Credit Amount

 

Contra Vouchers

Your can import data with Contra vouchers as per ledgers Cash or bank

 

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 

 

Excel To Tally Imports All Types Of Transaction Vouchers With

 

Invoice details

You can import data with Invoice Number, Invoice Date, Bill ref number & invoice, cheque Number, Date, Bank Name & Branch

 

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 

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Ledger-Report-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Receipt Vouchers

Excel to Tally import Receipt voucher with separate excel template having features to import receipt entry with auto Debit Credit Ledgers creation, Multiple Bill Reference Number, Bank & Check Details.

 

Payment Vouchers

Excel to Tally import Payment voucher with separate excel template having features to import Payment entry with auto Debit Credit Ledgers creation, Multiple Bill Reference Number, Bank & Check Details.

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Payment-Voucher-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Journal Vouchers

Excel to Tally import Journal voucher with separate excel template having features to import Journal entry with auto Debit Credit Ledgers creation, Multiple Bill Reference Number, Bank & Check Details.

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Purchase-without-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Contra Vouchers

In Bank Statement All Ledger in template are auto created & according to Ledger groups software auto Creates Contra voucher type 

 

 

Excel To Tally Import E Commerce Data

When we export data from E commerce portal like Amazon, Flipkart, paytm etc they provide data in combine format means all Sales & Credit note Entries merge in single file, it very complex to sort data ,that why provide 2 type of MTR Templates as 

MRT+ for Sales with positive value Credit note 

MRT- for Sale with Negative value Credit not

We also provide Separate template features for Commission & Settlement 

 

Excel to Tally import Amazon
E commerce data

1- Import Amazon MRT+ data

2-Import Amazon MRT – data

3-Amazon Commission data

4-Amazon Settlement data

 

Excel to Tally import Flipkart E commerce data

1 Import Flipkart MRT+ data

2-Import Flipkart MRT – data

3-Flipkart Commission data

4-Flipkart Settlement data

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Purchase-with-3-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Excel to Tally import All Brand E commerce data

1 Import E Commerce MRT+ data

2-Import E Commerce- data

3-E Commerce Commission data

4-E Commerce Settlement data

 
” alt=”” width=”256″ height=”256″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/025-analytics.png.webp” data-no-retina=”” data-ll-status=”loaded” />

Excel To Tally Import Multi Currency Data

Many organizations have transactions in more than one currency. Such transactions have to be recorded either in the base (home) currency or in the foreign currency.

For this Excel-Tally software provide AddOn Feature to import Multi currency data in same Voucher templates 

Means from Same template feature as Sales, Purchase, Receipt, Payment, Journal  voucher can import in Multi currency format 

 

Excel To Tally Import Payroll Data

Using Excel-Tally Software you can import all type of Payroll Masters & Voucher using different template features as 

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Employee-Voucher-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Employee Master

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Stock-Journal-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Pay heads

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/027-consultant-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Attendance Heads

” alt=”” width=”150″ height=”150″ data-src=”https://www.excel-tally.com/wp-content/uploads/2020/04/Purchase-without-150×150.png” data-no-retina=”” data-ll-status=”loaded” />

Payroll and Attendance Vouchers

 

CALL US FOR ANY QUERY WE ARE GLAD TO HELP YOU OUT @9811782542 & 9911721597
Are you looking for benefits of tally over excel?    
Are you looking for what is excel tally?      
Are you looking for cash flow in tally erp 9?    
Are you looking for multi language in tally erp 9?    
Are you looking for tally bill of material questions?    
Are you looking for difference between tally and excel in hindi?
Are you looking for tally excel format?      
Are you looking for excel to tally import template download?  
Are you looking for payment voucher excel to tally?    
Are you looking for excel2tally free download?    
Are you looking for bank statement excel to tally software?  
Are you looking for various features of tally?    
Are you looking for uses of tally erp 9?      
Are you looking for how many contra entries can be done in tally?
 

 

Material hide
1. Excel to Tally import Ledger Masters with all this details using single template
1.1. GST details EXCEL TO TALLY DATA IMPORT AND FREE DEMO

Welcome to our website !

error: Content is protected !!