Computerised Accounting Software — OCN London Digital Functional Skills Qualification Digital Skills & IT Revision

    This element develops the practical skills needed to operate accounting software for routine business transactions. Learners will build competence in acces

    Topic Synopsis

    This element develops the practical skills needed to operate accounting software for routine business transactions. Learners will build competence in accessing, entering, and editing financial data, selecting appropriate tools and techniques to process transactions such as invoices, payments, and journals, and producing accurate accounting documents and summary reports that meet organisational requirements. Mastery enables efficient contribution to financial record-keeping and reporting in a modern office environment.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Computerised Accounting Software

    OCN LONDON
    vocational

    This element develops the practical skills needed to operate accounting software for routine business transactions. Learners will build competence in accessing, entering, and editing financial data, selecting appropriate tools and techniques to process transactions such as invoices, payments, and journals, and producing accurate accounting documents and summary reports that meet organisational requirements. Mastery enables efficient contribution to financial record-keeping and reporting in a modern office environment.

    11
    Learning Outcomes
    21
    Assessment Guidance
    23
    Key Skills
    10
    Key Terms
    25
    Assessment Criteria

    Assessment criteria

    OCNLR Level 2 Award in IT User Skills (ITQ)
    OCNLR Level 2 Certificate in IT User Skills (ITQ)
    OCNLR Level 2 Diploma in IT User Skills (ITQ)
    OCNLR Level 3 Diploma in IT User Skills (ITQ)
    OCNLR Level 1 Award in IT User Skills (ITQ)
    OCNLR Level 1 Certificate in IT User Skills (ITQ)

    Topic Overview

    The OCNLR Level 2 Award in IT User Skills (ITQ) is a vocational qualification designed to equip students with practical, transferable IT skills essential for the modern workplace. It covers a range of software applications and digital practices, including word processing, spreadsheets, databases, presentation software, and using the internet safely and effectively. This qualification is ideal for students who want to demonstrate competence in everyday IT tasks, whether for employment, further study, or personal development.

    This award is part of the IT User Skills suite, which is recognised by employers and educational institutions across the UK. It focuses on real-world application rather than theory, meaning students learn by doing. The qualification is flexible, allowing learners to choose units that match their interests or career goals. By completing this award, students gain a nationally recognised certification that validates their ability to use IT confidently and productively in a variety of contexts.

    In the wider subject of Digital Skills & IT, this qualification serves as a foundational stepping stone. It builds core competencies that are prerequisites for more advanced studies, such as the Level 3 Diploma in IT or specialised certifications in areas like cybersecurity or data analysis. Moreover, it aligns with the UK government's digital skills agenda, addressing the growing demand for a digitally literate workforce. Students who master these skills are better prepared for the digital demands of almost any job role.

    Key Concepts

    Core ideas you must understand for this topic

    • →File management: organising, saving, and retrieving files in appropriate formats and locations, including understanding folder structures and file extensions.
    • →Word processing: creating, formatting, and editing documents using features like styles, tables, headers/footers, and mail merge.
    • →Spreadsheets: using formulas (SUM, AVERAGE, IF), functions, cell references, charts, and data sorting/filtering to analyse and present data.
    • →Presentation software: designing slides with consistent themes, adding multimedia elements, and using transitions/animations effectively.
    • →Safe internet use: evaluating online sources for reliability, protecting personal data, and understanding copyright and plagiarism.

    Learning Objectives

    What you need to know and understand

    • Access, enter and edit accounting information, Select and use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Access, enter and edit accounting information, Use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Access, enter and edit accounting information, Select and use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Access, enter and edit accounting information, Process business transactions from source documents, Develop and interpret management information reports, Set up a computerised accounting system ready for use
    • Access, enter and edit accounting information, Use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Demonstrate the ability to access and navigate accounting software to locate relevant modules.
    • Enter and edit accounting transactions accurately using appropriate data fields.
    • Select appropriate software tools to process common business transactions such as sales and purchases.
    • Utilise automated functions to calculate totals and taxes.
    • Produce standard accounting documents including invoices and receipts using the software.
    • Generate and interpret summary reports such as trial balance and customer statements as per given requirements.

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Award credit for demonstrating accurate data entry with verification checks, such as double-keying or on-screen review, ensuring no transposition errors.
    • Evidence of selecting and using appropriate software tools (e.g., sales ledger, purchase ledger, bank reconciliation) to process a range of business transactions.
    • Production of accounting documents and summary reports (e.g., trial balance, profit and loss statement, aged debtors/creditors) that are formatted correctly and meet the given specification.
    • Demonstration of editing and correcting entries using proper adjustment techniques (e.g., reversing journals, correcting posting errors) with a clear audit trail.
    • Award credit for demonstrating accurate entry of accounting information, including correct classification of income and expenditure categories.
    • Award credit for using appropriate software tools to reconcile bank transactions effectively.
    • Award credit for generating a trial balance that balances and accurately reflects all transactions.
    • Award credit for demonstrating accurate navigation of the software interface to access existing accounts and ledgers.
    • Award credit for entering financial transactions (e.g., sales, purchases, receipts) with correct coding and dates, and for making amendments without data corruption.
    • Award credit for selecting and applying appropriate processing techniques such as journal entries, bank reconciliation, or VAT adjustments to complete the accounting cycle.
    • Award credit for producing required documents (e.g., trial balance, profit and loss statement, balance sheet) that are complete, arithmetically correct, and formatted to specification.
    • Award credit for ensuring outputs meet given requirements, such as using correct report parameters, date ranges, and layout.
    • Award credit for demonstrating accurate setup of a new company file, including chart of accounts, VAT settings, and opening balances in a logical sequence.
    • Credit should be given for correctly processing a range of business transactions (e.g., sales invoices, purchase orders, bank payments) from source documents, ensuring correct nominal coding and customer/supplier allocation.
    • For management reports, expect interpretation that shows analysis beyond simple generation: identify trends, variances, and implications for business performance, not just a description of numbers.
    • Award credit for clearly demonstrating the ability to successfully open the accounting software and navigate to the correct modules for data entry, such as sales invoices or purchase records.
    • Look for accurate data entry, including correct use of customer/vendor accounts, nominal codes, and tax implications, without leaving fields incomplete or inappropriately blank.
    • Assess the candidate's use of software tools (e.g., post, save, search) to process transactions, ensuring the workflow from entry to final posting is completed correctly.
    • When producing summary reports, award credit for selecting the appropriate report type for the requirement (e.g., profit and loss, aged debtors) and outputting it with the correct date range and format.
    • Evidence of correct login and file access procedures.
    • Accurate input of transaction details with no data errors.
    • Demonstrated use of drop-down menus and shortcuts for efficiency.
    • Correct application of VAT or tax settings where applicable.
    • Outputs match the required format and layout as specified in the assessment brief.
    • Ability to edit previously entered data and correct mistakes.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always complete a trial balance after entering transactions to ensure the fundamental double-entry equation balances before generating final reports.
    • 💡Use help functions and on-screen prompts within the software to confirm correct transaction codes and VAT treatment where applicable.
    • 💡When producing summary reports, double-check that date ranges and criteria match the task requirements exactly, as often marks are lost on incorrect parameters.
    • 💡Practise with realistic sample data that includes common errors such as duplicate entries or missing invoices, to build confidence in troubleshooting.
    • 💡Always verify data entry by comparing against original source documents before processing.
    • 💡Use the software's built-in validation features (e.g., automatic reconciliation, error prompts) to catch mistakes early.
    • 💡Tailor reports to the specific requirements of the assessment task, ensuring they include all necessary details like date ranges and comparison periods.
    • 💡Always use the software's built-in validation and checking tools (e.g., trial balance summary) to verify accuracy before generating final reports.
    • 💡Read assignment scenarios carefully and identify all required outputs before starting data entry to avoid missing key documents.
    • 💡Practice common transaction scenarios repeatedly to build speed and confidence in navigating menus and selecting the right tools.
    • 💡Keep an evidence log as you work, capturing screenshots of key steps to demonstrate your process to the assessor.
    • 💡Practice processing transactions from a variety of source documents (invoices, receipts, bank statements) to build speed and accuracy, and always check that the software automatically calculates VAT correctly.
    • 💡When interpreting reports, always refer to specific figures and explain what they mean for the business (e.g., cash flow implications, profitability trends) rather than just describing the report layout.
    • 💡In setup tasks, follow a checklist: define fiscal year, set tax codes, create chart of accounts, enter opening balances, and assign user permissions—missing steps often lead to errors in later tasks.
    • 💡For the practical assessment, read the task brief carefully to identify exactly which documents and reports are required, and plan your sequence of entries to work efficiently.
    • 💡Use the software's help features or standard operating procedures to verify account codes and transaction steps if unsure, but do not guess as errors can cascade.
    • 💡At the end of the session, double-check that all required documents are printed or saved as evidence, with your name and date where appropriate, to demonstrate full completion of the requirements.
    • 💡Practice generating different types of reports from sample data to understand which reports serve which business purpose, so you can quickly select the right one in the exam.
    • 💡Practice using shortcut keys to speed up data entry tasks during timed assessments.
    • 💡Always cross-reference your report figures with manual calculations to ensure the software has processed them correctly.
    • 💡Read the task brief carefully to identify exactly which documents and reports are required, noting any specific layouts or company details to include.
    • 💡Always read the task instructions carefully. Many students lose marks by missing small details, such as specific file formats (e.g., .docx vs .pdf) or exact cell references in spreadsheets.
    • 💡Practise using keyboard shortcuts (Ctrl+C, Ctrl+V, Ctrl+Z) to save time during assessments. This shows efficiency and allows you to focus on the task rather than mouse clicks.
    • 💡For presentation units, remember that less is more. Use bullet points, not paragraphs, and ensure your slides are visually balanced. Examiners look for clear communication, not flashy effects.

    Common Mistakes

    Common errors to avoid in your coursework

    • Misclassifying accounts, such as posting capital expenditure to an expense account, leading to incorrect profit calculations.
    • Failing to perform or reconcile bank transactions with the cash book, resulting in unresolved discrepancies in reports.
    • Neglecting to back up data or save work at regular intervals, risking loss of all entries.
    • Overlooking the need to set up accurate company financial periods and default tax codes before entering transactions, causing systemic errors in reports.
    • Misclassifying account codes, such as entering a capital expense as a revenue expense.
    • Forgetting to apply or incorrectly applying VAT to transactions.
    • Generating reports without first checking for data entry errors, leading to unbalanced accounts.
    • Confusing the cash basis and accrual basis of accounting when entering revenue or expenses, leading to incorrect period reporting.
    • Posting transactions to the wrong nominal codes or periods, causing imbalances in the trial balance.
    • Not saving or backing up work regularly, resulting in lost data and incomplete evidence.
    • Using incorrect or inconsistent reconciliation techniques, leaving unexplained discrepancies.
    • Failing to produce all required reports or submitting them in a format other than that specified by the brief.
    • Misunderstanding the difference between cash and accrual basis and selecting the wrong accounting method during setup, leading to incorrect financial reports.
    • Entering transactions without linking to the correct nominal codes or customer/supplier accounts, resulting in inaccurate balances and reports.
    • Failing to set appropriate security or access levels when setting up the system, leaving the accounting data vulnerable to unauthorised changes.
    • Confusing the debit and credit sides when entering transactions, leading to inaccurate financial records.
    • Neglecting to reconcile or check for missing transactions before generating reports, resulting in incomplete summaries.
    • Using incorrect account codes, such as posting a purchase to a sales category, which distorts financial reporting.
    • Failing to save or backup work at crucial points, risking loss of entered data and requiring rework.
    • Confusing debits and credits when entering transactions.
    • Failing to save or backup work regularly, leading to data loss.
    • Misinterpreting the requirements document, such as using the wrong date format or currency.
    • Overlooking the need to check generated reports for accuracy against original data.
    • Misconception: 'Spreadsheet formulas are too hard; I'll just calculate manually.' Correction: Formulas are essential for efficiency and accuracy. Start with simple arithmetic (e.g., =A1+B1) and build up. The software does the hard work for you.
    • Misconception: 'I don't need to save versions; one file is enough.' Correction: Always save multiple versions (e.g., 'Report_v1', 'Report_v2') to avoid losing work and to track changes. This is crucial for coursework and professional projects.
    • Misconception: 'Using lots of different fonts and colours makes my work look good.' Correction: Consistency is key. Stick to one or two fonts and a simple colour scheme. Overcomplicating design distracts from content and can lose marks.

    Frequently Asked Questions

    Common questions students ask about this topic

    Before You Start

    Prior knowledge that will help with this topic

    • •Basic computer literacy: ability to turn on a computer, use a mouse and keyboard, and open/close applications.
    • •Familiarity with the Windows or macOS operating system, including managing windows and using the start menu or dock.
    • •Understanding of file types (e.g., .docx, .xlsx, .pptx) and how to save and open files.

    Key Terminology

    Essential terms to know

    • Access, enter and edit accounting information, Select and use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Access, enter and edit accounting information, Use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Access, enter and edit accounting information, Select and use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Access, enter and edit accounting information, Process business transactions from source documents, Develop and interpret management information reports, Set up a computerised accounting system ready for use
    • Access, enter and edit accounting information, Use tools and techniques to process business transactions, Produce accounting documents and summary reports to meet requirements
    • Accurate Data Entry
    • Transaction Processing Techniques
    • Accounting Document Production
    • Software Tool Selection
    • Reporting for Business Requirements

    Ready to learn?

    AI-powered learning tailored to this unit

    Related Topics in OCN LONDON vocational Digital Skills & IT

    Essential Digital Skills for Everyday Life

    View Topic

    Essential Digital Skills for Everyday Life

    View Topic

    Audio Software

    View Topic

    Audio Software

    View Topic