Please help! I am lost on how to do these bank reconciliations.

American National Bank of Chicago Chicago, IL 60603 (312) 441-1239 Beeler Fumiture Company Bank Reconciliation May 31, 20- \begin{tabular}{|c|c|c|} \hline Cash balance according to bank statement & & 9,447.20 \\ \hline \multicolumn{3}{|l|}{ Adjustments: } \\ \hline Deposit for May 31 not recorded by bank & 690.25 & \\ \hline Outstanding Check Na. 731 & (162.15) & \\ \hline Outstanding Check Na. 736 & (345.95) & \\ \hline Outstanding Check Na. 738 & (251.40) & \\ \hline Outstanding Check Na. 739 & (60.55) & \\ \hline Total adjustments & & (129.80) \\ \hline Adjusted balance & & 9,317.40 \\ \hline Cash balance according to company's records & & 9,352.50 \\ \hline \multicolumn{3}{|l|}{ Adjustments: } \\ \hline Bank service charges & & (35.10) \\ \hline Adjusted balance & & 9,317.40 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Account name: Checking } & \multicolumn{3}{|c|}{ Account 1202} \\ \hline & & \multirow[b]{2}{*}{ Vendor/source } & \multirow[b]{2}{*}{ Purpose } & \multirow[b]{2}{*}{ Debit } & \multirow[b]{2}{*}{ Credit } & \multicolumn{2}{|c|}{ Balance } \\ \hline Date & & & & & & Debit & Credit \\ \hline 1-Jun & & Beginning balance & & & & 9,317.40 & \\ \hline 1-Jun & & Cash Sales & & 1,080.50 & & 10,397.90 & \\ \hline \multirow[t]{4}{*}{ 1-Jun } & Check 740 & ABC Company & Supplies & & 237.50 & 10,160.40 & \\ \hline & Check 741 & Trinity Roofing & repair roof & & 495.15 & 9,665.25 & \\ \hline & Check 742 & Sally Moore & Payroll & & 501.90 & 9,163.35 & \\ \hline & Check 743 & Atlanta Journal & Advertising & & 761.30 & 8,402.05 & \\ \hline \multirow[t]{6}{*}{ 3-Jun } & & Cash Sales & & 854.17 & & 9,256.22 & \\ \hline & Check 744 & McGarrisons & Office equipment & & 506.88 & 8,749.34 & \\ \hline & Check 745 & Verizon & Telephone & & 117.25 & 8,632.09 & \\ \hline & Check 746 & ABC Company & Supplies & & 298.66 & 8,333.43 & \\ \hline & Check 747 & Windstream & Internet service & & \begin{tabular}{l} - \\ \end{tabular} & 8,333.43 & \\ \hline & Check 748 & Jacob's Design shop & Signs for advertising & & 450.90 & 7,882.53 & \\ \hline \multirow[t]{3}{*}{ 8-Jun } & & Cash sales & & 840.50 & & 8,723.03 & \\ \hline & Check 749 & Sally Moore & Payroll & & 640.13 & 8,082.90 & \\ \hline & Check 750 & HMC Electric & Utilities & & 276.77 & 7,806.13 & \\ \hline \multirow[t]{2}{*}{ 10-Jun } & & Cash Sales & & 996.61 & & 8,802.74 & \\ \hline & Check 751 & Windsor & Furniture purchases & & 299.37 & 8,503.37 & \\ \hline \multirow[t]{4}{*}{ 15-Jun } & & EFT collection from customer & payment on account & 882.95 & & 9,386.32 & \\ \hline & Check 752 & Tammy's Design & Store design scheme & & 537.01 & 8,849.31 & \\ \hline & Check 753 & ABC Company & Supplies & & 380.95 & 8,468.36 & \\ \hline & Check 754 & Sally Moore & Payroll & & 449.75 & 8,018.61 & \\ \hline \multirow[t]{3}{*}{ 17-Jun } & & EFT from customer & payment on account & 1,606.74 & & 9,625.35 & \\ \hline & Check 755 & Excess Training & \multicolumn{2}{|c|}{ professional development } & 272.75 & 9,352.60 & \\ \hline & Check 756 & Hector's & meals for meeting & & 113.95 & 9,238.65 & \\ \hline \multirow[t]{2}{*}{ 22-Jun } & & Cash sales & & 897.34 & & 10,135.99 & \\ \hline & Check 757 & Sally Moore & Payroll & & 407.95 & 9,728.04 & \\ \hline \multirow[t]{4}{*}{ 24-Jun } & & EFT collection from customer & payment on account & 947.21 & & 10,675.25 & \\ \hline & Check 758 & Allstate & Insurance & & 259.60 & 10,415.65 & \\ \hline & Check 759 & ABC Company & Supplies & & 901.50 & 9,514.15 & \\ \hline & Check 760 & Sally Moore & Payroll & & 486.39 & 9,027.76 & \\ \hline 30-Jun & & Cash sales & & 1,117.74 & & 10,145.50 & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} Internal Controls Over Cash - Cash drawers: reconcile sales reports to cash inflows - Petty cash funds: reconcile vouchers to cash outflows - Cash in bank: reconcile bank balance to cash in books Bank Reconciliation Banks prepare monthly statements showing beginning and ending balances and transactions occurring during the month. Because differences are likely to exist between the bank balance and the company's cash balance per the accounting records, a monthly reconciliation is essential. Bank reconciliations are used (1) to determine whether the bank account and the company's cash balance are in agreement after taking into account unrecorded items, (2) to isolate recording errors and other problems in the bank's records or the company's recording system, (3) to establish the correct ending cash balance, and (4) to supply information for adjusting entries. The reconciliation process begins with the two cash balances (bank and book) and lists the differences between those balances and the true ending cash balance. Reconciliations are an important part of the accountant's day-to-day duties as well as the functions in an audit. Prepaid accounts must be reconciled to contracts, Unearned Revenue or Deposits Received in Advance must be reconciled to customer contracts, Imventories must be reconciled to count sheets, Property, Plant \& Equipment must be reconciled to count sheets. Mast every account on the balance sheet must be reconciled to confirming support documentation to determine reasonableness and reliabilty. Instructions: Read pages 8-37 through 8-39 to understand the terminology and concepts of the bank reconcilation process. For this assignment, students wil, compare the May reconciliation, the June checking ledger, and the June bonk statement, prepore a bank recanciliotion as of June 30, 20-using the work sheets provided in this file. Remember, the purpose of the bank reconciliation is to locate differences, so as you compare the files, highlight the cleared and agreed amounts in one color and the errors or differences in another. Investigate the differences and record on the bank reconciliotion. If errovs in recording deposits or checks are discovered, assume that the errors were made by the company. Journalize the necessary entries in the space provided. Add lines as needed. If you are unsure about the accounts impacted or the differences uncovered, make a list to conswit with your supervisor or the client. What is the amount of Cash that should appear on the balance sheet as of June 30? American National Bank of Chicago Chicago, IL 60603 (312) 441-1239 Beeler Fumiture Company Bank Reconciliation May 31, 20- \begin{tabular}{|c|c|c|} \hline Cash balance according to bank statement & & 9,447.20 \\ \hline \multicolumn{3}{|l|}{ Adjustments: } \\ \hline Deposit for May 31 not recorded by bank & 690.25 & \\ \hline Outstanding Check Na. 731 & (162.15) & \\ \hline Outstanding Check Na. 736 & (345.95) & \\ \hline Outstanding Check Na. 738 & (251.40) & \\ \hline Outstanding Check Na. 739 & (60.55) & \\ \hline Total adjustments & & (129.80) \\ \hline Adjusted balance & & 9,317.40 \\ \hline Cash balance according to company's records & & 9,352.50 \\ \hline \multicolumn{3}{|l|}{ Adjustments: } \\ \hline Bank service charges & & (35.10) \\ \hline Adjusted balance & & 9,317.40 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Account name: Checking } & \multicolumn{3}{|c|}{ Account 1202} \\ \hline & & \multirow[b]{2}{*}{ Vendor/source } & \multirow[b]{2}{*}{ Purpose } & \multirow[b]{2}{*}{ Debit } & \multirow[b]{2}{*}{ Credit } & \multicolumn{2}{|c|}{ Balance } \\ \hline Date & & & & & & Debit & Credit \\ \hline 1-Jun & & Beginning balance & & & & 9,317.40 & \\ \hline 1-Jun & & Cash Sales & & 1,080.50 & & 10,397.90 & \\ \hline \multirow[t]{4}{*}{ 1-Jun } & Check 740 & ABC Company & Supplies & & 237.50 & 10,160.40 & \\ \hline & Check 741 & Trinity Roofing & repair roof & & 495.15 & 9,665.25 & \\ \hline & Check 742 & Sally Moore & Payroll & & 501.90 & 9,163.35 & \\ \hline & Check 743 & Atlanta Journal & Advertising & & 761.30 & 8,402.05 & \\ \hline \multirow[t]{6}{*}{ 3-Jun } & & Cash Sales & & 854.17 & & 9,256.22 & \\ \hline & Check 744 & McGarrisons & Office equipment & & 506.88 & 8,749.34 & \\ \hline & Check 745 & Verizon & Telephone & & 117.25 & 8,632.09 & \\ \hline & Check 746 & ABC Company & Supplies & & 298.66 & 8,333.43 & \\ \hline & Check 747 & Windstream & Internet service & & \begin{tabular}{l} - \\ \end{tabular} & 8,333.43 & \\ \hline & Check 748 & Jacob's Design shop & Signs for advertising & & 450.90 & 7,882.53 & \\ \hline \multirow[t]{3}{*}{ 8-Jun } & & Cash sales & & 840.50 & & 8,723.03 & \\ \hline & Check 749 & Sally Moore & Payroll & & 640.13 & 8,082.90 & \\ \hline & Check 750 & HMC Electric & Utilities & & 276.77 & 7,806.13 & \\ \hline \multirow[t]{2}{*}{ 10-Jun } & & Cash Sales & & 996.61 & & 8,802.74 & \\ \hline & Check 751 & Windsor & Furniture purchases & & 299.37 & 8,503.37 & \\ \hline \multirow[t]{4}{*}{ 15-Jun } & & EFT collection from customer & payment on account & 882.95 & & 9,386.32 & \\ \hline & Check 752 & Tammy's Design & Store design scheme & & 537.01 & 8,849.31 & \\ \hline & Check 753 & ABC Company & Supplies & & 380.95 & 8,468.36 & \\ \hline & Check 754 & Sally Moore & Payroll & & 449.75 & 8,018.61 & \\ \hline \multirow[t]{3}{*}{ 17-Jun } & & EFT from customer & payment on account & 1,606.74 & & 9,625.35 & \\ \hline & Check 755 & Excess Training & \multicolumn{2}{|c|}{ professional development } & 272.75 & 9,352.60 & \\ \hline & Check 756 & Hector's & meals for meeting & & 113.95 & 9,238.65 & \\ \hline \multirow[t]{2}{*}{ 22-Jun } & & Cash sales & & 897.34 & & 10,135.99 & \\ \hline & Check 757 & Sally Moore & Payroll & & 407.95 & 9,728.04 & \\ \hline \multirow[t]{4}{*}{ 24-Jun } & & EFT collection from customer & payment on account & 947.21 & & 10,675.25 & \\ \hline & Check 758 & Allstate & Insurance & & 259.60 & 10,415.65 & \\ \hline & Check 759 & ABC Company & Supplies & & 901.50 & 9,514.15 & \\ \hline & Check 760 & Sally Moore & Payroll & & 486.39 & 9,027.76 & \\ \hline 30-Jun & & Cash sales & & 1,117.74 & & 10,145.50 & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline & & & & & & & \\ \hline \end{tabular} Internal Controls Over Cash - Cash drawers: reconcile sales reports to cash inflows - Petty cash funds: reconcile vouchers to cash outflows - Cash in bank: reconcile bank balance to cash in books Bank Reconciliation Banks prepare monthly statements showing beginning and ending balances and transactions occurring during the month. Because differences are likely to exist between the bank balance and the company's cash balance per the accounting records, a monthly reconciliation is essential. Bank reconciliations are used (1) to determine whether the bank account and the company's cash balance are in agreement after taking into account unrecorded items, (2) to isolate recording errors and other problems in the bank's records or the company's recording system, (3) to establish the correct ending cash balance, and (4) to supply information for adjusting entries. The reconciliation process begins with the two cash balances (bank and book) and lists the differences between those balances and the true ending cash balance. Reconciliations are an important part of the accountant's day-to-day duties as well as the functions in an audit. Prepaid accounts must be reconciled to contracts, Unearned Revenue or Deposits Received in Advance must be reconciled to customer contracts, Imventories must be reconciled to count sheets, Property, Plant \& Equipment must be reconciled to count sheets. Mast every account on the balance sheet must be reconciled to confirming support documentation to determine reasonableness and reliabilty. Instructions: Read pages 8-37 through 8-39 to understand the terminology and concepts of the bank reconcilation process. For this assignment, students wil, compare the May reconciliation, the June checking ledger, and the June bonk statement, prepore a bank recanciliotion as of June 30, 20-using the work sheets provided in this file. Remember, the purpose of the bank reconciliation is to locate differences, so as you compare the files, highlight the cleared and agreed amounts in one color and the errors or differences in another. Investigate the differences and record on the bank reconciliotion. If errovs in recording deposits or checks are discovered, assume that the errors were made by the company. Journalize the necessary entries in the space provided. Add lines as needed. If you are unsure about the accounts impacted or the differences uncovered, make a list to conswit with your supervisor or the client. What is the amount of Cash that should appear on the balance sheet as of June 30