Rounding Issues

I have made up a worksheet that uses the GL function to get data from Great Plains. I have put an Excel ROUND function around every GL function, SUM function and every other calculation within my worksheet and I am still getting rounding issues.

This is what my formula looks like:

=ROUND(-GL("Cell","Balance",,,Period,,"45",F$12,$B17,,,,,,,,,,,,,"Methodist Church of NZ","Great Plains"),2)

I have tred the following also:

=ROUND(-GL("Cell","Balance",,,Period,,"45",F$12,$B17,,,,,,,,,,,,,"Methodist Church of NZ","Great Plains"),0)

and had the same problem.

Anyone got a solution?

Should I be using the INT function instead of the ROUND function?

I am using EXCEL 2007, Windows XP with SP3 installed and have JetReports 9.2.10167.0 installed.

Peter