Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pick any sole prop business for this example. Sep 8, 2019 11:00 PM Chart of Accounts in Excel- Due ACG2001 PRINC ACCTI ONLINE 640678 Review

image text in transcribed
pick any sole prop business for this example. image text in transcribed
Sep 8, 2019 11:00 PM Chart of Accounts in Excel- Due ACG2001 PRINC ACCTI ONLINE 640678 Review the chart of accounts in Ch 2. 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 nme and your pathway List at least 16 accounts. At least 6 account titles should be customized for your specific company or industry. Assign a three digit account number to your accounts following the example chart of accounts Group 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 row for cash could have the following information 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, Pl, Equipment providers for the industry STEM: Engineering Co., Vet. Office, Computer Services co. SGSHS: Psychology office, Non-profit agencies Social Media Chart of Accounts in Excel Due yesterday at 1100 PM Starts Sep 1, 2019 1200 AM Ends Sep 10, 2019 11:00 PM Sep 8, 2019 11:00 PM Chart of Accounts in Excel- Due ACG2001 PRINC ACCTI ONLINE 640678 Review the chart of accounts in Ch 2. 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 nme and your pathway List at least 16 accounts. At least 6 account titles should be customized for your specific company or industry. Assign a three digit account number to your accounts following the example chart of accounts Group 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 row for cash could have the following information 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, Pl, Equipment providers for the industry STEM: Engineering Co., Vet. Office, Computer Services co. SGSHS: Psychology office, Non-profit agencies Social Media Chart of Accounts in Excel Due yesterday at 1100 PM Starts Sep 1, 2019 1200 AM Ends Sep 10, 2019 11:00 PM

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

Step: 3

blur-text-image

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

Surviving An IRS Tax Audit

Authors: Frederick W. Daily

3rd Edition

1413318649, 978-1413318647

More Books

Students also viewed these Accounting questions