A B C D E F G H J K L M N P Q 30 567829722199222222222222222232 Presented below are the Cheryll's Furniture Company's Accounting Records and Bank Statement for the month of July 2022 CHERYLL'S FURNITURE COMPANY: Cash Account Beg. Bal. $8,648 Deposits $11,634 Checks End. Bal. = $11,332 $8,950 10 11 Date Desc. Amount Date Ck No. Amount 7/2 Sales $3,136 7/1 3,113 $1,350 7/8 Sales 615 7/3 3,114 1,491 14 7/10 Sales 1,826 7/7 3,115 1,860 7/16 Sales 781 7/12 3,116 91 7/22 Sales 532 7/15 3,117 582 7/29 Sales 1,942 7/16 3,118 619 7/30 Sales 2,802 7/22 3,119 550 7/24 3,120 659 20 7/30 3,121 502 7/30 3,122 3,628 $11,634 $11,332 24 25 1001 Smith Street OSBOURNE FIRST NATIONAL BANK 26 Houston, Texas 77002-1004 28 Account Holder: Member FDIC 33 32 Beg. Bal. 07/01/22 $8,648 34 Deposits & Credits No. Cheryll's Furniture Company 1122 Annette Boulevard Houston, Texas 77054-4623 Acct Number: 72854360 Statement Date 07/31/22 Amount Withdrawals & Debits No. End. Bal. Amount 07/31/22 7 $9,299 9 $7,142 $10,805 35 36 Date Desc. Amount Date Ck No. Amount 37 7/1 EFT $885 7/7 3,113 $1,350 38 7/4 Sales 3,136 7/13 3,115 1,680 39 7/9 Sales 615 7/14 NSF 740 40 7/12 Sales 1,826 7/15 3,114 1,491 41 7/17 Sales 781 7/18 3,116 91 42 7/22 Sales 532 7/21 EFT 534 43 7/23 BC 1,524 7/26 3,117 582 44 7/30 3,118 619 45 7/30 SC 55 46 $7,142 47 $9,299 48 Explanations of Descriptions: BC - Bank Collection of Note Receivable (Principal ($1,400) And Interest ($124)); EFT - Electronic Funds Transfer; NSF - Not Sufficient Funds; SC - Bank Service Charge 49 50 Additional Information a. The EFT deposit was a receipt of monthly rent (Rental Revenue). The EFT 51 b. 52 C. 53 payment was a monthly insurance payment (Insurance Expense). The check returned for Not Sufficent Funds (NSF) was received from a customer (Carmella Lawson) on her Accounts Receivable balance. The correct amount for Check # 3115, a payment on account (Accounts Payable), is $1,680. The Company's accountant mistakenly reported it as $1,860. The payment was for Advertising Expense. 54 55 Required: Using the Bank Reconcilation Template provided, prepare in good form the Bank 56 Reconciliation for Cheryll's Furniture Company's checking account for July 31, 2022. 57 Also, using the Bank Reconcilation-JE Template provided, prepare in good form the Journal Entries required to be made by Cheryll's Furniture Company for the Bank Reconciliation for 58 Cheryll's Furniture Company's checking account for July 31, 2022. 59 (Explanations for the Journal Entries are not required) 60 61 B C D E F G H 1 STUDENT NAME 2 3 4 567 8 BANK'S CASH BALANCE 9 Balance -END - Per The Bank Statement 10 ADD: DEPOSITS IN TRANSIT 11 12 -Sales-July, 2022 13 -Sales-July, 2022 14 15 16 17 SUB TOTAL 18 ACCOUNTING 2301 (FINANCIAL ACCOUNTING) BANK RECONCILIATION CHERYLL'S FURNITURE COMPANY For The Month Ended July 31, 2022 COMPANY'S CASH BALANCE Balance - END - Per The Company (BOOKS) ADD: CREDIT MEMORANDUMS SUB TOTAL 19 SUBTRACT: OUTSTANDING CHECKS SUBTRACT: DEBIT MEMORANDUMS 20 21 Check # 22 Check # 23 Check # 24 Check # 25 26 27 28 29 ADJUSTED BALANCE PER BANK $0 ADJUSTED BALANCE PER COMPANY (BOOKS) $0 30 31 32 33 34 35 36 37 38 39 CE F G H I J K L M N C P Q R S TUVWXY CHERYLL'S FURNITURE COMPANY GENERAL JOURNAL For The Year Ended July 31, 2022 A E C 1 2 3 4 Date Accounts/Description 5 July 31, 2022 565 7 8 9 10 11 12 13 14 15 16 July 31, 2022 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Debits Credits Z