BUS 4
Computerized Bookkeeping

Assignments Page

Assignment 1

Give Me Your E-mail Contact Information -

Before next class, send me an e-mail from your e-mail address. In the body of your e-mail, include the following:

Your Name The Name of Your Company

Include the Assignment 1 Attachment (see Below) -

In this class you will perform each assignment for a company of your own choosing. This can be a company you now work for or a fictitious company. The intent of allowing you to choose your own company is to provide you with an opportunity to make the assignments more interesting and meaningful to you. So you want to choose a business like one you work for now or would like to work for in the future. If you are unable to come up with one, I will provide you with one. Note ** If you have thought of opening your own business this is a perfect opportunity to get a feel for that business from an accounting perspective. When you have an idea of the company you wish to work with fill out this Business Information Form, and include it as your attachment for assignment 1.

Back to Syllabus

Assignment 2

Company Setup In Computer Accounting System

Use the information you created in Assignment 1 and my lecture number 2 to answer the questions in the Quickbooks EasyStep Interview. Complete the interview for your business. This will include: Basic Company Identification Information Business Type - Manufacturing, Retail, Service, etc. Basic Company Tax Information Identification of Industry Business Type - Manufacturing, Retail, Service, etc. Bank Account Setup When you are done you will display the Company Information to the screen, Take a screen shot of it, paste it to an excel worksheet, and turn in the spreadsheet by sending it as an attachment to my email address.If you have any problems, review Lecture 2, it has step by step instructions of this process.

Back to Syllabus

Assignment 3

Set up Your Chart of Accounts

Using the information we discussed in class, Open Quick Books and edit the Chart of Accounts to be consistant with the information you turned in in lab 1. For Example: Set up a primary bank account that references the bank you do business with You should have a Cash Account You should have a Accounts Recievable Account You should have a Accounts Payable Account You COGS Account should have sub accounts that reflect your product or service If you are renting you should have an Expense Account for Rent In addition make the following changes: Turn the account numbers on so they appear when you open your chart of accounts Sort your Chart of Accounts by Account Number When you are done send me proof. There are a number of ways to capture the chart of accounts in a file. There is a Chart of accounts report which can be exported to a file, or you can simply print the screen (it may take 2 screen shots). Email the file to me.

Back to Syllabus

Assignment 4

Set Up Vendors

Using the information we discussed in class, Set up a minimum of 10 vendors (the people you will purchase goods or services from) that your company will use to do business. You should include at a minimum: Contact Information - Name - Address - Phone Number Account Number - Account Type - Account Terms At least one field that you create When you have completed your vendors enter a minimum of 5 items in the Inventory List. With these Items you will indicate: Item Identification Information Name - Number - Description Associate the Item to a Cost Account Associate the Item with it's Supplier Create a feild for use in the Items List When you are done export both reports to a single Excel file and send it to my email it should be formated as follows: Vendor Report on one worksheet, Item Report on another Vendor Report shows 4 fields one of which is the one you created, in this order: Your Field Company Account Number Balance Total Item Report shows 4 fields one of which is the one you created, in this order: Item Your Field Description Quantity on Hand Worksheet Tabs should be named to label each report

Back to Syllabus

Assignment 5

Set Up Employees

Using the information we discussed in class, Set up a minimum of 10 Employees that your company will use to do business. You should include at a minimum: Contact Information - Name - Address - Phone Number Employee Number - Account Type - Account Terms Social Security Number xxx-xx-xxxx Salary or Hourly and associated Rate Vacation and/or Sick Pay Benefits - Medical, Dental, Retirement You will need to address to address tax information including Marital Status Exemptions on W4 State where employeed and State Tax When you are done export The Employee List report to a Excel file and send it to my email it should be formated as follows: Account Number (The Quick Books Employee Number Field) Employee Address First Earnings Rate STATE Filing Status The report should be sorted by the Account Number field

Back to Syllabus

Assignment 6

Set Up Customers

Using the information we discussed in class, Set up a minimum of 10 Employees for your company.

Back to Syllabus

Assignment 7

Topic

Record customer payments in QuickBooks. Handling customer discounts, partial payments, overpayments or down payments. Record deposits and enter cash back from a deposit.

Back to Syllabus

Assignment 8

Topic

Entering bills, using the Pay Bills window to pay a bill, enter discounts on a bill from a vendor.

Back to Syllabus

Assignment 9

Topic

Create a QuickReport, add and move a column in a report, creating and viewing reports onscreen, customize a report, process reports in batches, save reports in PDF format, export reports to Microsoft Excel, filter reports in Excel and create & customize graphs in QuickBooks.

Back to Syllabus

Assignment 10

Topic

Filling out purchase orders for inventory items, track the receipt of the inventory items, adjust inventory manually by entering a stock loss or increase and create & build inventory assemblies.

Back to Syllabus

Assignment 11

Topic

Track sales tax using QuickBooks, apply sales tax to a sale, determine a business's sales tax liablity and writing QuickBooks checks to the appropriate tax agency for sales tax liability.

Back to Syllabus

Assignment 12

Topic

Payroll setup in QuickBooks, setup employee payroll information, write and print payroll checks, track tax liabilities and pay payroll taxes using QuickBooks.

Back to Syllabus

Assignment 13

Topic

Create job estimates, find estimates in data files, duplicate an existing estimate, create an invoice from an estimate, display project reports for estimates, update a job's status and make an estimate inactive.

Back to Syllabus

Assignment 14

Topic

Track time worked on a project, invoice a customer for time worked on a project, track and invoice a customer for mileage, create project reports for time tracking, set up items used to track time worked by owners or partners and pay non-employees for time worked.

Back to Syllabus

Combination Final Assignment 15

Topic

Modify a preset invoice form, design a custom invoice form, print invoices, prepare a collection letter for overdue customers and edit prewritten letters in QuickBooks.

Back to Syllabus

Return to BUS 4 Class Links