TALLY PRIME LEDGER SETUP FOR ALCOHOL / LIQUOR BUSINESS

🧾 TALLY PRIME LEDGER SETUP FOR ALCOHOL / LIQUOR BUSINESS

---

⚙️ Step 1: Basic Structure

In Tally Prime, every ledger belongs under a group.
The 4 main categories are:

• Assets
• Liabilities
• Income
• Expenses

---

🏦 1. Assets

Ledger Name	Under Group	Purpose / Notes
Cash	Cash-in-Hand	For all cash transactions
[Your Bank Name] (e.g. HDFC Bank)	Bank Accounts	Each bank separately
Stock-in-Hand (Alcohol Inventory)	Stock-in-Hand	To track alcohol stock
Furniture & Fixtures	Fixed Assets	Counters, racks, etc.
Computer & Printer	Fixed Assets	Billing equipment
License Deposit / Security Deposit	Loans & Advances (Asset)	Deposits to excise or suppliers
Advance to Supplier	Current Assets	Advance payments for stock
Accounts Receivable (Customer Name)	Sundry Debtors	If you sell on credit (rare in liquor retail)

---

⚖️ 2. Liabilities

Ledger Name	Under Group	Purpose / Notes
Capital Account (Owner’s Name)	Capital Account	Owner’s capital
Drawings Account	Capital Account	Personal withdrawals
Outstanding Expenses	Current Liabilities	Pending bills (rent, salaries, etc.)
Excise Duty Payable	Duties & Taxes	For state excise duty
VAT Payable / State Tax Payable	Duties & Taxes	Liquor is usually under VAT/excise, not GST
Loan from Bank / Person	Loans (Liability)	Any borrowed funds
Accounts Payable (Supplier)	Sundry Creditors	Vendors you buy stock from

---

💰 3. Income Ledgers (Sales)

Ledger Name	Under Group	Purpose / Notes
Sales – IMFL (Indian Made Foreign Liquor)	Sales Accounts	Retail sale of liquor
Sales – Beer / Wine	Sales Accounts	Separate sales ledgers for clarity
Sales Return	Sales Accounts	For returned items
Other Income	Indirect Income	Any miscellaneous income (e.g., scrap sale, etc.)

⚠️ Note:
Liquor is not covered under GST in India — it comes under State Excise Laws.
So, use Duties & Taxes → Excise Duty / VAT, not GST.

---

💸 4. Purchase Ledgers

Ledger Name	Under Group	Purpose / Notes
Purchase – IMFL	Purchase Accounts	Main purchase ledger for Indian Made Foreign Liquor
Purchase – Beer / Wine	Purchase Accounts	For different categories
Purchase Return	Purchase Accounts	Returned goods
Freight Inward / Transport Charges	Direct Expenses	For transport cost of stock

---

🏭 5. Direct Expenses (Related to Stock)

Ledger Name	Under Group	Purpose / Notes
Excise Duty / License Fee	Duties & Taxes	State liquor license or excise cost
Loading & Unloading Charges	Direct Expenses	Stock handling charges
Bottle Breakage / Wastage	Direct Expenses	For damaged stock
Warehouse Rent	Direct Expenses	Storage space rent

---

🧾 6. Indirect Expenses (Day-to-Day Running Costs)

Ledger Name	Under Group	Purpose / Notes
Shop Rent	Indirect Expenses	Shop rent
Electricity Charges	Indirect Expenses	Utilities
Salary / Wages	Indirect Expenses	Staff salaries
Security Charges	Indirect Expenses	Bouncer/security payments
Cleaning & Maintenance	Indirect Expenses	Shop maintenance
Stationery & Printing	Indirect Expenses	Billing paper, receipts, etc.
Advertisement & Promotion	Indirect Expenses	Local promotions (if allowed)
Bank Charges	Indirect Expenses	Bank fees
Telephone / Internet Expense	Indirect Expenses	Communication
Miscellaneous Expenses	Indirect Expenses	Small daily costs
Depreciation	Indirect Expenses	On fixed assets

---

📦 7. Inventory Items (Create in Tally)

Under Inventory Info → Stock Items → Create, set up items like:

• Whisky (Brand Name, Size e.g. 750ml)
• Beer (Brand Name, 650ml)
• Wine (Brand Name, 375ml)

Each should include:

• Unit of measure: Bottle, Case, etc.
• Rate: Cost and selling price
• Tax Type: Excise or VAT applicable

---

🧮 8. Duties & Taxes Setup

Since alcohol is not under GST, create duties as:

Ledger Name	Under Group	Type of Duty/Tax
State Excise Duty	Duties & Taxes	Excise
Additional Excise Duty	Duties & Taxes	Excise
VAT Payable / Input VAT	Duties & Taxes	VAT
Label Registration Fee	Duties & Taxes	Excise / License

---

🧩 9. Optional Custom Groups

You can create your own subgroups for clarity:

Group Name	Under Group	Use For
Shop Operating Expenses	Indirect Expenses	Rent, electricity, cleaning
Excise / License Charges	Direct Expenses	All excise-related costs
Employee Expenses	Indirect Expenses	Salary, uniforms, etc.

---

📊 10. Reports You’ll Get Automatically

Once these are set up, Tally will generate:

• Trading Account (Gross Profit on liquor sales)
• Profit & Loss Account
• Balance Sheet
• Stock Summary
• VAT/Excise Summary
• Outstanding Supplier Reports

---

✅ Setup Tips

• When creating ledgers:
• Set “Inventory Values Are Affected” = Yes for Purchases and Sales
• Set “Type of Duty/Tax” = Excise / VAT, not GST
• Use “Batch-wise” or “Lot-wise tracking” for liquor items (bottle numbers, brands, etc.)
• Enter opening stock carefully with quantity and value