How to Reconcile Interac e-Transfers in QuickBooks Online

To reconcile Interac e-Transfers in QuickBooks Online, use the posted bank transaction as the evidence that money settled, use the e-Transfer notification to identify the other party and reference, and use the invoice, bill, receipt, or agreement to explain the business purpose. Match the bank transaction to an existing QuickBooks record when one already exists. Categorize it as a new record only when there is nothing to match, then reconcile the account to the monthly bank statement.

Do not import the same transfer from both a bank feed and a CSV, and do not treat an e-Transfer email as a bank statement. Those are two common ways to create duplicates or mark a payment complete before it has actually posted.

What Records Do You Need Before Reconciling?

Gather three connected records for the period:

• Settlement record: the posted deposit or withdrawal in the financial institution's account and statement
• Notification record: the e-Transfer email details, including direction, displayed name, amount, status, date, and reference when available
• Business record: the customer invoice, supplier bill or receipt, expense claim, contract, rent entry, loan document, or other support explaining the payment

The Canada Revenue Agency's electronic record-keeping guidance says electronic records must remain readable and that businesses must retain source documents. It lists bank statements, invoices, contracts, deposit slips, and relevant emails among the records that can form an audit trail. A QuickBooks entry or notification alone does not replace that trail.

Before changing anything, also identify:

• The QuickBooks company and bank account
• The statement start and end dates
• The opening and ending statement balances
• Whether the bank feed already downloaded the period
• Any bank CSV, QBO, QFX, or OFX file already uploaded
• Invoices, bills, expenses, or transfers already entered in QuickBooks

Should You Import the e-Transfer Export Into QuickBooks?

Usually, start with the financial institution's feed or download rather than an email-notification export. The bank record is the source for the account movement. The notification register helps identify and support that movement.

Intuit's current manual upload instructions for QuickBooks Online accept bank files such as QBO, QFX, OFX, and CSV. A bank-transaction CSV needs either Date, Description, and Amount columns, or Date, Description, Credit, and Debit columns. Review the target account and existing transactions before uploading so the same period is not added twice.

A standard TransferLog CSV is a notification register, not a ready-made QuickBooks bank file. It keeps money direction in a separate Type column and includes notification fields that do not all map to the bank upload. Do not upload it unchanged and assume QuickBooks will interpret sent and received amounts correctly.

If your bank feed is unavailable and you prepare a working import file, use the financial institution's posted transactions as the base. Map money in and money out correctly, keep a copy of the original files, and review the proposed rows before confirming the import. Ask your bookkeeper which import route fits your chart of accounts and existing records.

How Do You Reconcile e-Transfers in QuickBooks Online?

1. Define one account and statement period

Reconcile one financial-institution account at a time. Start with the oldest unreconciled statement, confirm its opening balance, and note its ending date and balance.

Do not combine transfers from several bank accounts into one reconciliation. If the same notification inbox receives activity for multiple accounts, assign each matched transaction to the correct account before continuing.

2. Build or export the notification register

Create one row for each transfer event you need to review. Include:

• Sent or received direction
• Displayed sender or recipient
• Known customer, supplier, employee, tenant, or other party
• Notification date and posted bank date
• Amount and status
• Interac reference number when available
• Related invoice, bill, receipt, or internal reference
• QuickBooks match, category, and exception notes

Do not count every email as a separate payment. A request, reminder, sent notice, Autodeposit confirmation, cancellation, and expiry may describe different stages of the same transfer. Use the reference, amount, parties, status, and timing to connect the messages.

3. Confirm every completed item against the bank

Open the financial institution through its known app or website. Match each transfer marked completed to a posted deposit or withdrawal. Leave a pending, cancelled, declined, or expired transfer out of settled totals until the account shows what happened.

Investigate a notification without a bank transaction and a bank transaction without a notification. The first may not have settled; the second may have a missing email, a different payment method, or a feed description that needs identification.

4. Match existing QuickBooks records before adding new ones

When an invoice payment, bill payment, expense, refund, or transfer is already recorded in QuickBooks, match the downloaded bank item to it. Intuit's bank-transaction matching guidance explains that matching connects the downloaded movement with an existing record.

Review the date, amount, account, and party before accepting a suggestion. An equal amount near the same date is not enough when several customers pay the same price or several properties collect the same rent.

If no record exists, categorize the bank item only after the source document supports its business purpose. An incoming transfer is not automatically sales income, and an outgoing transfer is not automatically an expense. It could be a customer deposit, refund, reimbursement, owner movement, loan, or transfer between the business's own accounts.

5. Resolve exceptions without forcing a match

Keep an exception list for items that need more evidence:

• Different displayed name: retain the e-Transfer name and the QuickBooks customer or supplier name; confirm the relationship before matching.
• Partial payment: apply only the amount received and leave the invoice balance open.
• Several transfers for one invoice: preserve each bank transaction and match or allocate the total to the same receivable.
• One transfer for several invoices: keep the original bank total and document the allocation to each invoice.
• Deposit or overpayment: keep the unsupported amount as a customer liability or credit until the facts support its treatment.
• Fee difference: record the gross obligation and bank fee separately when the evidence supports both.
• Refund or correction: add the outgoing movement and link it to the original receipt instead of deleting history.
• Transfer between owned accounts: link both sides so the movement does not create income or an expense.
• Personal item in a business account: identify and exclude it from business income or expense categories rather than deleting the bank movement.

Use the partial e-Transfer payment workflow when several payments affect one invoice. For money moved between the business's own accounts, follow the internal e-Transfer reconciliation guide.

6. Reconcile QuickBooks to the statement

Intuit's QuickBooks Online reconciliation instructions say to compare QuickBooks with the bank or credit-card statement, enter the statement ending date and balance, and review each transaction. Finish only when the difference is CA $0.00.

If the difference is not zero, check for:

• A duplicate feed and CSV import
• A transaction entered in the wrong account
• An incorrect opening balance
• A pending item treated as posted
• A sent transfer recorded as money in, or a received transfer as money out
• A fee, refund, internal transfer, or timing difference that was missed
• An edited transaction from a previously closed reconciliation

Avoid entering a balancing adjustment merely to make the screen reach zero when the underlying difference is still unknown. Preserve the exception and ask an accountant how to correct the books.

7. Preserve the reconciliation package

Save the statement, reconciliation report, notification register, source documents, and exception resolutions for the same period. Keep an unchanged copy of any original export plus the mapped working file used for an upload.

This makes it possible to move from a QuickBooks entry back to the bank movement, notification, and business purpose. It also protects the audit trail when a sender name or bank description is not recognizable months later.

How TransferLog Fits Into a QuickBooks Workflow

TransferLog organizes details detected in supported Interac e-Transfer notification emails from connected Gmail, Outlook, or iCloud inboxes. You can review sent and received items, search and filter them, assign categories, and export CSV or PDF on the Pro plan.

Use the export as a matching register:

1. Filter the statement period and relevant inboxes.
2. Review the detected dates, names, amounts, directions, statuses, and references.
3. Confirm completed items against the bank account.
4. Add the related invoice, bill, receipt, or other source reference.
5. Match or categorize the bank transaction in QuickBooks.
6. Record exceptions and complete the statement reconciliation.

TransferLog does not connect to QuickBooks or your bank account, post journal entries, create invoices or bills, choose tax categories, or guarantee that every bank transaction has a notification. Its CSV is not a direct QuickBooks bank-feed replacement. It reduces the inbox work involved in identifying and supporting e-Transfer activity.

For the underlying notification register, read how to track Interac e-Transfer payments. If you are reconciling supplier costs, use the business-expense e-Transfer workflow.

Official Sources

• QuickBooks Online: Manually upload transactions
• QuickBooks Online: Match bank and credit-card 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; export on Pro, then match the file with your bank statement, QuickBooks records, and source documents.