ACCG1000 Xero Assignment:Report

Introduction

The Xero assignment is designed to provide introductory accounting students with an overview of the Xero Accounting Software by completing a one-month accounting cycle for a fictional business. This is an online assignment worth 20% of your overall grade in ACCG1000.

An invitation email will be sent to every student’s MQ email with the individual access link to Xero and an invitation to your organisation called Green Thumb Gardening Services by Wednesday the 3rd May 2023. Please ensure you accept this invitation so you can complete the Xero assignment. You can access the assignment from Week 9 to Week 11.

Assignment Objectives

To perform a variety of activities and to record several transactions using the Xero accounting software including:

• Setting up a new business in Xero
• Record cash received from customers and cash paid to suppliers
• Record other cash receipts and payments including prepayment of expenses and revenue received in advance
• Record adjusting entries
• Prepare several accounting reports including Receivable Invoice Detail Report; Payable Invoice Detail Report; Journal Report, Trial Balance, Statement of Profit & Loss and Balance Sheet.

Business Background

Assume that you established Green Thumb Gardening Services (a fictional business) on 1 May 2023 in Sydney. The company provides quality gardening services including lawn care, tree trimming and garden design in Sydney’s Northern Beaches. You are required to complete the following tasks in order to prepare the business’s financial statements as at 31 st May 2023.

1. Enter Business and bank Information:

Enter only the following company information by clicking on your organisation and selecting settings from the dropdown menu. Select organisation details and update only those items listed below. Please ignore the other details and leave them blank. DO NOT change “Display name”.

• Legal/Trading name: Your name Your Student ID (For example: CARMEL EMANUEL 12345)
• Line of business: Gardening Services
• Organisation type: Sole Trader

Once you have updated the above details scroll to the bottom of the screen and hit SAVE.

Enter the following bank information by accessing the accounting menu and selecting bank account. Add the following bank account details for a St George Bank account:

• Account Name: Business Savings Account
• Account Type: Everyday (day-to-day)
• Account Number: BSB: 112-100; Account Number: 1234567

Please ignore the batch payments details and hit continue. On the next screen choose “I’ve got a form” and on the next screen choose “I’ll do it later”.

2. Enter the following transactions for May 2023 by selecting the appropriate function from the business menu, the accounting menu or the “+” menu. The menu appears in Xero as below. (Ignore GST when entering all transactions)

PLEASE NOTE: You do not need to enter all transactions at the same time, however, please ensure you record the transactions in chronological order and use the dates given for each transaction. If you do not enter the correct dates, Xero will default to the date you are entering the transaction.

1/05/2023 You invested $30,000 cash to commence the business (Hint: From the accounting menu choose the manual journal function to enter this transaction).

3/05/2023 The business purchased a 12-month insurance policy for the business from Shield Insurance for $3,600 for the period 1 May 2023 to 30 April 2024. The due date for payment of this invoice is 30 days from the date the invoice was issued. The reference number is 2579. (Hint: From the business menu use the bills to pay function to enter this transaction as a new bill. Ensure you approve and save it).

4/05/2023 The business negotiated to borrow $25,000 from Southern Cross Bank Ltd for two years. The loan was due to be repaid by May 2025. (From the ‘+’ menu use the receive money function to enter this transaction and choose direct payment. You can ignore the reference column.)

08/05/2023 The business purchased new gardening equipment for $9,500 on credit from All Green Gardening Centre. The reference number is 561. The invoice is due to be paid by the 22nd May 2023. (Hint: From the business menu use the bills to pay function to enter this transaction as a new bill. Ensure you approve and save it.)

11/05/2023 Provided gardening services to a new client Tony Fletcher and invoiced him $2,100. This invoice is due to be paid by the 25 th May 2023 and the reference number is 3064. The invoice number should be auto generated as Inv-0001. (Hint: From the business menu use the invoices function to enter this transaction as a new invoice. Ensure you approve and save it.)

12/05/2023 Purchased and paid $1,360 for gardening supplies from Quality Garden Suppliers to be used for garden maintenance. The reference number is 1490. (Hint: From the ‘+’ menu use the spend money function to enter this transaction and choose prepayment.)

(Add a new current asset account “Gardening Supplies”. Use “122” as the Account Code. Ensure you SAVE the details).

15/05/2023 Designed a new garden for Seabreeze Properties’ office premises in Dee Why and invoiced the client $5,700. This invoice is due to be paid by the 29 th May 2023 and the reference number is 9423. The invoice number should be auto generated as Inv-0002. (Hint: From the ‘+’ menu use the invoice function to enter this transaction. Take care you choose the correct revenue account.)

16/05/2023 Received and paid an invoice for $770 from The Mower Medic for repairs to the ride-on lawn mower. The reference number is 2485. (Hint: From the ‘+’ menu use the bill function to enter this transaction. Ensure you approve and pay it on the same day.)

18/05/2023 Provided lawn mowing services to Saddleridge Horse Stables and invoiced the client $4,200. This invoice is due to be paid by the 28 th May 2023 and the reference number is 4367. The invoice number should be auto generated as Inv-0003. (Hint: From the business menu use the invoices function to enter this transaction as a new invoice. Ensure you approve and save it.)

20/05/2023 Tony Fletcher paid its outstanding invoice issued on the 11th May 2023 in full. (Hint: From the business menu use the invoices function to receipt this cash by selecting the invoice and completing the receive payment details.)

21/05/2023 Paid All Green Gardening Centre for the new gardening equipment purchased on the 8th May 2023. (Hint: From the business menu use the bills to pay function to pay this outstanding bill by selecting the bill and completing the payment details.)

24/05/2023 Completed a gardening services project for Terry Hillside Public School including lawn care, tree trimming and weeding services. The client was invoiced $3,400 for the total cost of the gardening services project. This invoice is due to be paid by the 24 th June 2023 as the client was given extended credit terms. The reference number is 1478. The invoice should be auto generated as Inv-0004. (Hint: From the ‘+’ menu use the invoice function to enter this transaction. Take care you choose the correct revenue account.)

25/05/2023 Received $5,700 from Seabreeze Properties. The client paid the invoice issued on the 15 th May 2023 in full. (Hint: From the business menu use the invoices function to receipt this cash by selecting the invoice and completing the receive payment details.)

25/05/2023 Received and paid an invoice for $410 from AdMasters Pty Ltd for advertising the business for the month of May 2023. (Hint: From the ‘+’ menu use the spend money function to enter this transaction and choose direct payment.)

27/05/2023 Completed the design of a new outdoor garden for Ivy Robinson at her home in Avalon and invoiced the client $3,800. This invoice is due to be paid by the 8 th June 2023 and the reference number is 8632. The invoice should be auto generated as Inv-0005. (Hint: From the ‘+’ menu use the invoice function to enter this transaction. Take care you choose the correct revenue account.)

28/05/2023 Green Thumb Gardening Services signed a contract to provide garden maintenance to a new client Celebrations Function Centre for the next three months, commencing on the 1st June 2023. The business received $3,000 in advance from the client for the gardening services. (Hint: From the ‘+’ menu use the receive money function to enter this transaction and choose direct payment. You can ignore the reference column.)

PLEASE NOTE: The next five transactions are adjusting entries which you are required to enter as manual journal entries. From the accounting menu select manual journals.

31/05/2023 On the 31st May 2023, only $420 worth of gardening supplies purchased on the 12th May remained on hand. (Add a new expense account “Gardening Supplies Expense”. Use “515” as the Account Code. Ensure you SAVE the details.)

31/05/2023 Interest expense on the bank loan is accrued at $750 per month. The interest is paid to the bank quarterly and the first interest payment is due on the 1st August 2023. (Add a new current liability account “Interest Payable”. Use “210” as the Account Code. Ensure you SAVE the details.)

31/05/2023 Depreciation on the Gardening Equipment is $2,400 per year. All assets are depreciated for a full month regardless of the date acquired.

31/05/2023 Record the insurance expense expired for the month of May 2023. 31/05/2023 Wages of $1,020 are owed to casual employees as at 31 May 2023 and will be paid on the 6 th June 2023.

3. Prepare and export the following reports (in PDF format) from Xero for the month ending 31 May 2023 using the reports function from the accounting menu:

1. Receivable Invoice Detail Report,
2. Payable Invoice Detail Report,
3. Journal Report,
4. Trial Balance,
5. Statement of Profit and Loss
6. Balance Sheet

4. Merge all six reports into one PDF document and submit your assignment on ilearn using the link provided at section 6 “Assessment: Xero Assignment (20%).