Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Does a School Development Office Record Donations and Gift Aid Declarations Without Spreadsheets and Paper Forms?
Problems We Solve

How Does a School Development Office Record Donations and Gift Aid Declarations Without Spreadsheets and Paper Forms?

Independent school donations arrive by card, cheque and standing order, with Gift Aid forms on paper. We build donation records linked to declarations.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

A school development office receives gifts by card, bank transfer, standing order and cheque, with Gift Aid declarations on paper forms, and keeps the records in spreadsheets alongside the finance ledger. We build donation records where every gift is recorded against the donor with its fund, linked to a valid declaration where there is one, reconciled with finance and ready for your Gift Aid claims.

A cheque, a standing order and a form

An alumnus sends a cheque for the bursary fund with a handwritten note. A former parent sets up a monthly standing order for the new sports hall. A current parent gives online after the summer concert. Each might be eligible for Gift Aid, and the development office has a paper declaration form for some of them, an online tick box for others, and nothing for the rest.

At claim time, the development officer works through a spreadsheet, checking each gift against a declaration and against the bank statement, and then prepares the claim.

Gifts and declarations are recorded separately

Gifts arrive through several routes and are recorded by finance for accounting and by the development office for relationships. Declarations are kept separately again. Bringing all three together for each donor is a manual job, done under pressure at claim time.

  • Gifts arrive by card, transfer, standing order and cheque.
  • Declarations are on paper forms or online tick boxes.
  • The development office and finance keep separate records.
  • Funds and restrictions are noted inconsistently.
  • Donor thank-yous depend on someone noticing the gift.

What separate records cost

Days of work at claim time. Gift Aid that could have been claimed on eligible gifts, and was not, because the declaration could not be found. Gifts allocated to the wrong fund. Donors who are thanked late or not at all, which matters more than almost anything else in fundraising.

Restricted gifts carry an extra risk. A donor who gives specifically to the bursary fund expects that money to support bursaries, and the school's annual report and its trustees will want to show that it did. If the restriction was noted only in the covering letter, and the gift was entered as unrestricted income, putting that right later is awkward for everyone.

Whether a gift is eligible for Gift Aid and how claims are made follows HMRC's rules. Your finance team and advisers decide; the system keeps the records they need.

Donation records we build

  1. Every gift is recorded against the donor's record, with the date, amount, route, fund and any restriction.
  2. Online gifts are recorded automatically from your donation page or payment provider; bank and standing order gifts are matched from the bank feed; cheques are entered by the office.
  3. Gift Aid declarations are captured online in the donation flow, or scanned and recorded from paper, with the date and scope of the declaration.
  4. Each gift shows whether a declaration covers it, and gifts without one are listed so donors can be invited to make one.
  5. Totals by fund reconcile with the finance ledger, and differences are listed.
  6. Records are prepared in the format your finance team needs for Gift Aid claims, for them to check and submit.
  7. New gifts prompt a thank-you in wording you approve, with the development director alerted to gifts over a level you choose.
Gift routeHow it is recordedDeclaration
Online donationAutomatically from the paymentCaptured in the same flow
Standing orderMatched from the bank feedLinked from donor record
Bank transferMatched from the bank feedLinked or requested
ChequeEntered by the officePaper form scanned and recorded

Records that are ready when you need them

Claim time becomes a check of prepared records rather than a week with a spreadsheet. Every gift is in the right fund and reconciles with finance. Donors are thanked promptly and personally. And the development office knows each donor's giving history when they next meet.

On a normal day after a concert appeal, twelve online gifts arrive with declarations, two standing orders are matched from the bank, and one cheque is entered. Thank-yous for all fifteen are ready for the development director to review by the afternoon.

Signs your gift records need this

  • Gift Aid declarations are on paper forms.
  • Gifts are tracked in a spreadsheet alongside finance.
  • Gift Aid claims take days to prepare.
  • Some eligible gifts are not claimed.
  • Donors are thanked late or inconsistently.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does it submit Gift Aid claims?

It prepares the records. Your finance team checks and submits claims under HMRC's rules.

Can it work with Raiser's Edge?

Often, if you already use it, we connect to it rather than replace it.

What about gifts from overseas donors?

They are recorded the same way; eligibility for tax reliefs is for your advisers.

Can donors give monthly online?

Yes, through a payment provider that supports recurring gifts.

What affects the cost?

Your CRM and finance system, bank feed options and how many gift routes you use.

Keep reading

More on Problems We Solve

Start here

Tell us how your development office keeps its records

Describe where your alumni, parent and donor records live today, how gifts and events are recorded and what is still in spreadsheets. We will tell you what we would build and what we would leave alone, and if your existing CRM can already do it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →