Annual Income reports & MySQL

[Tozz]

Hello,

 

I am trying to determine my annual income. For some reason the reports from WHMCS differ from what I have gathered from MySQL. I was wondering if someone can explain these differences to me:

 

The Annual Income Report in WHMCS reports a value of (I mangled the numbers): 12.500,-

 

However, if I run a query:

 

SELECT SUM( subtotal ) FROM tblinvoices WHERE date LIKE '2012%' it returns +/- 8500,-

even including VAT:

SELECT SUM( total ) FROM tblinvoices WHERE date LIKE '2012%' it returns +/- 10.000,-

 

So, basicly WHMCS's report reports a couple of thousands more then what I can find using MySQL queries. My question is: What am I missing in my MySQL query?

[WHMCS Chris]

Hello - take a look at the reports, they're open source.