Computerised Accounting Software

Be able to manage accounting data.

AC 1.1:

• Unique references, codes, statutory requirements, editing restrictions.

AC 1.2:

• Use of data entry form, wizards, add/amend record (customer record, supplier record, nominal ledger, stock record), search, sort, print records, filters.

AC 1.3:

• Due to field size, data type, validation checks, duplicate records, format, use help, data that does not fit parameters, alerts, reminders, problems with forms.

AC 1.4:

• Risks (access control, different access levels for different users, authorised use, confidentiality, personal data, user names, password protection, secure password management, user authentication), data protection procedures (accessible, reliable, rapid access, shared view, up to date, accurate, secure, simplified data handling).

AC 1.5:

• Set by employer or organisation, policies relating to security backup and data protection, guidelines for data format, compliance, audit and reporting requirements, file management of the application, local storage, online storage.

Assessment Criteria

• 1.1

  Explain the sources and characteristics of accounting data.

• 1.2

  Enter, locate and display accounting data accurately to meet requirements.

• 1.3

  Check data records, making corrections as necessary.

• 1.4

  Describe the risks to data security and the procedures used for data protection.

• 1.5

  Apply local and/or legal guidelines for the storage and use of data.

Be able to process business transactions.

AC 2.1:

• Process transactions, number of items, single items, batches, create, copy, check, save, types of transactions (post invoice, receipt, payment, journal, contra entry, credit note), from (bank statement, cheque book, paying-in book, e-commerce.

AC 2.2:

• Spell check, format, consistency, remove duplication, verify data, edit details, check calculations, check coding, file maintenance, check others’ work, duplication, accuracy, limits of own responsibility, process for reporting errors and problems.

AC 2.3:

• Month, quarterly, fiscal end, post depreciation, budgets, standing orders, VAT return, duplication, accuracy, limits of own responsibility, process for reporting errors and problems.

Assessment Criteria

• 2.1

  Use appropriate tools and techniques to enter and process transactions.

• 2.2

  Check and respond appropriately to any errors or problems.

• 2.3

  Use appropriate tools and techniques for period-end processing.

Be able to produce accounting documents and summary reports.

AC 3.1:

• Month, quarterly, fiscal end, post depreciation, budgets, standing orders, VAT return, invoice, sales order, purchase order, statement, to screen, printed, email, audit trail, customer activity, day book, aged debtor, aged creditor.

AC 3.2:

• Mail merge, spreadsheet analysis, requirements for internet banking, stock control system, online ordering system, budget update, file format (CSV, XLSX).

Assessment Criteria

• 3.1

  Generate accounting documents and management reports to meet requirements.

• 3.2

  Import and export data and link to other systems and software.