Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Practitioners Blueprint To Construction Auditing

Authors: Ron Risner

1st Edition

0894137263, 978-0894137266

More Books

Students also viewed these Accounting questions