Rounding Differences

You may notice a slight rounding difference between the amounts on some summary and detail reports. This difference occurs because of the way that each report rounds sales data figures. The detail report sums sales by categories and then rounds the category sum. Higher level detail reports sum all categories and then round the sum. This can result in a difference of a few dollars between reports. Consider the following example:

The Purchase to Sales Comparison Detail By Store report lists the following purchase and sales category amounts for profit center 100.

BEER AND WINE	Purchases Sales	3,154 2,713
CIGARETTES	Purchases Sales	2,965 3,182
DELI/FAST FOOD	Purchases Sales	n/a 316
GROCERIES	Purchases Sales	-6,943 1,226
GROCERY-REDUCED	Purchases Sales	9,626 1,932
HBA	Purchases Sales	239 108
NON-TAXABLE	Purchases Sales	378 381
SOFT DRINKS	Purchases Sales	2,400 1,187
TOTAL	Purchases Sales	11,819 11,045

This detail report sums all sales and purchases by category and then rounds the totals to the nearest dollar for each category.

This detail report's parent report lists the following purchases and sales for all categories for the profit center:

TOTAL

Purchases
Sales

11,819
11,046

Notice that the total sales amount differs by 1. This occurs because the detail report sums each category, rounds the total for each category, and then totals the rounded amount for all categories. For the sake of efficiency and speed, the parent report sums all categories, and then rounds the total. This calculation method for summary reports results in a much faster report run time.