In an era characterized by exponential transaction velocity, real-time supply chain integration, and rigorous statutory compliance frameworks (such as Goods and Services Tax [GST], electronic invoicing, and mandatory audit trails), manual accounting systems have become obsolete. Contemporary commerce relies on computerized Accounting Information Systems (AIS) to maintain financial records, enforce internal controls, generate statutory tax filings, and provide executive decision-makers with instantaneous fiscal intelligence. Module I establishes the foundational theoretical, architectural, and operational principles of accounting software applications, examining the structural differences between manual and electronic accounting, classifying commercial software packages, analyzing strategic selection determinants, and outlining rigorous procurement, licensing, and installation methodologies.
UNIT 1: BASICS OF ACCOUNTING SOFTWARE APPLICATIONS
An Accounting Information System (AIS) is an integrated computer-based structure that collects, stores, processes, and transforms raw financial and transactional data into actionable financial statements, statutory tax filings, and managerial cost accounting reports. Computerized accounting software operationalizes double-entry bookkeeping rules through automated relational database management systems (RDBMS) and proprietary multi-dimensional data engines.
1. Foundational Architecture: Manual vs Computerized Accounting
While both manual and computerized systems adhere to the identical foundational accounting equation (Assets = Liabilities + Equity) and double-entry conventions (every debit must equal an equivalent credit), their underlying operational mechanisms differ fundamentally across data entry, ledger posting, trial balance extraction, and reporting velocity.
Processing Paradigm: Manual vs Computerized WorkflowsWORKFLOW ARCHITECTURE
Single-Point Data Ingestion: In a computerized system, an operator enters transaction parameters only once via an electronic voucher. The software's database engine automatically updates the General Ledger, Subsidiary Ledgers, Stock Ledgers, Tax Registers, and Cash/Bank books simultaneously.
Zero Arithmetic Posting Error: In manual bookkeeping, copying totals from subsidiary day books to general ledgers introduces frequent arithmetic and transposition errors. Software completely eliminates posting errors and casting discrepancies.
Continuous Real-Time Trial Balance: In manual accounting, balancing the trial balance is an exhaustive monthly or annual milestone. In computerized systems, the Trial Balance, Balance Sheet, and Profit & Loss Account are dynamically balanced and available at any second.
2. Comprehensive Comparative Analysis
Dimension
Manual Accounting System
Computerized Accounting Software
Recording & Input
Manual handwriting of transactions across journal books, cash books, and subsidiary purchase/sales day books.
Single-screen voucher entry with pre-configured dropdowns, auto-complete ledger names, and automated tax calculations.
Ledger Posting
Labor-intensive manual posting of debit and credit entries to individual ledger T-accounts.
Instantaneous, automated database distribution across all affected balance sheet and income statement accounts.
Speed & Velocity
Slow; days or weeks required to aggregate period-end totals and close books of account.
Real-time; reports, ratios, and multi-year comparative statements generate in fractions of a second.
Mathematical Accuracy
Highly prone to human calculation errors, casting errors, and transcription mistakes.
3. Enterprise Advantages of Computerized Accounting
The adoption of accounting software confers substantial strategic and operational dividends:
Instantaneous Management Information System (MIS) Reporting: Executive leadership can access real-time dashboards displaying gross margins, cash balances, aged debtors, and inventory turnover without waiting for month-end reconciliation.
Scalability: A computerized ledger handles thousands of daily transactions without requiring linear expansion in clerical headcount.
Frictionless Statutory Compliance: Pre-configured statutory engines automatically generate GST returns (GSTR-1, GSTR-3B), e-Way bills, and e-Invoices compliant with Goods and Services Tax Network (GSTN) APIs.
Bank Reconciliation Automation: Electronic bank statement imports (in Excel/CSV/XML formats) enable automated rule-based reconciliation against internal bank ledgers in minutes.
4. Internal Control Environment & Fraud Prevention in Accounting Software
Modern accounting software implements rigorous internal control mechanisms designed to prevent commercial fraud, embezzlement, and unauthorized data tampering:
Segregation of Duties (SoD): The principle that no single individual should have end-to-end control over a financial transaction. Software enforces role-based access control (RBAC), ensuring that a billing clerk who creates a sales invoice cannot authorize cash disbursements or approve write-offs.
Maker-Checker Authorization Workflows: Junior accountants ("Makers") input voucher records into an unapproved pending state; senior financial controllers ("Checkers") review supporting digital documents and formally authorize the entry before it posts to the general ledger.
Two-Factor Authentication (2FA) & Session Timeouts: Access requires combining user credentials with dynamic mobile OTPs, automatically terminating inactive user sessions to prevent unauthorized terminal access in open offices.
Mandatory Audit Trail (Edit Log): Statutory mandates (such as India's MCA notification under the Companies Act) require software to maintain an unalterable log recording every transaction modification, displaying the original value, altered value, operating system user ID, and timestamp.
5. Operational Risks and Inherent Limitations
Despite overwhelming advantages, organizations must manage critical technological vulnerabilities:
1. Hardware Failure & Data Corruption: Catastrophic server hard drive crashes, power surges, or filesystem corruption can instantly obliterate years of financial ledgers unless structured daily automated backup protocols are strictly enforced.
2. Cybersecurity & Ransomware Threats: Accounting databases are prime targets for malicious external attacks, phishing, and ransomware encryption. Organizations require firewalls, VPN tunnels, and encrypted off-site cloud mirrors to protect corporate solvency.
3. The "Garbage In, Garbage Out" (GIGO) Risk: Computerized software processes input without moral or contextual discernment. If a data entry operator assigns an expense voucher to the wrong ledger account or types an incorrect quantity, the system generates flawed financial statements with flawless arithmetic.
4. High Total Cost of Ownership (TCO): Deploying professional accounting software entails recurring subscription fees, annual maintenance contracts (AMC), dedicated server hardware, continuous operator training, and expensive data migration consultants.
UNIT 2: OVERVIEW OF ACCOUNTING SOFTWARE PACKAGES & SELECTION DETERMINANTS
The commercial software market offers diverse accounting platforms tailored to specific enterprise scales, organizational structures, regulatory jurisdictions, and industry verticals. Business managers must evaluate these packages systematically to align organizational requirements with technological capabilities.
1. Classification of Accounting Software Packages
1. Ready-to-Use / Off-the-Shelf: Mass-market commercial software designed with pre-configured standard chart of accounts, statutory tax rules, and standard invoice layouts.
Leading Examples: Tally Prime, QuickBooks Online, Busy Accounting, Zoho Books.
Best For: Small and medium-sized enterprises (SMEs) requiring rapid deployment, low initial acquisition cost, and standard compliance.
2. Customized Software: Standard off-the-shelf software modified through specialized programming add-ons or custom modules to meet unique industry workflows.
Industry Customizations: POS retail scanning modules, school fee management, pharmacy batch/expiry tracking, hotel billing.
Best For: Mid-market businesses whose operational flows deviate moderately from standard retail or trading norms.
3. Tailor-Made / Bespoke ERP: Comprehensive enterprise systems engineered from the ground up to match the exact structural hierarchy of large corporate groups.
Leading Examples: SAP S/4HANA, Oracle NetSuite, Microsoft Dynamics 365.
Best For: Large multinational corporations, complex multi-plant manufacturers, and heavily regulated banking institutions.
2. Comparative Landscape of Leading Accounting Software Packages
A critical comparative evaluation of dominant packages in the Indian and global business ecosystem:
Software Package
Target Market & Architecture
Distinctive Operational Capabilities
Key Constraints / Limitations
Tally Prime (Tally Solutions)
Indian SMEs & Mid-market; Desktop-centric with LAN multi-user and remote access.
Deep batch/serial tracking, barcode printing, multi-unit packaging, scheme/discount management for wholesale distributors.
Limited brand recognition outside South Asia; dated user interface design.
QuickBooks Online (Intuit)
Global micro-enterprises & service businesses; Cloud SaaS.
Intuitive invoicing, receipt photo capture via mobile app, global currency conversion, extensive third-party app integrations.
Withdrew localized Indian business operations in 2023; strictly global international reporting focus.
SAP Business One (SAP SE)
Upper Mid-Market & Large Enterprises; Comprehensive ERP.
End-to-end supply chain integration, multi-plant production scheduling, MRP II calculation, multi-national consolidation.
Prohibitive licensing cost; complex multi-month implementation; requires specialized SAP consultants.
3. Cloud-Native Accounting vs On-Premise Desktop Solutions
IT leaders face a strategic choice between on-premise control and cloud flexibility:
On-Premise Desktop Architecture (e.g., Tally Prime):Core Strategic Merits: • 100% Offline Operational Autonomy: Continues executing retail billing and invoicing during internet service provider (ISP) outages.
• Absolute Data Sovereignty: Financial databases reside physically on internal office hard drives, satisfying strict internal security policies.
• One-Time Capital Expenditure: Perpetual license models eliminate recurring monthly per-user billing overhead.
Cloud-Native SaaS Architecture (e.g., Zoho Books):Core Strategic Merits: • Omnipresent Executive Mobility: Business owners approve purchase orders and inspect cash flows from mobile devices anywhere in the world.
• Automated Cloud Backups: Eliminates manual tape or hard drive backups; cloud vendors maintain geo-redundant data centers.
• Instant Bank Telemetry: Direct bank API integrations match bank statements with general ledger transactions in real time.
4. Strategic Factors Affecting the Selection of Accounting Software
Procuring an accounting system is a major capital commitment that impacts organizational performance for years. Executive leadership must evaluate six core determinants:
1. Organizational Scale & Transaction Volume: A micro-retailer processing 20 daily transactions requires an accessible tool like Zoho Books or basic Tally; a distributor processing 10,000 daily line items requires multi-core database engines (Tally Prime Server or SAP Business One).
2. Nature of Commercial Operations: Service consulting firms prioritize project billing and timesheet tracking; trading enterprises demand multi-godown batch inventory; manufacturing entities mandate multi-stage Bill of Materials (BOM) and job-costing engines.
3. Statutory Compliance Capabilities: In India, the software must natively support GST rate slabs (0%, 5%, 12%, 18%, 28%), reverse charge mechanisms, TDS/TCS section limits, and the Ministry of Corporate Affairs (MCA) mandate for immutable Audit Trail (Edit Log) logging every transaction alteration.
4. User Friendliness & Talent Availability: The software must match the skill level of available accounting staff. Tally enjoys unmatched popularity across India, ensuring businesses can easily recruit certified operators.
5. Integration Capabilities: Ability to exchange data seamlessly via APIs, ODBC, Excel import/export, and banking portal payment gateways.
6. Total Cost of Ownership (TCO): Factoring in software licenses, annual renewal costs, hardware infrastructure upgrades, data migration fees, and ongoing staff training expenses.
UNIT 3: PROCUREMENT AND INSTALLATION OF COMPUTERISED ACCOUNTING SOFTWARE
Procuring and commissioning accounting software demands rigorous project management. A flawed installation or corrupted configuration can halt corporate invoicing, delay payroll, and jeopardize tax compliance.
1. The Software Procurement Lifecycle
Enterprises follow a structured five-stage acquisition protocol:
Stage 1: Business Requirements Specification (BRS): Documenting operational pain points, required reporting outputs, concurrent user counts, and statutory compliance needs across departments.
Stage 2: Vendor Benchmarking & RFP: Issuing Requests for Proposal (RFP), evaluating vendor market track records, conducting live proof-of-concept demonstrations, and verifying client references.
Stage 3: Licensing Model Selection: Choosing between Perpetual Licenses (ownership of specific software version) versus Subscription Models (ongoing access with automated cloud updates included). In Tally Prime, businesses evaluate:
• Silver Edition: Single-user standalone license for small offices.
• Gold Edition: Unlimited multi-user license across a local area network (LAN) for growing teams.
• Tally.Server 9: Enterprise-grade data concurrency engine eliminating database locks during heavy multi-user data entry.
Stage 4: Pilot Testing & Data Migration: Running legacy manual records and the new software concurrently (parallel run) for 30 to 60 days to verify that closing balances match to the exact rupee before full switchover.
Stage 5: Go-Live, User Training & Sign-Off: Transitioning fully to digital voucher entry and archiving legacy records.
2. Hardware & Software Prerequisites for Deployment
Ensuring system stability requires meeting verified technical specifications:
Operating System: 64-bit architecture (Windows 10, Windows 11, or Windows Server 2016/2019/2022). Modern accounting packages no longer support 32-bit operating systems.
Processor (CPU): 1.8 GHz or faster multi-core 64-bit x86/x64 architecture (Intel Core i3/i5/i7 or AMD Ryzen).
System Memory (RAM): Minimum 4 GB for basic single-user setups; 8 GB to 16 GB recommended for high-volume multi-user network servers.
Storage: Solid State Drive (SSD) with at least 1 GB free space for program files and dedicated high-speed partitions for the company database directory.
Network Architecture: 1 Gbps Ethernet local area network (LAN) with static IP addressing for server installations running multi-user accounting.
3. Step-by-Step Installation Protocol (Benchmarked on Tally Prime)
The standard commissioning workflow follows strict procedural steps:
Step 1: Downloading the Verified Installer: Download the official setup.exe executable installer directly from the authenticated vendor portal (e.g., tallysolutions.com) to prevent malware insertion.
Step 2: Segregation of Application and Data Paths (Critical Best Practice): During setup wizard execution, specify distinct physical disk paths:
• Application Path: Where software executables and DLLs reside (e.g., C:Program FilesTallyPrime).
• Data Path: Where live company databases are stored (e.g., D:TallyData).
Architectural Rationale: Segregating data to Drive D prevents accidental erasure of company accounting records during operating system reinstallation or software version updates on Drive C.
Step 3: License Activation & Modes of Operation: Upon initial launch, the startup screen presents four operational pathways:
• Try It For Free (Educational Mode): Complete functional software access provided free of charge for student learning, with a single statutory restriction: date entry is restricted strictly to the 1st, 2nd, and 31st calendar days of any month.
• Activate New License: Requires inputting the 9-digit Serial Number, 16-digit Activation Key, and registered Administrator Account Email ID.
• Reactivate Existing License: Unlocks licensed access following hardware upgrades or system transfers.
• Select Existing Network License: Automatically searches the local area network to connect client PCs to a central multi-user Gold License Server.
Step 4: Network & Firewall Exclusion Configuration: For multi-user installations, configure Windows Defender Firewall to allow inbound connections on port 9000 (Tally's default data communication port) and whitelist the executable path to prevent network disconnects.
Step 5: Database Backup Configuration: Establish scheduled automated daily backups targeting external secondary storage media or encrypted cloud repositories, verifying disaster recovery readiness before entering live corporate records.
4. Data Migration & Cut-Over Strategy
Transitioning from manual books or an older accounting system to a new computerized platform requires a structured cut-over strategy:
Establishing the Cut-Over Date: The optimal date to transition is the commencement of a new financial year (e.g., April 1st in India), eliminating the need to transfer historical transaction-level details. If cut-over occurs mid-year, cumulative trial balances as of the cut-off date must be migrated.
Chart of Accounts Standardisation: Auditing and rationalizing all legacy ledger accounts, eliminating redundant ledgers, and grouping accounts into appropriate statutory categories (Sundry Debtors, Sundry Creditors, Indirect Expenses).
Entering Opening Balances: Inputting audited opening balances for all balance sheet accounts into the software. The system generates a balancing figure ("Opening Balance Difference"); this difference must resolve exactly to zero to ensure accounting integrity.
Physical Inventory Verification: Conducting a complete physical stock-take on the eve of the cut-over date to establish exact opening inventory quantities and valuations (FIFO or Weighted Average) in the new system.
ENTERPRISE CASE BENCHMARK: THE COST OF FLAWED SOFTWARE COMMISSIONING
The Hardware-Application Path Confusion Incident: A mid-sized textile export firm in Tirupur, Tamil Nadu, commissioned computerized accounting software without professional systems oversight. The internal IT technician installed the application and allowed the data path to default directly inside C:Program FilesAccountingSoftwareData. Twelve months later, following an operating system crash, an external hardware technician performed a fresh clean installation of Windows on Drive C, inadvertently formatting the drive and completely destroying the un-backed-up accounting ledgers of 140 export clients.
The Lesson: Professional systems standards mandate: (1) Absolute physical segregation of the live Data Directory to secondary non-OS partitions, (2) Automated 3-2-1 backup policies (3 copies of data, 2 different media types, 1 off-site cloud copy), and (3) Routine disaster recovery mock drills verifying that archived backup files restore successfully.
Module I Comprehensive Mastery SummaryEXECUTIVE SUMMARY
Prevents costly software procurement mismatches and compliance failures.
Installation & Migration
Application vs Data path segregation, firewall port 9000, 3-2-1 backups.
Guarantees permanent data sovereignty and disaster recovery resilience.
Accounting Software Applications
Course Code: COM5FS112 (2) • Module 2 Notes
MODULE II: COMPANY CREATION AND ACCOUNTING MASTERS
MODULE OVERVIEW & OPERATIONAL CONTEXT
The operational heart of any computerized accounting system lies in the precision of its master configuration and voucher recording mechanisms. In business environments powered by software like Tally Prime, setting up an enterprise demands establishing the legal company entity, architecting a structured chart of accounts via hierarchical Groups and Ledgers, mastering the specialized taxonomy of accounting vouchers, configuring core company features (F11) and screen-level parameters (F12), conducting Bank Reconciliation Statements (BRS), and managing automated payroll processing. Module II delivers an exhaustive, textbook-depth technical guide to company creation, accounting masters, and transactional voucher workflows.
UNIT 4: COMPANY CREATION & ACCOUNTS GROUPS
In accounting software architecture, a Company represents the highest-level independent corporate entity containing a distinct chart of accounts, transaction ledgers, inventory masters, and statutory tax parameters. A single installation of Tally Prime can host thousands of distinct company files, each maintaining isolated financial books.
1. Step-by-Step Company Creation Protocol
Company creation initializes the underlying database schema. From the Gateway of Tally, navigating to Alt + K (Company) → Create opens the primary configuration screen:
1. Company Identification Fields: • Company Name: The statutory legal name of the enterprise (e.g., Malabar Consumer Goods Private Limited).
• Mailing Name & Address: The trade name and physical address printed automatically on sales invoices, tax debit notes, and formal customer correspondence.
• State, Country & Pincode: Critical statutory fields. Selecting the state (e.g., Kerala) defines the local Goods and Services Tax (GST) jurisdiction, automatically determining whether transactions evaluate as Intra-State (CGST + SGST) or Inter-State (IGST).
2. Financial Year and Books Beginning Architecture: • Financial Year Beginning From: The statutory commencement of the fiscal period (in India, strictly 01-04-2025 for FY 2025–26).
• Books Beginning From: The exact date the enterprise physically started recording digital accounting transactions. For a newly incorporated business founded on October 1st, Financial Year begins 01-04-2025 while Books Begin from 01-10-2025. Transactions prior to Books Beginning are strictly rejected by the database.
3. Security Control & TallyVault Encryption: • Enable TallyVault Password: Applies proprietary zero-knowledge encryption to the company folder on the hard disk. The folder name on disk is scrambled into a 5-digit numerical code (e.g., 10001, 10002), concealing company identity from Windows File Explorer. If the TallyVault password is lost, data recovery is mathematically impossible.
• Enable User Access Control (Security Control): Establishes administrative credentials (Username and Password) and activates Role-Based Access Control (RBAC), enabling the administrator to configure restricted logins for billing operators and auditors.
4. Base Currency Information: Configures the primary reporting currency: Base Currency Symbol (₹), Formal Name (INR), Decimal Places (2), Word representing decimal (Paise), and spacing conventions.
2. Company Lifecycle Operations: Select, Shut, Alter, and Delete
Operation
Shortcut Key
Operational Mechanics & Business Rules
Select Company
Alt + F3
Opens the company selection index, displaying company numbers, financial year spans, and encryption statuses to load a company into active memory.
Shut (Close) Company
Ctrl + F3
Unloads the active company from system RAM without deleting any files, returning the software to the startup selection menu.
Alter Company
Alt + K → Alter
Allows administrators to update telephone numbers, corporate address, email, or statutory tax settings. (Books Beginning date cannot be altered if vouchers exist).
Delete Company
Alt + D (in Alter screen)
Permanently purges the company database from the physical hard drive. Prompts for double confirmation ("Delete?" and "Are you sure?"). Irreversible unless external backups exist.
3. Chart of Accounts: The 28 Predefined Groups in Tally
An Account Group is a categorical collection of related ledger accounts sharing identical financial characteristics. Groups establish the fundamental structural taxonomy of the Balance Sheet and Profit & Loss Account. Tally Prime provides exactly 28 Predefined Groups organized into two structural tiers:
Taxonomy of Predefined Accounting Groups (15 Primary + 13 Sub-Groups)CHART OF ACCOUNTS
2. The 13 Sub-Groups (Pre-Classified Under Primary Groups):
Under Capital Account: Reserves & Surplus.
Under Loans (Liability): Bank OD / OCC, Secured Loans, Unsecured Loans.
Under Current Liabilities: Duties & Taxes, Provisions, Sundry Creditors.
Under Current Assets: Bank Accounts, Cash-in-Hand, Deposits (Asset), Loans & Advances (Asset), Stock-in-Hand, Sundry Debtors.
4. Creating and Managing Custom User-Defined Groups
While the 28 predefined groups provide a standard structural foundation, large multi-branch or diverse enterprises require custom hierarchical groups (Gateway of Tally → Create → Group) to enable granular managerial cost accounting:
Territorial Debtor Grouping: Creating sub-groups under Sundry Debtors such as "North Kerala Debtors" and "South Kerala Debtors". This allows the credit control department to generate regional aged receivable reports without sorting individual customer ledgers.
Functional Group Properties: • Group behaves like a Sub-ledger: When set to Yes, displays the group balance in reports as a single net figure rather than expanding every individual child ledger.
• Nett Debit/Credit Balances for Reporting: Enforces displaying separate debit and credit totals instead of a single net balance.
• Used for Calculation (Tax/Discounts): Enables automatic percentage calculations during invoicing.
5. Multi-Currency Accounting Architecture
For import-export businesses, Tally Prime allows configuring multiple international currencies (Gateway of Tally → Create → Currency). Key parameters include:
• Currency Symbol & Formal Name: e.g., $ for US Dollar or AED for UAE Dirham.
• Rates of Exchange: Specifying standard, buying, and selling exchange rates on transaction dates.
• Forex Gain/Loss Accounting: When settling foreign currency receivables or payables, exchange rate fluctuations generate automated foreign exchange gain or loss entries routed to a designated indirect expense/income ledger.
UNIT 5: LEDGERS, VOUCHER TYPES & VOUCHER ENTRY
While groups define reporting categories, Ledgers represent the actual operational transactional accounts where financial entries are posted. Every financial transaction in business must affect at least two distinct ledgers.
When a new company is created in Tally Prime, the system automatically creates two default ledgers:
1. Cash: Pre-classified under the Cash-in-Hand sub-group.
2. Profit & Loss A/c: A primary ledger holding accumulated retained earnings.
All other ledgers (e.g., State Bank of India, Rent Expense, ABC Traders) must be created by the user (Gateway of Tally → Create → Ledger). For trade debtors and trade creditors, enabling Bill-Wise Details is mandatory for corporate credit control:
1. New Ref (New Reference): Generated automatically during sales or purchase voucher entry. Captures the specific invoice number (e.g., INV-2025-084) and credit period (e.g., 30 Days) to track that individual receivable.
2. Agst Ref (Against Reference): Selected when recording receipts or payments. Links the payment directly to a pending historical invoice, tracking bill-by-bill settlements and calculating overdue interest.
3. Advance: Used when receiving or paying money prior to invoice generation (e.g., 20% advance booking deposit). Adjusted against the final invoice using "Agst Ref" upon delivery.
4. On Account: Used when a customer makes an unallocated lump-sum payment without specifying which specific outstanding invoices are being settled.
2. Standard Accounting Voucher Types & Shortcut Keys
A Voucher is the digital container recording an individual business transaction. In Tally Prime, specialized voucher types correspond to specific commercial actions:
Shortcut
Voucher Type
Accounting Purpose & Permitted Ledgers
Practical Business Example
F4
Contra Voucher
Strictly for internal funds movement between Cash and Bank accounts. No third-party expense or revenue accounts permitted.
Withdrawing ₹25,000 cash from SBI Current A/c for office petty cash.
F5
Payment Voucher
Recording all outflows of cash or bank funds for expenses, creditor settlements, or fixed asset acquisitions.
Issuing a bank cheque for ₹1,50,000 to settle supplier invoice.
F6
Receipt Voucher
Recording all inflows of cash or bank funds from customers, capital introduction, interest, or asset disposals.
Receiving ₹80,000 NEFT transfer from a trade customer.
Issued to suppliers for goods returned (purchase return) or debiting vendor for shortage/damage in delivered stock.
Returning spoiled chemical drums to vendor; debiting vendor account.
3. Specialized Control Vouchers & Voucher Classes
Beyond regular accounting vouchers, modern software provides advanced operational automation:
Memorandum Voucher (Ctrl + F10): A non-accounting voucher that records provisional transactions without impacting financial statements or ledger balances. Used for temporary cash advances to traveling executives, converting to a formal Payment voucher upon submission of verified expense bills.
Reversing Journal: Automated accrual vouchers that are active only on specific reporting dates and automatically reverse on the following day. Used to model temporary month-end expense provisions for management reporting without altering statutory ledgers.
Post-Dated Vouchers (Ctrl + T): When receiving or issuing post-dated cheques (PDCs), marking the voucher as "Post-Dated" ensures the bank balance is not altered until the cheque maturity date arrives, maintaining accurate current liquidity.
Voucher Classes: Pre-configured templates that automate repetitive voucher calculations. In Sales Vouchers, a voucher class can be configured to automatically append CGST, SGST, and a Round-Off ledger (calculating fractional paise automatically), preventing billing operators from forgetting mandatory tax lines.
UNIT 6: ACCOUNTING FEATURES, INVENTORY FEATURES & CONFIGURATION MENU
A critical strength of modern accounting systems is their deep configurability. Tally Prime provides two distinct control tiers: Company Features (F11), which apply globally across the entire company file, and the Configuration Menu (F12), which governs local screen-level data entry behaviors.
1. Company Features Architecture (F11)
Pressing F11 opens the comprehensive company features dashboard organized into three functional pillars:
1. Accounting Features: • Maintain Accounts: Enables core financial accounting.
• Enable Bill-wise Entry: Activates bill-by-bill tracking for receivables and payables.
• Enable Cost Centres: Allocates revenues and expenses to specific business branches, projects, or profit centers.
• Enable Interest Calculation: Automatically computes penal interest on overdue customer invoices.
2. Inventory Features: • Maintain Inventory: Activates stock items and physical tracking.
• Integrate Accounts with Inventory: Automatically links stock closing valuation to the Balance Sheet.
• Enable Multi-Godowns: Tracks inventory across multiple warehouses, retail floors, or factory sites.
• Enable Batches / Expiry: Mandatory for pharmaceuticals and food processing.
3. Statutory & Taxation Features: • Enable GST: Configures state jurisdiction, GSTIN number, GSTR-1 filing periodicity, and e-Invoicing thresholds.
• Enable TDS: Configures corporate Tax Deduction Account Number (TAN), deductor category, and expense threshold limits.
• Enable TCS: Tax Collection at Source on scrap, timber, and high-value vehicle sales.
2. Cost Categories and Cost Centres
In corporate accounting, managers need to break down revenue and expenses beyond statutory ledgers (e.g., knowing not just total advertising expense, but how much was spent on Product Launch A vs Product Launch B):
Cost Category: Represents the broad dimension of classification (e.g., Departments, Branches, or Projects).
Cost Centre: Represents the specific sub-units within a category (e.g., under Category "Branches": Kochi Branch, Calicut Branch, Trivandrum Branch).
Transactional Allocation: When entering an expense voucher (e.g., Rent Payment of ₹1,00,000), Tally prompts for cost center allocation, splitting ₹50,000 to Kochi, ₹30,000 to Calicut, and ₹20,000 to Trivandrum, generating instantaneous branch profitability reports.
UNIT 7: DAY BOOK, CASH/BANK BOOKS, RECTIFICATION & BRS
Financial accounting requires continuous verification, ledger auditing, and reconciliation against external banking telemetry to ensure institutional data fidelity.
1. Inspection Registers: Day Book, Cash Book, and Bank Book
The Day Book (Gateway of Tally → Day Book): Displays all transactions recorded across all voucher types chronologically. Pressing F2 changes the inspection date; pressing Alt + F2 defines a multi-month period; pressing F4 filters for a single voucher type (e.g., inspecting only Payment vouchers).
Cash & Bank Books: Accessed under Display More Reports → Account Books → Cash/Bank Summary. Provides a real-time view of daily debit receipts, credit disbursements, and closing balances across physical cash chests and commercial bank current accounts.
2. Bank Reconciliation Statement (BRS) Architecture
The balance shown in a company's internal Bank Ledger rarely matches the balance reported on the bank's external Passbook/Statement due to temporal timing differences:
Bank Reconciliation Discrepancy DriversBRS ANALYSIS
BALANCE AS PER CASH/BANK BOOK ± TIMING DIFFERENCES = BALANCE AS PER BANK PASSBOOK
Primary Sources of Temporal Divergence:
Cheques Issued but Not Yet Presented for Payment: The company debited creditor and credited bank internally, but the payee has not yet cleared the cheque at their bank. (Internal book balance is lower than bank passbook).
Cheques Deposited but Not Yet Cleared: The company debited bank internally upon receiving a cheque, but clearinghouse transit takes 2 working days. (Internal book balance is higher than bank passbook).
Direct Bank Charges / Interest Debited: Bank charges, processing fees, or loan interest auto-debited by the bank without prior internal intimation.
Direct Customer Collections: Trade debtors remitting payments via RTGS/NEFT/UPI directly into the company bank account without sending remittance advice.
Reconciling Discrepancy Item
Impact on Internal Bank Ledger
Correction / Reconciliation Action
Cheque Issued but Unpresented
Internal ledger balance is lower.
Add back to internal balance to arrive at bank statement balance.
Cheque Deposited but Uncleared
Internal ledger balance is higher.
Deduct from internal balance to arrive at bank statement balance.
Direct Customer NEFT / RTGS
Bank statement is higher; internal ledger unaware.
Record a Receipt Voucher (F6) in Tally to update internal ledger.
Bank Service Charges Debited
Bank statement is lower; internal ledger unaware.
Record a Payment Voucher (F5) under Bank Charges ledger.
UNIT 8: PAYROLL PROCESSING
Payroll processing encompasses the computerized calculation of employee salaries, statutory deductions (Provident Fund, Employee State Insurance, Professional Tax, TDS), attendance tracking, and generation of individual Pay Slips.
1. Payroll Masters Architecture
Executing payroll in accounting software requires configuring a structured hierarchy of masters:
1. Employee Groups & Employees: Employees are categorized into cost departments (e.g., Executive Management, Sales & Marketing, Factory Production). Individual profiles capture Date of Joining, Designation, Bank Account Number, PAN, Aadhaar, Universal Account Number (UAN for PF), and ESI Insurance Number.
2. Units & Attendance Types: Defines how work duration is measured. Configures calendar units (Months, Days) and production units (Hours, Pieces). Attendance types track Present (positive attendance), Absent / Leave Without Pay (deduction), and Overtime (production-based earning).
3. Earnings Pay Heads: Components that increase gross employee compensation:
• Basic Pay: Fixed monthly salary component.
• Dearness Allowance (DA): Cost-of-living allowance.
• House Rent Allowance (HRA): Statutory housing benefit.
• Overtime Pay: Computed as a rate per hour.
4. Deductions & Statutory Pay Heads: Components that reduce take-home net salary:
• Employee Provident Fund (EPF): 12% statutory employee deduction.
• Employee State Insurance (ESI): 0.75% employee deduction.
• Professional Tax (PT): State employment tax.
• Income Tax (TDS): Tax deduction under Section 192.
2. Statutory Rate Calculations for Indian Payroll
Statutory Component
Employee Deduction
Employer Contribution
Employees' Provident Fund (EPF)
12% of (Basic Pay + DA), capped optionally at ₹15,000 monthly wage ceiling.
12% split: 8.33% to Employees' Pension Scheme (EPS capped at ₹1,250) + 3.67% to EPF + 0.5% EDLI + 0.5% Admin charges.
Employees' State Insurance (ESI)
0.75% of Gross Wages (applicable if gross wage ≤ ₹21,000 per month).
3.25% of Gross Wages contributed by employer.
Professional Tax (PT)
Graduated slab deduction based on state schedule (e.g., ₹100 to ₹250 per half-year/month).
Nil (pure employee statutory tax).
Gratuity Provision
Nil.
Statutory provision computed under Payment of Gratuity Act: (15 × Last Drawn Basic × Years of Service) / 26.
3. Defining Salary Details and Automated Processing
Under Salary Details, the software defines the specific wage formula for each employee group. When monthly payroll is processed:
1. Attendance Voucher (Ctrl + F5): Records monthly attendance, absent days, and overtime hours worked.
2. Payroll Voucher (Ctrl + F4): Using the AutoFill utility (Alt + A), the system automatically calculates Basic Pay, allowances, and statutory PF/ESI deductions across hundreds of employees in seconds.
3. Pay Slip Generation: Exports itemized, audit-ready Pay Slips showing Gross Earnings, Deductions, and Net Take-Home Salary for distribution to staff.
ENTERPRISE BENCHMARK: PAYROLL & BRS INTEGRATION IN FMCG DISTRIBUTION
Automated Corporate Reconciliation: An FMCG trading enterprise employing 120 staff in Calicut previously required two full days each month to compute manual salary sheets and three days to reconcile four corporate bank accounts.
• By configuring Tally Prime's structured Payroll Masters with automated PF/ESI slabs, monthly payroll generation collapsed from 16 labor hours to 12 minutes, eliminating human calculation errors and ensuring statutory PF returns filed on time.
• Using electronic Bank Reconciliation (importing CSV statement files directly into Tally), over 2,500 monthly transactions reconciled with a single click, immediately isolating ₹4.8 Lakhs in unpresented customer cheques and securing working capital liquidity.
Module II Comprehensive Mastery SummaryEXECUTIVE SUMMARY
Automates statutory compliance and monthly pay slip distribution.
Accounting Software Applications
Course Code: COM5FS112 (2) • Module 3 Notes
MODULE III: ACCOUNTS WITH INVENTORY
MODULE OVERVIEW & ARCHITECTURAL FOUNDATION
For commercial trading houses, manufacturing corporations, distribution conglomerates, and retail supply chains, inventory represents the single largest current asset on the corporate balance sheet and the primary engine of operational cash flow. Maintaining financial ledgers in isolation from physical stock creates dangerous blind spots: unrecorded stockouts, unrecognized shrinkage, ballooning carrying costs, and distorted gross profit calculations. Module III explores the comprehensive architecture of Accounts with Inventory in computerized accounting software (Tally Prime). Students master the hierarchical configuration of Stock Groups, Stock Categories, and Stock Items; multi-godown spatial logistics; Units of Measure (UoM) conversion mathematics; purchase and sales order processing workflows; batch-wise expiry tracking; multi-tier price lists; Bill of Materials (BOM) in manufacturing; landed cost apportionment; pure inventory tracking vouchers; physical stock reconciliation; and executive diagnostic inventory telemetry.
UNIT 9: STOCK GROUPS, STOCK CATEGORIES & STOCK ITEMS
In modern computerized accounting software such as Tally Prime, the inventory subsystem operates as an integrated relational sub-ledger tightly synchronized with the general financial ledger. When the configuration switches "Maintain Inventory" and "Integrate Accounts with Inventory" are activated in Company Features (F11), every inward goods receipt, outward customer shipment, warehouse transfer, and physical shrinkage adjustment automatically updates stock ledgers and dynamically adjusts closing inventory valuations in the Trading & Profit & Loss Account and Balance Sheet.
1. Integration of Financial Accounts with Inventory Subsystems
Understanding the distinction between non-integrated and integrated accounting modes is fundamental to enterprise architecture:
Non-Integrated Mode (Accounts Only): Closing stock is entered as an arbitrary financial figure at the end of each accounting period via a standard Journal voucher or direct balance input in the Stock-in-Hand ledger. Physical purchases and sales are recorded as pure rupee values without tracking item quantities, unit rates, batch codes, or warehouse locations. This mode is suitable only for pure service firms (consultancies, legal practices, educational institutions).
Integrated Mode (Accounts with Inventory): Physical quantities and monetary values are perpetually unified. When a purchase invoice is recorded, the software debits the Purchase ledger in the financial book, debits Input GST ledgers, credits the Sundry Creditor, and simultaneously increases the physical balance and inventory valuation of that specific stock item in the specified godown. The closing inventory figure on the Balance Sheet is dynamically calculated based on actual item balances multiplied by the selected valuation costing method (e.g., FIFO or Weighted Average).
2. Stock Groups Architecture: Hierarchical Aggregation
A Stock Group is an organizational classification used to aggregate related stock items sharing similar product line characteristics, raw material origins, operating conditions, or sales divisions. Creating structured hierarchies prevents inventory clutter and empowers executive management to evaluate product line performance.
Stock Group Creation Protocol (Gateway of Tally → Create → Stock Group): • Name: The title of the product category (e.g., Consumer Electronics, Industrial Chemicals, Textiles & Fabrics).
• Under (Parent Group): Establishes hierarchical multi-tier nesting. A group can be classified under the root Primary group or nested under an existing parent group (e.g., nesting Smartphones and Laptops under parent Consumer Electronics; or nesting OLED TVs under Televisions).
• Should Quantities of Items be Added?: A pivotal technical flag:
— Set to Yes: Tally aggregates physical quantities of all subordinate stock items possessing identical units of measure into a single total on summary screens (e.g., aggregating all Laptop quantities measured in Numbers).
— Set to No: Mandated if child items use disparate, incompatible units (e.g., mixing cables measured in Meters with chemicals measured in Liters).
While Stock Groups categorize items by product lineage (e.g., Televisions vs Air Conditioners), enterprises frequently require a parallel, cross-cutting dimension of classification based on brand manufacturer, model generation, quality grade, or technical capacity. This is achieved via Stock Categories (Gateway of Tally → Create → Stock Category).
Multi-Dimensional Matrix: Stock Groups vs Stock CategoriesINVENTORY MATRIX
Stock Categories:Dell, HP, Lenovo, Apple (Brand / Manufacturer Classifications).
The Stock Item:Dell Latitude 5420 Laptop is configured Under Stock Group Laptops and Under Stock Category Dell.
Strategic Reporting Dividend: Executive management can view inventory telemetry from two orthogonal perspectives:
• Product-Centric View: Inspect all laptop inventory across all brands to assess total portable computing stock.
• Vendor-Centric View: Inspect all Dell inventory spanning laptops, desktops, and monitors to manage vendor credit terms and volume rebates.
4. Stock Items Architecture: The Atomic Inventory Unit
A Stock Item is the fundamental discrete physical commodity purchased, stored, manufactured, and sold by an enterprise. Creating a Stock Item (Gateway of Tally → Create → Stock Item) requires configuring multiple interdependent accounting, statutory, and logistical parameters:
1. Master Classification & Units: • Name & Part Number: Trade product name and SKU barcode number.
• Under Group & Category: Assigned to parent group and category.
• Unit of Measure (UoM): Primary unit (e.g., Nos, Kgs) and optional Alternate Unit (e.g., Boxes).
2. Statutory GST Configuration: • HSN / SAC Code: 8-digit Harmonized System of Nomenclature code.
• Taxability: Taxable, Exempt, or Nil-Rated.
• GST Rate: Specific tax rate (e.g., 18% IGST; automatically splitting into 9% CGST + 9% SGST for local sales).
3. Inventory Valuation Methods (AS-2): Selects the cost valuation formula compliant with Accounting Standard 2 (Valuation of Inventories):
• FIFO (First-In, First-Out) • Weighted Average Cost • Last Purchase Cost / Standard Cost
4. Opening Balance Allocation: Captures the physical stock position at the start of the financial year:
• Quantity: e.g., 50 Units.
• Rate: e.g., ₹22,000 per Unit.
• Godown Breakdown: Allocating units across specific physical warehouses.
5. Inventory Costing Methods under Accounting Standard 2 (AS-2)
During periods of volatile inflation or fluctuating supplier purchase prices, the choice of inventory costing method fundamentally impacts reported Cost of Goods Sold (COGS), Gross Profit, and Balance Sheet inventory valuation. Indian Accounting Standard 2 (AS-2) and Ind AS 2 mandate that inventory must be valued at the Lower of Cost and Net Realizable Value (NRV).
Costing Method
Underlying Valuation Mechanics
Financial & Inflationary Impact
FIFO (First-In, First-Out)
Assumes that the oldest inventory batches purchased are the first units sold or consumed in production. Closing inventory is valued at recent purchase costs.
In inflationary environments: Lowers Cost of Goods Sold (COGS), reports higher gross profit, and values closing inventory on the Balance Sheet at current market replacement costs. Fully permitted under AS-2 and Ind AS 2.
Weighted Average Cost
Calculates a dynamic moving average cost per unit: Total Cost of Goods Available for Sale divided by Total Units Available. Recomputed after each purchase.
Smooths out short-term price spikes; produces moderate, balanced profit figures; widely preferred for bulk commodities (crude oil, grains, steel). Fully permitted under AS-2 and Ind AS 2.
LIFO (Last-In, First-Out)
Assumes that the newest inventory purchased is sold first, leaving the oldest costs in closing stock.
Strictly Prohibited under Indian AS-2, Ind AS 2, and International IFRS because it undervalues balance sheet stock during inflation and facilitates artificial profit manipulation.
Last Purchase Cost
Values all remaining unsold stock at the exact unit rate of the most recently recorded purchase voucher.
Used strictly for internal management replacement cost modeling; not permitted for external statutory financial reporting.
Standard Cost
Values inventory at a pre-determined, engineered standard cost benchmark established by cost accountants.
Enables manufacturing firms to isolate Purchase Price Variances (PPV) between standard cost and actual vendor invoice price. Acceptable under AS-2 if standard costs approximate actual costs.
Mathematical Worked Valuation Benchmark: FIFO vs Weighted Average Cost • Opening Stock (Day 1): 100 Units @ ₹50 = ₹5,000
• Purchase 1 (Day 5): 200 Units @ ₹60 = ₹12,000
• Sale 1 (Day 10): 250 Units @ ₹90 = ₹22,500
• Purchase 2 (Day 15): 150 Units @ ₹70 = ₹10,500
Under FIFO Method: — Units Sold (250 Units): 100 Units @ ₹50 (₹5,000) + 150 Units @ ₹60 (₹9,000) = Cost of Goods Sold = ₹14,000.
— Gross Profit = ₹22,500 - ₹14,000 = ₹8,500.
— Closing Stock (200 Units): 50 Units @ ₹60 (₹3,000) + 150 Units @ ₹70 (₹10,500) = ₹13,500.
Under Weighted Average Method: — Prior to Sale: Total Units = 300; Total Cost = ₹17,000. Moving Average Rate = ₹17,000 / 300 = ₹56.67 per Unit.
— Cost of Goods Sold (250 Units) = 250 × ₹56.67 = ₹14,167.50.
— Gross Profit = ₹22,500 - ₹14,167.50 = ₹8,332.50.
— Balance Remaining = 50 Units @ ₹56.67 = ₹2,833.50 + New Purchase 150 Units @ ₹70 (₹10,500) = Total Closing Stock ₹13,333.50 (200 Units @ ₹66.67/unit).
6. Alternate Units of Measure & Packaging Hierarchies
In wholesale trading and FMCG manufacturing, goods are frequently purchased in bulk industrial packaging units but invoiced to retailers in smaller consumer units. Tally Prime manages this through Alternate Units of Measure configured directly on the Stock Item master:
Primary Unit:Kgs (Kilograms).
Alternate Unit:Bags (where conversion rule is defined: 1 Bag = 50 Kgs).
Operational Automation: During Sales Voucher entry, typing 10 Bags automatically populates the primary quantity as 500 Kgs. Billing can be based either per Bag or per Kg, eliminating manual mathematical conversions at billing counters.
Decimal Precision Controls: Simple units must be configured with appropriate decimal precision: 0 decimals for discrete items (Nos, Pcs) and 2 or 3 decimals for continuous commodities (Kgs, Liters, Meters).
UNIT 10: GODOWNS, UNITS OF MEASURE, INVENTORY VOUCHERS & STATEMENTS
Managing physical inventory across complex logistics networks requires multi-warehouse tracking, precise unit conversion algorithms, specialized inventory vouchers, and automated inventory aging telemetry.
In Tally Prime, a Godown (or Location) represents any physical storage facility where stock is housed. Enabling "Enable Multi-Godowns" in F11 allows businesses to track stock across:
Central Distribution Warehouses: Bulk receiving facilities located near ports, railways, or logistics hubs.
Factory Raw Material Stores: Dedicated storage adjacent to manufacturing lines supplying production inputs.
Retail Showrooms / Outlets: Point-of-sale display floors where units are sold directly to consumers.
Third-Party Logistics (3PL) & Consignment Stores: Stock held by clearing agents or distributors on behalf of the company.
2. Units of Measure (UoM) Architecture: Simple vs Compound Units
Accurate stock records require unambiguous mathematical units of measurement (Gateway of Tally → Create → Unit):
1. Simple Units of Measure: Discrete, singular units of measurement:
• Symbol:Nos, Kgs, Ltrs, Mtrs, Box.
• Formal Name: Numbers, Kilograms, Liters, Meters, Boxes.
• Decimal Places: Controls fractional precision:
— Decimal = 0 for indivisible units (e.g., Laptops, Furniture).
— Decimal = 3 for divisible mass (e.g., 1.450 Kgs).
2. Compound Units of Measure: Establishes a fixed mathematical relationship combining two simple units:
• 1 Box = 24 Nos (Wholesale packaging).
• 1 Ton = 1000 Kgs (Industrial raw materials).
• 1 Gross = 12 Dozens (Stationery trade).
Allows operators to purchase inventory in bulk Tons or Boxes and sell in individual Kgs or Pieces seamlessly.
3. The Complete Order Processing Lifecycle
In corporate supply chain management, transactions do not begin with immediate invoicing. They progress through a structured, multi-stage commercial verification pipeline:
End-to-End Procurement & Sales Order PipelinesSUPPLY CHAIN PIPELINE
PURCHASE: Purchase Order (Ctrl+F9) → Receipt Note (Alt+F9) → Rejections Out (Ctrl+F5) → Purchase Invoice (F9)
SALES: Sales Order (Ctrl+F8) → Delivery Note (Alt+F8) → Rejections In (Ctrl+F6) → Sales Invoice (F8)
Operational Mechanics & Control Points:
Order Tracking: Issuing an Order reserves stock or records a purchase commitment without altering financial ledgers or physical inventory counts. It creates an order record tracked in Outstanding Order Reports.
Goods Receipt / Delivery Notes (GRN / GDN): Updates physical warehouse stock immediately upon truck delivery/dispatch accompanied by a Delivery Challan. Financial ledgers remain untouched, with unbilled amounts posted to temporary suspense accounts ("Tracking Numbers").
Rejections Management: Physical defects discovered at the loading dock prior to billing are processed via Rejections Out (returning to vendor) or Rejections In (accepting customer return), maintaining exact physical stock integrity.
Invoicing & Automatic Order Clearing: When the final Tax Invoice (F8/F9) is recorded, selecting the Tracking Number automatically populates all items, quantities, and rates from the Delivery Note, clearing the tracking balance and creating the legal financial receivable/payable.
4. Pure Inventory Vouchers & Material Movement
While standard Sales (F8) and Purchase (F9) vouchers record both accounting ledgers and inventory movement simultaneously, modern supply chains require pure inventory vouchers to manage logistics:
Voucher Type
Shortcut Key
Logistical Purpose & Movement
Business Flow Context
Stock Journal
Alt + F7
Records inter-godown transfers (Source to Destination) and manufacturing consumption entries (Bill of Materials).
Transferring 100 bags of cement from Central Port Godown to Downtown Retail Outlet.
Delivery Note
Alt + F8
Records the physical dispatch of goods to a customer accompanied by a delivery challan before issuing the sales tax invoice.
Records customer goods returned at the warehouse loading dock prior to generating a financial Credit Note.
Customer rejects damaged cartons during truck delivery.
Rejections Out
Ctrl + F5
Records defective stock returned to supplier prior to receiving a formal Debit Note.
Rejecting sub-standard yarn back to mill upon incoming quality check.
Physical Stock
Ctrl + F7
Records physical inventory counts to synchronize digital book stock with actual warehouse shelf balances.
Adjusting for shrinkage, minor transit evaporation, or quarterly stock-take variances.
5. Batch-Wise Details & Expiry Date Management
In regulated industries such as pharmaceuticals, packaged foodstuffs, and industrial chemicals, tracking inventory purely by item name is illegal and operationally hazardous. Enabling "Maintain Batches" and "Set Expiry Dates for Batches" in F11 allows enterprises to capture granular batch telemetry:
Batch Number Allocation: Every inbound purchase lot is assigned a unique batch identifier (e.g., Batch No. PAR-2025-B4).
Manufacturing Date & Expiry Date: Inputted during purchase voucher entry. The software automatically calculates remaining shelf life.
Near-Expiry Stock Warning: Tally displays automated exception warnings when billing staff attempt to sell stock within 30 days of expiration.
Zero-Sale Enactment on Expired Batches: Tally Prime strictly blocks expired batches from appearing in sales invoice selection drop-downs, preventing catastrophic legal liability and protecting consumer safety.
6. Multi-Tier Price Levels & Price Lists
Enterprises selling to diverse customer tiers (e.g., institutional wholesalers, exclusive regional dealers, and walk-in retail consumers) cannot manually negotiate prices during each voucher entry. Modern accounting software implements Price Lists (Gateway of Tally → Create → Price List):
2. Quantity-Based Discount Slabs: Configures graduated volume discount matrices:
• 1 to 50 Units: ₹500 per unit, 0% discount.
• 51 to 200 Units: ₹480 per unit, 2% discount.
• 201+ Units: ₹450 per unit, 5% cash discount.
When billing, selecting the customer's assigned price level automatically applies the exact contractual rate and discount.
7. Bill of Materials (BOM) & Manufacturing Accounting
In manufacturing environments, a Bill of Materials (BOM) defines the complete recipe of raw material components, sub-assemblies, packaging materials, and by-products required to produce a single unit of a finished product.
Manufacturing Workflow via Bill of MaterialsBOM ENGINE
RAW MATERIAL CONSUMPTION (Godown A) → MANUFACTURING VOUCHER → FINISHED PRODUCT INGESTION (Godown B)
BOM Execution Mechanics:
1. Define the BOM on the finished stock item (e.g., 1 Desktop Computer requires: 1 Motherboard, 1 CPU, 2 RAM Sticks, 1 Power Supply, 1 Casing).
2. Record a Stock Journal configured with a Manufacturing Voucher Class.
3. Entering the finished quantity (e.g., 50 Desktops) automatically calculates and deducts the exact proportional quantities of raw materials from the factory stockroom.
4. Allocates additional operational costs (labor wages, factory power, machine depreciation) into the unit cost of the finished product.
5. Accounts for scrap generation, residual waste, and co-products, crediting their net realizable value against total manufacturing costs.
8. Additional Costs of Purchase (Inward Landed Cost Apportionment)
Purchasing inventory rarely incurs only the vendor's invoice price. Businesses incur freight inward, customs duty, transit insurance, and dock handling charges. Under Indian AS-2, all costs incurred in bringing inventories to their present location and condition must be capitalized into inventory cost. Tally's "Track Additional Costs of Purchase" feature automatically distributes landed freight charges proportionally across imported line items:
1. Apportionment by Item Value: Freight and insurance expenses are distributed proportionally based on each item's monetary value:
• Best suited for high-value delicate goods where insurance risk correlates with price.
• Formula: Item Landed Cost = Base Price + (Item Value / Total Invoice Value) × Total Additional Freight.
2. Apportionment by Item Quantity: Transportation and dock handling charges are distributed proportionally based on physical weight or volume:
• Best suited for bulk commodities (cement, grain, steel coils) where shipping freight depends strictly on metric tonnage rather than monetary worth.
• Formula: Item Landed Cost = Base Price + (Item Quantity / Total Quantity) × Total Additional Freight.
Periodic physical stock verification is a mandatory audit control requirement under Companies Act, 2013 and statutory tax laws. Regardless of how sophisticated the digital accounting software is, discrepancies inevitably arise between digital book records and physical shelf counts due to evaporation, moisture loss, theft, unrecorded breakage, or misplacement.
Physical Stock Voucher (Ctrl + F7): Used to input the actual physically counted stock in each godown. Tally Prime compares the counted balance with the software balance and automatically adjusts the book figure to match reality.
Accounting Treatment of Shortages: Normal unavoidable losses (minor shrinkage, drying) are absorbed into Cost of Goods Sold by inflating unit costs of remaining stock. Abnormal losses (pilferage, fire damage, catastrophic water leaks) must be isolated via Journal voucher:
— Abnormal Stock Loss A/c Dr. (to Profit & Loss A/c) — Insurance Claim Receivable A/c Dr. (if insured) — To Stock / Purchase A/c Cr.
Computerized inventory systems provide comprehensive diagnostic telemetry (Gateway of Tally → Stock Summary):
Stock Summary: The primary real-time dashboard displaying quantity, valuation rate, and total monetary value across all stock groups. Pressing Alt + F1 expands the view to reveal individual child stock items. Pressing F12 enables displaying opening stock, inbound purchases, outbound sales, and closing balances simultaneously.
Godown Summary: Displays inventory distribution across individual storage locations, enabling supply chain managers to rebalance stock between surplus and deficit branches.
Stock Ageing Analysis: Segregates inventory into temporal aging buckets (e.g., 0–30 Days, 31–60 Days, 61–90 Days, >90 Days). Crucial for identifying obsolete, slow-moving, or perishable goods before expiration.
Movement Analysis: Analyzes inventory turnover velocity, categorizing stock items into fast-moving high-margin lines versus slow-moving capital drains.
Reorder Status & Purchase Orders: Compares current stock on hand against pre-configured Minimum Reorder Levels and pending sales commitments, generating automated purchase requisition warnings.
ENTERPRISE CASE BENCHMARK: MULTI-GODOWN LOGISTICS RESTRUCTURING
Kerala Retail Consumer Electronics Chain: A consumer electronics chain operating a central port warehouse in Kochi and four retail showrooms across Calicut, Thrissur, and Trivandrum struggled with severe stockouts of high-demand 4K Televisions during festival seasons, despite holding ₹3 Crores of excess inventory across secondary warehouses.
• By implementing Tally Prime's structured Multi-Godown tracking with Compound Units (1 Master Carton = 4 Units), Batch Expiry Tracking, and activating Stock Journal inter-branch transfers:
• The supply chain team gained real-time visibility into branch-level stock positions, enabling automated daily replenishment runs.
• Stock Ageing Analysis exposed ₹42 Lakhs of aged display models accumulating holding costs, which were immediately cleared via targeted promotional discounts.
Business Result: Stockout incidents collapsed by 85%, while overall inventory carrying costs declined by 18% within six months of implementation.
To integrate all theoretical concepts, consider a complete end-to-end corporate scenario simulated in Tally Prime for Apex Tech Solutions Pvt Ltd (a computer assembly and wholesale distribution firm based in Kochi, Kerala):
Phase 1: Master Setup & Bill of Materials (BOM) Configuration • Stock Groups:Raw Components (Items added = No) and Finished Desktops (Items added = Yes).
• Stock Categories:Intel Architecture and AMD Architecture.
• Units of Measure: Simple: Nos (Decimal = 0), Boxes (Decimal = 0). Compound: 1 Box = 10 Nos.
• Godowns:Kochi Port Warehouse (Bulk Receiving), Aluva Factory Floor (Assembly Plant), and Calicut Showroom (Retail Outlet).
• BOM Definition on Finished Item "Apex Core-i7 Desktop": — Raw Components consumed from Aluva Factory Floor: 1 Motherboard, 1 Core-i7 CPU, 2 DDR5 16GB RAM Sticks, 1 1TB NVMe SSD, 1 750W SMPS, 1 ATX Cabinet.
Phase 2: Procurement, Landed Freight & Assembly • Transaction 1: Purchase Order Issued (Ctrl + F9) to Microchip Distributors for 100 sets of components @ ₹40,000 per set. Order No: PO-APX-01.
• Transaction 2: Receipt Note Recorded (Alt + F9) upon arrival of container at Kochi Port Warehouse against Tracking No: TRK-GRN-101. Physical stock increases by 100 sets.
• Transaction 3: Rejections Out Recorded (Ctrl + F5) for 5 defective SMPS units returned to vendor before invoicing.
• Transaction 4: Final Purchase Tax Invoice (F9) booked against TRK-GRN-101. Incurs additional Freight Inward of ₹25,000 apportioned across components by value.
• Transaction 5: Stock Journal Transfer (Alt + F7) moving 50 sets of components from Kochi Port Warehouse to Aluva Factory Floor.
• Transaction 6: Manufacturing Stock Journal (Alt + F7 with BOM class) assembling 50 units of "Apex Core-i7 Desktop". Consumes component sets; allocates Direct Assembly Wages of ₹15,000. Finished Desktop unit cost calculated automatically as ₹40,550.
Phase 3: Multi-Tier Sales & Physical Reconciliation • Transaction 7: Sales Order Recorded (Ctrl + F8) from Horizon IT Academy for 20 Desktops under Dealer Price Level @ ₹48,000 each. Order No: SO-HRZ-501.
• Transaction 8: Delivery Note Issued (Alt + F8) dispatching 20 Desktops from Aluva Factory Floor with Challan No: CHL-202.
• Transaction 9: Sales Tax Invoice Generated (F8) tracking CHL-202 with 18% IGST. Horizon IT Academy is debited; Sales and Output Tax credited.
• Transaction 10: Physical Stock Audit (Ctrl + F7) conducted at month-end. Physical count reveals 29 Desktops on hand versus digital book balance of 30. Discrepancy investigated: 1 unit damaged in transit; written off via Abnormal Loss Journal Voucher to ensure audit compliance.
Module III Comprehensive Mastery SummaryEXECUTIVE SUMMARY
The ultimate objective of recording transactions and maintaining inventory in accounting software is the generation of timely, error-free, and legally compliant financial telemetry. While manual accounting required weeks of laborious cross-posting, ledger balancing, and manual reconciliation at year-end, computerized accounting engines dynamically synthesize raw vouchers into real-time financial statements, diagnostic ratio matrices, statutory Goods and Services Tax (GST) returns, and forward-looking budgetary variance models. Module IV explores the complete reporting ecosystem: primary registers (Cash/Bank Books, Ledger Accounts), statutory financial statements (Trial Balance, Profit & Loss Account, Balance Sheet under Schedule III of the Companies Act, 2013), diagnostic ratio analysis and Cash Flow Statements (AS-3 / Ind AS 7), multi-format data exports (PDF, Excel, XML), end-to-end GST accounting (GSTR-1, GSTR-3B, e-Invoicing, e-Way Bills), and managerial budgeting and forecasting frameworks.
In software environments like Tally Prime, financial statements are not static documents compiled manually at the end of the fiscal year; they are dynamic relational views computed instantaneously from transaction tables. Entering a single voucher propagates immediately across the Cash Book, Debtor/Creditor ledgers, Trial Balance, Income Statement, and Balance Sheet.
1. Primary Books: Cash Book, Bank Books & Ledger Accounts
Primary accounting registers provide chronologically ordered and account-specific records of financial transactions:
Cash Book (Gateway of Tally → Display More Reports → Account Books → Cash/Bank Book(s)): Displays the opening cash balance, all inward cash receipts, outward cash disbursements, and the closing physical cash position. Modern software supports multi-currency cash accounts, petty cash imprest sub-ledgers, and daily cash flow summaries. Negative cash balances are highlighted as severe control warnings.
Bank Books & Bank Reconciliation Telemetry: Tracks transactions processed through commercial banking channels. Pressing Alt + R opens the integrated Bank Reconciliation Statement (BRS) module, allowing accountants to match digital book entries against bank statement clearance dates, isolating unpresented cheques, uncredited deposits, and automated bank charges.
Ledger Accounts (Gateway of Tally → Display More Reports → Account Books → Ledger): The foundational sub-ledger displaying all debit and credit entries posted to a specific ledger. Features include:
• Columnar Ledger Display (F8): Breaks down line items by voucher type, voucher number, reference number, quantity, rate, gross amount, and tax breakdowns.
• Bill-by-Bill Clearing Status: For Sundry Debtors and Creditors, pressing Alt + B displays unpaid bills, payment due dates, overdue aging buckets, and accrued interest.
• Daily / Monthly Summary: Aggregates transactions into monthly totals to identify seasonal sales spikes or expenditure anomalies.
2. Trial Balance: The Arithmetical Equilibrium Benchmark
A Trial Balance (Gateway of Tally → Display More Reports → Trial Balance) is a consolidated schedule of all ledger debit and credit closing balances at a specific point in time. In computerized systems based on strict double-entry mechanics, the total of all debit balances mathematically equals the total of all credit balances at all times.
TOTAL DEBITS (Assets + Expenses + Losses) = TOTAL CREDITS (Liabilities + Capital + Incomes + Gains)
Core Display Configurations in Tally Prime:
Grouped View vs Detailed View (Alt + F1 / Alt + F5): Grouped view shows high-level Primary Groups (Capital Account, Current Assets, Current Liabilities, Sales Accounts, Purchase Accounts). Expanding the view reveals nested subgroups and atomic ledger accounts.
Ledger-wise Trial Balance (F5): Flattens the hierarchical group structure to present all active ledgers alphabetically, providing a fast audit checklist.
Columnar / Four-Column Trial Balance (F12): Displays Opening Balance, Debit Transactions during the period, Credit Transactions during the period, and Net Closing Balance for every account.
Difference in Trial Balance (Suspense Account): While standard dual-entry prevents mathematical inequality, opening balance entry errors or corrupted database tables can create a discrepancy. Tally Prime automatically isolates this difference and displays it at the bottom of the Trial Balance until resolved.
3. Profit and Loss Account (Income Statement)
The Profit and Loss Account (Gateway of Tally → Profit & Loss A/c) measures the operational and commercial financial performance of the enterprise over a specified accounting period. It calculates Gross Profit, Operating Profit, and Net Profit.
1. Trading Account Section (Gross Profit): Captures direct manufacturing and trading operations:
• Debit Side: Opening Stock, Direct Purchases (net of returns), Direct Expenses (Wages, Factory Freight, Power, Fuel).
• Credit Side: Sales Revenue (net of returns and trade discounts), Closing Stock valuation (from inventory sub-ledger).
• Gross Profit Margin: Gross Profit = Net Revenue from Operations - Cost of Goods Sold (COGS).
2. Profit & Loss Section (Net Profit): Captures operational overheads, financial costs, and non-operating income:
• Debit Side: Indirect Expenses (Administrative Salaries, Office Rent, Marketing, Depreciation, Bank Interest, Bad Debts).
• Credit Side: Gross Profit brought down, Indirect Incomes (Interest Received, Dividend Income, Discount Received, Scrap Sales).
• Net Profit / Net Loss: Transferred dynamically to Capital Account / Reserves & Surplus on the Balance Sheet.
Presentation Styles: Tally Prime allows toggling between the traditional Horizontal T-Format (Debit on Left, Credit on Right) and the Vertical Format prescribed under Schedule III of the Companies Act, 2013 for corporate statutory reporting (F12 → Show Vertical P&L = Yes).
4. Balance Sheet: Statement of Financial Position
The Balance Sheet (Gateway of Tally → Balance Sheet) summarizes the financial condition of the enterprise at a specific date, presenting the fundamental accounting identity:
The Fundamental Accounting Equation: ASSETS = LIABILITIES + SHAREHOLDERS' EQUITY (CAPITAL)
Fixed Assets + Non-Current Investments + Current Assets = Capital / Share Capital + Reserves & Surplus + Non-Current Liabilities + Current Liabilities
Marshalling of Balance Sheet: Accounting software supports both methods of ordering assets and liabilities:
Order of Liquidity: Assets are presented in descending order of their convertibility into cash (Cash in Hand → Bank Balances → Marketable Securities → Sundry Debtors → Closing Stock → Fixed Assets). Best suited for banking, trading, and financial institutions.
Order of Permanence: Assets are presented starting with the most permanent long-term investments (Goodwill & Land → Plant & Machinery → Furniture → Long-term Investments → Stock → Debtors → Cash). Mandated for manufacturing companies and joint-stock corporations under Schedule III.
Relational Drill-Down Navigation Power in Tally Prime: One of the greatest advantages of computerized accounting over paper ledgers is multidimensional interactive drill-down:
• On the Balance Sheet, highlighting Sundry Debtors and pressing Enter displays the group-wise breakdown of all corporate debtors.
• Selecting an individual customer ledger and pressing Enter reveals the monthly transactional summary.
• Selecting a specific month displays all vouchers recorded during that month.
• Selecting a specific Sales Invoice opens the original root transaction voucher, allowing immediate verification or audit alteration.
UNIT 12: RATIO ANALYSIS, CASH FLOW STATEMENT & MULTI-FORMAT DATA EXPORTS
Modern corporate executives, commercial lenders, credit rating agencies, and statutory auditors require higher-order analytical telemetry beyond raw financial statements. Accounting software packages automate the continuous computation of diagnostic financial ratios, generate standardized Cash Flow Statements, and facilitate enterprise data interoperability through multi-format exports.
1. Financial Ratio Analysis Architecture
In Tally Prime, the Ratio Analysis dashboard (Gateway of Tally → Ratio Analysis) automatically calculates and presents core financial metrics updated with every voucher:
Ratio Category
Mathematical Formulation
Executive Analytical Interpretation
Current Ratio (Liquidity)
Current Assets / Current Liabilities
Measures short-term debt servicing capability. Standard benchmark is 2:1. A ratio below 1.5 indicates liquidity stress; a ratio above 3.0 indicates idle, unproductive working capital.
Quick / Acid-Test Ratio (Liquidity)
(Current Assets - Inventory - Prepaid Expenses) / Current Liabilities
Measures instant liquidity without relying on the liquidation of physical stock. Standard benchmark is 1:1. Essential for assessing solvency during sudden commercial downturns.
Debt-to-Equity Ratio (Solvency / Leverage)
Total Long-Term Debt / Shareholders' Equity
Evaluates financial leverage and capital risk. Standard norm is 2:1 or lower. High leverage magnifies insolvency risk during rising interest rate cycles.
Inventory Turnover Ratio (Activity / Efficiency)
Cost of Goods Sold (COGS) / Average Inventory
Measures the velocity at which physical inventory is converted into sales. Higher turnover reflects agile supply chain management and reduced carrying holding costs.
Debtors Turnover & Days Sales Outstanding (DSO)
Net Credit Sales / Average Debtors DSO = (Average Debtors / Credit Sales) × 365 Days
Measures the average collection period. A high DSO indicates loose credit policies, delayed collections, and elevated risk of bad debts.
Return on Capital Employed (ROCE)
Earnings Before Interest and Taxes (EBIT) / Capital Employed
Evaluates the profitability and asset efficiency of total capital deployed across equity and debt. Must comfortably exceed the weighted average cost of capital (WACC).
2. Cash Flow Statement (Accounting Standard 3 & Ind AS 7)
While the Profit & Loss Account measures accounting profitability on an accrual basis, profitable companies can easily collapse into bankruptcy if operating profits are tied up in unsold inventory or overdue accounts receivable. The Cash Flow Statement (Gateway of Tally → Display More Reports → Cash Flow) tracks actual physical liquidity inflows and outflows across three mandatory economic streams:
1. Operating Activities: Core cash generated from primary business revenue:
• Cash receipts from customers.
• Cash paid to suppliers & staff.
• Income tax paid.
• Adjustments for non-cash items (Depreciation, Amortization) and working capital changes.
2. Investing Activities: Cash flows from capital asset management:
• Purchase of Fixed Assets (CapEx: plant, property, machinery, IT infrastructure).
• Proceeds from sale of old equipment.
• Purchase or sale of long-term marketable investments.
3. Financing Activities: Cash flows from capital structure changes:
• Inflow from share capital issuance.
• Inflow from long-term bank borrowings or debentures.
• Outflow for loan principal repayment, lease liabilities, and dividend payouts.
3. Enterprise Data Exporting & Digital Interoperability
Financial statements must be exported for board presentations, external auditing, tax filing, and data analytics. Tally Prime provides versatile multi-format export capabilities (Alt + E → Current):
PDF (Portable Document Format): Read-only, tamper-resistant format preserving exact layout typography. Widely used for emailing customer tax invoices, supplier purchase orders, and audited financial statements. Supports cryptographic digital signatures.
Microsoft Excel (XLS / XLSX): Exports formatted or raw tabular data. Crucial for financial analysts performing sensitivity modeling, scenario planning, regression analysis, and pivot table synthesis.
XML (Extensible Markup Language): Structured hierarchical data format used for system-to-system automated data integration (e.g., syncing Tally transactions directly with Salesforce, SAP, or web e-commerce backends).
HTML (Web Page): Exports formatted web documents suitable for intranet publishing and internal corporate dashboards.
CSV / ASCII (Plain Text): Comma-delimited plain text files used for bulk data migration into relational SQL databases or government e-filing utilities.
UNIT 13: ACCOUNTING FOR GOODS AND SERVICES TAX (GST)
The implementation of the Goods and Services Tax (GST) in India on July 1, 2017 revolutionized indirect taxation by subsuming multiple central and state levies (Excise Duty, Service Tax, VAT, Central Sales Tax, Luxury Tax) into a unified destination-based tax system. Accounting software packages serve as the primary engine for statutory GST compliance, tax invoicing, input credit reconciliation, and e-filing.
The Indian GST structure operates under a dual federal model:
Intra-State Supply (Within Same State): Incurs Central GST (CGST) collected by the Central Government and State GST (SGST) (or UTGST for Union Territories) collected by the State Government in equal 50:50 proportions. For an 18% GST item sold within Kerala, 9% is booked to CGST and 9% to SGST.
Inter-State Supply (Between Two Different States): Incurs Integrated GST (IGST) collected entirely by the Central Government and subsequently apportioned to the destination consumption state. For an 18% GST item sold from Kochi (Kerala) to Bangalore (Karnataka), 18% is booked to IGST.
GSTIN (Goods and Services Tax Identification Number): A 15-character alphanumeric identifier:
• Digits 1–2: State Code (e.g., 32 for Kerala, 29 for Karnataka, 27 for Maharashtra).
• Digits 3–12: 10-digit Permanent Account Number (PAN) of the business entity.
• Digit 13: Entity number of the same PAN holder within the state.
• Digit 14: Default character Z.
• Digit 15: Check digit for cryptographic checksum validation.
HSN / SAC Codes: 8-digit Harmonized System of Nomenclature (HSN) codes for physical goods and 6-digit Services Accounting Codes (SAC) for professional services. Mandated on all B2B tax invoices.
2. Master Configuration for GST in Tally Prime
Activating and configuring statutory GST requires precise setup across four operational tiers:
Tier 1: Company Features Activation (F11 → Enable Goods and Services Tax (GST) = Yes): • Select State (e.g., Kerala).
• Registration Type: Regular (standard input tax credit mechanism) or Composition (flat turnover tax for small traders without ITC).
• Enter 15-digit GSTIN, Periodicity of GSTR-1 (Monthly for turnover > ₹5 Crores; Quarterly under QRMP for smaller entities), and e-Invoicing applicability.
Tier 2: Tax Ledger Masters (Gateway of Tally → Create → Ledger): • CGST Ledger: Grouped Under Duties & Taxes → Type of Duty: GST → Tax Type: Central Tax.
• SGST Ledger: Grouped Under Duties & Taxes → Type of Duty: GST → Tax Type: State Tax.
• IGST Ledger: Grouped Under Duties & Taxes → Type of Duty: GST → Tax Type: Integrated Tax.
Tier 3: Commercial Party Ledgers: • Sundry Debtors & Creditors: Configure official State, Registration Type (Regular, Composition, Unregistered, Consumer), and verified 15-digit GSTIN.
Tier 4: Stock Item Masters & Tax Rate Mapping: • Input accurate HSN code and configure taxability as Taxable, Exempt, or Nil Rated.
• Enter the integrated tax percentage (e.g., 18%). The software automatically divides it into 9% CGST and 9% SGST during intra-state billing.
3. Inward & Outward GST Vouchering Mechanics
During voucher entry (F8: Sales and F9: Purchase), Tally Prime's statutory tax engine automatically validates tax applicability:
Automated Tax Calculation: Selecting the customer party ledger informs Tally of the destination state. If the buyer's state matches the seller's state, selecting CGST and SGST ledgers automatically populates the exact tax amounts. Attempting to select an IGST ledger on a local transaction results in a zero-value entry, preventing statutory billing errors.
Reverse Charge Mechanism (RCM): For specified goods and services (e.g., freight transport by Goods Transport Agencies - GTA, legal services from advocates), liability to pay tax shifts from the supplier to the recipient. Tally automatically tracks reverse charge liability and creates input tax credit offsets upon tax payment.
4. Statutory GST Returns & The Triangulation Engine
Tally Prime features an intelligent Triangulation Reporting Engine that audits tax data before statutory returns are generated:
Tally Prime GST Triangulation & Audit ArchitectureSTATUTORY ENGINE
TOTAL VOUCHERS → INCLUDED IN RETURN → UNCERTAIN TRANSACTIONS (CORRECTIONS NEEDED) → JSON EXPORT
Core Return Frameworks:
GSTR-1 (Gateway of Tally → Display More Reports → Statutory Reports → GST → GSTR-1): The statutory monthly/quarterly return of outward supplies. Categorizes sales into:
• Table 4: B2B Invoices: Taxable sales to registered entities with GSTIN.
• Table 5: B2C (Large) Invoices: Interstate sales to unregistered consumers exceeding ₹2.5 Lakhs.
• Table 7: B2C (Small) Invoices: All local consumer sales and interstate sales below ₹2.5 Lakhs.
• Table 9: Credit / Debit Notes: Post-sale price adjustments, discounts, and sales returns.
• Table 12: HSN Summary: Mandatory HSN-wise quantity and tax rate breakdown.
GSTR-3B (GST Reports → GSTR-3B): The monthly summary return for tax payment. Synthesizes total outward taxable supplies, computes net tax payable, calculates eligible Input Tax Credit (ITC), and matches ITC against auto-populated GSTR-2B vendor portal feeds to prevent ineligible ITC claims.
Resolving Uncertain Transactions: If an invoice contains an invalid GSTIN, missing HSN code, or tax rate mismatch, Tally isolates it in the "Uncertain Transactions (Corrections needed)" section, preventing corrupted or defective JSON return filing.
5. E-Invoicing & E-Way Bill Integration
Under statutory mandates notified by the Central Board of Indirect Taxes and Customs (CBIC), registered businesses exceeding specified turnover thresholds must comply with digital invoicing and transport tracking:
E-Invoicing: Businesses generate invoices in JSON format and transmit them directly to the government's Invoice Registration Portal (IRP). The IRP validates the document, signs it cryptographically, and generates a unique 64-character Invoice Reference Number (IRN) along with a machine-readable QR Code containing invoice metadata. Tally Prime integrates directly with the IRP via API, printing the IRN and QR code directly onto tax invoices seamlessly.
E-Way Bill: An electronic documentation required for transporting physical consignments of goods exceeding ₹50,000 in value. It comprises:
• Part A: Consignor GSTIN, Consignee GSTIN, Delivery Pin Code, Invoice Number, HSN Code, and Consignment Value.
• Part B: Transporter ID, Vehicle Number, and Railway/Air/Ship receipt number.
Tally Prime compiles e-Way Bill data automatically, generating direct JSON payloads for instantaneous upload to the national e-Way Bill portal.
UNIT 14: BUDGETING AND FORECASTING USING ACCOUNTING SOFTWARE
While retrospective financial accounting records historical performance, managerial accounting requires proactive financial planning, operational targets, and dynamic variance tracking. Accounting software bridges this gap through integrated Budgets and Scenarios.
1. Budgetary Control Architecture
A Budget in accounting software is a quantified, time-bound financial plan establishing projected expenditure limits and revenue expectations for specific ledger accounts, account groups, or operational cost centers (Gateway of Tally → Create → Budget).
1. Budget Types & Scopes: • Corporate Operating Budgets: Establishes company-wide revenue and operating expenditure ceilings.
• Departmental / Cost Center Budgets: Allocates distinct spending limits to specific departments (e.g., Marketing, R&D, Human Resources, Production).
• Capital Expenditure (CapEx) Budgets: Governs multi-year plant and IT infrastructure investments.
2. Budget Basis Configuration: • On Net Transactions Basis: Evaluates net debits minus credits incurred strictly during the budget period (ideal for revenue and expense ledgers like Advertising, Travel, Salaries).
• On Closing Balance Basis: Evaluates the cumulative ending account balance (mandated for Balance Sheet accounts like Bank Overdrafts, Term Loans, or Inventory Balances).
2. Automated Variance Analysis & Management Control
Once budgets are established, accounting software continuously compares actual ledger transactions against budgeted benchmarks, generating real-time Budget vs Actual Variance Reports:
In Tally Prime, pressing Alt + C in the Trial Balance or Profit & Loss Account allows adding a parallel comparative column displaying the active Budget alongside Actuals, accompanied by exact Rupee Variance and Percentage Variance columns. This enables Management by Exception (MBE), directing executive attention only to departments with severe adverse variances exceeding pre-set tolerance thresholds.
3. Financial Forecasting & Scenario Management
Corporate planners often need to model hypothetical economic conditions (e.g., raw material price surges, currency devaluation, tax rate increases) without polluting the official books of accounts. Accounting software achieves this via Scenario Management (Gateway of Tally → Create → Scenario):
Optional Vouchers: Regular vouchers marked as "Optional" (Ctrl + L). They do not affect financial ledgers, inventory counts, or statutory reports. They are visible only when explicitly included in provisional scenario reports.
Reversing Journals (F10): Special temporary vouchers that auto-reverse on a specified expiry date. Widely used for interim monthly depreciation estimates, unbilled revenue accruals, or projected year-end bonuses.
What-If Scenario Synthesis: Management can create a Scenario named "Worst Case Expansion" combining official actuals with optional marketing vouchers and reversing interest accruals to evaluate debt coverage viability before executing commercial capital expansion.
ENTERPRISE CASE BENCHMARK: STATUTORY GST & BUDGETARY RESTRUCTURING
Malabar Agro-Processing Corporation: An export-oriented agro-processing firm in Kozhikode operating across four manufacturing plants suffered from recurring GST audit penalties of ₹18 Lakhs annually due to manual calculation of inverted duty structures, missing supplier GSTINs, and untracked Input Tax Credit mismatches. Furthermore, factory maintenance costs consistently exceeded administrative forecasts by 35%.
• By migrating fully to Tally Prime's integrated Statutory GST subsystem and Cost-Center Budgeting:
• The Triangulation Engine identified 142 mismatched vendor invoices prior to GSTR-3B filing, ensuring 100% ITC claim accuracy against GSTR-2B and eliminating statutory penalties entirely.
• Plant-level maintenance budgets were configured on a Net Transactions basis. Automated variance alerts triggered whenever a plant consumed 80% of its monthly maintenance quota before the 20th of the month.
Business Result: Statutory tax compliance reached 100% audit perfection, while controllable plant operating expenses were compressed by 22% in the first fiscal year.
To master all core concepts in Unit 11 through Unit 14, examine the complete annual financial closing and statutory audit simulation for Zenith Infotech Solutions Pvt Ltd (a business software developer and hardware distributor based in Ernakulam, Kerala):
Phase 1: Transaction Recording & Trial Balance Verification • Gross Revenues: Total sales of ₹1,20,00,000 recorded across IT Services (SAC 9983) and Enterprise Hardware (HSN 8471).
• Procurement & Overheads: Hardware purchases of ₹60,00,000, Employee Salaries of ₹25,00,000, Office Rent of ₹6,00,000, and Server Cloud Infrastructure of ₹4,00,000.
• Trial Balance Extraction: Verified on March 31. Total Debits (₹1,55,00,000) equal Total Credits (₹1,55,00,000). Difference in Trial Balance is ₹0.00.
Phase 2: Financial Statements & Ratio Diagnostic Audit • Trading & Profit & Loss Statement: Gross Profit computed as ₹60,00,000 (50% Gross Margin). After deducting Operating Overheads (₹35,00,000) and Depreciation (₹3,00,000), Operating Net Profit Before Tax is ₹22,00,000.
• Balance Sheet Marshalling: Formatted under Schedule III Order of Permanence. Non-Current Assets: ₹45,00,000; Current Assets (Bank + Debtors + Closing Stock): ₹55,00,000. Total Assets = ₹1,00,00,000 matched against Equity Share Capital (₹50,00,000), Retained Earnings (₹30,00,000), and Current Liabilities (₹20,00,000).
• Ratio Dashboard Validation: — Current Ratio = Current Assets (₹55L) / Current Liabilities (₹20L) = 2.75 : 1 (Healthy liquidity buffer).
— Quick Ratio = (₹55L - ₹15L Stock) / ₹20L = 2.00 : 1 (Excellent solvency).
— Debt-to-Equity Ratio = 0.00 (Zero long-term debt; entirely equity funded).
Phase 4: Budgetary Variance Evaluation & Board Export • Annual Variance Review: Cloud Server Hosting was budgeted at ₹3,00,000; actual expenditure was ₹4,00,000. Unfavorable variance of ₹1,00,000 (33.3% overrun) flagged for IT infrastructure optimization.
• Multi-Format Export: Final audited Balance Sheet and Profit & Loss exported to PDF with 256-bit encryption for bank credit renewal, and raw monthly ledger schedules exported to Microsoft Excel (.XLSX) for statutory tax audit certification.
Module IV Comprehensive Mastery SummaryEXECUTIVE SUMMARY
TRIAL BALANCE + STATUTORY STATEMENTS + RATIO TELEMETRY + GST COMPLIANCE + BUDGETARY CONTROL
Domain
Core Technical Capability
Strategic Business Impact
Financial Books & Statements
Trial Balance, P&L, Balance Sheet with Schedule III marshalling and drill-down.
Delivers real-time corporate financial condition and statutory shareholder transparency.
Financial Diagnostics
Automated Liquidity, Solvency, Turnover, and Profitability ratios; Cash Flow (AS-3).
Evaluates operational health, prevents bankruptcy risk, and guides capital allocation.
Data Interoperability
Multi-format exports (PDF, Excel, XML, HTML, CSV) with digital signature support.
Enables frictionless external auditing, banking reviews, and enterprise ERP integration.
Guarantees total statutory tax compliance and maximizes Input Tax Credit realization.
Budgeting & Forecasting
Ledger/Group budgets, Variance Analysis (MBE), Scenarios with Optional vouchers.
Empowers management to enforce expenditure control and model strategic expansion.
Calicut University FYUGP Academic Framework
Course CodeCOM5FS112 (2)
Credits3 Credits (45h)
Internal (CIE)30 Marks
End-Sem (ESE)70 Marks
Syllabus details for BCom Semester 5 under official Calicut University regulations.
Assessment comprises a 70-mark End-Semester Examination (2 Hours) and 30-mark Continuous Internal Evaluation.
About Accounting Software Applications (Calicut University BCom Sem 5)
Accounting Software Applications (COM5FS112 (2) • 3 Credits • 45 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).
Official syllabus unit modules prescribed by the Calicut University FYUGP framework:
Module I
Theoretical Foundations & Principles
Examines the core principles and analytical methods of Theoretical Foundations & Principles in Accounting Software Applications (COM5FS112 (2)). Key areas of study encompass Introduction to computerized accounting systems: features, benefits over manual accounting, and Tally Prime interface; Company setup: creating, altering, and configuring company data, financial year settings, and security controls, 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.
Module II
Operational Frameworks & Methodologies
Examines the core principles and analytical methods of Operational Frameworks & Methodologies in Accounting Software Applications (COM5FS112 (2)). Key areas of study encompass Chart of Accounts: predefined groups, creating custom groups, ledger creation, and opening balance entry; Accounting voucher entry: Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), and Purchase (F9), 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.
Module III
Regulatory Compliance & Quantitative Analysis
Examines the core principles and analytical methods of Regulatory Compliance & Quantitative Analysis in Accounting Software Applications (COM5FS112 (2)). Key areas of study encompass Inventory management: stock groups, stock categories, stock items, units of measure (UoM), and godown management; Inventory vouchers: purchase orders, sales orders, delivery notes, and goods receipt notes, 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.
Module IV
Strategic Applications & Contemporary Trends
Examines the core principles and analytical methods of Strategic Applications & Contemporary Trends in Accounting Software Applications (COM5FS112 (2)). Key areas of study encompass Statutory compliance in Tally: enabling Goods and Services Tax (GST), CGST, SGST, IGST calculation, and HSN/SAC codes; Generating statutory reports and returns: GSTR-1, GSTR-3B, e-Way bill generation, and GST audit reconciliation, 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
Introduction to computerized accounting systems: features, benefits over manual accounting, and Tally Prime interface
Company setup: creating, altering, and configuring company data, financial year settings, and security controls
Chart of Accounts: predefined groups, creating custom groups, ledger creation, and opening balance entry
Accounting voucher entry: Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), and Purchase (F9)
Inventory management: stock groups, stock categories, stock items, units of measure (UoM), and godown management
Statutory compliance in Tally: enabling Goods and Services Tax (GST), CGST, SGST, IGST calculation, and HSN/SAC codes
Generating statutory reports and returns: GSTR-1, GSTR-3B, e-Way bill generation, and GST audit reconciliation
Financial reports generation: Trial Balance, Profit and Loss Account, Balance Sheet, Ratio Analysis, and Cash Flow
Learning Outcomes
Create and configure corporate company files in computerized accounting software with security controls.
Set up structured charts of accounts and post transactions using standard accounting voucher formats.
Manage multi-location inventory, stock categories, and godown transfers in Tally Prime.
Configure Goods and Services Tax (GST) rules, invoice generation, and statutory tax calculations.
Generate automated financial statements, trial balances, bank reconciliations, and statutory GST return reports.
Calicut University Examination Scheme for Accounting Software Applications
The evaluation framework for Accounting Software Applications (COM5FS112 (2)) 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):
Part A: Conceptual Questions
10 Questions × 3 Marks (Maximum ceiling 24 Marks). Short definitional and conceptual questions covering all 4 syllabus modules.
Part B: Analytical Problems
8 Questions × 6 Marks (Maximum ceiling 36 Marks). Paragraph questions, comparative evaluations, and analytical problems.
Part C: Comprehensive Essays
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 Accounting Software Applications (COM5FS112 (2)) 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 — Accounting Software Applications
What are the essential steps in setting up a computerized company in Tally Prime?
Steps include: entering company name, address, and statutory registration numbers (PAN, GSTIN), defining the financial year and books beginning date, configuring base currency symbols, and enabling GST, TDS, and inventory features.
How do you record a Goods Purchase with CGST and SGST in Tally Prime?
Select Purchase Voucher (F9), enter supplier invoice details, select supplier ledger (Sundry Creditor), choose the Purchase Ledger, select items with HSN codes, and apply the appropriate Input CGST and Input SGST ledgers; Tally auto-calculates tax.
What is a Bank Reconciliation Statement (BRS) in Tally Prime and how is auto-reconciliation performed?
BRS in Tally reconciles the book balance with the bank passbook. Auto-reconciliation imports the electronic bank statement (Excel/CSV), automatically matches instrument numbers and transaction dates, and highlights unreconciled items.
How do Cost Centres and Cost Categories track departmental expenditure in Tally?
Cost Categories classify expenditure dimensions (e.g., Branches, Projects). Cost Centres represent individual business units within that category (e.g., Kochi Branch, Calicut Branch). When recording vouchers, expenses are allocated to specific cost centres.
Academic Standards
Course outlines and study notes follow official Calicut University curricula. Curated by Fayiz (Wayanad).