Question
It is recommended that you print the first 3 files listed above. These represent documents you would have on file (last month bank reconciliation), and
It is recommended that you print the first 3 files listed above. These represent documents you would have on file (last month bank reconciliation), and documents you would receive from your bank at the end of the month (bank statement with cancelled cheques). You can work on the 4th file on your computer screen to complete the assignment.\ Compare deposits on the bank statement with deposits in the accounting records (this will include both the general ledger and last months bank reconciliation). Hint: Use a highlighter to mark off items as you match them. Identify any missing items or discrepancies by circling them and making any notes, if needed. \ Compare cancelled cheques on the bank statement with the actual cheques returned with the statement. For each cheque, make sure the bank deducts the correct amount and the returned cheque is properly charged to the account. Hint: Use a highlighter to mark off items as you match them. Identify any missing items or discrepancies by circling them and making any notes, if needed.\ Compare cancelled cheques on the bank statement with cheques recorded in the books (general ledger and last months bank reconciliation). Again, use a system to mark off matched items. Identify any missed items or discrepancies by circling them and making any notes, if needed.\ Fill in the appropriate sections on the January 2023 Bank Reconciliation worksheet. NOTE: You are expected to use Excel formulas to perform math functions.\ Check to ensure the adjusted bank balance and adjusted book balance are equal. If they are not equal, review for math errors or other missing information.\ Once your bank is reconciled, use the General Journal worksheet to record the necessary journal entries.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started