Process routine payments and receipts using a computerised system — Pearson EDI Vocationally-Related Qualification Accounting & Finance Revision

    This subtopic focuses on the accurate recording and management of routine financial transactions within a computerised accounting environment, covering key

    Topic Synopsis

    This subtopic focuses on the accurate recording and management of routine financial transactions within a computerised accounting environment, covering key processes such as petty cash, non-credit payments, salary journals, and bank reconciliation. Mastery of these tasks ensures the integrity of financial data and supports the production of reliable reports for decision-making.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Process routine payments and receipts using a computerised system

    PEARSON EDI
    vocational

    This subtopic focuses on the accurate recording and management of routine financial transactions within a computerised accounting environment, covering key processes such as petty cash, non-credit payments, salary journals, and bank reconciliation. Mastery of these tasks ensures the integrity of financial data and supports the production of reliable reports for decision-making.

    7
    Learning Outcomes
    5
    Assessment Guidance
    7
    Key Skills
    6
    Key Terms
    7
    Assessment Criteria

    Assessment criteria

    EDI Level 2 Award in Computerised Book-keeping Skills (QCF)

    Topic Overview

    The EDI Level 2 Award in Computerised Book-keeping Skills (QCF) introduces you to the practical use of accounting software to record financial transactions. This qualification covers essential tasks such as setting up a computerised accounting system, processing customer and supplier transactions, and reconciling bank accounts. It is designed for those who wish to develop hands-on skills in book-keeping using popular software packages like Sage or QuickBooks, which are widely used in UK businesses.

    Mastering computerised book-keeping is crucial because most modern businesses rely on software to manage their finances efficiently. This award not only teaches you how to input data accurately but also how to generate reports like trial balances and aged debtor/creditor listings. These skills are directly applicable to roles such as accounts assistant, bookkeeper, or payroll clerk, and provide a solid foundation for further study in accounting.

    Within the wider subject of Accounting & Finance, this qualification bridges the gap between manual book-keeping and fully integrated accounting systems. It emphasises accuracy, data integrity, and the ability to troubleshoot common errors. By the end of the course, you will be able to maintain a computerised book-keeping system up to the trial balance stage, ensuring you are job-ready for entry-level finance positions.

    Key Concepts

    Core ideas you must understand for this topic

    • →Setting up a new company and chart of accounts: You must know how to create a new business file, enter opening balances, and customise the nominal ledger to match the business's structure.
    • →Processing sales and purchase invoices: Accurately recording credit transactions, including VAT calculations, and understanding the difference between cash and credit sales.
    • →Bank reconciliation: Matching the software's bank account balance to the bank statement, identifying discrepancies such as unpresented cheques or bank charges.
    • →Generating reports: Producing a trial balance, aged debtor/creditor reports, and VAT returns to verify the accuracy of the data entered.
    • →Correcting errors: Using methods like journal entries or delete/amend functions to fix mistakes without disrupting the audit trail.

    Learning Objectives

    What you need to know and understand

    • Enter and restore financial data using a computerised accounting package
    • Process petty cash payments and receipts accurately within the system
    • Record non-credit payments and receipts, ensuring correct allocation to nominal codes
    • Identify and correct transaction errors using appropriate audit trails
    • Prepare and post salary journals incorporating gross pay, deductions, and employer costs
    • Perform a full bank reconciliation between system records and bank statements
    • Generate bespoke reports applying selection criteria and parameters

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Award credit for demonstrating the ability to back up and restore data without corruption or loss.
    • Ensure petty cash vouchers are correctly coded and entered, with any imbalances investigated and resolved.
    • All non-credit transactions must be allocated to correct supplier accounts and nominal codes.
    • Demonstrate the use of suspicious accounts or journal adjustments to correct errors, preserving the original transaction for audit purposes.
    • Salary journal must include gross pay, employee and employer NI, and PAYE, correctly posted to the nominal ledger.
    • Identify and record unpresented cheques and outstanding deposits, and investigate any discrepancies between the bank statement and system balance.
    • Produce a report filtered by date range and cost centre, verifying totals against control accounts.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always verify the trial balance after entering a batch of transactions to identify discrepancies early.
    • 💡Tick off each item systematically on the bank statement against the system records during reconciliation.
    • 💡Use the payroll summary to prepare salary journals and double-check the net pay control account.
    • 💡Employ the software's search and filter functions to locate transactions quickly when correcting errors.
    • 💡Allocate time in the assessment to demonstrate backup and restoration procedures, as these are frequently examined.
    • 💡Always check your VAT calculations: Many marks are lost due to incorrect VAT treatment. Ensure you know the standard rate (20%) and when to use zero-rated or exempt codes.
    • 💡Use the software's built-in reports to verify your work: Before finalising, run a trial balance and check it balances. Also, print an audit trail to show the examiner your steps.
    • 💡Practice entering transactions in the correct order: For example, enter opening balances first, then sales/purchases, then payments/receipts, and finally bank reconciliation. This logical sequence prevents errors.

    Common Mistakes

    Common errors to avoid in your coursework

    • Failing to create a backup before restoring data, risking data loss.
    • Not reconciling the petty cash float frequently, leading to unexplained differences.
    • Posting non-credit payments to wrong supplier accounts due to errors in supplier selection.
    • Deleting original erroneous transactions instead of posting correcting entries, destroying the audit trail.
    • Omitting employer's National Insurance contributions from the salary journal.
    • Misinterpreting timing differences as errors during bank reconciliation, such as classifying unpresented cheques as mistakes.
    • Selecting incorrect date ranges or filters when generating reports, thus omitting or including extraneous transactions.
    • Misconception: 'Computerised book-keeping means I don't need to understand double-entry.' Correction: You still need to grasp double-entry principles because the software automates the posting, but you must know which accounts to debit and credit to enter transactions correctly.
    • Misconception: 'Once data is entered, it's always correct.' Correction: Data entry errors (e.g., wrong amounts, incorrect VAT codes) are common. You must regularly reconcile and review reports to catch mistakes.
    • Misconception: 'Bank reconciliation is just ticking off items.' Correction: It requires understanding timing differences and adjusting entries for items like bank charges or direct debits that appear only on the statement.

    Frequently Asked Questions

    Common questions students ask about this topic

    Before You Start

    Prior knowledge that will help with this topic

    • •Basic understanding of double-entry book-keeping (debits and credits).
    • •Familiarity with manual book-keeping concepts such as ledgers, trial balance, and VAT.
    • •Basic computer literacy, including using a keyboard and mouse, and navigating software menus.

    Key Terminology

    Essential terms to know

    • Data entry and restoration
    • Petty cash processing
    • Non-credit transaction management
    • Error identification and correction
    • Salary journal adjustments
    • Bank reconciliation procedures

    Ready to learn?

    AI-powered learning tailored to this unit

    Related Topics in PEARSON EDI vocational Accounting & Finance

    Carry out stock control processes using a computerised system

    View Topic

    Process routine payments and receipts using a computerised system

    View Topic

    Setting up accounting software to manage accounting information

    View Topic