Computer Based Financial Accounting

A computer is an electronic device that accepts data as input, processes it according to a set of stored instructions, stores the result, and gives the output in a useful form. It works on the IPO cycle — Input → Process → Output — and is fast, accurate, automatic and versatile.

Hardware is the physical, tangible component of a computer system that can be seen and touched — for example, the CPU, monitor, keyboard, mouse, and printer.

Input device is a hardware component that accepts data and instructions from the user and sends them to the computer for processing. For example: keyboard, mouse, scanner.

Primary memory vs Secondary memory

In short, primary memory is fast, costly and mainly volatile, while secondary memory is slower, cheaper and permanent.

Uses of Application Software (3 marks)

Application software is a set of programs designed to help the user perform specific tasks. Its main uses are:

1. Performing specific user tasks — It is developed to do particular jobs such as word processing (MS Word), spreadsheet calculation (MS Excel), presentation (MS PowerPoint), accounting (Tally), and photo or video editing. General-purpose packages like MS Office are used for documentation, data analysis, and reporting in offices and schools.

2. Supporting business and professional work — Business application software is used for accounting, payroll, inventory, billing, payroll, and customer management (e.g., payroll systems, ERP, and accounting packages). It increases accuracy, saves time, and helps management take decisions through reports and charts.

3. Communication and entertainment — Application software such as e-mail clients, web browsers, chat and video-conferencing apps (Zoom, Google Meet) is used for communication, while media players, games, and multimedia software are used for entertainment and education.

In short, application software makes the computer useful to the end user by turning hardware into a tool for work, communication, learning, and entertainment.

MIS (Management Information System) is a computer-based system that collects, processes, stores, and disseminates information to managers at different levels so that they can make timely, informed decisions and coordinate the activities of an organization.

In simple terms, MIS is the organized combination of people, hardware, software, communication networks, and data that provides routine reports (such as sales reports, inventory status, and payroll summaries) to support the day-to-day operations and managerial functions of a business.

Key points:

• It serves the middle-level management mainly, providing summary and exception reports.
• It converts raw data from internal sources (and sometimes external sources) into meaningful, structured information.
• Its outputs are usually periodic, pre-specified reports rather than ad-hoc queries.
• It supports planning, controlling, and decision-making, but does not itself make decisions.

MS-Excel in Financial Accounting and Reporting (6 marks)

MS-Excel is the most widely used spreadsheet tool in accounting practice. Its ways of helping in financial accounting and reporting are:

1. Recording and maintaining books of accounts — Transactions (journal entries) can be entered in tabular form with columns for date, particulars, voucher no., debit and credit. Built-in functions such as SUM, IF, and VLOOKUP allow automatic totalling and posting to ledger accounts.

2. Preparation of financial statements — Excel can prepare the Trial Balance, Trading Account, Profit & Loss Account and Balance Sheet. Cells are linked by formulas (e.g., =B5+C5), so when one figure changes, the whole statement updates automatically. This "what-if" capability makes it easy to revise estimates.

3. Ledger and subsidiary records — Debtors' and creditors' ledgers, inventory records, and depreciation schedules can be maintained in separate worksheets and linked to the main accounts.

4. Financial analysis and ratios — Ratio analysis (liquidity, profitability, solvency, turnover), trend analysis, and common-size/ comparative statements can be computed instantly using formulas. Tools like charts and conditional formatting highlight weak areas.

5. Budgeting, forecasting and variance analysis — Budgets are prepared in Excel and compared with actuals; variances (favourable/unfavourable) are calculated automatically. Functions like FV, PV, NPV, and IRR help in capital budgeting and investment appraisal.

6. Reporting and presentation — Excel offers formatting, sorting, filtering, PivotTables, and charts (bar, pie, line) to convert raw data into meaningful reports for management, banks, and tax authorities. Reports can be printed or exported to PDF/other formats.

Conclusion: Excel reduces manual drudgery, ensures accuracy through formulas, saves time, and supports quick decision-making. However, it must be used with proper controls (cell protection, backup, and audit checks) because a single wrong formula can misstate the whole report.

Enterprise Resource Planning (ERP) Systems — Benefits to Organizations

An ERP system is an integrated software package (e.g., SAP, Oracle, Microsoft Dynamics) that uses a single, centralized database to connect all functional areas of a business — finance, HR, production, inventory, sales, and customer service — into one unified platform. Its major benefits are:

1. Integration of business functions All departments work on one shared database, so data entered in one module (say, sales) is instantly available to others (accounts, inventory, production). This eliminates data duplication and inconsistency across departments.

2. Single source of truth / accurate, real-time information Because there is only one database, everyone sees the same up-to-date figures. Managers get reliable, real-time information for planning and control instead of reconciling conflicting reports from separate systems.

3. Improved decision-making ERP generates consolidated reports, dashboards, and analytics across the whole organization. Top management can make faster, better-informed strategic decisions on costs, profitability, and resource allocation.

4. Cost reduction and operational efficiency Automation of routine transactions (billing, payroll, purchase orders, stock updates) reduces manual labour, paperwork, and errors. Better inventory and production planning lowers carrying costs, wastage, and stock-outs.

5. Enhanced customer service With complete customer history, order status, and delivery information available instantly, staff can respond to customer queries quickly and accurately, improving satisfaction and loyalty.

6. Standardization of processes ERP enforces common, best-practice processes across all branches, units, and countries. This brings discipline, comparability, and easier compliance with laws, tax rules, and audit requirements.

7. Better coordination and communication Departments share information seamlessly instead of exchanging files and emails. Cross-functional workflows (e.g., order-to-cash, procure-to-pay) run smoothly, reducing delays and inter-departmental conflicts.

8. Scalability and flexibility ERP modules can be added or removed as the organization grows or enters new markets, supporting expansion without replacing the entire system.

9. Improved security and control Role-based access, audit trails, and centralized data storage protect sensitive business information and make internal control and fraud detection easier.

10. Competitive advantage Faster response to market changes, lower operating costs, and better customer service together give the firm an edge over competitors.

Conclusion: ERP transforms isolated departmental systems into an integrated, information-driven enterprise, improving efficiency, control, and decision-making — though these benefits are realized only with proper implementation, training, and management support.

Meaning of Accounting Software

Accounting software is a type of application program (computer software) designed to record, store, process, and report financial transactions of a business in an organised and systematic manner. It performs the routine accounting functions — such as recording journal entries, maintaining ledgers, preparing trial balance, and generating financial statements — automatically, accurately, and quickly. It replaces the manual book-keeping system, reduces clerical errors, ensures accuracy, and provides timely financial information to management for decision-making. Most accounting software also supports features like inventory management, payroll, taxation (VAT/TDS), billing, and bank reconciliation.

Description of Three Accounting Software

1. Tally ERP 9 / Tally Prime

Tally is one of the most widely used accounting software packages in Nepal and South Asia, developed by Tally Solutions Pvt. Ltd. (India). It is a multi-lingual, multi-currency, and double-entry accounting software that maintains journals, ledgers, trial balance, profit and loss account, and balance sheet automatically. It also supports inventory management, payroll, GST/VAT computation, banking, and generation of MIS reports. It is popular among small and medium-sized business firms in Nepal because it is easy to operate and can handle a large volume of transactions.

2. QuickBooks

QuickBooks is an accounting software developed by Intuit Inc. (USA). It is mainly designed for small and medium-sized enterprises and is available in both desktop and cloud-based (online) versions. It helps in recording income and expenses, invoicing customers, tracking debtors and creditors, managing bank accounts, preparing financial statements, and calculating taxes. Its user-friendly interface, automatic bank reconciliation, and cloud accessibility make it suitable for businesses that need real-time financial information from anywhere.

3. Tally-free alternatives — Busy Accounting Software

Busy is an accounting and business management software developed by Busy Infotech Pvt. Ltd. (India). It is a fully featured, double-entry, multi-currency accounting package used by trading and manufacturing firms. It offers accounting, inventory control, taxation (VAT, GST), payroll, and MIS reporting features. It is known for its speed, data security, and ability to manage multiple branches and godowns. It is a popular alternative to Tally among medium-sized business houses in Nepal.

4. Other commonly used software (brief)

• SAP (Systems, Applications and Products): An ERP (Enterprise Resource Planning) software used by large organisations; its FI (Financial Accounting) module handles all accounting functions.
• Swastik / Nepali accounting packages: Locally developed software such as Swastik, Tally-based Nepali versions, and IRIS are used in Nepal as they support Nepali fiscal year, VAT rules, and Nepali language.

Conclusion: Accounting software thus automates the whole accounting cycle, reduces errors and manual labour, ensures accuracy and timeliness of financial records, and helps management in planning, controlling, and decision-making.

Assumptions. (i) 10,000 shares at Rs 100 = Rs 10,00,000, deposited in the bank (the two contributors each put in Rs 5,00,000). (iii) Mortgaging the old building is only security for the loan, so no separate entry is made. (v) Commission and dividend received are income, increasing retained earnings. (vi) Salary expense is Rs 52,000 (Rs 40,000 paid, Rs 12,000 payable).

Check: Assets $=13{,}30{,}000+5{,}00{,}000+10{,}000=$ Rs 18,40,000. Liabilities + Equity $=6{,}00{,}000+2{,}62{,}000+10{,}00{,}000-22{,}000=$ Rs 18,40,000. The equation balances.

Assumptions. The question does not say how the computers, furniture and software were paid for, so all three purchases are treated as on credit (payables). Software inventory is unsold at year-end. Administrative expenses and the dividend are paid from the bank. Depreciation (10%) is charged on furniture only. Amounts in Rs.

1. Journal entries

(viii: all cash received is banked the same day, so the Bank account is used directly.)

2. T-accounts (balances)

3. Trial balance as at 31 Dec 2013

4. Income statement for the year ended 31 Dec 2013

Retained earnings $=2{,}32{,}000-50{,}000\text{ (dividend)}=1{,}82{,}000$.

5. Vertical balance sheet as at 31 Dec 2013

Excel work: Use separate sheets for Journal, T-accounts, Trial Balance, Income Statement and Balance Sheet. Link the later sheets to the earlier ones with cell formulae and use SUM for totals. Save the file as SKY_<Your Roll No> on the Desktop.