Problem 8-05A a-b (Video) The bank portion of the bank reconciliation for Concord Company at November 30, 2020, was as follows. Concord COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank $14,537.90 Add: Deposits in transit 2,530.20 17,068.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,055.60 6,307.40 Adjusted cash balance per bank $10,760.70 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 12-21 2,945 12-10 3477 2,130 12-26 2,567.30 12-15 3479 3,080 12-29 2,836 12-27 3480 600 12-30 1,025 12-30 3482 475.50 Total $18,152.90 12-29 3483 1,140 12-31 3485 540.80 Total $15,438.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 12-22 3483 1,140 12-7 2,365.10 12-2 3477 2,130 12-23 3484 792.40 12-15 2,672.70 12-4 3478 621.30 12-24 3485 450.80 12-20 2,954 12-8 3479 3,080 12-30 3486 889.50 12-25 2,567.30 12-10 3480 600 Total $13,927.60 12-28 2,836 12-17 3481 807.40 12-30 1,025 12-31 1,690.40 Total $17,322.10 The bank statement contained two memoranda: 1. A credit of $2,400 for the collection of Langer Company of an electronic funds transfer. 2. A debit for the printing of additional company checks $90.60. At December 31, the cash balance per books was $14,155.20, and the cash balance per the bank statement was $19,561.50. The bank did not make any errors, but Langer Company made two errors.
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.)
Concord COMPANY | ||
Bank Reconciliation | ||
December 31, 2020 | ||
Cash balance per bank statement | 19561.50 | |
Add: Deposits in transit | 1690.40 | |
21251.90 | ||
Less: Outstanding checks | ||
No. 3470 | 720.10 | |
No. 3474 | 1055.60 | |
No. 3478 | 621.30 | |
No. 3481 | 807.40 | |
No. 3484 | 792.40 | |
No. 3486 | 889.50 | |
4886.30 | ||
Adjusted cash balance per bank | 16365.60 | |
Cash balance per books | 14155.20 | |
Add: Electronic funds transfer received | 2400.00 | |
16555.20 | ||
Less: | ||
Error in recording check | 90.00 | |
Error in deposit | 9.00 | |
Check printing charge | 90.60 | |
189.60 | ||
Adjusted cash balance per books | 16365.60 | |
Journal entries: | ||
Dec 31 Cash | 2400.00 | |
Accounts Receivable | 2400.00 | |
(To record electronic funds transfer received by bank) | ||
Dec 31 Bank service charge expense/Miscellaneous expense | 90.60 | |
Cash | 90.60 | |
(To record charge for printing company checks) | ||
Dec.31 Accounts Payable | 90.00 | |
Cash | 90.00 | |
(To correct error in recording check) | ||
Dec.31 Accounts Receivable | 9.00 | |
Cash | 9.00 | |
(To correct error in deposit) | ||
Note: | ||
Error in recording check is for check 3485. Error amount = 540.80-450.80 = $90 | ||
Error in deposit is for 12/20 deposit. Error amount = 2954-2945 = $9 |
Problem 8-05A a-b (Video) The bank portion of the bank reconciliation for Concord Company at November 30, 2020, was as f...
The bank portion of the bank reconciliation for Concord Company at November 30, 2020, was as follows. Concord COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank $14,547.90 Add: Deposits in transit 2,530.20 17,078.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,775.00 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement...
Problem 8-05A a-b (Video) The bank portion of the bank reconciliation for Waterway Company at November 30, 2020, was as follows. Waterway COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank $14,777.90 Add: Deposits in transit 2,530.20 17,308.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,053.00 6,304.80 Adjusted cash balance per bank $11,003.30 The adjusted cash balance per bank agreed with the cash balance per books at November 30....
Please try to keep the same format! Problem 8-05A a-b (Video) The bank portion of the bank reconciliation for Bonita Company at November 30, 2020, was as follows. Bonita COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank Add: Deposits in transit $14,577.90 2,530.20 17,108.10 Less: Outstanding checks Check Number 3451 3470 3471 3472 Check Amount $ 2,260.40 720.10 844.50 1,426.80 1,051.30 3474 6,303.10 Adjusted cash balance per bank $10,805.00 The adjusted cash balance per bank agreed with the...
Can you please help me solve this problem? Problem 8-05A a-b (Video) The bank portion of the bank reconciliation for Waterway Company at November 30, 2020, was as follows. Waterway COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank Add: Deposits in transit $14,777.90 2,530.20 17,308.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,053.00 6,304.80 $11,003.30 The adjusted cash balance per bank agreed with...
How would you do the general journal adjusting entries for this? Bank Reconciliation The bank portion of the bank reconciliation for Hilo Company at November 30 was as follows. It agreed with the cash balance per books. The cash records per books for December showed the following: Cash Receipts Journal Date Amount Hilo Company Bank Reconciliation November 30 Cash balance per bank Add: Deposits in transit $14,367.90 2.530.20 16,898.10 Less: Outstanding checks Ck # Ck Amount 3451 $2,260.40 - 3470...
Question 2 Rinta Lad's accountant is preparing the bank reconciliation at 31 December 2018. The book balance was same as bank balance for 30 November The December bank statement showed the following checks and deposits Checks Date Number 12-4 3475 12-8 3476 12-10 3477 12-15 3479 12-27 3480 12-30 3482 12-29 3483 12-31 3485 Total Bank Statement Deposits Amount Date $1,640.70 12-1 1,300.00 12-4 2,130.00 12-8 3,080.00 12-16 600.00 12-21 475.50 12-26 1,140.00 12-29 540.80 12-30 $10,907.00 Total Amount $2,530.20...
Problem 7-05A a-b (Video) The bank portion of the bank reconciliation for Bogalusa Company at October 31, 2020, is shown below. Bogalusa Company Bank Reconciliation October 31, 2020 Cash balance per bank Add: Deposits in transit $12,367.90 1,530.20 13,898.10 Less: Outstanding checks Check Number Check Amount 2451 2470 2471 2472 $ 1,260.40 684.20 844.50 426.80 1,050.00 2474 4,265.90 $9,632.20 Adjusted cash balance per bank The adjusted cash balance per bank agreed with the cash balance per books at October 31....
Problem 7-4A The bank portion of the bank reconciliation for Pharoah Company at October 31, 2017, is shown below. PHAROAH COMPANY Bank Reconciliation October 31, 2017 Cash balance per bank $12,627.90 Add: Deposits in transit 1,530.20 14,158.10 Less: Outstanding checks Check Number Check Amount 2451 $1,260.40 2470 684.20 2471 844.50 2472 435.65 1,050.00 2474 4,274.75 $9,883.35 Adjusted cash balance per bank The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank....
Problem 7-04A (Part Level Submission) The bank portion of the bank reconciliation for Cullumber Company at October 31, 2022, is shown below. CULLUMBER COMPANY Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12,597.90 1,530.20 14,128.10 Less: Outstanding checks Check Number 2451 Check Amount $ 1,260.40 684.20 2470 2471 844.50 2472 427.80 1,050.00 2474 4,266.90 Adjusted cash balance per bank $9,861.20 The adjusted cash balance per bank agreed with the cash balance per books at October...
P7-7A The bank portion of last month’s bank reconciliation for Yap Ltd. at February 28 was as follows: YAP LTD. Bank Reconciliation February 28 Cash balance per bank $17,984 Add: Deposits in transit 3,140 21,124 Less: Outstanding cheques #3451 1,960 #3470 2,135 Reconciled cash balance $17,029 The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at February 28. The March bank statement showed the following: YAP LTD. Bank Statement March 31...