Accounting – Quickbooks/excel

0 comments

Follow these directions to set up QuickBooks™ for the Module 3 Critical Thinking Assignment:

  1. Load the QuickBooks™ disc.
  2. Enter the information found on the disc sleeve when asked for the license and product number.
  3. Once QuickBooks™ is loaded, reboot your computer.
  4. Once the computer is re-booted, click the icon entitled QuickBooks™, go through the agreement question(s), select “create a new company,” and then select “express set-up.”
  5. Enter the company name in your assignment option choice.
  6. Enter the industry: “construction general contractor.”
  7. Enter the type of company: “sole proprietorship.”
  8. Enter the Tax ID number as 99-1234567.
  9. Select “no employees but might have in the future.”
  10. Enter your address, phone number, 
  11. Wait for QuickBooks™ to create your company.
  12. Select the right-hand corner icon called “start working.”
  13. Select “Home” from the list in the left-hand column. The home page will appear as follows: 
    Quickbooks home

    Source com/2011/05/quickbooks-homepage-is-it-yours/” href=”http://topnotchbookkeeping.com/2011/05/quickbooks-homepage-is-it-yours/”>http://topnotchbookkeeping.com/2011/05/quickbooks-homepage-is-it-yours/

  14. Among the icons on the screen (i.e., Vendors, Customers, Employees, Company, and Bank), select “Chart of Accounts” under Company and a list of the company accounts will appear.
  15. In the top ribbon click “Edit” (second icon over from the top), and then from the drop-down menu select “add a new account.”
  16. Add two accounts—accounts payables and bank loan accounts—which are both loan-type accounts; label each accordingly.
  17. Change the retainage receivables to account receivables.
  18. Delete all expense accounts except payroll expenses, rent expense, telephone expense, and utilities.

Important items to remember:

  • All dates used must be in the month preceding the current month.
  • Do not forget to hit “save and close” after you input and file, and back up your company’s information often.
  • Always ensure that your input dates are last month’s dates. It is very important to do that, especially if you cannot find an input.

With the setup complete, you are now ready to begin your chosen Critical Thinking Assignment in QuickBooks™.

Option #2: Introduction to QuickBooks™: The Mini Construction Company Case

Assignment Template attached

Set up your QuickBooks™ access, and then go to the QuickBooks™ home page. Select “chart of accounts” and enter each line item in the chart of accounts as follows:

1st of month: Beginning cash is $50,000; beginning equity is $50,000.

5th of month: Construction in progress increase $3,200; corresponding accounts payable due in 10 days (Quick add: DEF Company, vendor).

10th of month: Furniture and equipment increase $6,000; corresponding account cash (Quick add: DEF Company, vendor).

16th of month: Construction income increase $10,000; corresponding account accounts receivables (Quick add: UVW, customer).

19th of month: Accounts receivable increase $2,900; corresponding account construction income (Quick add: UVW, customer).

20th of month: Loan from PQR Bank $4,000; corresponding cash account (Quick add: PQR Bank, other).

25th of month: Make individual cash entries (for each amount to corresponding expense items) for payroll expense $1,000; rent expense $1,000; telephone expense $300; and utilities expense $500 (Quick add and use for all: Misc., other).

Instructions:

In an Excel worksheet, submit to the assignment area the standard balance for the end of last month for the Mini Construction Company:

  • Go to the top ribbon called “Reports” from Company and Financial and Balance Sheet Standard.
  • To export the chart of accounts to Excel, select the Excel tab and then select “create a new worksheet.”
  • Save the file as your last name_ first name.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}