Business Homework Solutions
Problem
#155515

Adjusting journal entries and corrected bank reconciliation

Bank Rec, Dec 31, 2004

Balance per ledger Dec.31, 2004                                 $17,174.86
Add:
Cash receipts received on the last day of December and
charged to "cash in bank" on books but no deposited               2,662.25
Debit memo for customer's cheque returned unpaid (cheque is on
hand but no entry has been made on boks)                            200.00
Debit memo for bank service charge for December                       5.50
Total                                                           $20,142.61
Deduct:
Cheques drawn but not paid by bank
(see detailed list below)                             $2,267.75
Credit memo for proceeds of a note receivable that
had been left at the bank for collection but which
has not been recorded as collected.                      400.00
Cheques for an account payable entered on books as
$240.90 but drawn and pais by bank as $419.00            178.10 (2,945.85)
Computed balance                                                17,196.76
Unlocated difference                                              (200.00)
Balance per bank (checked for confirmation)                     16,996.76

Cheques drawn but not paid by bank:
573     $67.27
724       9.90
903     456.67
907     305.50
911     482.75
913     550.00
914     366.76
916      10.00
917     218.90
Total  2,267.75

I need help preparing the corrected reconciliation and preparing the journal entries for items that should be adjusted prior to closing the books.

Attached file(s):
Attachments
Auditing question.doc  View File

Attachment Content Summary (Note: view attachment at the above link before purchasing. Actual attachment content may vary slightly from that shown below.)

Auditing question.doc
Bank Rec, Dec 31, 2004

Balance per ledger Dec.31, 2004
$17,174.86

Add:

Cash receipts received on the last day of December and

charged to "cash in bank" on books but no deposited
2,662.25

Debit memo for customer's cheque returned unpaid (cheque is on

hand but no entry has been made on books)
200.00

Debit memo for bank service charge for December
5.50

Total
$20,142.61

Deduct:

Cheques drawn but not paid by bank

(see detailed list below) $2,267.75

Credit memo for proceeds of a note receivable that

had been left at the bank for collection but which

has not been recorded as collected. 400.00

Cheques for an account payable entered on books as

$240.90 but drawn and pais by bank as $419.00 178.10
(2,945.85)

Computed balance
17,196.76

Unlocated difference
(200.00)

Balance per bank (checked for confirmation)
16,996.76

Cheques drawn but not paid by bank:

573 $67.27

724 9.90

903 456.67

907 305.50

911 482.75

913 550.00

914 366.76

916 10.00

917 218.90

Total 2,267.75

*Prepare a corrected reconciliation

*Prepare journal entries for items that should be adjusted prior to
closing the books.

Solution Summary

The solution presents a corrected bank reconciliation in the two step format: book to bank and bank to book.  The format is more understandable when looking for errors.  The journal entries needed for the books are also written out in the solution.

This is an auditing question and it contains an error not easily seen, but proper auditing technique would find it.  The solution discloses the little trick too.

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
  • Attached file(s):
    • 155515.xls
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • DeVries Company - E7-8 The following information pertains to DeVries Company 1)Cash balance per bank on July 31, $7,328. 2)July bank service charge not recorded by the depositor $40. 3)Cash balance as per books, ...
  • Jose Orozco Co: Bank reconciliation, adjusting entries - Bank Reconciliation and adjusting entries The cash account of Jose Orozco Co. showed ledger balance of $3,969,.85 on June 30, 2007. The bank statement as of that date showed a balance of $4,150. Up ...
  • Galenti Company: Preparing bank reconciliation and adjusting entries - On May 31, 2007, Galenti Company had a cash balance per books of $5,681.50. The bank statement from Community Bank on that date showed a balance of $7,964.60. A comparison of the statement with the ca ...
  • Bank Reconciliation, Journal Entries - The following information is available to reconcile Clark Company's book balance of cash with its bank statement cash balance as of July 31, 2005: a. After all posting is complete on July 31, the ...
  • Prepare a bank reconciliation and journalize adjusting entries - The following information pertains to Worthy Video Company. 1. Cash balance per bank, July 31, $7,263. 2. July bank service charge not recorded by the depositor $28. 3. Cash balance per books, July ...
Browse