Cash BookCr2019$2019$1-JunBalance b/d4,2305-JunR. Red5407-JunP. Ryan18612-JunJ. Rebus1,55716-JunG. Grey22516-JunY. Yale12328-JunJ. Jim67229-JunBlister Disco6630-JunT. Fling1,74630-JunBalance c/d4,7737,0597,059 Bank StatementJune 2019DrCrBalance$$$1Balance b/d4,2307Cheque1864,4165R. Red5403,87616Cheque2254,10117J. Rebus1,5572,54418Y. Yale1232,42128Cheque6723,09329SLM standing order1562,93730G.Rice: trader's credit1923,12930Bank charges1293,000 As the accountant, you have been asked to do the following:a. Prepare an updated cashbook for the monthb. Prepare a bank reconciliation statement for the month
Question
Cash BookCr20191-JunBalance b/d4,2305-JunR. Red5407-JunP. Ryan18612-JunJ. Rebus1,55716-JunG. Grey22516-JunY. Yale12328-JunJ. Jim67229-JunBlister Disco6630-JunT. Fling1,74630-JunBalance c/d4,7737,0597,059 Bank StatementJune 2019DrCrBalance$1Balance b/d4,2307Cheque1864,4165R. Red5403,87616Cheque2254,10117J. Rebus1,5572,54418Y. Yale1232,42128Cheque6723,09329SLM standing order1562,93730G.Rice: trader's credit1923,12930Bank charges1293,000 As the accountant, you have been asked to do the following:a. Prepare an updated cashbook for the monthb. Prepare a bank reconciliation statement for the month
Solution
Sure, here is how you can prepare the updated cashbook and bank reconciliation statement for the month:
a. Updated Cash Book for June 2019:
| Date | Details | Debit ($) | Credit ($) | Balance ($) |
|---|---|---|---|---|
| 1-Jun | Balance b/d | 4230 | ||
| 5-Jun | R. Red | 540 | 3690 | |
| 7-Jun | P. Ryan | 186 | 3504 | |
| 12-Jun | J. Rebus | 1557 | 1947 | |
| 16-Jun | G. Grey | 225 | 1722 | |
| 16-Jun | Y. Yale | 123 | 1599 | |
| 28-Jun | J. Jim | 672 | 927 | |
| 29-Jun | Blister Disco | 66 | 861 | |
| 30-Jun | T. Fling | 1746 | -885 | |
| 30-Jun | SLM standing order | 156 | -1041 | |
| 30-Jun | G.Rice: trader's credit | 192 | -849 | |
| 30-Jun | Bank charges | 129 | -978 | |
| 30-Jun | Balance c/d | -978 |
b. Bank Reconciliation Statement for June 2019:
| Particulars | Amount ($) |
|---|---|
| Overdraft as per Cash Book | 978 |
| Add: Unpresented Cheques: G. Grey (16-Jun), Y. Yale (16-Jun), J. Jim (28-Jun) | 1020 |
| Less: Amounts not credited: R. Red (5-Jun), P. Ryan (7-Jun), J. Rebus (12-Jun), Blister Disco (29-Jun), T. Fling (30-Jun) | 4089 |
| Overdraft as per Bank Statement | 3000 |
Please note that the figures are calculated based on the information provided and may vary depending on the actual transactions.
Similar Questions
opening balances 1 July 2019 Petty cash 5000 Bank 80550Provide journal entries and cash book entires in the petty cash book and current account cash book
Bank Reconciliation StatementMarkson’s & cash book balance and bank statement balance at 31 March 2021 does not agree. The following information has been given to you as a student of accounting to help the company reconcile the difference:The balance per the cash book is GH¢3,300.A cheque of GH¢6,000 issued to a supplier on 30 March 2021 was still in the supplier’sInsurance paid by the bank is GH¢400. This is yet to be recorded in the cash book.An outgoing cheque of GH¢2,000 was recorded twice in the cash book. It is accurately recorded in the bankPayment of a GH¢1,000 cheque is recorded twice in the bankThe bank statement recorded an amount of GH¢1,200 as dividends received from Kankam There is no such transaction in the cash book.A cheque of GH¢1,000 received from a customer was deposited at the bank on 29 March 2021, but this amount has not yet reflected in the bank statement.Bank charges in the bank statement amounted to GH¢100.Required: a. List out the items and balances for the credit side of the updated / adjusted cashbookb. List out the items and balances for the debit side of the updated / adjusted cashbookexample: Debit: Dishonoured cheques GHS 2,000, Credit: Standing order GHS 1,000.
Based on the May 2020 bank reconciliation completed in the following question, which of the following would not be a part of one of the three adjusting journal entries Poorten will record at May 31, 2020 to adjust the cash account balance? Group of answer choicesCredit to Interest Revenue for $25Debit to Outstanding Checks for $2,410Debit to Service Charge Expense for $25Debit to Accounts Receivable for $175
Cash at bank Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 2 Capital 20000 20000 Dr 7 Sales 4000 24000 Dr 14 Purchases 1500 22500 Dr 17 Creditor XYZ Ltd 3000 19500 20 Sales 1500 21000 23 Debtor Jason 1900 22900 26 Creditor XYZ Ltd 1500 21400 Furniture Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 2 Cash at bank 5000 5000 Capital Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 2 Cash at bank 20000 20000 Cr Furniture 5000 25000 Cr Account Title: Purchases______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 4 Cash at bank 5500 5500 14 Cash at bank 1500 6500 Account Title: Creditor XYZ Ltd_______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 4 Purchases 5500 5500 10 Purchase returns 1000 6500 17 Cash at bank 2940 3560 Discount received 60 3500 26 Cash at bank 1500 2000 Account Title: Sales _______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 7 Cash at bank 4000 4000 14 Debtor- Jason 2500 1500 20 Cash at bank 1500 3000 Account Title: Purchases returns_______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 10 Creditor XYZ Ltd 1000 1000 Account Title: Debtor- Jason_______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 14 Sales 2500 2500 17 Sales returns 600 1900 23 Cash at bank 1862 38 Discount allowed 38 - Account Title: Discount received______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 17 Creditor XYZ Ltd 60 60 Cr Account Title: Sales returns_______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 17 Debtor- Jason 600 600 Account Title: Discount allowed_______________________________________ Date Particulars Folio Ref Debit (K) Credit (K) Balance (K) Jan 23 Debtor- Jason 38 38 Dr Change all these columnar accounts to T format accounts
A firm's bank reconciliation statement shows a book balance of $32,840, a non-interest note collected by the bank of 4,100, outstanding checks of $1,400, and a service charge of $100. Its adjusted book balance is:
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.