Relay CSV to QBO Converter: Convert a Relay CSV to QuickBooks

Relay connects to QuickBooks Online through a native bank feed integration that pushes transactions every few hours. Relay's own support documentation states it does not connect with QuickBooks Desktop at this time, so Desktop users have no automatic Relay feed and no OFX Direct Connect option. For Desktop, the supported path is a Web Connect (.qbo) file, which is what this converter builds from your Relay CSV.

Two causes account for most of it. First, Relay pushes only settled transactions to the QuickBooks bank feed, so anything still pending will not appear until it clears. Second, users in the QuickBooks community have reported the account linking on Relay's side while nothing lands in QuickBooks, which leaves a real gap in the register. In both cases the reliable fix is the same: export the period as a CSV and import a converted .qbo.

No. QuickBooks Desktop does not accept raw CSV for bank transactions. Its bank feed reader takes Web Connect files, meaning .qbo, .qfx, and .ofx. That is why a Relay CSV, which imports fine into QuickBooks Online with column mapping, is useless to Desktop until you convert it. Running the CSV through this converter produces the .qbo file that Desktop's Web Connect importer expects.

It depends on the QuickBooks edition you run and how many Relay checking accounts you are reconciling. This table lays out what Relay supports today and what each option means in practice.

Sign in to Relay, open the checking account you want, set the date range, and download the transactions as a CSV. Relay keeps each of your sub-accounts separate, so export one file per account rather than trying to merge them. One account per CSV becomes one clean .qbo that maps to one QuickBooks bank account, which is what keeps the reconciliation honest.

Upload the exported CSV in the converter at the top of this page. It detects the date, description, and amount columns automatically, normalizes the dates into the format QuickBooks expects, strips currency symbols and thousands separators, and signs debits and credits correctly. Before the file downloads, the tool totals every transaction it parsed so you can check it against the Relay balance. Download the .qbo and import it. The whole pass takes under a minute.

Mirror them. Create one QuickBooks bank account for each Relay checking account you use, then export and convert one CSV per account so each .qbo imports into its matching register. Firms running Profit First typically keep buckets for operating cash, owner pay, taxes, and profit, and keeping those separate in QuickBooks is the entire point of the method. Merging them into a single import destroys the allocation you set up Relay to enforce.

In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and select the .qbo you downloaded. Desktop asks which account the transactions belong to, so pick the register that matches that Relay checking account. The transactions land in the Bank Feeds Center for review, and you accept them into the register from there. Nothing is typed by hand and nothing is mapped column by column.

In QuickBooks Online, open Transactions, then Bank transactions, select the matching Relay account, and use the upload option to add the .qbo file. QuickBooks reads it, shows the transactions for review, and posts them once you accept. Because it is a Web Connect file and not a raw CSV, you skip the column-mapping screen entirely, and the file is not held to the size cap that trips up long raw CSV uploads.

Bank feeds are forward looking, so any period from before you connected the account has to arrive as a file. Export the older date range from each Relay account as a CSV, convert each file here, and import the .qbo into the matching register. If you are catching up several months across several buckets, convert them in one batch rather than one at a time, and reconcile each account against its Relay statement as you go.

Only if the same dates are already in the register. QuickBooks matches incoming Web Connect transactions against what is already posted and flags likely duplicates for review rather than blindly adding them. To stay safe, check the last cleared date in the QuickBooks account before you export, then set the Relay date range to start the day after it. If the native feed is running for that account, import files only for the gap it missed.

Relay is a fintech platform, not a chartered bank. Banking services are provided by its partner bank, and Relay provides the software layer, the sub-accounts, and the cards. That distinction matters for bookkeeping because fintechs typically do not offer OFX Direct Connect, which is the protocol QuickBooks Desktop uses for automatic downloads. It is the structural reason Desktop users end up importing files instead of connecting a feed.

Yes, and the accuracy check is the point of it. The converter totals every transaction it parsed and shows you that total before the .qbo downloads, so a misread row surfaces immediately instead of during month-end reconciliation. The tool reads only the transaction rows, the date, the description, and the amount, to build the file. It never asks for your Relay login and never touches your banking session.