When you export the VAT transaction report to csv (so that you can create a proper table in excel) it exports Credit Notes as positive figures rather than negative.
The EXCEL extract is not a usable alternative, due to the spaces / extra lines / etc…