Excel to Tally Prime Import Ledger Master

Play Video

Get Free Demo

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

  1. We can Create Ledger In Tally 
  2. We can Alter Ledger in Tally 
  3. 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 

Excel to Tally Software is ultimate software with ultimate features