Wise Reconcile
Payment addon
If your customers pay by bank transfer to a Wise account, someone has to record each payment in WHMCS by hand: find the proforma invoice named in the payment reference, and enter the amount and the Wise transfer number. The Wise Reconcile addon automates this step: it matches the incoming transfer to the right proforma invoice by the reference, and records the payment the same way you would by hand.
The addon records the payment through WHMCS’s own API under the configured payment method, and it also runs after every WHMCS cron run. It is for providers using WHMCS whose customers pay proforma invoices by transfer to a Wise Business account.
How it works
Two sources that confirm each other. Wise sends a notification email for every incoming transfer, which shows the payer, the amount, the reference and the Wise transfer number. Since anyone can forge an email, the addon only accepts it with a valid DKIM signature for the wise.com domain. The actual arrival of the money is confirmed by Wise’s webhook, which the addon verifies with Wise’s RSA signature. The webhook doesn’t contain a transfer ID, so the addon pairs the two by currency, amount and time; if the pairing is ambiguous, the items go to review.
Matching by proforma number. The addon reads the proforma number from the reference with a strict rule: only a standalone number counts – one that isn’t part of a word, doesn’t start with zero, and isn’t attached to another number, such as a date. The payment is recorded automatically if exactly one proforma is mentioned, it is unpaid, it is in the same currency, the amount equals the amount due, and the Wise transfer number isn’t in WHMCS yet. A single transfer can also cover several proformas if they all belong to the same customer and their balances add up exactly to the amount received.
Two delivery routes. The email can reach the addon in two ways. On an Exim mail server, an address can pipe it straight into the addon’s script; if the database is temporarily unavailable, Exim retries later. With Cloudflare Email Routing, a Cloudflare Email Worker forwards the message unchanged over HTTPS, with an HMAC signature. Both routes use the same verification and matching. Wise sends the email to the account’s login address, so it has to be forwarded to the receiving address with a mail filter; forwarding it unchanged preserves the DKIM signature.
Items that don’t match. Anything that doesn’t meet the rules goes into the review queue on the addon’s page, together with the reason. From there, an item can be recorded manually against a chosen proforma (as a partial payment if needed), paired with a specific webhook, retried or ignored. The addon never records duplicate payments or overpayments, not even at an administrator’s request, because WHMCS would book the excess as customer credit. For these, a button opens Wise’s refund page for the transfer in question; the refund itself has to be approved in the Wise interface.
Main features
- Combined verification of Wise’s notification email and webhook, with DKIM and RSA signatures.
- Matching by the proforma number in the reference, including one transfer to several proformas.
- Recording the payment with the Wise transfer number; the same transfer is never recorded twice, and that includes payments entered by hand.
- A review queue on the addon’s page, with duplicate payments and overpayments highlighted.
- Automatically ignores payouts, such as Stripe’s transfers, as well as specified payers or references.
- Configurable data retention: the raw email and webhook content of closed items can be deleted after a set time, while the matching records are kept.
What it doesn’t include
- It can’t carry out refunds automatically, because the Wise API doesn’t allow it.
- It currently recognises the fields of the Hungarian-language Wise notification; processing emails in other languages isn’t implemented yet.
- It doesn’t send email notifications about items waiting for review.
- Matching by uploading a bank statement isn’t included.