Bank StatementCheques/ChargesDeposits/Credits31-Маy|Balance12.192.926/1 9.050.00 20677.92#8846/1565.00#8836/42.390.0018.287.92#8766/9226.006/9 6.280.024.341.92#8896/121,248.0023.093.92#8826/14659.0022.434.92#8876/182,003.786/18 1,920.0022.35114#8856/20424.0021 92714#8916/216,569.0015,358.14#8866/29352.0015 006.14SC6/3089.306/3014.916.84Notes: Cheque #887 was recorded incorrectly by the bookeeper for equipmentpurchase. Cheque #891 was recorded incorrectly by the bank.Prepare the bank reconciliation at June 30, 2020. The bank statement and relevant portions of Bernie Company's cash records for the month ended June 30, 2020 are given below.Bernie CompanyCheque RegisterExplanation31-May Deposit1-Jun Cheque1-Jun Cheque1-Jun Cheque1-Jun Cheque3-Jun Cheque4-Jun Cheque9-Jun Deposit12-Jun Cheque12-Jun Cheque12-Jun Cheque18-Jun Deposit20-Jun Cheque21-Jun Cheque24-Jun Cheque26-Jun ChequeDateDebitCreditBalance-21,242,9220.583.9220,357.9217,967.9237,402.92424.00 E16,978.9216,626.9222,906.9220,793.149.050.00882659.00226.002,390.00565.00876883884885886352.006,280.008872,113.7818,623.7117,375.7119,295.7116,926.7110,257.718,805.712,169.431,248.008888891,920.008902,369.008916,669.008928931,452.00256.008,549.713,695.0012,244.729-Jun Deposit

Bank reconciliation statement is prepared where an entry which is found in one book (Cash book or…

Answered: Bank Statement Cheques/Charges…

College Accounting (Book Only): A Career Approach

13th Edition

ISBN:9781337280570

Author:Scott, Cathy J.

Publisher:Scott, Cathy J.

Chapter6: Bank Accounts, Cash Funds, And Internal Controls

Section: Chapter Questions

Problem 2E

See similar textbooks

Similar questions

Cash Receipts from Customers Singleton Inc. had accounts receivable of $22,150 at January 1, 2019, and $26,850 at December 31, 2019. Net income for 2019 was $125,300 and sales revenue was $1,240,000. Required: Compute the amount of cash collected from customers using the direct method.
The following information is produced by comparing the cash deposits and withdrawals recorded bythe S&W Windows Ltd for the month with their most recent bank statement received at 30 June2019:a. S&W Windows Ltd’ cash at bank ledger at 30 June 2019 is: $75,864b. Credit balance as per bank statement as at 30 June 2019 is: $101,160c. Bank statement shows an electronic transfer from a customer of $3,864d. Deposits in transit, $12,540e. Interest earned on bank account, $75f. Unpresented cheques, $37,407g. Service charge included in bank statement, $150h. Cheque for insurance expense, $5,370 incorrectly recorded in books as $5,910i. A dishonoured cheque written by a client Jim Smith, $3,900The entity doesn’t use special journals for record keeping. The entity prepares bank reconciliationstatement at the end of each month.Required:a) Prepare a bank reconciliation statement for S&W Windows Ltd at 30 June 2019. b) Discuss why a bank reconciliation is still necessary even most of the…
The following information is produced by comparing the cash deposits and withdrawals recorded by the M&N Windows Ltd for the month with their most recent bank statement received at 30 June 2019:a. M&N Windows Ltd’ cash at bank ledger at 30 June 2019 is: $75,864b. Credit balance as per bank statement as at 30 June 2019 is: $101,160c. Bank statement shows an electronic transfer from a customer of $3,864d. Deposits in transit, $12,540e. Interest earned on bank account, $75f. Unpresented cheques, $37,407g. Service charge included in bank statement, $150h. Cheque for insurance expense, $5,370 incorrectly recorded in books as $5,910i. A dishonoured cheque written by a client Jim Smith, $3,900The entity doesn’t use special journals for record keeping. The entity prepares bank reconciliation statement at the end of each month.Required:a) Prepare a bank reconciliation statement for M&N Windows Ltd at 30 June 2019. b) Discuss why a bank reconciliation is still necessary even most of…
The bank columns in the cash book for June 2019 and the bank statement for that month for Phillips Hardware Company Ltd are as follows:DrCash BookCr 2019 $2019 $ 1-JunBalance b/d4,2305-JunR.Red540 7-JunP. Ryan18612-JunJ. Rebus1,557 16-JunG. Grey22516-JunY.Yale123 28-JunJ. Jim67229-JunBlister Disco66 30-JunT. Fling1,74630-JunBalance c/d4,773 7,059 7,059 Bank Statement June 2019 DrCrBalance $$$ 1Balance b/d 4,230 7Cheque 1864,416 5R.Red540 3,876 16Cheque 2254,101 17J. Rebus1,557 2,544 18Y.Yale123 2,421 28Cheque 6723,093 29SLM standing order156 2,937 30G.Rice: trader's credit 1923,129 30Bank charges129 3,000 As the accountant, you have been asked to do the following: a) Prepare an updated cashbook for the month b) Prepare a bank reconciliation statement for the month c) Advise the directors of Phillips Hardware how they can use theinternal control measures listed below to mitigate against error and fraud in the business. 1: Physical Observation 2: Authorization and Approval 3:…
At October 31, Matrah Company has this bank information: cash balance per bank RO 8,950; outstanding checks RO 450; deposits in transit RO 1,300; and a bank service charge RO 60. Determine the adjusted cash balance per bank at October 31, 2019.
What is the adjusted cash in bank as of March 31 per bank and per books?
Compute the adjusted cash balance as at September 30, 2019 of Guyana Corp where it was preparing a bank reconciliation statement as of September 30, 2019. The company has provided the following details:Deposit in Transit = $4,300Book balance =$32,800Customer NSF check returned by bank =$400Outstanding checks = $2,200Interest earned on checking account =$100
In connection with your examination, the Caliao Company presented to you the following information regarding its Cash in Bank account for the month of December 2020: A. Balances per bank statements: November 30, P215,600 and December, P230,400. B. Balances of cash in bank account in company's books: November 30, P165,450 and December 31, P226,800. C. Total receipts per book were P2,221,900 of which P12,100 was paid in cash to a creditor on December 24. D. Total charges in the bank statement during December were P2,189,700. E. Undeposited receipts were: November 30, P90 600 and December 31, P101,200. F. Outstanding checks were: November 30, P26,750 and December 31, P19,300, of which a check for P5,000 was certified by the bank on December 26. G. NSF checks returned, recorded as reduction of cash receipts were: Returned by bank on December and recorded also in December P10,400. Returned by bank on December but recorded also in January P8,600. H. Collections by bank not recorded by…
In connection with your examination, the Caliao Company presented to you the following information regarding its Cash in Bank account for the month of December 2020: A. Balances per bank statements: November 30, P215,600 and December, P230,400. B. Balances of cash in bank account in company’s books: November 30, P165,450 and December 31, P226,800. C. Total receipts per book were P2,221,900 of which P12,100 was paid in cash to a creditor on December 24. D. Total charges in the bank statement during December were P2,189,700. E. Undeposited receipts were: November 30, P90 600 and December 31, P101,200. F. Outstanding checks were: November 30, P26,750 and December 31, P19,300, of which a check for P5,000 was certified by the bank on December 26. G. NSF checks returned, recorded as reduction of cash receipts were:  Returned by bank on December and recorded also in December P10,400.  Returned by bank on December but recorded also in January P8,600. H. Collections by bank not recorded by…
In connection with your examination, the Caliao Company presented to you the following information regarding its Cash in Bank account for the month of December 2020: A. Balances per bank statements: November 30, P215,600 and December, P230,400. B. Balances of cash in bank account in company’s books: November 30, P165,450 and December 31, P226,800. C. Total receipts per book were P2,221,900 of which P12,100 was paid in cash to a creditor on December 24. D. Total charges in the bank statement during December were P2,189,700. E. Undeposited receipts were: November 30, P90 600 and December 31, P101,200. F. Outstanding checks were: November 30, P26,750 and December 31, P19,300, of which a check for P5,000 was certified by the bank on December 26. G. NSF checks returned, recorded as reduction of cash receipts were: Returned by bank on December and recorded also in December P10,400. Returned by bank on December but recorded also in January P8,600. H. Collections by bank not recorded by…
In connection with your examination, the Caliao Company presented to you the following information regarding its Cash in Bank account for the month of December 2020: A. Balances per bank statements: November 30, P215,600 and December, P230,400. B. Balances of cash in bank account in company’s books: November 30, P165,450 and December 31, P226,800. C. Total receipts per book were P2,221,900 of which P12,100 was paid in cash to a creditor on December 24. D. Total charges in the bank statement during December were P2,189,700. E. Undeposited receipts were: November 30, P90 600 and December 31, P101,200. F. Outstanding checks were: November 30, P26,750 and December 31, P19,300, of which a check for P5,000 was certified by the bank on December 26. G. NSF checks returned, recorded as reduction of cash receipts were:  Returned by bank on December and recorded also in December P10,400.  Returned by bank on December but recorded also in January P8,600. H. Collections by bank not recorded by…
Given this book and bank statement information, create an October bank reconciliation for Arrowhead company. And the journal entries required for the book side. BOOK INFO: Cash Date Debit Credit Balance 10/1/2020 Beginning Balance 8,259.86 10/1/2020 Ck 10102 Accounts Payable 1,374.12 6,885.74 10/2/2020 Ck 10103 Rent 3,420.00 3,465.74 10/2/2020 Ck 10104 Utilities 689.00 2,776.74 10/4/2020 Deposit 3,743.10 6,519.84 10/4/2020 Ck 10105 Advertising 344.21 6,175.63 10/4/2020 Ck 10106 Subscription 102.84 6,072.79 10/9/2020 Ck 10107 Internet 74.97 5,997.82 10/9/2020 Deposit 4,859.47 10,857.29 10/9/2020 Ck 10108 Telephone 221.00 10,636.29 10/9/2020 Deposit 11,339.64 21,975.93 10/12/2020 Ck 10109 Accounts Payable 1,680.00 20,295.93 10/13/2020 Ck 10110 Wages…

SEE MORE QUESTIONS

Recommended textbooks for you

College Accounting (Book Only): A Career Approach

Accounting

ISBN:

9781337280570

Author:

Scott, Cathy J.

Publisher:

South-Western College Pub

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

College Accounting (Book Only): A Career Approach

Accounting

ISBN:

9781305084087

Author:

Cathy J. Scott

Publisher:

Cengage Learning

College Accounting (Book Only): A Career Approach

Accounting

ISBN:

9781337280570

Author:

Scott, Cathy J.

Publisher:

South-Western College Pub

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

College Accounting (Book Only): A Career Approach

Accounting

ISBN:

9781305084087

Author:

Cathy J. Scott

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS