Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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?arrow_forwardThe 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?arrow_forwardThe 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?arrow_forward
- The following transactions were completed by Yang Restaurant Equipment during January, 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. Yang Restaurant Equipment 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. 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 Aging Detail report in QuickBooks). Do the totals equal the balances of the related controlling accounts? If using QuickBooks or general ledger, ignore Steps 2, 3, and 4.arrow_forwardThe following transactions were completed by Yang Restaurant Equipment during January, 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. Yang Restaurant Equipment 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 91; a purchases journal, page 74; a cash receipts journal, page 56; a cash payments journal, page 63; and a general journal, page 119. 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?arrow_forwardHappy Tails Inc. has a September 1, 20Y4, accounts payable balance of 620, which consists of 320 due Labradore Inc. and 300 due Meow Mart Inc. Transactions related to purchases and cash payments completed by Happy Tails Inc. during the month of September 20Y4 are as follows: a. Prepare a purchases journal and a cash payments journal to record these transactions. The forms of the journals are similar to those used in the text. Place a check mark () in the Post. Ref. column to indicate when the accounts payable subsidiary ledger should be posted. Happy Tails Inc. uses the following accounts: b. Prepare a listing of accounts payable creditor balances on September 30, 20Y4. Verify that the total of the accounts payable creditor balances equals the balance of the accounts payable controlling account on September 30, 20Y4. c. Why does Happy Tails Inc. use a subsidiary ledger for accounts payable?arrow_forward
- Transactions related to purchases and cash payments completed by Wisk Away Cleaning Services Inc. during the month of May 20Y5 are as follows: Prepare a purchases journal and a cash payments journal to record these transactions. The forms of the journals are similar to those illustrated in the text. Place a check mark () in the Post. Ref. column to indicate when the accounts payable subsidiary ledger should be posted. Wisk Away Cleaning Services Inc. uses the following accounts:arrow_forwardTransactions related to revenue and cash receipts completed by Sycamore Inc. during the month of March 20Y8 are as follows: Prepare a single-column revenue journal and a cash receipts journal to record these transactions. Use the following column headings for the cash receipts journal: Fees Earned Cr., Accounts Receivable Cr., and Cash Dr. Place a check mark () in the Post. Ref. column to indicate when the accounts receivable subsidiary ledger should be posted.arrow_forwardCASH PAYMENTS TRANSACTIONS Kay Zembrowski operates a retail variety store. The books include a general journal and an accounts payable ledger. Selected account balances on May 1 are as follows: The following transactions are related to cash payments for the month of May: May 1Issued Check No. 326 in payment of May rent (Rent Expense), 2,600. 4Issued Check No. 327 to Cortez Distributors in payment of merchandise purchased on account, 4,200, less a 3% discount. Check was written for 4,074. 7Issued Check No. 328 to Indra Velga in partial payment of merchandise purchased on account, 6,200. A cash discount was not allowed. 11Issued Check No. 329 to Toy Corner for merchandise purchased on account, 4,600, less a 1% discount. Check was written for 4,554. 15Issued Check No. 330 to County Power and Light (Utilities Expense), 1,500. 19Issued Check No. 331 to Builders Warehouse for a cash purchase of merchandise, 3,500. 25Issued Check No. 332 to Troutman Outlet for merchandise purchased on account, 4,400, less a 2% discount. Check was written for 4,312. May 30Issued Check No. 333 to Rapid Transit Company for freight charges on merchandise purchased (Freight-In), 800. 31Issued Check No. 334 to City Merchants for a cash purchase of merchandise, 2,350. Required 1. Enter the transactions starting with page 9 of a general journal. 2. Post from the general journal to the general ledger and the accounts payable ledger. Use general ledger account numbers as shown in the chapter.arrow_forward
- 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.arrow_forwardYour company paid rent of $1,000 for the month with check number 1245. Which journal would the company use to record this? A. sales journal B. purchases journal C. cash receipts journal D. cash disbursements journal E. general journalarrow_forwardA customer just charged $150 of merchandise on the companys own charge card. Which special journal would the company use to record this transaction? A. sales journal B. purchases journal C. cash receipts journal D. cash disbursements journal E. general journalarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY