Why are my financial totals a penny off?
At times, you may see the totals on your financials page or in your Insights reports/dashboards be off be a penny or so. This happens because we store each item and rental rate in an unrounded state, which could be three or more decimal places depending on your taxes and service charges. When you load a page with financial information, the application looks at the stored unrounded number and then displays the number rounded to two decimal places.
The totals row does not total the rounded numbers in the display - it is totaling the unrounded numbers stored in the database. This is why, on occasion, the totals row can be off by a penny and seem to not be adding correctly.
The balance is rounded to two decimal places and stored in the database in that state. This is necessary because payments only ever have two decimal places, and we need to be able to accurately calculate the amount due for the event.
Do you have any additional questions or need further clarification? Please don't hesitate to contact us.