Question

In Excel, create a four column chart of accounts for a fictitious company in your pathway. The company should be a sole proprietor and a service business. In the upper left side of your worksheet list your name, your company name and your pathway. Write a short description of what your company does. Your Chart of Accounts must include the following:

• List at least 16 accounts.
• At least 6 account titles should be customized for your specific company.
• Assign a three digit account number to your accounts following the example chart of accounts.
• Group and title the accounts, as in the example, as Assets, Liabilities, Owner’s Equity, Revenue and Expense.
• In the last two columns, state what the normal balance of the account is (debit or credit), and state how the account is increased (debit or credit).

Your four columns should have the following titles:

• Account number
• Account title
• normal balance
• increases with

The example below is for the cash line

Account number	Account title		Normal Balance		Increases with
101	Cash		Debit		Debit

:

Examples of businesses in pathways could be:

• AHCD: Dance, Theater, Film production, Social media, Graphics design or architecture business
• Business: Accounting office, caterer, advertising firm, dry cleaner, restaurant, any business is acceptable
• Education: K-12 tutoring, Child care, Charter schools
• Health Sciences: Dr. or Dentist office, PT office, Hospital, Insurance co,
• IMCT: Engineering Co., Aviation maintenance, Aviation distribution, Supply Chain Management
• Public Safety: Law office, PI, Equipment providers for the industry
• STEM: Engineering Co., Vet. Office, Computer Services co.
• SGSHS: Psychology office, Non-profit agencies, Social Media

Answer 1

I have selected Business accounting office

The following would be specific for this business

1. Staff salary
2. Partner's remuneration
3. Accounting Software - Amortization
4. Accumulated Amortization - Accounting Software
5. Revenue - Taxation services
6. Revenue - Accounting Services

	Account number	Account title	Normal Balance	Increases with
1	101	Cash	Debit	Debit
2	102	Accounts Receivable	Debit	Debit
3	103	Office Supplies	Debit	Debit
4	104	Furniture and Fixtures	Debit	Debit
5	105	Accounting Software	Debit	Debit
6	201	Accounts Payable	Credit	Credit
7	202	Accrued Wages - Staff	Credit	Credit
8	203	Accrued Wages - Partner	Credit	Credit
9	204	Accumulated Amortization - Accounting Software	Credit	Credit
10	205	Accumulated Depreciation	Credit	Credit
11	301	Revenue - Taxation services	Credit	Credit
12	302	Revenue - Accounting services	Credit	Credit
13	401	Staff salary	Debit	Debit
14	402	Partner Remuneration	Debit	Debit
15	403	Depreciation	Debit	Debit
16	404	Amortization	Debit	Debit