Excel to Tally

The great feature-rich Excel to tally programmed available; use it for free to save time and money.

GST details

You can import ledger master with GST number, Registration type, Name, Address with state city country Excel To Tally Addon

Personal Details

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

Balance Details

Your can import Debit Credit Opening Balance of Ledgers Also Credit period & Cost center details if neededExcel To Tally Addon

Tax Ledgers in details

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

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

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

Opening Quantity & Rate

Your can import import team master with Opening Quantity & Rate

GST rate details

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

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 Addon

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 Addon

Invoice details

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

Buyer Details

You can import data with Buyer Name, Address, state, City, Country & GSTN with place of supplyExcel To Tally Addon

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 Excel To Tally Addon

Order Details

You can import data with Order No, Order Due Date, Tracking No, Other Ref Number,Mode of Payment

Transporter Details

You can import data with Terms of Delivery, LR/RR No, LR/RR Date, Vehicle No Excel To Tally Addon

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

You can import data Party ledger link with Cost center & Cost Category, Also import Narrations in single or Multi invoice mode

Excel to Tally import Bank Statement with Auto reconciliation Excel To Tally Addon

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 Excel To Tally Addon

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

Excel To Tally Imports All Types Of Transaction Vouchers With Excel To Tally Addon

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 Excel To Tally Addon

Cost Center & Narration

Your can import data Party ledger link with Cost center & Cost Category, Also import Narrations in single or Multi invoice mode

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.

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.

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+ data2-Import Amazon MRT – data3-Amazon Commission data4-Amazon Settlement data

Excel to Tally import Flipkart E commerce data

1 Import Flipkart MRT+ data2-Import Flipkart MRT – data3-Flipkart Commission data4-Flipkart Settlement data

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

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