Question

Option #1: Conducting a Bank Reconciliation Note: Part 1 is the bank reconciliation itself and Part 2 is for the adjusting en
• An NSF check in the amount of $500 (written by J. Smith, a customer) was returned by the bank to the company in the July 31
Spreadsheets + Bank Reconciliation Part 1 Bank Reconciliation Part 2 ACT300 Principles of Accounting Module 5: Critical Think
Spreadsheets + Bank Reconciliation Part 1 Bank Reconciliation Part 2 Requirements Compleme n t ed to bank reconciliation
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part :1

Bank Reconciliation as of 31/07/2011

Bank statement balance 15875 Book balance of cash 66955
ADD ADD
1) Deposit made but not yet credited in the bank account 52000 1) Interest credited by bank but not yet considered in cash statement 125
2) Check returned by the bank is not yet considered in cash balance 500 2) Collection from customer is considered in bank statement but not in cash statement 1000
3) Bank charges debited in the bank account but not yet entered in the cash statement 50 3) Wrong entry passed in cash statement (520-250) 270
4) Bank erroneously debited other companies check 5000 4) #364 and #365 check's considered in cash statement but outstanding at bank 2075
5) Bank erroneously credited other companies check 3000
DEDUCT DEDUCT
1) Interest credited by bank not yet considered in cash statement 125 1) deposit made but not yet credited in the bank account 52000
2) Collection from customer considered in bank statement but not in cash statement 1000 2) Check returned by bank is not yet considered in cash statement 500
3) Wrong entry passed in cash statement (520-250) 270 3) Bank charges not yet considered in cash statement 50
4) #354 and #365 Check's outstanding at Bank but entered in cash statement 2075 4) Bank erroneously debited other companies check 5000
5) Bank erroneously credited other companies check 3000
Reconciled balance as per books 66955 Reconciled balance as per bank statement 15875

PART : 2

Adjustment Entries

1) J. Smith Dr. 500

To bank a/c 500

( Being check returned by bank)

2) Bank charges Dr 50

To bank a/c 50

(Being bank charges deducted)

3) Bank a/c Dr 125

To interest income 125

( Being interest credited by bank)

4) Bank a/c Dr 1000

To H. Doe 1000

( Being collections made by bank)

5) Bank a/c Dr 270

To Expense / 'X' party 270

( Being error rectified)

Add a comment
Know the answer?
Add Answer to:
Option #1: Conducting a Bank Reconciliation Note: Part 1 is the bank reconciliation itself and Part...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Option #1: Conducting a Bank Reconciliation Note: Part 1 is the bank reconciliation itself and Part...

    Option #1: Conducting a Bank Reconciliation Note: Part 1 is the bank reconciliation itself and Part 2 is for the adjusting entries. Instructions: Using the information below, complete the bank reconciliation for both the "book" and the "bank" sides and create all necessary adjusting journal entries. Details: Cash balance per company's records as of July 31st, 2011 was $66,955. Bank statement balance as of July 31st, 2011 was $15,875. A deposit in the amount of $52,000 was deposited into the...

  • Option #1: Conducting a Bank Reconciliation Note: Part 1 is the bank reconciliation itself and Part...

    Option #1: Conducting a Bank Reconciliation Note: Part 1 is the bank reconciliation itself and Part 2 is for the adjusting entries. Instructions: Using the information below, complete the bank reconciliation for both the "book" and the "bank" sides and create all necessary adjusting journal entries. Details: Cash balance per company's records as of July 31st, 2011 was $66,955. Bank statement balance as of July 31st, 2011 was $15,875. A deposit in the amount of $52,000 was deposited into the...

  • Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...

    Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $22,020. Cash balance according to the bank statement at July 31, $22,940. Checks outstanding, $4,470. Deposit in transit, not recorded by bank, $3,590. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $50. a. Prepare a...

  • prepare a bank reconciliation as of October 31 from the above information Refer to the information...

    prepare a bank reconciliation as of October 31 from the above information Refer to the information given below a. The October 31 cash balance in the general ledger is $836. b. The October 31 balance shown on the bank statement is $335 c. Checks issued but not returned with the bank statement were No. 462 for $14 and No. 483 for $43 d. A deposit made late on October 31 for $472 is included in the general ledger balance but...

  • Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...

    Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: 1. Cash balance according to the company's records at July 31 $19,590. 2. Cash balance according to the bank statement at July 31, $20,420. 3. Checks outstanding, $3,980. 4. Deposit in transit, not recorded by bank, $3,190. 5. A check for $340 in payment of an account was erroneously recorded in the check register as $430. 6. Bank debit memo for...

  • Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...

    Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: 1. Cash balance according to the company's records at July 31 $17,490. 2. Cash balance according to the bank statement at July 31, $18,520. 3. Checks outstanding, $3,550. 4. Deposit in transit, not recorded by bank, $2,850. 5. A check for $590 in payment of an account was erroneously recorded in the check register as $950. 6. Bank debit memo for...

  • bank reconciliation Bank Reconciliation The following information is available to assist you in preparing a bank...

    bank reconciliation Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Burgoon Enterprises on May 31: a. The balance on the May 31 bank statement is $8,432.11. b. Not included on the bank statement is a $1,250 deposit made by Burgoon Enterprises late on May 31. c. A comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at May 31: No....

  • bank reconciliation the following dada were accumulated for use in reconciliation gonna in the bank account...

    bank reconciliation the following dada were accumulated for use in reconciliation gonna in the bank account of Creative Design Co. for August 20Y6 Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: 1. Cash balance according to the company's records at August 31, $42,920. 2. Cash balance according to the bank statement at August 31, $56,300. 3. Checks outstanding, $25,390. 4. Deposit in transit not recorded by bank,...

  • Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...

    Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $14,720. Cash balance according to the bank statement at July 31, $15,730. Checks outstanding, $2,990. Deposit in transit, not recorded by bank, $2,400. A check for $270 in payment of an account was erroneously recorded in the check register as $720. Bank debit memo for service charges, $30. a. Prepare a...

  • Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...

    Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $22,020. Cash balance according to the bank statement at July 31, $22,940. Checks outstanding, $4,470. Deposit in transit, not recorded by bank, $3,590. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $50. a. Prepare a...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT