Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi can you help me with this please. Thanks in advance Required on Microsoft Excel Problem 2 - 2 B Preparing and posting journal entries;

Hi can you help me with this please. Thanks in advance Required on Microsoft Excel Problem 2-2B Preparing and posting journal entries;
preparing a trial balance P1 A1
At the beginning of April, Bernadette Grechus launched a custom computer
solutions company called Softworks. The company had the following transactions
during April.
a. B. Grechus invested $65,000 cash, office equipment with a value of $5,750, and
$30,000 of computer equipment in the company in exchange for common
stock
b. The company purchased land worth $22,000 for an office by paying $5,000
cash and signing a note payable for $17,000.
c. The company purchased a portable building with $
1. Prepare general journal entries to record these transactions (use account titles listed in part 2).
2. Open the following ledger accountstheir account numbers are in parentheses (use the balance column format): Cash (101); Accounts Receivable (106); Prepaid Insurance (108); Office Equipment (163); Computer Equipment (164); Building (170); Land (172); Accounts Payable (201); Notes Payable (250); Common Stock (307); Dividends (319); Services Revenue (403); Wages Expense (601); Advertising Expense (603); and Repairs Expense (604). Post the journal entries from part 1 to the accounts and enter the balance after each posting.
Check (2) Ending balances: Cash, $17,262; Accounts Receivable, $9,350; Accounts Payable, $580
3. Prepare a trial balance as of the end of April.
(3) Trial balance totals, $141,080 Problem 2-2B Preparing and posting journal entries;
preparing a trial balance P1 A1
At the beginning of April, Bermadette Grechus launched a custom computer
solutions company called Softworks. The company had the following transactions
during April.
a. B. Grechus invested $65,000 cash, office equipment with a value of $5,750, and
$30,000 of computer equipment in the company in exchange for common
stock
b. The company purchased land worth $22,000 for an office by paying $5,000
cash and signing a note payable for $17,000.
c. The company purchased a portable building with $34,500 cash and moved it
onto the land acquired in b.
d. The company paid $5,000 cash for the premium on a two-year insurance
policy.
e. The company provided services to a client and immediately collected $4,600
cash.
f. The company purchased $4,500 of additional computer equipment by paying
$800 casirat signing a note payable for $3,700.
g. The company completed $4,250 of services for a client. This amount is to be
received within 30 days.
h. The company purchased $950 of additional office equipment on credit.
i. The company completed $10,200 of services for a customer on credit.
j. The company purchased $580 of TV advertising on credit.
k. The company collected $5,100 cash in partial payment from the client
described in transaction i.
The company paid $1,800 cash for employee wages.
m. The company paid $950 cash to settle the payable created in transaction h.
n. The company paid $608 cash for repairs.
o. The company paid a $6,230 cash divided Page 78
p. The company paid $1800 cash dividend.
q. The company paid $7500 cash for employee wages.
Required
Prepare general journal entries to record these transactions (use account
titles listed in part 2).
Open the following ledger accounts-their account numbers are in
parentheses (use the balance column format): Cash (101); Accounts
Receivable (106); Prepaid Insurance (108); Office Equipment (163);
Computer Equipment (164); Building (170); Land (172); Accounts Payable
(201); Notes Payable (250); Common Stock (307); Dividends (319); Services
Revenue (403); Wages Expense (601); Advertising Expense (603); and
Repairs Expense (604). Post the journal entries from part 1 to the accounts
and enter the balance after each posting.
Check (2) Ending balances: Cash, $17,262; Accounts Receivable, $9,350;
Accounts Payable, $580
Prepare a trial balance as of the end of April.
(3) Trial balance totals, $144,080
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Microsoft Excel And Access 20 For Accounting

Authors: Glenn Owen

5th Edition

133751229X, 9781337512299

More Books

Students also viewed these Accounting questions