Hi! I'm not quite sure how to go about this problem (attached), I was wondering if you could help me with it. Thanks!

Using the four steps in the reconciliation procedure, prepare a bank reconciliation at December 31.

Prepare the adjusting entries based on the reconciliation.

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 $14,717.90 Add: Deposits in transit 2,530.20 17,248.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 Using the four steps in the reconciliation procedure, prepare a bank reconciliation at December 3470 to 2 decimal places, e.g. 52.75. 720.10 31. (Round answers List items that increase cash balance first. Reconcile cash balance per bank first.) 3471 844.50 3472 LANGER COMPANY Bank 3474 Reconciliation Adjusted cash balance per bank December 31, 2017 1,426.80 1,056.00 6,307.80 $10,940.30 $ per bank agreed with the cash balance per books at November 30. The adjusted cash balance The December bank statement showed the following checks and deposits. : Bank Statement Checks Deposits Date : Number 12-1 3451 $2,260.40 12-1 12-2 3471 844.50 12-4 3472 1,426.80 12-8 12-4 3475 1,640.70 12-16 12-8 3476 1,300.00 12-21 12-10 3477 2,130.00 12-26 12-15 3479 3,080.00 12-29 12-27 3480 600.00 12-30 12-30 3482 475.50 Total 12-29 3483 1,140.00 12-31 3485 540.80 12-7 $ $ Amount Total Date $15,438.70 The cash records per books for December showed the following. $ Cash Payments Journal Date 12-1: Number Amount Date Number Amount 3475 $1,640.70 12-20 3482 $475.50 12-2 3476 1,300.00 12-22 3483 1,140.00 12-2 3477 2,130.00 12-23 3484 792.00 12-4: 12-8 3478 621.30 12-24 3485 450.80 $3479 3,080.00 12-30 3486 889.50 12-10 3480 600.00 12-17 3481 807.40 Total $13,927.20 The bank statement contained two memoranda: 1. A credit of $5,275 for the collection of a $5,130 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. $ Prepare the adjusting entries based on the reconciliation. (Credit account titles are automatically indented when amount is entered. Do not indent manually. Round answers to 2 decimal places, e.g. 52.75.) No. Account Titles and Explanation Dec. 31 (To record collection of note receivable by bank) Dec. 31 (To record NSF Check) Dec. 31 (To correct error in recording check) Dec. 31 (To correct error in deposit) Debi Credi t t