M Re ACCOUNTING LAB ASSIBNM X BANK REC Office Editing for Docs, Sheets & Slides chrome-extension://bpmcpldpdmajfigpchkicefoigmkfalc/views/app.html ACCOUNTING 2113 - BANK RECONCILIATION ASSIGNMENT.xlSx X Fle Edt Insert Format Help 12 BIUA Calibr . A B C D J K L M ACCOUNTING 2113 (FINANCIAL ACCOUNTING) 1 FALL SEMESTER 2019 ACCOUNTING LAB ASSIGNMENT NUMBER 1 Presented below are the Cheryl's Furniture Company's Accounting Records and Bank Statement for the month of July 2019 5 6 CHERYLL'S FURNITURE COMPANY: Cash Account 7 Beg Bal 8 Deposits End. Bal Checks $9,087 $7,900 $9,124 $7,937 10 Date Desc Amount 11 Ck No Date Amount 7/2 Sales 12 $2,771 7/1 3,113 $1,503 7/8 Sales 13 516 7/3 3,114 1,149 7/10 Sales 14 1,682 7/7 3,115 1,630 15 7/16 Sales 871 352 7/12 3,116 3,117 19 7/22 Sales 16 7/15 825 7/29 17 Sales Sales 924 2.008 7/16 3,118 91 7/30 18 7/22 3,119 3,120 440 19 7/24 965 20 7/30 3,121 205 2.260 21 7/30 3,122 $9.124 $9,087 24 50 BANK RECONCILIATION FACTS BAN RECONC NEMA ANK RECONCIATION LAT G 24 1001 Smith Street JRNE FIRST NATIONAL 25 Member FDIC Houston, Texas 77002-1004 26 27 28 Account Holder: Diaz Entertainment Acct Number: 72854360 29 124 Saddle Blvd Bowlegs, OK 74830 30 Statement Date 07/31/19 31 32 Beg. Bal. 07/01/19 Deposits&Credits Amount $8,192 Withdrawals & Debits End. Bal. Amount 07/31/19 $5,713 33 No. No $7,900 34 7 $10,379 35 Date 36 Desc Amount Ck No Date Amount $1,503 7/1 37 EFT $750 7/7 3,113 7/4 38 Sales 2,771 7/13 3,115 1,360 7/9 39 Sales 516 7/14 NSF 407 7/12 40 Sales 1,682 7/15 3,114 1,149 7/17 41 Sales 871 7/18 3,116 19 7/22 42 Sales 352 7/21 EFT 334 7/23 43 BC 1,250 7/26 3,117 825 44 7/30 3,118 91 45 7/30 SC 25 46 $8,192.00 $5,713.00 47 51 RANK DECON 7/30 3,118 91 7/30 SC 25 45 $8,192.00 $5,713.00 46 47 Explanations of Descriptions: BC-Bank Collection; EFT-Electronk Funds Transfer; NSF-Not Sufficlent Funds; SC-Bank Service Charge 48 49 50 Additional Information a. The EFT deposit was a receipt of monthly rent. The EFT payment was a monthly insurance payment The check returned for Non Sufficent Funds was received from a 51 b. customer (Carmella Lawson). C. The correct amount for Check #3115, a payment on account, is $1,360. The Company's accountant mistakenly reported it as 53 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, 57 Also, using the Bank Reconcilation-JE Template provided, prepare in good form 58 the Journal Entries required to be made by Cheryll's Furniture Company for the Bank Reconciliation for Cheryll's Furniture Company's checking account for July 59 (Explanations for the Journal Entries are not required) 60 61 62 4 52 AC 2113 BANK RECONCILIATION ASSIGNMENT.xlsx File Edt Irsert Format Help BIU&A Calbri 11 EB A B G H K L M ACCOUNTING 2113 (FINANCIAL ACCOUNTING) 3 4 BANK RECONCILIATION CHERYLL'S FURNITURE COMPANY 5 For the Month Ended JULY 31, 2019 6 7 8 BANK'S CASH BALANCE COMPANY'S CASH BALANCE Balance-END-per the Bank Statement 9 Balance-END per the BOOKS DEPOSITS IN TRANSIT 10 CREDIT MEMORANDUMS 11 12 13 14 15 16 OUTSTANDING CHECKS DEBIT MEMORANDUMS 17 Check 18 Check 19 Check # 20 Check # 21 Check # 22 Check# 23 Check 24 Check 25 26 AnICTEnDALANE DEO COAAIVDnnac ADUSTED.DALANCE DED DA en BANK RECONCILIATIONL TEMPLATE BANK RECONCILIATION TEMPLATE BANK RECONCILIATION FACTS lup CHERYLL'S FURNITURE COMPANY A IEFGHIJKLMN PORSTUVWX Y C AA CHERYLL'S FURNITURE COMPANY GENERAL JOURNAL Date Accounts/Description Debits Credits 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 BANK RECONCILIATION FACTS BANK RECONCILIATION TEMPLATE BANK RECONCILIATION-JE TEMPLATE
