In: Accounting
Harrison Company maintains a checking account at the
First National City Bank. The bank provides a bank statement along
with canceled checks on the last day of each month. The July 2021
bank statement included the following information:
Balance, July 1, 2021 | $ | 57,428 | |
Deposits | 180,900 | ||
Checks processed | (194,010 | ) | |
Service charges | (45 | ) | |
NSF checks | (1,900 | ) | |
Monthly payment on note, deducted directly by bank from
account (includes $220 in interest) |
(4,020 | ) | |
Balance, July 31, 2021 | $ | 38,353 | |
The company’s general ledger account had a balance of $40,803 at
the end of July. Deposits outstanding totaled $7,700 and all checks
written by the company were processed by the bank except for those
totaling $8,560. In addition, a $3,400 July deposit from a credit
customer was recorded as a $340 debit to cash and credit to
accounts receivable, and a check correctly recorded by the company
as a $45 disbursement was incorrectly processed by the bank as a
$450 disbursement.
Required:
1. Prepare a bank reconciliation for the month of
July.
2. Prepare the necessary journal entries at the
end of July to adjust the general ledger cash account.
Answer: 1) | |
Bank Reconciliation statement for the month of July | |
Balance per bank statement | $38,353 |
Add: Deposits outstanding | $7,700 |
Bank error in recording check ($450 (-) $45) |
$405 |
$46,458 | |
Deduct: Checks outstanding | ($8,560) |
Adjusted cash balance | $37,898 |
Add : Error in recording ($3,400 (-) $340) |
$3,060 |
$43,863 | |
Deduct:Service charges | ($45) |
NSF checks | ($1,900) |
Monthly loan payment | ($4,020) |
Adjusted cash balance | $37,898 |
2) Preparation of journal Entries | |||
Date | Accounts and Explanation | Debit (in $) | Credit (in $) |
Cash | $3,060 | ||
Accounts Receivable | $3,060 | ||
(To record the error in recording Cash receipts) | |||
Misc Exp/ Bank Service Charges | $45 | ||
Accounts Receivable - NSF checks | $1,900 | ||
Interest Expense | $220 | ||
Note Payable | $3,800 | ||
Cash | $5,965 | ||
(To record credit to cash) | |||