I am looking to produce a supplier specific spend report using Xero. In the good/(bad) old days it was a case of producing a supplier day book report for invoices and credit notes using Sage filtered to the appropriate supplier.
There are a significant number of transactions involved and I am trying to understand the data used for the reports as I get two different total spend figures for the year using the following which is a worry:
Accounting>Reports>Purchases>Supplier Invoice Report
Accounting>Reports>Purchases>Payable Invoice Summary
The total value I am looking at is just under £2m total purchase ledger spend and there is a £8k difference between the figure reported using these two reports?
The first report looks like the expected day book format.
The second report is the newer Xero report with more filter options and refers to source as 'payable invoice'
I would still expect these to report the same figures for the same periods or have I got this wrong?
I have tested this across a couple of other clients with a similar result although, looking at single months in isolation, some months do agree.
Can anyone confirm why the figures would be different?