Making Sense of the Gift Aid Spreadsheet

Quick Answer

The Gift Aid Spreadsheet gives information supporters have declared either via Donr’s Text Giving service or our Appeal Pages from 2019 or earlier so that your charitable organisation can claim Gift Aid funds from HMRC on the donation they made via one of our products.

Want to know a little more?

Where do I Find the Gift Aid spreadsheet?

While Donr does not make Gift Aid claims from HMRC on behalf of our Charity Partners. We can, and do, take Gift Aid declaration information from supporters on behalf of our Charity Partners so that they can make the claim themselves.

This information can be found, and downloaded, in the Gift Aid section of the Donr Dashboard. It is sorted by campaign and by month. The blue ‘CSV’ button allows you to download a spreadsheet of the information you’ve currently called up on your screen. For instance, if you have 25 active campaigns with Donr and want to see all information on all of the Gift Aid declarations made by your supporters in the calendar month of May 2019, simply click ‘Select all’ in the ‘Sort by Campaign’ drop-down menu, select ‘May 2019’ from the ‘Sort by Month’ drop-down menu and click ‘Filter.’

This will display the information you’re looking for on-screen then, when you click the blue ‘CSV’ button, the same information will be downloaded to your computer in the form of a CSV spreadsheet (you can export this into an MS Excel spreadsheet by clicking ‘save as’ and changing the file type).

What am I Looking At?

The Gift Aid spreadsheet will be organised into the following columns:

Accountid: a reference number to help Donr’s Tech team identify this declaration, in case of any technical issues

Campaignid: a second reference number to help Donr’s Tech team identify this declaration, in case of any technical issues

First name: the supporter’s first name

Surname: the supporter’s surname

Address 1: the first line of the supporter’s address

Address 2: the second line of the supporter’s address

City: the town/city line of the supporter’s address

Postcode: the supporter’s post code

Amount: the amount donated

Gift Aid claim: the amount that can be claimed in Gift Aid from the supporter’s donation

Bill method: the method used to make the donation

Bill route: the mobile network/card payment provider used to make the donation

Logged: the date and time the donation was made.

Yyyymmdd: the date the donation was made.

Please note, unless you have certain permissions, some of the information in the spreadsheet may be partially redacted. Please see this FAQ to learn how to gain appropriate user permissions to allow you to see full, non-redacted information on your organisation’s donations.

Latest blog post

The Christmas Hub

Spotlight on

Text-to-donate allowed Teesside Hospice to run a viral ‘keepy up’ challenge, in which amateur and professional footballers attempted to do 26 keep ups to raise awareness and funds for the hospice
text-donate-charity

FAQs

Any questions...

…then look no further for our FAQs pages with answers to a wide range of questions and cover everything you need to know to get started.

Can't find what you're looking for?

or call us on 0333 4444 111 👋🏼

Adding Text Giving to your digital fundraising or emergency appeal? Read our COVID-19 Info Hub