Can you please help me create a Bank reconciliation and the necessary journal entries for the below
Fantastic news! We've Found the answer you've been seeking!
Question:
Can you please help me create a Bank reconciliation and the necessary journal entries for the below attached documents?
Transcribed Image Text:
Name: Accounting Essentials (GACG1047)- Assignment Two 1. Using the Bank Statement below for October and the columns of the cash receipts journal, cash payments journal and the cash ledger account-Prepare a Bank Reconciliation for Romeo's Roses and prepare all necessary journal entries to bring the books up to date. (value 23) A partial chart of accounts includes the following: cash 101, accounts receivable 110, notes receivable 120, interest revenue 420, utilities expense 640, and bank charges expense 670. In addition: Cheque 123 was written to pay the utility bill (assume any errors were made by the company bookkeeper. The credit memo is for a notes receivable that the bank collected for $4000 plus interest on our behalf. The debit memo indicated a cheque from R Walters had been returned NSF. October Total Cash Deposits (Cash Receipts) Cheques Written (Cash Payments) 4 7 10 15 187 17 2,130 22 1,404 23 721 225 4,208 29 5,105 $19,895 $ 3,174 Cheque 113 $1,930 1,407 114 1,472 1,559 115 2,413 116 689 117 230 118 118 119 307 120 1,326 121 640 122 3,016 123 741 Total $12,882 Date 2023 Oct. 1 Balance 31 31 Account No. 101 Post Explanation Ref Debit Credit Balance 13542.00 Cr4 19895.00 33437.00 CP8 12882.00 20555.00 Name: Accounting Essentials (GACG1047)- Assignment Two 1. Using the Bank Statement below for October and the columns of the cash receipts journal, cash payments journal and the cash ledger account-Prepare a Bank Reconciliation for Romeo's Roses and prepare all necessary journal entries to bring the books up to date. (value 23) A partial chart of accounts includes the following: cash 101, accounts receivable 110, notes receivable 120, interest revenue 420, utilities expense 640, and bank charges expense 670. In addition: Cheque 123 was written to pay the utility bill (assume any errors were made by the company bookkeeper. The credit memo is for a notes receivable that the bank collected for $4000 plus interest on our behalf. The debit memo indicated a cheque from R Walters had been returned NSF. October Total Cash Deposits (Cash Receipts) Cheques Written (Cash Payments) 4 7 10 15 187 17 2,130 22 1,404 23 721 225 4,208 29 5,105 $19,895 $ 3,174 Cheque 113 $1,930 1,407 114 1,472 1,559 115 2,413 116 689 117 230 118 118 119 307 120 1,326 121 640 122 3,016 123 741 Total $12,882 Date 2023 Oct. 1 Balance 31 31 Account No. 101 Post Explanation Ref Debit Credit Balance 13542.00 Cr4 19895.00 33437.00 CP8 12882.00 20555.00
Expert Answer:
Answer rating: 100% (QA)
Answer Cash balance in bank needs to be arrived at 31 st March 2018 hence the given entries are to be entered in cash receipts and cash payments journal to reflect the correct account balance Cash Rec... View the full answer
Related Book For
College Accounting A Practical Approach
ISBN: 978-0134166698
13th Canadian edition
Authors: Jeffrey Slater, Debra Good
Posted Date:
Students also viewed these accounting questions
-
Blossom, Inc. had the following equity investment portfolio at January 1, 2020. Evers Company 990 shares @ $14 each $13,860 Rogers Company 890 shares @ $19 each 16,910 Chance Company 480 shares @ $10...
-
In Exercises 7980, find the value of y if the line through the two given points is to have the indicated slope. (3, y) and (1, 4), m = -3
-
You are a member of the engineering organization for an aircraft parts manufacturer. The firm is considering the implementation of a PLM system. Make a convincing argument for selecting a system...
-
The FUTA Tax (LO 9.6) Your client has provided the following annual payroll summary for 2022: Premium Court Corporation 1 First Street, NE Washington, DC 20543 EIN: 44-1112223 December 31, 2022 Gross...
-
Explain how the control variate technique is implemented.
-
At December 31, 2013, Crawford Company had a balance of $15,000 in Allowance for Doubtful Accounts. During 2014, Crawford wrote off accounts totaling $14,100. One of those accounts ($1,800) was later...
-
IQ scores (as measured by the Stanford-Binet intelligence test) are normally distributed with a mean of 100 and a standard deviation of 16. What percentage of the population has an IQ score between...
-
Brothers Herm and Steve Hargenrater began operations of their tool and die shop (H & H Tool) on January 1, 1987, in Meadville, PA. The annual reporting period ends December 31. Assume that the trial...
-
A firm is funded with $2 million of loans and $6 million of equity. The interest rate on the loans is 8% pa. The cost of equity is estimated to be 20% pa. The corporate tax rate is 30% pa. Which of...
-
What can a business do to improve its productivity? Explain how ?
-
if the atomic radius of a cubic monatomic crystal with FCC unit cell is 0 , 1 5 0 nm , how many atoms are there per square nanometer of planes with ( 1 1 0 ) miller index ? Briefly explain with...
-
Suppose the following order arrive in sequence: 1. Harry: Buy 700 stocks at market. 2. Jenny: Sell 1600 stocks at limit $50.04. What is the bid ask spread after these orders arrive and are executed?...
-
Estate Tax Planning GOALS FOR SYNC SESSION Review of some Estate Tax Planning Strategies In-Class Practice - Taxable gift? Practice Problems with Estate Taxes Questions about Exam 3 Review of some...
-
The Sun moves in a circular orbit around our Milky Way galaxy with an orbital radius r = 2.5x10 20 m m and a uniform circular speed v = 2x10 5 m/s. Estimate the mass of the galaxy inside the Sun...
-
Plot the Pressure vs Np in Table 3 . Pressure psia Bt. bbl/STB Bg, bbl/SCF Np. MM STB Rp. SCF/STB 2500 1.498 0.001048 2300 1.523 0.001155 3.741 716
-
Find the work done in pumping all the oil (density S = 50 pounds per cubic foot) over the edge of a cylindrical tank that stands on one of its bases. Assume that the radius of the base is 4 feet, the...
-
Identify whether each of the following items affects the bank or book side of the reconciliation, and indicate whether the amount represents an addition or a subtraction. Bank or Book + or - a....
-
When would a company consider using a periodic inventory system?
-
For this exercise, please assume a province that has three rates for workers compensation: General Office Workers, $1.85 per $100; Sales Staff, $2.45 per $100; Management Personnel, $1.25 per $100....
-
All three 50 kg blocks are at rest. Is the tension in rope 2 greater than, less than, or equal to the tension in rope 1? 50 kg 2 50 kg 2 50 kg
-
a. Can the normal force on an object be directed horizontally? If not, why not? If so, provide an example. b. Can the normal force on an object be directed downward? If not, why not? If so, provide...
-
You are going sledding with your friends, sliding down a snowy hill. Friction can't be ignored. Riding solo on your sled, you have a certain acceleration. Would the acceleration change if you let a...
Study smarter with the SolutionInn App