On August 28 the bank statement shows a return item of Php100 plus a related bankfee of Php10. The return item is a customer's check that was returned because ofinsufficient funds.Item 3Item 4The bank statement shows a charge of Php80 for check printing on August 20.The bank statement shows that Php8 was added to the checking account on August 31for interest earned by the company during the month of August.Item 5The bank statement shows that a note receivable of Php1,000 was collected by thebank on August 29 and was deposited into the company's account. On the same day,the bank withdrew Php40 from the company's account as a fee for collecting the notereceivable.Item 6Item 7The company's Cash account at the end of August shows a balance of Php967.Item 8During the month of August, the company wrote checks totaling more than Php50,000.As of August 31 Php3,021 of the checks written in August had not yet cleared the bankand Php200 of checks written in June had not yet cleared the bank.Item 9The Php1,450 of cash received by the company on August 31 was recorded on thecompany's books as of August 31. However, the Php1,450 of cash receipts wasdeposited at the bank on the morning of September 1.Item 10On August 29 the company's Cash account shows cash sales of Php145. The bankstatement shows the amount deposited was actually Php154. The company reviewedthe transactions and found that Php154 was the correct amount.Requirements: Prepare a bank reconciliation statement of the given information above. Activity 3.3 Prepare MeItem 1The bank statement for August 2014 shows an ending balance of Php3,490.Item 2On August 31 the bank statement showed charges of Php35 for the service charge formaintaining the checking account.10

A bank reconciliation statement is the statement in which company matches its cash balance as per…

Answered: Prepare a bank reconciliation statement…

Business

Accounting

Prepare a bank reconciliation statement of the given information above.

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter4: Internal Control And Cash

Section: Chapter Questions

Problem 21CE: Cornerstone Exercise 4-21 Cash Over and Short On a recent day, Pence Company obtained the following...

See similar textbooks

Similar questions

(Appendix 3.1) Cash-Basis Accounting Puntarelli Contracting keep its accounting records on a cash basis during the year. At year end, it adjusts its books to the accrual basis for preparing its financial statements. At the end of 2018, Puntarelli reported the following balance sheet items. It is now the end of 2019. The companys checkbook shows a balance of 4,700, which includes cash receipts from customers of 51,300 and cash payments of 49,300. An examination of the cash payments shows that: (1) 30,600 was paid to suppliers, (2) 12,700 was paid for other operating costs (including 7,200 paid on January 1 for 2 years annual rent), and (3) 6,000 was withdrawn by T. Puntarelli. On December 51, 2019, (1) customers owed Puntarelli Contracting 55,900, (2) Puntarelli owed suppliers and employees 7,000 and 900, respectively, and (3) the ending inventory was 6,300. Puntarelli is depreciating the equipment using straight line depreciation over a 10-year life (no residual value). Required: 1. Using accrual based accounting, prepare a 2019 income statement (show supporting calculations). 2. Using accrual-based accounting, prepare a December 31, 2019, balance sheet (show supporting calculations).
Comprehensive (Appendix 3.1) Dawson OConnor is the owner of Miller Island Sales, a distributor of fishing supplies. The following is the balance sheet of the company as of December 31, 2018: Dawson keeps very few records and has asked you to help him prepare the 2019 financial statements for Miller Island Sales. An analysis of the 2019 cash transactions recorded in the companys checkbook indicates deposits and checks as follows: Other information about the company is as follows: 1. Accounts receivable at December 31, 2019; 9,200. 2. Accounts payable at December 31: 3. Salaries payable at December 31, 2019, 1,800. 4. Equipment is depreciated by the straight-line method over a 10-year life. The equipment purchased in 2019 was acquired on July 1. All of the equipment will have zero salvage value at the end of its useful life. 5. Interest payable at December 31. 2019: 140. 6. The company uses a periodic inventory system Inventory at December 31, 2019: 17,400. Required: 1. Prepare a worksheet to summarize the transactions and adjustments of Miller Island Sales for 2019. (Hint: Include debit and credit columns for both transactions and adjustments.) 2. Prepare a 2019 income statement and a balance sheet as of December 31, 2019. (Contributed by Waller A. Parker)
Miller Enterprises deposits the cash received during each day at the end of the day. Miller deposited $48,287 on October 3 and $50,116 on October 4. Cash register records and other documents E supporting the deposits are summarized as follows: 10.8 10 Cash sale: $36,690 $49,310 @ Collections on account 10,875 9,813 Total receipts $41565 $541123 mn: HUI Required: 1. Calculate the amount 0? cash over or cash shun for each day. 2. Prepare the journal entry to record the receipt and deposit of cash on October 3. 3. Prepare the journal entry to record the receipt and deposit of cash on October 4. 4. CONCEPTUAL CONNECTION If you were the manager with responsibility over the cash registers. how would you use this information?
Cornerstone Exercise 4-21 Cash Over and Short On a recent day, Pence Company obtained the following data from its cash registers: Pence deposits its cash receipts in its bank account daily. Required: Prepare a journal entry to record these cash sales.
Hawk Enterprises identified the following items on its January,r reconciliaLion that may require adjusting entries: a. A deposit of $1,190 was recorded in Hawks accounting records. but not on the January 31 bank statement. b. A check for $3.31 was outstanding at January 31. c. Included with the bank statement was a check for $560 written by Eagle Corporation. The bank had in error, deducted this check from Hawks account. d. Bank service charges were $371. e. An NSF check written by one of Hawks customers in the amount of $1,150 was returned by the bank with Hawks bank statement. This customer was paying for merchandise originally purchased on account. Required: For each of these five items, prepare an adjusting entry for Hawks jaumai1 if any is required.
Multiple-step income statement and report form of balance sheet The following selected accounts and their current balances appear in the ledger of Clairemont Co. for the fiscal year ended May 31, 2016: Instructions 1. Prepare a multiple-step income statement. 2. Prepare a statement of owners equity. 3. Prepare a report form of balance sheet, assuming that the current portion of the note payable is 50,000. 4. Briefly explain (a) how multiple-step and single-step income statements differ and (b) how report-form and account-form balance sheets differ.
Continuing Problem 4.Total of Debit column: 40,750 The transactions completed by PS Music during June 20Y5 were described .it the end of Chapter 1. The following transactions were completed during July, the second month of businesss operations: July 1. Peyton Smith made an additional investment k PS Music in exchange for common stock by depositing 5,000 in PS Mu wet checking account. 1.Instead of continuing to share office space with a local real estate agency. Peyton decided to rent office space near a local musk store, Paid rent for July, 1,750. 1.Paid a premium of 2,700 for a comprehensive insurance policy covering liability, theft and fire. The policy covers a one year period. 2.Received 1,000 on account 3. On behalf of PS Musk, Peyton signed a contract with a local radio station. KXMD, to provide guest spots for the next three months. The contract requires PS Musk to provide a guest disc jockey for 80 hours per month for a monthly fee of 3,600. Any additional hours beyond 80 will be billed to KXMD at 40 per hour. In accordance with the contract Peyton received 7,200 from KXMD as an advance payment for the first two months. 3.Paid 2SO on account 4.Paid an attorney 900 for reviewing the July 3 contract with KXMD. (Record as Miscellaneous Expense.) 5.Purchased office equipment on account from Office Mart. 7,500. 8.Paid for a newspaper advertisement 200. 11.Received 1.000 for serving as a disc jockey for a party. 13.Paid 700 to a local audio electronics store for rental of digital recording equipment 14.Paid wages of 1,200 to receptionist and part-time assistant. Enter the following transactions on Pane 2 of the two-column journal: 16.Received 2,000 for serving as a disc jockey for a wedding reception. 18.Purchased supplies on account 850 21.Paid 620 to Upload Musk for use of its current musk demos in making various musk sets. 22.Paid 800 to a local radio station to advertise the services of PS Music twice daily for the remainder of July. 23.Served as disc jockey for a party for 2,500 Received 750, with the remainder due August 4.20YS. 27.Paid electric Ml 915. 28.Paid wages of 1,200 to receptionist and part-time assistant. 29.Paid miscellaneous expenses, 540. 30.Served as a disc jockey for a charity ball for 1,500, Received S00 with the remainder due on August 9. 20Y5. 31.Received 3,000 for serving as a disc jockey for a party. 31.Paid 1.400 royalties (musk expense) to National Musk Clearing for use of various artists music during July. 31. Paid dividends, 1,250. PS Musics chart of accounts and the balance of accounts as of July 1, 20Y5 (all normal balances), are as follows: 11 Cash 3,920 12 Accounts Receivable 1,000 14 Supplies 170 15 Prepaid Insurance 17 Office Equipment 21 Accounts Payable 250 23 Unearned Revenue 31 Common Stock 4.000 33 Dividends 500 41 Fees Earned 6,200 50 Wages Expense 400 51 Office Rent Expense 800 52 Equipment Rent Expense 67S 53 Utilities Expense 300 54 Music Expense 1.590 55 Advertising Expense 500 56 Supplies Expense 180 59 Miscellaneous Expense 415 Instructions 1. Enter the July 1, 20Y5, account balances in the appropriate balance column of a four-column account. Write Balance in the Item column, and place a check mark () in the Posting Reference column. (Hint: Verify the equality of the debit and credit balances in the ledger before proceeding with the next instruction.) 2. Analyze and journalize each transaction in a two-column journal beginning on Page 1, omitting journal entry explanations. 3. Post the journal to the ledger, extending the account balance to the appropriate balance column after each posting. 4. Prepare an unadjusted trial balance as of July 31, 20Y5.
Case 1-74 Comparative Analysis: Under Armour, lnc., versus Columbia Sportswear Refer to the 10-K reports of Under Armour, Inc., and Columbia Sportswear that are available for download from the companion website at CengageBrain.com Required: Answer the following questions: What were the major sources and uses of cash for each company?