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 master data using
Excel-Tally Software in just a click
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
You can import ledger master with GST number, Registration type, Name, Address with state city country
You can import Name Alias,detail address, Contact Person, PhoneNo, MobileNo, Email, Website & more
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