FILL IN HIGHLIGHTED AREAS ON 2ND SPREADSHEET

Use the data in the 'information' spreadsheet and complete reconciliation in the 'reconciliation' tab of the spreadsheet. Enteryour answers in the yellow highlighted fields.Please do not add fields or change the formatting in these spreadsheets.(show less)File Edit View Insert Format Data Tools Extensions HelpQ 5 2 5 5 100%$%.0 .00 123Arial10+BD.A1fx Information for Bank Reconciliation and Month End PostingsABCDEFG1Information for Bank Reconciliation and Month End Postings23Balances at Dec 31, 2021General Ledger Bank Statements4Bank AccountAmountAmount5Citibank1,405,0001,480,000678Transactions - Checks issued, but not presented for payment9Check#1022150,00010Check#1022275,00011Check#10100130,00012DepositABC Company150,0001314Transactions - Checks deposited, but not collected by bank15DepositAds-r-u Inc25,00016DepositPlus Inc5,0001718+InformationReconciliation Use the data in the 'information' spreadsheet and complete reconciliation in the 'reconciliation' tab of the spreadsheet. Enteryour answers in the yellow highlighted fields. Please do not add fields or change the formatting in these spreadsheets.(show less) File Edit View Insert Format Data Tools Extensions Help O\bdl.'é'i!'-'me%v $ % 0_ .00 123 Arial - —+ B I = A o Al - ReconciliationsA B C D E1 Reconciliations .I Description Citibank23 Balance per Bank Statement 1,480,000.004 PLEASE ENTER ANSWER IN THEHIGHLIGHTED BOXES, DO NOT ALTER THE5 FORMATTING OR REMOVE THEHIGHLIGHTING AS THAT WILL LEAD TOINCORRECT AUTO-GRADING OF YOUR Add: ANSWERS.6 ABC Company7 Ads-r-u Inc8 Plus Inc9 Sub total Y10 Deduct:11 #1022112 #1022213 #101001 Sub total Y i = Information ~ Reconciliation ~