Computerised Accounting Software
This element focuses on the practical application of computerised accounting software to manage financial data accurately and efficiently. Learners develop skills to access, enter, and edit accounting information, process business transactions using integrated tools, and generate compliant accounting documents and summary reports. Mastery of these tasks is essential for maintaining reliable financial records and supporting business decision-making in a professional environment.
Assessment criteria
Quick Revision Summary (Key Takeaway)
The City & Guilds Level 3 Diploma in IT User Skills is a vocational qualification that develops advanced digital literacy and practical IT competencies for the modern workplace. It covers topics such as advanced word processing, spreadsheets, databases, presentation software, and IT security, preparing learners for roles that require confident and efficient use of digital tools.
Topic Overview
The City & Guilds Level 3 Diploma in IT User Skills is designed to equip learners with advanced practical skills in using digital tools effectively. It goes beyond basic computer literacy, focusing on the confident and productive use of software applications such as word processors, spreadsheets, databases, and presentation tools. The qualification is recognised by employers and is ideal for those seeking to enhance their employability in roles that require strong IT capabilities.
The diploma covers a range of units, including advanced word processing, spreadsheet modelling, database design, and presentation skills. It also emphasises the importance of IT security, data protection, and legal considerations when using digital technologies. Learners develop the ability to solve problems, analyse data, and communicate information clearly, which are essential skills in today's digital workplace.
Assessment is typically through practical tasks and assignments that simulate real-world scenarios. This ensures that learners not only understand theoretical concepts but can also apply them in practical situations. The qualification is flexible, allowing learners to choose optional units that align with their career goals, making it a valuable addition to any CV.
Key Concepts
Core ideas you must understand for this topic
- →Advanced formatting techniques in word processing, such as styles, templates, and mail merge.
- →Use of formulas and functions in spreadsheets, including VLOOKUP, IF, and SUMIF, to analyse and manipulate data.
- →Designing and creating relational databases, including tables, queries, forms, and reports.
- →Creating professional presentations using multimedia elements, transitions, and animations.
- →Understanding IT security principles, including password management, encryption, and safe internet practices.
Learning Objectives
What you need to know and understand
- 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, 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, 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
- Set up a computerised accounting system, including chart of accounts and opening balances, ready for operational use.
- Enter and edit accounting information accurately, adhering to data validation rules.
- Process a range of business transactions from source documents, applying correct software functions.
- Develop and interpret management information reports to evaluate financial performance.
- Reconcile control accounts and produce a trial balance to verify ledger integrity.
- Apply data security and backup procedures to maintain system integrity.
- Demonstrate accurate access, entry, and editing of accounting data using software interfaces.
- Apply appropriate tools and techniques to process diverse business transactions.
- Produce standard accounting documents and summary reports that meet specified requirements.
- Utilize software features to automate recurring entries and reconciliations.
- Maintain data integrity through validation and backup procedures.
- 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
Assessment Criteria
Key criteria assessors look for in your portfolio
- Award credit for demonstrating the ability to accurately access and navigate the accounting software, including logging in and selecting the correct company file or database.
- Award credit for correctly entering a range of financial transactions (e.g., sales invoices, purchase invoices, bank payments/receipts) with appropriate nominal codes, VAT treatment, and dates.
- Award credit for producing a trial balance, profit and loss account, and balance sheet that reconcile with the underlying transaction data, with no material errors.
- Award credit for editing existing entries to correct errors while maintaining an adequate audit trail (e.g., using credit notes, journal entries, or voiding with proper authorisation).
- Award credit for using software tools such as bank reconciliation, recurring entries, or budget comparison to process transactions efficiently and accurately.
- Award credit for accurately entering and categorising financial data such as invoices, receipts, and payments using the correct nominal codes and tax rates.
- Credit should be given for demonstrating the selection and application of appropriate software features (e.g., bank reconciliation, recurring entries, VAT calculations) to process business transactions.
- Evidence must include the production of standard accounting reports (e.g., trial balance, profit and loss, aged debtor/creditor lists) that are accurate, properly formatted, and meet specified requirements.
- Assessors should look for the ability to edit and correct accounting information, including journal adjustments, to rectify errors while maintaining an audit trail.
- Award credit for demonstrating secure access to the accounting system using appropriate authentication methods and maintaining data confidentiality.
- Evidence must show accurate entry and editing of accounting data, including corrections of errors using proper audit trails and journal entries.
- Require selection and application of relevant software tools (e.g., ledger, bank reconciliation, VAT functions) to process common business transactions completely.
- Credit should be given for producing accounting documents (invoices, statements, trial balance) and summary reports that meet specified formatting, content, and accuracy requirements.
- Award credit for accurately setting up a chart of accounts with nominal codes aligned to business structure and reporting needs.
- Award credit for correctly entering and editing a range of transactions (e.g., invoices, credit notes, payments) with appropriate VAT treatment and payment terms.
- Award credit for selecting and applying the correct processing tools such as journal entries, recurring entries, and bank reconciliation to ensure ledger accuracy.
- Award credit for producing a variety of summary reports (e.g., trial balance, profit and loss, aged debtors/creditors) that are fully reconciled and formatted to meet given requirements.
- Award credit for demonstrating accurate setup of chart of accounts, customer/supplier records, and opening balances in the software.
- Accurately entering a batch of invoices and credit notes from provided source documents with no errors.
- Processing transactions by correctly matching payments to invoices and recording bank transactions.
- Generating a trial balance report and interpreting its accuracy.
- Setting up user access levels and security settings appropriately.
- Award credit for demonstrating the ability to set up and maintain customer, supplier and nominal ledger accounts with accurate opening balances.
- Award credit for correctly entering a range of transactions (e.g. invoices, credit notes, receipts, payments) using appropriate software modules and date periods.
- Award credit for processing transactions to update ledgers, including applying VAT treatment and allocating to correct tax codes.
- Award credit for generating accurate accounting reports such as trial balance, aged debtors/creditors and profit and loss statements, verifying they meet specified requirements.
- Award credit for correctly configuring a new company file with a comprehensive chart of accounts tailored to the scenario.
- Evidence of entering a batch of invoices and credit notes from supplier and customer source documents without error.
- Demonstrate ability to edit a previously posted transaction while maintaining a clear audit trail (e.g., using journal entries).
- Correctly generate and interpret a profit and loss statement and balance sheet, explaining key figures.
- Show reconciliation of bank and cash accounts, identifying and resolving discrepancies.
- Produce a trial balance that balances, confirming the accuracy of double-entry postings.
- Award credit for correctly setting up and modifying customer, supplier, and nominal accounts.
- Expect clear evidence of entering at least two different types of transactions (e.g., sales invoice, payment receipt) without errors.
- Check that generated reports (trial balance, profit and loss) are complete, formatted per guidelines, and accurately reflect the entered data.
- Look for appropriate use of error-correction tools such as journal entries or reversal functions.
- Award credit for successfully launching the accounting software and navigating to the correct module for data entry.
- Award credit for accurately entering a batch of transactions, including the use of correct date formats, account codes, and monetary values.
- Award credit for amending an existing record (e.g., correcting a supplier payment amount) while maintaining data integrity.
- Award credit for using software tools (e.g., recurring entry templates, quick-search) to process transactions efficiently.
- Award credit for generating at least two different reports (e.g., trial balance, sales daybook) that meet specified layout requirements and are free from data extraction errors.
- Award credit for demonstrating accurate and secure access to accounting software, including correct login procedures and navigation to appropriate ledgers or modules for data entry.
- Award credit for selecting and applying the correct transaction processing tools (e.g., recording sales invoices, purchase orders, or bank payments) with accurate coding, VAT treatment, and posting to the general ledger.
- Award credit for producing specified accounting documents and summary reports (such as customer statements, trial balance, or profit and loss reports) that meet given requirements and are free from data errors.
- Award credit for accurately entering company details and financial year start date during system setup.
- Expect correct data entry when processing a purchase invoice, including nominal codes and VAT treatment.
- Demonstrated ability to produce a trial balance report that reconciles with manually calculated figures.
Assessment Guidance
Guidance for achieving higher grades
- 💡Before starting any task, verify the system date and financial year settings in the software to ensure all entries fall in the correct period.
- 💡For reports, always check that the date range and parameters (e.g., inclusive vs. exclusive) match the assessment requirements exactly—a single incorrect filter can invalidate output.
- 💡Practice the full workflow of entering transactions, reconciling, and generating reports multiple times on the specific software used by your centre to build speed and familiarity.
- 💡When editing transactions, use the software’s native correction features (e.g., journal reversals) rather than simply deleting or overwriting data, as centres often assess audit trail integrity.
- 💡In the practical assessment, allocate time to cross-check key figures: ensure the net profit on the profit and loss matches the equity section of the balance sheet, and the bank balance reconciles with the cash book.
- 💡Thoroughly familiarise yourself with the software's chart of accounts and navigation before starting any assessment tasks.
- 💡Use the software’s built-in checks (e.g., trial balance, reconciliation tools) at each stage to catch errors early.
- 💡Practice processing a full cycle of common transactions—from sales invoices to bank payments—to build speed and accuracy.
- 💡When producing reports, always review them for completeness and cross-check key figures against source documents before submission.
- 💡Always double-check account codes and customer/supplier details before confirming entries to prevent costly mispostings.
- 💡Familiarise yourself with the software’s error-correction tools; understanding how to void or reverse transactions without deleting them shows robust data management.
- 💡Practice generating reports from different date ranges and parameters to ensure you can tailor outputs to specific assessment criteria.
- 💡In timed assessments, allocate the first five minutes to reviewing all input data provided; this minimises rework and ensures you meet all document requirements.
- 💡Always verify the chart of accounts and customer/supplier records before entering transactions to ensure coding accuracy.
- 💡Use the software’s data validation and error-checking features (e.g., control accounts, audit trails) to catch mistakes early.
- 💡During assessment, systematically complete all stages—enter, process, reconcile, and report—following the task brief meticulously.
- 💡Print or save draft reports and cross-check key figures (e.g., gross profit, bank balance) against manual calculations to confirm correctness before final submission.
- 💡Always double-check your entries against the source documents before processing.
- 💡When setting up a system, begin with the chart of accounts and ensure it aligns with the business's reporting needs.
- 💡In assessments, evidence your work with screenshots showing key stages, including reports before and after transactions.
- 💡Familiarise yourself with the specific accounting software's shortcuts and common functions to save time during timed tasks.
- 💡Read assignment briefs carefully to identify exactly which documents and reports must be produced, and tailor your data entry accordingly.
- 💡Use the software's help features and check figures as you work—small data entry errors can cascade into incorrect final accounts.
- 💡Print or save your work as you go, ensuring you have clear audit trails and screen prints to evidence your process for the assessor.
- 💡Familiarise yourself with common shortcuts and batch processing features to work efficiently during timed assessments.
- 💡Read the assessment scenario carefully, noting all dates, tax requirements, and specific report requests before starting.
- 💡Use checklists for the setup process (e.g., company details, financial year, standard VAT rate) to ensure nothing is omitted.
- 💡After entering transactions, always preview or print a daybook listing to verify entries match source documents exactly.
- 💡Practise generating a variety of reports (e.g., aged debtors, profit & loss, trial balance) and be prepared to explain their meaning verbally or in written tasks.
- 💡Double-check that all entries are saved and posted correctly—run a trial balance as a quick check for imbalances before final submission.
- 💡Always verify entries against source documents like invoices or receipts before processing.
- 💡Make use of software shortcuts and form templates to speed up routine tasks.
- 💡Practice generating a variety of reports to become familiar with filtering and export options.
- 💡Review the chart of accounts beforehand to ensure correct account selection during data entry.
- 💡Familiarise yourself with the specific accounting software’s interface, menu structure, and common shortcut keys before the assessment.
- 💡For process-based tasks, always read the entire scenario first to understand the transaction flow and avoid unnecessary corrections.
- 💡Double-check that you have selected the correct accounting period and company/client file before starting any entry or report generation.
- 💡Use the software’s validation prompts and error alerts as a guide; if a warning appears, review the entry for accuracy.
- 💡Practice reconciling a simple set of input data against generated reports to ensure consistency and accuracy—this mirrors typical assessor checks.
- 💡Practice using the software regularly to build speed in data entry; use keyboard shortcuts and automated features to improve efficiency during timed assessments.
- 💡Always double-check transaction entries for correct dates, amounts, and account codes, and use available validation tools within the software to minimise errors.
- 💡Before producing final reports, verify report parameters (e.g., date range, account filters) against the task requirements to ensure the output matches exactly what is requested.
- 💡Practice navigating the software menus to quickly access common functions like creating suppliers or running reports.
- 💡Double-check source documents for all necessary details (date, amount, tax) before data entry.
- 💡Familiarise yourself with interpreting basic financial reports; exam tasks often ask you to identify errors or discrepancies.
- 💡Always read the question carefully and identify the command word (e.g., 'describe', 'explain', 'evaluate'). This tells you the depth of answer required.
- 💡When answering practical questions, mention specific software features and menu options to demonstrate your hands-on knowledge.
- 💡For calculation questions, show all your working and include units in your final answer. This ensures you gain method marks even if the final answer is incorrect.
Common Mistakes
Common errors to avoid in your coursework
- Failing to set the correct financial period before entering transactions, leading to misdated entries that compromise period-end reports.
- Misapplying VAT codes—such as using 'standard' instead of 'exempt' or 'zero-rated'—resulting in incorrect VAT returns.
- Neglecting to perform a bank reconciliation regularly, causing discrepancies between the cash book and bank statement.
- Entering transactions without considering double-entry principles, leading to unbalanced accounts and unreliable trial balances.
- Forgetting to produce and review aged debtors/creditors reports, which can mask cash flow issues.
- Misposting transactions to incorrect ledger accounts due to confusion over nominal codes or incomplete chart of accounts setup.
- Failing to reconcile bank and credit card transactions within the software, leading to undetected discrepancies in financial records.
- Neglecting to update master data (customer/supplier records, VAT rates) before entering transactions, causing errors downstream.
- Generating reports without first verifying the accuracy of underlying data, resulting in misleading financial summaries.
- Confusing editable fields with calculated fields, leading to overwriting formulas or automatic totals.
- Failing to set up or apply the correct VAT rates or discount structures before processing transactions.
- Neglecting to perform regular data backups or failing to recognise the importance of maintaining a clear audit trail.
- Producing reports without verifying data accuracy first, resulting in misleading or incomplete financial summaries.
- Misposting transactions to incorrect nominal codes, leading to misstated financial reports.
- Failing to apply the correct VAT rate or tax code, which compromises VAT return accuracy.
- Not performing or incorrectly performing bank reconciliation, leaving discrepancies between software and bank statements.
- Neglecting to check and edit data entry errors before processing, causing batch processing failures or inaccurate ledgers.
- Producing reports without verifying them against source documents or balancing controls, resulting in invalid outputs.
- Confusing the double-entry system when entering transactions, leading to imbalance in reports.
- Entering incorrect dates or nominal codes, which causes misallocation of transactions.
- Failing to back up data before performing system setup changes.
- Overlooking the reconciliation step, resulting in discrepancies between bank statements and software records.
- Entering transactions in the wrong accounting period, leading to misstated financial reports.
- Misclassifying VAT or using incorrect tax codes, causing errors in VAT returns and ledger balances.
- Forgetting to back up data regularly or not saving work correctly, resulting in loss of evidence for assessment.
- Neglecting to reconcile bank and control accounts, leading to un-reconciled differences that affect the accuracy of reports.
- Misclassifying accounts in the chart of accounts, e.g., treating capital expenditure as revenue expense.
- Failing to enter transactions in the correct period, leading to incorrect financial statements.
- Omitting to apply VAT/tax codes correctly where required by the scenario.
- Not backing up the accounting file before making significant changes or system setup adjustments.
- Confusing the purpose of different ledgers (e.g., posting payments to the sales ledger instead of the cash book).
- Generating reports without first reconciling accounts, resulting in inaccurate management information.
- Confusing debit and credit entries when recording transactions.
- Failing to reconcile bank or control accounts before generating final reports.
- Overlooking the need to back up data before making bulk edits.
- Misclassifying transaction types (e.g., capital expenditure vs. revenue expense).
- Confusing debit and credit entries when recording transactions, leading to imbalanced ledgers.
- Entering transactions with incorrect dates (e.g., today's date instead of the actual transaction date), affecting period-end reports.
- Forgetting to save or finalise entries, resulting in lost data or incomplete records.
- Selecting the wrong nominal ledger account from a lookup list, causing misposting.
- Generating reports without verifying the inclusion of all relevant criteria (e.g., date range, specific accounts), producing incomplete summaries.
- Confusing nominal ledger account codes when entering transactions, leading to misclassification of income or expenditure.
- Forgetting to save or post transactions after entry, resulting in incomplete records and discrepancies in reports.
- Failing to reconcile or check generated reports against source data, causing undetected errors in final documents.
- Confusing the difference between cash and accrual accounting when entering transactions.
- Misapplying VAT codes, particularly between standard-rated and zero-rated items.
- Forgetting to back up the accounting data after significant entries.
- Misconception: Spreadsheet formulas are only for simple arithmetic. Correction: Spreadsheets can perform complex data analysis using functions like VLOOKUP, IF, and PivotTables, which are essential for business decision-making.
- Misconception: A database is the same as a spreadsheet. Correction: Databases are designed to manage structured data with relationships between tables, while spreadsheets are more suited for calculations and simple lists. Databases offer better data integrity and querying capabilities.
- Misconception: Mail merge is only for letters. Correction: Mail merge can be used for emails, envelopes, labels, and directories, making it a versatile tool for bulk communication.
Revision Plan
How to revise this topic in 1–2 weeks
- 1Week 1: Focus on word processing and presentation units. Practice creating professional documents and presentations using advanced features. Review formatting, styles, and mail merge.
- 2Week 2: Dedicate time to spreadsheets. Learn key formulas and functions, and practice creating charts and pivot tables. Work through past exam questions on data analysis.
- 3Week 3: Study databases. Understand table relationships, create queries, and design forms and reports. Practice building a small database from scratch.
- 4Week 4: Revise IT security and legal aspects. Make flashcards for key terms and regulations. Take a full practice exam under timed conditions to identify weak areas.
Exam Question Types
How this topic typically appears in the exam
- 📋Multiple-choice questions: These test factual knowledge of software features and terminology. Read each option carefully and eliminate obviously wrong answers.
- 📋Short-answer questions: These require brief explanations or definitions. Use precise technical language and keep answers concise but complete.
- 📋Practical tasks: These are often scenario-based, asking you to perform a task in a simulated environment. Follow the instructions step-by-step and save your work as directed.
- 📋Extended writing questions: These may ask you to evaluate a process or compare tools. Structure your answer with an introduction, main points, and a conclusion, using examples to support your arguments.
Command Word Expectations (CITY & GUILDS LIMITED)
What examiners look for when using specific command words in this specification
Provide a detailed account of the features, functions, or steps involved. Do not just list; explain what each feature does and how it is used.
Give reasons or causes for why something happens or how a process works. Use 'because' or 'therefore' to link ideas and show understanding.
Weigh up the pros and cons of a method, tool, or approach. Make a judgement and support it with evidence or examples. Consider alternatives and justify your conclusion.
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 small business uses a spreadsheet to track monthly sales. The spreadsheet has columns: Month, Product, Units Sold, Unit Price. Calculate the total revenue for the product 'Widget' in March, given that 150 units were sold at £12.50 each. Show your working.
- 1.Step 1: Identify the relevant data: Units Sold = 150, Unit Price = £12.50.
- 2.Step 2: Apply the formula for revenue: Revenue = Units Sold × Unit Price.
- 3.Step 3: Calculate: 150 × 12.50 = 1875.
- 4.Step 4: State the final answer with currency: £1,875.
Question: Explain the purpose of using mail merge in a business context, and describe the main steps to create a mail merge letter in Microsoft Word.
- 1.Step 1: Define mail merge: a process that combines a template document with a data source to produce personalised copies.
- 2.Step 2: Identify the data source, such as an Excel spreadsheet or Access database, containing recipient details.
- 3.Step 3: In Word, go to the 'Mailings' tab and select 'Start Mail Merge' > 'Step-by-Step Mail Merge Wizard'.
- 4.Step 4: Choose the document type (e.g., letter), select the recipients from the data source, insert merge fields (e.g., name, address) into the template, and preview the results.
- 5.Step 5: Complete the merge by printing or saving the personalised letters.
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 CITY & GUILDS LIMITED Computerised Accounting Software
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 computer literacy, including file management and internet use.
- •Foundational knowledge of Microsoft Office or equivalent software.
- •Understanding of simple data handling and mathematical concepts.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- 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, 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, 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
- System setup and configuration
- Data entry and validation
- Transaction processing from source documents
- Management report generation
- Interpretation of financial data
- Audit trail and data integrity
- Data entry and validation
- Transaction processing workflows
- Financial report generation
- Software navigation and shortcuts
- Accounting controls and error correction
- 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
Ready to learn?
AI-powered learning tailored to this unit