EBK EXCEL APPLICATIONS FOR ACCOUNTING P
EBK EXCEL APPLICATIONS FOR ACCOUNTING P
4th Edition
ISBN: 8220100456848
Author: SMITH
Publisher: CENGAGE L
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 1, Problem 3R

On June 1 of the current year, Wilson Wood opened Woodyʼs Web Services. This sole proprietorship had the following transactions during June.

  1. a. Opened a business checking account and made a deposit, $9,000.
  2. b. Paid rent for June for office space and computer equipment, $3,000.
  3. c. Purchased office supplies (stamps, pens, etc.) on account, $1,980.
  4. d. Received cash for services rendered, $4,500.
  5. e. Paid creditor for office supplies purchased on account, $1,400.
  6. f. Purchased office supplies for cash, $420.
  7. g. Billed clients for consultations performed on account, $4,600.
  8. h. Paid monthly internet service bill of $360.
  9. i. Paid the secretaryʼs salary of $2,400.
  10. j. Returned $300 of office supplies purchased in transaction f. Received a full refund.
  11. k. Received cash from clients previously billed, $3,000.
  12. l. Cash was withdrawn for ownerʼs personal use, $2,000.

It has been determined that the cost of the supplies used during the month was $600. Record the increase or decrease in the appropriate columns on the worksheet. This is transaction m. Enter your name in cell A1. Save the completed file as PTRANS3. Print the worksheet. Also print your formulas. Check figure: Ending cash balance (cell B21), $7,220.

Blurred answer
Knowledge Booster
Background pattern image
Accounting
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Text book image
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
Text book image
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Text book image
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY