AAT Access Award In Accounting Software Sample Assessment .

3y ago
111 Views
5 Downloads
214.39 KB
24 Pages
Last View : 6d ago
Last Download : 2m ago
Upload by : Tripp Mcmullen
Transcription

AAT Access Awardin Accounting SoftwareSample assessment andmark schemeAssessment bookQualification number: 603/1306/7Qualification Specification: AAT Access Award in Accounting SoftwareVersion 2.0 published 7 September 2018AAT is a registered charity. No. 1050724

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookNotes for studentsThis sample assessment is designed to demonstrate as many of the possible question types youmay find in a live assessment. It is not designed to be used on its own to determine whether youare ready for a live assessment.In a live assessment, you will be required to upload documents as part of your evidence requiredfor marking. For the purpose of this sample assessment, it is advised that you familiarise yourselfwith the process of uploading documents to share with your tutor.The assessment information detailed below is reflective of what you will see in a live assessment.2

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookAssessment informationThe time allowed to complete this assessment is 2 hours. You should allow a minimum of 15 minuteswithin this time to upload your evidence.This assessment consists of 6 tasks and it is important that you attempt them all. Section 1: Task 1 will ask you to complete short answer questions. Section 2: Tasks 2 to 6 will ask you to process transactions and produce reports.You may complete the sections in the order you prefer but all documents for Section 2 must be uploadedwithin the total time available.Documents must be produced in one of the following formats: XLSX, CSV, PDF. Assessment evidencesubmitted in alternative file formats will not be marked.You will be able to attach and remove files throughout the duration of this assessment until you click on‘Finish’, which will submit your assessment.You should make sure you upload all reports specified in Section 2. If you do not upload your work itcannot be marked.All uploaded documents should be saved and titled with the following information: evidence number your name your AAT membership number.The evidence number to use for each document is stated in the table on page 11.ExampleYour name is Simon White and your AAT membership number is 12345678.Evidence 1A document showing all the purchase invoices and credit notes (by purchase type) posted in April 20XX.This document would be saved and uploaded as: Evidence 1 – Simon White – 12345678.If multiple documents are uploaded to show competency in an individual task, name these Evidence 1A,Evidence 1B and so on.3

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookInformationBella’s Boutique is a small owner-managed business that provides beauty services. The owner, Bella Anwar,has decided to use an accounting software package from 1 January 20XX onwards.Bella’s Boutique will be expanding to offer hairdressing services from 1 January 20XX.The following table contains information about the business.Business nameBella’s BoutiqueBusiness address291 Escafeld RoadSheffieldSouth YorkshireS41 1GUBusiness ownerBella AnwarAccounting period end31 December (each year)VAT number298253087 (standard scheme)VAT rateStandard rate VAT of 20%You have been asked to carry out the bookkeeping tasks for January 20XX only.All documents have been checked for accuracy and have been authorised by Bella Anwar.Before you start the assessment you should: set up the business name, address, owner and accounting period if required by your software, add the VAT number and rate set the system software date as 31 January of the current year set the financial year to start on 1 December of the current year.This set-up does not form part of the assessment standards, so your training provider may assist you withthis.4

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookSection 1Task 1 (20 marks)(a) The following are potential features or benefits of accounting software compared to manualbookkeeping. Show whether they are true or false.(5 marks)True(a benefit/feature)False(not a benefit/feature)Export quickly to softwareProduce reports showing real-time financial positionVAT is always calculated correctlyBatch processingPrint reports(b) Which two of the following are advantages of using off the shelf software compared to bespokepackages?(2 marks)Off the shelf packages are generally cheaper than bespoke packages. are designed for the exact needs of the business. give a business an advantage over other businesses. can be set up quickly.(c) Which two of the following are advantages of using traditional software compared to cloudpackages?(2 marks)Traditional software has specific system requirements. doesn’t always need access to the internet. can be viewed from two different places. requires a one-off payment rather than ongoing subscription.Your company needs new accounting software. You have staff working from home.(d) Should you choose traditional software or a cloud package?(1 mark) Traditional softwareCloud package5

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookWhich two of the following are threats to data security?(2 marks) A computer virusA floodEncryptionUse of firewalls(e) Which two of the following can protect accounting software against threats?(2 marks) Making sure a senior manager has copies of user passwordsRegularly backing up dataKeeping paper copies of all recordsPassword-protecting data(f) What is phishing?(1 mark) Using a program to infect a computer system and cause problemsPretending to be trustworthy to gain access to dataAccidental deletion of data(g) Which report would you print to see all the transactions posted?(1 mark) Audit trailTrial balanceSales analysisBank payments analysis6

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookIt’s the 1st of April and you are entering your bank transactions for March.(h) Which report would show a bank charge from 31 March?(1 mark) Bank payment report dated 01 April to 30 AprilBank receipts report dated 01 March to 31 MarchBank payment report dated 01 March to 31 MarchBank receipts report dated 01 April to 30 AprilYou have entered a cash sale into your accounting software.(i) Which three of the following reports would this transaction appear on?(3 marks) Sales general ledger accountBank receipts analysisBank payments analysisAudit trailTrial balanceCash receipts analysis7

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookSection 2Task 2 (20 marks)(a) Refer to the list of general ledger accounts below taken from the spreadsheet that the businesshas been using.Set up general ledger records for each account, entering opening balances (if applicable) at 1January 20XX.Make sure you select, amend or create appropriate general ledger account codes.(16 marks)Opening trial balance as at 1 January 20XXAccount nameOffice equipment – costOffice equipment – depreciationMotor vehicles – costMotor vehicles – depreciationPrepaymentsBank current accountCash accountCapitalDrawingsSales tax control accountPurchase tax control accountSalesBank interest ebitbalance ( )Creditbalance ( LNIL16,789.8616,789.86NotesItems marked 1 are general ledger accounts needed for transactions taking place in January 20XX. Theaccounting software you are using may not have these accounts as standard.(b) The business has been using the following list of general ledger accounts.Set up general ledger records for each account, ensuring you amend or create appropriategeneral ledger account codes.(4 marks)Account nameHairdressing equipment – costAdvertising (hairdressing business)Sales (hairdressing business)Purchases (hairdressing business)8

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookTask 3 (10 marks)Refer to the following bank statement. Use the accounting software to enter the transactions.Bank of Eccleshall102 Prince StreetLondonEC1A 2WE291 Escafeld RoadSheffieldSouth YorkshireS41 1GUSort code: 23 - 04 - 19Account Number: 60911568Statement date: 31 January 20XXDate 20XXDetailsStatement of accountMoney OutNote( )Money In( )Balance( )01 JanuaryOpening balance03 JanuaryDeposit (beauty sales)269.522,029.3808 JanuaryDeposit (beauty sales)97.462,126.8409 JanuaryDD – Global Telecoms14 JanuaryWithdrawal (drawings)14 JanuaryDeposit (beauty sales)17 JanuaryDD - Wages20 JanuaryDD – Rent23 JanuaryBank interest23 JanuaryDD – Beauty supplies shop69.151,908.5426 JanuaryCard – Graze Office 771,977.69NotesAll items, except for those marked with ‘1’, include VAT at the standard rate of 20%.Items marked with 1 do not include VAT.9

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookTask 4 (10 marks)Refer to the following five cash payments and enter them into the accounting software.Equip RiteDate: 7 January 20XXMedia MogulHocktonBirminghamB33 4AE15 Badger RoadClaphamC21 9DGVAT Registration No 233 2937 22VAT No: 800 1120 88Invoice No: 190/25To:Bella’s BoutiqueInvoice No: BFR665To:Bella’s BoutiqueHairdressing equipmentVAT at 20%TotalElla’s Emporium 1,000.00200.001,200.00Date: 18 January20XXDate: 15 January 20XXHairdressing advert – Jan 20XXVAT at 20%TotalOffice Plus 50.0010.0060.00Date: 20 January 20XX74 Desborough RoadHigh WycombeHP11 2SE1 The PlaceDenleyD33 4XBVAT No: 986 1423 96Invoice No: 17862To:Bella’s BoutiqueHairdressing suppliesVATTotalElla’s EmporiumInvoice No: 789To:Bella’s Boutique 200.000.00200.00Office stationeryVAT at 20%Total 30.006.0036.00Date: 31 January20XX1 The PlaceDenleyD33 4XBInvoice No: 17967To:Bella’s BoutiqueBeauty suppliesVATTotal 356.000.00356.0010

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookTask 5 (10 marks)Refer to the following email from Bella Anwar and enter the five transactions into the accounting software.EmailFrom: Bella AnwarTo: Accounting TechnicianDate: 31 January 20XXSubject: January transactionsHiThe following transactions were received into the cash account this month.Date5 January10 January17 January29 January31 JanuaryDescriptionCapital introducedHairdressing saleBeauty saleHairdressing saleBeauty e could you process them into the accounting software?Thanks.Bella11

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Assessment bookTask 6 (10 marks)You are now required to generate the following documents.Document and reportsSave/upload as:Hairdressing sales analysis for themonth of January 20XX.Evidence 1 – Name – AAT NumberBeauty purchases general ledgeraccount for the month of January20XX.Evidence 2 – Name – AAT NumberCash payments analysis for themonth of January 20XX.Evidence 3 – Name – AAT NumberAudit trail, showing full details of alltransactions.Evidence 4 – Name – AAT NumberTrial balance as at 31 January20XX.Evidence 5 – Name – AAT Number12

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeAAT Access Awardin Accounting SoftwareSample assessment andmark schemeModel answers and mark schemeQualification number: 603/1306/7Qualification Specification: AAT Access Award in Accounting SoftwareVersion 1.0 published 28 April 2017AAT is a registered charity. No. 105072413

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeNotes for tutorsMarking guidanceCorrect answers in Section 1 are shown in red text.Individual marks for each correct answer in Section 1 are shown in red text superscript.14

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark 0Mark allocation(a) – 1 mark for each of the correct answers (5 marks total).(b) – 1 mark for each of the correct answers (2 marks total).(c) – 1 mark for each of the correct answers (2 marks total).(d) – 1 mark.(e) – 1 mark for each of the correct answers (2 marks total).(f) – 1 mark for each of the correct answers (2 marks total).(g) – 1 mark.(h) – 1 mark.(i) – 1 mark.(j) – 1 mark for each of the correct answers (3 marks total).Award 1 mark for each of the 8 general accounts created and 1 mark foreach of the 8 opening balances entered. Credit should only be given for theaccounts with a balance allocated to them.2aSet up generalledger accounts16General accountsTo award the mark, the account code selected must be technically correct. Ifany of the account names differ due to wording in the software package thenthe mark should be awarded as long as the code selected is technicallycorrect. If the account code is technically incorrect (for example, incorrectcategory such as asset code rather than expense code) then the mark mustnot be awarded.Evidenced by one (or a combination) of the following uploads: Evidence 4 – Audit trail (or) Evidence 5 – Trial balance.Opening balancesTo award the mark, opening balance must be the correct amount andrecorded on the correct side (debit or credit).Evidenced by: some accounts will not have any further activity apart from theopening balance and therefore these balances can be evidenced byone (or a combination) of the following uploads:o Evidence 4 – Audit trail (or)o Evidence 5 – Trial balance. the opening balances on all other accounts will need to beevidenced by:o Evidence 4 – Audit trail.2bAmend generalledger accounts4Amended general accountsTo award the mark, the name of the account must be correct (excludingtypos). If any of the account names differ due to wording in the softwarepackage then the mark should be awarded as long as the code selected istechnically correct.Evidenced by one (or a combination) of the following uploads: Evidence 4 – Audit trail (or) Evidence 5 – Trial balance.15

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeTask3456TopicProcess banktransactionsProcess cashpaymentsProcess cashreceiptsMarks101010Produce reports10TOTAL80Mark allocation1 mark per transaction for correct date, amounts and appropriate generalledger code selected (10 marks total).Evidenced by: Evidence 4 – Audit trail.For each voucher or transaction: 1 mark for correct amounts (5 marks total) 1 mark for date and appropriate general account (5 marks total).Evidenced by: Evidence 4 – Audit trail.For each voucher or transaction: 1 mark for correct amounts (5 marks total) 1 mark for date and appropriate general account (5 marks total).Evidenced by: Evidence 4 – Audit trail.For each report requested:1 mark for uploading the correct report (5 marks total)1 mark for selecting the correct dates (5 marks total).Evidenced by: Evidence 1 – Hairdressing sales analysis Evidence 2 – Beauty purchases general ledger account Evidence 3 – Cash payments analysis Evidence 4 – Audit trail Evidence 5 – Trial balance.16

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeSection 1Task 1 (20 marks)(a) The following are potential features or benefits of accounting software compared to manualbookkeeping. Show whether they are true or false.(5 marks)True(a benefit/feature)Export quickly to software 1Produce reports showing real-time financial position 1False(not a benefit/feature) 1VAT is always calculated correctlyBatch processing 1Print reports 1(b) Which two of the following are advantages of using off the shelf software compared to bespokepackages?(2 marks)Off the shelf packages are generally cheaper than bespoke packages. 1 are designed for the exact needs of the business. give a business an advantage over other businesses. can be set up quickly. 1(c) Which two of the following are advantages of using traditional software compared to cloudpackages?(2 marks)Traditional software has specific system requirements. doesn’t always need access to the internet. 1 can be viewed from two different places. requires a one-off payment rather than ongoing subscription. 117

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeYour company needs new accounting software. You have staff working from home.(d) Should you choose traditional software or a cloud package?(1 mark) Traditional softwareCloud package 1(e) Which two of the following are threats to data security?(2 marks) A computer virus 1A flood 1EncryptionUse of firewalls(f) Which two of the following can protect accounting software against threats?(2 marks) Making sure a senior manager has copies of user passwordsRegularly backing up data 1Keeping paper copies of all recordsPassword-protecting data 1(g) What is phishing?(1 mark) Using a program to infect a computer system and cause problemsPretending to be trustworthy to gain access to data 1Accidental deletion of data(h) Which report would you print to see all the transactions posted?(1 mark) Audit trail 1Trial balanceSales analysisBank payments analysis18

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeIt’s the 1st of April and you are entering your bank transactions for March.(i) Which report would show a bank charge from 31 March?(1 mark) Bank payment report dated 01 April to 30 AprilBank receipts report dated 01 March to 31 MarchBank payment report dated 01 March to 31 March 1Bank receipts report dated 01 April to 30 AprilYou have entered a cash sale into your accounting software.(j) Which three of the following reports would this transaction appear on?(3 marks) Sales general ledger account 1Bank receipts analysisBank payments analysisAudit trail 1Trial balanceCash receipts analysis 119

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeSection 2Tasks 2–6The model answers here are not exhaustive. The format of the document will depend on the accounting software used. Candidates may upload more than one pieceof documentary evidence per task.If the accounting software does not allow candidates to perform the task required, they can be awarded credit for performing a suitable alternative.Evidence 1 – Hairdressing sales analysis for the month of January 20XXTypeCash receiptCash receiptDate10 Jan29 JanDescriptionSales – hairdressingSales – ce 2 – Beauty purchases general ledger account for the month of January 20XXTypeBank paymentCash paymentDate23 Jan31 JanDescriptionPurchases – beautyPurchases – beautyVATYNDebit57.62356.00Credit413.6220

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeEvidence 3 – Cash payments analysis for the month of January 20XXDate7 Jan15 Jan18 Jan20 Jan31 JanDescriptionHairdressing equipmentAdvertising (hairdressing)Purchases (hairdressing)StationeryPurchases 001,852.0021

AAT Access Award in Accounting SoftwareAccess to Accounting Software – SAMS – Mark schemeEvidence 4 – Audit trail, showing full details of all ank receiptBank receiptBank paymentBank paymentBank receiptBank paymentBank paymentBank receiptBank paymentBank paymentCash paymentCash payment45Cash paymentCash paymentCash paymentCash receiptCash receiptCash receiptCash receiptAccount(s)Office equipment – costOffice equipment – depreciationMotor vehicles – costMotor vehicles – depreciationPrepaymentsBank current accountCash ngsB

Access to Accounting Software – SAMS – Assessment book . 2 . Notes for students . This sample assessment is designed to demonstrate as many of the possible question types you may find in a live assessment. It is not designed to be used on its own to determine whether you are ready for a live assessment. In a live assessment, you will be required to upload documents as part of your evidence .

Related Documents:

AAT Access – entry level 20 Introductory level 24 Intermediate level 28 Advanced level 32 AAT Bookkeeping and Computerised Accounting 38 AAT Bookkeeping 42 AAT Computerised Accounting 48. Why AAT? AAT Accounting Qualificatio

SUNSIGHT AAT RF Panel Antenna Alignment System – AAT MODELS AAT30 & AAT15 Description of the AAT System The AAT is a battery operated tool that measures azimuth, tilt, roll and height. Typical use of the AAT is for aligning RF cellular panel antennas. The AAT kit comes with all the basic items needed to perform most antenna alignment tasks.

Auto-Adjust II Turbo-Meters Parts List MP-1073E Rev. 4 4" Model AAT-18 and AAT-27 Auto-Adjust II Turbo-Meters Working Pressures: 175, 275, 720 & 1440 psi (Jqq, ,: fj A BTR Metering Systems Company 411 MODEL AAT-18 AND AAT-27 AUTO-ADJUST II TURBO-METERS GENERAL ASSEMBLY Body Assembly Components ILL. QTY. PART DESCRIPTION

- ASSOCIATION OF ACCOUNTING TECHNICIANS AQ2016 - AAT Professional Diploma in Accounting COURSE HANDBOOK AAT Level 4. AQ2016 - About AAT AAT works across the globe with around 130,000 members in more than 90 countries. Our members are represented at every level of the finance and accounting world, including students, people already working in accountancy and self-employed business owners. AAT .

Task 1 (12 marks) Practice assessment model answers – MDCL . AAT is a registered charity. No. 1050724 Task 2 (15 marks) AAT is a registered charity. No. 1050724 Task 3 (15 marks) AAT is a registered charity. No. 1050724 Task 4 (12 marks) AAT is a registered charity. No. 1050724 Task 5 (18 marks) Q Model Answer (a) Materials variances The general price of materials may have risen since the .

This practice assessment is one of a set of five AAT mock practice assessments which have been published for this subject. They are produced by expert AAT tutors to ensure real AAT exam style and real AAT exam standard tasks and ensure the best chance of success. All practice assessments are relevant for the current syllabus.

targeted towards the style of AAT assessment questions.” NIGEL HUGHES, AAT LECTURER “I started using Osborne texts in 2012, and since then I have always used them. They are extremely user-friendly and coincide well with the AAT syllabus. The students are really pleased with them.” HUSSAIN PATEL, AAT LECTURER . Follow us Like us 8 Call us: 01905 748071 Email us: books@osbornebooks.co.uk 9 .

Our AAT Advanced Diploma in Accounting course is the intermediate level of AAT’s accounting qualifications. You’ll master more complex accountancy skills, including advanced bookkeeping, preparing final accounts, and management costing techniques. You’ll also cover VAT issues in business, and the importance of professional ethics - all without giving up your job, family time or social .