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 Sydneys Northern Beaches. You are required to complete the following tasks in order to prepare the businesss financial statements as at 31 st May 2023.

Create a Balance Sheet

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 25th 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 29th 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 28th 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 24th 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 15th 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 8th 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 6th 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: 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 25th 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 29th 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 28th 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 24th 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 15th 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 8th 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 6th 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