How to Record e-Transfers in QuickBooks Online
Match or categorize Interac e-Transfers in QuickBooks Online, avoid duplicate imports, handle common exceptions, and reconcile to the bank statement.
To record an Interac e-Transfer in QuickBooks Online, start with the posted bank transaction. Match it when the invoice payment, bill payment, expense, refund, or transfer already exists in QuickBooks. Categorize or add it only when there is no existing record to match. Then reconcile the account to the monthly bank statement until the difference is CA $0.00.
Use the e-Transfer notification to identify the sender, recipient, status, and reference—not as proof that the bank movement settled. Do not import the same period from both a connected bank feed and a manual bank file. A notification export is a supporting register, not a substitute for the bank feed or statement.
Should You Match or Categorize the e-Transfer?
The right action depends on what was recorded before the bank transaction arrived.
| Situation | QuickBooks action | Evidence to check |
|---|---|---|
| Customer invoice payment already recorded | Match the downloaded deposit to the existing payment | Invoice, payment record, bank deposit, notification |
| Supplier bill payment or expense already recorded | Match the withdrawal to the existing transaction | Bill or receipt, payment record, bank withdrawal |
| Transfer between the business's own accounts | Match or record both sides as a transfer | Both bank accounts, dates, amount, fees |
| No accounting record exists yet | Identify the business purpose, then categorize or create the supported record | Bank movement, source document, notification |
| Pending, cancelled, declined, or expired notification | Do not record it as settled merely because an email exists | Current status in known online banking |
| Equal amount but uncertain customer or purpose | Leave it for review; do not accept a suggested match on amount alone | Party, reference, invoice, date, bank details |
Intuit's current bank-transaction matching instructions say suggested matches can cover records dated up to 90 days before or 20 days after the downloaded transaction. A suggestion is still only a suggestion: verify the amount, date, party, account, and business purpose before posting it.
What Records Do You Need?
Keep three records connected for every material payment:
- Settlement record: the posted deposit or withdrawal in the financial institution's account and statement.
- Notification record: the Interac email details, such as direction, displayed name, amount, status, date, and reference when available.
- Business record: the invoice, bill, receipt, expense claim, contract, rent entry, loan document, or other support that explains the transaction.
The CRA's electronic record-keeping guidance requires electronic records to remain readable and source documents to be retained. A QuickBooks entry or e-Transfer email by itself does not create a complete audit trail.
How Do You Record and Reconcile e-Transfers in QuickBooks Online?
1. Choose one bank account and statement period
Work through one financial-institution account at a time, beginning with the oldest unreconciled statement. Note the statement's opening balance, ending balance, start date, and end date.
If the inbox receives notifications for several accounts, assign each transfer to the correct account before posting anything in QuickBooks.
2. Bring in the bank transactions once
Use the connected bank feed when it already covers the period. If it does not, start with a file downloaded from the financial institution.
Intuit's current manual upload instructions say to check the chart of accounts before uploading to avoid duplicates. The Canadian instructions accept supported bank files and explain the required CSV layouts: Date, Description, and Amount, or Date, Description, Credit, and Debit.
Do not upload a standard TransferLog CSV unchanged as a QuickBooks bank file. It is a notification register with separate direction, status, and reference fields; it is not a bank statement and is not formatted as a direct bank-feed replacement.
3. Build the notification matching register
For each transfer, record:
- sent or received direction;
- displayed sender or recipient and the known business party;
- notification date and posted bank date;
- amount, final status, and Interac reference when available;
- related invoice, bill, receipt, payroll item, or agreement;
- QuickBooks transaction or category; and
- unresolved exception notes.
Several emails can describe one transfer. A request, reminder, sent notice, Autodeposit confirmation, cancellation, and replacement should not automatically become separate payments. Connect messages using the reference, amount, parties, status, and timing.
Build a searchable e-Transfer record
Connect Gmail, Outlook, or iCloud. TransferLog organizes supported Interac notification details so you can search, filter, and export when you reconcile.
4. Review matches before creating new records
In QuickBooks Online, open All apps → Accounting → Bank transactions and select the account. Review any suggestion in the Match/Categorize column. If it is correct, post the match. If it is not, use the available match search or leave the item pending until you have enough evidence.
Create or categorize a new record only after identifying the transaction. An incoming e-Transfer is not automatically sales income, and an outgoing transfer is not automatically an expense. It may instead be a customer deposit, refund, employee reimbursement, owner contribution, shareholder loan, payroll item, or transfer between owned accounts.
5. Resolve partial, combined, and unusual payments
Do not force an amount into the wrong transaction merely to clear the bank feed.
- Partial invoice payment: apply only the amount received and leave the invoice balance open.
- Several transfers for one invoice: preserve each bank transaction and allocate the completed total to the same receivable.
- One transfer for several invoices: keep the original bank total and document the allocation.
- Customer deposit or overpayment: do not record unsupported money as earned revenue; keep the liability or credit treatment supported by the facts.
- Fee difference: record the obligation and the actual bank fee separately when the evidence supports both.
- Refund or replacement: add the new bank movement and link it to the original transaction instead of deleting history.
- Personal item: identify the owner-related or personal treatment rather than removing the real bank movement.
The partial e-Transfer payment workflow covers split invoice payments. For transfers between owned accounts, use the business-account transfer guide.
6. Reconcile to the statement
Intuit's QuickBooks Online reconciliation instructions say to enter the statement ending date and balance, compare each QuickBooks transaction with the statement, and finish when the difference is CA $0.00.
If the difference is not zero, check for:
- duplicate bank-feed and file imports;
- an incorrect opening balance or wrong account;
- a pending item recorded as posted;
- money-in and money-out directions reversed;
- a missing fee, refund, internal transfer, or timing difference; and
- a previously reconciled transaction that was changed.
Do not create a balancing adjustment simply to reach zero while the cause is unknown. Preserve the exception and ask an accountant how to correct the books.
7. Preserve the reconciliation package
Save the bank statement, QuickBooks reconciliation report, notification register, source documents, and exception resolutions for the same period. Keep unchanged copies of original downloads and any working file prepared for upload.
This lets you move from a QuickBooks entry back to the bank movement, notification, and business purpose months later.
Why Is an e-Transfer Missing From a QuickBooks Match?
A suggested match may be absent because the amounts differ, several payments were grouped, the dates fall outside QuickBooks' matching window, or the existing record was already reconciled. The bank feed may also use a description that does not reveal the sender or recipient.
Confirm the transaction in online banking, search QuickBooks by amount and date, and compare the notification reference and source document. If the accounting treatment is unclear, leave the item pending for the bookkeeper rather than choosing a convenient category.
How Does TransferLog Fit Into the Workflow?
TransferLog organizes details detected in supported Interac e-Transfer notification emails from connected Gmail, Outlook, or iCloud inboxes. You can search and filter records, assign categories, and export CSV or PDF on the Pro plan.
Use that export as a matching register alongside the bank statement and QuickBooks. TransferLog does not connect to QuickBooks or a bank account, post entries, create invoices, choose tax categories, or guarantee that every bank transaction has a notification.
For the broader register, read how to track Interac e-Transfer payments. If the payment is a supplier cost, use the business-expense e-Transfer workflow.
Official Sources
- QuickBooks Online: Match bank and credit-card transactions
- QuickBooks Online: Manually upload transactions
- QuickBooks Online: Reconcile an account
- CRA: Electronic Record Keeping
- Interac e-Transfer for Business
QuickBooks is a trademark of Intuit Inc. TransferLog is not affiliated with or endorsed by Intuit. This article provides general record-keeping information, not accounting or tax advice.
Organize supported e-Transfer notifications for reconciliation. Start free, then compare the notification register with your bank statement, QuickBooks records, and source documents.