hello I need this problem solved it's accounting I have attached a file in the microsoft word, I need it solved please post the solution in the excel file please thanks very much please have it in then next 30 minutes.

LANGER COMPANY Bank Reconciliation December 31, 2017

The bank portion of the bank reconciliation for Langer Company at November 30, 2017, was as follows. LANGER COMPANY Bank Reconciliation November 30, 2017 Cash balance per bank Add: Deposits in transit $14,767.90 2,530.20 17,298.10 Less: Outstanding checks Check Number 3451 3470 3471 3472 3474 Adjusted cash balance per bank Check Amount $ 2,260.40 720.10 844.50 1,426.80 1,051.50 6,303.30 $10,994.80 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement showed the following checks and deposits. Bank Statement Date 12-1 12-2 12-7 12-4 12-8 12-10 12-15 12-27 12-30 12-29 12-31 Checks Number 3451 3471 3472 3475 3476 3477 3479 3480 3482 3483 3485 Total Amount $2,260.40 844.50 1,426.80 1,640.70 1,300.00 2,130.00 3,080.00 600.00 475.50 1,140.00 530.80 $15,428.70 Date 12-1 12-4 12-8 12-16 12-21 12-26 12-29 12-30 Total Deposits Amount $ 2,530.20 1,211.60 2,365.10 2,672.70 2,945.00 2,567.30 2,836.00 1,025.00 $18,152.90 The cash records per books for December showed the following. Date 12-1 12-2 12-2 12-4 12-8 12-10 12-17 Number 3475 3476 3477 3478 3479 3480 3481 Cash Payments Journal Amount Date Number $1,640.70 12-20 3482 1,300.00 12-22 3483 2,130.00 12-23 3484 621.30 12-24 3485 3,080.00 12-30 3486 600.00 Total 807.40 Amount $475.50 1,140.00 796.50 350.80 889.50 $13,831.70 Cash Receipts Journal Date Amount 12-3 $ 1,211.60 12-7 2,365.10 12-15 2,672.70 12-20 2,954.00 12-25 2,567.30 12-28 2,836.00 12-30 1,025.00 12-31 1,690.40 Total $17,322.10 The bank statement contained two memoranda: 1 A credit of $5,265 for the collection of a $5,120 note for Langer Company plus interest of . $160.00 and less a collection fee of $15.00. Langer Company has not accrued any interest on the note. 2 A debit of $574.30 for an NSF check written by L. Rees, a customer. At December 31, the . check had not been redeposited in the bank. At December 31, the cash balance per books was $14,485.20, and the cash balance per the bank statement was $22,182.80. The bank did not make any errors, but two errors were made by Langer Company