How to Reconcile Interac e-Transfers in FreshBooks
Match Canadian e-Transfer payments to FreshBooks invoices, expenses, bank transactions, and statements without creating duplicate entries.
To reconcile Interac e-Transfers in FreshBooks, bring the posted bank transactions into the correct FreshBooks bank account once, then match each deposit or withdrawal to the invoice payment, expense, bill payment, transfer, owner-equity entry, or refund it represents. Use the bank statement to confirm settlement, the e-Transfer notification to help identify the payment, and the invoice or receipt to explain its business purpose.
Do not import the same money movement from both a bank connection and a CSV. A TransferLog export is normally a matching register, not a replacement bank statement or a file to upload unchanged into FreshBooks.
What Do You Need Before Reconciling in FreshBooks?
Collect four connected records for one bank account and period:
- FreshBooks entries: invoices, recorded payments, expenses, bills, credits, and transfers already in the books.
- Bank activity: imported transactions and the statement showing the opening balance, closing balance, and posted movements.
- e-Transfer details: displayed sender or recipient, amount, direction, status, dates, message, and Interac reference when available.
- Source documents: invoices, receipts, contracts, expense claims, or other records that support the purpose and tax treatment.
FreshBooks describes bank reconciliation as matching bank transactions to FreshBooks entries so the book and bank balances agree. Its current help centre says the feature is available on trials and on Plus, Premium, and Select plans. Features and plan access can change, so follow the options shown in your own account.
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.
Should You Import a TransferLog CSV Into FreshBooks?
Usually, do not upload it unchanged as bank activity. FreshBooks accepts CSV files for manual bank-reconciliation accounts, but its current format centres on dates and amounts, with optional description and operating-expense category fields. A TransferLog CSV is designed to preserve notification context, not to reproduce a financial institution's statement.
| Record | What it establishes | What it does not establish |
|---|---|---|
| Bank statement or bank import | Posted amount, account, date, and period balance | Which invoice, expense, or person the line belongs to |
| FreshBooks entry | Customer, supplier, category, tax, and open balance | That the money necessarily posted to the bank |
| e-Transfer notification register | Payment context, direction, lifecycle, and available reference | That every message is a separate completed payment |
| Invoice, receipt, or agreement | Business purpose, terms, subtotal, and tax details | The final bank status of the e-Transfer |
Use a notification export beside the FreshBooks and bank records to identify ambiguous lines. If you must prepare a bank-transaction CSV because a connection is unavailable or missing history, build it from the financial institution's posted activity, follow FreshBooks' current column rules, remove overlapping dates, and review the target account before importing.
How Do You Reconcile e-Transfers in FreshBooks Step by Step?
1. Set up one business bank account
Choose the FreshBooks bank account that corresponds to the statement. FreshBooks recommends connecting only a business account, reconciling in one currency, and setting a reconciliation start date and opening balance from the statement.
Start with the oldest unreconciled period. Do not combine several financial-institution accounts because the notifications arrived in one inbox.
2. Confirm that the bank activity appears only once
Decide whether the account receives transactions through a bank connection or a manual CSV upload. Check the imported date range before adding anything. Duplicate connections, overlapping files, and a manually created copy of an already imported line can all show the same payment twice.
Keep an unchanged copy of the source statement or download. If a transaction is missing, investigate the connection or add the missing bank activity through the method FreshBooks currently supports for the account.
3. Separate completed transfers from notification events
An Interac Request Money message, reminder, sent notice, pending transfer, cancellation, decline, or expiry is not automatically a posted payment. Confirm the status through known online banking and locate the corresponding bank transaction.
Several emails can describe one transfer lifecycle. Connect them using the reference, amount, people, dates, and status rather than creating one FreshBooks entry per message. Use the pending, cancelled, and expired e-Transfer workflow when the result is unresolved.
4. Match incoming customer payments
FreshBooks says imported money-in transactions do not affect its reports until they are matched or marked appropriately. If an invoice payment already exists as a FreshBooks entry, match the bank deposit to that entry after verifying the customer, amount, date, and account.
If no entry exists, create the appropriate payment or other-income entry only after the invoice or other source record supports it. An incoming e-Transfer could instead be a deposit, refund, owner contribution, loan, internal transfer, or personal amount.
For a partial payment, apply only the completed amount and keep the remaining invoice balance open. For one deposit covering several invoices, preserve the bank total and document allocations that add back to it. The partial-payment reconciliation guide covers both patterns.
5. Review outgoing expenses and bill payments
Match a withdrawal to the supplier bill, receipt, expense, or reimbursement it settles. Interac e-Transfer is the payment method, not the expense category. Use the source document for the category and GST/HST details.
FreshBooks explains that bank-connected money-out activity can appear as an expense before it is matched. Check for an existing expense or bill payment before creating another one. If the displayed recipient differs from the supplier, retain both names and document the relationship.
6. Mark transfers, owner movements, and refunds correctly
FreshBooks provides separate bank-reconciliation treatments for transfers, owner's equity, and expense refunds. Use the type supported by the facts instead of forcing every deposit into income or every withdrawal into expenses.
When money moves between two business accounts, link both sides so the movement does not duplicate income or expense. Follow the internal e-Transfer workflow when the same business controls both accounts.
7. Clear every bank transaction and review the balances
FreshBooks treats reconciliation as an ongoing match between the Bank Account Balance and FreshBooks Balance. Review the unmatched bank transactions until each has a supported match, new entry, or appropriate Mark As treatment.
Do not use an unexplained entry simply to make the balances agree. Check first for a wrong opening balance, missing import, duplicate row, pending transfer, wrong currency, manual journal entry, fee, refund, or transaction posted to another account.
Which FreshBooks Reconciliation Problems Need Extra Care?
- The payer name is unfamiliar: compare the amount, date, reference, invoice, and expected payments, then confirm through a trusted channel. Do not match on amount alone.
- A bank line and manual payment both exist: verify they are the same movement before matching or removing a duplicate; identical amounts can represent different transactions.
- The transfer settled after month-end: keep the notification date and posted date separately and reconcile the bank period that actually contains the movement.
- A fee posts separately: record the e-Transfer and financial-institution fee from their own evidence. TransferLog does not detect bank fees.
- A journal entry affects the bank account: FreshBooks warns that manual journal entries to a reconciled bank account can make the balances differ without appearing as a bank-reconciliation transaction. Ask an accountant how to correct the entry.
- The account uses several currencies: FreshBooks says bank reconciliation is single-currency. Preserve the original currency and obtain accounting advice before posting a conversion or gain/loss.
How TransferLog Fits Into a FreshBooks Workflow
TransferLog organizes details detected in supported incoming and outgoing Interac e-Transfer notification emails from connected Gmail, Outlook, and iCloud inboxes. You can search and filter records, assign categories, and export CSV or PDF on the Pro plan.
Use the export to help identify FreshBooks bank lines when the bank description omits a useful payer, recipient, status, message, or reference. TransferLog does not connect to FreshBooks or a bank account, create or match FreshBooks entries, post journal entries, verify settlement, calculate taxes, or replace invoices and receipts.
For the underlying register, start with how to track Interac e-Transfer payments. If you need to inspect or map the file first, use the e-Transfer CSV export workflow.
Official Sources
- FreshBooks: Set up bank reconciliation
- FreshBooks: Reconcile simple transactions
- FreshBooks: Reconcile complex transactions
- FreshBooks: Add or import manual bank-reconciliation transactions
- FreshBooks: Import transactions from a bank account
- CRA: Electronic Record Keeping
- Interac e-Transfer help and reference numbers
FreshBooks is a trademark of FreshBooks. TransferLog is not affiliated with or endorsed by FreshBooks. This article provides general record-keeping information, not accounting or tax advice.
Organize supported e-Transfer notifications before reconciling FreshBooks. Start free; export on Pro, then verify each match against FreshBooks, the bank statement, and source documents.