Skip to content

How to Import Relay Transactions into QuickBooks (Online Bank Feed, Desktop, Visa Card)

By ConvertQBO Team ·

Relay connects to QuickBooks Online directly, but not to QuickBooks Desktop: its help center says plainly that “QuickBooks Desktop isn’t supported.” Relay also has no QuickBooks (.qbo) download. It exports CSV and OFX, so Desktop users need one conversion step. Here are both paths, plus the Relay Visa credit card, which has its own connection.

Option 1: QuickBooks Online bank feed

  1. In QuickBooks Online, find the Bank accounts box on the dashboard and click Connect accounts.
  2. Search for Relay Financial and sign in with your Relay login.
  3. All your Relay checking and savings accounts are selected. Untick any you don’t want, then confirm.
  4. Match each Relay account to a bank account in your chart of accounts.

Things Relay’s guide points out:

  • You need the Administrator or Manager role in Relay. Other roles can’t authorize the connection.
  • Only settled transactions sync, every few hours. Pending ones show up once they clear.
  • Renaming an account in Relay doesn’t carry over. Rename it in QuickBooks too.
  • You can change which accounts sync later: in Relay, open the QuickBooks Online integration, click Manage, and use Bank feeds selection and Account mapping. If transactions are missing, check that the account is ticked and mapped there first.

Relay’s article doesn’t say how far back the first sync goes. If older months are missing, upload them from a file (Option 2) for exactly the dates the feed doesn’t cover.

Expense Management is a separate QuickBooks Online sync. Once you turn it on, you push categorized transactions, with receipts, memos and vendors, from Relay’s Expenses tab yourself. Nothing moves automatically. Relay recommends keeping the bank feed connected alongside it so the history lines up.

Option 2: export a file (QuickBooks Desktop, or Online without the feed)

Relay gives you two kinds of export, both on the web, not in the mobile app:

Monthly statements (CSV or OFX): Settings → Account Statements (or Accounts → the sub-account → ⋯ → View Statements). Tick the statements and click Export X Statements, then choose PDF, CSV or OFX and click Export. Leave Combine into one file unticked: combined exports are PDF only. The mobile app offers PDF and CSV, but not OFX.

A custom date range (CSV): Settings → Account Statements → Generate a Custom Report. Pick the From and To dates, set the toggle to Accounts, tick the accounts and choose CSV. One report can cover up to 366 days, so split longer periods. Use this when you need the current month, or dates that don’t line up with a statement.

Import into QuickBooks Desktop: Desktop only imports bank transactions as a Web Connect (.qbo) file, so convert the Relay file first:

  • OFX statement: OFX to QBO keeps the transaction IDs, so QuickBooks can spot duplicates if you import overlapping dates.
  • CSV: CSV to QBO. Relay doesn’t document its CSV columns, so check the preview: money out should be negative and money in positive.

Then go to File → Utilities → Import → Web Connect Files, pick Use an existing account and choose your Relay account in the Bank Feeds Center.

Import into QuickBooks Online: Banking → Link account ▾ → Upload from file. QuickBooks Online takes the OFX statement as is. A CSV works too, but you map the columns by hand each time.

The Relay Visa credit card

Card activity is not part of the checking and savings feed. In QuickBooks Online, connect the card the same way (Bank accounts → Connect accounts, search for Relay, sign in). It appears as a credit account ending in 0000. Relay says that’s expected: credit accounts have no standard account number, and the 0000 refers to the parent account, not a card. Like the bank feed, only settled purchases sync, usually 1 to 3 business days after the purchase. If the card doesn’t appear in the list, check that it’s activated and not frozen. If the feed stops updating, refresh it in QuickBooks, and if that keeps failing, disconnect and reconnect.

For QuickBooks Desktop, Relay suggests exporting the card statements, but those are PDF only for now (“CSV and OFX export formats are on the roadmap but are not available yet”), and a statement is ready the day after the billing cycle closes. To get the transactions themselves, use Settings → Credit Statements → Generate a Custom Report, tick the cards, choose CSV, and convert it with CSV to QBO, choosing Credit card as the account type.

Tips

  • Don’t import the same dates through the bank feed and a file. Start each file the day after the last transaction already in QuickBooks.
  • Statement files only include whole statement periods. For the days since the last statement, use a custom report.
  • To check what’s in an OFX or .qbo file before importing it, open it in QBO to Excel.
  • For other business accounts that only export CSV or OFX, see which banks offer QuickBooks Web Connect downloads.

Sources

Read November 9, 2026, all updated by Relay on August 11, 2026 unless noted: Relay help center, QuickBooks Online bank feeds, downloading and emailing statements, custom transaction reports (no date shown), Relay Visa credit card and QuickBooks, credit card statements, Expense Management sync with QuickBooks Online.

Report a problem

Something does not convert or looks wrong? Tell us — we read every report. Please don’t paste real bank data.