Computerized Accounting: Systems, Software & Automation

TAKEAWAYS:

• Computerized accounting replaces manual journals/ledgers with software like Tally, QuickBooks, or ERP systems (e.g., SAP for hotels).
• Automation (e.g., bank reconciliation, payroll) reduces errors but requires cybersecurity measures like encryption and audit trails.
• Cloud accounting (e.g., Xero, Zoho Books) enables real-time collaboration for franchised travel agencies or multi-location hotels.
• Data analytics in hospitality (e.g., Pathao’s ride-sharing revenue reports) turns raw transactions into actionable insights.
• Compliance with Nepal’s Income Tax Act (2058) and Company Act (2063) mandates digital record-keeping for businesses over NPR 5 million turnover.
• Disadvantages (e.g., software costs, training needs) must be weighed against benefits like speed and accuracy.

1. What Is Computerized Accounting?

Computerized accounting uses software to automate:

• Journal entries (e.g., recording a Kathmandu hotel’s room service sales).
• Ledger postings (e.g., updating Nepal Airlines’ fuel expenses).
• Financial statements (e.g., Daraz’s monthly profit/loss reports).
• Payroll (e.g., NTC employees’ salary disbursements via eSewa).

Why? Manual methods are slow, error-prone, and non-scalable for businesses like Pathao (handling 100K+ daily transactions).

2. Key Components of Computerized Accounting Systems

A. Hardware & Software

B. Data Security Measures

flowchart TD
    A["User Input\n(e.g., eSewa payment entry)"] --> B["Encryption\n(AES-256 for data at rest)"]
    B --> C["Firewalls\n(Block unauthorized access)"]
    C --> D["Audit Trails\n(Log every change, e.g., Ncell billing adjustments)"]
    D --> E["Backup Systems\n(Cloud + local, e.g., Daraz’s daily backups)"]
    E --> F["Compliance\n(GDPR, Nepal’s IT Act 2008)"]

Real Example:

• Khalti uses tokenization (replacing card numbers with tokens) to secure online payments for Nepal’s travel bookings (e.g., Helambu Lodge reservations).

3. How Computerized Accounting Works: A Step-by-Step Trace

Use this workflow for a Kathmandu-based tour operator (e.g., Everest Views Travels):

Step 1: Data Entry

• Source: POS terminal (e.g., Thamel café sales) or online booking system (e.g., TrekkingPermit.com).
• Action: Software (e.g., Tally) auto-categorizes transactions:
  • Debit: Cash at Bank (NPR 50,000)
  • Credit: Sales Revenue (NPR 50,000)

Step 2: Processing

• Automated Journal Entry:

Step 3: Posting to Ledger

• Ledger Account (Sales Revenue):

  Date	Particulars	Dr (NPR)	Cr (NPR)
  2023-10-15	To Cash at Bank		50,000
  Total		0	50,000

Step 4: Reconciliation

• Bank Statement vs. Software Record:
  • Discrepancy Found: NPR 2,000 unrecorded deposit (e.g., Ncell top-up via eSewa).
  • Action: Software flags it; accountant investigates.

Step 5: Reporting

• Automated Financial Statements:
  • Profit & Loss Statement: Shows gross profit margin for Everest Views’ trekking packages.
  • Balance Sheet: Lists current assets (e.g., cash at bank: NPR 250,000).

4. Software Comparison for Tourism/Hospitality

5. Advantages and Disadvantages

Advantages

• Speed: Pathao processes 10,000+ transactions/hour without manual errors.
• Accuracy: Reduces arithmetic mistakes in ledgers (e.g., Nepal Rastra Bank’s audit findings drop by 40%).
• Scalability: Daraz handles 1 million orders/month with automated inventory updates.
• Analytics: Google Trends + QuickBooks helps trekking agencies predict peak seasons.
• Compliance: eSewa auto-generates tax filings for Nepal’s VAT Act (2075).

Disadvantages

• Cost: SAP implementation for a 5-star hotel can cost NPR 10–20 million.
• Training: Staff at local guesthouses may resist learning Tally.
• Downtime Risk: Power cuts in Nepal can disrupt cloud-based systems (e.g., Khalti outages during Dasain).
• Data Security: Cyberattacks (e.g., ransomware on NTC’s systems) threaten financial data.

6. Real-World Applications in Nepal

Example 1: eSewa’s Transaction Tracking

• Idea Used: Real-time journal entries + reconciliation.
• How?
  • When you book a Lumbini tour via eSewa, the system:
    1. Debits your wallet (NPR 10,000).
    2. Credits the tour operator’s account.
    3. Auto-generates a receipt with GST breakdown (13% for services).
  • Audit Trail: eSewa logs every transaction for Nepal Rastra Bank’s oversight.

Example 2: Daraz’s Inventory Management

• Idea Used: Automated ledger + inventory control.
• How?
  • When Daraz sells a trekking backpack for NPR 15,000:
    1. Sales Journal: Debit Cash at Bank (NPR 15,000), Credit Sales Revenue.
    2. Inventory Ledger: Auto-updates stock levels (no manual counting).
    3. Cost of Goods Sold (COGS): Deducts NPR 8,000 (purchase cost) from revenue.
  • Result: Gross profit = NPR 7,000 per unit.

Example 3: Hotel Property Management Systems (PMS)

• Idea Used: Integration of accounting + operations.
• How?
  • Yeti Mountain Home uses Hotelogix:
    • Front Desk: Guest checks in → auto-creates an invoice.
    • Housekeeping: Room status updates → triggers maintenance ledger entries.
    • Accounts: End-of-day bank reconciliation with Nabil Bank.
  • Outcome: 30% faster financial close than manual methods.

7. Worked Example: Kathmandu Café’s Monthly Accounting

Scenario: Thamel Café (owned by a TU student) uses QuickBooks Online to track:

• Cash sales: NPR 800,000
• Credit card sales (via Khalti): NPR 300,000
• Expenses:
  • Rent: NPR 150,000
  • Food inventory: NPR 200,000
  • Salaries: NPR 250,000

Step 1: Record Sales (Automated Journal Entry)

Step 2: Record Expenses

Step 3: Generate Trial Balance

Step 4: Profit & Loss Statement

| **Particulars**           | **Amount (NPR)** |
|---------------------------|------------------|
| **Sales Revenue**         | 1,100,000        |
| **Less: Expenses**        |                  |
| - Rent                   | (150,000)        |
| - Food Inventory         | (200,000)        |
| - Salaries               | (250,000)        |
| **Gross Profit**          | **500,000**      |
| **Net Profit**            | **500,000**      | *(No other expenses)* |

Step 5: Bank Reconciliation

• Bank Statement Balance: NPR 1,200,000
• Software Balance: NPR 1,100,000
• Discrepancy: NPR 100,000 (unrecorded Ncell top-up via eSewa).
• Action: Add missing entry to Cash Receipts Journal.

8. Challenges and Solutions in Nepal

9. Exam Tip: How to Score Full Marks

1. Define Key Terms Precisely:

   • ERP: "Enterprise Resource Planning software that integrates accounting, HR, and operations (e.g., SAP for hotels)."
   • Cloud Accounting: "Hosted on remote servers (e.g., Xero) for real-time access."

2. Compare Software with Examples:

   • "Unlike Tally (best for small businesses), QuickBooks offers multi-currency support—useful for Sita Air’s international ticket sales."

3. Use Real-World Scenarios:

   • "eSewa’s transaction journal entries must comply with Nepal’s Payment Systems Act (2063) to avoid penalties."

4. Draw Diagrams:

   • Sketch a mermaid flowchart of the accounting cycle (see below) or a t-account for ledger entries.

5. Highlight Compliance:

   • *"Under Nepal’s Income Tax Act (2058), businesses over NPR 5M must use digital invoicing—failures result in 2% monthly penalties."*

6. Calculate Numerical Examples:

   • "If Thamel Café’s QuickBooks shows a NPR 100,000 discrepancy with the bank statement, explain how to reconcile it (e.g., unrecorded deposits or bank fees)."

flowchart LR
    A["Start\n(Manual Entry\nor POS Input)"] --> B["Software\n(Tally/QuickBooks)"]
    B --> C["Automated\nJournal Entry"]
    C --> D["Post to Ledger"]
    D --> E["Trial Balance\nCheck Dr=Cr"]
    E --> F["Bank Reconciliation"]
    F --> G["Financial Statements\n(P&L, Balance Sheet)"]
    G --> H["Audit Trail\n(GST/VAT Filings)"]
    H --> I["End\n(Cloud Backup)"]