Bank reconciliation

FA – L1 – Q66 – Bank reconciliations

Prepare an adjusted cash book for Mama Clara as at 31st December 20X9 based on bank statement and cash book discrepancies.

Question

The following information was extracted from the records of Mama Clara, a sole trader as at 31st December, 20X9.
Balance as per bank statement as at 31st December, 20X9 was GH¢10,000 credit.
Cash book balance was GH¢40,000 credit in the bank account column.
The following had been reflected in the bank statement but not in the cash book.
(i) Bank loan interest GH¢2,000
(ii) Bank charges GH¢6,000
(iii) Dividends from Investment GH¢10,000
(iv) Interest from treasury bill GH¢4,000
In addition, a cheque of GH¢20,000 issued to Madam Grace was dishonoured because of insufficient funds. A cheque of GH¢25,000 from Samuel has not been credited. A cheque of GH¢49,000 issued to Simon remained unpresented.

You are required to prepare:
(i) An adjusted cash book.

(ii) Bank reconciliation statement as at 31st December, 20X9.

Answer

Find Related Questions by Tags, levels, etc.

Tags: Adjustments, Bank reconciliation, Cash book, Financial accounting, Uncredited deposits, Unpresented cheques
Level: Level 1

Topic: Bank reconciliations

FA – L1 – Q65 – Bank Reconciliations

Demonstrate adjustments needed to KW Ltd's cash book for July 20X9 due to errors and unrecorded transactions.

Question

The following is a summary from the cash book of KW Ltd for July 20X9:

Opening balance	1,530
Receipts	23,104
Payments	23,005
Closing balance	1,629

On investigation it was discovered that:
(i) Bank charges of GH₵15 shown on the bank statement have not been entered in the cash book.
(ii) A cheque drawn for GH₵110 to pay a supplier has been entered in the cash book as a receipt.
(iii) A cheque from a customer for GH₵120, which was banked (and included above in receipts), has been returned by the bank, but this has not been adjusted in the company’s books.
(iv) An error of transposition which occurred in the opening balance of the cash book should have been recorded as GH₵1,350.
(v) Cheques totaling GH₵264 have been sent by post to suppliers but were not presented to the company’s bank until August 20X9.
(vi) The last page of a bank account paying-in book shows a deposit of GH₵1,040 which was not credited to the account by the bank until 1st August 20X9.
(vii) The company’s bank statement at 31st July 20X9 shows a balance of GH₵318.

Required:
(a) Demonstrate any adjustments needed to the company’s accounting records.

(b) Prepare a Bank Reconciliation Statement as at 31st July 20X9.

Answer

Find Related Questions by Tags, levels, etc.

Tags: Adjustments, Bank reconciliation, Bank statement, Cash book, Cheques, Deposits, Error Correction, Financial accounting
Level: Level 1

Topic: Bank reconciliations

FA – L1 – Q59 – Bank reconciliations

Prepare a bank reconciliation statement for Kofi & Associates as of 31 December 20X9, addressing discrepancies between cash book and bank statement.

Question

Kofi & Associates
Mr. Kofi is a sole trader and carries on business under the name “Kofi & Associates”. The balance on his cash book at 31 December 20X9 did not agree with the balance as per the bank statement which shows a credit balance of GH¢367,500.
An examination of the cash book and bank statement disclosed the following:
(i) A deposit of GH¢49,200 made on 29 December 20X9 had been credited by the bank on 1 January 20Y0.
(ii) Bank charges of GH¢1,700 have not been entered in the cash book.
(iii) A debit of GH¢4,200 appeared on the bank statement for an unpaid cheque which has been returned marked “out of date”. The cheque was re-dated by his customer and paid into the bank again on 3 January 20Y0.
(iv) A standing order for payment of an annual subscription amounting to GH¢1,000 has not been entered in the cash book.
(v) On 26 December 20X9, Mr. Kofi had given the cashier a cheque for GH¢10,000 tos to pay into his personal account at the bank. The cashier deposited it into the business account by mistake.
(vi) On 27 December 20X9, a customer had made an online transfer of GH¢49,900 in payment against goods supplied. The advice was received and recorded in the cash book on 2 January 20Y0.
(vii) On 30 September 20X9, Mr. Kofi entered into a hire purchase agreement and issued a standing order to the bank to pay a sum of GH¢2,600 on the 10th day of each month, commencing from October 20X9. No entries have been made in the cash book for these payments.
(viii) A cheque for GH¢36,400 received from Mr. Kwame had been entered twice in the cash book.
(ix) Cheques issued amounting to GH¢467,200 had not been presented to the bank for payment until after 31 December 20X9.
(x) Dividend collected by the bank amounting to GH¢12,000 has not been recorded in the cash book.
(xi) A cheque of GH¢243,000 received from Mr. Asante was deposited in the bank but entered in the cash book as GH¢234,000.

Required
(a) Prepare a bank reconciliation statement as on 31 December 20X9.

(b) Prepare necessary journal entries in the books of Kofi & Associates and determine the correct cash balance that should be reported in the statement of financial position. Also specify the situations in which no adjustment/entry is required.

Answer

Find Related Questions by Tags, levels, etc.

Tags: Bank reconciliation, Cash book, Financial Statements, Journal entries, Overdraft
Level: Level 1

Topic: Bank reconciliations

FA – L1 – Q58 – Bank reconciliations

Prepare a bank reconciliation statement for Accra & Sons as at 31 Dec 20X9, identifying the cash at bank balance.

Question

While reconciling the bank statement with the cash/bank book of Accra & Sons for the year ended December 31, 20X9, you noted the following:

(i) Balance as per bank statement at December 31, 20X9, overdrawn: GH¢806,436
(ii) Cheques drawn but not presented till December 31, 20X9: GH¢377,784
(iii) Mark-up on overdraft charged by the bank on January 2, 20Y0 was recorded in the cash/bank book on December 31, 20X9: GH¢118,686
(iv) Collections made on December 30 and 31, 20X9 were not lodged with the bank till January 3, 20Y0: GH¢250,600
(v) A bill which was due on December 29, 20X9 was sent to the bank for collection on December 28, 20X9, and entered in the cash/bank book. However, the proceeds were credited by the bank on January 1, 20Y0: GH¢196,500
(vi) Subscription for a magazine was paid by the bank, as per the auto-debit instructions, on December 1, 20X9. This transaction has not been recorded in the cash/bank book so far: GH¢3,144
(vii) A time-barred cheque was replaced with a new cheque on December 30, 20X9 and entered in the cash/bank book without the previous cheque being cancelled / reversed. Both the cheques are included in (ii) above: GH¢5,000
(viii) A cheque received on December 21 was erroneously recorded on the credit side of the cash/bank book: GH¢7,500
(ix) A cheque issued to a supplier was time-barred as of January 2, 20Y0: GH¢13,200
(x) A cheque issued by the company has been entered in the credit column of the bank statement: GH¢13,200

Required:
Prepare a bank reconciliation statement as at December 31, 20X9 and identify the amount to be carried to the statement of financial position as “cash at bank”.

Answer

Find Related Questions by Tags, levels, etc.

Tags: Bank reconciliation, Cash book, Cheques, Errors, Financial Statements, Overdraft
Level: Level 1

Topic: Bank reconciliations

FA – L1 – Q57 – Bank reconciliations

Prepare a bank reconciliation for Newman & Co as at 31 August 20X9, correcting errors in the cash book and bank statement.

Question

Following information has been collected from the books of Newman & Co, as at August 31, 20X9:
(a) Balance as per bank book
(b) Cash balance on bank statement
(c) Cheques outstanding on August 31 were as follows:

Cheque No.	GH¢
670	13,353
679	14,152
690	17,108
996	3,535
997	14,430
999	23,629

(d) The company made the following payments into the bank in the last week in August but these had not yet appeared on the bank statement.

GH¢
83,250
144,641

(e) The following matters have been discovered.
(i) Receipt of GH¢15,000 was erroneously recorded on the credit side of the bank book.
(ii) A payment of GH¢12,480 was erroneously recorded on the debit side of the bank book.
(iii) The credit side of the bank book has been overcasted by GH¢4,800.
(iv) The bank statement showed an amount collected by the bank but not shown in the cash book in the amount of GH¢87,188.

Required
Prepare the bank reconciliation as at 31 August.

Answer

Find Related Questions by Tags, levels, etc.

Tags: Adjustments, Bank reconciliation, Bank statement, Cash book, Cheques, Errors, Financial accounting, Overdraft
Level: Level 1

Topic: Bank reconciliations

FA – L1 – Q56 – Bank reconciliations

Reconcile cash book with bank statement for Sandwell Ltd, adjust ledger for unrecorded items.

Question

A company, Sandwell Ltd, receives a bank statement. The balance on its cash book (= bank account in the main ledger) is a debit balance of GH₵1,600,000. In reconciling the cash book balance with the bank statement balance, the accountant discovers that the bank statement does not show cheques received from customers for GH₵8,200,000 and banked, or cheque payments to suppliers for GH₵4,700,000. The bank statement also shows bank charges of GH₵150,000, a direct debit payment of GH₵400,000, and a dishonoured cheque for GH₵300,000. None of these three items have yet been recorded in the ledger.

Required:

What is the balance on the bank statement?
What entries should be made in the company’s ledger accounts when the cash book and the bank statement balances have been reconciled?

Answer

Find Related Questions by Tags, levels, etc.

Tags: Adjustments, Bank charges, Bank reconciliation, Bank statement, Cash book, Direct Debit, Dishonoured Cheque, Errors, Financial accounting, Ledger Entries
Level: Level 1

Topic: Bank reconciliations

FA – L1 – Q55 – Bank reconciliations

Calculate the cash book balance given bank statement details, unrecorded transactions, and ledger discrepancies.

Question

A company, Connelly Enterprises, receives a bank statement showing a credit balance of GH₵7,400,000. On investigation, its accountant discovers that the bank statement does not show cheques received from customers for GH₵16,200,000 and banked, or cheque payments to suppliers for GH₵18,500,000. The bank statement also shows bank charges of GH₵250,000, which have not yet been recorded in the ledger.

Required
What is the current balance on the cash book? (This is the balance on the bank account in the main ledger.)

Answer

Find Related Questions by Tags, levels, etc.

Tags: Bank charges, Bank reconciliation, Bank statement, Cash book, Ledger adjustments, Unpresented cheques
Level: Level 1

Topic: Bank reconciliations

Tag (SQ): Bank reconciliation

Filter by Professional Bodies

Filter by Subject

Filter by Topics

Filter by Levels

FA – L1 – Q66 – Bank reconciliations

Prepare an adjusted cash book for Mama Clara as at 31st December 20X9 based on bank statement and cash book discrepancies.

FA – L1 – Q65 – Bank Reconciliations

Demonstrate adjustments needed to KW Ltd's cash book for July 20X9 due to errors and unrecorded transactions.

FA – L1 – Q59 – Bank reconciliations

Prepare a bank reconciliation statement for Kofi & Associates as of 31 December 20X9, addressing discrepancies between cash book and bank statement.

FA – L1 – Q58 – Bank reconciliations

Prepare a bank reconciliation statement for Accra & Sons as at 31 Dec 20X9, identifying the cash at bank balance.

FA – L1 – Q57 – Bank reconciliations

Prepare a bank reconciliation for Newman & Co as at 31 August 20X9, correcting errors in the cash book and bank statement.

FA – L1 – Q56 – Bank reconciliations

Reconcile cash book with bank statement for Sandwell Ltd, adjust ledger for unrecorded items.

FA – L1 – Q55 – Bank reconciliations

Calculate the cash book balance given bank statement details, unrecorded transactions, and ledger discrepancies.

Our offerings

Contact Info

Customer

Get In Touch

Tag (SQ): Bank reconciliation

Filter by Professional Bodies

Filter by Subject

Filter by Topics

Filter by Levels

FA – L1 – Q66 – Bank reconciliations

Prepare an adjusted cash book for Mama Clara as at 31st December 20X9 based on bank statement and cash book discrepancies.

You're reporting an error for "FA – L1 – Q66 – Bank reconciliations"

FA – L1 – Q65 – Bank Reconciliations

Demonstrate adjustments needed to KW Ltd's cash book for July 20X9 due to errors and unrecorded transactions.

You're reporting an error for "FA – L1 – Q65 – Bank Reconciliations"

FA – L1 – Q59 – Bank reconciliations

Prepare a bank reconciliation statement for Kofi & Associates as of 31 December 20X9, addressing discrepancies between cash book and bank statement.

You're reporting an error for "FA – L1 – Q59 – Bank reconciliations"

FA – L1 – Q58 – Bank reconciliations

Prepare a bank reconciliation statement for Accra & Sons as at 31 Dec 20X9, identifying the cash at bank balance.

You're reporting an error for "FA – L1 – Q58 – Bank reconciliations"

FA – L1 – Q57 – Bank reconciliations

Prepare a bank reconciliation for Newman & Co as at 31 August 20X9, correcting errors in the cash book and bank statement.

You're reporting an error for "FA – L1 – Q57 – Bank reconciliations"

FA – L1 – Q56 – Bank reconciliations

Reconcile cash book with bank statement for Sandwell Ltd, adjust ledger for unrecorded items.

You're reporting an error for "FA – L1 – Q56 – Bank reconciliations"

FA – L1 – Q55 – Bank reconciliations

Calculate the cash book balance given bank statement details, unrecorded transactions, and ledger discrepancies.

You're reporting an error for "FA – L1 – Q55 – Bank reconciliations"

Our offerings

Contact Info

Customer

Get In Touch

admin