E-Commerce & Digital Marketing Notes
COM6EJ308 - E-Commerce & Digital Marketing study notes and resources.
Chapter-Wise Module Notes & PDF Downloads
Short Notes
All Modules IncludedComplete syllabus revision notes covering all modules in one single PDF
Module 1
Theoretical Foundations & Principles
Module 2
Operational Frameworks & Methodologies
Module 3
Regulatory Compliance & Quantitative Analysis
Module 4
Strategic Applications & Contemporary Trends
Read Module Notes Online
Course Code: COM6EJ308(4) • Course Title: Computerized Accounting with Tally • Semester: VI • Credits: 4 • Contact Hours: 60
Module I Title: COMPUTERIZED ACCOUNTING FUNDAMENTALS & MASTER SETUP (15 Contact Hours)
Syllabus Units Covered: Unit 1: Introduction to Tally — Architecture, Interface (Gateway of Tally, Button Bar, Go To feature), Company Creation & Alteration, Security Controls • F11 Company Features (Accounting, Inventory, Statutory/Taxation) & F12 Configurations • Chart of Accounts & Accounting Groups — The 28 Predefined Groups (15 Primary & 13 Secondary Groups), Creating Custom Groups • Accounting Ledgers — Ledger Creation, Group Allocation, Opening Balances • Accounting Vouchers — Voucher Types (Contra F4, Payment F5, Receipt F6, Journal F7, Sales F8, Purchase F9, Debit Note Alt+F5, Credit Note Alt+F6) & Voucher Entry Mechanics • Inventory Management — Stock Groups, Stock Categories, Stock Items, Units of Measure (Simple & Compound), Multi-Godowns/Locations & Inventory Vouchers • Calicut University Academic Examination Bank (Part A: 2 Marks, Part B: 5 Marks, Part C: 10/15 Marks).
1. Overview: The Digital Transformation of Financial Accounting
Manual bookkeeping systems, with their separate paper journals, sub-ledgers, cash books, and trial balances, are structurally incapable of meeting the speed, volume, and statutory compliance demands of modern corporate commerce. Computerized Accounting automates the entire accounting cycle: when a primary transaction voucher is recorded, the software instantaneously updates the general ledger, recalculates inventory balances, adjusts trial balance columns, and generates real-time financial statements (Profit & Loss Account and Balance Sheet).
Tally Prime (and Tally.ERP 9) represents the gold standard enterprise resource planning (ERP) platform for small and medium enterprises (SMEs) across India and the Global South. Designed around a "no-code, concurrent multi-lingual" architecture, Tally operates on a real-time relational data engine that requires no explicit posting routines or period-closing batches. Module I establishes the operational foundations: navigating the Gateway of Tally, configuring company masters, mastering the 28 predefined accounting groups, processing multi-class vouchers, and setting up multi-location inventory hierarchies.
1. INTERFACE & COMPANY SETUP
• Company Creation: Financial year beginning, books beginning, and base currency.
• F11 & F12 Controls: Enabling multi-currency, cost centres, and voucher behavior.
2. CHART OF ACCOUNTS & GROUPS
• Balance Sheet vs. P&L Groups: Strict mathematical classification hierarchy.
• Custom Sub-Groups: Tailoring chart of accounts to specific industry niches.
3. LEDGER MASTERS & VOUCHERS
• Accounting Vouchers: F4 (Contra), F5 (Payment), F6 (Receipt), F7 (Journal).
• Invoicing Vouchers: F8 (Sales), F9 (Purchase), and Debit/Credit Notes.
4. INVENTORY MANAGEMENT MASTERS
• Units of Measure (UOM): Simple (Nos, Kgs) and compound units (Box of 12).
• Multi-Godowns & Stock Journal: Inter-warehouse transfers and physical stock taking.
2. Workspace Navigation, Company Creation & Configuration Controls
A. Anatomic Architecture of the Tally Interface
The Tally interface is engineered for rapid keyboard-driven transaction entry:
- Gateway of Tally (GOT): The central command dashboard divided into functional sections: Masters (Create, Alter, Chart of Accounts), Transactions (Vouchers, Day Book), Utilities (Banking), and Reports (Balance Sheet, Profit & Loss A/c, Stock Summary, Ratio Analysis).
- Top Menu Bar: Houses global administrative options: Company (Alt+K) for company selection and security, Data (Alt+Y) for backup and restore, Exchange (Alt+Z) for data synchronization, Import/Export (Alt+O / Alt+E), and Print (Alt+P).
- 'Go To' Search Engine (Alt+G): A powerful navigational breakthrough in Tally Prime allowing users to search any report, master, or voucher entry from anywhere in the software without exiting the current transaction screen.
- Side Button Bar: Displays contextual function keys (F2 Date, F3 Company, F4 Contra, F5 Payment, F6 Receipt, F7 Journal, F8 Sales, F9 Purchase).
- Calculator & Secondary Action Bar (Ctrl+N): An on-screen computational scratchpad that executes arithmetic calculations and transfers results directly into active voucher quantity and rate fields.
B. Company Creation and Initialization Parameters
When initializing a new enterprise accounting profile in Tally, the accountant configures foundational parameters:
| Configuration Parameter | Data Input Field | Statutory & Accounting Function |
|---|---|---|
| Company Name & Mailing Name | Legal Registered Corporate Entity Name | Appears as header on all printed invoices, GST returns, and official balance sheets. |
| Financial Year Beginning From | 01-04-2024 (1st April of current year) |
Defines the statutory 12-month financial reporting cycle in accordance with the Income Tax Act. |
| Books Beginning From | 01-04-2024 or date of business inception |
The exact calendar date from which opening balances and transaction entries commence. |
| Base Currency Information | Symbol: ₹ • Formal Name: INR • Decimals: 2 |
Governs currency formatting, paisa sub-units, and decimal rounding in all general ledgers. |
| Security & TallyVault | User Access Password / TallyVault Key | Encrypts database files on disk and restricts user access based on role permissions. |
C. F11 Features vs. F12 Configuration
A crucial conceptual distinction exists between F11 and F12 controls:
F11: COMPANY FEATURES (GLOBAL SCOPE)
• Accounting: Enable multi-currency, bill-wise accounting, cost centres, budgets.
• Inventory: Enable multiple godowns, batch-wise details, order processing.
• Statutory: Enable Goods and Services Tax (GST), TDS, and TCS compliance.
F12: CONFIGURATION (LOCAL / VIEW SCOPE)
• Master Entry: Provide aliases, provide descriptions, allow multi-language names.
• Voucher Entry: Use Cr/Dr instead of To/By, warn on negative cash balance, show inventory details.
• Printing: Print bank details on invoice, show company seal, print terms of payment.
3. The Chart of Accounts: Mastering the 28 Predefined Groups
A. Theoretical Architecture of Tally Groups
In Tally, every ledger account must belong to a Group. Groups determine whether an account appears on the Balance Sheet or the Profit & Loss Account, and establish the mathematical behavior of financial statements.
Tally comes pre-loaded with exactly 28 Predefined Groups, organized hierarchically into 15 Primary Groups and 13 Secondary / Sub-Groups:
B. The 15 Primary Groups
| Primary Group Name | Statement Placement | Accounting Characteristics & Standard Ledgers |
|---|---|---|
| Capital Account | Balance Sheet (Liabilities) | Owner equity capital, partner capital accounts, drawings, share capital. |
| Loans (Liability) | Balance Sheet (Liabilities) | Long-term and short-term debt borrowings from banks and financial institutions. |
| Current Liabilities | Balance Sheet (Liabilities) | Short-term operational obligations payable within 12 months. |
| Fixed Assets | Balance Sheet (Assets) | Long-term capital assets: Land, Buildings, Plant & Machinery, Computer Hardware. |
| Current Assets | Balance Sheet (Assets) | Liquid assets convertible into cash within one year: debtors, stock, bank balances. |
| Investments | Balance Sheet (Assets) | Capital invested outside business: Government bonds, shares, fixed deposits > 1 yr. |
| Suspense Account | Balance Sheet (Liabilities/Assets) | Temporary holding group for unexplained cash differences or un-reconciled receipts. |
| Branch / Divisions | Balance Sheet (Liabilities/Assets) | Inter-branch transfer accounts, head office control accounts. |
| Misc. Expenses (ASSET) | Balance Sheet (Assets) | Preliminary expenses, share issue expenses awaiting amortization. |
| Sales Accounts | Profit & Loss (Trading Credit) | Domestic sales, export sales, sales of scrap. |
| Purchase Accounts | Profit & Loss (Trading Debit) | Raw material purchases, goods purchased for resale, import purchases. |
| Direct Expenses | Profit & Loss (Trading Debit) | Manufacturing expenses: Factory wages, freight inward, carriage inward, power & fuel. |
| Direct Incomes | Profit & Loss (Trading Credit) | Operating revenues tied directly to production: job-work charges received. |
| Indirect Expenses | Profit & Loss (P&L Debit) | Administrative, selling, and financial overheads: salaries, rent, audit fees, advertising. |
| Indirect Incomes | Profit & Loss (P&L Credit) | Non-operating revenues: Bank interest earned, dividend income, rent received. |
C. The 13 Secondary / Sub-Groups
The 13 sub-groups inherit characteristics from their parent primary groups:
- Under Capital Account: Reserves & Surplus (General reserve, statutory reserve fund).
- Under Loans (Liability): Secured Loans (Mortgage loans, vehicle loans), Unsecured Loans (Loans from directors/friends), Bank OD Accounts (Overdraft and cash credit limits).
- Under Current Liabilities: Sundry Creditors (Trade suppliers), Duties & Taxes (GST, TDS, TCS, cess ledgers), Provisions (Provision for taxation, provision for bad debts).
- Under Current Assets: Sundry Debtors (Trade customers), Bank Accounts (Current & savings accounts), Cash-in-hand (Petty cash, main cash ledger), Stock-in-hand (Closing inventory), Deposits (Asset) (Rent deposits, electricity security deposits), Loans & Advances (Asset) (Staff advances, short-term vendor advances).
4. Accounting Vouchers: Typology & Transaction Mechanics
A. Standard Accounting Vouchers in Tally
A voucher is the primary electronic document recording a financial transaction:
| Shortcut | Voucher Type | Operational Rules & Real-World Transaction Examples |
|---|---|---|
| F4 | Contra Voucher | Restricted strictly to internal transfers between Cash and Bank accounts. Examples: Depositing ₹25,000 cash into SBI current account; Withdrawing ₹10,000 from Federal Bank for office petty cash. |
| F5 | Payment Voucher | Used for all outflows of funds via cash, bank transfer, or cheque. Examples: Paying office rent ₹18,000 by cheque; Paying staff salaries ₹85,000 via NEFT; Settling vendor dues. |
| F6 | Receipt Voucher | Used for all inflows of money received into cash or bank accounts. Examples: Receiving ₹50,000 from debtor via UPI; Receiving interest of ₹4,200 credited by bank. |
| F7 | Journal Voucher | Non-cash adjustment, transfer, and accrual transactions. Examples: Charging depreciation on machinery (Depreciation A/c Dr. To Machinery A/c); Writing off bad debts; Year-end accrued interest entries. |
| F8 | Sales Voucher | Records cash and credit sales of goods/services to customers. Can be operated in Item Invoice mode (for inventory) or Accounting Invoice mode (for service billing). |
| F9 | Purchase Voucher | Records cash and credit procurement of raw materials and trading merchandise from suppliers. |
| Alt+F5 | Debit Note | Issued to a supplier when returning damaged goods (purchase return) or debiting them for price overcharges. |
| Alt+F6 | Credit Note | Issued to a customer accepting returned goods (sales return) or granting special volume discounts. |
5. Inventory Management Architecture in Tally
A. The Hierarchical Inventory Masters
Tally seamlessly integrates financial ledgers with physical stock tracking through a five-tier inventory master hierarchy:
1. STOCK GROUPS
• Sub-Grouping: Electronics → Computers → Laptops.
• Tax Setting: GST rates and HSN codes can be assigned at the Stock Group level to inherit down to all items.
2. STOCK ITEMS
• Item Definition: Dell Inspiron 15, HP LaserJet Toner 12A.
• Parameters: Assigned parent Stock Group, Unit of Measure, opening stock quantity, and valuation rate.
3. UNITS OF MEASURE (UOM)
• Compound Units: Defined conversion relationships: 1 Box = 12 Nos, or 1 Dozen = 12 Pcs.
• Precision Decimals: Specifying decimal places (e.g., 3 decimals for Kilograms to track grams).
4. MULTI-GODOWNS / LOCATIONS
• Stock Journal (Alt+F7): Inter-godown transfers (Source → Destination) and manufacturing assembly.
• Physical Stock (Ctrl+F7): Recording periodic audit counts to adjust inventory shrinkage.
6. Practical Empirical Case Studies
Enterprise Context: Malabar Super Foods Ltd, a regional FMCG distributor in Kozhikode handling packaged foods, beverages, and toiletries, migrated from manual ledgers to Tally Prime.
Master Implementation Workflow:
- F11 Features: Activated Maintain Inventory, Enable Multi-Godowns, and Enable GST with Kerala GSTIN
32AAACM1234F1Z5. - Inventory Structure: Created Stock Group "Dairy Products" (HSN 0401, GST 5%). Created Compound Unit
1 Crtn = 24 Pkts. Created Stock Item "Milma Toned Milk 500ml" linked to Godown "Cold Storage Bay A". - Transaction Execution: Passed an F9 Purchase voucher for 50 Cartons from supplier. Tally automatically updated the Accounts Payable ledger under Sundry Creditors while simultaneously increasing stock balance by 1,200 packets in the Stock Summary report.
Enterprise Context: During a financial audit of a manufacturing firm, an internal auditor discovered that an inexperienced clerk had used F7 Journal vouchers to record cash sales and cash expenses.
Remedial Audit Action: Tally's fundamental rule states that F7 Journal vouchers must never involve Cash or Bank accounts. The auditor cancelled the irregular journal entries, retrained staff to route cash sales through F8 Sales (or F6 Receipt) and cash expenses through F5 Payment, thereby restoring the mathematical integrity of the automated Cash Flow Statement.
7. Calicut University Academic Examination Bank
Exhaustively curated for Calicut University B.Com Semester VI Elective: Computer Applications — COM6EJ308(4): Computerized Accounting with Tally (CUFYUGP 2024 Regulations). Specially formatted for superior academic performance.
The 'Go To' feature (keyboard shortcut Alt+G) is a universal search and navigation tool in Tally Prime that allows users to instantly discover and open any financial report, master, or voucher screen from anywhere in the software without leaving the current transaction.
F11 Features controls global functionality for the entire company profile across all users (e.g., enabling GST or multi-godowns). F12 Configuration controls local user display preferences and entry behavior for the active screen or workstation (e.g., toggling Cr/Dr vs To/By).
There are exactly 28 Predefined Groups in Tally, categorized into 15 Primary Groups (9 Balance Sheet groups + 6 Profit & Loss groups) and 13 Secondary / Sub-Groups.
A Contra Voucher records internal funds transfers exclusively between Cash and Bank accounts within the enterprise.
Eligible transactions: (1) Depositing physical cash into a bank current account; (2) Withdrawing cash from bank for office petty cash.
A Compound Unit of Measure defines a fixed mathematical conversion relationship between two simple units of measure. Example:
1 Box = 24 Nos, or 1 Carton = 12 Packets.
A Debit Note is issued to a supplier to record purchase returns or price reductions. A Credit Note is issued to a customer to record sales returns or price allowances granted.
The Stock Journal Voucher (keyboard shortcut Alt+F7) is utilized for inter-godown transfers (transferring items from Source Godown to Destination Godown) and manufacturing assemblies.
Architecture of Chart of Accounts:
The Chart of Accounts in Tally is organized hierarchically around 28 predefined groups. Every ledger must be parented by a group, which dictates its financial statement destination.
The 9 Balance Sheet Primary Groups:
1. Capital Account: Proprietor/partner equity and reserves.
2. Loans (Liability): External borrowings and term loans.
3. Current Liabilities: Short-term operational obligations payable within 12 months.
4. Fixed Assets: Long-term capital property, plant, and equipment.
5. Current Assets: Liquid operating assets (debtors, cash, bank).
6. Investments: External financial assets held outside business.
7. Suspense Account: Temporary unclassified debit or credit balances.
8. Branch / Divisions: Inter-unit control accounts.
9. Misc. Expenses (ASSET): Unamortized fictitious assets (preliminary expenses).
The 6 Profit & Loss Primary Groups:
1. Sales Accounts: Trading credit revenues from sales of goods.
2. Purchase Accounts: Trading debit costs from merchandise purchases.
3. Direct Expenses: Trading debit manufacturing costs (wages, freight inward).
4. Direct Incomes: Trading credit operational service revenues.
5. Indirect Expenses: P&L debit administrative and selling overheads (rent, salaries).
6. Indirect Incomes: P&L credit non-operating receipts (interest, dividends).
1. Contra Voucher (F4):
• Purpose: Records internal cash-to-bank or bank-to-bank funds movements.
• Accounting Rule: Both Debit and Credit legs must involve only Cash or Bank ledgers. Never used for payments to third parties.
2. Payment Voucher (F5):
• Purpose: Records all financial disbursements via cash, cheque, or electronic transfer.
• Accounting Rule: Expense / Creditor A/c is debited; Cash / Bank A/c is credited.
3. Receipt Voucher (F6):
• Purpose: Records all monetary inflows received by the business.
• Accounting Rule: Cash / Bank A/c is debited; Customer / Revenue / Capital A/c is credited.
4. Journal Voucher (F7):
• Purpose: Non-cash adjusting, closing, and rectification entries.
• Accounting Rule: Neither Cash nor Bank ledgers can be selected. Used exclusively for depreciation, bad debt write-offs, and inter-ledger transfers.
Procedure and Architecture of Inventory Masters:
Navigate to
Gateway of Tally → Create (under Masters) → Inventory Masters:1. Units of Measure (UOM): Created first because items require measurement units. Define simple units (
Nos, Kgs, Box) or compound conversion units (1 Box = 10 Nos).2. Stock Groups: Establishes product classification (e.g., Group = "Beverages"). Assign common GST rates (e.g., 12%) and HSN codes to streamline tax compliance.
3. Godowns / Locations: Defines physical warehouse sites (e.g., "Main Warehouse", "Showroom Bay") to enable multi-location tracking and inter-warehouse stock journals.
4. Stock Items: The core SKU master (e.g., "Red Label Tea 500g"). Linked to parent Stock Group, assigned the UOM, and populated with opening balance quantity, rate, and godown location.
Commercial Significance: Real-time automated stock valuation (FIFO, Weighted Average), immediate stock shortage alerts, and automatic cost of goods sold (COGS) computation in trading statements.
1. Introduction & The Paradigm Shift:
Computerized accounting with Tally represents a revolutionary leap from sequential manual record-keeping to unified relational financial intelligence. In manual systems, recording a transaction required separate entries in day books, posting to multiple ledger accounts, extraction of trial balance totals, and laborious final account compilation.
2. Core Technological Advantages of Tally:
• Single-Entry Posting Automation: Recording a single voucher automatically updates all subsidiary ledgers, trial balance, and balance sheet simultaneously.
• Real-Time Financial Reporting: Executive balance sheets and profit & loss statements are generated instantaneously at any point in the financial year.
• Mathematical Precision: Eliminates human arithmetic errors, casting mistakes, and ledger posting omissions.
3. The Structural Discipline of the 28 Predefined Groups:
• Groups impose strict architectural rigor: segregating capital assets from operating expenditures, ensuring trial balances always balance.
• Standardizes corporate chart of accounts across parent entities and regional branch subsidiaries.
4. Regulatory Compliance & Audit Trail:
• Seamless compliance with GST, TDS, and Companies Act mandates via F11 Statutory features.
• Built-in validation warnings (negative cash warnings, duplicate voucher alerts) enforce internal control discipline.
5. Conclusion:
Tally Prime transforms accounting departments from historical bookkeeping clerks into strategic financial analysts capable of delivering real-time commercial insights.
(b) State the exact Voucher Type (Contra F4, Payment F5, Receipt F6, Journal F7, Sales F8, Purchase F9, Debit Note Alt+F5, Credit Note Alt+F6) and draft the Debit/Credit journal entry for each of the following business transactions:
1. Withdrew ₹15,000 cash from SBI for office use.
2. Purchased goods worth ₹80,000 from Apex Suppliers on credit.
3. Sold goods worth ₹1,20,000 to M/s Royal Enterprises on credit.
4. Paid office rent ₹20,000 by SBI cheque.
5. Returned damaged goods worth ₹8,000 to Apex Suppliers.
6. Charged ₹12,000 annual depreciation on Factory Machinery.
Part (a): Master Setup & Group Allocation:
• Sequence:
Gateway of Tally → Create → Ledger.1. SBI Current Account: Under Bank Accounts (Sub-group of Current Assets).
2. Output CGST: Under Duties & Taxes (Sub-group of Current Liabilities).
3. Factory Machinery: Under Fixed Assets (Primary Group).
4. Carriage Inward: Under Direct Expenses (Primary Group - Trading Debit).
5. Office Electricity Expenses: Under Indirect Expenses (Primary Group - P&L Debit).
6. M/s Royal Enterprises: Under Sundry Debtors (Sub-group of Current Assets).
7. Bank Overdraft Account: Under Bank OD A/c (Sub-group of Loans Liability).
8. General Reserve: Under Reserves & Surplus (Sub-group of Capital Account).
Part (b): Voucher Classification & Accounting Entries:
1. Cash Withdrawal for Office Use (₹15,000):
• Voucher Type: F4 (Contra Voucher).
• Entry:
Cash A/c Dr. ₹15,000 • To SBI Current A/c Cr. ₹15,000.2. Credit Purchase of Goods from Apex Suppliers (₹80,000):
• Voucher Type: F9 (Purchase Voucher).
• Entry:
Purchase A/c Dr. ₹80,000 • To Apex Suppliers A/c Cr. ₹80,000.3. Credit Sales to M/s Royal Enterprises (₹1,20,000):
• Voucher Type: F8 (Sales Voucher).
• Entry:
M/s Royal Enterprises A/c Dr. ₹1,20,000 • To Sales A/c Cr. ₹1,20,000.4. Paid Office Rent by Cheque (₹20,000):
• Voucher Type: F5 (Payment Voucher).
• Entry:
Rent Expense A/c Dr. ₹20,000 • To SBI Current A/c Cr. ₹20,000.5. Returned Damaged Goods to Apex Suppliers (₹8,000):
• Voucher Type: Alt+F5 (Debit Note Voucher).
• Entry:
Apex Suppliers A/c Dr. ₹8,000 • To Purchase Returns A/c Cr. ₹8,000.6. Depreciation Charged on Machinery (₹12,000):
• Voucher Type: F7 (Journal Voucher).
• Entry:
Depreciation A/c Dr. ₹12,000 • To Factory Machinery A/c Cr. ₹12,000.
Course Code: COM6EJ308(4) • Course Title: Computerized Accounting with Tally • Semester: VI • Credits: 4 • Contact Hours: 60
Module II Title: INTEGRATION OF ACCOUNTING WITH INVENTORY & FINANCIAL REPORTING (15 Contact Hours)
Syllabus Units Covered: Unit 2: Bill-wise Details — New Ref, Agst Ref, Advance, On Account, Accounts Receivable & Payable Management • Invoicing Modes — Item Invoice, Accounting Invoice, Voucher Mode • Cost Centres & Cost Categories — Multi-Dimensional Expense Allocation • Budgetary Controls — Setting Budgets, Variance Analysis Reports • Bank Reconciliation — Auto Bank Reconciliation & Manual Clearing Dates • Interest Calculation — Simple & Compound Interest on Overdue Debts • Order Processing — Purchase & Sales Order Cycles • Bill of Materials (BOM) — Manufacturing Journal & Production Costing • Accounting & Inventory Reports — Balance Sheet, Profit & Loss A/c, Ledgers, Stock Summary, Godown Reports • Managerial Decision Tools — Ratio Analysis, Cash Flow Statement (AS-3), Funds Flow Statement • Calicut University Academic Examination Bank (Part A: 2 Marks, Part B: 5 Marks, Part C: 10/15 Marks).
1. Overview: The Symbiosis of General Ledgers and Material Inventory
In simple service firms, accounting operates strictly in monetary terms. However, in trading, retail, and manufacturing enterprises, financial health is intimately bound to the physical movement of inventory. Integrating accounting with inventory ensures that every material movement—from receiving raw materials at a warehouse loading bay to dispatching finished goods—is dynamically mirrored in the financial ledgers.
When an item invoice is passed in Tally, the software simultaneously executes dual updates: it debits or credits trade party ledgers, recognizes revenue or expenditure, adjusts GST tax accounts, and recalibrates inventory quantities, godown stock balances, and Cost of Goods Sold (COGS) using automated valuation methods (FIFO, Weighted Average, Standard Cost). Module II explores the advanced managerial and analytical modules of Tally: Bill-wise debt tracking, Cost Centres, Budgets, Bank Reconciliation, Manufacturing BOMs, and dynamic Ratio Analysis.
1. BILL-WISE & INVOICING CONTROLS
• Credit Monitoring: Credit days limits, interest on overdues, and aging schedules.
• Invoicing Modes: Item Invoice (goods) vs. Accounting Invoice (services).
2. COST & BUDGETARY ALLOCATION
• Budgeting & Controls: Setting corporate budgets and tracking variances.
• Bank Reconciliation (BRS): Matching electronic bank statements with cash books.
3. ORDER CYCLES & BILL OF MATERIALS
• Bill of Materials (BOM): Formulating standard raw material consumption recipes.
• Manufacturing Journal: Converting raw components into finished stock assemblies.
4. EXECUTIVE REPORTING & RATIOS
• Inventory Analytics: Stock Summary, Godown Registers, and Movement Analysis.
• Decision Support: Real-time Ratio Analysis, Cash Flow (AS-3), and Funds Flow.
2. Bill-Wise Accounting and Invoicing Mechanics
A. The Four Bill Reference Methods in Tally
When 'Maintain Bill-wise Details' is enabled for Sundry Debtors and Sundry Creditors, every credit transaction prompts the accountant to assign one of four reference types:
| Reference Type | Operational Trigger | Commercial Accounting Function & Behavior |
|---|---|---|
| New Ref (New Reference) | Passed during new credit sales (F8) or credit purchases (F9). | Creates a fresh, unique invoice tracking ID (e.g., INV/2024/042) with associated credit period (e.g., 30 days) and due date. |
| Agst Ref (Against Reference) | Passed during payment receipt (F6) or supplier payment (F5), and Debit/Credit notes. | Presents an interactive pop-up window of pending unpaid bills. Linking the payment to a specific invoice settles that liability in the aging ledger. |
| Advance | Passed when receiving or paying money upfront prior to invoice generation. | Records an unadjusted advance payment. When the final invoice is billed later, it is adjusted against this advance via Agst Ref. |
| On Account | Passed when an interim payment cannot be tied to a specific invoice number. | Reduces the overall party balance without clearing individual invoice line items in the outstanding debt aging schedule. |
B. Invoicing Modes in Tally (Ctrl+H Toggle)
Tally provides three distinct operational modes for entering sales and purchase vouchers:
- Item Invoice Mode: Standard mode for trading enterprises. Contains tabular columns for Name of Item, Godown, Quantity, Rate, Unit, and Amount, alongside automated tax ledgers (CGST, SGST, IGST).
- Accounting Invoice Mode: Tailored for service providers (consultants, advertising agencies, legal firms). Omits inventory columns and presents Particulars (service ledgers) and Amount.
- As Voucher Mode: The traditional double-entry journal format presenting classic Dr (Debit) and Cr (Credit) rows without automated invoice formatting.
3. Cost Centres, Budgets, Bank Reconciliation & Interest Calculations
A. Cost Categories and Cost Centres
In corporate management, executives must analyze expenses and revenues by department, branch, or project without cluttering the general ledger with hundreds of separate accounts:
1. COST CATEGORY (PRIMARY CLASSIFICATION)
• Examples: "Departments", "Regional Branches", "Client Projects".
• Parallel Tracking: A single salary payment can be simultaneously allocated 100% to a Department and 100% to a Branch.
2. COST CENTRE (SPECIFIC ALLOCATION UNIT)
• Examples: Under Departments: Marketing, Accounts, Production; Under Branches: Kochi, Calicut, Trivandrum.
• Execution: During voucher entry, Tally prompts the user to distribute the voucher amount across cost centres.
B. Budgetary Controls and Variance Analysis
Tally enables management to formulate corporate budgets for specified timeframes (monthly, quarterly, annual):
- Ledger Budgets: Imposing spending ceilings on specific indirect expense ledgers (e.g., capping Traveling Expenses at ₹2,50,000 for Q1).
- Cost Centre Budgets: Allocating total operational expenditure budgets to specific branch cost centres.
- Budget Variance Report: Compares Budgeted Expenditure against Actual Expenditure, calculating positive and negative variances (over-budget variances flagged for administrative action).
C. Bank Reconciliation Statements (BRS) in Tally
Automated & Manual BRS Workflow in Tally Prime
1. Navigation: Gateway of Tally → Banking → Bank Reconciliation → Select Bank Ledger (e.g., SBI Current A/c).
3. Auto Bank Reconciliation: Users import electronic bank statement files (.xlsx, .csv, .mt940). Tally automatically executes algorithmic matching of cheque numbers, dates, and amounts, instantly reconciling identical entries and highlighting unexplained variances.
D. Automated Interest Calculation
Tally automates the computation of interest on outstanding customer balances:
- Simple & Compound Interest: Configured in ledger masters under F11 features. Users specify the interest rate (e.g., 18% p.a.), calendar year basis (365 days or 360 days), and grace period.
- Debit Note Generation: Overdue interest reports calculate exact accrued interest up to any date, allowing the accountant to generate automated interest Debit Notes to bill defaulting debtors.
4. Order Processing Cycles & Bill of Materials (BOM)
A. The Integrated Order Processing Cycles
In advanced trade environments, financial vouchers are preceded by formal commercial order tracking:
| Stage | The Procurement (Purchase) Cycle | The Fulfillment (Sales) Cycle |
|---|---|---|
| 1. Order Placement | Purchase Order (Ctrl+F9): Issues formal order to vendor specifying agreed quantities, rates, and delivery dates. | Sales Order (Ctrl+F8): Receives order from customer agreeing to supply specified goods. |
| 2. Physical Movement | Receipt Note (Alt+F9): Warehouse storekeeper certifies physical arrival of goods; inventory increases without affecting financials. | Delivery Note (Alt+F8): Goods dispatched from warehouse accompanied by delivery challan; inventory decreases. |
| 3. Rejection / Return | Rejections Out: Returning damaged units before invoice billing. | Rejections In: Customer returns rejected goods before billing. |
| 4. Financial Invoicing | Purchase Invoice (F9): Links to Receipt Note number; automatically populates items and updates vendor liability. | Sales Invoice (F8): Links to Delivery Note number; bills customer and recognizes sales revenue. |
| 5. Settlement | Payment Voucher (F5): Settles invoice balance via Agst Ref. |
Receipt Voucher (F6): Collects payment from customer via Agst Ref. |
B. Bill of Materials (BOM) and Manufacturing Costing
A Bill of Materials (BOM) defines the exact standard technical recipe of raw materials, packaging components, and sub-assemblies required to manufacture one unit of a finished product:
1. BOM DEFINITION IN ITEM MASTER
• Raw Material Recipe: Engineered Wood: 2.5 Sq.Mtrs; Steel Screws: 40 Nos; Industrial Adhesive: 0.5 Kg; Edge Banding: 8 Mtrs.
2. MANUFACTURING JOURNAL (ALT+F7)
• Destination (Production): Adds 50 finished desks to the showroom godown, automatically absorbing direct labor and power overheads into the finished unit cost.
5. Financial, Inventory & Managerial Decision Reports
A. Core Accounting and Financial Reports
Tally generates standard financial statements dynamically from the relational ledger database:
- Balance Sheet (F10 / GOT → Balance Sheet): Displays capital liabilities on the left and assets on the right (or vertical format). Pressing
Alt+F1expands all primary groups into detailed sub-groups down to individual ledger balances. - Profit & Loss Account: Structured into upper Trading Account (Gross Profit derived from Sales, Purchases, Opening/Closing Stock, and Direct Expenses) and lower P&L Statement (Operating Net Profit after deducting indirect overheads).
- Trial Balance: Displays closing debit and credit balances of all 28 groups. Pressing
F12configures opening balances, periodic transactions, and closing balances simultaneously.
B. Managerial Decision Tools (Ratio Analysis, Cash Flow, Funds Flow)
| Analytical Tool | Key Metric Calculated in Tally | Executive Decision Significance |
|---|---|---|
| Ratio Analysis (GOT → Ratio Analysis) | Current Ratio, Quick Ratio, Debt-Equity Ratio, Inventory Turnover, Gross Profit %, Net Profit %. | Provides an instantaneous real-time financial health dashboard; flags liquidity crunches (Current Ratio < 1.33) and sluggish inventory rotation. |
| Cash Flow Statement (AS-3) | Segregates cash movements into: (1) Operating Activities; (2) Investing Activities; (3) Financing Activities. | Reveals whether net profit is translating into physical bank liquidity or locked in uncollected debtor receivables. |
| Funds Flow Statement | Tracks changes in Working Capital and identifies long-term Sources and Uses of funds. | Audits whether short-term working capital borrowings were misapplied to finance long-term fixed assets. |
6. Practical Empirical Case Studies
Enterprise Context: A wholesale pharmaceutical distributor in Thrissur suffered severe cash flow bottlenecks with over ₹45 Lakh in overdue receivables.
Tally Implementation: Activated Bill-wise Details and set strict 21-day credit periods on customer ledgers.
- Generated the Bills Outstanding Report (GOT → Statement of Accounts → Outstandings → Receivables) using F12 Aging by Due Date (0–15 days, 16–30 days, 31–60 days, 60+ days).
- Discovered that 6 hospital clients accounted for 72% of debts overdue beyond 60 days. Tally's credit limit controls automatically blocked new sales invoicing to these accounts until outstanding invoices were cleared via
Agst Ref, accelerating debtor recovery by 34%.
Context: A modular kitchen manufacturing unit in Ernakulam struggled with inaccurate manual cost estimates for custom kitchen installations.
BOM Automation: Created distinct Bill of Materials recipes in Tally Prime for 5 modular cabinet lines, capturing exact consumption of plywood, hinges, handles, and laminates.
- Executing the Manufacturing Journal automatically deducted inventory from raw material godowns and allocated 15% labor overheads, establishing true per-unit production cost and eliminating product under-pricing.
7. Calicut University Academic Examination Bank
Exhaustively curated for Calicut University B.Com Semester VI Elective: Computer Applications — COM6EJ308(4): Computerized Accounting with Tally (CUFYUGP 2024 Regulations). Specially formatted for superior academic performance.
The four bill reference methods are: (1) New Ref; (2) Agst Ref; (3) Advance; (4) On Account.
Agst Ref (Against Reference) is utilized when recording a payment receipt (F6) or payment disbursement (F5) to settle an existing pending invoice.
Item Invoice mode includes inventory columns (Item Name, Godown, Quantity, Rate, Amount) for trading physical goods. Accounting Invoice mode omits inventory details and is used by service providers to bill professional charges, rent, or consultancies directly to ledgers.
A Cost Category represents the broad classification dimension (e.g., "Departments" or "Branches"). A Cost Centre is the specific functional unit or project under that category (e.g., "Marketing Department" or "Kochi Branch") to which income or expenditure is allocated.
A Bill of Materials (BOM) is a master recipe listing the standard quantities of raw materials and components required to produce one unit of a finished product. It is executed in a Manufacturing Journal Voucher (a specialized form of Stock Journal, Alt+F7).
Entering the 'Bank Date' records the actual calendar date on which the cheque or online transaction cleared in the physical bank statement. Tally immediately clears that voucher from the un-reconciled variance list and updates the reconciled bank balance.
A Receipt Note records the physical arrival and inspection of goods at the warehouse, increasing physical stock without affecting financial accounting ledgers. A Purchase Invoice records the financial bill, creating the monetary accounts payable liability to the supplier.
(1) Current Ratio (Current Assets / Current Liabilities); (2) Inventory Turnover Ratio (Cost of Goods Sold / Average Stock).
Operational Mechanics:
When activated in Sundry Debtors and Creditors ledgers, Bill-wise accounting tracks every credit invoice as an independent liability unit rather than maintaining a single running lumped balance.
The Four Reference Types:
1. New Ref: Generates a unique tracking reference number for each fresh sales or purchase invoice with credit period terms (e.g.,
Bill #101 due in 30 days).2. Agst Ref: Applied during payment receipts or disbursements, linking payments directly to specific open invoices, clearing them from the aging register.
3. Advance: Records unallocated advance deposits collected from clients before goods dispatch, later knocked off against the final invoice.
4. On Account: Interim payments recorded without bill tagging when specific invoice details are unavailable.
Prevention of Bad Debts: Tally generates dynamic Bills Outstanding Aging Reports (0–30, 31–60, 60+ days) and enforces automated credit limit locks, blocking new sales orders to defaulting clients whose credit days have expired.
Configuration Procedure:
1. Enable Maintain Cost Centres under F11 Company Features.
2. Navigate to
Gateway of Tally → Create → Cost Category → Create category (e.g., "Regional Branches").3. Navigate to
Create → Cost Centre → Select parent category "Regional Branches" and create centres: "Kochi Branch", "Calicut Branch", "Kannur Branch".4. In expense ledgers (e.g., Staff Traveling Expense), ensure "Cost Centres are applicable" is set to Yes.
Business Scenario Demonstration:
Suppose the head office pays ₹60,000 for traveling expenses via bank cheque. In the F5 Payment voucher, upon selecting Traveling Expense A/c for ₹60,000, Tally displays a pop-up sub-form prompting cost allocation. The accountant enters: Kochi Branch: ₹25,000; Calicut Branch: ₹20,000; Kannur Branch: ₹15,000. Tally posts the single monetary debit while updating three independent cost centre profitability reports simultaneously.
Step 1: BOM Configuration in Item Master:
Navigate to
Create → Stock Item → Create finished product (e.g., "Packaged Fruit Juice 1 Liter"). Press F12 and enable Set Component List (Bill of Materials). Set Alter Components (BOM) to Yes. Enter BOM Name (e.g., "Standard 1L Recipe"), unit of manufacture = 1 Liter. List components: Raw Fruit Pulp = 0.4 Kg; Purified Water = 0.6 Liter; Sugar = 0.08 Kg; TetraPak Carton = 1 No.Step 2: Manufacturing Voucher Type Setup:
Navigate to
Create → Voucher Type → Create "Manufacturing Journal", select Type of Voucher = Stock Journal, and set "Use as a Manufacturing Journal" to Yes.Step 3: Executing Production (Alt+F7):
Open Manufacturing Journal, select Product = "Packaged Fruit Juice 1L", enter Quantity to Produce =
500 Liters. Tally automatically calculates and populates the exact raw materials consumed on the left (Source) side, deducting them from inventory. On the right, direct labor and packaging costs are added, computing the exact manufacturing unit cost dynamically.
1. Introduction & The Concept of Unified Enterprise Accounting:
Traditional business software historically operated disjointed islands of data: warehouse stock was tracked in standalone inventory sheets while financial transactions were entered in independent general ledgers. Tally Prime's integrated architecture unifies financial accounting with material inventory into a single relational ecosystem.
2. End-to-End Order Processing Integration:
• Order-to-Cash Cycle: Tracking sales orders through Delivery Notes (updating physical inventory) to final Sales Invoicing (updating customer receivables and revenue ledgers), eliminating duplicate data entry.
• Procure-to-Pay Cycle: Tracking purchase orders through Receipt Notes to final Purchase Invoices, enforcing strict three-way quantity and price matching.
3. Real-Time Multi-Location Inventory & Costing:
• Tracking inventory across distributed godowns via Stock Journals (Alt+F7) enables multi-branch visibility.
• Automated inventory valuation rules (FIFO, Weighted Average, Last Purchase Cost) immediately update the Cost of Goods Sold in the Trading Account, reflecting true gross margins.
4. Executive Decision Support & Analytical Reporting:
• Ratio Analysis: Instantaneous calculation of liquidity, working capital turnover, and operating margins without manual spreadsheet formula drafting.
• Cash Flow Statement (AS-3): Segregating operating, investing, and financing cash flows, exposing whether accounting net profits are tied up in delinquent trade receivables.
• Budget Variance Tracking: Enforcing operational discipline across departments by monitoring expenditure against pre-approved budgets.
5. Conclusion:
The complete integration of accounting and inventory in Tally Prime empowers management with total operational visibility, tighter working capital controls, and robust audit compliance.
(b) A manufacturing unit produces 'Office Chairs'. The Bill of Materials (BOM) for 1 Chair requires: Steel Frame: 1 No @ ₹400; Molded Foam: 1 No @ ₹250; Fabric: 1.5 Mtrs @ ₹100/Mtr; Castor Wheels: 5 Nos @ ₹30/No. Direct labor cost is ₹80 per chair. Detail the Manufacturing Journal voucher entry for producing 100 Office Chairs, calculating total raw material cost, additional costs, and finished cost per chair.
Part (a): Bill-Wise Transaction Accounting Sequence:
1. 1st May 2024: Credit Sales of ₹1,50,000 (Invoice #201):
• Voucher Type: F8 (Sales Voucher).
• Debit: M/s Modern Retailers A/c → ₹1,50,000 [Bill Ref: New Ref: INV-201, Credit Period: 30 Days].
• Credit: Sales A/c → ₹1,50,000.
2. 10th May 2024: Sales Return of Damaged Goods (₹15,000):
• Voucher Type: Alt+F6 (Credit Note Voucher).
• Debit: Sales Returns A/c → ₹15,000.
• Credit: M/s Modern Retailers A/c → ₹15,000 [Bill Ref: Agst Ref: INV-201].
(Net outstanding balance on INV-201 becomes ₹1,35,000).
3. 20th May 2024: Advance Received (₹35,000):
• Voucher Type: F6 (Receipt Voucher).
• Debit: Bank / Cash A/c → ₹35,000.
• Credit: M/s Modern Retailers A/c → ₹35,000 [Bill Ref: Advance: ADV-01 or Agst Ref: INV-201].
(If tagged against INV-201, remaining balance becomes ₹1,00,000).
4. 30th May 2024: Final Settlement via NEFT (₹1,00,000):
• Voucher Type: F6 (Receipt Voucher).
• Debit: SBI Current A/c → ₹1,00,000.
• Credit: M/s Modern Retailers A/c → ₹1,00,000 [Bill Ref: Agst Ref: INV-201].
(INV-201 is fully cleared and zero balance reflects in the Aging Report).
Part (b): Manufacturing Journal Voucher for 100 Office Chairs:
• 1. Per-Unit Raw Material Recipe Cost:
• Steel Frame: 1 No × ₹400 = ₹400
• Molded Foam: 1 No × ₹250 = ₹250
• Fabric: 1.5 Mtrs × ₹100 = ₹150
• Castor Wheels: 5 Nos × ₹30 = ₹150
• Total Raw Material Cost Per Chair: ₹400 + ₹250 + ₹150 + ₹150 = ₹950.00.
• 2. Total Batch Production Consumption (100 Chairs):
• Steel Frames: 100 Nos × ₹400 = ₹40,000
• Molded Foam: 100 Nos × ₹250 = ₹25,000
• Fabric: 150 Mtrs × ₹100 = ₹15,000
• Castor Wheels: 500 Nos × ₹30 = ₹15,000
• Total Raw Materials Consumed (Source): ₹95,000.00.
• 3. Additional Manufacturing Overheads:
• Direct Labor Cost: 100 Chairs × ₹80 = ₹8,000.00.
• 4. Finished Goods Valuation (Destination):
• Total Manufacturing Cost = Raw Materials (₹95,000) + Labor (₹8,000) = ₹1,03,000.00.
• Finished Cost Per Chair: ₹1,03,000 / 100 = ₹1,030.00 per Chair.
Tally automatically increases the finished stock of "Office Chairs" by 100 units at ₹1,030 each in the designated Godown.
Course Code: COM6EJ308(4) • Course Title: Computerized Accounting with Tally • Semester: VI • Credits: 4 • Contact Hours: 60
Module III Title: TAX APPLICATION & GST COMPLIANCE IN TALLY (10 Contact Hours)
Syllabus Units Covered: Unit 3: Introduction to GST — Architecture of Dual GST (CGST, SGST, IGST, UTGST, Cess), Statutory Background • GST Activation in Tally — F11 Setup, 15-Digit GSTIN Structure, Regular vs. Composition Registration • Tax Rate Hierarchy & Classification — Mapping Tax Rates & HSN/SAC Codes at Company, Group, Item & Ledger Tiers • Input Tax Credit (ITC) Mechanics — Eligible ITC, Blocked Credits (Sec. 17(5)), Reverse Charge Mechanism (RCM) • Tax Invoices, Credit Notes & Debit Notes — Statutory Mandates under Section 31 & Rule 46 • GST Returns in Tally — GSTR-1 (Outward Supplies), GSTR-3B (Summary Return), GSTR-2B Matching, Tax Offset & Payment • Advanced Modern Features — E-Invoicing, E-Way Bill Integration, QR Code Compliance • Calicut University Academic Examination Bank (Part A: 2 Marks, Part B: 5 Marks, Part C: 10/15 Marks).
1. Overview: Automated Statutory Taxation in Modern Enterprise ERP
The implementation of the Goods and Services Tax (GST) on 1st July 2017 fundamentally reshaped Indian commercial accounting. GST replaced a fragmented maze of cascading indirect taxes (Central Excise, Service Tax, State VAT, Entry Tax, Luxury Tax) with a unified, digital, destination-based consumption tax. In this regime, manual tax calculation is practically obsolete: compliance requires real-time validation of 15-digit GSTINs, automatic determination of Place of Supply (POS) for tax splitting, HSN/SAC code tracking, and automated electronic return generation.
Tally Prime incorporates a built-in statutory tax engine that automates end-to-end GST administration. When an invoice is entered, Tally determines whether the transaction is Intra-State (triggering CGST + SGST) or Inter-State (triggering IGST), calculates taxes with mathematical precision, validates eligibility for Input Tax Credit (ITC), flags blocked credits under Section 17(5), and populates statutory returns (GSTR-1 and GSTR-3B) with zero manual intervention. Module III provides an exhaustive academic and procedural analysis of GST taxation in Tally.
1. ACTIVATION & TAX HIERARCHY
• HSN/SAC Mapping: 5-tier tax rate hierarchy (Company to Voucher level).
• Duties & Taxes Ledgers: CGST, SGST, IGST, and Cess under Current Liabilities.
2. DYNAMIC TAX COMPUTATION & RCM
• Reverse Charge (RCM): Self-invoicing, tax liability booking, and ITC claims.
• Composite GST: Turn-over based tax calculation for small retailers.
3. STATUTORY INVOICING & E-WAY BILLS
• Debit & Credit Notes: Adjusting turnover and ITC with original invoice tagging.
• E-Invoicing & E-Way Bills: Live JSON generation and portal API synchronization.
4. RETURN FILING & RECONCILIATION
• GSTR-3B Consolidation: Eligible vs. ineligible ITC and tax offset rules.
• GSTR-2B Matching: Resolving vendor mismatches and protecting cash flow.
2. GST Setup, Registration Types & The Five-Tier Tax Hierarchy
A. F11 Company Statutory Setup and GSTIN Architecture
Enabling GST in Tally Prime requires configuring parameters under F11 → Enable Goods and Services Tax (GST):
- State & Registration Type: Designating the home operating state (e.g., Kerala - State Code 32) and selecting between Regular (standard monthly/quarterly tax filer claiming ITC) and Composition Scheme (small dealers paying concessional turnover tax without ITC).
- GSTIN / UIN Structure: The mandatory 15-character alphanumeric Goods and Services Tax Identification Number:
[State Code: 2 Digits (e.g., 32)] + [Entity PAN: 10 Alphanumeric] + [Entity Number: 1 Char] + [Default 'Z'] + [Checksum: 1 Char]. - Periodicity of GSTR-1: Configuring filing frequency: Monthly (turnover > ₹5 Crore) or Quarterly under the QRMP (Quarterly Return Monthly Payment) scheme.
B. The Five-Tier GST Rate Hierarchy in Tally
Tally features a sophisticated inheritance hierarchy that resolves tax rates and HSN/SAC codes from top to bottom. If a rate is not defined at a lower level, Tally automatically inherits it from the level above:
| Hierarchy Tier | Configuration Level | Appropriate Business Deployment |
|---|---|---|
| Tier 1: Company Level | F11 → GST Details |
Best for single-product businesses where all goods share the same tax rate (e.g., a garment manufacturer where 100% of products attract 12% GST). |
| Tier 2: Stock Group Level | Create / Alter → Stock Group |
The industry standard for multi-category traders. E.g., setting 5% on "Food Grains" group and 18% on "Stationery" group; all child items inherit automatically. |
| Tier 3: Stock Item Level | Create / Alter → Stock Item |
Applied when specific items within a group carry exceptional rates or distinct 8-digit HSN codes. Overrides Stock Group rates. |
| Tier 4: Ledger Level | Create / Alter → Ledger Master |
Standard for service expense ledgers (e.g., Auditing Fees assigned 18% under SAC 9982) and dedicated tax-rate sales ledgers (e.g., "Sales @ 18%"). |
| Tier 5: Voucher Level | Voucher Entry Screen → F12 Configuration |
Manual transaction override during live voucher entry; takes ultimate precedence over all preceding tiers. |
3. Input Tax Credit (ITC), Reverse Charge & Composite Scheme
A. Input Tax Credit (ITC) Mechanics
Input Tax Credit (ITC) is the mechanism allowing a registered business to deduct the GST paid on purchases (raw materials, capital equipment, operational services) from the GST collected on sales:
Mathematical Mechanics of Net GST Liability
Net GST Payable to Government = Output Tax Liability (on Sales) - Eligible Input Tax Credit (on Purchases)
1. IGST Credit: Must be completely exhausted first against Output IGST, then Output CGST, and finally Output SGST in any order.
2. CGST Credit: Used against Output CGST, then Output IGST. (CGST Credit can NEVER be offset against Output SGST).
3. SGST Credit: Used against Output SGST, then Output IGST. (SGST Credit can NEVER be offset against Output CGST).
B. Blocked / Ineligible Input Tax Credit (Section 17(5))
Under Section 17(5) of the CGST Act, certain purchases are statutorily ineligible for ITC, even if used for business purposes. In Tally, the accountant marks these as Ineligible ITC:
- Motor vehicles for transportation of persons having seating capacity ≤ 13 persons (except when used for commercial passenger transport or driving schools).
- Food and beverages, outdoor catering, beauty treatment, and health insurance (unless mandated by statutory law for employees).
- Goods lost, stolen, destroyed, written off, or disposed of as free gifts or commercial samples.
- Works contract services for construction of immovable property (except for plant and machinery).
C. Reverse Charge Mechanism (RCM) in Tally
Under normal GST, the supplier collects tax and remits it. Under Reverse Charge Mechanism (RCM) (Sections 9(3) and 9(4)), the recipient is legally obligated to pay GST directly to the government:
- RCM Scenarios: Procuring Goods Transport Agency (GTA) freight services, legal services from advocates, sponsorship services, or importing services from foreign vendors.
- Tally Accounting Cycle: (1) Record purchase voucher checking "Is Reverse Charge Applicable = Yes"; (2) Pass a Journal voucher (F7) using Statutory Adjustment to raise tax liability (
Tax on RCM A/c Dr. To Output CGST/SGST); (3) Discharge tax in cash via Challan PMT-06; (4) Claim equivalent ITC in the next month's GSTR-3B.
4. Statutory Invoicing, Credit/Debit Notes & Modern E-Invoicing
A. Statutory Tax Invoice Requirements (Section 31 & Rule 46)
A valid GST Tax Invoice generated from Tally must display:
- Consecutive serial numbering unique for each financial year, containing only letters, numerals, and slashes/hyphens.
- Name, registered address, and 15-digit GSTIN of the supplier and recipient.
- Place of Supply (POS) along with state name and state code.
- HSN/SAC codes, description, quantity, taxable value, and explicit tax split (CGST, SGST, IGST).
- Digital signature / authorized signatory physical signature.
B. Modern Electronic Invoicing (E-Invoicing) & E-Way Bills
Under Central Board of Indirect Taxes and Customs (CBIC) mandates, registered businesses with aggregate turnover exceeding prescribed thresholds (currently ₹5 Crore) must generate E-Invoices:
| Compliance Mechanism | Regulatory Standard & Threshold | Tally Prime Integrated Workflow |
|---|---|---|
| Electronic Invoicing (E-Invoice) | Mandatory for B2B supplies where turnover > ₹5 Crore. Requires uploading invoice payload to the Invoice Registration Portal (IRP). | Tally Prime connects directly to the IRP via API, transmits invoice JSON, and retrieves the 64-character Invoice Reference Number (IRN) and encrypted signed QR Code, printing them on the invoice in real time. |
| Electronic Way Bill (E-Way Bill) | Mandatory for movement of goods where consignment value exceeds ₹50,000 (Inter-State) or ₹1,00,000 (Intra-State in Kerala). | Tally auto-generates E-Way Bill JSON containing Part A (goods details) and Part B (vehicle number / transporter ID), automatically fetching the 12-digit E-Way Bill Number. |
5. Statutory GST Returns & Reconciliation in Tally Prime
A. GSTR-1: Outward Supplies Statement
GSTR-1 is the monthly/quarterly return reflecting all outward sales of goods and services. Tally automatically maps transactions into statutory reporting tables:
- Table 4 (B2B Invoices): Sales to registered persons holding valid GSTINs. Requires invoice-level detail.
- Table 5 (B2C Large): Inter-state sales to unregistered consumers where invoice value > ₹2,50,000.
- Table 7 (B2C Small): Intra-state sales and small inter-state sales to unregistered consumers, reported in state-wise consolidated summaries.
- Table 9 (Credit / Debit Notes): Adjustments to registered and unregistered invoices.
- Table 12 (HSN-wise Summary): Consolidated summary of goods and services categorized by HSN/SAC codes, total quantity, total taxable value, and tax amounts.
B. GSTR-3B: Consolidated Monthly Summary Return
GSTR-3B is the self-declared summary return used to discharge monthly tax liabilities:
SECTION 3.1: OUTWARD SUPPLIES & RCM
• 3.1(b): Outward taxable supplies (zero-rated exports).
• 3.1(d): Inward supplies liable to reverse charge (RCM).
SECTION 4: ELIGIBLE INPUT TAX CREDIT (ITC)
• 4(B): ITC Reversed (Rule 42/43 for exempt supplies).
• 4(D): Ineligible ITC under Section 17(5).
C. GSTR-2B Matching and Reconciliation
Under Section 16(2)(aa) of the CGST Act, a buyer can claim ITC only if the supplier has filed their GSTR-1 and the invoice appears in the buyer's auto-drafted GSTR-2B statement:
- Tally's GSTR-2B Reconciliation Utility: Users import the GSTR-2B JSON file downloaded from the GST portal into Tally Prime.
- Algorithmic Status Matching: Tally compares internal purchase registers against the portal data, categorizing invoices into: Reconciled (100% exact match), Mismatch in Tax/Amount, and Missing in GSTR-2B (supplier failed to file return).
- Fiduciary Protection: Enables management to withhold payment of GST amounts to defaulting suppliers, eliminating tax loss risks.
6. Practical Empirical Case Studies
Enterprise Scenario: An automotive spare parts distributor in Kozhikode recorded ₹8,50,000 of input tax in its internal purchase register for August 2024. However, its portal GSTR-2B reflected only ₹7,15,000, creating an alarming discrepancy of ₹1,35,000.
Tally Prime Reconciliation Audit:
- Imported the August GSTR-2B JSON file into Tally's GST reconciliation tool.
- Discovered that a major brake component manufacturer (Invoice #412 for ₹1,18,000 including ₹18,000 GST) had erroneously uploaded the invoice under a different customer's GSTIN.
- Identified two supplier invoices totaling ₹1,17,000 omitted because the vendors filed GSTR-1 after the 11th of the month.
- Result: Tally prevented the company from claiming ₹1,35,000 of uncredited ITC in GSTR-3B, saving the enterprise from receiving a Section 73 statutory demand notice carrying 18% penal interest.
Context: A spice exporting company in Kochi paid ₹1,50,000 to Goods Transport Agencies (GTA) for container transportation to Cochin Port.
Tally RCM Implementation: Passed purchase vouchers under RCM (5% GST). Tally booked the liability of ₹7,500 (₹3,750 CGST + ₹3,750 SGST) in Table 3.1(d) of GSTR-3B. The company remitted ₹7,500 via Challan PMT-06 and immediately claimed ₹7,500 under Table 4(A)(3) as eligible ITC in the same tax period, achieving 100% cash neutrality and statutory compliance.
7. Calicut University Academic Examination Bank
Exhaustively curated for Calicut University B.Com Semester VI Elective: Computer Applications — COM6EJ308(4): Computerized Accounting with Tally (CUFYUGP 2024 Regulations). Specially formatted for superior academic performance.
The 15-digit GSTIN is structured as: (1) First 2 digits: State Code (e.g.,
32 for Kerala); (2) Next 10 characters: PAN of the legal entity; (3) 13th character: Entity registration number within state (e.g., 1); (4) 14th character: Default alphabet 'Z'; (5) 15th character: Checksum validation code.
An Intra-State Supply occurs when the supplier's location and the Place of Supply (POS) are in the same state, attracting CGST + SGST equally. An Inter-State Supply occurs when the supplier and POS are in different states, attracting IGST (Integrated GST) in full.
Under the Reverse Charge Mechanism (RCM), the statutory liability to pay GST to the government shifts from the supplier to the recipient of goods or services (e.g., procurement of GTA transport or legal services).
(1) Composition dealers cannot claim Input Tax Credit (ITC) on purchases; (2) They cannot collect GST from customers and cannot issue tax invoices (must issue a 'Bill of Supply').
(1) Motor vehicles for passenger transport with seating capacity ≤ 13 persons; (2) Food and beverages, outdoor catering, and health insurance (unless statutory employer obligations).
GSTR-1 is a detailed statement of all outward sales supplies (invoice-level details for B2B, HSN summaries). GSTR-3B is a consolidated self-assessed summary return showing total sales turnover, eligible ITC, and net tax paid.
IRN stands for Invoice Reference Number, a unique 64-character hash code generated by the government Invoice Registration Portal (IRP) upon validating an uploaded e-invoice payload.
The Five-Tier GST Rate Hierarchy:
Tally Prime resolves tax rates and HSN codes through a hierarchical inheritance structure:
1. Company Level (F11): Default master level. Applied when all business products share a single tax rate.
2. Stock Group Level: The standard setup for retail/wholesale. Grouping products (e.g., "Dairy" @ 5%, "Footwear" @ 12%) cascades down to all child items.
3. Stock Item Level: Overrides Stock Group rates when specific items carry exceptional rates or distinct 8-digit HSN codes.
4. Ledger Level: Applied to service expense ledgers (e.g., Audit Fees assigned 18%) or dedicated tax sales ledgers.
5. Voucher Level: Live override during voucher entry via F12 configuration; takes ultimate precedence.
Resolution Rule: Tally always searches from the bottom tier up: Voucher → Ledger → Item → Group → Company. The lowest specific level defined overrides all higher global levels.
Under Section 49, 49A, and 49B of the CGST Act, ITC must be offset against output tax liabilities in a strict statutory sequence:
1. Mandatory Exhaustion of IGST Credit:
Available IGST credit must be completely utilized 100% before any CGST or SGST credit can be touched. It is set off against Output IGST first; any remaining balance can be set off against Output CGST and Output SGST in any proportion chosen by the taxpayer.
2. Utilization of CGST Credit:
CGST credit can be set off against Output CGST first, and any surplus balance can be applied to Output IGST.
3. Utilization of SGST Credit:
SGST credit can be set off against Output SGST first, and any surplus balance can be applied to Output IGST.
Critical Cross-Set-off Prohibition: CGST credit can NEVER be used to pay Output SGST, and SGST credit can NEVER be used to pay Output CGST.
Significance of GSTR-2B:
GSTR-2B is a static, auto-drafted ITC statement generated on the 14th of each month reflecting invoices filed by suppliers. Under Section 16(2)(aa), claiming ITC on an invoice not appearing in GSTR-2B is illegal and attracts demand notices with 18% interest and penalties.
Tally Prime Reconciliation Safeguards:
1. Direct JSON Import: The accountant imports the GSTR-2B JSON statement directly into Tally Prime.
2. Automated Status Tagging: Tally matches invoice numbers, dates, and tax values, sorting bills into: Reconciled, Mismatched in Values, and Available in Books but Missing in GSTR-2B.
3. Vendor Payment Withholding: Generates automated vendor discrepancy lists, allowing the accounts department to withhold the GST component from defaulting suppliers until they file their returns, safeguarding enterprise cash flow.
1. Introduction & The Architecture of Digital Taxation:
The introduction of GST transformed Indian commerce into a data-driven, technology-linked indirect tax ecosystem. Tally Prime serves as a certified Application Service Provider (ASP) platform, automating the complete indirect tax lifecycle for commercial enterprises.
2. Master Setup & Classification Foundations:
• Configuring 15-digit GSTINs, assigning HSN/SAC codes, and creating dedicated tax ledgers (CGST, SGST, IGST) under Duties & Taxes.
• Implementing the 5-tier tax rate hierarchy ensuring error-free automated tax calculations across complex product inventories.
3. Transaction Invoicing & Place of Supply Routing:
• Tally validates customer state codes dynamically: routing intra-state sales to CGST+SGST and inter-state sales to IGST, eliminating human misallocations.
• Enforcing statutory invoice fields mandated by Rule 46 (consecutive numbering, HSN, POS).
4. Reverse Charge Mechanism (RCM) & Self-Invoicing:
• Recording GTA freight and legal services under RCM, auto-generating tax liability via statutory journal entries, and reclaiming equivalent ITC in cash flow neutrality.
5. Automated Statutory Return Filing (GSTR-1, GSTR-3B & E-Invoicing):
• Real-time population of GSTR-1 outward tables (B2B, B2C, HSN Summary) and export to JSON for direct portal upload.
• Automated GSTR-3B tax offset calculations strictly obeying Section 49 rules.
• Real-time API integration with the government Invoice Registration Portal (IRP), generating IRN hash codes and encrypted QR codes on invoices.
6. Conclusion:
Tally Prime eliminates tax filing stress, provides foolproof audit trails, and protects businesses from severe penalties and lost Input Tax Credits.
1. Sold 10 Laptops @ ₹50,000 each plus 18% GST to Apex Infotech, Kochi (GSTIN: 32BBBCB5678G1Z2) on credit.
2. Sold 5 Laptops @ ₹52,000 each plus 18% GST to Metro Systems, Bengaluru, Karnataka (GSTIN: 29CCCC9999K1Z3) on credit.
3. Paid Goods Transport Agency (GTA) freight charges of ₹20,000 liable to 5% GST under Reverse Charge (RCM).
Show the exact Tally voucher entries, specifying Voucher Type, Ledger Debits/Credits, Tax Split (CGST/SGST/IGST), and GSTR-3B table placement.
(b) On 30th September 2024, ABC Electronics reports the following balances: Output CGST = ₹45,000; Output SGST = ₹45,000; Output IGST = ₹60,000; Input Tax Credit Available: Input IGST = ₹90,000; Input CGST = ₹20,000; Input SGST = ₹20,000. Calculate the statutory set-off under Section 49 and determine net tax payable or balance ITC carried forward.
Part (a): Invoicing Vouchers & Tax Entries:
1. Intra-State Sales to Apex Infotech, Kochi (Kerala → Kerala):
• Voucher Type: F8 (Sales Voucher) [Item Invoice Mode].
• Taxable Value = 10 × ₹50,000 = ₹5,00,000 • Tax: CGST @ 9% = ₹45,000; SGST @ 9% = ₹45,000.
• Accounting Entry:
Apex Infotech A/c Dr. ₹5,90,000To Sales A/c Cr. ₹5,00,000To Output CGST A/c Cr. ₹45,000To Output SGST A/c Cr. ₹45,000• Return Placement: GSTR-1 Table 4A (B2B); GSTR-3B Table 3.1(a).
2. Inter-State Sales to Metro Systems, Bengaluru (Kerala → Karnataka):
• Voucher Type: F8 (Sales Voucher) [Item Invoice Mode].
• Taxable Value = 5 × ₹52,000 = ₹2,60,000 • Tax: IGST @ 18% = ₹46,800.
• Accounting Entry:
Metro Systems A/c Dr. ₹3,06,800To Sales A/c Cr. ₹2,60,000To Output IGST A/c Cr. ₹46,800• Return Placement: GSTR-1 Table 4A (B2B); GSTR-3B Table 3.1(a).
3. GTA Freight Under Reverse Charge (₹20,000 @ 5% GST):
• Voucher Type: F9 (Purchase) / F5 (Payment).
• GTA Expense A/c Dr. ₹20,000 • To Cash / Bank A/c Cr. ₹20,000.
• Tax Liability = 5% of ₹20,000 = ₹1,000 (CGST ₹500 + SGST ₹500).
• Statutory Adjustment Journal (F7):
Tax on RCM A/c Dr. ₹1,000 • To Output CGST (RCM) Cr. ₹500 • To Output SGST (RCM) Cr. ₹500.• Return Placement: GSTR-3B Table 3.1(d) (Liability paid in cash) and Table 4(A)(3) (Eligible ITC).
Part (b): Statutory Tax Offset Calculation (Section 49):
• Total Output Tax Liabilities:
Output IGST = ₹60,000 • Output CGST = ₹45,000 • Output SGST = ₹45,000 • Total = ₹1,50,000.
• Step 1: Set off Input IGST (Available = ₹90,000):
1. Offset against Output IGST (₹60,000): Balance Output IGST becomes ₹0. Remaining Input IGST = ₹30,000.
2. Offset remaining Input IGST against Output CGST: Apply ₹30,000 against Output CGST (₹45,000). Remaining Output CGST = ₹15,000. Input IGST is now completely exhausted (₹0).
• Step 2: Set off Input CGST (Available = ₹20,000):
Apply Input CGST against remaining Output CGST (₹15,000): Output CGST becomes ₹0. Remaining unused Input CGST = ₹5,000.
• Step 3: Set off Input SGST (Available = ₹20,000):
Apply Input SGST against Output SGST (₹45,000): Output SGST becomes ₹45,000 - ₹20,000 = ₹25,000. Input SGST is completely exhausted.
• (Note: Surplus Input CGST of ₹5,000 cannot be set off against Output SGST).
• Final Settlement Verdict:
• Net Cash Tax Payable to Government: ₹25,000 (SGST paid via Challan PMT-06).
• Surplus ITC Carried Forward in Electronic Credit Ledger: ₹5,000 (CGST Credit).
Course Code: COM6EJ308(4) • Course Title: Computerized Accounting with Tally • Semester: VI • Credits: 4 • Contact Hours: 60
Module IV Title: TECHNOLOGY ADVANTAGE & ENTERPRISE DATA SECURITY IN TALLY (8 Contact Hours)
Syllabus Units Covered: Unit 4: Technological Architecture of Tally — Proprietary C++ Relational Data Engine, Concurrent Multi-User Execution, Zero-Latency Synchronization • Tally Audit & Audit Trail — Tracking Voucher Alterations, Date Stamps, User Stamps, Companies Act Statutory Edit Log Mandate • Tally Vault & Enterprise Security — Cryptographic Encryption (AES/DES), Concealed Company Names, Role-Based Access Controls (Owner vs. Data Entry) • Database Administration — Backup (.tbk), Restore, Splitting Financial Years, Company Merging • Open Database Connectivity (ODBC) — Interfacing Tally with MS-Excel, SQL Server & Python • Data Import & Export — XML Data Pipelines, Multi-Branch Synchronization • Web-Enabled Reporting & Tally.NET — Encrypted Browser Access & Remote Auditing • Calicut University Academic Examination Bank (Part A: 2 Marks, Part B: 5 Marks, Part C: 10/15 Marks).
1. Overview: The Technological Infrastructure of Enterprise Tally
Beyond its accounting and inventory masters, Tally Prime derives its global dominance from an exceptionally fast, robust, and proprietary computational architecture. Built on a customized, non-relational C++ database engine, Tally achieves what conventional SQL database systems often struggle with: instantaneous real-time double-entry recalculations without dedicated database administrators or batch processing queues.
In contemporary enterprise governance, accounting software must deliver ironclad security, forensic audit trails, and multi-platform data interoperability. Regulatory statutes—such as the Ministry of Corporate Affairs (MCA) Audit Trail / Edit Log Mandate under the Companies Act, 2013—demand that every voucher alteration be immutably recorded. Module IV explores Tally's technological pillars: Tally Vault cryptographic encryption, Tally Audit controls, ODBC live data bridges, XML synchronization across distributed branch networks, and secure mobile browser reporting via Tally.NET.
1. DATABASE ENGINE & PERFORMANCE
• Zero Data Loss: Automatic dynamic journaling preventing database corruption.
• Multi-User Scaling: Tally Server 9 supporting concurrent multi-terminal entry.
2. FORENSIC AUDIT & SECURITY
• Tally Vault: Advanced cryptographic file encryption; hides company name on disk.
• Role Permissions: Granular user security restricting backdated voucher alterations.
3. DATABASE MANAGEMENT & SPLITTING
.tbk snapshots on cloud/flash drives.• Financial Year Split: Splitting multi-year data into distinct financial year books.
• Group Companies: Consolidating parent and subsidiary ledgers into single balance sheets.
4. INTEROPERABILITY & CLOUD ACCESS
• XML & Synchronization: Automated data replication between branches and Head Office.
• Web-Enabled Reports: Encrypted browser-based reporting on mobile devices via Tally.NET.
2. Technological Architecture & The Proprietary Tally Engine
A. The C++ Object-Oriented Database Architecture
Unlike conventional ERP packages (SAP, Oracle) that depend on heavy external Relational Database Management Systems (RDBMS) requiring dedicated database administrators, Tally is built on an integrated, self-contained C++ Object-Oriented Database Engine:
- Direct Memory Pointers: Data records are connected via high-speed memory pointers rather than disk-intensive SQL join operations, allowing instant report generation across millions of transactions.
- Zero Database Footprint: Tally requires no third-party database installation (e.g., Oracle, MySQL). The entire database engine is embedded directly within the lightweight application executable.
- Dynamic Roll-Forward Recovery: If a sudden power loss occurs during voucher entry, Tally's transactional journal rolling engine recovers uncommitted memory buffers without database corruption upon reboot.
B. Concurrent Multi-User Execution & Tally Server 9
In large commercial firms, hundreds of terminals access the central accounting repository simultaneously:
TALLY PRIME GOLD (MULTI-USER LAN)
TALLY SERVER 9 (ENTERPRISE CACHING)
3. Forensic Governance: Tally Audit, Edit Log & Tally Vault Security
A. Tally Audit and the Statutory Edit Log Mandate
Under the Companies (Accounts) Rules, 2014 (as amended by the Ministry of Corporate Affairs), every company using accounting software must maintain an immutable Audit Trail (Edit Log) recording every change made to books of account:
- The Edit Log Feature in Tally Prime: Once enabled, Tally maintains a permanent, tamper-proof historical log of every transaction. The edit log records: (1) Date and time of voucher creation; (2) Username of the creator; (3) Date and time of any subsequent alteration or deletion; (4) The exact before-and-after values of altered fields.
- Tally Audit Operations: Statutory auditors utilize
Gateway of Tally → Display More Reports → Analysis & Verificationto review all altered vouchers, un-reconciled bank entries, and back-dated postings, instantly uncovering unauthorized management overrides.
B. Cryptographic Security via Tally Vault
Tally Vault Cryptographic Mechanics
1. Military-Grade File Encryption:
Tally Vault encrypts the entire raw database folder on the local hard drive using advanced symmetric key cryptographic algorithms (such as the Data Encryption Standard - DES, and Advanced Encryption Standard - AES).
In normal companies, Tally displays the company name and a 5-digit folder number (e.g.,
10001). When Tally Vault is enabled, the company name on the selection screen is completely replaced by asterisks (*****). Even if an intruder steals the hard drive, they cannot identify which folder belongs to which company without the Vault Password.
3. Absolute Non-Recoverability:
Because Tally Vault utilizes zero-knowledge encryption, there is no "forgot password" or backdoor recovery utility. If the owner loses the Vault Password, the financial data is permanently cryptographically irrecoverable.
C. Role-Based User Access Controls (UAC)
Tally enables management to configure granular user security levels:
| Security Role | Permitted Operational Scope | Restricted / Blocked Capabilities |
|---|---|---|
| Owner (Super Administrator) | Full unrestricted access across all masters, vouchers, reports, F11 features, and security settings. | None. Holds ultimate administrative authority over the enterprise database. |
| Data Entry Operator | Passing sales invoices, receipts, payment vouchers, and viewing the daily Day Book. | Blocked from viewing the Balance Sheet, Profit & Loss A/c, or altering master chart of accounts; barred from backdating vouchers beyond 3 days. |
| Auditor | Read-only access across all general ledgers, trial balances, and audit verification tools. | Cannot create, edit, or delete accounting vouchers or master ledgers. |
4. Database Maintenance: Backup, Restore & Splitting Financial Years
A. Backup and Restore Procedures
Rigorous database administration requires automated off-site data protection:
- Backup Procedure (Alt+Y → Backup): Compresses the 5-digit company data folder (e.g., folder
10001) into a single, encrypted backup archive file with the extension .tbk (e.g.,TBK900_10001.001). Management stores this archive across external SSDs, network-attached storage (NAS), or encrypted cloud storage. - Restore Procedure (Alt+Y → Restore): Unpacks the
.tbkarchive back into a functional 5-digit data folder in the designated Tally data directory, allowing instantaneous disaster recovery.
B. Splitting Company Financial Data
The Mechanics of Splitting Financial Years
1. Why Split Data? As a company records hundreds of thousands of transactions over several years, the database file expands, slowing down multi-user search queries. Splitting divides multi-year data into distinct, independent annual company files.
Navigate to
Alt+Y → Split → Verify Company Data to audit unadjusted bills. Select Split Company Data → Choose Split Date (e.g., 01-04-2024).
3. Mathematical Outcome of Split:
Tally generates two new independent companies from the parent file:
• Company A (Pre-Split): Contains historical transactions up to 31st March 2024.
• Company B (Post-Split): Commences on 1st April 2024, with all closing balances from Company A automatically converted into opening balances, leaving historical data permanently frozen and uncorrupted.
5. Interfacing, Data Interoperability & Cloud Capabilities
A. Open Database Connectivity (ODBC) Live Data Interfacing
ODBC (Open Database Connectivity) is an industry-standard database abstraction layer that allows external software applications to communicate directly with Tally's database in real time:
- The ODBC Server Port: Tally Prime can be configured to run as an ODBC Server on a designated port (e.g., port
9000). - Real-Time Integration with MS-Excel: A financial analyst opens Microsoft Excel, navigates to
Data → Get Data → From ODBC, connects to Tally, and writes standard SQL queries (e.g.,SELECT ClosingBalance FROM Ledger WHERE $Parent = 'Sundry Debtors'). - Live Management Dashboards: The Excel spreadsheet establishes a live dynamic data pipeline: whenever a billing clerk passes a sales voucher in Tally, the Excel dashboard refreshes instantaneously without manual file exports.
B. Data Import and Export Formats (XML, Excel, PDF)
Tally supports extensive data exchange formats:
| File Format | Technical Structure | Enterprise Integration Deployment |
|---|---|---|
| Extensible Markup Language (XML) | Hierarchical text file enclosed in semantic metadata tags (<VOUCHER><DATE>...</DATE></VOUCHER>). |
The standard programmatic pipeline for importing master ledgers and bulk sales invoices from e-commerce platforms (Amazon, Shopify) directly into Tally. |
| Excel Spreadsheet (.xlsx) | Standard row-and-column tabular workbook. | Exporting Trial Balances and Stock Summaries for advanced financial ratio modeling and auditor review. |
| Portable Document Format (.pdf) | Vectorized, encrypted, non-editable document format. | Emailing signed GST tax invoices, purchase orders, and payment receipts directly to external clients and vendors. |
C. Multi-Branch Data Synchronization & Web-Enabled Reporting
Modern multi-location retail chains and corporate groups leverage Tally's distributed network services:
- Data Synchronization: Enables two-way data replication between branch terminals and the Central Head Office server over the internet. Branch vouchers replicate automatically to the head office, while centralized price master updates cascade down to all branches.
- Web-Enabled Browser Reporting: Authorized business owners can log into a secure web browser on any smartphone or tablet from anywhere in the world, securely authenticating via Tally.NET to view live Balance Sheets, Cash Flow statements, and debtor aging reports without having Tally installed locally.
6. Practical Empirical Case Studies
Enterprise Context: During annual statutory audit at a wholesale hardware enterprise in Kozhikode, auditors noted an unexpected cash shortfall of ₹3,20,000 against recorded sales.
Forensic Tally Audit Investigation:
- The auditor accessed the Tally Edit Log (Analysis & Verification → Altered Vouchers) for Cash Sales vouchers.
- Discovered that a billing clerk had created valid cash sales invoices for customers, but subsequently opened the vouchers at 7:30 PM after customer departure and altered the invoice amounts downwards (e.g., altering a ₹45,000 cash sale to ₹15,000), pocketing the ₹30,000 cash difference.
- The Edit Log preserved the immutable chronological record: showing exact timestamps, the clerk's user login ID, the original ₹45,000 amount, and the altered ₹15,000 entry.
- Legal Outcome: Provided unassailable digital evidence for criminal prosecution under Section 477A of the IPC and full recovery of embezzled funds.
Context: The Managing Director of a fast-moving consumer goods company required an hourly executive dashboard showing regional sales across 4 distribution hubs without disturbing billing operators.
Solution: Configured Tally Prime as an ODBC Server on port 9000. Built a dynamic Microsoft Excel Power Query model linking to Tally via ODBC. The dashboard automatically refreshes every 30 minutes, pulling live sales totals, gross profit margins, and bank cash balances, eliminating manual report preparation entirely.
7. Calicut University Academic Examination Bank
Exhaustively curated for Calicut University B.Com Semester VI Elective: Computer Applications — COM6EJ308(4): Computerized Accounting with Tally (CUFYUGP 2024 Regulations). Specially formatted for superior academic performance.
Tally Vault is an advanced data encryption security feature in Tally that encrypts the entire company database files on the hard drive using standard cryptographic algorithms (DES/AES) and conceals the company name into asterisks (
*****) on the company selection screen.
Under MCA rules, corporate accounting software must maintain an immutable edit log tracking every transaction modification. Tally Prime complies via its Edit Log feature, permanently recording the date, time, user identity, and exact before-and-after values of any altered or deleted voucher.
Splitting divides a multi-year company database into two distinct, independent financial year company files. It is executed at the close of a financial year (e.g., 31st March) to optimize software speed and maintain uncorrupted historical records.
ODBC stands for Open Database Connectivity. It allows external applications (such as Microsoft Excel, Access, or SQL Server) to establish a live dynamic link with Tally's database, extracting real-time financial data for executive dashboards without manual file exports.
A Tally backup file carries the extension .tbk (e.g.,
TBK900_10001.001). It is restored by navigating to Alt+Y (Data) → Restore, specifying the backup destination path, and selecting the company archive.
Tally.NET is an encrypted cloud framework and subscription service provided by Tally Solutions.
Services: (1) Secure remote browser-based access to financial reports on mobile devices; (2) Two-way multi-branch data synchronization over the internet.
XML (Extensible Markup Language) uses standardized semantic tags (e.g.,
<LEDGER>, <AMOUNT>) that Tally's parser understands natively, allowing automated programmatic import of bulk invoices and master ledgers from e-commerce portals.
Architecture of Tally Audit & Edit Log:
The Tally Audit and Edit Log suite operates as an automated digital forensic watchdog running continuously beneath transaction processing.
Operational Features:
1. Immutable Timestamping: Every voucher creation, modification, or cancellation is stamped with the exact date, time, and active user login ID.
2. Version Comparison: Under
Display → Edit Log, auditors view a side-by-side comparison highlighting all altered fields in red (e.g., altered voucher amounts, changed ledger accounts, or modified bank dates).3. Audit Verification Module: Allows statutory auditors to mark vouchers as "Verified", attach audit observations, and track backdated vouchers entered after the financial year-end.
Prevention of Fraud: Eliminates the traditional practice of dishonest staff altering cash sales records after customer departure, deterring embezzlement and ensuring compliance with Ministry of Corporate Affairs audit trail mandates.
1. Data Backup Procedure:
• Press
Alt+Y (Data) → Backup.• Specify the Backup Destination Path (e.g., external drive
E:TallyBackups).• Select the company from the list and select End of List. Tally compresses and writes the
.tbk archive file.2. Data Restore Procedure:
• Press
Alt+Y (Data) → Restore.• Select the Restore Destination Path and locate the source
.tbk file.• Select the company archive to restore. Tally extracts the data into a functional 5-digit folder.
3. Splitting Financial Year Data:
• Navigate to
Alt+Y → Split → Verify Company Data to resolve any unadjusted bills.• Click
Split Company Data, select Split Date (e.g., 01-04-2024), and confirm.• Tally splits the multi-year database into two clean files: historical pre-split books and active post-split books with carried forward opening balances.
Mechanics of ODBC Interfacing:
ODBC provides a standard application programming interface (API) that enables external client programs to access Tally's database as if it were a standard SQL relational database.
Configuration & Connection Workflow:
1. Under Tally Configuration, set "Tally is Acting as: Both / Server" and assign port
9000.2. In Microsoft Excel, open
Data → Get Data → From Other Sources → From ODBC → Select TallyODBC_9000.3. Excel queries Tally's internal tables (such as
Ledger, Company, Voucher, StockItem).Corporate Reporting Example:
A Chief Financial Officer builds an automated dynamic liquidity dashboard in MS-Excel. By executing the query:
SELECT ClosingBalance FROM Ledger WHERE $Parent = 'Bank Accounts', Excel pulls live closing balances from Tally. Whenever cheques are entered in Tally, clicking Refresh Data in Excel updates the executive cash dashboard instantly without manual re-typing.
1. Introduction & The Technological Imperative:
In contemporary corporate finance, accounting software is not merely a record-keeper; it is the legal and financial repository of the firm. Tally Prime's technological superiority lies in its proprietary non-relational C++ database engine, which delivers lightning-fast processing, zero external software dependencies, and dynamic fail-safe recovery.
2. Forensic Governance & The Statutory Edit Log:
• Under Companies Act mandates, Tally's Edit Log provides complete transaction immutability: recording creator identity, alteration timestamps, and historical values.
• Eliminates management override of internal controls, protecting minority shareholders and creditors from falsified financial statements.
3. Cryptographic Data Security via Tally Vault:
• Deploys symmetric cryptographic algorithms (DES/AES) to encrypt physical data files on disk.
• Conceals company names on the selection screen, neutralizing corporate espionage and physical hard drive theft.
• Granular User Access Controls (UAC) enforce segregation of duties between billing clerks and management.
4. Enterprise Interoperability & Distributed Synchronization:
• ODBC Live Pipelines: Connects live Tally ledgers to advanced analytical business intelligence tools (Excel, Power BI, Python).
• Multi-Branch Synchronization: Replicates transactions across geographically dispersed retail showrooms and central warehouses in real time via encrypted Tally.NET tunnels.
• Mobile Browser Reporting: Enables executive decision-making on smartphones anywhere in the world.
5. Conclusion:
By fusing robust database engineering with military-grade encryption and forensic audit trails, Tally Prime delivers a resilient technological platform safeguarding modern corporate integrity.
(b) Case Scenario: A wholesale trading company with 6 years of accumulated transaction data in a single company file experiences severe software slowdowns. Detail the complete procedure to: (1) Audit and verify data integrity; (2) Execute a Financial Year Split as on 1st April 2024; (3) Verify opening balances in the post-split company; (4) Safely archive the historical pre-split database.
Part (a): Enterprise Tally Security & Disaster Recovery Policy:
• 1. Tally Vault Cryptographic Implementation:
All branch and head office companies must activate Tally Vault. The Vault Password must be generated using high-entropy 16-character alphanumeric combinations, stored in the company's secure digital password vault, and known exclusively to the Managing Director and CFO. Folder names appear as
***** on screen.• 2. Granular Role-Based Access Controls (UAC):
• Store Cashiers: Assigned role "Data Entry". Permitted: Passing F8 Sales (Item Invoice) and F6 Cash Receipts. Blocked: Viewing Balance Sheet, P&L Account, Stock Valuation Rates, and entering vouchers backdated beyond 24 hours.
• Branch Managers: Assigned role "Branch Manager". Permitted: Passing purchase vouchers, approving credit limits, viewing Stock Summary, and generating Day Books. Blocked: Altering F11 Features, creating new security users, or modifying historical vouchers.
• Chief Accountant & CFO: Assigned role "Owner". Unrestricted access, managing Tally Audit verification, bank reconciliation, and year-end closing journals.
• 3. The 3-2-1 Automated Backup Rotation Schedule:
• 3 Copies of Data: (1) Primary active data on server; (2) Local secondary backup; (3) Off-site cloud backup.
• 2 Different Media: Stored on internal high-speed NVMe drives and external encrypted USB SSDs.
• 1 Off-Site Cloud Location: At 8:00 PM daily, an automated script executes Tally Backup (
.tbk) and uploads the archive to an encrypted AWS S3 cloud bucket with 30-day versioning.Part (b): Step-by-Step Financial Year Split & Archival Protocol:
• Step 1: Data Integrity Audit & Pre-Split Checks:
1. Navigate to
Alt+Y (Data) → Split → Verify Company Data.2. Tally scans the database for errors (un-reconciled bank entries, pending bill references, negative stock quantities). The accountant resolves all flagged exceptions.
3. Take a complete master backup of the undivided 6-year company file to an external hard drive (
Master_Archive_PreSplit.tbk).• Step 2: Executing Financial Year Split as on 1st April 2024:
1. Navigate to
Alt+Y → Split → Split Company Data.2. Select Company Name → Set Split From:
01-Apr-2024.3. Confirm the split. Tally processes transactions and creates two new distinct companies: "Apex Wholesale (from 1-Apr-2018)" and "Apex Wholesale (from 1-Apr-2024)".
• Step 3: Verification of Post-Split Opening Balances:
1. Open the new company: "Apex Wholesale (from 1-Apr-2024)".
2. Open
Gateway of Tally → Balance Sheet and Trial Balance.3. Cross-verify every group total (Capital, Sundry Debtors, Sundry Creditors, Bank Accounts, Closing Stock) against the closing balance sheet of the pre-split company as on 31st March 2024. Confirm that the Difference in Opening Balances is exactly zero.
• Step 4: Historical Database Archival:
Rename the historical pre-split company to "Apex Wholesale [ARCHIVE - READ ONLY up to Mar 2024]". Alter user security to revoke all editing permissions, converting it into a permanent, read-only digital archive for tax audit inspections.
Calicut University FYUGP Academic Framework
Syllabus details for BCom Semester 6 under official Calicut University regulations.
Assessment comprises a 70-mark End-Semester Examination (2 Hours) and 30-mark Continuous Internal Evaluation.
About E-Commerce & Digital Marketing (Calicut University BCom Sem 6)
E-Commerce & Digital Marketing (COM6EJ308 • 4 Credits • 60 Hours) constitutes an essential academic pillar of the Bachelor of Commerce curriculum under the University of Calicut Four-Year Undergraduate Programme (CUFYUGP Regulations 2024 / 2025). The course delivers comprehensive instruction in core commercial theories, statutory regulatory environments, and practical corporate workflows. Undergraduates transition from introductory commercial overviews to rigorous operational analysis, examining how modern financial enterprises, commercial establishments, and regulatory authorities formulate policies, ensure statutory compliance, and optimize resource allocations. The curriculum integrates historical administrative and financial doctrines with contemporary market realities, exploring quantitative modeling, legal jurisprudence, and computerized financial reporting systems. Through structured case studies, problem-solving workouts, and theoretical evaluations, scholars cultivate the analytical competence required for corporate accounting, financial consultancy, banking services, and higher research in commerce. The subject is evaluated under a 100-mark assessment model consisting of Continuous Internal Evaluation (30 Marks) and the university End-Semester Examination (70 Marks).
E-Commerce & Digital Marketing Module-by-Module Curriculum Breakdown
Official syllabus unit modules prescribed by the Calicut University FYUGP framework:
Theoretical Foundations & Principles
Examines the core principles and analytical methods of Theoretical Foundations & Principles in E-Commerce & Digital Marketing (COM6EJ308). Key areas of study encompass E-commerce foundations: architectural frameworks, revenue models (subscription, marketplace, dropshipping), and digital transformation; E-commerce business models: B2B electronic marketplaces, B2C online retail, D2C brand ecosystems, and C2C platforms, focusing on conceptual rigor, practical business applications, and institutional procedures under the Calicut University curriculum. Students master quantitative calculations, procedural documentation, and theoretical models essential for scoring high marks in university end-semester evaluations.
Operational Frameworks & Methodologies
Examines the core principles and analytical methods of Operational Frameworks & Methodologies in E-Commerce & Digital Marketing (COM6EJ308). Key areas of study encompass Digital payment infrastructure: payment gateways, UPI, net banking, mobile wallets, and card tokenization protocols; Digital retail supply chains: automated warehousing, fulfillment centers, drop-shipping, and last-mile logistics, focusing on conceptual rigor, practical business applications, and institutional procedures under the Calicut University curriculum. Students master quantitative calculations, procedural documentation, and theoretical models essential for scoring high marks in university end-semester evaluations.
Regulatory Compliance & Quantitative Analysis
Examines the core principles and analytical methods of Regulatory Compliance & Quantitative Analysis in E-Commerce & Digital Marketing (COM6EJ308). Key areas of study encompass Search Engine Optimization (SEO): keyword research, on-page optimization (meta tags, headers), and off-page backlink building; Search Engine Marketing (SEM): Google Ads auction mechanics, Quality Score, CPC bidding, and ad copy optimization, focusing on conceptual rigor, practical business applications, and institutional procedures under the Calicut University curriculum. Students master quantitative calculations, procedural documentation, and theoretical models essential for scoring high marks in university end-semester evaluations.
Strategic Applications & Contemporary Trends
Examines the core principles and analytical methods of Strategic Applications & Contemporary Trends in E-Commerce & Digital Marketing (COM6EJ308). Key areas of study encompass Social Media Marketing (SMM): content strategies, organic community building, influencer marketing, and paid performance ads; Email marketing workflows: subscriber segmentation, automated lead nurturing, open rates, and click-through rates (CTR), focusing on conceptual rigor, practical business applications, and institutional procedures under the Calicut University curriculum. Students master quantitative calculations, procedural documentation, and theoretical models essential for scoring high marks in university end-semester evaluations.
Core Curriculum & Key Topics
- E-commerce foundations: architectural frameworks, revenue models (subscription, marketplace, dropshipping), and digital transformation
- E-commerce business models: B2B electronic marketplaces, B2C online retail, D2C brand ecosystems, and C2C platforms
- Digital payment infrastructure: payment gateways, UPI, net banking, mobile wallets, and card tokenization protocols
- Digital retail supply chains: automated warehousing, fulfillment centers, drop-shipping, and last-mile logistics
- Search Engine Optimization (SEO): keyword research, on-page optimization (meta tags, headers), and off-page backlink building
- Search Engine Marketing (SEM): Google Ads auction mechanics, Quality Score, CPC bidding, and ad copy optimization
- Social Media Marketing (SMM): content strategies, organic community building, influencer marketing, and paid performance ads
- Email marketing workflows: subscriber segmentation, automated lead nurturing, open rates, and click-through rates (CTR)
- Web analytics and conversion optimization: Google Analytics 4 (GA4), funnel analysis, bounce rates, and Return on Ad Spend (ROAS)
- Legal and regulatory compliance: IT Act 2000, e-commerce consumer protection rules, and Digital Personal Data Protection Act 2023
Learning Outcomes
- Evaluate digital commercial business models and design scalable online marketplace architectures.
- Integrate secure digital payment gateway workflows complying with RBI tokenization directives.
- Execute on-page and technical SEO audits to enhance organic search engine visibility.
- Formulate paid search ad campaigns utilizing Quality Score optimizations and cost-per-click bidding.
- Design targeted social media and email marketing nurturing funnels to maximize customer retention.
- Analyze digital campaign performance metrics (CTR, CPA, ROAS) using web analytics dashboards.
Calicut University Examination Scheme for E-Commerce & Digital Marketing
The evaluation framework for E-Commerce & Digital Marketing (COM6EJ308) under Calicut University FYUGP regulations combines Continuous Internal Evaluation (30 Marks) with the university End-Semester Examination (70 Marks) for a total of 100 Marks (2 Hours duration):
10 Questions × 3 Marks (Maximum ceiling 24 Marks). Short definitional and conceptual questions covering all 4 syllabus modules.
8 Questions × 6 Marks (Maximum ceiling 36 Marks). Paragraph questions, comparative evaluations, and analytical problems.
2 Questions × 10 Marks (Answer any 1 for 10 Marks). Long-form essay or comprehensive numerical workout problem.
Exam Preparation Strategy:
Under Calicut University FYUGP regulations, the end-semester theory examination for E-Commerce & Digital Marketing (COM6EJ308) carries 70 Marks (2 or 2.5 hours duration) evaluated across three structured sections: Part A Conceptual Definitions (Short Answers): Prepare concise, textbook-precise definitions for core terminology, statutory clauses, and operational metrics. Write 2 to 3 focused sentences for each prompt and provide one clear illustrative example. Avoid conversational phrasing. Part B Analytical Paragraphs (Models & Typologies): Focus on structured comparative explanations, classification typologies, and step-by-step procedures. Structure responses with numbered subheadings, draw labeled diagrams where applicable, and construct comparative tables with explicit basis-of-distinction columns. Part C Comprehensive Essays & Workout Problems: Follow a formal five-part structure: (1) Conceptual Introduction & Scope, (2) Detailed Theoretical Exposition or Step-by-Step Numerical Computation, (3) Labeled Schematic Diagram or Accounting Ledger Accounts, (4) Statutory / Practical Industry Evaluation, and (5) Concluding Managerial Appraisal. Ensure all ledger balances or formula substitutions are neatly highlighted with double underlines.
Exam Preparation & Study Guides — E-Commerce & Digital Marketing
What components determine Google Ads Quality Score and why does it matter to commercial advertisers?
Quality Score (rated 1 to 10) is determined by Expected Click-Through Rate (eCTR), Ad Relevance, and Landing Page Experience. A higher Quality Score lowers the effective Cost Per Click (CPC) and earns higher ad ranking positions without requiring higher monetary bids, maximizing marketing return on investment.
What is the difference between On-Page SEO and Off-Page SEO?
On-page SEO involves optimizing elements directly within the website's control, such as keyword-optimized titles, meta descriptions, header hierarchy, URL architecture, and page loading speed. Off-page SEO focuses on external authority-building activities outside the website, primarily acquiring high-quality backlinks from reputable domains, brand mentions, and social signals.
How does the Dropshipping business model operate in modern e-commerce?
In dropshipping, the online retailer sells products to consumers without stocking or owning physical inventory. When a customer places an order on the retailer's website, the retailer purchases the item from a third-party manufacturer or wholesaler, who ships the product directly to the customer, allowing the retailer to profit from the retail-wholesale price difference with zero warehouse overhead.
What core rights does the Digital Personal Data Protection Act 2023 grant to online consumers in India?
The DPDP Act 2023 grants digital data principals: the Right to Access information about personal data processed; the Right to Correction and Erasure of outdated or inaccurate personal data; the Right to Grievance Redressal; and the Right to Nominate a representative in the event of death or incapacity, while imposing steep penalties on data fiduciaries for data breaches.
Course outlines and study notes follow official Calicut University curricula. Curated by Fayiz (Wayanad).
For feedback or corrections, contact support@degreelive.in.
Related Study Resources & Student Support
Related Semester 6 Subjects
Browse study notes for other courses in BCom Sem 6:
Financial Aid & Grants 2026-27
Check eligibility criteria and deadlines for Kerala government and merit scholarships (e-Grantz 3.0, KSHEC, DCE).
Request Notes
Can't find what you're looking for? Let us know which subject notes you need.