Question: Using Xero information answer this Enter the following transactions for October 2023 by selecting the appropriate function from the business menu, the accounting menu or
Using Xero information answer this
Enter the following transactions for October 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/10/2023 You invest $35,000 cash to commence the business (Hint: From the + menu use the receive money function to enter this transaction and choose direct payment. You can ignore the reference column). 4/10/2023 The business negotiated to borrow $20,000 from Northwestern Bank Ltd for three years. The loan was due to be repaid by October 2026. (From the + menu use the receive money function to enter this transaction and choose direct payment. You can ignore the reference column). 5 5/10/2023 The business paid Blaxland Real Estate $ 6,000 relating to the rental of the businesss new office premises in Botany for two months commencing on the 1st October. The reference number is 226. (Hint: From the + menu use the spend money function to enter this transaction and choose prepayment. Ensure you approve and save it). 09/10/2023 The business purchased and paid $2,150 for cleaning supplies from Quality Cleaning Suppliers. The reference number is 2412. (Hint: From the + menu use the spend money function to enter this transaction and choose prepayment. Ensure you approve and save it). (Add a new current asset account Cleaning Supplies. Use 115 as the Account Code. Ensure you SAVE the details). 10/10/2023 The business purchased new cleaning equipment for $12,200, on credit, from Crystal Clear Cleaning Equipment. The reference number is 165. The invoice is due to be paid by the 23rd October 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). 13/10/2023 Provided home cleaning services to a new client Belinda Nelson and invoiced her $1,100. This invoice is due to be paid by the 27th October 2023 and the reference number is 2010. 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). 14//10/2023 Received and paid an invoice for $530 from HiPages Advertising to advertise the business for the month of October. The reference number is 5793. (Hint: From the + menu use the bill function to enter this transaction. Ensure you approve and pay it on the same day). 17/10/2023 Provided cleaning services to Oceanview Real Estates office premises in Bondi and Bronte and invoiced the client $4,700. This invoice is due to be paid by the 17 th November 2023 as the client was given extended credit terms. The reference number is 1849. The invoice number should be auto generated as Inv-0002. (Hint: From the + menu use the invoice function to enter this transaction. Ensure you approve and save it). 18/10/2023 Provided office cleaning services to Quantum Leap Software and invoiced the client $4,900. This invoice is due to be paid by the 28 th October 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). 22/10/2023 Belinda Nelson paid her outstanding invoice issued on the 13 th October 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). 23/10/2023 Paid Crystal Clear Cleaning Equipment for the new cleaning equipment purchased on the 10th October 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). 6 24/10/2023 Completed an end-of-lease cleaning project for RKM Management Consultants The client was invoiced $3,400 for the total cost of the cleaning project. This invoice is due to be paid by the 8 th November 2023. The reference number is 1964. The invoice should be auto generated as Inv-0004. (Hint: From the + menu use the invoice function to enter this transaction. Ensure you approve and save it). 25/10/2023 Received a bill for $410 from The Vacuum Medic for repairs to the carpet and upholstery shampoo cleaner. The bill is due to be paid on 4th November 2023. The reference number is 1917. (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). 27/10/2023 Golden Touch Cleaning Services signed a contract to provide cleaning services for the next three months to a new client, A Taste of Italy, an Italian restaurant in Maroubra. The contract is due to start on the 1st November 2023. The business received $5,000 in advance from the client for the cleaning services (Hint: From the + menu use the receive money function to enter this transaction and choose direct payment. You can ignore the reference column) 28/10/2023 Completed a major clean-up of five classrooms at Little Bay Secondary School after a burst water pipe flooded them. The school was invoiced $3,800 for the job. This invoice is due to be paid by the 11th November2023 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. Ensure you approve and save it). 29/10/2023 Received $4,900 from Quantum Leap Software for full payment of the invoice issued to the client on the 18th October 2023. (Hint: From the business menu use the invoices function to receipt this cash by selecting the invoice and completing the receive payment details). 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/10/2023 Received a mobile phone bill for $1,850 from PMG Mobile for the month of October 2023. The bill is due to be paid on the 28th November 2023. (Add a new current liability account Mobile Phone Payable. Use 210 as the Account Code. Ensure you SAVE the details) 31/10/2023 On the 31st October 2023, only $990 worth of cleaning supplies purchased on the 9 th October remain on hand. (Add a new expense account Cleaning Supplies Expense. Use 515 as the Account Code. Ensure you SAVE the details.) 31/10/2023 Depreciation on the cleaning equipment is $2,400 per year. All assets are depreciated for a full month regardless of the date acquired. 31/10/2023 Record the rent expense for the month of October 2023. 31/10/2023 Wages of $1,290 are owed to three employees as at 31 October 2023 and will be paid on the 6 th November 2023.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
