Question

You have been provided with the following information for XYZ Corporation and its bank, ABC Trust...

You have been provided with the following information for XYZ Corporation and its bank, ABC Trust Company. From the Bank Statement at the end of May 2002:

Ending balance

$30,399.00

Bank charges

26.10

NSF cheque

5,400.00

Interest collected on a note for the company by the bank

635.10

From the cash records of the company at the end of May 2002:

Cash on hand

$300.00

Ending balance, cash (including cash on hand)

52,500.00

Unrecorded deposits

21,000.00

Outstanding cheques:

No. 30

$1,800.00

No. 48

519.99

No. 50

410.01

No. 51

564.00

No. 55

642.00

Additional information: Error on cheque No. 12. The cheque was correctly written for $882but was shown as $828 on the bank statement.

(a) Based on the information above, prepare a proper/professional bank reconciliation

(b) Show any adjusting entries that would have to be shown on the books of XYZ Corporation.

Homework Answers

Answer #1

Bank Reconciliation Statement

Explained: Balance as per cash records( 52500-300)= 52200

Know the answer?
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
Similar Questions
The following information regarding cash for Alpha Company is provided for the month ending March 31,...
The following information regarding cash for Alpha Company is provided for the month ending March 31, 2016: Item Amount Ending Cash per Bank Statement Ending Cash per books $22,484 $14,794 Note collected by bank included interest of $106 $5,106 Bank Service Charges $35 Deposits in Transit $1,776 Outstanding Cheques $4,717 Customer Cheque returned NSF $322 Do the bank reconciliation in order to find the adjusted cash balance.
The following information relates to the month of August for XYZ Inc. Prepare the bank reconciliation....
The following information relates to the month of August for XYZ Inc. Prepare the bank reconciliation. Date Information 1 Aug 31 Bank statement balance $3,490 2 Aug 31 Bank statement reflects bank fees for the month $35 3 Aug 28 NSF cheque $100 with fee of $10. 4 Aug 27 Bank statement reflects paper statement fee $80 5 Aug 31 Bank statement reflects interest earned on balance $8 6 Aug 31 $1,000 note receivable collected by bank and deposited into...
As the bookkeeper of Rose Company of Drumheller, you received the bank statement from TD Canada...
As the bookkeeper of Rose Company of Drumheller, you received the bank statement from TD Canada Trust indicating a balance of $5,820.  The ending book balance wad $6,321.    The following information was available Deposits in transit were $2,875 Bank service charges were $24 Cheques outstanding:  No. 111, $478,  No. 115, $1,147 TD collected a note for Rose, $1,770 and charged you a $12 collection fee NSF cheque $525 was on the bank statement Rose company records cheque No. 107 as $900 for this months...
The following information is for SeaTrans Ltd. in April: Cash balance per bank, April 30, $14,606.73...
The following information is for SeaTrans Ltd. in April: Cash balance per bank, April 30, $14,606.73 Cash balance per book, April 30, $4,387.55 Outstanding cheques, $5,904.00 Deposit in transit, $2,201.40 Bank service charge and debit/credit card fees, $165.00 Electronic receipts from customers in payment of the amount $ 6,787.18, not previously received by the company Return from bank two NSF cheques including service charges, 465.60 Cheque # 459 was correctly written in the amount of $3,260.00 but was incorrectly written...
The following information is for SeaTrans Ltd. in April: 1. Cash balance per bank, April 30,...
The following information is for SeaTrans Ltd. in April: 1. Cash balance per bank, April 30, $14,606.73 2. Cash balance per book, April 30, $4,387.55 3. Outstanding cheques, $5,904.00 4. Deposit in transit, $2,201.40 5. Bank service charge and debit/credit card fees, $165.00 6. Electronic receipts from customers in payment of the amount $ 6,787.18, not previously received by the company 7. Return from bank two NSF cheques including service charges, 465.60 8. Cheque # 459 was correctly written in...
Alpha company does all of its banking with the Micro City Bank & Trust, Co. The...
Alpha company does all of its banking with the Micro City Bank & Trust, Co. The following banking information from its bank statement dated January 31, 2018 was provided to you from late on the close of business today. Your general manager ask you to prepare the bank reconciliation because it is believe that there may be some personnel concerns. One of great concern is that IT section noted that the general ledger balances were not being calculated. The day-to-day...
Please Finish the following using Canadian Accounting version of Bank reconciliation statement: Neopolitan Ltd Bank Reconciliation...
Please Finish the following using Canadian Accounting version of Bank reconciliation statement: Neopolitan Ltd Bank Reconciliation July 31 Cash Balance Per Bank $10670 Add: Deposits in transit 1968 8702 Less: Outstanding Cheques 2359 Reconciled Cash balancer per bank 6343 Cash Balance Per Books Add: EFT collections on Account 1276 Less: NSF cheque and fee Bank Service Charge 40 Reconciled Cash Balance Per books                                                                USE THE FOLLOWING INFORMATION to complete or correct the above bank reconociliations statement The following information is...
Belbin’s Grocery Store developed the following information in recording its bank statement for the month of...
Belbin’s Grocery Store developed the following information in recording its bank statement for the month of March, 2017.            Balance per books March 31               $ 1,905            Balance per bank statement March 31 $11,400 1.    Cheques written in March but still outstanding $8,000. 2.    Cheques written in February but still outstanding $2,800. 3.    Deposits of March 30 and 31 not yet recorded by bank $5,200. 4.    NSF cheque of customer returned by bank $700. 5.    Cheque No. 210 for $594...
On May 31, JB Games Ltd. received its bank statement from the East Coast Savings Bank...
On May 31, JB Games Ltd. received its bank statement from the East Coast Savings Bank showing that JB had a balance of $13,100. The company’s general ledger showed a cash balance of $7,925 at that date. A comparison of the bank statement and the accounting records revealed the following information: 1. A cheque from one of JB’s customers in the amount of $1,280 that had been deposited during the last week of May was returned with the bank statement...
On May 31, JB Games Ltd. received its bank statement from the East Coast Savings Bank...
On May 31, JB Games Ltd. received its bank statement from the East Coast Savings Bank showing that JB had a balance of $14,000. The company’s general ledger showed a cash balance of $9,740 at that date. A comparison of the bank statement and the accounting records revealed the following information: 1. A cheque from one of JB’s customers in the amount of $1,240 that had been deposited during the last week of May was returned with the bank statement...