Prepare the trial balance worksheet

Assignment Help Accounting Basics
Reference no: EM131906307

Assignment -

1. EDIT COMPANY INFORMATION

a. Change the company's name to your full name and exam I. For example, John Jones - Exam 1.

b. Change the Company's Legal Name to your full name and exam 1. For example, John Jones - Exam 1.

2. CUSTOMIZE THE CHART OF ACCOUNTS

a. Change the title of the checking account to First State Bank Checking.

b. Change the title of account 30100 Capital Stock to Common Stock.

c. Add the following subaccounts to a Fixed Asset:

Account Type

Fixed Asset

Number

Choose an appropriate number

Account Name

Forklift - Cost

Subaccount of

Construction Equipment

Description

Used heavy duty forklift

 

Account Type

Fixed Asset

Number

Choose an appropriate number

Account Name

Accum. Depre. Forklift

Subaccount of

Construction Equipment

Description

Total depreciation of forklift

3. a. CREATE A NEW CUSTOMER ACCOUNT

Customer Name

Campus Restaurant

Opening Balance

0 as of 09/01/2017

Company Name

Campus Restaurant

Main Phone

908-555-4511

Address

241 Crown Street, Bayshore, CA  94326

Ship to

241 Crown Street, Bayshore, CA  94326

Account #

72510

Credit limit

5000

Payment Terms

2% 10 Net 30

Preferred Method of Payment

Check

Credit Card No.

9876-5432-1234-5678

Tax Code

Tax

Tax Item

San Tomas

Customer Type

Commercial

b. ADD A JOB

Job Name

Kitchen Repair

Company Name

Campus Restaurant

Opening Balance

0 as of 09/01/2017

Job Description

Kitchen Repair

Job Type

Repairs

Job Status

Awarded

Start Date

09/03/2017

Projected End

09/05/2017

4. ADD A VENDOR

Vendor Name

Tom's Hardware Store

Opening Balance

0 as of 09/01/2017

Company Name

Tom's Hardware Store

Main Phone

908-555-1323

Main E-mail

[email protected]

Address (Billed from/Shipped to)

5110 Market St., Bayshore, CA 94326

Account No.

2011

Credit Limit

5000

Payment Terms

2% 10 net 30

Print on check as

Tom's Hardware Store

Vendor Tax ID

37-8911501

Vendor eligible for 1099

No

Vendor Type

Materials

5. ADD INVENTORY ITEM

Type: Inventory Part

Inventory Name: Acrylic Paint Primer

Manufacturer's Part Number: APP123

Purchase/Sales Description: One-gallon can

Cost: $12

Sales Price: $24.99

COGS Account: 50100 Cost of Goods Sold

Tax Code: Tax

Preferred Vendor: Tom's Hardware Store

Income Account: 40140 Materials Income

Asset Account: 12100 - Inventory Asset

Reorder Point: 5

Quantity on Hand: 0

As of: 09/01/2017

6. Record the following transactions in date sequence

Note - Charges San Tomas Tax on all sales Transactions

a. 09/01/2017 - Received a long-term loan of $7,200 from Lending Tree, This loan is to be repaid in monthly installments over a 3-year period with interest of 10% per annum starting Nov 1. Deposit this amount into First State Bank Checking.

b. 09/04/2017 - Ordered 25 cans of Acrylic Paint Primer from Tom's Hardware Store. Purchase Order #0101.

c. 09/07/2017 - Replenished the petty cash fund by writing check #801 for $487.50 to the petty cash custodian, Greg O. Schneider (employee). At this date the fund consisted of  $12.50 cash and the following petty cash receipts: postage 25.00; office supplies 105.70. automobile insurance 185.00, reseals and entertainment 80.75 and legal fee $93.

d. 09/1012017 - Purchased a used forklift for $7,200 from Equipment Sales Company and paid with check #802.

e. 09/12/2017 - Received 20 cans of Acrylic Paint Primer from Tom's Hardware Store without a bill.

f. 09/13/2017 - Charged Campus Restaurant: Kitchen Repair job for the following items (Invoice #012017): 4 Interior door kits at $120 each; 5 cans of Acrylic Paint Primer; 6 hours of painting at $35 per hour and 3 hours of removal labor at $35 per hour.

g. 09/14/2017. Sold 3 cans of Acrylic Paint Primer to Waterman, Pamela for cash. Pamela paid with Visa card 4321-0987-5678-6543. Deposited this payment into First State Bank Checking. Record a 5% bankcard fee. Use account 60600 Bank Service Charges.

h. 09/15/2017 - Received bill #4285 from Tom's Hardware Store for 20 cans of Acrylic Paint Primer plus $25 freight and delivery.

i. 09/17/2017 - Returned 2 damaged cans of Acrylic Paint Primer to Tom's Hardware Store for a credit.

j. 09/19/2017 - Issued credit memo #012017C to Campus Restaurant: Kitchen Repair job for I hour of removal labor and 1 can of Acrylic Paint Primer. Apply this credit to invoice #012017.

k. 09/20/2017 - Paid Tom's Hardware Store bill #4285. (less credit and discount), with check #803.

l. 09/22/2017 - Received check #2409 for $700 from Campus Restaurant in partial payment of its Kitchen Repair job. Apply credit memo #012017C and the appropriate discount toward this payment.

m. 09/23/2017 - Paid January's gas and electric bill of $123.26 with check #804 payable to Elizabeth Gas.

n. 09/24/2017 - Deposit into First State Bank Checking Campus Restaurant's check #2409.

o. 09/28/2017 - Waterman, Pamela returned 1 can of Acrylic Paint Primer for a cash refund. (Check #805)

p. 09/29/2017 - Thomas Alexander purchased 1,000 shares of the company's $0.25 par value common stock and paid by cheek #72532 for $750. This check was immediately deposited into First State Bank Checking.

q. 09/29/2017 - First State Bank returned Campus Restaurant's check #2409 for $700 marked NSF and charged your company $20 for this NSF check. Use Account 60600 Bank Service Charge for the bank fee. Your company charged Campus Restaurant $30 fee for the NSF check.

7. PRINT THE FOLLOWING REPORTS: (REPORTS MUST FIT TO 1 PAGE WIDE)

1. Journal - from 09/01/2017 to 09/30/2017 (show account numbers and full title)

2. Trial Balance - from 09/01/2017 to 09/30/2017

3. Check Register - from 09/01/2017 through 09/30/2017.

Reference no: EM131906307

Questions Cloud

Think about the processes of forming a judgment : Think about the processes of forming a judgment and persuading others in your professional environment.
What is net present value of project with cash flows : What is the net present value of a project with the following cash flows if the required rate of return (cost of capital) is 12.0 percent?
What is the distance from one condensation to the next : Sound from the siren of an emergency vehicle has a frequency of 700.0 Hz and moves with a velocity of 345.0 m/s.
Describe strategic philanthropy in your own words : Describe strategic philanthropy in your own words.Does strategic philanthropy influence your brand loyalty? Why or why not?
Prepare the trial balance worksheet : PRINT THE FOLLOWING REPORTS: Journal - from 09/01/2017 to 09/30/2017 and Trial Balance - from 09/01/2017 to 09/30/2017
Examine the companys strategic philanthropy : Examine the company's strategic philanthropy and how it impacts profits, brand, image and turnover, as well as society as a whole.
What depth would this intensity be halved : At the surface of the ocean, the light intensity is 1015 photons s-1cm-2. At what depth would this intensity be halved?
What is the expected risk premium on the portfolio : If the expected T-bill rate is 4.15 percent, what is the expected risk premium on the portfolio?
Principle of conservation of energy : Briefly, justify this claim, using the principle of conservation of energy.

Reviews

len1906307

3/19/2018 3:27:30 AM

NOTE: This exam is to be completed in a new Chapter 5 company tile. Save this file as "Exam 1". INSTRUCTIONS: Check off the printouts you have completed. Staple this page to your printouts in the order listed below and hand it in on Monday 19, at the beginning of class. Points will be deducted for not following instructions 1 and 2. PRINTOUT CHECKLIST – Journal, Trial Balance and Check Register.

Write a Review

Accounting Basics Questions & Answers

  Problem regarding the stock issuance

Record a journal entry for each transaction.

  How much inome should yaro recongnize

There is no amortization associated with the investment. During 2011, how much inome should Yaro recongnize related to this investment

  Hancock manufacturing allocates overhead to production on

hancock manufacturing allocates overhead to production on the basis of direct labor costs. at the beginning of the year

  According to the standards what direct labor cost should

skychefs inc. prepares in-flight meals for a number of major airlines. one of the companys products is grilled salmon

  Discuss what will leather purchases be in july

On July 1 leather inventory was expected to be 1,000 square meters. What will leather purchases be in July

  After a partner decides to withdraw from a partnership

after a partner decides to withdraw from a partnership which of the occurs when the withdrawing partner receives more

  What subjects or issues should be explored with Lucas

Robert wondered why he was always so stressed out when he was dealing with Lucas, the latest addition to his team. On the face of it, the new hire seemed.

  A student is trying to determine the half life of radioactiv

A student is trying to determine the half-life of radioactive iodine-131. He measures the amount, A, of iodine-131 in a sample solution every 8 hours. His data are shown in the table.

  Enter the above transaction nov 17 into the cash receipts

prepare a cash receipts journal based on the information given below and post it to the accounts receivable subsidiary

  Compute the sales level required in both dollars and units

jetson co. sold 19200 units of its only product and incurred a 43072 loss ignoring taxes for the current year as shown

  Determine the items exempt from gift tax

Determine the taxable gift in each of the following unrelated scenarios

  What is the accrual basis of accounting

What is the accrual basis of accounting? What is an accrued expense? What is accrued revenue? What is a prepaid expense?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd