Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I need the answer of this question: Future Communications had a computer failure on June 1, 2020, which resulted in the loss of data, including

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

I need the answer of this question:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Future Communications had a computer failure on June 1, 2020, which resulted in the loss of data, including the balance of its Cash account and its bank reconciliation from May 31, 2020. The accountant Byron Eyers, has been able to obtain the following information from the records of the company and its bank (Click the icon to view records a-b.) Click the icon to view records co.) Required 1. Prepare a bank reconciliation as of June 30, 2020, including the calculation of the book balance of June 30, 2020 2. Prepare all journal entries that would be required by the bank reconciliation Explanations are not required i Records a-b a. An examination showed that two cheques (#461 for $690.00 and #492 for $225.00) had not been cashed as of June 1. Eyers recalled that there was only one deposit in transit on the May 31 bank reconciliation but was unable to recall the amount b. The cash receipts and cash payments journal contained the following entries for June 2020 Cash Receipts: Amounts 885.00 1.245.00 1.580.00 610.00 2.470.00 6.790.00 Cash Payments: Cheque# Amount 499 $ 68000 500 660.00 2.590.00 875,00 360.00 820.00 void 345.00 Records a-b b. The cash receipts and cash payments journal contained the following entnes for June 2020. Cash Receipts: Amounts 885.00 1.245.00 1.580.00 610.00 2.470.00 $ 6.790.00 Cash Payments: Cheque# Amount 499 $ 680.00 500 660.00 2,590.00 875.00 360 00 820.00 void 345.00 56000 $ 6.890.00 Print Done 0 Records c-9 lay 31 c. The bank provided the following statement as of June 30, 2020. Deposits and Other Credits 695.00 Date | Cheques and Other Debits Jun. 1 #500 660.00 #492 225.00 #501 2,590.00 is. E 885.00 580.00 #499 680.00 445.00 Balance 3,610.00 3,385.00 795.00 1.680.00 1.580.00 1,135.00 1,870.00 2.755.00 2.235.00 2.730.00 2,500.00 EFT EFT #503 360.00 860.00 735.00 1.245.00 340.00 495.00 1.580.00 #504 EFT EFT NSF 1.810.00 Drin Done 0 Records c-g - X Way 31, 2020. The a 30 s. Enter all amounts #503 360.00 1,245.00 2,755.00 #504 860.00 EFT 340.00 2,235.00 24 EFT 495.00 2.730.00 26 NSF 1,810.00 1,580.00 2,500.00 27 SC 60.00 2,440.00 #507 560.00 610.00 2,490.00 d. The deposit made on June 16 was for the collection of a note receivable ($500.00) plus interest. e. The EFTs had not yet been recorded by Future Communications since the bank statement was the first notification of them The June 17 EFT was for the monthly payment on an insurance policy for Future Communications The June 19 and 24 EFTs were collections on accounts receivable. The June 22 EFT was in error-the transfer should have been to Frank Communications f The NSF cheque on June 26 was received from a customer as payment of $1,810.00 for installation of a satellite purchased from Future g. Cheque #504 was correctly written for $860.00 for the purchase of inventory (assume a perpetual system) but incorrectly recorded by the cash payments clerk. Print Done Required 1. Prepare a bank reconciliation as of June 30, 2020, including the calculation of the book balance of June 30, 2020 2. Prepare all journal entries that would be required by the bank reconciliation Explanations are not required. Requirement 1. Prepare a bank reconciliation as of June 30, 2020, including the calculation of the book balance of June 30, 2020 Prepare the bank section of the bank reconciliation. Then, prepare the book section of the bank reconciliation (Use parentheses or a minus sign when subtracting numbers. Enter all amounts in two decimal places. Future Electronics Bank Reconciliation June 30 2020 BANK Balance June 30, 2020 Add Deposits in transit Choose from any list or enter any number in the input fields and then continue to the next question Required 1. Prepare a bank reconciliation as of June 30, 2020, including the calculation of the book balance of June 30, 2020. 2. Prepare all journal entries that would be required by the bank reconciliation. Explanations are not required. Balance, June 30, 2020 Add: Deposits in transit Less: Outstanding cheques Cheque No. Correction of bank error A nthont han linnun 2020 Choose from any list or enter any number in the input fields and then continue to the next question. O Type here to search Adjusted bank balance, June 30, 2020 BOOKS Balance, June 30, 2020 Add: Bank collection of note receivable incl. interest Bank collection of accounts receivable Less NSF cheque Service charge Correction of book error Insurance payment Bank collection of accounts receivable Less: NSF cheque Service charge Correction of book error Insurance payment Adjusted book balance, June 30, 2020

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions