Balance as per the bank statement is $ 10 comma 990.

Question

bullet Balance as per books is $ 10 comma 400.
bullet Check​ #506 for $ 900 and check​ #510 for $ 650 were not shown on the June 30 bank statement.
bullet A deposit of $ 2 comma 850 had not been received by the bank when the bank statement was generated.
bullet A bank debit memo indicated an NSF check for $ 80 written by Maddie Wolfe to Ahlgren Company on June 13.
bullet A bank credit memo incidated a note collected by the bank of $ 2 comma 000 and interest revenue of $ 30 on June 20.
bullet The bank statement indicated service charges of $ 60.

Prepare bank reconciliation for Ahlgren Company for June ​30, 2025. ​(Leave unused input fields​ blank.)

Answer 1

To prepare the bank reconciliation for Ahlgren Company as of June 30, 2025, we need to reconcile the balances from the books and the bank statement by considering outstanding checks, deposits in transit, and other adjustments such as service charges and NSF checks.

Here's how the reconciliation will look:

Bank Reconciliation for Ahlgren Company

For the period ending June 30, 2025

Bank Balance:

• Balance per bank statement: $10,990
• Add: Deposits in transit: $2,850
• Less: Outstanding checks:
  • Check #506: ($900)
  • Check #510: ($650)
• Adjusted bank balance:
  $10,990 + $2,850 - $900 - $650 = $12,290

Book Balance:

• Balance per books: $10,400
• Add: Note collected by the bank: $2,000
• Add: Interest revenue: $30
• Less: NSF check: ($80)
• Less: Service charges: ($60)
• Adjusted book balance:
  $10,400 + $2,000 + $30 - $80 - $60 = $12,290

Summary:

Adjusted Bank Balance: $12,290
Adjusted Book Balance: $12,290

The adjusted bank balance matches the adjusted book balance, which indicates that the reconciliation is complete and accurate. You can fill in any further details if required, but this summarizes the bank reconciliation process for Ahlgren Company as of June 30, 2025.