Create bank reconciliation using the adjusted balance method

Assignment Help Financial Accounting
Reference no: EM132645784

Your examination of the financial statements of MAGDALO Group Co. for the year ended December 31, 2020 you obtained the following information on the checking account of the company:

a. The bank statement on November 30, 2020 showed a balance of P15,300.

b. Among the bank credits in November was a customer's note for P5,000 collected for the account of the company which the company recognized in December among its receipts.

c. Included in the bank debits in November was a cost of checkbooks amounting to P60.

d. A check for P2,000 issued by MAGULO Group Co. in November was charged by the bank in error against MAGDALO Group Co. account.

e. You also ascertained that there were deposits in transit amounting to P4,000 and outstanding checks totaling P8,500 as of November 30, 2020.

f. The bank statement for the month of December showed total credits of P20,800 and total charges of P10,200.

g. Company books for December showed total receipts of P36,780 and disbursements of P20,360.

h. Bank debit memos for December were: No. 418 for service charges, P80 and No. 504 on a customer's returned check marked "Refer to Drawer" for P1,200.

i. On December 29, 2020 the company placed with the bank a customer's promissory note with a face value of P6,000 for collection. The company treated this note as part of its receipts although the bank was able to collect on the note only in January, 2020.

j. A check for P198 was recorded in the company cash payments books in December as P1,980.

REQUIRED:

Question 1. Make a bank reconciliation using the adjusted balance method.

Question 2. Compute for the following items:

a. Adjusted cash balance as of December 31, 2020

b. Unadjusted book balance November 30, 2020

c. Adjusted cash balance November 30, 2020

d. Deposit in transit as of December 31, 2020.

e. Outstanding Checks as of December 31, 2020

Question 3. Prepare the required adjusting journal entries.

Reference no: EM132645784

Questions Cloud

Mobile devices in society today has indeed become ubiquitous : We learn from the authors that, the use of mobile devices in our society today has indeed become ubiquitous.
Determine the total outstanding checks on december : Make a four-column proof of a cash reconciling bank balance and balance per books to the correct balance. determine the Total Outstanding checks on December
Reflective Paper and Practical Connection Paper : Summarizes what you feel are the most important or interesting concepts you have learned so far in this Cloud Computing course.
Explain the different types of health care plans : Create an educational brochure using Word on the different types of health care plans, including public and private, so that any consumer could understand.
Create bank reconciliation using the adjusted balance method : The bank statement on November 30, 2020 showed a balance of P15,300. Make a bank reconciliation using the adjusted balance method.
What is your reaction to change in your personal history : What is your reaction to change in your personal history? What personal tools do you implement to help yourself navigate change? The response must be typed.
Provide journal entries in the books of shelly ltd for june : Provide the journal entries in the books of Shelly Ltd for 30 June. Shelly Ltd pays its salaries fortnightly in arrears. The next pay day is Thursday 2 July.
Identify individual behaviors that seem to be problematic : Bob is a very intelligent, 25-year-old member of a religious organization based on Buddhism. Bob's working for this organization has caused considerable.
Information and communication technology : The recent advances in information and communication technology (ICT) has promoted the evolution of conventional computer-aided manufacturing industry

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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