Question

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 for Neopolitan Ltd in July

Cash balance per bank, July 31, $10,670

Cash balance per general ledger cash account, July 31, $8,953

Bank Service Charge, $40

Deposits in Transit, $1,968

Electronic receipts from customers in payment of their accounts, $1,276, not previously recorded by the company

Outstanding cheques, $2,359

Cheque #373 was correctly written in the amount of $890 but was incorrectly recorded by the company’s bookkeeper at $980.

Homework Answers

Answer #1
Neopolitan Ltd
Bank Reconciliation
31-Jul-18
Cash balance according to the bank statement $10,670
Add deposit in transit, not recorded by bank $1,968
$12,638
Deduct outstanding checks $2,359
Adjusted balance $10,279
Cash balance according to the company's records $8,953
Add receipts from customers not recorded $1,276
Add error in recording cheque $90 ($980-$890)
$10,319
Deduct bank service charges $40
Adjusted balance $10,279
Yes, the bank reconciliation must always balance (reconcile) to an adjusted balance.
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 pertains to Wildhorse Corporation. 1. Balance per bank, July 31, $8,207. 2. July...
The following information pertains to Wildhorse Corporation. 1. Balance per bank, July 31, $8,207. 2. July bank service charge not recorded by Wildhorse, $23. 3. Balance per books, July 31, $8,632. 4. Deposits in transit, July 31, $2,762. 5. Electronic collection on account (EFT) from a customer, $1,920 not yet recorded by Wildhorse. 6. Outstanding cheques, July 31, $809. 7. Returned cheque from the deposit of a collection on account, $328, due to nonsufficient funds. Related bank service charge, $41....
Emerge Solutions Company deposits all receipts and makes all payments by cheque. The following information is...
Emerge Solutions Company deposits all receipts and makes all payments by cheque. The following information is available from the cash records: MARCH 31 BANK RECONCILIATION Balance per bank    $26,746 Add: Deposits in transit    2,100 Deduct: Outstanding cheques (3,800) Balance per books $25,046 Month of April Results Per Bank Per Books Balance April 30    $27,995 $27,355 April deposits 11,784 13,889 April cheques 11,100 10,080 April note collected (not included in April deposits) 3,000    0 April bank service...
Exercise 7-15 On August 31, 2021, Sheridan Company had a cash balance per its books of...
Exercise 7-15 On August 31, 2021, Sheridan Company had a cash balance per its books of $26,660. The bank statement on that date showed a balance of $17,760. A comparison of the bank statement with the Cash account revealed the following. 1. The August 31 deposit of $17,050 was not included on the August bank statement. 2. The bank statement shows that Sheridan received EFT deposits from customers on account totalling $2,420 in August. Sheridan has not recorded any of...
Exercise 7-9 Don Wyatt is unable to reconcile the bank balance at January 31. Don’s reconciliation...
Exercise 7-9 Don Wyatt is unable to reconcile the bank balance at January 31. Don’s reconciliation is as follows. Cash balance per bank $3,760.20 Add: NSF check 590.00 Less: Bank service charge 30.00 Adjusted balance per bank $4,320.20 Cash balance per books $4,075.20 Less: Deposits in transit 630.00 Add: Outstanding checks 935.00 Adjusted balance per books $4,380.20 Prepare a correct bank reconciliation. (List items that increase cash balance first. Reconcile cash balance per bank first. Round answers to 2 decimal...
Question 6.2                                         &n
Question 6.2                                                                           (Total: 15 marks; 5 marks per part) Emerge Solutions Company deposits all receipts and makes all payments by cheque. The following information is available from the cash records: MARCH 31 BANK RECONCILIATION Balance per bank                                                                                $26,746 Add: Deposits in transit                                                                          2,100 Deduct: Outstanding cheques                                                             (3,800) Balance per books                                                                               $25,046 Month of April Results Per Bank Per Books Balance April 30                                                                                  $27,995 $27,355 April deposits                                                                                         11,784 13,889 April cheques                                                                                         11,100 10,080 April note collected (not included in April deposits)...
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 $28,850. Cash balance according to the bank statement at July 31, $30,060. Checks outstanding, $5,860. Deposit in transit, not recorded by bank, $4,700. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $40. a. Prepare a...
Sunland Wyatt is unable to reconcile the bank balance at January 31. Sunland’s reconciliation is as...
Sunland Wyatt is unable to reconcile the bank balance at January 31. Sunland’s reconciliation is as follows. Cash balance per bank $4,340.20 Add: NSF check 300 Less: Bank service charge 31 Adjusted balance per bank $4,609.20 Cash balance per books $4,655.20 Less: Deposits in transit 920 Add: Outstanding checks 936 Adjusted balance per books $4,671.20 (a) Prepare a correct bank reconciliation. (List items that increase cash balance first. Round answers to 2 decimal places, e.g. 52.75.) Sunland Wyatt Bank Reconciliation...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $7,620 Adjustments:    Outstanding checks $3,660    Error by Chesner Co. in recording Check      No. 1056 as $830 instead of $380 450    Note for $12,000 collected by bank, including interest 12,480    Deposit in transit on July 31 (7,760)    Bank service charges (30)       Total adjustments 8,800 Cash balance according to bank statement $16,420 a. From the data...
Skysong Lansbury Company deposits all receipts and makes all payments by check. The following information is...
Skysong Lansbury Company deposits all receipts and makes all payments by check. The following information is available from the cash records. June 30 Bank Reconciliation Balance per bank $ 32,200 Add: Deposits in transit 7,084 Deduct: Outstanding checks ( 9,200 ) Balance per books $ 30,084 Month of July Results Per Bank Per Books Balance July 31 $ 39,790 $ 42,550 July deposits 23,000 26,726 July checks 18,400 14,260 July note collected (not included in July deposits) 4,600 July bank...
David is preparing the bank reconciliation for the month of May for ABC Ltd. His reconciliation...
David is preparing the bank reconciliation for the month of May for ABC Ltd. His reconciliation is as follows and he is unable to reconcile the bank balance at the end of May. Cash balance per bank $4820 Add: NSF check $400 Less: Bank service charge $20 Adjusted balance per Bank $5,200 Cash balance per book $4840 Less: deposit in transit $800 Add: outstanding check $1200 Adjusted Balance per book $4400 Required a) Prepare a correct Bank reconciliation and journalise...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT