Prepare 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 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.

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

Answered: Prepare bank reconciliation at June 30…

Business

Accounting

Prepare bank reconciliation at June 30 2020.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: borrowed is fixed. on how much is overdrawn. The limit of overdrawing is an amo by the bank. For…

A: Interest Expense - The fee a company pays for borrowed money is known as an interest expenditure.…

Q: Currency in Circulation (2019) 20.25 billion currency units Reserves (2019) 17.10 billion currency…

A: Monetary base- It is the total sum of currency in circulation and reserve balances (deposits held by…

Q: Whispering Winds Corp. had the following transactions involving notes payable. July 1, 2022 Borrows…

A: A journal entry is a record of a financial transaction in a company's accounting system. It…

Q: 1. The total amount remitted to the BIR through the Tax Remittance Advice? 2. How much is the…

A: The Tax Remittance Advice (TRA) is an official document used by organizations to report and send…

Q: None

A: Step 1: Determination of proceeds received from the bank on discounting the noteNoteNote Face Value…

Q: Descriptors are provided below for six situations involving notes receivable being discounted at a…

A: Notes receivables are the company's asset as it is the amount that is to be received at the end of…

Q: a) From the following information, update the cash book and prepare a bank reconciliation statement…

A: Step 1: Compare the Bank Statement and Cash Book BalancesStart by comparing the ending balance of…

Q: Kendall, who earned $128,400 during 2021, is paid on a monthly basis, is married, (spouse does not…

A: Federal withhold Taxes The sum of federal income tax deducted from an employee's wages is known as…

Q: Which of the following are common POSITIVE bank covenants? Indicate ALL that apply. Achieve a…

A: A bank covenant is an agreement between a borrower and a lender which governs the terms of the loan.…

Q: 2022. The U.S. dollar equivalent of the note amount was $295,000 on December 31, 2021, and $299,000…

A: Foreign currency is currency other than domestic currency. When there is dealing in foreign currency…

Q: 2.3. Thor Company provided the following data on December 31, 2019: Checkbook balance: 4,000,000…

A: Cash includes Cash Balance, Bank Balance, Bills Which have Maturity Value less then 3 Months.

Q: Match each of the below items into one of the following balance sheet categories: Cash Receivables…

A: The objective of this question is to categorize various items into appropriate balance sheet…

Q: Use the information provided below to prepare the following for January and February 2023 as per…

A: Cash Budget- A cash budget analyses the flow of cash in a company over the long or short term. So a…

Q: Funds in a ____ must remain on deposit for a stated time period in order to avoid an interest…

A: Deposit is a fixed amount of money invested in a bank or in some financial institutions in which…

Concept explainers

Bank Reconciliation Statement

As a commerce student, we all know that every business has to maintain a cash book to maintain all his cash and bank transactions. A cash book is a book which has two columns, one cash column and one bank column.

Question

Prepare 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 Company
Cheque Register
Explanation
31-May Deposit
1-Jun Cheque
1-Jun Cheque
1-Jun Cheque
1-Jun Cheque
3-Jun Cheque
4-Jun Cheque
9-Jun Deposit
12-Jun Cheque
12-Jun Cheque
12-Jun Cheque
18-Jun Deposit
20-Jun Cheque
21-Jun Cheque
24-Jun Cheque
26-Jun Cheque
Date
Debit
Credit
Balance
-21,242,92
20.583.92
20,357.92
17,967.92
37,402.92
424.00 E16,978.92
16,626.92
22,906.92
20,793.14
9.050.00
882
659.00
226.00
2,390.00
565.00
876
883
884
885
886
352.00
6,280.00
887
2,113.78
18,623.71
17,375.71
19,295.71
16,926.71
10,257.71
8,805.71
2,169.43
1,248.00
888
889
1,920.00
890
2,369.00
891
6,669.00
892
893
1,452.00
256.00
8,549.71
3,695.00
12,244.7
29-Jun Deposit

Bank Statement
Cheques/Charges
Deposits/Credits
31-Маy|
Balance
12.192.92
6/1 9.050.00 20677.92
#884
6/1
565.00
#883
6/4
2.390.00
18.287.92
#876
6/9
226.00
6/9 6.280.0
24.341.92
#889
6/12
1,248.00
23.093.92
#882
6/14
659.00
22.434.92
#887
6/18
2,003.78
6/18 1,920.00
22.35114
#885
6/20
424.00
21 92714
#891
6/21
6,569.00
15,358.14
#886
6/29
352.00
15 006.14
SC
6/30
89.30
6/30
14.916.84
Notes: Cheque #887 was recorded incorrectly by the bookeeper for equipment
purchase. Cheque #891 was recorded incorrectly by the bank.
Prepare the bank reconciliation at June 30, 2020.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Waterway, Inc. had the following bank reconciliation at March 31, 2020: Balance per bank statement, 3/31/20 Add: Deposit in transit Less: Outstanding checks Balance per books, 3/31/20 Data per bank for the month of April 2020 follow: Deposits Disbursements $36600 O $25050 O $31100 O $29350 O $26350 6240 42840 8540 $34300 $47200 50400 All reconciling items at March 31, 2020 cleared the bank in April. Outstanding checks at April 30, 2020 totaled $6050. There were no deposits in transit at April 30, 2020. What is the cash balance per books at April 30, 2020?
Please see photos for table and questions that need answering
narubhai
Hi, How do I organize these transactions ? Thanks
The bank statement for Unique Fashion had an ending cash balance of $2,200 on April 30, 2022. On this date the cash balance in their general ledger was $3,678. After comparing the bank statement with the company records, the following information was determined. The bank returned an NSF cheque in the amount of $350 that Unique Fashion deposited on April 20. The NSF service fee was $9. A direct deposit received from a customer on April 29 in payment of their accounts totaling $3,780. This has not yet been recorded by the company. On April 29, the bank deposited $16 for interest earned. The bank withdrew $35 for bank service charges. Deposits in transit on April 30 totalled $4,880. Required Reconcile the ledger and bank statement and create the required journal entries. Do not enter dollar signs or commas in the input boxes. Do not use negative signs. Select the proper order for the headings of the Bank Reconciliation. Cash balance per bank statement Add Outstanding deposit Adjusted bank…
The bank reconciliation prepared by Gatz Company on May 31, 2020, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2020 Bank statement balance $ 9,364.35 Book balance $19,639.00 Add: Deposit of May 31 in transit 959.00 $10,323.35 Deduct: Deduct: Outstanding cheques: NSF cheque plus service charge $11,655.65 #876 643.00 #882 1,763.00 2,406.00 Bank service charge 66.00 11,721.65 Adjusted bank balance $ 7,917.35 Adjusted book balance $ 7,917.35 The Cash account in the General Ledger appeared as follows on June 30 (Gatz uses only a General Journal to record transactions): Acct. No. Cash 101 Date Explanation PR Debit Credit Balance 2020 May 31 Balance June 1 Cheque #883 1 Cheque #884 3 Cheque #885 4 Cheque #886 9 Deposit 12 Cheque #887 7,917.35 1,850.00 6,067.35 107.00 5,960.35 618.00 5, 342.35 GJ16 GJ16 GJ16 GJ16 1,917.00 3,425.35 8,011.35 425.15 7,586.20 3,143.00 4,443.20 937.00 3,506.20 7,392.20 2,540.00 4,852.20 1,406.24 3,445.96 950.96 GJ16 4,586.00 GJ16 12 Cheque #888 12…
Are 1 year certificates of deposit recorded on bank reconciliation?
CHAPTER : BANK RECONCILIATION
Suppose that you are the Chief Financial Officer of a corporation based in Germany (EUR is thehome currency), having operations globally in all the continents.In the performance of your estimations and calculations you have to analyze the exposures in theforeign currencies. In the appendix there is a table with downloaded information from theEuropean Central Bank (ECB)’s website, the exchange rates of each day of September 2020.Required:i. Present that information in a table for 5 currencies (freely decide whichcurrencies).ii. Discuss the fluctuations and how the exchange rates have changed from the firstto the last day of the period under investigation.iii. Discuss how the following activities of your company are expected to beinfluenced by the expected EUR appreciation for the last quarter of 2020.Explain your answers.i. Domestic sales;ii. Foreign sales denominated in domestic currency;iii. Foreign sales denominated in foreign currency;iv. Importing goods for domestic sales…
Suppose that today is 13 August 2019 and the current exchange rate is HKD 6.20 per AUD 1.00. The figure below shows your prediction with respect to the HKD's movements relative to the AUD between now and mid-September 2019. HKD per AUD 7.2 6.8 6.4 6.0 13/08 18/08 23/08 28/08 2/09 7/09 12/09 today Note: HKD = Hong Kong Dollar; AUD = Australian Dollar. %3D %3D You intend to capitalize on your prediction by using the 15/9/2019-maturity forward contract, which is currently priced at HKD 6.00 per AUD 1.00. Which of the following are you most likely to undertake today to capitalize on your prediction? (Select the best answer.) O a. Long forward contract to buy AUD O b. Short forward contract to sell AUD O C. Long forward contract to sell HKD O d. Either (a) or (c) will work