Computer Applications in Accounting and Office Work
This domain checks that you can operate accounting software, build simple spreadsheets and handle digital office tasks safely. Questions are practical: voucher selection, report names, formulas and file handling.
Accounting software
- Standard features: double-entry engine, groups and ledgers, voucher entry, automatic GST calculation, reconciliation, MIS reports, data backup and an audit trail (compulsory for companies from FY 2023-24).
- Voucher types: Payment, Receipt, Contra, Journal, Sales, Purchase, Credit Note and Debit Note. Cash deposited into the bank is Contra - it changes two asset accounts and never touches profit.
- In Tally, masters come before vouchers: create the ledger under the right group, tick GST details, then pass entries. Reports: Day Book, Trial Balance, Profit and Loss, Balance Sheet, GST summary.
Spreadsheets
- Relative references shift when copied; absolute references with ₹ signs stay fixed. Core functions: SUM, AVERAGE, IF, VLOOKUP, PMT, ROUND.
Worked example
Quantity in A2, a fixed GST rate of 12% in B1. The formula =ROUND(A2*(1+$B$1/100),2) gives the invoice value. The ₹ before B and before 1 locks the rate cell, so dragging the formula down recalculates each quantity against the same rate. Writing B1 without ₹ would pull the rate down the column and produce wrong totals from row 3 onward.
Traps
- Passing a credit sale through a Payment voucher, which corrupts the debtors' ledger.
- Deleting a wrong entry instead of cancelling it with a credit or debit note - the audit trail breaks.
- Saving over the only copy: keep a dated backup, ideally off the machine as well.
- Forgetting to activate GST in the ledger, so the invoice prints without tax.
- Typing numbers as text, which makes SUM return zero.