Question
Balance as per the bank statement is $ 10 comma 990.
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.)
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.)
Answers
GPT-4o mini
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.
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.