Project headline and detail totals not matching

Support
1

Hi, just trying to do some analysis on our projects. We tag everything so we can get a break down of project profitability. However, something doesn’t add up.

Project main page Money Out = £16,167.61
Drill down into ‘show tagged items’ and look at All Purchase Invoices and I have a total of £19,217.87.

Even looking at miss-tagging or adjustments I can’t see why there is this difference. All invoices are paid up. We generally have 2 tags per invoice (customer name and business stream). I’m looking at a customer project and am using the detailed list of ‘all purchase invoices’ but am concerned it doesn’t match ‘money out’ headline.
I don’t know if this is a bug or my miss-understanding of data.

Any suggestions as to why Money Out does not equal the sum of all invoices?

Thanks
Susie

2

It’s ok, worked it out. Money out excludes VAT, whilst sum of all invoices is sum of total including VAT.
I assume this is also for sales invoices, not so easy to spot as our products are currently 0% VAT.
s.

3

Hello @Susiec

Sorry for the slow response, I’m just working through the queries from the weekend.

I’m glad you managed to resolve this :+1:

4

This topic was automatically closed after 7 days. New replies are no longer allowed.