Using a computerised accounting application
This element equips learners with the practical skills to operate a computerised accounting package for routine financial transactions. It covers entering sales and purchase data, processing customer and supplier invoices alongside credit notes, handling payments, correcting errors, and performing a bank reconciliation. Learners also maintain petty cash, generate customised reports, and apply basic data protection and security principles, ensuring accurate financial records and compliance in a business environment.
Assessment criteria
Quick Revision Summary (Key Takeaway)
The VTCT Skills Level 1 Award in Computerised Accounting for Business (RQF) introduces learners to the fundamental principles of computerised accounting, focusing on the use of accounting software to record financial transactions, maintain ledgers, and produce reports. It covers setting up a computerised accounting system, processing customer and supplier transactions, and understanding the role of accounting in business.
Topic Overview
Computerised accounting is the use of software to record, process, and report financial transactions. This qualification introduces students to the core functions of accounting software, including setting up a company, creating a chart of accounts, and processing sales and purchase transactions. It emphasises accuracy, data integrity, and the importance of maintaining an audit trail.
The course covers essential skills such as entering opening balances, processing customer and supplier invoices, credit notes, and payments, and producing reports like the trial balance and aged debtor/creditor summaries. Students learn how to use software to streamline accounting processes, reduce errors, and provide timely financial information for decision-making.
This award is a stepping stone for further study in accounting, such as the Level 2 Certificate in Computerised Accounting. It also provides practical skills valued by employers, as most businesses use accounting software like Sage, QuickBooks, or Xero. Understanding computerised accounting is crucial for anyone pursuing a career in finance or business administration.
Key Concepts
Core ideas you must understand for this topic
- →Double-entry bookkeeping: every transaction has a debit and credit entry, and computerised systems automate this.
- →Sales and purchase ledgers: track transactions with customers and suppliers, including invoices, credit notes, and payments.
- →Bank reconciliation: comparing the cash book with the bank statement to identify and explain differences.
- →Trial balance: a list of all account balances at a point in time, used to check the accuracy of the ledger.
- →Audit trail: the ability to trace transactions from source documents to final reports, ensuring data integrity.
Learning Objectives
What you need to know and understand
- Be able to enter data into a Computerised Accounting Package, Be able to record customer and supplier invoices and credit notes, Be able to process payments received from customers and made to suppliers, Be able to correct transaction errors, Be able to carry out a bank reconciliation, Be able to prepare and produce financial documents to be sent to credit customers, Be able to maintain the petty cash account, Be able to produce reports using selection criteria and parameters, Be able to identify simple data protection, storage and security issues
Assessment Criteria
Key criteria assessors look for in your portfolio
- Award credit for accurately entering a supplier invoice with correct date, amount, tax code, and supplier details, as evidenced in software logs or screenshots.
- Award credit for performing a bank reconciliation by correctly identifying and matching all transactions, and clearly documenting any outstanding items, with the reconciled balance matching the bank statement.
- Award credit for producing a credit customer statement of account that includes all relevant invoices, credit notes, and payments within a specified date range, demonstrating use of selection criteria.
- Award credit for identifying at least two simple data protection issues, such as password protection and secure data backup, and explaining their importance in a practical context.
Assessment Guidance
Guidance for achieving higher grades
- 💡During the assessment, always double-check that you have used the correct nominal ledger codes for each transaction type, as this is a frequent area for observation.
- 💡When processing payments, ensure you select the appropriate payment method (e.g., bank transfer, cash) and match it to the corresponding entry in the bank feed to simplify reconciliation.
- 💡For the bank reconciliation task, print or view the bank statement and the cash book side by side, ticking off matched items sequentially to avoid omissions.
- 💡Always show your workings in calculations, even when using software. Examiners award method marks.
- 💡Use the correct terminology, such as 'debit', 'credit', 'ledger', 'journal', and 'reconciliation'. This demonstrates understanding.
- 💡In practical tasks, double-check that you have entered the correct date, amounts, and accounts. Small errors can lead to large mark deductions.
Common Mistakes
Common errors to avoid in your coursework
- Confusing the entry of a credit note as an invoice, leading to inflated sales or purchases and incorrect customer/supplier balances.
- Forgetting to allocate a payment received to the correct customer invoice, resulting in an overstated accounts receivable ledger.
- Reconciling the bank account without adjusting for outstanding unpresented cheques or deposits in transit, causing discrepancies in the cash book.
- Neglecting to set or apply date range parameters when generating reports, leading to the inclusion of irrelevant transactions and inaccurate period-end summaries.
- Misconception: Computerised accounting means you don't need to understand double-entry. Correction: You still need to understand the principles to enter transactions correctly and interpret reports.
- Misconception: The trial balance always proves that all transactions are correct. Correction: It only proves that debits equal credits; errors like posting to the wrong account or omitting a transaction entirely won't be detected.
- Misconception: Bank reconciliation is only needed at year-end. Correction: It should be done regularly, often monthly, to ensure cash records are accurate and to detect fraud or errors.
Revision Plan
How to revise this topic in 1–2 weeks
- 1Week 1: Focus on understanding the principles of double-entry bookkeeping and how they apply in computerised systems. Practice entering simple sales and purchase transactions.
- 2Week 2: Learn how to set up a company in accounting software, including creating a chart of accounts and entering opening balances. Practice processing invoices and credit notes.
- 3Week 3: Master bank reconciliation and producing reports like the trial balance. Use sample data to practice reconciling and identifying timing differences.
- 4Week 4: Review all topics, attempt past exam questions, and focus on areas of weakness. Use active recall and flashcards for key terms.
Exam Question Types
How this topic typically appears in the exam
- 📋Multiple-choice questions: Test knowledge of key terms and concepts. Read each question carefully and eliminate obviously wrong answers.
- 📋Practical tasks: You may be given a scenario and asked to enter transactions into a simulated software environment. Ensure you follow the steps in order and check your entries.
- 📋Short-answer questions: Require you to explain a concept or process. Use clear, concise language and include relevant terminology.
- 📋Calculation questions: Such as preparing a bank reconciliation statement. Show all workings and present your answer neatly.
Command Word Expectations (VTCT SKILLS)
What examiners look for when using specific command words in this specification
State or name the required information, such as a transaction type or account. No explanation needed, just accurate identification.
Provide a clear account of how or why something happens, using relevant accounting principles. Include reasons and examples where appropriate.
Produce a formal document or statement, such as a bank reconciliation or trial balance. Ensure correct format and accurate figures.
How Students Lose Marks (Examiner Pitfalls)
Common mark loss traps and how to write 100% full-mark answers
Step-by-Step Worked Solutions
Detailed solution breakdown for typical exam problems
Question: A business uses computerised accounting software. On 1 March, the cash book shows a debit balance of £2,500. During March, the business issued cheques totalling £1,200, of which £800 have been presented to the bank. It also banked £1,500, of which £1,000 has been cleared. The bank statement at 31 March shows a balance of £2,900. Prepare a bank reconciliation statement as at 31 March.
- 1.Step 1: Identify the cash book balance (debit balance) as the starting point: £2,500.
- 2.Step 2: Adjust for timing differences: unpresented cheques (cheques issued but not yet presented) = £1,200 - £800 = £400; bank lodgements not yet cleared = £1,500 - £1,000 = £500.
- 3.Step 3: Calculate the adjusted cash book balance: £2,500 - £400 + £500 = £2,600. This should equal the bank statement balance after considering any bank charges or errors (none given).
- 4.Step 4: Present the reconciliation: Cash book balance £2,500; less unpresented cheques £400; add bank lodgements not credited £500; adjusted balance £2,600. Bank statement balance £2,900; less bank lodgements not credited £500; add unpresented cheques £400; adjusted balance £2,600.
Question: A trainee accountant enters a sales invoice for £500 as £50 in the computerised accounting system. Explain the impact on the trial balance and how this error would be corrected.
- 1.Step 1: Identify the error: the sales invoice was understated by £450 (500 - 50).
- 2.Step 2: Determine the impact: the sales account (credit) is understated by £450, and the receivables (debit) is understated by £450. Therefore, the trial balance will still balance, but both totals will be £450 lower than they should be.
- 3.Step 3: Correction: post a journal entry to debit the receivables account and credit the sales account by £450.
- 4.Step 4: In computerised accounting, this is done via a journal adjustment or by correcting the original invoice if the system allows.
Active Recall Memory Test
Test your memory before revealing the key facts
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for VTCT SKILLS Using a computerised accounting application
Every vocational unit is marked against named criteria rather than an exam percentage. Your tutor's brief lists the exact codes for this unit — here is what each band is asking you to do.
Demonstrate baseline knowledge, accurate terminology, and core practical application.
Provide detailed analysis, structured explanations, and clear workplace reasoning.
Deliver thorough evaluation, original problem solving, and fully justified recommendations.
Before You Start
Prior knowledge that will help with this topic
- •Basic numeracy skills, including addition, subtraction, multiplication, and division.
- •An understanding of simple business transactions, such as sales and purchases.
- •Familiarity with using a computer and basic software applications.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Be able to enter data into a Computerised Accounting Package, Be able to record customer and supplier invoices and credit notes, Be able to process payments received from customers and made to suppliers, Be able to correct transaction errors, Be able to carry out a bank reconciliation, Be able to prepare and produce financial documents to be sent to credit customers, Be able to maintain the petty cash account, Be able to produce reports using selection criteria and parameters, Be able to identify simple data protection, storage and security issues
Ready to learn?
AI-powered learning tailored to this unit