I was supposed to complete this problem in QuickBooks, but for some reason, QuickBooks is not cooperating and the instructor has given me permission to do the problem as Excel spreadsheets. I'm stuck on how to go about it though. Any help would be appreciated. Thanks.

Option #1: Practice in QuickBooks: The Case of Sams Company

Continue to use your QuickBooks access. Return to the QuickBooks home page. Delete the information from module 3. Remember to delete the free trial and, if you entered, your credit card information after you submit module 5.

Go to Home page, select the widget to the direct top right of the word help and select on the left side settings, then company setting.

For each edit, hit the pen picture on the right hand side of each section. Enter the company name, Sams Company (option 1)

TIPS:

In the home page, go to the top right hand corner, to the right of the name of the company, click the gear symbol, which is the main link for everything you need for changes.

Input is on the left-hand side of the home page with links to customers, vendors, and transactions

For doing the journal entries below: Go to top panel, in the middle of the top of the screen, where there is a plus sign (+) and select journal entries found in the other section.

It is up to you to create the correct accounts, with the proper journal entries.

Important to remember:

Do not forget to click on save and new after you input and file.

Backup your company information many times as you work. To do this, click the button at the bottom of each screen called: save and new

Always check to be sure your input dates are correct. Transaction input date are on the top left side above the journal entry

Always best to record terms within the journal entry in the extra line provided to the right of A/R or A/P

Prepare journal entries. Be sure all dates agree with the problem and are not todays date:

For 6/1/2015:

Go to + for making journal entries: opening equity and title equity as EQUITY.

Deposit $150,000 to Cash

In side panel memo of cash write: Initial deposit from owner

For 6/3/2015:

Buys for cash furniture and equipment from Weiss, add new vendor Weiss, for $50,000.

In side panel memo of cash write: For furniture and equipment from Weiss

For 6/10/2015:

Deposit on bank money market the amount of $40,000 from Pat B, add new customer, Pat B, for Consulting Revenue

In side panel memo of cash write: Work completed on 6/10/15 for Pat B

For 6/20/2015:

Pay Wansi, add new vendor Wansi, for $5,000 for purchase of supplies which are other current assets, inventory

In side panel memo of cash write: For purchase of supplies from Wansi

For 6/30/2015:

Deposit on bank money market the amount of $120,000 from Bill Mak, add new customer, Bill Mak, for Consulting Revenue

In side panel memo of cash write: Work completed on 6/31/2015 for Bill Mak

For 6/30/2015:

Pay #1 Employee, add new employee #1 Employee, for $3,000 for purchase of supplies which are other current assets, inventory

In side panel memo of cash write: Payroll expense to #1 Employee for month of June 2015

Instructions:

Enter above transactions into QuickBooks. To submit: go to home reports balance sheet and be sure your dates include June 1 to June 30, 2015. Click on the cash link on the balance sheet. Cut and paste just the cash report into a document to submit.