Make column bank reconciliation for the month of December

Reference no: EM132654736

Question - In connection with your examination, the MQM company presented to you the following information regarding its Cash in Bank account for the month of December 2018:

a. Balances per bank statements: November 30, P215,600, and December 31, P230,400

b. Balances of cash in bank account in company's books: November 30, P165,450 and December 31, P226,800.

c. Total receipts per books were P2,221,900 of which P12,100 was paid on cash to a creditor on December 24.

d. Total charges in the bank statement during December were P2,189,700

e. Undeposited receipts were: November 30, P90,600 and December 31, P101,200.

f. Outstanding checks were: November 30, P26,750, and December 31, P19,300 of which a check for P5,000 was certified by the bank on December 26.

g. NSF checks returned, recorded as reduction of cash receipts, were"

- Returned by bank on December, recorded also in December P10,400.

- Returned by bank on December but recorded in January P8,600.

h. Collections by bank not recorded by company were P121,500 in November and P116,400 in December.

i. Bank service charges not entered in company's books were: November 30, P7,500 and December 31, P4,200.

j. A check for P9,500 of QMQ company was charged to MQM company.

k. A check drawn for P8,400 was erroneously entered in the books as P4,800.

Required - Make 4-column bank reconciliation for the month of December using adjusted balance method and prepare the necessary adjusting entries as of December 31, 2018.

Reference no: EM132654736

Questions Cloud

Compute and calculate gross profit : Calculate gross profit if sales are $90,000, inventory at beginning is $5,600, purchases of inventory are $30,500 and inventory at end is $4,900.

Differences between liberals and conservatives : What is the convenient short-hand Craig uses to understand the differences between liberals and conservatives? Define spatial issues and give an example.

Explain the benefits of risk management : Identify and explain the benefits of risk management mentioned in the Indian case study above. Discuss other benefits of Enterprise Risk Management

Identify the areas that will be searched : Identify the areas that will be searched and what type evidence you might expect to find in those areas. Create a set of instructions for all of the department

Make column bank reconciliation for the month of December : Make 4-column bank reconciliation for the month of December using adjusted balance method and prepare the necessary adjusting entries as of December

What group of user that is most likely to require accounting : What the group of users that is most likely to require accounting information to assess the ability of a business to pay interest and repay a loan is

Find the conclusion that a company generates in net profit : Find the conclusion that a company 'generates $2.50 in net profit for every $1 of sales' is a(n). description of how effective the company is.

Discuss the civilianization of police organizations : Discuss the civilianization of police organizations. What are the reasons for ncivilianization? What would be the arguments against civilianization.

Determining the value of the fund today : Mike who is 6 years old just received a trust fund that will be worth $25,000 when he turns 21. If the fud earns .11 interest compounded

User Account

All Pages