The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $84,457. The bank statement indicated a balance of $127,190 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: a. Checks outstanding totaled $33,310.
b. A deposit of $17,610, representing receipts of June 30, had been made too late to appear on the bank statement.
c. The bank collected $28,248 on a $26,400 note, including interest of $1,848.
d. A check for $1,100 returned with the statement had been incorrectly recorded by Pala Medical Co. as $110. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account.
e. A check drawn for $680 had been erroneously charged by the bank as $860.
f. Bank service charges for June amounted to $45.

Required:
a. Prepare a bank reconciliation.
b. Journalize the necessary entries.
c. If a balance sheet were prepared for Pala Medical Co. on June 30, 20Y1, what amount should be reported as cash?

Pala Medical Co.

a. Bank Reconciliation Statement as at June 30, 20Y1

Balance as per adjusted cash balance $111,670

add outstanding checks                           33,310

less uncredited deposits                           17,610

       overdrawn check                                   180

Balance as per bank statement          $127,190

b. Journal Entries:

c. Debit Cash $28,248

Credit Notes Receivable $26,400

Credit Interest Revenue $1,848

To record the receipt on notes receivable, including interest revenue.

d. Debit Accounts Payable $990

Credit Cash $990

To record the check in payment on account ($1,100 - $110)

f. Debit Bank service charges $45

Credit Cash $45

To record bank charges.

c. If a balance sheet were prepared for Pala Medical Co. on June 30, 20Y1, the amount that should be reported as cash is:

= $111,670.

Explanation:

a) Data and Calculations:

Cash account balance at June 30, 20Y1 = $84,457

Bank statement balance on June 30, 20Y1 = $127,190

Analysis of discrepancies:

a. Outstanding checks $33,310

b. Uncredited deposits $17,610

c. Cash $28,248 Note Receivable $26,400  Interest Revenue $1,848

d. Returned check $1,100 Accounts Payable $1,100  $110

e. Overdrawn check $180 $680 had been erroneously charged by the bank as $860.

f. Bank service charges for June amounted to $45

Cash Account Adjustments:

Balance at June 30, 20Y1 = $84,457

Direct credit                           28,248

Dishonored check                     (990)

Bank charges                               (45)

Adjusted cash balance       $111,670