Make a Xero aged accounts payable summary with the information below:

Schedule of Accounts Payable as at 30 June 2021 Account No. Account Name Amount ($) 201001 9,640 CC Importers Cups R Us 201002 6,400 Invoice 6501, due 02 July 2021 Invoice 6505, due 07 July 2021 Invoice 6520, due 09 July 2021 Invoice 6535, due 10 July 2021 201003 Hotel Catering Supplies 6,810 201004 Mid Vest Consumables 11,950 34,800 Schedule of Inventory as at 30 June 2021 Product Code Product Description Unit of Measure Quantity Unit Cost on Hand (GST exc) Total Cost Unit Selling Price (GST exe) AS330 Carton 300 60.00 18,000 100.00 KEL675 Carton 200 85.00 17,000 115.00 Coffee cup lids Boz biodegradable coffee cups 12oz biodegradable coffee cups KEL685 Carton 150 95.00 14,250 125.00 MA121 600ml rectangular takeaway containers Carton 500 45.00 22,500 75.00 MA122 750ml rectangular takeaway containers Carton 400 50.00 20,000 100 PHO22 Rectangular takeaway container lids Carton 578 25.00 14,450 40.00 106,200 1 N 2 3 4 5 5 7 10 11 12 Invoiced R1002 Black Bean Espresso for a sale on credit of 10 x AS330 Coffee cup lids and 10 x KEL685 120z biodegradable coffee cups. The invoice (number 3540) contained the GST inclusive amounts of $1,100.00 for AS330 and $1,375.00 for KEL685. Paid 201001 CC Importers the amount owing for invoice 6501 by EFT. Paid the annual rates account on the premises to Hobart City Council (for the period 1 July 2021 to 30 June 2022) of $1200.00 by EFT. Made a cash sale (invoice number 3541) of 10 x MA121 500ml rectangular takeaway containers, 10 x MA122 750ml rectangular takeaway containers and 20 x PH022 rectangular takeaway containers lids. The invoice contained the GST inclusive amounts of $825.00 for MA121, 5990.00 for MA122 and $880.00 for PHO22. Received an EFT payment of $11,840.00 from R1002 Black Bean Espresso in full payment for invoice 3501. Receipt number 6002. Paid the annual insurance premium (1/7/2021 to 30/6/2022) on the premises by EFT. Policy number BABX4982. The amount of payment was $605.00 GST inclusive Paid 201002 Cups R Us the amount owing for invoice 6505 by EFT. Received a cheque of 58,300.00 from R1010 Tony's Bar and Grill in full payment for invoice 3505. Receipt number 6004. Paid 201003 Hotel Catering Supplies the amount owing for invoice 6520 and 201004 Mid Vest Consumables the amount owing for invoice 6535. Both payments were made by EFT. Received a delivery of inventory from 201002 Cups R Us of 50 KEL685 120z biodegradable coffee cups. Invoice number 6540. Invoiced R1020 Vesuvio's Italian Ristorante for a sale on credit of 15 x MA122 750ml rectangular takeaway containers and 15 x PH022 rectangular takeaway container lids. The invoice (number 3542) contained the GST inclusive amounts of $1485.00 for MA122 and $660.00 for PHO22. Paid at the local Australia Post with a debit card attached to the business bank account (reference number: 123456) a Telstra Account from the previous month of $650.00 (GST inclusive) and for stationary of $220.00 (GST inclusive). Run a payroll for the last fortnight. David worked his normal hours for his salary, Scarlett worked 70 hours (at the hourly rate of $35.50). A transfer of 57,000.00 was made from the business bank account to the payroll bank account io.order to cover the wages for the previous fortnight (see previous transaction). Record the EFT payment of the wages from the payroll bank account. Paid for some advertising in The Mercury for the next three months by EFT. The amount of the payment was $1650.00 (GST inclusive) Received a cheque of $3500.00 from R1020 Vesuvio's Italian Ristorante in part payment for invoice 3520. Receipt number 5005. Made a cash sale (invoice 3543) of 20 x AS330 Coffee cup lids and 20 X KEL675 8 oz biodegradable coffee cups. The invoice contained the GST inclusive amounts of $2200.00 for AS330 and $2530.00 for KEL675. Paid 201002 Cups R Us the amount owing for invoice 6540 by EFT. 13 13 14 14 15 16 25 X 26 28 28 29 Run a payroll for the last fortnight. David worked his normal hours for his salary, Scarlett worked 80 hours ($35.50 per hour). A transfer of $7,500 was made from the business bank account to the payroll bank account jo_order to cover the wages for the previous fortnight (see next previous). Record the EFT payment of the wages from the payroll bank account Received a cheque of $1,500.00 from R1002 Black Bean Espresso in part payment for invoice 3540. Receipt number 6006. Invoiced R1010 Tony's Bar and Grill for a sale on credit of 10 x MA121 600ml rectangular takeaway containers and 10 x PHO22 rectangular takeaway container lids. The invoice (number 3544) contained the GST inclusive amounts of $825.00 for MA121 and 5440.00 for PH022 Received the Telstra account for this month of $660.00 (GST inclusive). 29 31 31 Complete the following adjustments for the month: Run the depreciation on the fixed assets (the three fixed assets can be depreciated on a straight-line basis at 10% per annum of cost). Adjust the allowance for bad and doubtful debts to 3% of the accounts receivable balance. A stocktake of stationary reveals that there is $600.00 worth of stationary on hand. Accrue the interest on the loan (the interest rate on the loan is 5% per annum). Record the adjustment for the rates expense. Record the adjustment for the insurance expense. Record the adjustment for the advertising expense. A stocktake of inventory reveals there is a shortage of 10 cartons of KEL585 and 8 cartons of AS330. Record the adjustment for this shortage. Schedule of Accounts Payable as at 30 June 2021 Account No. Account Name Amount ($) 201001 9,640 CC Importers Cups R Us 201002 6,400 Invoice 6501, due 02 July 2021 Invoice 6505, due 07 July 2021 Invoice 6520, due 09 July 2021 Invoice 6535, due 10 July 2021 201003 Hotel Catering Supplies 6,810 201004 Mid Vest Consumables 11,950 34,800 Schedule of Inventory as at 30 June 2021 Product Code Product Description Unit of Measure Quantity Unit Cost on Hand (GST exc) Total Cost Unit Selling Price (GST exe) AS330 Carton 300 60.00 18,000 100.00 KEL675 Carton 200 85.00 17,000 115.00 Coffee cup lids Boz biodegradable coffee cups 12oz biodegradable coffee cups KEL685 Carton 150 95.00 14,250 125.00 MA121 600ml rectangular takeaway containers Carton 500 45.00 22,500 75.00 MA122 750ml rectangular takeaway containers Carton 400 50.00 20,000 100 PHO22 Rectangular takeaway container lids Carton 578 25.00 14,450 40.00 106,200 1 N 2 3 4 5 5 7 10 11 12 Invoiced R1002 Black Bean Espresso for a sale on credit of 10 x AS330 Coffee cup lids and 10 x KEL685 120z biodegradable coffee cups. The invoice (number 3540) contained the GST inclusive amounts of $1,100.00 for AS330 and $1,375.00 for KEL685. Paid 201001 CC Importers the amount owing for invoice 6501 by EFT. Paid the annual rates account on the premises to Hobart City Council (for the period 1 July 2021 to 30 June 2022) of $1200.00 by EFT. Made a cash sale (invoice number 3541) of 10 x MA121 500ml rectangular takeaway containers, 10 x MA122 750ml rectangular takeaway containers and 20 x PH022 rectangular takeaway containers lids. The invoice contained the GST inclusive amounts of $825.00 for MA121, 5990.00 for MA122 and $880.00 for PHO22. Received an EFT payment of $11,840.00 from R1002 Black Bean Espresso in full payment for invoice 3501. Receipt number 6002. Paid the annual insurance premium (1/7/2021 to 30/6/2022) on the premises by EFT. Policy number BABX4982. The amount of payment was $605.00 GST inclusive Paid 201002 Cups R Us the amount owing for invoice 6505 by EFT. Received a cheque of 58,300.00 from R1010 Tony's Bar and Grill in full payment for invoice 3505. Receipt number 6004. Paid 201003 Hotel Catering Supplies the amount owing for invoice 6520 and 201004 Mid Vest Consumables the amount owing for invoice 6535. Both payments were made by EFT. Received a delivery of inventory from 201002 Cups R Us of 50 KEL685 120z biodegradable coffee cups. Invoice number 6540. Invoiced R1020 Vesuvio's Italian Ristorante for a sale on credit of 15 x MA122 750ml rectangular takeaway containers and 15 x PH022 rectangular takeaway container lids. The invoice (number 3542) contained the GST inclusive amounts of $1485.00 for MA122 and $660.00 for PHO22. Paid at the local Australia Post with a debit card attached to the business bank account (reference number: 123456) a Telstra Account from the previous month of $650.00 (GST inclusive) and for stationary of $220.00 (GST inclusive). Run a payroll for the last fortnight. David worked his normal hours for his salary, Scarlett worked 70 hours (at the hourly rate of $35.50). A transfer of 57,000.00 was made from the business bank account to the payroll bank account io.order to cover the wages for the previous fortnight (see previous transaction). Record the EFT payment of the wages from the payroll bank account. Paid for some advertising in The Mercury for the next three months by EFT. The amount of the payment was $1650.00 (GST inclusive) Received a cheque of $3500.00 from R1020 Vesuvio's Italian Ristorante in part payment for invoice 3520. Receipt number 5005. Made a cash sale (invoice 3543) of 20 x AS330 Coffee cup lids and 20 X KEL675 8 oz biodegradable coffee cups. The invoice contained the GST inclusive amounts of $2200.00 for AS330 and $2530.00 for KEL675. Paid 201002 Cups R Us the amount owing for invoice 6540 by EFT. 13 13 14 14 15 16 25 X 26 28 28 29 Run a payroll for the last fortnight. David worked his normal hours for his salary, Scarlett worked 80 hours ($35.50 per hour). A transfer of $7,500 was made from the business bank account to the payroll bank account jo_order to cover the wages for the previous fortnight (see next previous). Record the EFT payment of the wages from the payroll bank account Received a cheque of $1,500.00 from R1002 Black Bean Espresso in part payment for invoice 3540. Receipt number 6006. Invoiced R1010 Tony's Bar and Grill for a sale on credit of 10 x MA121 600ml rectangular takeaway containers and 10 x PHO22 rectangular takeaway container lids. The invoice (number 3544) contained the GST inclusive amounts of $825.00 for MA121 and 5440.00 for PH022 Received the Telstra account for this month of $660.00 (GST inclusive). 29 31 31 Complete the following adjustments for the month: Run the depreciation on the fixed assets (the three fixed assets can be depreciated on a straight-line basis at 10% per annum of cost). Adjust the allowance for bad and doubtful debts to 3% of the accounts receivable balance. A stocktake of stationary reveals that there is $600.00 worth of stationary on hand. Accrue the interest on the loan (the interest rate on the loan is 5% per annum). Record the adjustment for the rates expense. Record the adjustment for the insurance expense. Record the adjustment for the advertising expense. A stocktake of inventory reveals there is a shortage of 10 cartons of KEL585 and 8 cartons of AS330. Record the adjustment for this shortage