Need help on bank reconciliation table and how to do a journal

DUPLICATE DEPOSIT TICKETS; Date and amount of each deposit in June: CHECKS WRITIEN: Number and amount of each check issued in June: Bank Reconciliation May 31, 20Y2 1. Cash balance according to bankstatemient. 59,447.20 1. Addd deposit for May 51 not recorded by bank 3. Deduct outstanding threck: No.731 1Na.736 No.738 No.739 1. Acjusted bahance 10 Gash balance accoiding to companys recorde is Derfuct bank servioe charges (1) Adjusted balance Beeler Fumiture Company General Ledger ASSETS REVENUE 110 Cash 410 Sales 111 Petty Cash 610 interest Revenue 120 Accounts Receiyable 131 Notes Receivable EXPENSES 141 Merchandise inventory 510 Cost of Merchandise Sold 145 Oltice Suppties 515 Credit Card Expense 146 Store Supplies 516 Cash Short and Over 151 Prepaid Insurance 520 Salaries Expense 181 Land 531 Advertising Expense 191 Office Equipment 532 Delivery Expense 192 Accumulated Depreciation-Oflice Equipment 533 Insurance Expense 193 Store Equipment 534 Ofrice Supplies Expense 194 Accumulated Depreciation-Store Equipment 535 Rent Expense 536 Repairs Expense LIABILITIES 537 Seling Expenses 210 Accounts Pavable 538 Store Suoblies Expense 194 Accumulated Depreciation-Store Equipment 535 Rent Expense 536 Repairs Expense LIABILITIES 537 Selling Expenses 210 Accounts Payable 538 Store Supplies Expense 221 Notes Payable 561 Depreciation Expense-Office Equipment 222 interest Payable 562 Depreciation Expense-Store Equipment 231 Salaries Payable 590 Miscellaneous Expense 241 Sales Tax Payable 710 Interest Expense EQUITY 310 Owner, Capital 311 Owner, Drawing Labels Cash and cash equivalents For the Year Ended June 30, 20Y2 June 30,20Y2 Outstanding checks Amount Descriptions Adjusted baiance Bank service charges Check retumed because of insufficient funds Deposit of June (insert day), not recorded by bank Error in recording Check No. (Insert check number) Error in recording June (insert day) deposit Interest Note and interest colected by bank Principal (Check numbers are vald Amount Descriptions; Please enter "No "preceeding the Check number) BEELER FURNITURE COMPANY Bank Reconciliation June 30,20Y2 1. Cash balance according to bank statement 1 Add: Deposit of lune 30 not recorded by bank 1 Deduct: Outstanding checks Cani balance according to companys records $10,145.30 JOURNAL DATE DESCAIPTION POST RE. oeerT CREDT ASSETS Final Questions PAGE 1 MEMBER FDIC ACCOUNT NUMBER AMERICAN NATIONAL BANK OF CHICAGO FROM 6/01/20Y2 TO 6/30/20Y2 ICAGO, IL 60603 (312) 441-1239 BALANCE 9,447.20 9 DEPOSITS 8,691.77 20 WITHDRAWALS 7,699.26 BEELER FURNITURE COMPANY 4 OTHER DEBITS AND CREDITS 3,086.00CR NEW BALANCE 13,624.71 NSP - NOT SUFHCIENT FUNDS... SC-SERVICE CHARGE ASY ERROR OR EXCEPTION BHOULD BE REPORTED MNMBDTEIY