How to Import Brex Transactions into QuickBooks (Online Integration, Bank Feed, Desktop IIF or QBO)
Brex works with QuickBooks Online in two ways: its own accounting integration and a QuickBooks bank feed. QuickBooks Desktop has no live connection. You export an IIF or CSV file from Brex and import it yourself. Brex doesn’t offer a QuickBooks (.qbo) download. Its help center says: “If you need a .QBO file, you’ll need to use a file converter to change the CSV file format to .QBO.” Below are all the paths and when to use each.
QuickBooks Online: integration or bank feed
Brex lets you use both at the same time:
| Brex integration (Brex recommends it) | Bank feed | |
|---|---|---|
| Set up in | Brex dashboard → Accounting | QuickBooks → Transactions → Bank transactions |
| What arrives | Categorized expenses with receipts and memos | Raw transactions you categorize in QuickBooks |
| History | What you export from Brex | Up to 90 days back |
Option 1: the Brex integration
- In the Brex dashboard, go to Accounting and click Connect.
- Choose QuickBooks Online, sign in, pick your company and click Next.
- Wait for the banner saying Brex imported your QuickBooks fields.
- Open QuickBooks settings in Brex and map the GL accounts. The key one is Brex card payable, which must be a Credit Card account in QuickBooks.
- On the Accounting page, assign any missing fields, mark the transactions as prepared, then Review and export transactions.
The Brex user who sets this up must also be the primary admin in QuickBooks Online. Each Brex account links to only one QuickBooks Online company. For a second entity, Brex suggests exporting a CSV and importing it there by hand, or opening a separate Brex account.
Option 2: the bank feed
- In QuickBooks Online, go to Transactions → Bank transactions and click Link account (or Connect account).
- Search for Brex, sign in and choose the accounts.
- Pick the QuickBooks account each one syncs to, or create one.
- Choose a sync-from date and click Connect. Transactions older than 90 days won’t come in.
Running both? As long as the period isn’t closed, QuickBooks matches feed transactions to what Brex exported, and you confirm each with Match. One known catch: a payment to Brex can show up twice, once dated when it left your bank and once dated when Brex received it. Brex’s fix is to open the payment in QuickBooks, choose Find Match, and reconcile.
Older than 90 days, or a second company
Download a file from Brex (see below) and upload it: Transactions → Bank transactions → Link account ▾ → Upload from file. QuickBooks Online takes the CSV directly and asks you to map the columns. Upload only the dates the feed doesn’t cover.
If you mark transactions as exported with CSV in Brex, they aren’t sent to QuickBooks. Brex flags them as exported so the integration won’t send them again later, so make sure they actually get imported.
When the Brex export fails
Brex’s checklist:
- You’re signed in to QuickBooks Online, as a master admin.
- All required GL mappings are set, and none has a red exclamation mark. If one does, refresh the integration and map it again.
- “Invalid account type”: Brex card payable is mapped to something other than a credit card account.
- The period isn’t closed in QuickBooks, and the transactions weren’t already exported as CSV.
- RATE_LIMIT_ERROR or INTERNAL_ERROR on a big export: wait, then export in batches of 2,000 transactions or fewer.
If the bank feed says it needs reconnecting, Brex’s steps are: Edit account details → Disconnect this account on save → refresh → Link account → choose Brex → pick the same credit card account and the same start date as before.
Download your Brex transactions
- Card transactions: Account → Credit → Transactions, enter a date range and download an XLSX, CSV, HTML or TXT report.
- Expenses page: pick columns with the gear icon, then Download. Admins and bookkeepers get everyone’s expenses. Other roles only see their own.
- Business account (cash): Accounts → View all accounts, open the account, filter and click Export.
- Statements: Statements and documents → Card (PDF only) or → Banking.
QuickBooks Desktop: IIF or QBO
There are two ways in. Pick one for each date range, never both, or you’ll get duplicates.
Option 3: Brex’s IIF export (the official integration)
- In QuickBooks Desktop, create a Credit Card account for Brex. If you use Brex reimbursements, you also need an Accounts Payable account and a Bank account to pay them from.
- Switch to single-user mode and go to File → Utilities → Export → Lists to IIF Files. Select Chart of Accounts (required) and anything else you want to map, then export.
- In Brex, go to Accounting → Setup, choose QuickBooks Desktop and import that IIF file.
- Map and prepare transactions on the Accounting page, export an IIF file, and import it in QuickBooks Desktop with File → Utilities → Import → IIF Files. Back up the company file first, because an IIF import can’t be undone.
What Brex says this doesn’t do:
- No vendor. The IIF file leaves Purchased From empty on card charges, even if the vendor exists in QuickBooks. Brex suggests putting the merchant name in the memo, or using a custom CSV template.
- No bank feed and no automatic receipts. You get memos, receipt URLs and links back to Brex.
- No bill sync. Bills and bill payments are exported by hand as IIF or CSV.
Option 4: a .qbo file through Bank Feeds
If you’d rather review Brex charges in the Bank Feeds center and match them like any other card, use a Web Connect file:
- Download the card transactions from Brex as CSV (or XLSX) for the dates you need.
- Drop the file into CSV to QBO, or Excel to QBO for the XLSX. Choose Credit card as the account type. In the preview, charges should be negative and payments positive. If they’re the other way round, tick Reverse signs. The conversion runs in your browser, so the file isn’t uploaded anywhere.
- In QuickBooks Desktop, go to File → Utilities → Import → Web Connect Files, choose Use an existing QuickBooks account and pick your Brex credit card account.
Unlike the IIF file, each transaction comes in with the merchant as the payee, and QuickBooks can apply your bank rules. Categorization done in Brex doesn’t come along, though. If you categorize in Brex, use the IIF export instead.
Tips
- Start each file the day after the last Brex transaction already in QuickBooks.
- To check a .qbo file before importing it, open it in QBO to Excel.
- If QuickBooks Desktop rejects the Web Connect file, see what is a QBO file for the bank ID it expects.
- Other business accounts that only export CSV or OFX: which banks offer QuickBooks Web Connect downloads.
Sources
Read November 22, 2026: Brex help center, QuickBooks Online integration, QuickBooks Desktop integration, exporting to your integration, documents for your account.