PLEASE SHOW ME HOW TO DO IT STEP BY STEP AND EXPLAIN

3) Open the PDF below and complete the exercise - type your answers below: Statement Recohciliation A) Please list out all the missing transactions between our record and the statement from Midnight Hardware Supply as of Feb 28 B) Write the appropriate business letter to request a copy of the missing invoice on the letterhead provided. You may type or hand-write for the purposes of this test. It may be an email or official letter Statement/Account Reconciliation 7. Perform the following steps to demonstrate your ability to reconcile accounts: a. Balance the following Statement for Midnight Hardware Supply as of Feb 28 against our records. b. Prepare a brief explanation to show the reconciliation. You may use the format given or any other format you may be more familiar with. C. Please show the journal entry needed to bring our account up to date with their records. d. Write the appropriate business letter to request a copy of the missing invoice on the letterhead provided. You may type or hand-write for the purposes of this test. Open with OUR RECORDS Date Invoice Midnight Hardware Supply Amount Balance Due Check # Date Paid 111689 111689 111568 111568 01-15-95 01-15-95 02-28-95 02-28-95 12-24-94 12-24-94 01-10-95 01-14-95 01-18-95 01-19-95 01-19-95 01-19-95 01-24-95 01-26-95 01-26-95 01-26-95 01-29-95 02-06-95 02-08-95 02-16-95 02-20-95 02-24-95 02-26-95 03-08-95 03-08-95 03-09-95 03-09-95 14895 14896 15884 15990 15583 15317 15348 15375 15653 15563 15601 15655 1056 15792 15886 16026 16038 16099 16196 16232 16248 16318 16353 256.80 5.60 100.56 568.22 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 -3.22 125.51 223.90 275.52 16.16 95.64 125.12 92.88 58.05 129.41 35.96 3447.72 0.00 0.00 0.00 0.00 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 -3.22 125.51 223.90 275.52 16.16 95.64 125.12 92.88 58.05 129.41 35.96 2516.54 Their Statement Less: Payments not posted Plus: Items after cutoff Plus or minus adjustments: Balance per our records Journal Entry: Debit Credit Page 23 + Midnight Hardware Supply STATEMENT Statement Date 02/28/95 ABC Supplies PO Box 3425A San Diego, CA 92199 Acct # 288012 PAYMENT DATE 01-25-95 01-25-95 PAYMENT PAYMENT REFERENCE AMOUNT 111689 256.80 111689 5.60 INVOICE DATE 12-24-94 12-24-94 01-06-95 01-10-95 01-18-95 01-19-95 01-19-95 01-19-95 01-24-95 01-26-95 01-26-95 01-26-95 01-29-95 02-06-95 02-08-95 02-16-95 02-17-95 02-20-95 02-24-95 02-26-95 02-28-95 INVOICE NUMBER 14895 14896 15990 15884 15583 15317 15348 15375 15653 15563 15601 15655 1056 15792 15886 16026 16028 16038 16099 16196 FC INVOICE AMOUNT 256.80 5.60 568.22 100.56 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 3.22CR 125.51 223.90 275.52 57.62 16.16 95.64 125.12 6.60 BALANCE DUE 0.00 0.00 568.22 100.56 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 (3.22) 125.51 223.90 275.52 57.62 16.16 95.64 125.12 6.60 CURRENT 30 DAYS 60 DAYS CHARGES SERVICE DUE BALANCE 919.47 2007.17 6.60 2933.24 3) Open the PDF below and complete the exercise - type your answers below: Statement Recohciliation A) Please list out all the missing transactions between our record and the statement from Midnight Hardware Supply as of Feb 28 B) Write the appropriate business letter to request a copy of the missing invoice on the letterhead provided. You may type or hand-write for the purposes of this test. It may be an email or official letter Statement/Account Reconciliation 7. Perform the following steps to demonstrate your ability to reconcile accounts: a. Balance the following Statement for Midnight Hardware Supply as of Feb 28 against our records. b. Prepare a brief explanation to show the reconciliation. You may use the format given or any other format you may be more familiar with. C. Please show the journal entry needed to bring our account up to date with their records. d. Write the appropriate business letter to request a copy of the missing invoice on the letterhead provided. You may type or hand-write for the purposes of this test. Open with OUR RECORDS Date Invoice Midnight Hardware Supply Amount Balance Due Check # Date Paid 111689 111689 111568 111568 01-15-95 01-15-95 02-28-95 02-28-95 12-24-94 12-24-94 01-10-95 01-14-95 01-18-95 01-19-95 01-19-95 01-19-95 01-24-95 01-26-95 01-26-95 01-26-95 01-29-95 02-06-95 02-08-95 02-16-95 02-20-95 02-24-95 02-26-95 03-08-95 03-08-95 03-09-95 03-09-95 14895 14896 15884 15990 15583 15317 15348 15375 15653 15563 15601 15655 1056 15792 15886 16026 16038 16099 16196 16232 16248 16318 16353 256.80 5.60 100.56 568.22 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 -3.22 125.51 223.90 275.52 16.16 95.64 125.12 92.88 58.05 129.41 35.96 3447.72 0.00 0.00 0.00 0.00 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 -3.22 125.51 223.90 275.52 16.16 95.64 125.12 92.88 58.05 129.41 35.96 2516.54 Their Statement Less: Payments not posted Plus: Items after cutoff Plus or minus adjustments: Balance per our records Journal Entry: Debit Credit Page 23 + Midnight Hardware Supply STATEMENT Statement Date 02/28/95 ABC Supplies PO Box 3425A San Diego, CA 92199 Acct # 288012 PAYMENT DATE 01-25-95 01-25-95 PAYMENT PAYMENT REFERENCE AMOUNT 111689 256.80 111689 5.60 INVOICE DATE 12-24-94 12-24-94 01-06-95 01-10-95 01-18-95 01-19-95 01-19-95 01-19-95 01-24-95 01-26-95 01-26-95 01-26-95 01-29-95 02-06-95 02-08-95 02-16-95 02-17-95 02-20-95 02-24-95 02-26-95 02-28-95 INVOICE NUMBER 14895 14896 15990 15884 15583 15317 15348 15375 15653 15563 15601 15655 1056 15792 15886 16026 16028 16038 16099 16196 FC INVOICE AMOUNT 256.80 5.60 568.22 100.56 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 3.22CR 125.51 223.90 275.52 57.62 16.16 95.64 125.12 6.60 BALANCE DUE 0.00 0.00 568.22 100.56 61.42 49.81 334.57 552.60 13.45 213.70 97.48 18.58 (3.22) 125.51 223.90 275.52 57.62 16.16 95.64 125.12 6.60 CURRENT 30 DAYS 60 DAYS CHARGES SERVICE DUE BALANCE 919.47 2007.17 6.60 2933.24