Insert Format Tools Table Window Help +14% Lab 6 fall 2020 - Compatibility Mode-Saved to my Mac on Layout References Mailings Review View Table Design Layout Tell me 12 Aa A ! Add Auditor AaBbd aibede XX Normal Na Sacra Heading Head Problem 1 (12 points) . Pine's accountant observes the following related to Pine's Cash account balance as of 10/31/20. Use this information to prepare a bank reconciliation for Pine. Pine's 10/31/20 Cash Taccount shows a balance of 541.000, Pine's bank statement dated 10/31/20 shows a balance of 537,000, Pine has not yet recorded bank fees of $250. The bank twice recorded a $350 deposit made by Pine Pine has not yet recorded $400 of interest revenue related to the bank account Pine has written S850 worth of checks that have not yet cleared the bank. The bank reports that one of Pine's customers' checks was returned as NSF. The check totaled $220. Pine received a check but forgot to post the related journal entry to the Taccounts. The journal entry that Pine forgot to post was: Dr. Cash 4,500 and Cr. Service Revente 4.500. Pine incorrectly recorded a debit to Cash for $700 on a check that was received for $70. Pinc has deposits of S9,000 that do not yet appear on the bank statement. . . Pine Bank Reconciliation As of 10/31/20 ds English (United States O Focus 5 & 7 5 6 8. 9 E R Y U P *14%D Insert Format Tools Table Window Help @SUOLO Lab 6 fall 2020 - Compatibility Mode -Saved to my Mac ign Layout References Mailings Review View Table Design Layout Tell me 12 AA + T ABCDE alle AaBb Aather Normal Ne Saadia Heading Heading Pine Bank Reconciliation As of 10/31/20 Balance per books, 10/31/20 Balance per bank, 10/31/20 Adjusted bank balance, 10/31/20 Adjusted books balance, 10/31/20 English (United States 40- 3 4 6 7 E R. T Y 0 P