Dean's Office Official Model Question Paper

Answer: Computerized Accounting System (CAS): An integrated software framework that processes financial transaction data according to GAAP, automatically updating ledgers and generating trial balances and financial statements. Primary Advantage: Speed, automated ledger posting with zero clerical mathematical errors, and instant financial reporting.

Answer: Chart of Accounts (COA): A structured, systematic listing of all financial accounts (Assets, Liabilities, Equity, Revenue, Expenses) utilized by an organization, indexed by unique numerical account codes for automated transaction classification.

Answer:

• Payment Voucher (F5 in Tally): Used to record all cash or bank outflow transactions (e.g., supplier payments, rent, salaries).
• Receipt Voucher (F6 in Tally): Used to record all cash or bank inflow transactions (e.g., collections from customers, interest received).

Answer: Automated BRS: A computerized feature that imports electronic bank statements (CSV/OFX) and programmatically matches bank transaction reference numbers with the internal cash ledger, isolating uncredited checks and unpresented drafts automatically.

Answer: Audit Trail: An immutable, chronological, tamper-evident digital record that logs every creation, modification, or deletion of a financial transaction, recording the user ID, timestamp, and previous transaction state to ensure accountability.

Architecture of an Accounting Information System (AIS)

A modern AIS operates as a specialized transaction processing system with four interconnected components:

1. Input Subsystem: Captures source documents digitally: Electronic Invoices, Purchase Orders, Debit/Credit Notes, Payroll timesheets, and Bank Feeds. Validates data formats, debtor credit limits, and tax codes before entry.
2. Processing Subsystem: The core accounting engine:
   • Enforces Double-Entry rules ($\sum \text{Debits} = \sum \text{Credits}$).
   • Executes real-time posting to General Ledgers, Sub-ledgers (Sundry Debtors, Sundry Creditors), and inventory records.
   • Calculates automatic Depreciation schedules, foreign exchange translation gains/losses, and Value Added Tax (VAT) input/output offsets.
3. Database Storage Subsystem: Relational database management tables organizing Chart of Accounts, fiscal calendars, historical transactions, and supplier registries with referential integrity.
4. Output Subsystem (Reporting): Generates real-time statutory and managerial statements: Trial Balance, Statement of Profit or Loss, Balance Sheet, Cash Flow Statement, Aging Analysis of Receivables, and VAT return schedules for tax filing.

Computerized VAT Accounting in Nepal (Tally ERP)

Under the Nepal Value Added Tax Act 2052, VAT is levied at a standard 13% rate:

1. Configuration in Accounting Software

• Enable VAT features in statutory configuration.
• Define VAT ledgers: Input VAT (Current Asset - paid on purchases) and Output VAT (Current Liability - collected on sales).

2. Accounting Entries and Voucher Recording

• Purchase with VAT (Purchase Voucher F9):
  • Debit: Purchase Account (Rs. 100,000)
  • Debit: Input VAT Account (Rs. 13,000)
  • Credit: Sundry Creditor / Bank (Rs. 113,000)
• Sale with VAT (Sales Voucher F8):
  • Debit: Sundry Debtor / Bank (Rs. 169,500)
  • Credit: Sales Account (Rs. 150,000)
  • Credit: Output VAT Account (Rs. 19,500)

3. Monthly VAT Settlement and Statutory Registers

• Net VAT Payable Computation:
  $$\text{Net VAT Payable} = \text{Output VAT} - \text{Input VAT} = 19,500 - 13,000 = \text{Rs. } 6,500$$
• Statutory Registers: Tally automatically compiles the formal Sales Register (Schedule 8) and Purchase Register (Schedule 9) mandated by the Inland Revenue Department (IRD).

Automated Inventory Accounting and Valuation Methods

1. Inventory Configuration in ERP

• Defining Stock Groups, Stock Categories, Units of Measure (e.g., Kg, Liters, Cartons), and Godowns / Warehouses.
• Automated generation of Goods Receipt Notes (GRN), Delivery Challans, and Reorder Level alerts.

---

2. Perpetual Inventory: FIFO vs. Weighted Average Costing

1. First-In, First-Out (FIFO):
   • Logic: The system assumes that items purchased earliest are issued to production or cost of goods sold (COGS) first.
   • Impact during Inflation: Ending inventory is valued at recent higher purchase costs, reflecting realistic market balance-sheet asset values; however, COGS is based on older lower costs, leading to higher reported net profits and higher income tax liabilities.
2. Weighted Average Cost (WAC):
   • Logic: The software recalculates the weighted moving average unit cost after every new inventory purchase receipt:
     $$\bar{C}_{new} = \frac{(\text{Prior Stock Units} \times \bar{C}_{old}) + (\text{New Units} \times \text{New Unit Cost})}{\text{Prior Stock Units} + \text{New Units}}$$
   • Impact: Smooths out short-term price fluctuations and price spikes; provides a stable, conservative COGS and inventory valuation.

Internal Controls and Security in Computerized Accounting

1. Segregation of Duties (SoD) via Software Permissions

• CAS eliminates single-point operational vulnerabilities by segmenting permissions:
  • The employee who creates a Purchase Order cannot approve the vendor invoice.
  • The cashier who inputs receipt vouchers cannot reconcile the monthly bank statement.
• Prevents fictitious vendor creation and unauthorized payments.

2. Technical and Logical Access Controls

• Role-Based Access Control (RBAC): Restricts ledger visibility and voucher posting rights strictly based on job roles.
• Mandatory Multi-Factor Authentication (MFA): Secures remote and on-premise accounting logins.
• Automated Exception Alerts: Software triggers email notifications to the Financial Controller when transactions exceed authorized financial limits.

3. Data Integrity and Business Continuity

• Automated Encrypted Backups: Daily encrypted snapshots mirrored to off-site cloud repositories (AWS S3) guarantee business continuity against ransomware and hardware crashes.
• Tamper-Evident Audit Logging: Any backdated modification or entry deletion is logged permanently with the user’s digital signature.

Comprehensive Accounting Case Solution: Annapurna Trading House

a) Chart of Accounts (COA) Numerical Coding Framework

A 5-digit hierarchical numerical coding system:

1. 10000 - Assets:
   • 11000: Current Assets
     • 11100: Cash and Bank Balances (11101: Nabil Bank Operating A/C, 11102: Petty Cash)
     • 11200: Accounts Receivable / Sundry Debtors (sub-ledger per wholesale dealer)
     • 11300: Finished Goods Inventory (categorized by electronics stock groups)
     • 11400: Input VAT Account
   • 12000: Non-Current Assets (12100: Warehouse Real Estate, 12200: Delivery Vehicles, 12300: Computer Hardware)
2. 20000 - Liabilities:
   • 21000: Current Liabilities (21100: Sundry Creditors/Suppliers, 21200: Output VAT Payable, 21300: TDS Payable)
   • 22000: Long-Term Debt (22100: Bank Term Loan)
3. 30000 - Equity:
   • 31000: Paid-Up Share Capital; 32000: Retained Earnings
4. 40000 - Revenue:
   • 41000: Wholesale Electronics Sales; 42000: Sales Discounts/Returns; 43000: Service & Repair Income
5. 50000 - Expenses:
   • 51000: Cost of Goods Sold (Purchases, Freight-in, Customs Clearance)
   • 52000: Administrative & Selling Expenses (Salaries, Rent, Depreciation, Advertising)

---

b) Cutover and Data Migration Procedure

1. Choose Migration Cutover Date: Select the close of a fiscal quarter or month-end (e.g., 32nd Ashad) to minimize transactions in flight.
2. Comprehensive Physical Stocktake and Cash Audit: Conduct a 100% physical count across all 8 godowns. Value physical inventory using Weighted Average Costing and write off the Rs. 8.5 million discrepancy into an extraordinary loss account.
3. Reconcile Sub-Ledgers: Obtain signed balance confirmation letters from all 120 wholesale dealers and major suppliers to verify opening debtor/creditor balances.
4. Draft and Verify Opening Balance Sheet: Input opening balances via an Opening Journal Voucher. Ensure $\sum \text{Opening Debits} = \sum \text{Opening Credits}$ before recording live daily transactions.
5. Parallel Running (30 Days): Operate the cloud ERP concurrently with legacy manual records for one complete monthly billing cycle. Compare trial balances; discontinue manual books only when variance is zero.

---

c) Automated Internal Control Workflows

1. Order-to-Cash (O2C) Automated Controls (Eliminating Phantom Stockouts):
   • Real-Time Stock Reservation: When a sales rep drafts a Sales Order, the ERP immediately reserves the stock units across the specific godown, changing status from ‘Available’ to ‘Allocated’. Other reps cannot sell allocated inventory.
   • Automated Credit Limit Check: The ERP blocks sales invoice generation if a dealer’s outstanding balance exceeds their approved credit limit or aging terms.
2. Procure-to-Pay (P2P) Three-Way Automated Matching:
   • The system automatically cross-checks: (1) Purchase Order, (2) Goods Receipt Note (GRN from warehouse), and (3) Supplier Tax Invoice.
   • Payment voucher generation is restricted unless quantities, unit prices, and VAT amounts match within 0.1% tolerance, eliminating supplier billing fraud.