" No Monthly Cost Pay Once Use Lifetime 100% Accuracy and Guaranteed Support " Tally Connect Software imports various types of vouchers like Sales Vouchers, Purchases Vouchers, Bank statements, Receipt Vouchers, Payment Vouchers, Journal Vouchers, E-Commerce, and Payroll Vouchers, and masters like Ledgers, Items, and Stock Journal into Tally Prime or Tally ERP9. How to import data from Excel to Tally Software? 1- Prepare your data in a template by copying & pasting or by smart mapping 2-Validate Ledger, Items, Vouchers & Auto Create using TallyConnect software 3- Select template & start importing. After successful import, check data in Tally
Read More No Monthly Cost Pay Once Use Lifetime
100% Accuracy and Guaranteed Support
Tally Connect Software imports various types of vouchers like Sales Vouchers, Purchases Vouchers, Bank statements, Receipt Vouchers, Payment Vouchers, Journal Vouchers, E-Commerce, and Payroll Vouchers, and masters like Ledgers, Items, and Stock Journal into Tally Prime or Tally ERP9.
How to import data from Excel to Tally Software?
1- Prepare your data in a template by copying & pasting or by smart mapping
2-Validate Ledger, Items, Vouchers & Auto Create using TallyConnect software
3- Select template & start importing. After successful import, check data in Tally
Excel to Tally Import Ledger Master
Whats is Ledger Master
A ledger is the actual account head to identify your transactions and are used in all accounting vouchers. For example, purchase, payments, sales, receipts, and others accounts heads are ledger accounts. Without a ledger, you cannot record any transaction. (Ref: Tally Solutions)
Whats operation we do with Ledger masters
- We can Create Ledger In Tally
- We can Alter Ledger in Tally
- We can Delete Ledger in Tally
How to import ledger masters from Excel to tally software?
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- Now Select Ledger Master Template In Software & Click Import
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 LEDGER MASTER Button & Click on Import Button,
check the software dashboard it will show you Count of Ledgers Records created.
check in tally all your records are imported successfully
follow Same 2 step to Alter ledger master using Excel-Tally Software
You can Import ledger Master with Following details
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