How to Match Interac e-Transfers to Invoices Automatically

To match Interac e-Transfers to invoices automatically, connect the inbox that receives your payment notices to software that reads each notice, finds the open invoice with the right amount and customer, and records the payment in QuickBooks. Clear matches are recorded on their own. Anything unclear goes to a person with a suggested answer and the email attached.

Why e-Transfers are hard to match by hand

Interac e-Transfer is easy for customers. It is harder for whoever keeps the books.

• The name does not match. A customer invoiced as "Smith Plumbing Ltd." pays from Jane Smith's personal account.
• The message is optional. Some customers type the invoice number. Many do not, or type it three different ways.
• The bank line is thin. The deposit in your bank feed may not carry the customer's message, so you cannot always tell which invoice it pays.
• Payments come in bunches. One transfer covers two invoices. Another pays half of one.

So someone opens each notice, searches QuickBooks for the amount, guesses, and records it. At month end, the leftovers pile up.

What an e-Transfer notice tells you

Each notice email is a small bundle of useful data. A matcher should read all of it.

• The sender's name. Interac says a real notice contains the sender's full legal name and comes from notify@payments.interac.ca (Interac).
• The amount and the sender's message. With Autodeposit, the email includes the sender's name, the amount deposited, and any message the sender included (ATB Financial).
• A reference number. Interac's notices for received transfers include a reference number (Neo Financial). It is the best key for spotting duplicates.
• Whether the money is in. An Autodeposit notice means the funds were deposited. A standard transfer still has to be accepted.

Two cautions before you automate anything:

1. Keep sender messages switched on. Recipients can opt out of seeing sender messages in their notices (ATB Financial). On the inbox that receives payments, that would throw away the invoice numbers you need.
2. Expect fake notices. Interac warns people to be suspicious of notices they were not expecting (Interac FAQ). A matcher should check the sender address and never treat an email alone as proof of payment.

The matching rules that work

A good matcher works through a fixed order of checks, from most certain to least. Here is the order we recommend:

1. Invoice number in the message. Look for your invoice number format, and handle the variations people type: "INV-1042", "inv 1042", "#1042", "invoice 1042". If the number exists, the customer matches, and the amount matches the balance, it is a clear match.
2. Exact amount from a known payer. Keep a list of payer names for each customer. When Jane Smith pays for Smith Plumbing Ltd. once and someone confirms it, the matcher remembers her next time.
3. Exact amount, one open invoice. If only one open invoice in your books has that exact balance, it is a strong suggestion, but not a certainty. Send it to a person to confirm unless you have decided otherwise.
4. Everything else goes to a person, with the notice, the likely invoices, and the reason it could not decide.

This is where AI helps. Plain rules handle clean invoice numbers well. An AI model is better at reading a free-text message like "for the March job at the Elm St site" or matching "J Smith" to "Smith Plumbing." A good split: AI for the messy reading, plain rules for the final decision.

What the notice shows	What the matcher does
Invoice number, right customer, right amount	Records the payment
Known payer, exact amount, one open invoice	Records it, or asks, depending on your setting
Exact amount, but the payer is new	Suggests the invoice, waits for a person
Amount matches nothing	Sends to a person with the notice attached
Reference number already recorded	Stops. Flags a possible duplicate

Partial, duplicate, and unclear payments

These are the cases that make or break a matcher. Decide how each one works before you build.

• Partial payments. QuickBooks Online lets you apply a partial amount to an invoice and leave the balance open (QuickBooks Canada). The matcher can record it, but a person should see it, since a short payment may mean a dispute.
• One payment, several invoices. If the amount equals the exact total of two or three open invoices for that customer, and the message names them, record it across all of them. If not, send it to a person.
• Overpayments. Never guess. A person decides whether it is a credit, a tip, or a mistake.
• Duplicate notices. Use the reference number as the key. The same reference must never be recorded twice.
• Paid twice. If the invoice is already paid, perhaps by cheque, flag it for a refund or credit.
• Unknown senders. Send them to a person. Once confirmed, add the payer name to that customer's list.

Recording the payment in QuickBooks Online

In QuickBooks Online, a payment against an invoice is recorded with Receive payment: pick the customer and the payment date, enter the reference number and amount, choose the deposit account and payment method, and apply it to the open invoice (QuickBooks Canada). A matcher does the same steps through Intuit's API, creating a payment linked to the invoice (Intuit Developer).

A few settings make the books cleaner:

• Put the Interac reference number in the payment's reference field, so anyone can trace it back to the email.
• Create a payment method called "Interac e-Transfer," so reports can separate these payments from cheques and cards.
• Let the bank feed confirm it. When the deposit shows up in your bank feed, QuickBooks offers to match it to the payment already recorded, so it is not counted twice (QuickBooks Canada). That match is also your proof the money actually arrived.

Make matching easier from the start

The best matcher is one that rarely has to guess. A few changes help:

• Ask for the invoice number. Print "Please include invoice number in the e-Transfer message" on every invoice.
• Use Request Money. Interac Request Money has optional message and invoice number fields (Interac), so the payment comes back tied to the invoice.
• Ask your bank about Interac e-Transfer for Business. It supports structured remittance data, such as an invoice number field, that accounting software can use to reconcile payments (Interac).
• Turn on Autodeposit for the business email, so payments land without anyone answering a security question.

How we run this in our own business

We built an e-Transfer matcher for our own back office before we offered it to anyone. Interac notices are read as they arrive, matched to the right invoice, and recorded as paid. Nobody scrolls through the inbox at month end.

Our automations report their own failures to Microsoft Teams, so a broken connection gets fixed fast instead of being found at month end. You can see the rest of our back office in how we run CloudWise on what we sell.

The same approach fits any business that invoices in QuickBooks Online and gets paid by e-Transfer: trades, property managers, clinics, and distributors. For more ways to cut double entry, see QuickBooks Online automations that save hours every week.

What it costs

On our plans, building and running a matcher is part of the monthly subscription: Core at $3,500 or Scale at $6,000 CAD. Hosting and upkeep are included. Outside costs, like AI usage for reading messages, are billed at cost with no markup. When plain rules do most of the matching, AI usage stays low. See pricing or our automation service for details.

Not sure it is worth it for your volume? Count the e-Transfers you receive in a normal week and the minutes each one takes, then run the numbers in our automation ROI calculator.

Common questions

Can QuickBooks Online match e-Transfers to invoices on its own?

QuickBooks can match a bank deposit to a payment you have already recorded, and bank rules can categorize transactions. But the deposit line from your bank may not include the customer's message or invoice number, so a person usually still decides which invoice it pays. The notice email carries more detail, which is why a matcher reads it.

Is it safe to let software read our payment emails?

It can be, if it is set up with care. Use a dedicated inbox for payment notices, give the automation access to that inbox only, check that notices come from Interac's real address, and confirm each deposit in the bank feed. Never let an email alone mark an invoice paid without that check somewhere in the process.

What happens when one e-Transfer pays two invoices?

A good matcher checks whether the amount equals the exact total of that customer's open invoices, and whether the message names them. If both line up, it records the payment across the invoices. If not, it sends the payment to a person with the likely invoices listed.

Does this work with Autodeposit?

Yes, and Autodeposit makes it simpler. The notice says the money has been deposited, so there is no security question to answer and no waiting for someone to accept the transfer. Standard transfers still work, but the matcher should wait until they are deposited.

If you want to see how much time payment matching costs your team, book a free 30-minute Automation Map call. We will look at how payments move through your week and show you what we would build first.