Sarawat company provided the following data for the month of February:Use One MS Excel file for this assessmenttask.Use ONE TAB sheet for every Test number.In presenting your answers use VERTICALORIENTATION, where answers will be presented vertically or going downNOT horizontally.Balance per book, February 28Collection on February 28 but undepositedNSF Check received from a customer returned by the bankon March 5 with the February bank statementCheck outstanding on February 28Balance per bank, February 28Bank debit memo for safety deposit boxrental notrecorded by depositorA creditor check for P30,000 was incorrectly recorded inthe depositor's book asA customer check for P200,000 was recorded by thedepositor asThe depositor neglected to make an entry in its books foracheck drawn in payment of an account payableTask Requirements:Your taskis to prepare the following:P3,130,000550,00050,000650,0003,500,0005,000300,00020,000125,0001. Aformal Bank Reconciliation Statement (Adjusted Balance Method)Start with the Unadjusted Book Balance to Adjusted Book balance• Observe proper heading.2. Adjusting or correcting entries

Sarawat company provided the following data for the month of February: Use One MS Excel file for this assessmenttask. • Use ONE TAB sheet for every Test number. In presenting your answers use VERTICALORIENTATION, where answers will be present NOT horizontally. lance per book, February 28 llection on February 28 but undeposited F Check received from a customer returned by the bank March 5 with the February bank statement eck outstanding on February 28 lance per bank, February 28 nk debit memo for safety deposit boxrental not corded by depositor creditor check for P30,000 was incorrectly recorded in edepositor's book as customer check for P200,000 was recorded by the positor as e depositor neglected to make an entry in its books for a P3,130,000 550,000 50,000 650,000 3,500,000 5,000 300,000 20,000 125,000

Sarawat company provided the following data for the month of February: Use One MS Excel file for this assessmenttask. • Use ONE TAB sheet for every Test number. In presenting your answers use VERTICALORIENTATION, where answers will be present NOT horizontally. lance per book, February 28 llection on February 28 but undeposited F Check received from a customer returned by the bank March 5 with the February bank statement eck outstanding on February 28 lance per bank, February 28 nk debit memo for safety deposit boxrental not corded by depositor creditor check for P30,000 was incorrectly recorded in edepositor's book as customer check for P200,000 was recorded by the positor as e depositor neglected to make an entry in its books for a P3,130,000 550,000 50,000 650,000 3,500,000 5,000 300,000 20,000 125,000

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter5: Bank Reconciliation (bankrec)

Section: Chapter Questions

Problem 3R

See similar textbooks

Similar questions

Catherines Cookies has a beginning balance in the Accounts Payable control total account of $8,200. In the cash disbursements journal, the Accounts Payable column has total debits of $6,800 for November. The Accounts Payable credit column in the purchases journal reveals a total of $10,500 for the current month. Based on this information, what is the ending balance in the Accounts Payable account in the general ledger?
The transactions completed by AM Express Company during March, the first month of the fiscal year, were as follows: Instructions 1. Enter the following account balances in the general ledger as of March 1: 2. Journalize the transactions for March, using the following journals similar to those illustrated in this chapter: single-column revenue journal (p. 35), cash receipts journal (p. 31), purchases journal (p. 37, with columns for Accounts Payable, Maintenance Supplies, Office Supplies, and Other Accounts), cash payments journal (p. 34), and twocolumn general journal (p. 1). Assume that the daily postings to the individual accounts in the accounts payable subsidiary ledger and the accounts receivable subsidiary ledger have been made. 3. Post the appropriate individual entries to the general ledger. 4. Total each of the columns of the special journals and post the appropriate totals to the general ledger; insert the account balances. 5. Prepare a trial balance.
Maddie Inc. has the following transactions for its first month of business. A. What are the individual account balances, and the total balance, in the accounts receivable subsidiary ledger? B. What is the balance in the accounts receivable general ledger (control) account?
On June 30, Isner Inc.s bookkeeper is preparing to close the books for the month. The accounts receivable control total shows a balance of $550, but the accounts receivable subsidiary ledger shows total account balances of $850. The accounts receivable subsidiary ledger is shown here. Can you help find the mistake?
The transactions completed by Revere Courier Company during December, the first month of the fiscal year, were as follows: Instructions 1. Enter the following account balances in the general ledger as of December 1: 2. Journalize the transactions for December, using the following journals similar to those illustrated in this chapter: cash receipts journal (p. 31), purchases journal (p. 37, with columns for Accounts Payable, Maintenance Supplies, Office Supplies, and Other Accounts), single-column revenue journal (p. 35), cash payments journal (p. 34), and two-column general journal (p. 1). Assume that the daily postings to the individual accounts in the accounts payable subsidiary ledger and the accounts receivable subsidiary ledger have been made. 3. Post the appropriate individual entries to the general ledger. 4. Total each of the columns of the special journals and post the appropriate totals to the general ledger; insert the account balances. 5. Prepare a trial balance.
For each of the following, indicate if the statement reflects an input component, output component, or storage component of the accounting information system for a bank. A. Online customer check ordering system. B. Approved loan applications. C. Report of customers with savings accounts over $5,000. D. Desktop hard drive on computer used by bank presidents administrative assistant. E. List of the amount of money withdrawn from all of the banks ATMs on a given day.
Catherines Cookies has a beginning balance in the Accounts Receivable control total account of $8,200. $15,700 was credited to Accounts Receivable during the month. In the sales journal, the Accounts Receivable debit column shows a total of $12,000. What is the ending balance of the Accounts Receivable account in the general ledger?
The following transactions were completed by Hammond Auto Supply during January, which is the first month of this fiscal year. Terms of sale are 2/10, n/30. The balances of the accounts as of January 1 have been recorded in the general ledger in your Working Papers or in CengageNow. Hammond Auto Supply does not track cash sales by customer. If you are using the form-based approach with QuickBooks or general ledger, select Cash Sales as the customer for all cash sales transactions. Required 1. Record the transactions for January using a general journal, page 1. Assume the periodic inventory method is used. If using QuickBooks, record transactions using either the journal entry method or the forms-based approach as directed by your instructor. The chart of accounts is as follows: 2. Post daily all entries involving customer accounts to the accounts receivable ledger. 3. Post daily all entries involving creditor accounts to the accounts payable ledger. 4. Post daily the general journal entries to the general ledger. Write the owners name in the Capital and Drawing accounts. If using QuickBooks or general ledger, ignore Steps 2, 3, and 4. 5. Prepare a trial balance. 6. Prepare a schedule of accounts receivable (A/R Aging Detail report in QuickBooks) and a schedule of accounts payable (A/P Summary Detail report in QuickBooks). Do the totals equal the balances of the related controlling accounts?
The following transactions were completed by Hammond Auto Supply during January, which is the first month of this fiscal year. Terms of sale are 2/10, n/30. The balances of the accounts as of January 1 have been recorded in the general ledger in your Working Papers or in CengageNow. Hammond Auto Supply does not track cash sales by customer. If you are using the form-based approach with QuickBooks or general ledger, select Cash Sales as the customer for all cash sales transactions. Required 1. Record the transactions for January using a sales journal, page 73; a purchases journal, page 56; a cash receipts journal, page 38; a cash payments journal, page 45; and a general journal, page 100. Assume the periodic inventory method is used. 2. Post daily all entries involving customer accounts to the accounts receivable ledger. 3. Post daily all entries involving creditor accounts to the accounts payable ledger. 4. Post daily those entries involving the Other Accounts columns and the general journal to the general ledger. Write the owners name in the Capital and Drawing accounts. 5. Add the columns of the special journals and prove the equality of the debit and credit totals on scratch paper. 6. Post the appropriate totals of the special journals to the general ledger. 7. Prepare a trial balance. 8. Prepare a schedule of accounts receivable and a schedule of accounts payable. Do the totals equal the balances of the related controlling accounts?
Complex Balance Sheet Presented below is the unaudited balance sheet as of December 31, 2019, prepared by Zeus Manufacturing Corporations bookkeeper. Your company has been engaged to perform an audit, during which you discover the following information: 1. Checks totaling 14,000 in payment of accounts payable were mailed on December 31, 2019, but were not recorded until 2020. Late in December 2019, the bank returned a customers 2,000 check marked NSF, but no entry was made. Cash includes 100,000 restricted for building purposes. 2. Included in accounts receivable is a 30,000 note due on December 31, 2022, from Zeuss president. 3. During 2019, Zeus purchased 500 shares of common stock of a major corporation that supplies Zeus with raw materials. Total cost of this stock was 51,300, and fair value on December 31, 2019, was 51,300. Zeus plans to hold these shares indefinitely. 4. Treasury stock was recorded at cost when Zeus purchased 200 of its own shares for 32 per share in May 2019. This amount is included in investments. 5. On December 31, 2019, Zeus borrowed 500,000 from a bank in exchange for a 10% note payable, manning December 31, 2024. Equal principal payments are due December 31 of each year beginning in 2020. This note is collateralized by a 250,000 tract of land acquired as a potential future building site, which is included in land. 6. The mortgage payable requires 50,000 principal payments, plus interest, at the end of each month. Payments were made on January 31 and February 28, 2020. The balance of this mortgage was due June 30, 2020. On March 1, 2020, prior to issuance of the audited financial statements, Zeus consummated a non-cancelable agreement with the lender to refinance this mortgage. The new terms require 100,000 annual principal payments, plus interest, on February 28 of each year, beginning in 2021. The final payment is due February 28, 2028. 7. The lawsuit liability will be paid in 2020. 8. Of the total deferred tax liability; 5,000 is considered a current liability. 9. The current income tax expense reported in Zeuss 2019 income statement was 61,200. 10. The company was authorized to issue 100,000 shares of 50 par value common stock.
Sage Learning Centers was established on July 20 to provide educational services. The services provided during the remainder of the month are as follows: Instructions 1. Journalize the transactions for July, using a single-column revenue journal and a two-column general journal. Post to the following customer accounts in the accounts receivable ledger and insert the balance immediately after recording each entry: D. Chase; J. Dunlop; F. Mintz; T. Quinn; K. Tisdale. 2. Post the revenue journal and the general journal to the following accounts in the general ledger, inserting the account balances only after the last postings: 3. a. What is the sum of the balances of the customer accounts in the subsidiary ledger at July 31? b. What is the balance of the accounts receivable controlling account at July 31? 4. Assume Sage Learning Centers began using a computerized accounting system to record the sales transactions on August 1. What are some of the benefits of the computerized system over the manual system?
In the process of your examination of the financial statements of the Malu-oy Company for the year ended December 31, 20X6, you obtained the following data on its current account. The bank statement on November 30, 20X6 showed a balance of P76,500. Among the bank credits in November was a customer’s note for P25,000 collected for the account of the company which the company recognized in December among its receipts. Included on the bank debits were cost of checkbooks amounting to P300 and a P10,000 check which was charged by the bank in error against Malu-oy Company account. Also in November, you ascertained that there were deposits in transit amounting to P20,000 and outstanding checks totaling P42,500. The bank statement for the month of December showed total credit of P104,000 and total charges of P51,000. The company’s books for December showed total receipts of P183,900, disbursements of P101,800 and a balance of P121,400. Bank debit memos for December were: No. 14334 for service…