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: Encashing the bill before the due date is called from bank

A: Introduction: Bills of exchange: Bills of exchange is mostly used for international trade. Its an…

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: what is the price of sukuk for bahrain islamic bank (BisB) from 2017 to 2021

A: Introduction Sukuk, or Islamic bonds, are an important source of financing for Islamic banks in…

Q: Balance as per bank statement (Favourable) 17 200 Add: Outstanding deposits: 10 April 2021 8 500 30…

A: A bank reconciliation statement refers to the statement that matches the balance as per the bank…

Q: Q.4.1 Prepare the following subsidiary journals for Neverland Traders for February 2020: Q.4.1.1…

A: Petty cash fund is a little amount of money available or kept aside for paying off small expenses in…

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: Which of the Deposits in the bank provides facility for bank overdraft? Select one: O a. Current…

A: Banking system is a system in which bank organizations seeks deposit from public to lend them…

Q: hat is the doubtful accounts expense for the year 2021? 2. What is the net realizable value of the…

A: A certain percentage of expected uncollectible amount is derived through historical analysis of the…

Q: On 1/5/2019, the customer deposited an amount of (200,000) dinars as a fixed deposit for a period of…

A: Answer: Fixed deposit amount = 200000 dinars Interest = 200000*8%*6/12 = 8000 When ever any fixed…

Q: Use the following information for the next two questions. BPI Davao provided the following…

A: A loss allowance is the amount of money that a business sets aside to cover the potential losses…

Q: Bank Sohar declares the profit for the year ended 2019-20. They makes profit: a. When their rate of…

A: Banks main income generated from granting loans to the borrower.

Q: Ahmed has discounted the bill with bank. The date of maturity is 1st July 2021, when can the bank…

A: Days of Grace: Drawee is given three extra days following the due date of the bill for making…

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: Which one of the following will verify the documents and decide on their payability? Select one: A.…

A: Any agreement of consignment of goods through shipping or sale of goods through shipping has…

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: Given the required reserve ratio for Country AZ is as follows: Month September 2019 December 2019…

A: The following formulas are used in calculating the required information:- Total deposits recorded in…

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: What journal entry should be made to reflect the issuance of a $3,000 note to a creditor who has…

A: The issue is a journal entry that records the issuing of a $3,000 note to a customer. creditor who…

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

A: Positive bank covenant are the covenants meant for maintaining the financial health and well-being…

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: A. On December 2020, Al NASR Islamic bank buys a government bond worth $1000mln by issuing new…

A: The process of money creation by the commercial banks starts as soon as people deposit money in…

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: ASSETS FOREIGN CURRENCY FINANCIAL ASSETS ternational reserves Deposits with foreign banks Other cash…

A: Accounts receivable refers to the payments that the business would get from the customers who have…

Q: If we prepare financial statement for 31 december 2021, what should we enter in balance sheet and…

A: The answer is stated below:

Q: ments Journal Payee Grocery nvenience Store pre Gomer Chec y to

A: The Bank Statement and Bank column of the cash book need to be reconciled to understand the deposits…

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: The following are the cash book and bank statement of DRS Enterprise for the month of December 2020:…

A: In case, the balance in cash book and pass book, does not match, the cash book is to be updated as…

Q: Sarasota Co receives $2,680,000 when it issues a $2,680,000, 6%, mortgage note payable to finance…

A: Mortgage notes payable is kind of legal promissory note which binds one to pay the mortgage with the…

Q: Mention and explain the major line items on a bank’s income statement. What can the numbers on an…

A: Financial statement of a bank is different from others because they usually do not have inventory or…

Q: QUIXNO COMPANY Bank Reconciliation November 30, 2018 Cash balance per bank Add: Deposits in transit…

A: What is Bank Reconciliation: A statement is prepared to reconcile the balance as per the cash book…

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…

Q: Discuss FIVE (5) actions taken up by MASB when Central Bank of Malaysia announced a 6-month…

A: The Malaysian Accounting Standards Board (MASB) is a standard setting accounting body which was…

Q: Good day please assist with this question Show the adjustments that would be required in the…

A: Cash Book It is important for the organisation to maintain the cash book which is involve in all the…

Q: On 13 November 2020, Africa Traders received an electronic funds transfer payment of R7 000 from SA…

A: Accounting is the detailed process of recording, classifying and summarising accounting information…

Q: Items EUR/USD USD/MYR USD/SGD SPOT (2018) 1.1017/18 4.2200/699 1.3917/87 1 MONTH 437/492 74/119…

A: Note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…

Q: 4.1 Debtors Collection Schedule INFORMATION The following information was provided by Intel…

A: Debtors collection schedule is a schedule which show the amount received from debtors each month.…

Q: C. A Bank Reconciliation Statement as at June 30, 2020.

A: Any differences between the cash balance as per the bank and the cash balance as per the depositor's…

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
Crane Corp. owes $ 283,000 to Cheyenne Trust. The debt is a 10-year, 12% note due December 31, 2020. Because Crane Corp. is in financial trouble, Cheyenne Trust agrees to extend the maturity date to December 31, 2022, reduce the principal to $ 236,000, and reduce the interest rate to 6%, payable annually on December 31. (a) Prepare the journal entries on Crane's books on December 31, 2020, 2021, 2022. (b) Prepare the journal entries on Cheyenne Trust's books on December 31, 2020, 2021, 2022. Click here to view factor tables. (Round present value factor calculations to 5 decimal places, eg. 1.25124 and the final answer to O decimal places eg. 58,971. If no entry is required, select "No Entry" for the account titles and enter O for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually.)
What should be the age of receivables in 2021?
narubhai
An entity provided the following data on December 31, 2020: Checkbook balance ₱ 5,000,000.00 Check drawn on entity’s account, payable to supplier, dated and recorded on December 31, 2020 but not mailed until January 31, 2021 1,500,000.00 Cash in sinking fund 1,500,000.00 Treasury bills, purchased November 1, 2020 and maturing January 31, 2021 2,500,000.00 Time deposit, purchased October 1, 2020 and maturing January 31, 2021 3,500,000.00 What amount should be reported as cash and cash equivalents on December 31, 2020?
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…
Upon checking, the book of Meraki on December 31, 2020 is composed of the following:· Cash on Hand- P50,000· Demand Deposit- P200,000· Time Deposit, 30 days- P100,000· DAIF Check of customer- P4,000· Money market placement (due June 30, 2021)- P150000· Savings Deposit in a closed bank- P10000· IOU from employee- P2000· Pension Fund- P300000· Petty Cash Fund- P1000· Customer’s Check dated January 1, 2022- P5000· Customer’s Check outstanding for 18 months- P4000· Unused credit line- P50000 Additional information: a. P20,000 check was recorded as payment in December 31, 2020 but is mailed on January 5, 2021 to the suppliers. b. On December 31, 2020 a check dated January 15, 2021 of P10,000 in payment of accounts payable was recorded and mailed. c. While the Cash Receipt Journal is open until January 15, 2021, an amount of P40,000 was collected and recorded on December 31, 2020. d. The company uses the calendar year.…
fill in the boxes and find the monthly and ending balances with the savings calculator.
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…
As on 31 May 2020 the deposits awaiting clearance is RO15,240 and cheques yet to be presented for payment is RO17,590; while the bank balance as recorded in the Cash book was RO 5,480. How much should be the bank balance as on 31 May 2020 as per bank statement? a. RO 6130 b. RO 6130 Overdraft c. RO 7830 d. RO 7830 overdraft -fast-