Question

On October 31 Windsor Ltd. received its bank statement from Provincial Bank. It stated that Windsor...

On October 31 Windsor Ltd. received its bank statement from Provincial Bank. It stated that Windsor had a balance of $9,480 at October 31. The company’s general ledger showed a cash balance of $10,205 at that date. A comparison of the bank statement and the accounting records revealed the following information:

Bank service charges for the month were $50.
The company had written and mailed out cheques with a value of $1,380 that had not yet cleared the bank.
A cheque from one of Windsor’s customers in the amount of $840 that had been deposited during the last week of October was returned with the bank statement as NSF.
An electronic funds transfer payment (EFT) of $255 for monthly insurance expense was automatically deducted from Windsor’s bank account on October 22. Windsor’s bookkeeper had forgotten to record this transaction.
During the month, the company’s bookkeeper had recorded a cheque (#1872) paid for utilities as $575 rather than $755 (which was the amount written on the cheque and processed by the bank).
The cash receipts for October 31 amounted to $780 and had been deposited in the night drop slot at the bank on the evening of October 31. These were not reflected on the bank statement for October.

Prepare the bank reconciliation for Windsor at October 31.

Homework Answers

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
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...
On October 31, 2021, Oriole Company had a cash balance per books of $8,967. The bank...
On October 31, 2021, Oriole Company had a cash balance per books of $8,967. The bank statement on that date showed a balance of $10,165. A comparison of the statement with the Cash account revealed the following: 1. The statement included debit memos of $45 for the printing of additional company cheques and $40 for bank service charges. 2. Cash sales of $528 on October 12 were deposited in the bank. The journal entry to record the cash receipt and...
On October 31, 2021, Oriole Company had a cash balance per books of $8,967. The bank...
On October 31, 2021, Oriole Company had a cash balance per books of $8,967. The bank statement on that date showed a balance of $10,165. A comparison of the statement with the Cash account revealed the following: 1. The statement included debit memos of $45 for the printing of additional company cheques and $40 for bank service charges. 2. Cash sales of $528 on October 12 were deposited in the bank. The journal entry to record the cash receipt and...
Banana Company’s bank balance on the bank statement for October 31 of the current year is...
Banana Company’s bank balance on the bank statement for October 31 of the current year is $12,500. Banana’s accountant is preparing a cash reconciliation and has determined that three cheques issued by Banana to its suppliers for a total of $8,500 have not yet cleared the bank. Also, a deposit for $1,500 made by Banana on October 31 does not appear on the bank statement. Bank service charges of $150 appear on the bank statement but have not yet been...
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...
SNM Sdn Bhd received its bank statement for the month of March 2020 from BCB Bank....
SNM Sdn Bhd received its bank statement for the month of March 2020 from BCB Bank. The bank statement shows a balance of RM520,200 while SNM Sdn Bhd cash book balance shows a balance of RM512,750 on 31 March 2020. A comparison of the bank statement with the cash book reveals the following information. Cheque number 1444 for RM2,000 and cheque number 1501 for RM2,900 are still outstanding on the 31 March 2020. The bank statement indicates that BCB Bank...
Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance...
Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance of $15,180. Meanwhile its Cash book balance at March 31, 2019 stood $8,140. In addition, the Accountant of Broadway Enterprises was presented with the following information: 1. Bank charges for the month were shown as $250 as per bank statement. 2. Cheques issued to two creditors-Alloy Limited for $900 (cheque #253) and Ben Lion for $270 (cheque #258) were not presented to the bank...
Question Two c) BSD Ltd has prepared its October 2018 bank reconciliation for auditors to review....
Question Two c) BSD Ltd has prepared its October 2018 bank reconciliation for auditors to review. As at 31 October 2018 the ledger balance was GH¢ 2,450 (Credit) but the bank statement showed that the company has funds amounting to GH¢3,743. The following are useful information: The company arranged for the bank to transfer the dollar equivalent of GH¢ 500,000 to a supplier in the United States. Charges on the transfer of 0.5% have not been recorded in the books...