Instructions:

1. Review the data you have been given.

2. Copy the data from the worksheet into a new worksheet called Working Data, and name the original worksheet Original Data.

3. Under General Ledger in the table to the right of the Bank Statement data, complete the roll forward and calculate the ending balance in cash per the general ledger. Do the same for the Bank balance. You will need these numbers for your reconciliation.

4. Holding the control key down, highlight both columns of dollar amounts (General Ledger and Bank Statement amounts in columns C and G).

5. From the home tab, choose Conditional Formatting, then New Rule. Choose format only unique and duplicate values. Under Format all, choose unique values. Click on the Format and set the fill color to any color you choose. This will show you only the numbers that need to be reconciled. (For example, you can change the color of the font or choose to fill the cells.) Click OK.

6. Create a third worksheet called Reconciliation. Prepare a bank reconciliation using the data and the information you learned from the conditional formatting. Assume that any errors made were made by the company, not the bank. All items should be referenced to the data.

7. Add a new worksheet called Journal Entries, and prepare any entries needed to adjust the cash balance.

8. Move the Reconciliation worksheet to be the first one and the Journal Entries worksheet to be the second one.

LIED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected Vi D10 X IV f Deposit 228 A B C 1 D F 1 Vern Richardson CPA IN Cash Transactions 3 July 31, 2022 4 General Ledger/ Company Books Bank Statement 5 6 Transaction Type Transaction Type 7 Check 722 2,669.14 Check 722 2,669.14 3 Check 723 2,106.89 Check 723 2,106.89 9 Check 724 2,632.24 Deposit 224 1,658.22 10 Check 725 2,436.76 Deposit 228 2,417.82 11 Check 726 2,060.13 Deposit 227 2,778.50 12 Check 727 2,173.54 Deposit 225 2,930.78 13 Check 728 2,242.57 Deposit 226 1,371.63 14 Check 729 1,851.13 Deposit 223 1,852.37 15 Check 730 2,025.09 Deposit 229 1,926.75 16 Check 731 1,908.65 Deposit 230 1,664.18 17 Check 732 1,674.59 Check 725 2,436.76 18 Check 733 2,749.97 Check 726 2,060.13 19 Check 734 1,379.02 Check 727 2,173.54 20 Deposit 223 1,852.37 Check 728 2,242.57 21 Deposit 224 1,658.22 Check 729 1,851.13 22 Deposit 225 2,930.78 Check 730 2,025.09 23 Deposit 226 1,371.63 Note Collect 1 1,500.00 24 Deposit 227 2,778.50 Interest Earned 11.05 25 Deposit 228 2,417.82 NSF Check 213 2,645.05 26 Deposit 229 1,926.75 NSF Check 217+ 924.17 27 Deposit 230 1,664.18 NSF Fees 1 18.00 28 Deposit 231 1,479.91 NSF Fees 2 19.00 29 Deposit 232 2,255.74 Deposit 231 1,479.91 30 Deposit 233 2,329.55 31 32