Prepare a bank reconciliation for the company

Assignment Help Database Management System
Reference no: EM132501422

Question - Note the following information related to a company's cash account:

Cash Balance per Bank

Cash balancer per bank, 12/31/19 9,610

Check #6832 cleared the bank for $240, but erroneously recorded by company for $268 Outstanding checks 2,417

Deposit by ABC Inc erroneously recorded to the company by the bank 486

NSF check returned by bank 281

Cash balance per books, 12/31/19 7,430

December 2019 interest per bank 30

Check mailed to bank for a deposit that had not reached the bank by 12/31/19 500

Required -

Prepare a bank reconciliation for the company for the month ended December 2019.

Prepare any journal entries that should be made based on the reconciliation prepared.

Reference no: EM132501422

Questions Cloud

6316ENG Power Electronics and Machine Drives Assignment : 6316ENG Power Electronics and Machine Drives Assignment Help and Solution, Griffith University - Assessment Writing Service - Analysis of Diode-Rectifier
Explain the importance of a substance use disorder counselor : Explain the importance of a substance use disorder counselor having an understanding of tolerance and withdrawal. What potential issues could arise.
Identify holidays from various cultures or religions : Identify holidays from various cultures/religions and discuss their origin, and practices associated with them. Are there holidays which are common to several
What type of family system is present : What type of family system is present? (Ambiguous, distorted, etc.) Explain. Which of Satir's patterns of communication does the individual with a substance.
Prepare a bank reconciliation for the company : Deposit by ABC Inc erroneously recorded to the company by the bank 486. Prepare a bank reconciliation for the company for the month ended December 2019
Why are social security benefits important : Why are social security benefits important? If you had government power how would you fix the Social Security crises that may occur in the future?
What is meant by autonomous and then explore the benefits : what is meant by 'autonomous' and then explore the benefits and challenges that autonomous vehicles may present in a future in which they are widely adopted
Explain how ethnocentrism and racism may influence the case : Identify a specific peer-reviewed article and explain how it could inform understanding of the problem/population, development of goals, or intervention
What ways that parents use technology to support their child : According to Margaret Nelson, what are the three ways that parents use technology to support their children? Describe each of these ways that technology is used

Reviews

Write a Review

Database Management System Questions & Answers

  Security issues relating to database management systems

Database Systems and Administration (ECM38IS) - Middle East College - Critically evaluate security issues relating to database management systems

  Perform an inner join on tables books and sources.

Perform a Left Outer Join using tables BOOKS and ORDER_LINES. Show all the ISBNs in the BOOKS table and any associated ISBNs in the ORDER_LINES table.

  Show the dependency diagram for each table

The dependency diagram in Figure indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram.

  Graph the mean performance of the two groups on graph paper

Psy 2317 Data Analysis Project- Perform the statistical procedures necessary to develop and document a conclusion about the mean differences between the two groups. Graph the mean performance of the two groups on graph paper.

  Sketch machine simulation by a standard turing machine

Consider a version of the standard Turing machine in which transitions can depend not only on the cell directly under the read-write head.

  Describe 4 software or hardware problems which will render

discuss 4 software or hardware problems that will render two hosts unable to use the tcpip protocol to communicate.

  Identify the primary keys in each table

In addition, transform your data model (your EERD created in phase 2 IP) into a logical model, to third normal form. Describe why each table is in third Normal.

  Show all columns and all records in the membertype table

Display the first name, last name, city, state, and phone number for every member with the initials A.C. that lives in California.

  Do the tables exhibit referential integrity

Do the tables exhibit referential integrity?  Yes or no, then explain.  Write not applicable if the table does not have a foreign key.

  Create database model using ms visio database model diagram

You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associ..

  Create an entity-relationship diagram

Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia

  Discuss considerations for implementing an database system

Discuss the considerations for implementing an operating and database system. Recommend the optimum system, considering the types of revenue and expense transactions for this company.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd