Question: need to create this into an excel file woth directions please Danik Kornett Company Bank Reconciliation December 31, 20Y8 1 Cash balance according to bank

need to create this into an excel file woth directions please Danik Kornett Company Bank Reconciliation December 31, 20Y8 1 Cash balance according

to bank statement 2 Add: Deposit in transit, not recorded by bank

Danik Kornett Company Bank Reconciliation December 31, 20Y8 1 Cash balance according to bank statement 2 Add: Deposit in transit, not recorded by bank 3 Deduct: Outstanding checks Score: 68/72 $283,000.00 29.500.00 68,540.00 + Adjusted balance $243,960.00 5 6 Cash balance according to company's records $245,410.00 7 Deduct: Bank service charges $750.00 Error in recording check 700.00 9 Adjusted balance $243,960.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

By looking at the region in Figure 9 first vertically and then horizontally, conclude that And use this fact to calculate: (a) (b) xÌ, the horizontal coordinate of the centroid of the region?...

https://www.youtube.com/watch?v=lOeQUwdAjE0&t=5s Watch the video: " ReMoved ". Reflect on the impact of child abuse on the child over the course of their life. Answer the following questions: How did...

Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30, 20Y2, have...

Kornett Company Bank Reconciliation December 31, 20Y8 Cash balance according to bank statement $283000 Add deposit in transit, not recorded by bank $29500 Deduct outstanding checks $68540 Adjusted...

Each section has excel with tabs at the bottom for assignments. P8-22A Correcting internal control weakness Each of the following situations has an internal control weakness. a. Upside-Down...

Please help! I am lost on how to do these bank reconciliations. American National Bank of Chicago Chicago, IL 60603 (312) 441-1239 Beeler Fumiture Company Bank Reconciliation May 31, 20-...

I can not figure out what to put for the last part of the journal I have the first two parts completed.I will attempt to add pictures!!! 1. Journalize the selected transactions, starting on page 21...

NEED HELP ASAP Can you please help me do a bank reconciliacion statement, if possible provide your work to see the reconciled balance. thanks Template: Western Bank Page 1 PO Box 12345 El Paso, Texas...

Please I don't want an answer that is copied and pasted from a similar question. These answers are wrong or incomplete that is why I posted the question again. Posh Hotels Ltd. (PHL) is a small...

Assessment Task - AT3 Silver Services Catering. Following your complete and correct Assessment 2, you will now post the general journals to the ledgers, undertake a bank reconciliation and Trial...

In the two-stage amplifier circuit in Figure 1, mosfets are equivalent and their parameters are; rd = 100 k?, VT = 4 V, k = 0.3 mA / V2. In the two-stage amplifier circuit? a) Calculate the VGSQ...

You are developing a property and need to take out a construction loan. Loan terms are as follows: Construction Cost (excluding loan interest): $1,950,000 Loan-to-Cost (LTC): Construction Period:...

How many appendices does BS 7 6 7 1 ? a ) 1 7 b ) 1 2 c ) 1 4 d ) 1 5

factory closing decision the dough knot corporation bakes breads, pastries, cookies and every other baked good imaginable thb approximately 400 factory employees will lose their jobs if the factory...

Discuss the possible effects to our BOP when international credit agencies downgrade the credit rating of the Philippines.

Why did the Russian economy perform well during the 2001-2013 period and why did it run into trouble in 2014? After the collapse of communism, many Western businesses started to invest in Russia. How...

Examine QuickTrip value chain and evaluate its effectiveness to operations in terms of quality, value creation, and customer satisfaction. Determine the different types of performance measurements...

Identify three studies and provide the following information on each: What types of statistical techniques were utilized in the study? Why did the researcher select those specific techniques? Are...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

The emergency fund ratio measure how many times the client can satisfy their short-term liabilities. a. True b. False

Identify the four responses to managing risk.

Personal risk management is a system- atic process for identifying, evaluating, and managing pure risk exposures. a. True b. False