Question

In: Accounting

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 after the bank reconciliation at October 31. The November bank statement showed the following:

CRANE LIMITED
Bank Statement
November 30
Date Description Amounts
Deducted from
Account (Debits)		 Amounts Added
to Account
(Credits)		 Balance
Oct. 31 24,920
Nov. 1 Cheque, No. 2472 1,430 23,490
1 Deposit 2,972 26,462
2 Cheque, No. 2473 1,600 24,862
3 Deposit 2,350 27,212
4 Cheque, No. 2475 3,357 23,855
7 Deposit 2,130 25,985
8 Cheque, No. 2476 5,710 20,275
10 Cheque, No. 2477 1,200 19,075
14 Deposit 4,930 24,005
15 Cheque, No. 2478 3,100 20,905
15 EFT, salaries 6,500 14,405
20 Deposit 5,890 20,295
25 Returned cheque—NSF, Giasson Developments 400 19,895
25 NSF fee 8 19,887
26 Cheque, No. 2479 1,410 18,477
27 Deposit 3,100 21,577
28 EFT, collection of note receivable and interest 5,048 26,625
30 Cheque, No. 2481 1,099 25,526
30 EFT, salaries 6,500 19,026
30 Bank service charges 5 19,021



The cash records per books for November showed the following:

Cash Receipts Cash Payments
Date Amount Date Number Amount
Nov. 3 $2,350 Nov. 1 2475 $ 3,357
7 2,130 2 2476 4,710
12 4,930 2 2477 1,200
20 5,908 8 2478 3,100
27 3,100 15 2479 1,410
30 2,808 15 EFT, salaries 6,500
$21,226 18 2480 1,324
20 2481 1,099
29 2482 1,720
30 EFT, salaries 6,500
$30,920

Solutions

Expert Solution

CRANE LIMITED
Bank Reconciliation
Nov. 31
Bank Statement Balance      19,021 Book Balance      14,130
Add: Add:
Deposit in Transit         2,808 Proceeds of note         5,048
Deduct: Deduct:
SERVICE CHARGE               13
Outstanding Checks(#2474)         1,038 Error in Nov 20 deposit               18
Outstanding Checks(#2480)         1,324 NSF Check            400
Outstanding Checks(#2482)         1,720 Check Error #2476         1,000
Adjusted Bank Balance      17,747 Adjusted Book Balance      17,747

ekkarill92 answered 3 years ago
Next > < Previous

Related Solutions

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 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...
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...
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...
Instructions a. Prepare a bank reconciliation dated June 30, 2020, proceeding to a correct cash balance....
Instructions a. Prepare a bank reconciliation dated June 30, 2020, proceeding to a correct cash balance. b. Prepare any entries necessary to make the books correct and complete. *P7.14 (LO 6) (Bank Reconciliation and Adjusting Entries) Presented below is information related to Haselhof Inc. Balance per books at October 31, $41,847.85; receipts $173,523.91; disbursements $164,893.54. Balance per bank statement November 30, $56,274.20. The following checks were outstanding at November 30. 1224 $1,635.29 1230 2,468.30 1232 2,125.15 1233 482.17 Included with...
Classifying bank reconciliation items The following items could appear on a bank reconciliation:
Question Classifying bank reconciliation items The following items could appear on a bank reconciliation:a. Outstanding checks, $670.b. Deposits in transit, $1,500.c. NSF check from customer, no. 548, for $175.d. Bank collection of note receivable of $800, and interest of $80.e. Interest earned on bank balance, $20.f. Service charge, $10.g. The business credited Cash for $200. The correct amount was $2,000.h. The bank incorrectly decreased the business’s account by $350 for a check written by another business.Classify each item as (1)...
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...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the month of June. It reconciles the bank balance and the book balance to the correct balance. For each of the following items, indicate whether the item is an addition to the bank balance, an addition to the book balance, a deduction from the bank balance, a deduction from the book balance, or would not appear on the June reconciliation. Also, choose Yes or No...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT