QUESTION ONE

The cash transaction and cash balances of Paper line for July were as follows:

  1. Cash book balance at June 30 was Shs. 730,165
  2. Total cash receipts for July was Shs. 4,521,618
  3. Total cash payments for July was Shs. 3,575,088
  4. The cash received on July 31 amounted to Shs. 401,715. It was nailed to the bank too late to be included in the July bank statement
  5. The July bank statement showed a closing balance of Shs. 1,892,812
  6. Also concluded with the July bank statement was a debit memorandum from the bank for Shs. 765 representing service charges for July.
  7. A credit memorandum enclosed with the bank statement indicated that a collection of Shs. 454,500 from Mzumbe Pharmacy was collected and credited to the account of Paper line.
  8. Comparison of the paid cheque with the entries in the cash book revealed that cheque No. 821 for Shs. 83,502 issued July 15 in payment for office equipment had been erroneously entered in the cash book as Shs. 85,302.
  9. Examination of the paid cheque also revealed that three cheques, all issued in July had not been paid by the bank No 811 for Shs. 86,112, No 814 for Shs. 64,080, and No 823 for Shs. 30,105
  10. Included with the bank statement was a Shs. 18,000 dishonoured cheque drawn by Tapeli, a customer of Paper Line.

Required:

  1. Adjust the cash book.
  2. Bank reconciliation as at July 31.

  • Updated: 18 Jul 20
  • |
  • Attempts: 8
  • |
  • Correct: 3

Need help?

Adjusted CashBook Balance:
QUESTION TWO

The following are summaries of balances presented by KINGS Co. ltd for month of November 2011:
Balance as per bank statements (CR) Tshs. 20,000,000/=
Balance as per cash book (DR) Tshs. 22,000,000/=

The financial manager of the company amazed with the big differences between cash and bank balances, wrote a notice to accountant responsible with bank matters for more explanation. Upon detailed investigations the following were revealed:

  1. There were bank charges amounted to Tshs. 200,000, not recognized in the cash book
  2. Tshs. 200,000 Debtors receipts through cheque was correctly recorded by the bank but recognized as payment in the cash book.
  3. The following payment cheques were issued to suppliers, BC 2 amounted to Tshs. 600,000, BC 5 amounted to Tshs. 450,000, BC 11 amounted to Tshs. 900,000 and BC 23 Amounted to 700,000. Only cheque number BC 2 and BC 5 was presented to the bank for payments.
  4. The company receives a credit lodgment from trading partner amounting to Tshs. 600,000. The opposite company notifies KINGS Company on 4th December 2011.
  5. There was a standing order for electricity and water bills paid by bank but not recorded in cash book, the total of Tshs. 300,000 was paid.
  6. The company receive a dividend of Tshs. 500,000 through bank but not recorded in the cash book
  7. The company receives a cheque amounting to Tshs. 3,000,000 submitted to the bank on 30th November 2011, but the bank deposit the cheque on 2nd December 2011.
  8. Tshs. 600,000 payment to creditors was completely not recorded in the cash book.
  9. Cheque payment of Tshs. 500,000 is correctly recorded by bank but was posted on wrong side of the cash book

Required:

  1. Show the adjustments required in the cash book.
  2. Prepare a bank reconciliation statement as at 30th November 2011.

  • Updated: 18 Jul 20
  • |
  • Attempts: 2
  • |
  • Correct: 0

Need help?

Adjusted CashBook Balance:
QUESTION THREE

The Following is the summary of cash book (bank column only) of BF Company for the month of December, 2016

DR. CASH BOOK (BANK COLUMN) CR.
Balance b/d 28,140 payments 310,400
Receipts 301,460 Balance c/d 19,200
329,600 329,600

On examining the bank statement, you discover the following:

  1. The opening balance should have been carried down as shs. 29,400/= instead of shs. 28,140/=
  2. The debit balance as per bank pass book on December 31st, 2016 is shs. 2,480/=
  3. Bank charges shs. 700/= is not shown in the cash book.
  4. A cheque drawn by BF Company for shs 940/= has been entered as a receipt in the cash book.
  5. Cheques issued but not presented for payment amount to shs. 12,280/=
  6. The last bank pay-in-slip amounting to shs. 30,840/= is yet to be credited by the bank
  7. Bank has wrongly debited the BF Company’s account by shs. 1,440/=
  8. Cheque received from a customer mr. pesambili for shs 360/= was deposited but was later dishonoured by bank, while receipt and deposit were recorded in the cash book, dishounouring of the cheque was not recorded.

Required:

  1. Show the Adjusted Cash book
  2. Reconcile the balances given by the cash book (after adjustment) and bank pass book

  • Updated: 18 Jul 20
  • |
  • Attempts: 0
  • |
  • Correct: 0

Need help?

Adjusted CashBook Balance:
QUESTION FOUR

The following is a summary from the cash book of lake development corporation for March, 2105

DR. CASH BOOK (BANK COLUMN) CR.
Balance b/d 5,820 payments 50,490
Receipts 46,240 Balance c/d 1,570
52,060 52,060

The bank statement for the same month shows a balance of shs 955/=. On investigation you discover that:-

  1. Cheque issued amounting to 2,680/= are still outstanding
  2. A cheque for 785/= was debited by the bank in error to the company’s account.
  3. A cheque for 340/= has been returned by the bank marked insufficient funds, but it has not beeen written back in the cash book.
  4. A cheque drawn for 190/= has been entered in error as a receipt in the cash book.
  5. A cheque of 1, 250/= has not yet been credited to the account by the bank.
  6. The opening balance in the cash book should have been 5,280/= instead of 5,820/= brought forward

Required:

Prepare a bank reconciliation statement after the necessary adjustment have been made in the cash book


  • Updated: 18 Jul 20
  • |
  • Attempts: 0
  • |
  • Correct: 0

Need help?

Adjusted CashBook Balance:
QUESTION FIVE

The cash book of ABC Ltd. Shows bank balance of shs. 24,115,000/= as on 31st December, 2014. This does not tally with the shs. 26,345,000/= balance of the bank pass book. On scrutiny, the following discrepancies were noted:

  1. Pass book shows debits for bank charges as given below:
    30.11.2014 – 110,000/=
    10.12.2014 - 32,000/=
    22.12.2014 - 18,000/=
    The relevant debit advises have not reached the office of ABC Ltd.
  2. Receipt side of the cash book was under cast by shs. 900,000/= on 20th December, 2014
  3. Out of cheques amounting to shs. 76,910,000/= issued in December, 2014 cheques for shs. 72,300,000/= were encashed in December, 2014 and shs. 4,100,000/= in January, 2015 and balance in February, 2015.
  4. A cheque for shs. 1,340,000/= was wrongly debited to the account by the bank
  5. Dividend collected by the bankers amounted to shs. 2,100,000/= but this was not entered in the cash book
  6. A cheque for shs. 3,200,000/= received from Mr. KP was deposited in the bank on 10th December, 2014. the bank returned the cheque as disnonoured on 28the December, 2014, but no entry was passed in the cash book.
  7. A cheque drawn for shs. 340,000/= was wrongly entered in the cash book on the receipt side.

Required:

  1. Find the correct balance of the cash book
  2. prepare a bank reconciliation statement as of 31st December, 2014

  • Updated: 18 Jul 20
  • |
  • Attempts: 0
  • |
  • Correct: 0

Need help?

Adjusted CashBook Balance:
QUESTION SIX

On 31 December 2018 the bank column of Macha cash book showed a debit balance of shs 1,500,000.
The monthly bank statement written up to 31 December 2018 showed a credit balance of shs 2,950,000.
On checking the cash book with the bank statement it was discovered that the following transactions had not been entered in the cash book:

  1. Dividends of shs 240,000 had been paid directly to the bank.
  2. A credit transfer – Customs and VAT refund of shs 260,000 – had been collected by the bank.
  3. Bank charges shs 30,000.
  4. A direct debit of shs 70,000 for the RAC subscription had been paid by the bank.
  5. A standing order of shs 200,000 for Macha loan repayment had been paid by the bank.
  6. Macha deposit account balance of shs1,400,000 was transferred into his bank current account.
A further check revealed the following items:
  1. Two cheques drawn in favour of Massawe shs 250,000 and Kafanabo shs 290,000 had been entered in the cash book but had not been presented for payment.
  2. Cash and cheques amounting to shs 690,000 had been paid into the bank on 31 December 2018 but were not credited by the bank until 2 January 2019.

Required:

  1. Starting with the debit balance of shs1,500,000, bring the cash book (bank columns) up to date and then balance the bank account.
  2. Prepare a bank reconciliation statement as at 31 December 2018.

  • Updated: 18 Jul 20
  • |
  • Attempts: 0
  • |
  • Correct: 0

Need help?

Adjusted CashBook Balance:
QUESTION SEVEN

In the draft accounts for the year ended 31 October 2019 of Marijani, garage proprietor, the balance at bank according to the cash book was shs 894,680 in hand. Subsequently the following discoveries were made:

  1. Cheque number 176276 dated 3 September 2019 for shs 310,840 in favour of Kurwa Limited has been correctly recorded in the bank statement, but included in the cash book payments as shs 301,840.
  2. Bank commission charged of shs 169,560 and bank interest charged of shs 109,100 have been entered in the bank statement on 23 October 2019, but not included in the cash book.
  3. The recently received bank statement shows that a cheque for shs 29,310 received from Makaranga and credited in the bank statements on 9 October 2019 has now been dishonoured and debited in the bank statement on 26 October 2019. The only entry in the cash book for this cheque records its receipt on 8 October 2019.
  4. Cheque number 177145 for shs 15,100 has been recorded twice as a credit in the cash book.
  5. Amounts received in the last few days of October 2019 totalling shs1,895,600 and recorded in the cash book have not been included in the bank statements until 2 November 2019.
  6. Cheques paid according to the cash book during October 2019 and totaling shs 395,800 were not presented for payment to the bank until November 2019.
  7. Traders’ credits totalling shs 210,100 have been credited in the bank statement on 26 October 2019, but not yet recorded in the cash book.
  8. A standing order payment of shs 15,000 on 17 October 2019 to Makongo transporters has been recorded in the bank statement but is not mentioned in the cash book.

Required:

  1. Prepare Adjusted CashBook
  2. Prepare Bank Reconciliation Statement as at that date.

  • Updated: 18 Jul 20
  • |
  • Attempts: 0
  • |
  • Correct: 0

Need help?

Adjusted CashBook Balance:
Unique visitors
Page views