College: Yuba Community College
Course: Accounting 1 LAB (online)
Platform/Website: Cengage (cengage.com)
Email:
[email protected]Password: Evangel1995
Once on the dashboard, proceed to go click on the "eBook: Excel Applications for Accounting Principles". A new window will open that shows the chapters on the left-hand side of the page. Scroll down and select "P5: Bank Reconciliation (BANKREC)." This chapter goes hand in hand with the spreadsheet you are to complete.
The name of the lab assignment for this week is "BANKREC". It is due by 11:59 on MONDAY, October 25, 2021.
*****MUST INCLUDE:*****- ANSWERED QUESTIONS
- What if Section
- Chart Analysis Section
- Tickler Section
PLEASE READ ALL INFORMATION AND REQUIREMENTS ON PAGES 45-47 OF THE EBOOK CAREFULLY.
Worksheet BANKREC Bank Reconciliation Skye Boats Bank Reconciliation October 31, 2011 Balance per bank statement$0.00 Additions by depositor not on bank statement: Deductions by depositor not on bank statement: Bank errors: Adjusted balanceFORMULA1 Balance per books Additions by bank not recorded by depositor: Deductions by bank not recorded by depositor: Depositor's errors: Adjusted balanceFORMULA2 Difference between adjusted balancesFORMULA3 Chart Chart Data Table BookBank July 317712.389080.25 Aug. 318046.997264.47 Chart Tickler DataSep. 308720.239568.63 Oct. 319996.6111157.57 Nov. 307608.097950.88 Chart Book Balance Bank Balance Comparison of Book and Bank Balances