Analyze Sales [Item - FY Comparison]

Index to Reports: Sales Tab

For all items sold, this report compares dollar sales, units sold, gross profit and percent margin in the selected year, based on recorded invoices, not including orders or quotes.

Report Tip:

As with most analysis reports, focus on the percent difference. What changed from year to year? Look at items you emphasized this year. Did any of your sales campaigns pay off? If you ran a sale, did you make more money or just sell more units? To select multiple months, click and drag the month selector in the Report Filters window.

Analyze Sales [Item - FY Comparison]

December 2000

Item

 

This Year

FY 1999

Difference

% Difference

______________________________________________________________________________________

100-101A5

Widgets

       
 

Sales:

$1,700.00

$1,500.00

$200.00

13.3%

 

Units:

100

90

10

11.1%

 

Gross Profit:

$685.40

$550.00

$135.40

24.6%

 

% Margin:

40.3%

36.7%

3.7%

 

______________________________________________________________________________________

200-101A5

Gadgets

       
 

Sales:

$1,567.50

$1,600.00

($32.50)

(2.0%)

 

Units:

50

55

-5

(9.1%)

 

Gross Profit:

$566.17

$400.00

$166.17

41.5%

 

% Margin:

36.1%

25.0%

11.1%

 

______________________________________________________________________________________

400-101

Whatsits

       
 

Sales:

$3,618.00

$3,000.00

$618.00

20.6%

 

Units:

60

40

20

50.0%

 

Gross Profit:

$1,213.29

$1,000.00

$213.29

21.3%

 

% Margin:

33.5%

33.3%

0.2%