9. 10. 11. 12. 13. 14. Paid the utility bill for the month, $1,800. Paid Daily Herald the amount due in transaction (6). Paid $40 of interest on the bank loan obtained in transaction (2). Paid employees' salaries, $5,760. Received $10,800 cash from customers billed in transaction (7). Paid income tax, $1,350. Journalize the transactions. (If no entry is required, select "No Entry" for the account titles and enter O for the a are automatically indented when amount is entered. Do not indent manually. List all debit entries before credit en Debit

9. 10. 11. 12. 13. 14. Paid the utility bill for the month, $1,800. Paid Daily Herald the amount due in transaction (6). Paid $40 of interest on the bank loan obtained in transaction (2). Paid employees' salaries, $5,760. Received $10,800 cash from customers billed in transaction (7). Paid income tax, $1,350. Journalize the transactions. (If no entry is required, select "No Entry" for the account titles and enter O for the a are automatically indented when amount is entered. Do not indent manually. List all debit entries before credit en Debit

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 5R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...

See similar textbooks

Similar questions

In March, T. Carter established Carter Delivery Service. The account headings are presented below. Transactions completed during the month of March follow. a. Carter deposited 25,000 in a bank account in the name of the business. b. Bought a used truck from Degroot Motors for 15,140, paying 5,140 in cash and placing the remainder on account. c. Bought equipment on account from Flemming Company, 3,450. d. Paid the rent for the month, 1,000, Ck. No. 3001 (Rent Expense). e. Sold services for cash for the first half of the month, 6,927 (Service Income). f. Bought supplies for cash, 301, Ck. No. 3002. g. Bought insurance for the truck for the year, 1,200, Ck. No. 3003. h. Received and paid the bill for utilities, 349, Ck. No. 3004 (Utilities Expense). i. Received a bill for gas and oil for the truck, 218 (Gas and Oil Expense). j. Sold services on account, 3,603 (Service Income). k. Sold services for cash for the remainder of the month, 4,612 (Service Income). l. Paid wages to the employees, 3,958, Ck. Nos. 30053007 (Wages Expense). m. Carter withdrew cash for personal use, 1,250, Ck. No. 3008. Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
On July 1, K. Resser opened Ressers Business Services. Ressers accountant listed the following chart of accounts: The following transactions were completed during July: a. Resser deposited 25,000 in a bank account in the name of the business. b. Bought tables and chairs for cash, 725, Ck. No. 1200. c. Paid the rent for the current month, 1,750, Ck. No. 1201. d. Bought computers and copy machines from Ferber Equipment, 15,700, paying 4,000 in cash and placing the balance on account, Ck. No. 1202. e. Bought supplies on account from Wigginss Distributors, 535. f. Sold services for cash, 1,742. g. Bought insurance for one year, 1,375, Ck. No. 1203. h. Paid on account to Ferber Equipment, 700, Ck. No. 1204. i. Received and paid the electric bill, 438, Ck. No. 1205. j. Paid on account to Wigginss Distributors, 315, Ck. No. 1206. k. Sold services to customers for cash for the second half of the month, 820. l. Received and paid the bill for the business license, 75, Ck. No. 1207. m. Paid wages to an employee, 1,200, Ck. No. 1208. n. Resser withdrew cash for personal use, 700, Ck. No. 1209. Required 1. Record the owners name in the Capital and Drawing T accounts. 2. Correctly place the plus and minus signs for each T account and label the debit and credit sides of the accounts. 3. Record the transactions in the T accounts. Write the letter of each entry to identify the transaction. 4. Foot the T accounts and show the balances. 5. Prepare a trial balance as of July 31, 20--. 6. Prepare an income statement for July 31, 20--. 7. Prepare a statement of owners equity for July 31, 20--. 8. Prepare a balance sheet as of July 31, 20--. LO 1, 2, 3, 4, 5, 6
On March 1 of this year, B. Gervais established Gervais Catering Service. The account headings are presented below. Transactions completed during the month follow. a. Gervais deposited 25,000 in a bank account in the name of the business. b. Bought a truck from Kelly Motors for 26,329, paying 8,000 in cash and placing the balance on account, Ck. No. 500. c. Bought catering equipment on account from Luigis Equipment, 3,795. d. Paid the rent for the month, 1,255, Ck. No. 501. e. Bought insurance for the truck for one year, 400, Ck. No. 502. f. Sold catering services for cash for the first half of the month, 3,012. g. Bought supplies for cash, 185, Ck. No. 503. h. Sold catering services on account, 4,307. i. Received and paid the heating bill, 248, Ck. No. 504. j. Received a bill from GC Gas and Lube for gas and oil for the truck, 128. k. Sold catering services for cash for the remainder of the month, 2,649. l. Gervais withdrew cash for personal use, 1,550, Ck. No. 505. m. Paid the salary of the assistant, 1,150, Ck. No. 506. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
On March 1 of this year, B. Gervais established Gervais Catering Service. The account headings are presented below. Transactions completed during the month follow. a. Gervais deposited 25,000 in a bank account in the name of the business. b. Bought a truck from Kelly Motors for 26,329, paying 8,000 in cash and placing the balance on account, Ck. No. 500. c. Bought catering equipment on account from Luigis Equipment, 3,795. d. Paid the rent for the month, 1,255, Ck. No. 501 (Rent Expense). e. Bought insurance for the truck for one year, 400, Ck. No. 502. f. Sold catering services for cash for the first half of the month, 3,012 (Catering Income). g. Bought supplies for cash, 185, Ck. No. 503. h. Sold catering services on account, 4,307 (Catering Income). i. Received and paid the heating bill, 248, Ck. No. 504 (Utilities Expense). j. Received a bill from GC Gas and Lube for gas and oil for the truck, 128 (Gas and Oil Expense). k. Sold catering services for cash for the remainder of the month, 2,649 (Catering Income). l. Gervais withdrew cash for personal use, 1,550, Ck. No. 505. m. Paid the salary of the assistant, 1,150, Ck. No. 506 (Salary Expense). Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
Journal entries and trial balance On August 1, 20Y7, Rafael Masey established Planet Realty, which completed the following transactions during the month: a. Rafael Masey transferred cash from a personal bank account to an account to be used for the business in exchange for common stock, 17,500. b. Purchased supplies on account, 2,300. c. Earned sales commissions, receiving cash, 13,300. d. Paid rent on office and equipment for the month, 3,000. e. Paid creditor on account, 1,150. f. Paid dividends, 1,800. g. Paid automobile expenses (including rental charge) for month, 1,500, and miscellaneous expenses, 400. h. Paid office salaries, 2,800. i. Determined that the cost of supplies used was 1,050. Instructions 1. Journalize entries for transactions (a) through (i), using the following account titles: Cash, Supplies, Accounts Payable, Common Stock, Dividends, Sales Commissions, Rent Expense, Office Salaries Expense, Automobile Expense, Supplies Expense, Miscellaneous Expense. Journal entry explanations may be omitted. 2. Prepare T accounts, using the account titles in (1). Post the journal entries to these accounts, placing the appropriate letter to the left of each amount to identify the transactions. Determine the account balances, after all posting is complete. Accounts containing only a single entry do not need a balance. 3. Prepare an unadjusted trial balance as of August 31, 20Y7. 4. Determine the following: a. Amount of total revenue recorded in the ledger. b. Amount of total expenses recorded in the ledger. c. Amount of net income for August. 5. Determine the increase or decrease in retained earnings for August.
In July of this year, M. Wallace established a business called Wallace Realty. The account headings are presented below. Transactions completed during the month follow. a. Wallace deposited 24,000 in a bank account in the name of the business. b. Paid the office rent for the current month, 650, Ck. No. 1000. c. Bought office supplies for cash, 375, Ck. No. 1001. d. Bought office equipment on account from Dellos Computers, 6,300. e. Received a bill from the City Crier for advertising, 455. f. Sold services for cash, 3,944. g. Paid on account to Dellos Computers, 1,500, Ck. No. 1002. h. Received and paid the bill for utilities, 340, Ck. No. 1003. i. Paid on account to the City Crier, 455, Ck. No. 1004. j. Paid truck expenses, 435, Ck. No. 1005. k. Wallace withdrew cash for personal use, 1,500, Ck. No. 1006. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
In April, J. Rodriguez established an apartment rental service. The account headings are presented below. Transactions completed during the month of April follow. a. Rodriguez deposited 70,000 in a bank account in the name of the business. b. Paid the rent for the month, 2,000, Ck. No. 101 (Rent Expense). c. Bought supplies on account, 150. d. Bought a truck for 23,500, paying 2,500 in cash and placing the remainder on account. e. Bought insurance for the truck for the year, 2,400, Ck. No. 102. f. Sold services on account, 4,700. g. Bought office equipment on account from Stern Office Supply, 1,250. h. Sold services for cash for the first half of the month, 8,250. i. Received and paid the bill for utilities, 280, Ck. No. 103. j. Received a bill for gas and oil for the truck, 130. k. Paid wages to the employees, 2,680, Ck. Nos. 104106. l. Sold services for cash for the remainder of the month, 3,500. m. Rodriguez withdrew cash for personal use, 4,000, Ck. No. 107. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
Journal entries and trial balance On October 1, 20Y6, Jay Crowley established Affordable Realty, which completed the following transactions during the month: a. Jay Crowley transferred cash from a personal bank account to an account to be used for the business in exchange for common stock, 40,000. b. Paid rent on office and equipment for the month, 4,800. c. Purchased supplies on account, 2,150. d. Paid creditor on account, 1,100. e. Earned sales commissions, receiving cash, 18,750. f. Paid automobile expenses (including rental charge) for month, 1,580, and miscellaneous expenses, 800. g. Paid office salaries, 3,500. h. Determined that the cost of supplies used was 1,300. i. Paid dividends, 1,500. Instructions 1. Journalize entries for transactions (a) through (i), using the following account titles: Cash, Supplies, Accounts Payable, Common Stock, Dividends, Sales Commissions, Rent Expense, Office Salaries Expense, Automobile Expense, Supplies Expense, Miscellaneous Expense. Explanations may be omitted. 2. Prepare T accounts, using the account titles in (1). Post the journal entries to these accounts, placing the appropriate letter to the left of each amount to identify the transactions. Determine the account balances after all posting is complete. Accounts containing only a single entry do not need a balance. 3. Prepare an unadjusted trial balance as of October 31, 20Y6. 4. Determine the following: a. Amount of total revenue recorded in the ledger. b. Amount of total expenses recorded in the ledger. c. Amount of net income for October. 5. Determine the increase or decrease in retained earnings for October.
P. Schwartz, Attorney at Law, opened his office on October 1. The account headings are presented below. Transactions completed during the month follow. a. Schwartz deposited 25,000 in a bank account in the name of the business. b. Bought office equipment on account from QuipCo, 9,670. c. Schwartz invested his personal law library, which cost 2,800. d. Paid the office rent for the month, 1,700, Ck. No. 2000. e. Bought office supplies for cash, 418, Ck. No. 2001. f. Bought insurance for two years, 944, Ck. No. 2002. g. Sold legal services for cash, 8,518. h. Paid the salary of the part-time receptionist, 1,820, Ck. No. 2003. i. Received and paid the telephone bill, 388, Ck. No. 2004. j. Received and paid the bill for utilities, 368, Ck. No. 2005. k. Sold legal services for cash, 9,260. l. Paid on account to QuipCo, 2,670, Ck. No. 2006. m. Schwartz withdrew cash for personal use, 2,500, Ck. No. 2007. Required 1. Record the transactions and the balance after each transaction. 2. Total the left side of the accounting equation (left side of the equal sign), then total the right side of the accounting equation (right side of the equal sign). If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
In April, J. Rodriguez established an apartment rental service. The account headings are presented below. Transactions completed during the month of April follow. a. Rodriguez deposited 70,000 in a bank account in the name of the business. b. Paid the rent for the month, 2,000, Ck. No. 101 (Rent Expense). c. Bought supplies on account, 150. d. Bought a truck for 23,500, paying 2,500 in cash and placing the remainder on account. e. Bought insurance for the truck for the year, 2,400, Ck. No. 102. f. Sold services on account, 4,700 (Service Income). g. Bought office equipment on account from Stern Office Supply, 1,250. h. Sold services for cash for the first half of the month, 8,250 (Service Income). i. Received and paid the bill for utilities, 280, Ck. No. 103 (Utilities Expense). j. Received a bill for gas and oil for the truck, 130 (Gas and Oil Expense). k. Paid wages to the employees, 2,680, Ck. Nos. 104106 (Wages Expense). l. Sold services for cash for the remainder of the month, 3,500 (Service Income). m. Rodriguez withdrew cash for personal use, 4,000, Ck. No. 107. Required 1. In the equation, write the owners name above the terms Capital and Drawing. 2. Record the transactions and the balance after each transaction. Identify the account affected when the transaction involves revenues or expenses. 3. Write the account totals from the left side of the equals sign and add them. Write the account totals from the right side of the equals sign and add them. If the two totals are not equal, check the addition and subtraction. If you still cannot find the error, re-analyze each transaction.
Prepare journal entries to record the following transactions for the month of July: A. on first day of the month, paid rent for current month, $2,000 B. on tenth day of month, paid prior month balance due on accounts, $3,100 C. on twelfth day of month, collected cash for services provided, $5,500 D. on twenty-first day of month, paid salaries to employees, $3,600 E. on thirty-first day of month, paid for dividends to shareholders, $800
Kelly Pitney began her consulting business, Kelly Consulting, on April 1, 2018. The accounting cycle for Kelly Consulting for April, including financial statements, was illustrated in this chapter. During May, Kelly Consulting entered into the following transactions: May 3. Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, 4,500. 5. Received cash from clients on account, 2,450. 9. Paid cash for a newspaper advertisement, 225. 13. Paid Office Station Co. for part of the debt incurred on April 5, 640. 15. Recorded services provided on account for the period May 115, 9,180. 16. Paid part-time receptionist for two weeks salary including the amount owed on April 30, 750. 17. Recorded cash from cash clients for fees earned during the period May 1-16, 8,360. Record the following transactions on Page 6 of the journal: 20. Purchased supplies on account, 735. 21. Recorded services provided on account for the period May 16-20,4,820. 25. Recorded cash from cash clients for fees earned for the period May 17- 23, 7,900. 27. Received cash from clients on account, 9,520. 28. Paid part-time receptionist for two weeks salary, 750. 30. Paid telephone bill for May, 260. 31. Paid electricity bill for May, 810. 31. Recorded cash from cash clients for fees earned for the period May 26-31, 3,300. 31. Recorded services provided on account for the remainder of May, 2,650. 31. Paid dividends, 10,500. Instructions 1. The cl1art of accounts for Kelly Consulting is shown in Exhibit 9, and the post-closing trial balance as of April 30, 2018, is shown in Exhibit 17. For each account in the post-closing trial balance, enter the balance in the appropriate Balance column of a four-column account. Date the balances May 1, 2018, and place a check mark () in the Posting Reference column. Journalize each of the May transactions in a two-column journal starting on Page 5 of the journal and using Kelly Consultings chart of accounts. (Do not insert the account numbers in the journal at this time.) 2. Post the journal to a ledger of four-column accounts. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6). (A) Insurance expired during May is 275. (B) Supplies on hand on May 31 are 715. (C) Depreciation of office equipment for May is 330. (D) Accrued receptionist salary on May 31 is 325. (E) Rent expired during May is 1,600. (F) Unearned fees on May 31 are 3,210. 5. (Optional) Enter the unadjusted trial balance on an end-of-period spreadsheet and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 7 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a retained earnings statement, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 8 of d1e journal. (Income Summary is account #34 in d1e chart of accounts.) Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. 10. Prepare a post-closing trial balance.