Enter the transactions on the worksheet format provided below. January 2          Invested in a new business $ 100000 cash, $25000 in the bank. 6          Bought a vehicle on credit $12000 10        Bought office supplies for $4000 cash. 14        Sold goods for cash to clients $10000. 13        Bought stores supplies on credit $1200 15        Provided sales on credit to Susan $15000. 18        Paid utilities $14500. 20        Paid 12 months insurance in advance $4800. 21        Paid for stores supplies bought on 13th to take advantage of a $100 discount. 24        Purchases on credit by Saturn Co. $2000. 30        Received $14500 as full settlement from Susan.     Assets Liabilities Equity Date Bank Cash Debtors Office supplies Vehicle Prepaid insurance Stores supplies Creditors Other payables Equity

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 1R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...
icon
Related questions
icon
Concept explainers
Question
  1. Enter the transactions on the worksheet format provided below.

January

2          Invested in a new business $ 100000 cash, $25000 in the bank.

6          Bought a vehicle on credit $12000

10        Bought office supplies for $4000 cash.

14        Sold goods for cash to clients $10000.

13        Bought stores supplies on credit $1200

15        Provided sales on credit to Susan $15000.

18        Paid utilities $14500.

20        Paid 12 months insurance in advance $4800.

21        Paid for stores supplies bought on 13th to take advantage of a $100 discount.

24        Purchases on credit by Saturn Co. $2000.

30        Received $14500 as full settlement from Susan.

 

 

Assets

Liabilities

Equity

Date

Bank

Cash

Debtors

Office supplies

Vehicle

Prepaid insurance

Stores supplies

Creditors

Other payables

Equity

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage