Ch. 16: General Ledger and Reporting System
Next, highlight the cells containing the data as shown:
Accounting Information Systems
Ch. 16: General Ledger and Reporting System
16–16
b. Print out a report that shows sales by month for each salesperson.
Step1: select the salesperson, order date, and order amount fields in the window in the upper right corner that says “Choose
Fields to add to Report.”
Accounting Information Systems
Step 2: Then click on the salesperson entry and move it from the “Row Labels” window to the “Column Labels” window.
Ch. 16: General Ledger and Reporting System
16–18
Step 3: Highlight all the cells in the PivotTable and format them to display currency with two decimals.
Accounting Information Systems
c. Assume that Brown and David are in sales group 1 and the other three salespeople are in sales group 2. Print out a
report that shows monthly sales for each group.
Step 1: To separate the sales people into groups, click on the sales person row in the Pivot Table and highlight Brown and David.
Ch. 16: General Ledger and Reporting System
16–20
Step 2: Right click the two highlighted cells and select “Group”. They will now have a super–title called “Group 1”. Do the same
for the other three sales people to form group 2. The spreadsheet should look like this:
Accounting Information Systems
Step 3: You can collapse and display the groups by clicking on the button to the left of each group name. The preceding screen
shot showed all members of each group (note the minus signs to the left of the labels “Group1” and “Group2”). Clicking those to
change to a plus sign produces the following:
Ch. 16: General Ledger and Reporting System
16–22
16.10 Excel Problem Objective: How to do what-if analysis with graphs.
a. Read the article “Tweaking the Numbers,” by Theo Callahan in the June 2001 issue of the Journal of Accountancy
(either the print edition, likely available at your school’s library, or access the Journal of Accountancy archives at
www.aicpa.org). Follow the instructions in the article to create a spreadsheet with graphs that do what-if analysis.
Most of the steps in the article can be done as indicated. One difference is finding the control toolbox to create a spin button. This
requires that the “Developer” tab is available as shown below.
Click on “Design Mode” to toggle
Click on Insert to add spin
buttons and other Active X
controls