Tips:$1.$ It is recommended to start by reviewing the $2019$ file as an example to see what was done in the previous year. Similar work should be completed for $2020\mathrm{.}2.$ The client was unable to prepare bank reconciliation this year due to an unexpected employee departure in the accounting department. Therefore, you will have to prepare the bank reconciliations. This can be done using a new Al working paper. You can use the$2019$ Al working paper and select "Save as$"$ and rename it to $"$A$1-2020".$ Then update it for $2020$ information$\mathrm{.}3.$ The only work required is relating to account#$1055,1060,$ & $1070.$When preparing your bank reconciliation, you do not need to calculate all cash receipts and disbursements for the year. Simply state the book ending balance as your starting point$\mathrm{.}5.$ You account transaction details are located in document called $"\text{'}$Proulx$\text{'}$s PremiumProjects General Ledger Detail Jul $12019-$ June $302020".$ Look for the detail specific to the bank account numbers that you are working on $($titles on the left in the excel$).$ There are a lot of transactions in this document relating to the three bank accounts as the transactions for the entire year have been provided by the client. You do not need the transactions for the entire year, only those that relate to the period in which you are doing the reconciliation. Please copy$/$past the transactions into a new document for your supporting working paper$\mathrm{.}6$Outstanding cheques for the previous month, $($May $2020)$ for account#$1060$ included Chq#$273$ for $$21,250,$ Chq#$130$ for $$6,272\mathrm{.}70$ and Chq#$267$ for $$1,808.$ There were no outstanding deposits. For account #$1070$ Cheque # $460$ for $$1,211\mathrm{.}65$ and #$465$ for #$1,827\mathrm{.}50$ were outstanding. No other items were outstanding for the month of May for other accounts$\mathrm{.}7.$ When submitting H$85$ trial balance for $2020,$ you only need to include accounts relating to the cash section with relevant markups $($please see H$85$ in in the $"2019$ Data". Purpose: You have been asked by your audit Senior to prepare the working papers for the Cash section for the Compilation engagement of Proulx's Premium Projects$\mathrm{.}2019$ Data: You have been provided with the previous year's working papers. These are to be used as a guide. Caution, sometimes previous year's working papers contain errors$\mathrm{.}2020$ Data: You have been provided with some data from the client for the current year in order to prepare the working papers for the cash section. Caution, sometimes the client does not initially provide all of the required data, you must then request them from the client. The document currently missing is the Oakville Dominion Bank statement, your request should be included in a separate word document with your assignment in an e$-$mail format to the client.The document is included in Moodle under the heading "Document to request from client"You must notify your Senior once the work is complete so that they are aware that it can then be reviewed. The senior on the engagement is Stephanie Hall. Your request should be included in a separate word document with your assignment in an e$-$mail format to your senior.Proulx's Premium Projects Inc.Year End: June $30,2019$TB by FS groupingsF$5678$AccountPrelimAdj'sReclassRep Annotation$1055$ Regal Bank Savings$50,000\mathrm{.}001060$ Regal Bank Current$64,823\mathrm{.}7991070$ Oakville Dominion B:$(8,038\mathrm{.}13)1011\mathrm{.}01$ Cash$106,785\mathrm{.}6611121314151617181920010\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}0050,000\mathrm{.}00$ A$164,823\mathrm{.}79$ A$1(8,038\mathrm{.}13)$ A$1106,785\mathrm{.}66$H$85$Ready$\backslash$deg Type here to searchAFaguni Mahendrabhai DaveFM commentsGRep $06/18$Amount Chg$\%$Chg$0\mathrm{.}000\mathrm{.}000\mathrm{.}000\mathrm{.}0050,000\mathrm{.}0064,823\mathrm{.}79(8,038\mathrm{.}13)106,785\mathrm{.}66$Prepared byAM $9/12/20192$nd partner ReDetailed Revie Partner ReviewSG $9/18/2019$ SBH $8/31/2019$AdminsH$85$Proulx's Premium PrBank ReconciliationJune $30,2019$DescriptionEnding balance per$91011$Regal $-$ Savings a$/$cRegal $-$ Current a$/$cDominion $-$ Payroll a$50\mathrm{.}000\mathrm{.}00$TB#$105564\mathrm{.}823\mathrm{.}79$TB#$1060(8,038\mathrm{.}13)$ TB#$107012131415106,785\mathrm{.}66161718$NOTES:$19$Bank Reconciliation $-$ Example $1$Ready$ Accessibility: InvestigateType here to searchDataHelpAcrobat$8$AlignmentGeneral$ $-\%608$NumberIS Conditional Formatting ~ a Format as Table ~$12$ Cell Styles ~MNPRefBalance perBank statementNotesRefAdd: o$/$s depositsA$1-1$A$1-1$A$250\mathrm{.}000\mathrm{.}0048\mathrm{.}455\mathrm{.}93(2,091\mathrm{.}40)$A$1-2$A$2-157,000\mathrm{.}0022,600\mathrm{.}00$Bank Reconciliation $-$ Example $2$StylesRefLess: o$/$s chequesA$1-2$A$2-140,632\mathrm{.}1428,546\mathrm{.}73$Faguni Mahendrabhai DaveEM.$-$ CommentsEInsert $22$ Delete$)$ Format ~$2$ANSort & Find & Filter ~ Select $-$SensitivityAdd$-$insAnalyzeDataCreate arAdobeCellsEditingSensitivityAdd$-$insAdobe AUWPrepared by:Date:Reviewed by:Date!DRJJuly $232019$SBHJuly $252019$YNotesEndingDifferenceReviewer Notes$50\mathrm{.}000\mathrm{.}0064,823\mathrm{.}79(8,038\mathrm{.}13)4$Prepared by: DRJDate: Jul $23,2019$Proulx's Premium ProjectsReviewed by: SBHDate: Jul $25,2019$Transactions by Account Report May $01,2019$ to Jun $30,2019$Sorted by: Transaction NumberDateCommentPBCPrepared by: DRJDate: Jul $23,2019$Reviewed by:SBHDate: Jul $25,20191060$Regal Bank CurrentSource # Trans. No$.$DebitsCreditsBalanceMay $01,2019$ DAB Collision Ltd$35,791\mathrm{.}70$May $01,2019$ Ocean View Apartments$425$J$3655,609\mathrm{.}940\mathrm{.}0041,401\mathrm{.}64428$J$36811,770\mathrm{.}000\mathrm{.}0053,171\mathrm{.}64$May $06,2019$ Abercrombie Hardware Inc.May $07,2019$ Teesdale Metalworks$94$J$3720\mathrm{.}0036,839\mathrm{.}2616,332\mathrm{.}39$May $09,2019$ Abercrombie Hardware Inc$\mathrm{.}95$J$3730\mathrm{.}008,151\mathrm{.}008,181\mathrm{.}39$May $13,2019$ Fogarty Motors$960\mathrm{.}0013\mathrm{.}803\mathrm{.}00(5,021\mathrm{.}61)$May $14,2019$ Lee & Partners$426$J$36631350\mathrm{.}000\mathrm{.}0025,728\mathrm{.}39$May $15,2019$ Mainline Rail Ltd$\mathrm{.}97$J$3750\mathrm{.}0024\mathrm{.}604\mathrm{.}621,123\mathrm{.}77$May $15,2019$ Richmond Optical$427429$J$36926,750\mathrm{.}000\mathrm{.}0027\mathrm{.}873\mathrm{.}777,809\mathrm{.}000\mathrm{.}0035\mathrm{.}682\mathrm{.}77$May $26,2019$ Dextor, Drew & Angus$9$BJ$3760\mathrm{.}006,800\mathrm{.}13-$V$28\mathrm{.}882\mathrm{.}64$May $26,2019$ Streamline Couriers Inc.May $26,2019$ Underhill & McLeod Ltd$\mathrm{.}99$J$3770\mathrm{.}00266\mathrm{.}7628\mathrm{.}615\mathrm{.}88100$J$3780\mathrm{.}002,052\mathrm{.}00126\mathrm{.}563\mathrm{.}88$May $26,2019$ Office Equipment RentalsMay $26,2019$ Farwest Telephone Corp$\mathrm{.}101$J$3790\mathrm{.}004,969\mathrm{.}38($A$/21,594\mathrm{.}50$May $26,2019$ Northwest Hydro Company$102103$J$8800\mathrm{.}004,418\mathrm{.}81(4)17,175,690\mathrm{.}006,272\mathrm{.}7010,902\mathrm{.}99$May $28,2019$ West Coast DevelopmentMay $28,2019$ Ocean View Apartments$430137223,750\mathrm{.}000\mathrm{.}0034,552\mathrm{.}99$Spering book balanceMay $31,2019$ trfr to payroll$431$J$37124,510\mathrm{.}000\mathrm{.}0059,162\mathrm{.}99$Jun $17,2015$ Fogarty Motors$117434$J$394$J$4080\mathrm{.}0022700\mathrm{.}003646299$Jun $17,2019$ Hesiman Construction$31,350\mathrm{.}00$ g$0\mathrm{.}0067,812,9910514170,009,448\mathrm{.}32483647$Jun $25,2019$ Dextor, Drew $3.$ AngusJun $25,2015106$J