Computerised Accounting Software

Be able to manage accounting data.

AC 1.1: 

Unique references, codes, statutory requirements, editing restrictions, spreadsheet analysis, requirements for internet banking, stock control system, online ordering system, budget update, file format (CSV, XLSX).

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

  Identify 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

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

• 1.5

  Follow local and/or legal guidelines for the storage and the 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.

Assessment Criteria

• 2.1

  Use appropriate tools and techniques to process transactions. 

• 2.2

  Check and respond appropriately to any errors or problems. 

Be able to produce accounting documents and summary reports. 

AC 3.1:

Month, quarterly, fiscal end, post depreciation, budgets, standing orders, VAT return.

AC 3.2:

Invoice, sales order, purchase order, statement, to screen, printed, email, audit trail, customer activity, day book, aged debtor, aged creditor.

Assessment Criteria

• 3.1

  Describe the types of information required and how to present it. 

• 3.2

  Generate accounting documents and management reports to meet requirements.