Matching transfers to members: the reconciliation problem nobody warns you about
A bank statement tells you money arrived. It rarely tells you whose. This is the single most tedious job in a volunteer-run organisation, and most of it is avoidable.
Every volunteer treasurer eventually meets the same evening. The bank statement is open in one window, the member list in another, and the job is to work out which of these forty transfers corresponds to which of these hundred and twenty people. Three of them are obvious. Most take a moment. Four or five will resist entirely, and those four or five will take longer than all the others put together.
This is reconciliation, and it is the single most tedious job in a small organisation. Most of it is avoidable, and the parts that are not can at least be made to stop haunting you.
Why it is genuinely hard
It helps to be clear that this is not carelessness on anybody's part. A bank transfer carries almost no identifying information by design. What arrives is an amount, a date, and a sender name that may be:
A nickname rather than the name on your member list. A spouse's account, because that is where the household money lives. A parent paying for a student member. A company account, because someone paid from work. An abbreviation the bank truncated to eighteen characters. Or a name that matches three different people in your list.
On top of that, the amount often does not match either. People round up. They pay for two members at once. They add an event fee without telling you. They pay last year's rate because that is what they remembered. Each of these is entirely reasonable behaviour by a member and entirely maddening at reconciliation time.
The habits that prevent most of it
Unique amounts. Add the member number to the fee so member 41 pays Rp 250.041. The amount becomes the identifier, and it survives everything above - it does not matter whose account it came from. This one habit eliminates most of the difficulty, and our guide on collecting dues by transfer and QRIS covers how to introduce it.
Ask for the reference anyway. It will not always arrive, but when it does it settles the ambiguous cases instantly.
Record the account they usually pay from. The second time somebody pays from "SITI RAHAYU" for a member listed as Dewi Anggraini, write it down against that member. You will never have to solve that puzzle again, and over two years this quietly removes most of your recurring mysteries.
Reconcile little and often. Twenty minutes weekly is far easier than two hours monthly, not because the work is less but because your memory of recent events is still intact. You will remember that someone mentioned paying for their friend. In four weeks you will not.
The rule that saves the most time: never let a payment sit unidentified for more than a week. After a week, the member has forgotten the details too, and what would have been a one-message question becomes an archaeology project for both of you.
What to do with the ones you cannot identify
There will always be a residue. Handle it with a policy rather than by staring at it, because the staring is what makes this job unbearable.
First, ask publicly but gently. A short note in the group - "we have a payment of Rp 250.000 on the 14th we cannot match, if that was you please let me know" - resolves a surprising proportion, and costs nobody any embarrassment.
Second, work backwards from who has not paid. If you have eleven unpaid members and three unmatched payments, the overlap is usually obvious once you look at the amounts and dates together rather than one at a time.
Third, keep an explicit holding list. A payment you cannot attribute is not lost and it is not income from nobody; it is money awaiting identification. Write it in a "suspense" line with the date and amount, and revisit it when the next renewal round produces someone insisting they paid. That person is your answer, and having the list means you can confirm them in thirty seconds instead of arguing.
Finally, set a limit on how long you will chase. After three months, take the amount as general income and move on. The time cost of pursuing a small unattributed payment exceeds its value very quickly, and a treasurer who cannot let go of the last four thousand rupiah is a treasurer who will resign.
The dispute you will eventually have
At some point a member will tell you, with complete sincerity, that they paid. Sometimes they did and you missed it. Sometimes they intended to and their memory has filled in the rest, which happens to everyone and is not dishonesty.
The way to survive this without damaging the relationship is to have made it a records question rather than a trust question. Ask them, kindly, for the date and amount - not as a challenge but because it lets you find it. If your reconciliation is up to date you can usually resolve it in a minute. If it is three months behind, you cannot, and now you are in a disagreement with a member about their honesty, which is a far worse outcome than any amount of money involved.
This is the real argument for keeping reconciliation current: not tidiness, but the fact that good records let you give people the benefit of the doubt without it costing you anything.
When to let software do it
Manual reconciliation with unique amounts is genuinely workable up to a few hundred members. Past that, or once more than one person needs to see who has paid, the arithmetic changes.
What a membership system actually changes is not the matching itself - it is that payment, member record and renewal status stop being three separate things that a human has to keep in agreement. When someone pays through a gateway or a dynamic QRIS code, the system knows who they are, marks them paid, sends the confirmation, and moves their renewal date, all without anyone opening a bank statement. Our guide to moving off the spreadsheet covers what that migration involves, and when it is worth doing.
Until then, unique amounts and a weekly twenty minutes will get you most of the benefit for none of the cost.
