In: Accounting
The bank portion of the bank reconciliation for Sheridan Company
at November 30, 2020, was as follows.
Sheridan COMPANY |
||||
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 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 | 795.50 | 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,930.70 |
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,410 for the collection of Langer Company of an electronic funds transfer. | |
2. | A debit for the printing of additional company checks $87.50. |
At December 31, the cash balance per books was $14,295.20, and the
cash balance per the bank statement was $19,714.60. The bank did
not make any errors, but Langer Company made two
errors.
Bank Reconciliation | ||
December 31,2020 | ||
Cash balance per bank statement | 19714.60 | |
Add: Deposits in transit | 1690.40 | |
21405.00 | ||
Less: Outstanding checks | ||
No. 3470 | 720.10 | |
No. 3474 | 1052.50 | |
No. 3478 | 621.30 | |
No. 3481 | 807.40 | |
No. 3484 | 795.50 | |
No. 3486 | 889.50 | |
4886.30 | ||
Adjusted cash balance per bank | 16518.70 | |
Cash balance per books | 14295.20 | |
Add: Electronic funds transfer received | 2410.00 | |
16705.20 | ||
Less: | ||
Error in deposit | 9.00 | |
Error in recording check | 90.00 | |
Check printing charge | 87.50 | |
186.50 | ||
Adjusted cash balance per books | 16518.70 | |
2 | ||
Cash | 2410 | |
Accounts Receivable | 2410 | |
Miscellaneous expense | 87.5 | |
Cash | 87.5 | |
(To record charge for printing company checks) | ||
Accounts Payable | 90 | |
Cash | 90 | |
(To correct error in recording check) | ||
Accounts Receivable | 9 | |
Cash | 9 | |
(To correct error in deposit) | ||