Question

In: Accounting

Nose Mask Ltd (Nose Mask) is preparing his bank reconciliation at 31st May 2019. His bank...

Nose Mask Ltd (Nose Mask) is preparing his bank reconciliation at 31st May 2019. His bank statement balance failed to agree with the cash book balance. His bank statement shows a balance of GH₵684 cash at the bank.
After investigation the following were revealed;
a. The following cheques have not yet been presented at the bank. These are:
Cheque No. GH₵ 956784........1,875
956892........978
958452.........1,407
958541.........366
958668..........261
Total Amount = 4,887
b. Cheque number 958602 was incorrectly recorded in Nose Mask's cash book as GH₵1,140. The cheque was correctly debited on the bank statement on 2nd May as GH₵1,005.
c. Bank charges of GH₵1,149 were debited by the bank on 4th May.
d. A customer's cheque for GH₵960 was returned by Nose Mask's bank in May as the customer had insufficient funds in his account. Nose Mask has not recorded the return
of the cheque in his records.
e. The bank has incorrectly credited Nose Mask's account with interest of GH₵660. This
is interest on a deposit account held by Nose Mask personally. The bank had not
corrected the error by 31st May.
f. A lodgement of GH₵2,550 entered in Nose Mask's cash book on 31st May was credited
on the bank statement on 3rd June.
g. Cheque number 956784 was lost in the post and was cancelled. Nose Mask has not recorded the cancellation of the cheque.
Required:
(i) Show Nose Mask's general ledger bank account including the necessary correcting entries.

(ii) Prepare a reconciliation of the bank statement balance to the corrected general ledger balance.
(iii) Indicate how the bank balance will be reported in Nose Mask's final account

Solutions

Expert Solution

Bank statement
Debit Credit Balance
Opening Balance 2178
958602 1005 1173
Bank charges 1149 24
Interest credited 660 684
Closing balance 684

Working for bank statement above is to derive at the opening bank book balance. Assuming that there are no old cheques or deposits which are unreconciled.

Nose Mask Ltd
(i) Bank Book Value GHC
Date Particulars Check no. Debit Credit
5/1/2019 Opening Balance 2178 Balancing figure
956784 1875 Contra
956892 978
958452 1407
958541 366
958602 1140 Contra
958668 261
Customer cheque 960 Contra
5/31/2019 Deposit 2550
Balance C/d 339
6027 6027
Balance b/d 339
Adjustments
Reversal of entry 958602 1140 Contra
Correct cheque amount 958602 1005
Cheque return from customer 960 Contra
Check lost in transit 956784 1875 Contra
5/4/2019 Bank charges accounted 1149
Balance b/d 438
3453 3453
(ii) Bank reconciliation as on 31st May 2019
Balance as per bank book -438 Credit balance
Add: Cheques issued not presented
956892 978
958452 1407
958541 366
958668 261
3012
Less: Deposits not credited by bank
5/31/2019 Deposit 2550
Balance as per bank statement 24
Balance as per bank statement 684
Less: Amount wrongly credited 660 To be corrected by bank
Correct balance as per statement 24
(iii) Bank balance will be shown as liabilities in Balance sheet

Related Solutions

Preparing a bank reconciliation
Question Preparing a bank reconciliationThe Cash account of Guard Dog Security Systems reported a balance of $2,540 at December 31, 2018. There were outstanding checks totaling $400 and a December 31 deposit in transit of $100. The bank statement, which came from Park Cities Bank, listed the December 31 balance of $3,340. Included in the bank balance was a collection of $510 on account from Brendan Ballou, a Guard Dog customer who pays the bank directly. The bank statement also...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the month of June. It reconciles the bank balance and the book balance to the correct balance. For each of the following items, indicate whether the item is an addition to the bank balance, an addition to the book balance, a deduction from the bank balance, a deduction from the book balance, or would not appear on the June reconciliation. Also, choose Yes or No...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31: The balance on the May 31 bank statement is $8,432.11. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31. 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. 123 $23.40 No. 127 145.00...
what is a bank reconciliation? what are the steps in preparing a bank reconciliation? what purpose...
what is a bank reconciliation? what are the steps in preparing a bank reconciliation? what purpose does it serve?
Preparing Bank reconciliation & any journal entries; The following information is for Neopolitan Ltd in July...
Preparing Bank reconciliation & any journal entries; The following information is for Neopolitan Ltd in July 1.Cash balance per bank, July 31, $10,670 2. Cash balance per general ledger cash account, July 31, $8,953 3. Bank Service Charge, $40 4. Deposits in Transit, $1,968 5. Electronic receipts from customers in payment of their accounts, $1,276, not previously recorded by the company 6. Outstanding cheques, $2,359 7. Cheque #373 was correctly written in the amount of $890 but was incorrectly recorded...
During the bank reconciliation process at A. Fontes Consultancy on May 2, 2019, the following two...
During the bank reconciliation process at A. Fontes Consultancy on May 2, 2019, the following two errors were discovered in the firm’s records. The checkbook and the general journal indicated that Check 2206 dated April 17 was issued for $695 to make a cash purchase of supplies. However, examination of the canceled check and the listing on the bank statement showed that the actual amount of the check was $14. The checkbook and the general journal indicated that Check 2247...
The bank portion of the bank reconciliation for Thomas Company at November 30, 2019, is: THOMAS...
The bank portion of the bank reconciliation for Thomas Company at November 30, 2019, is: THOMAS COMPANY Bank Reconciliation November 30, 2019 Cash balance per bank $14,367.90 Add: Deposits in transit 2,530.20 16,898.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 1,100.10 3471 824.50 3472 1,446.80 3474 1,050.00 6,681.80 Adjusted cash balance per bank $10,216.30 The adjusted cash balance per bank agreed with the cash balance per books at November 30. At December 31, the cash balance...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash balance of $5,000.17. •The cash ledger account on that date shows a balance of $4,262.83. •Four outstanding checks totaled $717.75. •A $410.90 deposit made after banking hours on July 31 does not appear in the bank statement. •On July 30, the bank returned J.B. Ball’s NSF check for $50.25, received as payment of an account receivable. •The bank statement showed $24.74 interest earned on...
The following information relates to ABC Ltd., for the year ended 31st December, 2019.
The following information relates to ABC Ltd., for the year ended 31st December, 2019.             Sales……………………………………………………………….. Rs.2,000,000.             EBID ………………………………………………………………. 40% of sales.             Ordinary Shares capital of par value Rs.10/each……………… Rs.800,000.             8% Preference shares Capital of par value Rs.100/ each………. Rs.500,000.             10% Bonds payable of par value Rs.1000/each…………………. Rs.400,000.             Reserves and surplus………………………………………………Rs.250,000.             Current liabilities…………………………………………………..Rs.250,000. Tax rate is 30%.             Market price of share is Rs.20 each.             Dividend payout ratio is 60%. Required; Compute and comments on each of the following ratios a)Earning per...
Briefly explain the importance of preparing Bank Reconciliation Statement and analyze the adjustments and the treatment...
Briefly explain the importance of preparing Bank Reconciliation Statement and analyze the adjustments and the treatment of the adjustments that needs to be considered under bank statement and cash book statement. You can access online resources to get the required information while maintaining APA referencing guidance [ 5 marks] [ minimum 500 words].
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT