Question

Calculate the balance of cash using a bank reconciliation (LO4-5) Spielberg Company's general ledger shows a checking account balance of $22,830 on July 31, 2021. The July cash receipts of $1,745, included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $41. The bank processes all checks written by the company by July 31 and lists them on the bank statement, except for one check totaling $1,320. The bank statement shows a balance of $22,364 on July 31.
Required:
1. Prepare a bank reconciliation to calculate the correct ending balance of cash on July 31, 2021. (Amounts to be deducted should be indicated with a minus sign.) SPIELBERG COMPANY Bank Reconciliation July 31, 2021 Bank's Cash Balance Company's Cash Balance Per General Ledger Per Bank Statement Bank Balance per Reconciliation Company Balance per Reconciliation
2. Record the necessary entry(ies) to adjust the balance for cash. (If no entry is required for a tra select "No Journal Entry Required" in the first account field.) View transaction list Journal entry worksheet 1 2 > Record the amounts that increase cash. Note: Enter debits before credits General Journal Debit Credit Date July 31, 2021

Answer 1

Answer:

A. Bank balance per reconciliation $22,789

Company balance per reconciliation $22,789

B. No journal entry required

Dr Service fees expense $41

Cr Cash $41

Explanation:

A Preparation of a bank reconciliation to calculate the correct ending balance of cash on July 31, 2021

Bank Reconciliation

July 31 2021

Bank Cash balance

Per bank statement $22,364

Add Deposits outstanding $1,745

Checks outstanding -$1,320

Bank balance per reconciliation $22,789

Company Cash balance

Per generall edger$ 22,830

Service Fees -$41

Company balance per reconciliation $22,789

B. Preparation of the journal entry to adjust the balance for cash.

No journal entry required

Dr Service fees expense $41

Cr Cash $41