please help its due soon!

8 Beg. Bal. B PD G CHERYLL'S FURNITURE COMPANY: Cash Account Deposits Checks End. Bal. 9 $8,648 $11,634 $11,332 $8,950 10 11 Date Desc. Amount Date Ck No. Amount 12 7/2 Sales $3,136 7/1 3,113 $1,350 13 7/8 Sales 615 7/3 3,114 1,491 14 7/10 Sales 1,826 7/7 3,115 1,860 15 7/16 Sales 781 7/12 3,116 91 16 7/22 Sales 532 7/15 3,117 582 17 7/29 Sales 1,942 7/16 3,118 619 18 7/30 Sales 2,802 7/22 3,119 550 19 7/24 3,120 659 20 7/30 3,121 502 21 7/30 3,122 3,628 22 $11,634 $11,332 23 24 25 1001 Smith Street OSBOURNE FIRST NATIONAL BANK Member FDIC 26 Houston, Texas 77002-1004 27 28 Account Holder: Cheryll's Furniture Company Acct Number: 72854360 29 1122 Annette Boulevard 30 Houston, Texas 77054-4623 Statement Date 07/31/20 31 32 Beg. Bal. Deposits & Credits Withdrawals & Debits End. Bal. 33 07/01/20 No. Amount No. Amount 07/31/20 34 $8,618 7 $9,299 9 $7,142 $10,805 25 Member FDIC 1001 Smith Street OSBOURNE FIRST NATIONAL BANK Houston, Texas 77002-1004 Account Holder: Cheryll's Furniture Company Acct Number: 72854360 1122 Annette Boulevard Houston, Texas 77054-4623 Statement Date 07/31/20 7/4 7/9 e Beg. Bal. End. Bal. Deposits & Credits Withdrawals & Debits 3 07/01/20 No. Amount No. Amount 07/31/20 $8,648 4 7 $9,299 9 $7,142 $10,805 5 6 Date Desc. Amount Date Ck No. Amount 7 7/1 EFT $885 7/7 3,113 $1,350 38 Sales 3,136 7/13 3,115 1,680 39 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 7/26 3,117 582 44 7/30 3,118 619 45 7/30 SC 55 46 $9,299 $7,142 47 48 Explanations of Descriptions: BC - Bank Collection of Note Receivable (Principal ($1,400) And Interest ($124)); EFT - 49 1,524 40 Leplanation of Description. HC-Bank Collection of Not Receivable (Pindpa (54,400) And Interest ($1201): EXT. Bestronie Funds Transfer. NSF - Not sufficient funde se Band service Charge 49 50 Additional Information The EFT deposit wara receipt of monthly rent (Rootal Revenue) The 51 EFT payment was a monthly insurance payet tasurance Expense) The check returned for Not Suificent Funds (NSE) was received from a 52 customer Camella Lawson) on her Accounts Receivable balance The correct amount for Check 311, a payment on account Accounts Payable), 151.60. The Company's accountant mistakenly ported its 51.860. The payment was for Advertising Expense 54 55 Required: Using the Bank concitation Template provided, prepare in good form the Bank Reconciliation for Cheryl's Furniture Companys checking account for July 11, 2020 Aho, in the Bank Reconcitation Template provided are in good for the Your Entries required to be made by Cheryl's Furniture Company for the Bank econciliation for Cheryl's Furniture Company checking account for July 1, 2020 Explanation for the Journal noted ACCOUNTING 2113 (FINANCIAL ACCOUNTING) BANK RECONCILIATION CHERYLL'S FURNITURE COMPANY For The Month Ended July 31, 2020 BANK'S CASH BALANCE Balance - END - Per The Bank Statement ADD: DEPOSITS IN TRANSIT COMPANY'S CASH BALANCE Balance - END- Per The Company (BOOKS) ADD: CREDIT MEMORANDUMS Sales July 2020 Sales - July 2020 SUB TOTAL SUBTRACT: DEBIT MEMORANDUMS 1 SUB TOTAL 8 9 SUBTRACT: OUTSTANDING CHECKS 0 21 Check Check 23 Check 24 Check 25 26 27 SO SO ADJUSTED BALANCE PER COMPANY (BOOKS) 28 29 ADIUSTED BALANCE PER BANK 30 DECONCIATION JE TEMPLATE 1 2 3 CHERYLL'S FURNITURE COMPANY GENERAL JOURNAL For The Month Ended July 31, 2020 Debits Credits S $ 4 Date Accounts/Description 5 July 31, 2020 6 7 8 19 10 11 12 13 14 15 16 July 31, 2020 17 18 19 20 21 22 23 24 25 26 27 28 29 30 BANK RECONCILIATION FACTS BANK RECONCILIATION TEMPLATE BANK RECONCILIATION JE TEMPLATE