Certain revenue types appear to be excluded from the Revenue/Application Details/Gift Aid/Gross Amount fields. This looks to be because the revenue application items are not in the REVENUESPLITGIFTAID table so they are not returning any information for any of the values (NULL values). These appear to be the following types (which cannot have gift aid claimed against them): Transaction Type Application Matching gift claim Donation Planned gift Donation Payment Matching Gift Matching gift claim Pledge If this is the case then regardless of Application and Transaction type if there is no matching application id value within the REVENUESPLITGIFTAID table then it should return the relevant application amount, as no gift aid can be claimed on the revenue application. At the moment these blank values will throw off any reporting that reports on the gross amount of a gift.