Forty lines that say J SMITH DONATION
On the first working day of the month, the charity bank account fills with small credits. The reference field says things like SMITH J, DONATION, MONTHLY GIFT or a sort code fragment. Some supporters used the reference you asked for, many did not. The bank truncates long names, joint accounts show the other partner's name, and two supporters called Smith both give on the same day.
Someone downloads the statement, opens the donor spreadsheet and works through it line by line, recognising the regulars from memory. The ones they cannot place go into a suspense list. By the time the list is looked at again, a supporter has phoned to ask why they never got a thank-you for three years of monthly gifts.
Why the bank line tells you so little
Standing orders are set up by the supporter in their own banking app, not by you. You control nothing about what the payment says.
- The reference is whatever the supporter typed, often nothing useful.
- Banks shorten the payer name, and joint accounts show whichever name the bank chooses.
- Amounts change when supporters increase their gift, so the amount alone is not a reliable key.
- Payment dates drift around weekends and bank holidays.
- When a standing order stops, nothing tells you; the line simply does not appear.
- The memory of who pays what lives in the head of the person who does the matching.
The underlying issue is that each month's matching starts from scratch. What was learned last month, that SMITH J 25.00 on the third is Mr John Smith of Leeds, is not stored anywhere a system can reuse.
What unmatched payments cost you
Unmatched gifts cannot be thanked, cannot be linked to a declaration, and do not show up in the supporter's giving history. Regular donors who are never acknowledged are more likely to stop, and when they do stop, you do not notice because you never knew who they were.
The suspense list grows. Year-end accounts need the income allocated, so someone does a painful catch-up under pressure. And the person with the mental map of the regulars becomes very hard to cover for when they are on leave.
How we build the bank matcher
- Statement lines come in from your bank's export or an open banking feed, or through the bank feed already in Xero or QuickBooks if you use one.
- Each credit is compared against known payment patterns: payer name fragments, reference, usual amount and usual day of the month.
- Where a supporter's pattern matches clearly, the gift is attached to their record automatically and marked as matched by rule.
- Where the match is partial, for example the right name and day but a new amount, it is proposed with a reason and held for a person to confirm.
- Unknown payments sit in a clear queue with any clues shown, and when a person identifies one, the pattern is saved so next month it matches without help.
- Expected payments that do not arrive are listed too, so a lapsed standing order is noticed within the month.
- Matched gifts are written to your donor database and, if you want, a thank-you or receipt step is triggered from there.
| Bank line | Pattern known | Result |
|---|---|---|
| SMITH J MONTHLY 10.00 on the 3rd | Mr J Smith, Leeds, 10.00, around the 3rd | Matched by rule |
| SMITH J 15.00 on the 3rd | Same pattern, different amount | Proposed as an increase, a person confirms |
| K PATEL DONATION 5.00 | No pattern yet | Unknown queue, saved once identified |
| Mrs Evans expected on the 1st | No payment this month | Listed as possibly lapsed |
The rules are yours to see and edit. If a pattern starts matching the wrong person, you can switch it off and the affected gifts are listed for correction.
The first week of the month afterwards
The statement comes in and most regular gifts are already matched before anyone opens it. The finance assistant spends their time on a short list of new or changed payments, each shown with the supporting clues. Lapsed standing orders turn up in a report the fundraising team can act on while the supporter still remembers giving.
When the assistant is on holiday, someone else can do the matching, because the knowledge is in the rules rather than in one person's memory.
Signs your bank matching needs this
- A suspense list of unidentified gifts that never quite clears.
- Regular supporters who have never been thanked.
- Only one person can match the monthly statement.
- You find out a standing order stopped months after it did.
- Year-end income allocation is a scramble.