Best way to handle rounding in reports

Summary:

Currently, we are handling rounding and footing by having an unrounded hidden column and using the round function in a visible column. At each section of the balance sheet we have a footing plug for rounding, so for total assets the report sums the rounded accounts under assets and compares that sum to the rounded Total_Assets accounts. The difference, if any, gets plugged to other assets so that the assets section foots. The same thing is done for the Liabilities section. After this, there is still sometimes a rounding issue with the total balance sheet footing so we take any