University of Washington

Why is my total cost in SAGE Budget off by a dollar or two?

SAGE Budget calculations are done using eight decimal places, and then each field is rounded for display depending on your preference. If you selected to "round amounts to the nearest dollar" on the Properties page, all dollar amounts in your budget are displayed rounded to the nearest whole number using “banker’s rounding.” In banker’s rounding, numbers ending in .5 round to the closest even number, instead of always rounding up.

Because this rounding method is different from Excel, the final totals may be off by a dollar or two when compared to a spreadsheet. The amount is insignificant enough that OSP will accept it.

Rounding is a display-only function. When you click into an editable field in your budget worksheet, you will see the exact amount you entered, and all calculated fields also use these exact amounts.

© 2015