Help with Gift Aid schedule uploads
Plain English answers to the problems treasurers most often hit with HMRC's Gift Aid schedule. Useful whether or not you use Donor Schedule. Each page links to the HMRC guidance it is based on.
Getting started
- Gift Aid schedule spreadsheet template: where to get it and what goes in each columnWhere to download HMRC's own Gift Aid schedule template, which version to pick, and what each column and box expects.
- How to fill in HMRC's Gift Aid schedule, step by stepA plain English walk through, from a blank HMRC template to a schedule ready to attach to your Charities Online claim.
- Exporting your donations from Stripe, PayPal, SumUp and your bankHow to get a CSV file out of the places donations usually arrive, and what columns to look for.
- Gift Aid claim deadline: the 4 year ruleHow long you have to claim Gift Aid on a donation, according to HMRC, and the shorter deadline for the Small Donations Scheme.
Upload errors
- Gift Aid schedule errors: a checklist before you uploadThe common reasons a Gift Aid schedule will not upload or loses donations, what causes each one, and where to find the fix.
- Error message beginning "ASM"What HMRC says causes ASM errors when you upload a Gift Aid schedule, and how to fix them.
- Other system errors: blank spaces and hidden charactersHMRC's first suggestion for most other upload errors is to check for stray spaces before or after donor details.
- Charities Online cannot read the schedule: check the worksheet nameThe worksheet inside HMRC's template has a special name. If it changes, the upload can fail.
- Save as .ods, not .xlsx or .csv, and which template to useCharities Online expects HMRC's template saved in OpenDocument format. Here is how to get that right in Excel and LibreOffice.
Filling in the rows
- Titles, names and hyphensThe small rules about titles and names that cause a surprising number of rejected rows.
- Postcode errors, overseas donors and BFPO addressesHow HMRC wants postcodes written, and what to do for donors outside the UK.
- Date errors, DD/MM/YY and the earliest donation dateHow to enter donation dates so Charities Online accepts them, including the earliest date box at the top of the schedule.
- More than 1,000 donations in one claimEach schedule holds up to 1,000 lines. If you go over, the extra lines are not included in your claim.
- Regular donations and standing orders: one line per donorHow HMRC lets you put a donor's regular gifts on one line of the Gift Aid schedule, and why accounting periods matter.
- Aggregated donations and sponsored eventsHow to group small donations, how to enter sponsored events, and the £20, £500 and £1,000 limits.
- Telling HMRC about an earlier over-claim (Box 2)How to use Box 2 on the Gift Aid schedule when you were overpaid on a previous claim, and the common mistake to avoid.
Let the free checker find these for you
Load your donation export and see every row HMRC is likely to reject, with the reason and the fix. Nothing is uploaded, and you don't need an account.