Using the following transactions, prepare a bank reconciliation statement for June.30th.

Date Transaction description Purchased Coffee Cup Lids from Abejundio Coffee for $160, terms net 30 . Purchased Gourmet Cubed Sugar from Brazil Imports Group for $200, terms 2/10,n/30. Obtained a loan of $55,000 from MRMC Bank at a simple interest rate of 6% per year. The first interest payment is due at the end of August 20XX and the principal of the loan is to be repaid at the beginning of June four years later. Paid the full amount owing to East Tangiers Co-op., Check No. 903. Payment fell within discount period. Paid the full amount owing to Buena Vista Coffee, Check No. 904. Payment fell within discount period. Purchased Gourmet Cream with cash for \$220, Check No. 905. Made cash sales of $5,961 during the first 4 days of the month. Sold 5 bags of Medium Roast Arabica Coffee Beans to SloZone for \$287 each, Invoice No. 201. Wrek 2 Date Transaction description Central Coffee paid the full amount owing on their account. Since Central Coffee has been a loyal customer from the day the business commenced, a 10% discount was given for this early repayment. - 2 Made cash sales of $10,081 during the week. SloZone returned $1,198 worth of product. Issued a Credit Memorandum for $1,198. Sold Chocolate Sprinkles to Jandesh's Hot Spot for \$484, Invoice No. 202. Paid the full amount owing to Klam Wholesalers, Check No. 906. Week 3 Date Transaction description 25 Paid sales staff wages of $5,103 for the two weeks up to and including yesterday, Check No. 907. 1) Sold 10 boxes of Plastic Condiment Containers to Revamp Coffee Carts for $206 each, Invoice No. 203 18 Made cash sales of $9,658 during the week. 18 Returned $1,403 worth of faulty product to Abejundio Coffee. Received a Credit Memorandum for $1,403. 12 Jandesh's Hot Spot paid $300 in partial payment of their account. SloZone paid the full amount owing on their account. Received a purchase order from Jandesh's Hot Spot. Created a corresponding sales order to deliver Gourmet Cream to this customer for $470, Invoice No. 204. Date Transaction description Delivered Gourmet Cream to Jandesh's Hot Spot for $470, Invoice No. 204, which was ordered on the 21st 25 Made cash sales of $9,592 during the week. Paid the full amount owing to Brazil Imports Group, Check No. 908. Paid the full amount owing to Abejundio Coffee, Check No. 909. 88 Ordered Organic Chocolate Cream Liqueur from Buena Vista Coffee for $155, agreed terms with Buena Vista Coffee are 2/10,n/30 Week 5 Date Transaction description Paid sales staff wages of $5,582 for the two weeks up to and including yesterday, Check No. 910. 30. Received Organic Chocolate Cream Liqueur for $155, which was ordered on the 28th, agreed terms with Buena Vista Coffee are 2/10,n/30. Quick Bolt Coffee paid the full amount owing on their account. Made cash sales of $6,629 during the last 5 days of the month. 30 Paid monthly salary of $5,200 to Adrian Bartos, Check No. 911. Date Transaction description Purchased Coffee Cup Lids from Abejundio Coffee for $160, terms net 30 . Purchased Gourmet Cubed Sugar from Brazil Imports Group for $200, terms 2/10,n/30. Obtained a loan of $55,000 from MRMC Bank at a simple interest rate of 6% per year. The first interest payment is due at the end of August 20XX and the principal of the loan is to be repaid at the beginning of June four years later. Paid the full amount owing to East Tangiers Co-op., Check No. 903. Payment fell within discount period. Paid the full amount owing to Buena Vista Coffee, Check No. 904. Payment fell within discount period. Purchased Gourmet Cream with cash for \$220, Check No. 905. Made cash sales of $5,961 during the first 4 days of the month. Sold 5 bags of Medium Roast Arabica Coffee Beans to SloZone for \$287 each, Invoice No. 201. Wrek 2 Date Transaction description Central Coffee paid the full amount owing on their account. Since Central Coffee has been a loyal customer from the day the business commenced, a 10% discount was given for this early repayment. - 2 Made cash sales of $10,081 during the week. SloZone returned $1,198 worth of product. Issued a Credit Memorandum for $1,198. Sold Chocolate Sprinkles to Jandesh's Hot Spot for \$484, Invoice No. 202. Paid the full amount owing to Klam Wholesalers, Check No. 906. Week 3 Date Transaction description 25 Paid sales staff wages of $5,103 for the two weeks up to and including yesterday, Check No. 907. 1) Sold 10 boxes of Plastic Condiment Containers to Revamp Coffee Carts for $206 each, Invoice No. 203 18 Made cash sales of $9,658 during the week. 18 Returned $1,403 worth of faulty product to Abejundio Coffee. Received a Credit Memorandum for $1,403. 12 Jandesh's Hot Spot paid $300 in partial payment of their account. SloZone paid the full amount owing on their account. Received a purchase order from Jandesh's Hot Spot. Created a corresponding sales order to deliver Gourmet Cream to this customer for $470, Invoice No. 204. Date Transaction description Delivered Gourmet Cream to Jandesh's Hot Spot for $470, Invoice No. 204, which was ordered on the 21st 25 Made cash sales of $9,592 during the week. Paid the full amount owing to Brazil Imports Group, Check No. 908. Paid the full amount owing to Abejundio Coffee, Check No. 909. 88 Ordered Organic Chocolate Cream Liqueur from Buena Vista Coffee for $155, agreed terms with Buena Vista Coffee are 2/10,n/30 Week 5 Date Transaction description Paid sales staff wages of $5,582 for the two weeks up to and including yesterday, Check No. 910. 30. Received Organic Chocolate Cream Liqueur for $155, which was ordered on the 28th, agreed terms with Buena Vista Coffee are 2/10,n/30. Quick Bolt Coffee paid the full amount owing on their account. Made cash sales of $6,629 during the last 5 days of the month. 30 Paid monthly salary of $5,200 to Adrian Bartos, Check No. 911