Why the customers tab shows small differences between invoice detail and total revenue

Why the invoice level detail and total revenue on the Customers tab can differ by a few dollars, and why rounding causes it.

Table of Contents

In the Customer tab of the system, displayed values are rounded.  This can result in small differences (typically no more $1 or $2) if you look across many invoices or lines. 

Here are the details of how the system rounds:

In displaying the spread revenue per month at the invoice level , amounts are rounded to the nearest $1/ £1 / €1. 

In displaying the spread revenue per month at the customer level , amounts are rounded to the nearest $1/ £1 / €1. 

The rounding is only for the display.  All data is stored to four significant digits. 

As an example, Customer ABC has 2 invoices with revenue to be recognized in June 2022.  Each annual invoice has a value of £10,000.  

Revenue from invoice 1 will display as £833.  The value stored in the database will be £833.3333.

Revenue from invoice 2 will display as £833. The value stored in the database will be £833.3333.

Across the two invoices, the revenue in June is displayed as £1667.  The value stored in the database is £1667.6667.

This display is intentional in order to make the visual display easy to review, across many invoices, customers and months.  

Finally, in the Deferred Revenue Journal report, the system will display values to two significant digits.  Using the example above, the system will display the value as £1667.67