Change the company name to include Ch 11 at the end so that the new company name is Crystal Clear Pool Service Ch 11. Add the following business events:

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 10/31/12–12/3/12 in landscape orientation.

b. Balance Sheet Budget Overview report from 10/1/12 to 11/30/12.

c. Profit & Loss Budget Overview report from 10/1/12 to 11/30/12.

d. Balance Sheet Budget vs. Actual report from 10/1/12 to 11/30/12.

e. Profit & Loss Budget vs. Actual report from 10/1/12 to 11/30/12.

f. Statement of Cash Flows for November 2012 centered.

g. Reconciliation Summary for November 2012.

h. Collapsed Sales by Customer Summary Report for the month ended 11/30/12, 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 11/30/12, sorted by total (from largest to smallest amount) with total only columns, centered, without cents, and in landscape orientation.

j. Collapsed Accounts Receivable Aging Summary Report as of 11/30/12.

k. Collapsed Accounts Payable Aging Summary Report as of 11/30/12.

l. Export the Collapsed Accounts Receivable Aging Summary Report created in (i) 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 11/1/2012 2 11/5/2012 3 11/6/2012 4 5 6 7 8 11/9/2012 11/12/2012 11/13/2012 11/14/2012 11/15/2012 9 11/26/2012 Business Event Invoiced customers AG, HR, PD, and WS 40 hours each for pool services to be rendered in November using Invoice numbers 10139-10142 with sales tax. Received the following payments from customers on account and deposited amounts the same day: check 8852 from customer PD for $5,777, check 124891 from customer HR for $7,300, VISA payment 6579514 from customer WS for $5,300. Created purchase order 45 to Cactus Pool Supply for the purchase of $1,850 in parts needed for repair work being completed for Adobe Grand (AG) on a new job Pool Repairs. Also created purchase order 46 to Sun Systems for the purchase of $1,200 in parts needed for repair work to be done for Hillton Resorts (HR) on a new job Pool Repairs. Received parts ordered on purchase order 45 from Cactus Pool Supply on its Invoice 585421 and purchase order 46 from Sun Systems on Its Invoice 2323. Completed Job HR Pool Repairs and Invoiced the customer on Invoice number 10143 for 10 hours in pool repairs and for parts reimbursement for a total of $2,597. Purchased cleaning supplies from Cactus Pool Supply in the amount of $1,200 using check 295 and charged the purchase to a new other current asset account Supplies. Paid rent expense to Century 21 Leasing using check 296 for $1,789. Wrote check 297 to Goldman Sachs (a new vendor with vendor name GS) for $5,000 as a Short-Term Invest- ment (a new other current asset account). Invoiced customers AG, HR, PD, and WS for pool sup- plies consumed in November using invoice numbers 10144-10147 with sales tax. Customer AG-20 units of chlorine, 9 units of pool shock, and 4 units of pool algae- cide. Customer HR-22 units of chlorine, 9 units of pool shock, and 3 units of pool algaecide. Customer PD-16 units of chlorine, 7 units of pool shock, and 3 units of pool algaecide. Customer WS-28 units of chlorine, 15 units of pool shock, and 8 units of pool algaecide.