If you use the formula

=SUM(A1*0.01) and A1 contains $562.50 then the result will be $5.62

**5**
Now, presumably because you have the cell formatted to show two decimal places (i.e. cents), the result displays as $5.63 BUT the underlying value is still $5.625 and therefore when you sum these values excel correctly uses the actual underlying value and the result displayed does not appear to tally correctly.

If you use my suggestion and change the formula to ROUND(A1*0.01,2) then the actual value of B1 will be changed to $5.63 so when you sum column B you'll get the answer you expect.

I'm assuming that you're using a formula like SUM(B1:B10) to give the total at the bottom.....