A customer pointed out that his numbers weren't adding up to the same things he could see in the Transactions report as well as the Cash Report. After an investigation we worked out it was because of a split payment over multiple months and financial years.
We have fixed it up now so the maths is making better sense of it all.