Make a copy of the QuickBooks Accountant file you created for Sunset in that chapter. Record the following business events in chronological order (remember, dates are in the month of January 2015).

Create, memorize, and print the following reports with no date prepared, time prepared, or report basis fields. When memorizing, you can choose to replace the existing report if one existed or add the chapter number to the title.

a. Transaction List by Date for the period 1/17/15–1/31/15 in landscape orientation.

b. Profit & Loss Statement for January 2015 with a % of Income column, without cents, and centered.

c. Balance Sheet as of 1/31/15 with a % of Column, without cents, and centered.

d. Statement of Cash Flows for January 2015 without cents and centered.

e. Reconciliation Summary for January 2015 without cents and centered.

f. Profit & Loss Budget vs. Actual for January 2015 without cents and centered.

g. Profit & Loss Budget Overview for January 2015 through March 2015 without cents and centered.

h. Collapsed Sales by Customer Summary Report for the month ended 1/31/15, sorted by total (from largest to smallest amount) with total only columns, centered and without cents.

i. Sales by Item Summary Report for the month ended 1/31/15, sorted by total (from largest to smallest amount) with total only columns, centered, without cents, and in landscape orientation.

j. Accounts Receivable Aging Summary Report as of 1/31/15.

k. Accounts Payable Aging Summary Report as of 1/31/15.

l. Export the Profit & Loss Statement created in (b) to Excel, and then print the Excel worksheet with gridlines and row and column headers.

Transcribed Image Text:

Chronological List of Business Events Event # Date 1 3 1/17/15 1/17/15 1/17/15 Business Event Paid $18,000 in liability insurance for the year to Hartford Insurance (a new vendor) using Check No. 111. (Hint: Record this in a new other current asset account called Prepaid Insur- ance.) Received a bill for $500 from Staples (a new vendor) for office supplies purchased on account. Terms are net 30. (All supplies are expected to be consumed this month.) Using Purchase Order No. 5003, ordered from Cal Spas one each of items #301, # 302, and # 303 for immediate delivery (terms: net 30).