Question

In: Accounting

The bank portion of the bank reconciliation for Langer Company at November 30, 2017, was as...

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,807.90

Add: Deposits in transit

2,530.20

17,338.10

Less: Outstanding checks

Check Number

Check Amount

3451

$ 2,260.40

3470

720.10

3471

844.50

3472

1,426.80

3474

1,057.30

6,309.10

Adjusted cash balance per bank

$11,029.00


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

Checks

Deposits

Date

Number

Amount

Date

Amount

12-1 3451 $2,260.40 12-1 $ 2,530.20
12-2 3471 844.50 12-4 1,211.60
12-7 3472 1,426.80 12-8 2,365.10
12-4 3475 1,640.70 12-16 2,672.70
12-8 3476 1,300.00 12-21 2,945.00
12-10 3477 2,130.00 12-26 2,567.30
12-15 3479 3,080.00 12-29 2,836.00
12-27 3480 600.00 12-30

1,025.00

12-30 3482 475.50 Total

$18,152.90

12-29 3483 1,140.00
12-31 3485

530.80

Total

$15,428.70


The cash records per books for December showed the following.

Cash Payments Journal

Cash Receipts Journal

Date

Number

Amount

Date

Number

Amount

Date

Amount

12-1 3475 $1,640.70 12-20 3482 $475.50 12-3 $ 1,211.60
12-2 3476 1,300.00 12-22 3483 1,140.00 12-7 2,365.10
12-2 3477 2,130.00 12-23 3484 790.70 12-15 2,672.70
12-4 3478 621.30 12-24 3485

350.80

12-20 2,954.00
12-8 3479 3,080.00 12-30 3486

889.50

12-25 2,567.30
12-10 3480 600.00 Total

$13,825.90

12-28 2,836.00
12-17 3481 807.40 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,285 for the collection of a $5,140 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 $580.10 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,525.20, and the cash balance per the bank statement was $22,237.00. The bank did not make any errors, but two errors were made by Langer Company.

What I need Answered:

- Using the four steps in the reconciliation procedure, prepare a bank reconciliation at December 31. (Round answers to 2 decimal places, e.g. 52.75. List items that increase cash balance first. Reconcile cash balance per bank first.)
- 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.)

Solutions

Expert Solution


Related Solutions

The bank portion of the bank reconciliation for Langer Company at November 30, 2017, was as...
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,657.90 Add: Deposits in transit 2,530.20 17,188.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,057.90 6,309.70 Adjusted cash balance per bank $10,878.40 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement...
The bank portion of the bank reconciliation for Langer Company at November 30, 2017, was as...
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,657.90 Add: Deposits in transit 2,530.20 17,188.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,057.90 6,309.70 Adjusted cash balance per bank $10,878.40 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement...
Problem 8-4A The bank portion of the bank reconciliation for Langer Company at November 30, 2017,...
Problem 8-4A 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,577.90 Add: Deposits in transit 2,530.20 17,108.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,051.30 6,303.10 Adjusted cash balance per bank $10,805.00 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December...
LANGER COMPANY Bank Reconciliation November 30, 2017 Cash balance per bank $14,717.90 Add: Deposits in transit...
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 3470 720.10 3471 844.50 3472 1,426.80 3474 1,056.00 6,307.80 Adjusted cash balance per bank $10,940.30 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 Checks Deposits Date Number Amount Date Amount 12-1 3451...
The bank portion of the bank reconciliation for Sheridan Company at November 30, 2020, was as...
The bank portion of the bank reconciliation for Sheridan Company at November 30, 2020, was as follows. Sheridan COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank $14,677.90 Add: Deposits in transit 2,530.20 17,208.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,052.50 6,304.30 Adjusted cash balance per bank $10,903.80 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement...
The bank portion of the bank reconciliation for Thomas Company at November 30, 2019, is: THOMAS...
The bank portion of the bank reconciliation for Thomas Company at November 30, 2019, is: THOMAS COMPANY Bank Reconciliation November 30, 2019 Cash balance per bank $14,367.90 Add: Deposits in transit 2,530.20 16,898.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 1,100.10 3471 824.50 3472 1,446.80 3474 1,050.00 6,681.80 Adjusted cash balance per bank $10,216.30 The adjusted cash balance per bank agreed with the cash balance per books at November 30. At December 31, the cash balance...
The bank portion of the bank reconciliation for the Fixar Company at January 31,2018 is as...
The bank portion of the bank reconciliation for the Fixar Company at January 31,2018 is as follows:                                                                                        FIXAR COMPANY                                                                                                                                                                                                       Bank Reconciliation                                                                                                                                                                         January 31, 2018                                                                                                                                                                                                                                                                                                                              Cash balance per bank                                                                                                                 $13,581.90                   Add: Deposits in transit                                                                                                                       1,432.80                                                                                                                                                                                       15,014.70 Less:        Outstanding checks                                                    Check Number Check Amount                                                                      3351        $1,089.20                                                                      3370                930.40                                                                      3371                844.50                                                                      3372                734.90                                                                      3374            1,050.00                                                                      3375            1,396.60                                                                                   6,045.60                                                                                                                                Adjusted cash balance per bank                                                                                                             $8,969.10 The...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as follows: BLOSSOM COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,771 Add: Deposits in transit 1,580 13,351 Less: Outstanding cheques    #2451 $1,200    #2470 960    #2471 882    #2472 516    #2474 1,060 4,618 Adjusted cash balance per bank $8,733 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: BLOSSOM COMPANY...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as follows: BLOSSOM COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,000 Add: Deposits in transit 1,500 12,500 Less: Outstanding cheques    #2451 $1,100    #2470 850    #2471 780    #2472 450    #2474 1,000 4,180 Adjusted cash balance per bank $8,320 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: BLOSSOM COMPANY...
Prepare a bank reconciliation at November 30 List items that increase balance as per bank &...
Prepare a bank reconciliation at November 30 List items that increase balance as per bank & books first The bank portion of last month’s bank reconciliation for Crane Limited at October 31 is shown here: CRANE LIMITED Bank Reconciliation October 31 Cash balance per bank $24,920 Add: Deposits in transit 2,972 27,892 Less: Outstanding cheques                #2472 $1,430                #2473 1,600                #2474 1,038 4,068 Reconciled cash balance $23,824 The reconciled cash balance per bank agreed with the reconciled cash balance per books...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT