Excel-Tally is ultimate Software with ultimate features.

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

GST details

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

Personal Details

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

VAT ServiceTax details

You can import ledger master with VAT TIN number, Service Tax Number, Address with state city country 

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

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 imports Sale Vouchers
Excel to tally imports Purchase Vouchers
Excel to tally import Credit debit note
with following details

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 

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 

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+ 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

Excel to Tally import All Brand E commerce data

1 Import E Commerce MRT

2-Import E Commerce- data

3-E Commerce Commission

4-E Commerce Settlement

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 

Employee Master

Pay heads

Attendance Heads

Payroll and Attendance Vouchers