What kind of reconciling item is the amount

Reference no: EM133611067

Question: Bank Rec Lab An important internal control for cash is the reconciliation of the cash general ledger account to the bank statement on a regular basis. In this lab, you will prepare the bank reconciliation. The outline is given to you in the Excel spreadsheet. You will have to fill in the missing numbers. Step 1: We need to analyze items that are in the G/L transactions list but are not in the Bank Statement transaction list. What could these items be? Step 2: (Vice-versa, too) We need to also analyze items that are in the Bank Statement but not in the G/L transactions. What could those items be? Hint: There are many ways to do this including COUNTIF and MATCH. Try using one or both. You can do them in columns C and G. Answer the following questions: 1. Does "Interest Earned" in the Bank Statement column need to be reconciled? Why? 2. What kind of reconciling item is the amount in B18? Why? 3. What kind of reconciling item is the amount in F34? Why? 4. Why do a bank reconciliation at all? 5. What is the reconciling balance?

Reference no: EM133611067

Questions Cloud

Prepare a report to the board of directors : Prepare a report to the Board of Directors of CommunityCares Foundation, providing them with the guidance they require

How much time the students spend studying : Counselors at a college want to poll students about how much time the students spend studying.

Canadian nfpo accounting standards : board of directors is confronting numerous obstacles while preparing financial statements in accordance with Canadian NFPO accounting standards

One activity for physical developmental domain : One activity for physical (gross motor) developmental domain that relates to dramatic play and is developmentally appropriate for preschool students

What kind of reconciling item is the amount : What kind of reconciling item is the amount in F34? Why? 4. Why do a bank reconciliation at all? 5. What is the reconciling balance

How much tax will the tax museum corporation pay : corporation owns less than 20 percent of the stock of the paying corporation. How much tax will The Tax Museum Corporation pay on the dividends from Florida

Maintenance is not function of procedures : Maintenance is not a function of procedures; maintenance is a function of the systems in which the presumed efficacious procedures are embedded.

What is one share of this stock worth today : will discountinue operations. What is one share of this stock worth today if the required rate of return is 15 percent

What measure is used for how wasteful a cost : What measure is used for how wasteful a cost or a cost recurring activity is so one can compare activities to see which one adds more value?

User Account

All Pages