Computerised Accounting Software — Skills and Education Group Awards Vocationally-Related Qualification Digital Skills & IT Revision
This element focuses on the foundational skills needed to operate computerised accounting software for day-to-day financial record-keeping. Learners will d
Topic Synopsis
This element focuses on the foundational skills needed to operate computerised accounting software for day-to-day financial record-keeping. Learners will develop the ability to accurately input and modify financial data, utilize software functions to process common transactions like invoices and payments, and generate standard reports such as trial balances and profit statements. Mastery of these skills enables efficient management of business finances and supports compliance with organisational requirements.
Key Concepts & Core Principles
- File Management: Understanding how to create, save, organise, and retrieve files and folders using appropriate naming conventions and directory structures.
- Word Processing: Using software like Microsoft Word to format text, insert images, create tables, and apply styles to produce professional documents.
- Spreadsheets: Entering data, using basic formulas (SUM, AVERAGE), formatting cells, and creating simple charts to present numerical information.
- Email and Communication: Sending, receiving, and organising emails, attaching files, and understanding email etiquette and security (e.g., recognising phishing attempts).
- Internet Safety: Knowing how to protect personal data, identify secure websites (HTTPS), use strong passwords, and understand the risks of sharing information online.
Exam Tips & Revision Strategies
- Always verify the data you enter against original source documents to prevent keying errors; many marks are lost due to simple typos.
- Use the software’s built-in validation tools, such as error checklists or data integrity reports, before finalising your work.
- When producing reports, ensure the date range exactly matches the period of the transactions you processed; this is a common pitfall in assessments.
- Double-check that the trial balance totals are equal before printing or submitting evidence, and investigate any discrepancies immediately.
- Always begin by checking the existing chart of accounts and understanding which codes to use for common transactions; refer to a provided list if available.
- When entering batch transactions, use the software’s validation features (e.g., duplicate detection, warnings) to minimise errors before posting.
- Before printing or submitting reports, run a data verification check (e.g., aged creditors balance) to ensure all transactions have been entered and the system is in balance.
Common Misconceptions & Mistakes to Avoid
- Entering transactions to the wrong ledger or nominal code, leading to misstated financial reports.
- Forgetting to flag or incorrectly applying VAT codes to transactions, causing compliance issues.
- Failing to use the software’s reconciliation tool properly, resulting in unreconciled items and an inaccurate cash position.
- Not checking that reports balance before submission, such as a Trial Balance where debit and credit totals do not match.
- Confusing debit and credit entries, e.g., posting a cash sale as a debit to sales and credit to cash, leading to reversed balances.
- Overlooking the need to set the correct financial year or period, resulting in transactions posted to a locked or incorrect period.
Examiner Marking Points
- Award credit for correctly logging into the software, navigating to the appropriate ledgers, and entering data such as supplier invoices or customer payments with complete accuracy in fields like date, amount, and account code.
- Assess ability to apply VAT codes correctly, allocate transactions to nominal accounts, post bank payments and receipts, and use the reconciliation tool to match transactions to bank statements.
- Credit the production of a Trial Balance, Profit and Loss report, and aged debtor/creditor reports that are balanced and meet specified criteria, with accurate selection of date ranges and report parameters.
- Award credit for accurate creation and amendment of customer, supplier, and nominal ledger accounts, ensuring data is complete and consistent with source documents.
- Credit is given when the learner correctly processes a purchase invoice, including accurate coding to the relevant expense account and applying the correct VAT treatment, and then successfully records the supplier payment.
- The learner must produce a trial balance and a summarized profit and loss report that reflects all transactions entered, with no arithmetic or posting errors, and present them in a clear, professional format.