LSBM208: Complete Cleaning Solution Services, a Business that Carries out Cleaning Services: Computer Applications in Accounting Assignment, UON, UK

Looking for Plagiarism free Answers for your US, UK, Singapore college/ university Assignments.

University University of Northampton(UON)
Subject Accounting

1.Assessment  Details

Part A – background information

Preparation of Accounts using computerised accounting software

This assessment asks you to input data into a computerised accounting package and produces documents and reports.

There are 14 tasks and it is important that you attempt all the tasks.

Hire a Professional Essay & Assignment Writer for completing your Academic Assessments

You need to produce all the reports and documents specified in the tasks.

DATA

This assessment is based on an existing business, Complete Cleaning Solution Services, a business that carries out cleaning services for local retail shops and offices.

The owner of the business is Zamira John, who operates as a sole trader.

At the start of the business, Zamira operated a manual bookkeeping system. She has decided to computerise the accounting system from 1 October 2020.

You are employed as an trainee Accountant.

You can assume that Zamira checked and authorised all the documentation. Cash and Credit sales are entered into one of the following two categories:

  • Retail Shop Cleaning
  • Office Cleaning

The business is VAT registered and the normal rate of VAT charged is 20%.

Some nominal ledger account codes are already in the system, but you may need to amend or alter them. Please remember the basic areas within the system for coding:

00XX – Asset accounts 1200 – Bank current 1210 – Petty cash

3000 – Capital and drawings 4000 – Sales

5000 – Purchases

7000 and 8000 – Expenses

Refer to the customer listing below. Enter the customer’s accounts and the opening balances into the system from the information as of the 1st October 2020

Customer name and addressCustomer accounting codeCustomer account details at 1 October 2020
Harris Accounting Services 5 Orford Hill, Norwich, Norfolk NR1 3QBHSA001Opening balance £530.58 Payment terms 30 days.
Blush Boutique 12, High Street, Norwich,Norfolk, NR12 9ANBB002Opening balance £728.96 Payment terms 30 days.
Petworth 24 St Brides, Burgh Road, Aylsham, Norwich, NR11 6AJP24003Opening balance £1,500.34 Payment terms 30 days.

Task 2

 Refer to the supplier listing below. Enter the supplier accounts and the opening balances in the system from the information as of the 1st October 2020.

Supplier name and addressSupplier account codeSupplier account details at 1st October 2020
JTR Cleaning Supplies 4 Nobel Villas,Waltham Abbey, EN9 1NUJTR002Opening balance £121.38 Payment terms 30 days.
Super Clean LTD 6 The Mazes, East Street, Braintree,Essex, CM7 3JJSCL002Opening balance £982.10 Payment terms 30 days.
The Specialists Winter Stoke Road, Bristol, BS3 2NSTSP004Opening balance £370.00 Payment terms 30 days.

Refer to the nominal ledger listings below.

Set up nominal ledger records for each account, entering the opening balances as at the 1st October 2020. You may need to amend, select, or create appropriate nominal ledger codes.

Create a trial balance to check the accuracy of your work and correct any errors. You do not need to save or print this report.

List of nominal ledgers as of 1 October 2020

Account namesDebit balance £Credit balance £
Van£11,000.00
Equipment£3189.00
Bank£1,789.52
Petty cash£300.00
Vat on sales£821.81
Vat on purchases£831.31
Capital£15,500.00
Sales – Retail Shop Cleaning£1,300.00
Sales – Office Cleaning£3084.42
Materials purchased£2310.00
SLCA*£2,759.88
PLCA*£1,473.48

*Note: As you have already entered opening balances for customers and suppliers you will not be required to enter these again.

Task 4

Refer to the summary of sales transactions below. Please process the invoices and credit notes into the system. Select appropriate nominal ledger codes for each transaction.

DateCustomerDetailsNetVatGross
05/10/2020BB002Invoice 512 for cleaning of office units£150.00£30.00£180.00
21/10/2020P24003Invoice 513 cleaning of retail units£127.00£25.40£152.40
09/10/2020BB002Credit note number 91 for missed office unit cleaning during the last visit£52.00£10.40£62.40

Refer to the following summary of purchase transactions below. Please process the invoices and credit notes for purchases made. Select appropriate nominal ledger codes for each transaction.

DateSuppliersDetailsNetVatGross
13/10/2020JTR Cleaning SuppliesInvoice number 421 for materials purchased 

£212.00

 

£42.40

 

£254.40

25/10/2020The SpecialistsInvoice number 321 for new ladders purchased for ongoing use 

 

£572.00

 

 

£114.40

 

 

£686.40

15/10/2020Super Clean LtdCredit note CRN201 for materials purchased 

£27.00

 

£5.40

 

£32.40

Task 6

  1. Payments were received, as listed in the table below. Please allocate the details to the relevant customer accounts in line with the instructions in the detail’s
  2. As no payments were received from Harris Accounting Services, please produce, and print a statement that can be sent to them to show the amounts
DateReceipt typeCustomerAmountDetails
18/10/2020BACSBlush Boutique£666.56Opening balance paid including credit note number 91
21/10/2020BACSPetworth 24£1000.00Payment on account

Please enter the following payments to suppliers on the system and allocate the payments to the relevant supplier accounts.

Ensure that you produce a remittance for each payment.

DatePayment typeCustomerAmountDetails
29/10/2020Cheque No 001237JTR Cleaning Supplies£121.38Opening balance paid
30/10/2020Cheque No 001238Super Clean Ltd£949.70Opening balance, including credit note CRN201

Task 8

Refer to the following cash sales listing, enter the transaction into the computer

DatePayment methodDetailsAmount
16th October 2020ChequeCash sale from retail outlet window clean£175.00 plus VAT

 

You receive a call from Zamira who informs you that he has taken £280.00 from the bank account on 17th October using his Debit card. This money is for his personal use and he would like you to record the payment in the bank account and corresponding ledger. Please process this payment.

Task 9

Refer to the standing order schedule shown below

DetailsAmountFrequency of paymentTotal number of paymentsPayment start datePayment end date
Advertising brochures (VAT exempt)£145.00One payment every month1225th October 202025th September 2021
  • Set up a recurring entry including the first payment processed
  • Produce a screen shot of setting up the recurring entry

Refer to the following petty cash vouchers for payments made, process these ensuring you allocate them to appropriate nominal ledger accounts.

DateVoucher number
PETTY CASH VOUCHER

Purchase of Office Stationery

25
09/10/2020
Gross£86.12
Vat£14.35
Net£71.77
DateVoucher number
PETTY CASH VOUCHER

Taxi to new customer meeting

26
15/10/2020
Gross£25.00
Vat£0.00
Net£25.00

 

 To ensure the petty cash account is maintained at the correct level of £300.00, transfer £131.12 from the bank to petty cash to restore the account as of 22nd October.

Refer to the following Journal entry and process accordingly

Journal entry 28/10/20££
Capital£120.00 

£120.00

Bank
Being an error in the opening balance

Refer to the Bank Statement below.

  1. Enter the Bank Interest Received £41.50 (No VAT) which has not been accounted
  2. Reconcile the bank account. If the bank statement does not reconcile, check your work, and make the necessary

 You do not need to print a bank reconciliation statement.

Great Yarmouth Bank 415 The High Street Norfolk

NR21 7UG

Complete Cleaning Solution Services 48 Church road

Great Yarmouth Norfolk

NR31 6ED.

Statement Number 3831 October 2020
STATEMENT OF ACCOUNT
DateDetailsPaid outPaid inBalance
01/10/2020Opening balance£1,789.52 C
16/10/2020Deposit of cash£210.00£1,999.52 C
17/10/2020Withdrawal£280.00£1,719.52 C
18/10/2020BACS Blush Boutique£666.56£2,386.08 C
21/10/2020Petworth 24£1000.00£3,386.08 C
22/10/2020Bank transfer£131.12£3,254.96 C
25/10/2020Standing order£145.00£3,109.96 C
31/10/2020Bank interest received£41.50£3,151.46C
D = Debit C = Credit

Print the following reports:

  • a customer activity report
  • a purchase return daybook
  • an aged creditor report
  • a trial balance as of 31st October
  • a full audit trail including full details of all transactions, including details of receipts/payments allocated to all items in customer/supplier accounts and details of bank-reconciled items
  • the materials purchased account in the nominal ledger showing all transactions. 

Task 14

  1. Select the appropriate option within the software to enter or change a password. Produce a screenshot of this tool which shows where the password can be done not enter a password on your work
  2. Create a back-up of your data using a suitable storage medium on which to save the back-up. Ensure you take a screenshot of the location of this back-up. Ensure you label the back-up with your name and the company.

Before you finish your work use the checklist below to ensure you have all the correct reports saved.

Checklist documents and reportsTaskWhen printed
Customer statement6
Remittance7
Screenshot of recurring transaction9
Customer activity13
Purchase returns daybook13
Aged creditors13
Trial balance13
Audit trail13
Material purchased account in Nominal13
Screenshot of password and back- up14

Task 1 

You are required to develop a Personal Development Plan (PDP) for the next 6 months. Illustrate how you aim to acquire new knowledge and skills to enhance your career prospect.

Task 2 

You are required to:

  • Reflect on your learning experience and
  • Conduct secondary research on other uses of SAGE

Task 3 

You are required to do research on how does technology impact accounting.

Hire a writer to get plagiarism free assignment answers of this question

Get Help By Expert

Do you want to relieve your homework load? Avail the most affordable accounting assignment help at studentsassignmenthelp.com. Our qualified expert Oxford assignment helpers provide homework help in your (lsbm208) computer applications in accounting assignment. We  offer on time  delivery and plagiarism free solution  for each assignment

 

Looking for Plagiarism free Answers for your US, UK, Singapore college/ university Assignments.

Get Support Instantly
info@studentsassignmenthelp.com
Quick Connect