Ledger Creation Using Multi-Create
Learn how to create multiple ledgers quickly and efficiently in Tally Prime.
1. Concept of Ledgers
A ledger is an account head under which transactions are recorded in accounting software. In Tally Prime, ledgers are essential because transactions such as sales, purchases, receipts, payments and expenses are recorded using appropriate ledger accounts.
Cash
Used to record cash receipts and cash payments.
Sales
Used to record income earned from selling goods or services.
Rent
Used to record rent paid or payable by the business.
2. Common Examples of Ledgers
| Ledger | Typical Group | Purpose |
|---|---|---|
| Cash | Cash-in-Hand | Records cash available with the business. |
| HDFC Bank | Bank Accounts | Records transactions through the bank account. |
| Sales | Sales Accounts | Records sales of goods or services. |
| Purchases | Purchase Accounts | Records purchases of goods or services. |
| Rent | Indirect Expenses | Records rent expense. |
| ABC Traders | Sundry Debtors | Records amounts receivable from a customer. |
| PQR Suppliers | Sundry Creditors | Records amounts payable to a supplier. |
3. What is Multi-Create?
Normally, a ledger can be created individually. However, when a business needs to create many ledgers, creating them one at a time can be time-consuming.
The Multi-Create facility allows multiple ledgers to be entered from a single screen, making bulk ledger creation faster and more convenient.
Instead of opening the ledger creation screen repeatedly, you can enter several ledger names and their basic details in one place.
Typical situations where Multi-Create is useful
- Setting up a new company.
- Creating many customers at once.
- Creating several suppliers.
- Creating multiple expense accounts.
- Creating ledgers during data migration.
- Setting up accounts at the beginning of a financial year.
4. Path to Multi-Create Ledgers
Use the following navigation path:
In shortcut/path form:
Gateway of Tally → Create → Multi-Create → Ledgers
5. Steps to Create Ledgers Using Multi-Create
- Go to Gateway of Tally → Create → Multi-Create → Ledgers .
- Select the appropriate Group. For example: Sundry Debtors, Sundry Creditors, Bank Accounts, Expenses, etc.
- Enter the Ledger Name. For example: ABC Traders, Rent, or HDFC Bank.
- Select or confirm the appropriate Under Group.
- Enter the Opening Balance, if the ledger has an existing balance.
- Enter applicable GST details, bank details, or other statutory information where the relevant screen/options require them.
- Continue entering the remaining ledgers on the same screen.
- Save/accept the multi-create screen using the appropriate accept/save command, such as Ctrl + A where applicable in your Tally Prime setup.
6. Practical Example
Suppose a newly created business needs the following ledgers:
| Ledger Name | Group | Opening Balance |
|---|---|---|
| Cash | Cash-in-Hand | ₹10,000 |
| Axis Bank | Bank Accounts | ₹50,000 |
| Sales | Sales Accounts | Nil |
| Purchases | Purchase Accounts | Nil |
| Wages | Direct Expenses | Nil |
| Rent | Indirect Expenses | Nil |
These ledgers can be entered together rather than repeatedly opening and saving individual ledger-creation screens.
7. Example: Creating Customers and Suppliers
Customers — Sundry Debtors
| Ledger | Group | Opening Balance |
|---|---|---|
| ABC Traders | Sundry Debtors | ₹25,000 Dr |
| XYZ Ltd. | Sundry Debtors | ₹15,000 Dr |
| LMN Enterprises | Sundry Debtors | ₹10,000 Dr |
A debtor generally represents an amount receivable from a customer.
Suppliers — Sundry Creditors
| Ledger | Group | Opening Balance |
|---|---|---|
| PQR Suppliers | Sundry Creditors | ₹20,000 Cr |
| RST Wholesalers | Sundry Creditors | ₹12,000 Cr |
A creditor generally represents an amount payable to a supplier.
8. Example: Expense Ledgers
Suppose a business wants to create three expense ledgers:
| Ledger | Suggested Group | Example Transaction |
|---|---|---|
| Rent | Indirect Expenses | Rent paid ₹20,000 |
| Telephone Charges | Indirect Expenses | Telephone bill ₹2,000 |
| Travel Expenses | Indirect Expenses | Travel expense ₹5,000 |
Rent A/c Dr. ₹20,000
To Cash/Bank A/c ₹20,000
This records payment of rent through the selected cash or bank account.
9. Example: GST Ledgers
GST-related ledgers may be created under the appropriate Duties & Taxes group with the relevant GST configuration.
| Ledger | Group | Rate | Purpose |
|---|---|---|---|
| CGST @ 9% | Duties & Taxes | 9% | Central GST component |
| SGST @ 9% | Duties & Taxes | 9% | State GST component |
| IGST @ 18% | Duties & Taxes | 18% | Integrated GST component |
10. Advantages of Multi-Create
⏱ Saves Time
Several ledgers can be entered without repeatedly opening separate creation screens.
📋 Bulk Creation
Useful when setting up customers, suppliers and expense accounts in large numbers.
🎯 Consistency
Makes it easier to apply the correct groups and basic account structure consistently.
- Quick creation of multiple ledgers.
- Useful during company setup.
- Useful when migrating accounting data.
- Reduces repetitive data entry.
- Helps organize accounts systematically.
11. Single Ledger vs. Multi-Create
| Feature | Single Ledger Creation | Multi-Ledger Creation |
|---|---|---|
| Purpose | Creates one ledger at a time with detailed configuration. | Creates multiple ledgers quickly from a single screen. |
| Path | Gateway of Tally → Create → Ledger | Gateway of Tally → Create → Multi-Create → Ledgers |
| Details | Suitable for detailed ledger configuration, including applicable statutory or banking information. | Primarily useful for entering multiple ledger records efficiently; additional configuration may need to be completed separately. |
| Flexibility | High — detailed setup can be performed for the individual ledger. | Faster for bulk creation, but some advanced details may need subsequent editing. |
| Best Use | Ledgers requiring detailed setup such as applicable GST, banking or other statutory information. | Creating many customers, suppliers, expenses or other ledgers at once. |
| Speed | Slower when creating many ledgers. | Faster for bulk creation. |
| Editing | Details can be configured while creating the ledger. | Advanced details may need to be edited later individually. |
Need one carefully configured ledger? → Use Single Ledger Creation.
Need to create many similar/basic ledgers quickly? → Use Multi-Create.
12. Common Mistakes to Avoid
- Wrong group: Placing a customer under Expenses instead of Sundry Debtors.
- Wrong opening balance: Entering a debtor’s balance as a creditor balance or vice versa.
- Incorrect GST configuration: Creating a GST ledger with the wrong tax type or rate.
- Duplicate ledgers: Creating multiple ledgers with nearly identical names when one existing ledger should have been used.
- Ignoring detailed configuration: Assuming Multi-Create automatically completes every advanced statutory or banking field.
13. Practice Questions
Question 1: Basic Ledger Creation
Using Multi-Create, create the following ledgers:
- Cash
- Axis Bank
- Sales
- Purchases
- Wages
Assign the correct groups. Enter an opening balance of ₹10,000 for Cash.
Show Suggested Answer
| Ledger | Group | Opening Balance |
|---|---|---|
| Cash | Cash-in-Hand | ₹10,000 |
| Axis Bank | Bank Accounts | As applicable |
| Sales | Sales Accounts | Nil |
| Purchases | Purchase Accounts | Nil |
| Wages | Direct Expenses | Nil |
Question 2: Debtors & Creditors
Create the following ledgers using Multi-Create:
Debtors:
- ABC Traders
- XYZ Ltd.
- LMN Enterprises
Creditors:
- PQR Suppliers
- RST Wholesalers
Assign them to the correct groups and enter suitable opening balances.
Show Suggested Answer
ABC Traders, XYZ Ltd. and LMN Enterprises → Sundry Debtors
PQR Suppliers and RST Wholesalers → Sundry Creditors
Customer opening balances are normally debit balances when the business is owed money, while supplier opening balances are normally credit balances when the business owes money.
Question 3: Expense Ledgers
Create these ledgers:
- Rent
- Telephone Charges
- Travel Expenses
Group them appropriately and record sample transactions using these ledgers.
Show Suggested Answer
A typical setup would place these under Indirect Expenses, depending on the nature of the business and accounting policy.
Example:
Question 4: GST Ledgers
Create:
- CGST @ 9%
- SGST @ 9%
- IGST @ 18%
Place them under the appropriate tax group, configure the applicable GST details, and record a sample GST sales transaction.
Show Suggested Answer
The relevant GST ledgers would generally be configured under Duties & Taxes with their applicable GST settings.
For an intra-state transaction at 18% GST:
For an inter-state transaction at 18%, IGST would generally be applicable, subject to the transaction’s GST treatment.
Question 5: Consolidated Exercise
Create all the following ledgers using Multi-Create:
- Cash
- HDFC Bank
- Sales
- Purchases
- Rent
- Salary
- ABC Traders
- XYZ Ltd.
- PQR Suppliers
- CGST @ 9%
Assign the correct groups and identify which ledgers require additional configuration.
Show Suggested Answer
| Ledger | Suggested Group |
|---|---|
| Cash | Cash-in-Hand |
| HDFC Bank | Bank Accounts |
| Sales | Sales Accounts |
| Purchases | Purchase Accounts |
| Rent | Indirect Expenses |
| Salary | Indirect Expenses* |
| ABC Traders | Sundry Debtors |
| XYZ Ltd. | Sundry Debtors |
| PQR Suppliers | Sundry Creditors |
| CGST @ 9% | Duties & Taxes |
*The classification of salary can depend on the nature of the employee cost and the business’s accounting structure. For example, wages directly attributable to production may be classified differently.
14. Challenge Exercise
Build a Complete Small Business Ledger Structure
Imagine that you are setting up the accounts of a retail business. Create at least 15 ledgers using Multi-Create.
Your ledger list should contain:
- 2 Cash/Bank accounts
- 2 Customers
- 2 Suppliers
- 2 Sales/Purchase ledgers
- 4 Expense ledgers
- 3 GST/tax-related ledgers
For every ledger, identify:
- Ledger name
- Correct group
- Opening balance, if applicable
- Whether additional configuration is required
Self-check
Before accepting the screen, verify:
- Every ledger has the correct group.
- Customer ledgers are classified correctly.
- Supplier ledgers are classified correctly.
- Expense ledgers are grouped appropriately.
- Opening balances are entered correctly.
- GST ledgers have the appropriate GST configuration.
- Bank ledgers have required bank information configured.
15. Quick Revision
| Topic | Remember |
|---|---|
| Ledger | An account head used to record transactions. |
| Multi-Create | Used to create multiple ledgers efficiently. |
| Path | Gateway of Tally → Create → Multi-Create → Ledgers |
| Customer | Generally classified under Sundry Debtors. |
| Supplier | Generally classified under Sundry Creditors. |
| Cash | Cash-in-Hand. |
| Bank | Bank Accounts. |
| GST Ledger | Generally configured under Duties & Taxes with appropriate GST settings. |
| Best advantage | Faster bulk ledger creation. |
One ledger + detailed setup → Single Create
Many ledgers + quick setup → Multi-Create