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
Videos
Textbook Question
Chapter 1, Problem 1R
On June 1 of the current year, Wilson Wood opened Woodyʼs Web Services. This sole proprietorship had the following transactions during June.
- a. Opened a business checking account and made a deposit, $9,000.
- b. Paid rent for June for office space and computer equipment, $3,000.
- c. Purchased office supplies (stamps, pens, etc.) on account, $1,980.
- d. Received cash for services rendered, $4,500.
- e. Paid creditor for office supplies purchased on account, $1,400.
- f. Purchased office supplies for cash, $420.
- g. Billed clients for consultations performed on account, $4,600.
- h. Paid monthly internet service bill of $360.
- i. Paid the secretaryʼs salary of $2,400.
- j. Returned $300 of office supplies purchased in transaction f. Received a full refund.
- k. Received cash from clients previously billed, $3,000.
- l. Cash was withdrawn for ownerʼs personal use, $2,000.
REQUIREMENT
1. Review the printout of the worksheet PTRANS. You have been asked to complete the worksheet by recording these transactions.
Expert Solution & Answer
To determine
Show the printout of worksheet of PTRANS.
Explanation of Solution
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
On July 1, 2019, Pat Glenn established Half Moon Realty. Pat completed the following transactions during the month of July:
a. Opened a business bank account with a deposit of $30,000 from personal funds.
b. Purchased office supplies on account, $3,010.
c. Paid creditor on account, $1,900.
d. Earned sales commissions, receiving cash, $30,690.
On April 1, 2019, Maria Adams established Custom Realty. Maria completed the following transactions during the month of April:a. Opened a business bank account with a deposit of $24,000 from personal funds.b. Paid rent on office and equipment for the month, $3,600.c. Paid automobile expenses (including rental charge) for the month, $1,350, and miscellaneous expenses, $600.d. Purchased office supplies on account, $1,200.e. Earned sales commissions (revenue) from selling real estate, receiving cash, $19,800.f. Paid creditor on account, $750.g. Paid office salaries, $2,500.h. Withdrew cash for personal use, $3,500.i. Determined that the cost of supplies on hand was $300; therefore, the cost of supplies used was $900.
Domingo Company started its business on May 1, 2019. The following transactions occurred during the month of May and the following entries were recorded.
A. The owners invested $9,500 from their personal account to the business account.B. Paid rent $600 with check #101.C. Initiated a petty cash fund $600 with check #102.D. Received $1,100 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,300, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $800, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77, miscellaneous expense $55. Cash on hand $115. Check #106.J. Increased petty cash by $30, check #107.
A.
Cash
9,500
Domingo, Capital
9,500
B.
Rent Expense
600
Cash
600
C.
Petty Cash
600
Cash
600
D.
Cash
1,100
Services Income
1,100
E.
Office…
Chapter 1 Solutions
Excel Applications for Accounting Principles
Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - On June 1 of the current year, Wilson Wood opened...Ch. 1 - Prob. 7R
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
- Inner Resources Company started its business on April 1, 2019. The following transactions occurred during the month of April. Prepare the journal entries in the journal on Page 1. A. The owners invested $8,500 from their personal account to the business account. B. Paid rent $650 with check #101. C. Initiated a petty cash fund $550 check #102. D. Received $750 cash for services rendered. E. Purchased office supplies for $180 with check #103. F. Purchased computer equipment $8,500, paid $1,600 with check #104 and will pay the remainder in 30 days. G. Received $1,200 cash for services rendered. H. Paid wages $560, check #105. I. Petty cash reimbursement office supplies $200, Maintenance Expense $140, Miscellaneous Expense $65. Cash on Hand $93. Check #106. J. Increased Petty Cash by $100, check #107.arrow_forwardDomingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. Prepare the journal entries in the journal on Page 1. A. The owners invested $10,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,000 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,500, paid $1,350 with check #104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $600, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77, miscellaneous expense $55. Cash on hand $11. Check #106. J. Increased petty cash by $30, check #107.arrow_forwardIn 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.arrow_forward
- On July 1, 2019, Pat Glenn established Half Moon Realty. Pat completed the following transactions during the month of July:a. Opened a business bank account with a deposit of $25,000 from personal funds.b. Purchased office supplies on account, $1,850. c. Paid creditor on account, $1,200.d. Earned sales commissions, receiving cash, $41,500.e. Paid rent on office and equipment for the month, $3,600.f. Withdrew cash for personal use, $4,000.g. Paid automobile expenses (including rental charge) for the month, $3,050, and miscellaneous expenses, $1,600.h. Paid office salaries, $5,000.i. Determined that the cost of supplies on hand was $950; therefore, the cost of supplies used was $900.arrow_forwardDomingo Company started its business on January 1, 2019. The following transactions occurredduring the month of May. Prepare the journal entries in the journal on Page 1.A. The owners invested $10,000 from their personal account to the business account.B. Paid rent $500 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,000 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,500, paid $1,350 with check #104, and will pay the remainder in 30days.G. Received $800 cash for services rendered.H. Paid wages $600, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $77,miscellaneous expense $55. Cash on hand $11. Check #106.J. Increased petty cash by $30, check #107.arrow_forwardDomingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $10,000 from their personal account to the business account.B. Paid rent $700 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,100 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,500, paid $1,250 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $600, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $110, postage expense $79, miscellaneous expense $57. Cash on hand $10. Check #106.J. Increased petty cash by $30, check #107. Domingo Company received the following bank statement. Bank Statement Beginning balance $0 Deposits Checks A. $10,000 101 $700 D. 1,100 102 500 103 158 106 490 Bank service…arrow_forward
- Domingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $12,000 from their personal account to the business account.B. Paid rent $700 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,000 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,100, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $800, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $75, miscellaneous expense $55. Cash on hand $18. Check #106.J. Increased petty cash by $30, check #107. Prepare the journal entries. If an amount box does not require an entry, leave it blank. A. fill in the blank 2 fill in the blank 3 fill in the blank 5 fill in the blank 6 B. fill in the blank 8 fill in the blank 9…arrow_forwardDomingo Company started its business on May 1, 2019. The following transactions occurred during the month of May and the following entries were recorded. A. The owners invested $5,000 from their personal account to the business account.B. Paid rent $700 with check #101.C. Initiated a petty cash fund $500 with check #102.D. Received $1,300 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,000, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $700, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $71, miscellaneous expense $55. Cash on hand $18. Check #106.J. Increased petty cash by $30, check #107. A. Cash 5,000 Domingo, Capital 5,000 B. Rent Expense 700 Cash 700 C. Petty Cash 500 Cash 500 D. Cash 1,300 Services Income 1,300 E. Office…arrow_forwardDomingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $12,000 from their personal account to the business account.B. Paid rent $600 with check #101.C. Initiated a petty cash fund $600 with check #102.D. Received $1,100 cash for services rendered.E. Purchased office supplies for $158 with check #103.F. Purchased computer equipment $2,500, paid $1,350 with check #104, and will pay the remainder in 30 days.G. Received $800 cash for services rendered.H. Paid wages $600, check #105.I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $73, miscellaneous expense $55. Cash on hand $116. Check #106.J. Increased petty cash by $30, check #107. Prepare the journal entries. If an amount box does not require an entry, leave it blank. A. Domingo, Capital Domingo, Capital Cash Cash B. Rent Expense Rent Expense Cash Cash C. Petty Cash…arrow_forward
- Domingo Company started its business on January 1, 2019. The following transactions occurred during the month of May. A. The owners invested $10,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,100 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,500, paid $1,250 with check #104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $600, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $110, postage expense $79, miscellaneous expense $57. Cash on hand $5. Check #106. J. Increased petty cash by $30, check #107. Domingo Company received the following bank statement. Bank Statement Beginning balance $0 Deposits Checks А. $10,000 101 $500 D. 1,100 102 500 103 158 106 495 Bank service charges 100 Total 11,100 1,753 Ending balance $9,347…arrow_forwardInner Resources Company started its business on April 1, 2019. The following transactions occurred during the month of April. A. The owners invested $9,000 from their personal account to the business account. B. Paid rent$650 with check #101. C. Initiated a petty cash fund $650 with check #102. D. Received $850 cash for services rendered. E. Purchased office supplies for $180 with check #103. F. Purchased computer equipment $9,500, paid $1,600 with check #104, and will pay the remainder in 30 days. G. Received s1,200 cash for services rendered. H. Paid wages $560, check #105. I. Petty cash reimbursement: office supplies $250, Maintenance Expense $140, Miscellaneous Expense $65. Cash on Hand $137. Check #106. J. Increased Petty Cash by $100, check #107. Inner Resources Company received the following bank statement. Bank Statement Beginning balance Deposits Checks A. $9,000 101 $650 G. 1,200 102 650 103 180 106 513 Bank service charges 150 Total $10,200 $2,143 Ending balance $8,057…arrow_forwardDomingo Company started its business on May 1, 2019. The following transactions occurred during the month of May and the following entries were recorded. A. The owners invested $1,000 from their personal account to the business account. B. Paid rent $500 with check #101. C. Initiated a petty cash fund $500 with check #102. D. Received $1,000 cash for services rendered. E. Purchased office supplies for $158 with check #103. F. Purchased computer equipment $2,200, paid $1,350 with check #104, and will pay the remainder in 30 days. G. Received $800 cash for services rendered. H. Paid wages $800, check #105. I. Petty cash reimbursement: office supplies $256, maintenance expense $108, postage expense $75, miscellaneous expense $55. Cash on hand $18. Check #106. J. Increased petty cash by $30, check #107. A. Cash 1,000 Domingo, Capital 1,000 В. Rent Expense 500 Cash 500 C. С. Petty Cash 500 Cash 500 D. Cash 1,000 Services Income 1,000 Е. Office Supplies 158 Cash 158 F. Computer Equipment…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Financial 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
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
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