Xero assignment how can reconcile with these items

actions for July you have completed the setting up of Xero, you can now enter the following actions. The values given here do not include GST unless you are told otherwise. ce y 1 Details Purchased 16 boxes of Item no. 6001 8oz Takeaway Lids (Box 1000) from Olam Specialty Coffee, terms net 30 Purchased 38 boxes of Item no. 5002 CSR Gourmet Cubed Sugar from Crop Del Monte, 2/10, n/30. Obtained a $275,000 loan from Bank Australia at a simple interest rate of 5% per year. The first interest payment is due at the end of September 2020 and the principal of the loan is to be repaid at the beginning of July four years later. Purchased for cash five Dutch Cargo Urban Arrow Cargo L electric bicycles from Captain Walker's Bicycles as part of a plan to provide an eco-delivery service in the local area. The bicycles have a useful life of three years, are depreciated on a straight-line basis and have no residual value. The unit price of the bicycles was $8,325 each but as this was a significant order, the supplier provided a 15% trade discount. Reference 911 Paid the full amount owing to FTA Speciality Coffee. Reference 912. Paid the full amount owing to Kolibri Kofe. Reference 913. 2 3 Purchased with cash, 12 boxes of Item no. 5003 Bannister Downs Gourmet Cream from North Street Bakery. Reference 914. Made cash sales during the first four days of the month. The follow inventory was sold. No reference applies... Wat Choose . . . . 2 x 7001 Le Marzocco Linea Mini Coffee Machine @ $5,990.00 5 x 7003 Baratza Forte Grinder @ $1,089.00 each 10 kg x 4302 Dark Horse Blend 1kg @352 per kg 20 kg x 4305 Leonid Ramirez Beans @ 62.00 per kg 5 kg of 4310 Panama Geisha beans at $269.00 per kg 48 tubs of 5003 Bannister Downs Gourmet Cream at $167.76 per box of 24 tubs. 20 boxes x 5005 Premium Drinking Chocolate at @18.00 per box 10,000 6001 8oz Takeaway lids. The sell price is $109.40 per 1,000 lids 30,000 6002 12oz Takeaway lids. The sell price is $108.90 per 1,000 lids. 8 boxes of 6003 Whadjuk Dreaming KeepCups. Each box contains 12 cups and the sell price of a single cup is $12.10. The cups are sold as a single unit 12 boxes of 6004 Whadjuk Dreaming KeepCup Brew. The sell price of a single box of 12 cups is $261.36. The cups are kept in inventory as a single unit. . 6 . . . . . Today was a trade promotion day and the following credit sales of Item no. 4313 Honduras Blue coffee beans occurred: 10 bags to Fothergill Bed and Breakfast 20 bags to Sarah's Hot Spot 5 bags to Revamp Coffee Carts 6 bags to Freewheelin Coffee 9 bags to ChillZone 6 bags to Mod Coffee 4 bags to Fremantle Coffee 140 bags to a new customer who owns several cafes in schools and provides industrial catering services. The new customer is Mio Sapore Foods Sold 100 bags of Item no. 4301 Medium Roast Arabica Coffee Beans to Chillzone on Fremantle Coffee paid the full amount owing on their account as of June 30. Made a significant sale to Chillzone for an upcoming catering contract. Given the size of the order, a trade discount of 10% was given. The discount is to be applied to the retail prices as recorded in the inventory system. The items purchased where ... . 7 account 9 9 10 x Panama Geisha 20 x Colombian Reserve 100 x Rwandan Single Origin 20 10x Chocolate sprinkles 10x CSR Gourmet Sugar Cubes 100 x Premium Drinking Chocolate 200 x Raw Sugar Sticks (Box of 2000] 300 x White Sugar Sticks (Box of 2000) 1 x Le Marzocco Linea Mini Coffee Machine 10 Purchased 257 replacement bags of 4313 Honduras Blue beans on credit from Honduras Gourmet Coffee. The roastery has increased the price to $18.50 per bag. The inventory records will need to be updated to reflect this. Made the following cash sales during the week. 11 10 x Leonid Ramirez beans 23 x Ardi Beans 106 x Cleanskin Blend - On special for the week - 10% discount 27 x Organic Blend 11 x Panama Geisha 18x Colombian Reserve 37 x Honduras Blue - On special @$36 each 41 x Chocolate Sprinkles 1 x Bannister Downs Gourmet Cream (Box of 24) 32 x Premium Drinking Chocolate 2 x Whadjuk Dreaming KeepCup Brew (Box of 12) 4 x Isomac Tea Coffee Machines 2 x Le Marocco Linea Mini Coffee Machines 10 x Milk Jug Rinser Chillzone returned product to the value of $5.990 including GST which had been purchased before June 30 and which was not suitable for them. A credit note was issued Sold 40 boxes of Item No. 5001 Chocolate Sprinkles to Sarah's Hot Spot on credit. 12 13 Paid the full amount owing to Moledina Commodities, reference 915 15 Paid sales staff wages for the two weeks up to and including yesterday, reference 916. The wages expense is $25,515 17 Sold 10 boxes of 8oz Takeaway Lids (Box of 1000) to Revamp Coffee Carts on account 18 The following items were sold during the week for cash: 10x Tightrope Blend 123 x Rwanda Single Origin 206 x Cleanskin Blend - On special for the week-20% discount 54 x Organic Blend 38 x Colombian Reserve 36 x Medium Roast Arabica Coffee 67 Crompton Road Blend 23 x Panama Geisha 41 x Raw Sugar Sticks (Box of 2000) 33 x White Sugar Sticks Box of 2000) 21 18 x Premium Drinking Chocolate 5x Whadjuk Dreaming KeepCup (Box of 12) 4x Isomac Tea Coffee Machines 1 x Le Marzocco Linca Mini Coffee Machines 6x Mazzer Mini Grinder 18 19 Returned a faulty product which is no longer carried in inventory, which was purchase before June 30 to Olam Specialty Coffee. Received a credit note for $7,015 GST inclusive. Sarah's Hot Spot paid a portion of their account. The payment was for S1,500 Chillzone paid the full amount owing on their account. Received a purchase order from Sarah's Hot Spot for 12 Bannister Downs Gourmet Cream (Box of 24). Created a corresponding sales order (quote) to deliver gourmet cream. 21 21 24 Completed the July 21 order for gourmet cream (credit sale made by Sarah's Hot Spot. 25 The following items were sold during the week for cash: 13 x Dark Horse Blend 57 x Risaralda Decaf 92 x Leonid Ramirez 65 x Organic Blend 76 x Cleanskin Blend 24 x Panama Geisha 37 x Colombian Reserve 36 Rwandan Single Origin 95 x Honduras Blue - On special $35.03 each 41 CSR Gourmet Sugar Cubes 33 x Chai Latter Powder 39 x 120 Takeaway Lids (Box of 10001 8. Whadjuk Dreaming KeepCup Brew (Box of 12) 2x Le Marrocco Linea Mini Coffee Machines 4x Baratza Forte Grinder 6x Mazzer Mini Grinder 1 x Acaia Lunar Scale Paid the full amount owing to Crop Del Monte, reference 917 Paid the full amount owing to Olam Specialty Coffee, reference 918 Ordered 28 x 5004 Organic Chocolate Cream Liqueur from Kolibri Kofe. Agreed terms with Kolibri Kofe are 2/10,n/30. This is a new inventory item. It is purchased for $27.50 per item 26 27 28 Week 5 29 Paid sales staff wages $27.910 for the two weeks up to and including yesterday. reference 919 22 FC Onpest-Fe Received Organic Chocolate Cream Liqueur, which was ordered on the 28th, agreed terms with Kolibri Kofe are 2/10,n/30. More Freewheelin Coffee paid the full amount owing on their account. The following items were sold during the week for cash: 6 x Medium Roast Arabica Coffee 12 x Dark Horse Blend 36 x Crompton Road Blend 29 x Leonid Ramirez 43 x Ardi 42 x Panama Geisha 73 x Colombian Reserve 14 x CSR Gourmet Sugar Cubes 93 x 8oz Takeaway Lids (Box of 1000] 1x Whadjuk Dreaming KeepCup (Box of 12] 2 x Le Marzocco Linea Mini Coffee Machines 2 x Acaia Lunar Scale Paid Bindi a monthly salary of $26,000, reference 920 31 JO Complete the bank reconciliation in Xero. You will need to create and upload the bank statement using the template provided by Xero. For reconciliation purposes use your conversion cash at bank balance as the opening balance To account for uncleared cheques, see the relevant additional help files in Xero Central The applicable information is Uncleared Deposits account number is 101 Uncleared Cheques account number is 252 There are possible bank error(s). Items which are possible bank errors will remain unreconciled. Possible bank errors are normally reported to the bank. Posting in the discussion board is our equivalence of doing the same. Record the following adjusting entries for July 31 Depreciation expense using Xero's Fixed Assets feature Estimated electricity payable to Synergy Ltd for the month is $4,370 Estimated water usage payable to the Water Corporation for the month is $1,175 Wages incurred during the month but not yet paid to sales staff is $6,600 Interest expense incurred during the month but not yet paid to Bank Australia is S1,145 Interest earned from short-term investments with Bank Australia during the month but not yet paid amount to $165 The value of office supplies used during the month are $20,185 23 Create Discuss e contact During the month, prepaid rent to the value of $15,000 expired What Choose the con in During the month, prepaid advertising to the value of $15,000 expired During the month, prepaid insurance to the value of $2,950 expired Next 31 Prepare and submit any reports as specified including your month end report (memo Bindi Tjandamurra. Note: . Invoice and credit note numbers are as allocated by Xero. Reference refers to cheque number. Enter this number in the applicable reference field. . THE Reconcile (22) Cash coding Bank statements Account transactions What's this? Review your bank statement lines... ...then match with your transactions in Xero Spent - Received - Spent Received Options - Match Create Discuss Find & Match 3,500.00 2 Jul 2021 910 More details Who FTA Specialty Coffee I What Choose the account Why Paid the full amount Tax Rate Add details Match Create Discuss Find & Match Options 275,000.00 Who Name of the contact What Choose the account. 43UA 2021 Loan More details Why Enter a description Tax Rate Add details Match Create Discuss Find & Math Gitions 18.425.00 Who Name at the contact What Choose the account 4 Jul 2021 Freewheelin Coffee Deposit - Freewheelin Cotton More details Why Enteraction Thx Adid details actions for July you have completed the setting up of Xero, you can now enter the following actions. The values given here do not include GST unless you are told otherwise. ce y 1 Details Purchased 16 boxes of Item no. 6001 8oz Takeaway Lids (Box 1000) from Olam Specialty Coffee, terms net 30 Purchased 38 boxes of Item no. 5002 CSR Gourmet Cubed Sugar from Crop Del Monte, 2/10, n/30. Obtained a $275,000 loan from Bank Australia at a simple interest rate of 5% per year. The first interest payment is due at the end of September 2020 and the principal of the loan is to be repaid at the beginning of July four years later. Purchased for cash five Dutch Cargo Urban Arrow Cargo L electric bicycles from Captain Walker's Bicycles as part of a plan to provide an eco-delivery service in the local area. The bicycles have a useful life of three years, are depreciated on a straight-line basis and have no residual value. The unit price of the bicycles was $8,325 each but as this was a significant order, the supplier provided a 15% trade discount. Reference 911 Paid the full amount owing to FTA Speciality Coffee. Reference 912. Paid the full amount owing to Kolibri Kofe. Reference 913. 2 3 Purchased with cash, 12 boxes of Item no. 5003 Bannister Downs Gourmet Cream from North Street Bakery. Reference 914. Made cash sales during the first four days of the month. The follow inventory was sold. No reference applies... Wat Choose . . . . 2 x 7001 Le Marzocco Linea Mini Coffee Machine @ $5,990.00 5 x 7003 Baratza Forte Grinder @ $1,089.00 each 10 kg x 4302 Dark Horse Blend 1kg @352 per kg 20 kg x 4305 Leonid Ramirez Beans @ 62.00 per kg 5 kg of 4310 Panama Geisha beans at $269.00 per kg 48 tubs of 5003 Bannister Downs Gourmet Cream at $167.76 per box of 24 tubs. 20 boxes x 5005 Premium Drinking Chocolate at @18.00 per box 10,000 6001 8oz Takeaway lids. The sell price is $109.40 per 1,000 lids 30,000 6002 12oz Takeaway lids. The sell price is $108.90 per 1,000 lids. 8 boxes of 6003 Whadjuk Dreaming KeepCups. Each box contains 12 cups and the sell price of a single cup is $12.10. The cups are sold as a single unit 12 boxes of 6004 Whadjuk Dreaming KeepCup Brew. The sell price of a single box of 12 cups is $261.36. The cups are kept in inventory as a single unit. . 6 . . . . . Today was a trade promotion day and the following credit sales of Item no. 4313 Honduras Blue coffee beans occurred: 10 bags to Fothergill Bed and Breakfast 20 bags to Sarah's Hot Spot 5 bags to Revamp Coffee Carts 6 bags to Freewheelin Coffee 9 bags to ChillZone 6 bags to Mod Coffee 4 bags to Fremantle Coffee 140 bags to a new customer who owns several cafes in schools and provides industrial catering services. The new customer is Mio Sapore Foods Sold 100 bags of Item no. 4301 Medium Roast Arabica Coffee Beans to Chillzone on Fremantle Coffee paid the full amount owing on their account as of June 30. Made a significant sale to Chillzone for an upcoming catering contract. Given the size of the order, a trade discount of 10% was given. The discount is to be applied to the retail prices as recorded in the inventory system. The items purchased where ... . 7 account 9 9 10 x Panama Geisha 20 x Colombian Reserve 100 x Rwandan Single Origin 20 10x Chocolate sprinkles 10x CSR Gourmet Sugar Cubes 100 x Premium Drinking Chocolate 200 x Raw Sugar Sticks (Box of 2000] 300 x White Sugar Sticks (Box of 2000) 1 x Le Marzocco Linea Mini Coffee Machine 10 Purchased 257 replacement bags of 4313 Honduras Blue beans on credit from Honduras Gourmet Coffee. The roastery has increased the price to $18.50 per bag. The inventory records will need to be updated to reflect this. Made the following cash sales during the week. 11 10 x Leonid Ramirez beans 23 x Ardi Beans 106 x Cleanskin Blend - On special for the week - 10% discount 27 x Organic Blend 11 x Panama Geisha 18x Colombian Reserve 37 x Honduras Blue - On special @$36 each 41 x Chocolate Sprinkles 1 x Bannister Downs Gourmet Cream (Box of 24) 32 x Premium Drinking Chocolate 2 x Whadjuk Dreaming KeepCup Brew (Box of 12) 4 x Isomac Tea Coffee Machines 2 x Le Marocco Linea Mini Coffee Machines 10 x Milk Jug Rinser Chillzone returned product to the value of $5.990 including GST which had been purchased before June 30 and which was not suitable for them. A credit note was issued Sold 40 boxes of Item No. 5001 Chocolate Sprinkles to Sarah's Hot Spot on credit. 12 13 Paid the full amount owing to Moledina Commodities, reference 915 15 Paid sales staff wages for the two weeks up to and including yesterday, reference 916. The wages expense is $25,515 17 Sold 10 boxes of 8oz Takeaway Lids (Box of 1000) to Revamp Coffee Carts on account 18 The following items were sold during the week for cash: 10x Tightrope Blend 123 x Rwanda Single Origin 206 x Cleanskin Blend - On special for the week-20% discount 54 x Organic Blend 38 x Colombian Reserve 36 x Medium Roast Arabica Coffee 67 Crompton Road Blend 23 x Panama Geisha 41 x Raw Sugar Sticks (Box of 2000) 33 x White Sugar Sticks Box of 2000) 21 18 x Premium Drinking Chocolate 5x Whadjuk Dreaming KeepCup (Box of 12) 4x Isomac Tea Coffee Machines 1 x Le Marzocco Linca Mini Coffee Machines 6x Mazzer Mini Grinder 18 19 Returned a faulty product which is no longer carried in inventory, which was purchase before June 30 to Olam Specialty Coffee. Received a credit note for $7,015 GST inclusive. Sarah's Hot Spot paid a portion of their account. The payment was for S1,500 Chillzone paid the full amount owing on their account. Received a purchase order from Sarah's Hot Spot for 12 Bannister Downs Gourmet Cream (Box of 24). Created a corresponding sales order (quote) to deliver gourmet cream. 21 21 24 Completed the July 21 order for gourmet cream (credit sale made by Sarah's Hot Spot. 25 The following items were sold during the week for cash: 13 x Dark Horse Blend 57 x Risaralda Decaf 92 x Leonid Ramirez 65 x Organic Blend 76 x Cleanskin Blend 24 x Panama Geisha 37 x Colombian Reserve 36 Rwandan Single Origin 95 x Honduras Blue - On special $35.03 each 41 CSR Gourmet Sugar Cubes 33 x Chai Latter Powder 39 x 120 Takeaway Lids (Box of 10001 8. Whadjuk Dreaming KeepCup Brew (Box of 12) 2x Le Marrocco Linea Mini Coffee Machines 4x Baratza Forte Grinder 6x Mazzer Mini Grinder 1 x Acaia Lunar Scale Paid the full amount owing to Crop Del Monte, reference 917 Paid the full amount owing to Olam Specialty Coffee, reference 918 Ordered 28 x 5004 Organic Chocolate Cream Liqueur from Kolibri Kofe. Agreed terms with Kolibri Kofe are 2/10,n/30. This is a new inventory item. It is purchased for $27.50 per item 26 27 28 Week 5 29 Paid sales staff wages $27.910 for the two weeks up to and including yesterday. reference 919 22 FC Onpest-Fe Received Organic Chocolate Cream Liqueur, which was ordered on the 28th, agreed terms with Kolibri Kofe are 2/10,n/30. More Freewheelin Coffee paid the full amount owing on their account. The following items were sold during the week for cash: 6 x Medium Roast Arabica Coffee 12 x Dark Horse Blend 36 x Crompton Road Blend 29 x Leonid Ramirez 43 x Ardi 42 x Panama Geisha 73 x Colombian Reserve 14 x CSR Gourmet Sugar Cubes 93 x 8oz Takeaway Lids (Box of 1000] 1x Whadjuk Dreaming KeepCup (Box of 12] 2 x Le Marzocco Linea Mini Coffee Machines 2 x Acaia Lunar Scale Paid Bindi a monthly salary of $26,000, reference 920 31 JO Complete the bank reconciliation in Xero. You will need to create and upload the bank statement using the template provided by Xero. For reconciliation purposes use your conversion cash at bank balance as the opening balance To account for uncleared cheques, see the relevant additional help files in Xero Central The applicable information is Uncleared Deposits account number is 101 Uncleared Cheques account number is 252 There are possible bank error(s). Items which are possible bank errors will remain unreconciled. Possible bank errors are normally reported to the bank. Posting in the discussion board is our equivalence of doing the same. Record the following adjusting entries for July 31 Depreciation expense using Xero's Fixed Assets feature Estimated electricity payable to Synergy Ltd for the month is $4,370 Estimated water usage payable to the Water Corporation for the month is $1,175 Wages incurred during the month but not yet paid to sales staff is $6,600 Interest expense incurred during the month but not yet paid to Bank Australia is S1,145 Interest earned from short-term investments with Bank Australia during the month but not yet paid amount to $165 The value of office supplies used during the month are $20,185 23 Create Discuss e contact During the month, prepaid rent to the value of $15,000 expired What Choose the con in During the month, prepaid advertising to the value of $15,000 expired During the month, prepaid insurance to the value of $2,950 expired Next 31 Prepare and submit any reports as specified including your month end report (memo Bindi Tjandamurra. Note: . Invoice and credit note numbers are as allocated by Xero. Reference refers to cheque number. Enter this number in the applicable reference field. . THE Reconcile (22) Cash coding Bank statements Account transactions What's this? Review your bank statement lines... ...then match with your transactions in Xero Spent - Received - Spent Received Options - Match Create Discuss Find & Match 3,500.00 2 Jul 2021 910 More details Who FTA Specialty Coffee I What Choose the account Why Paid the full amount Tax Rate Add details Match Create Discuss Find & Match Options 275,000.00 Who Name of the contact What Choose the account. 43UA 2021 Loan More details Why Enter a description Tax Rate Add details Match Create Discuss Find & Math Gitions 18.425.00 Who Name at the contact What Choose the account 4 Jul 2021 Freewheelin Coffee Deposit - Freewheelin Cotton More details Why Enteraction Thx Adid details