Attacthed is suplementary info

Mini-Project for Week Five. (Did you find the possible fraud?) Open a blank Excel workbook and create a Bank Reconciliation. You will access the Bank Statement.pdf file which contains the recent bank statement and the related checks that have been paid by the bank Reconcile the company's deposits, checks with the Bank's statement and ensure that the amounts are in balance after adjustments. See Bank_Statement.pdf for bank. The following is the Company's Check Register: Check # Rec Date Payment to ithdrawal( Deposit (+) Balance 15,000.00 15,000.00 $ 14,750.00 $ 10,550.00 10,050.00 $ 10,050.00 $ 9,500.00 $ 8,750.00 S 7,250.00 $5,250.00 OChedk 2/1/20xx Beginning Balance Deposit eck 2/2/20XX Back Country Supples nventory 250.00 1002 Check 2/4/20xX Kayak Gear 1003 esk 2/5/20xx Bank of America 1004 Inventory 4,200 Note Payable 500.00 VOID CHK Utilities OCheck 2/5/20xx VOID 550.00 1006 heck 2/12/20XXx Colorado Kayak Supply nventory 750.00 Inventory 1,500.00 2,000.00 Check 2/5/20xX PG & E Check 2/14/20xX Hobie Cat 1008 nCheck 2/20/20XX Anytown Property In addition to the above transactions, you must a add a bank deposit in transit of 14635.07 What is the balance per company books after the reconciliation? Answer to 2 decimals (no commas) Rent Answer Check