All articles

Brex to QuickBooks: Convert Your Brex CSV to a .qbo File

5 min read CSVQBO Team
csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

Short answer: Brex exports transactions as CSV, TXT, or Excel, and Brex's own support pages say that if you need a .QBO file you have to run the CSV through a converter. Its native QuickBooks Online sync only reaches the last 90 days and does not work on QuickBooks Desktop. So for older history, for Desktop, or for a batch the sync will not push, export a CSV from Brex, convert it to a QuickBooks Web Connect (.qbo) file, and import it. The whole thing takes about a minute.

Brex is a corporate card and cash-management account aimed at startups and venture-backed companies. The finance team usually wants everything reconciled in QuickBooks, and the Brex integration handles day-to-day activity well enough. The friction shows up at quarter close and at onboarding, when you suddenly need history the sync will not reach or you are on an edition it does not support.

Does Brex sync with QuickBooks?

Brex has a native QuickBooks Online integration that pushes completed transactions on a schedule. It connects to QuickBooks Online only. Brex's documentation states that the process is not supported on QuickBooks Desktop, so Desktop users have no automatic feed at all. For Desktop, and for anything the online sync cannot reach, a converted .qbo file is the reliable path into your books.

Why won't my Brex transactions export to QuickBooks?

Brex lists a handful of specific reasons an export stalls. The transactions are older than 90 days, so the sync-from limit blocks them. The books for that period are already closed. A transaction has conflicting custom rules that Brex needs you to resolve before it will export. Or the sync-from date is set incorrectly. Rather than clear each block one at a time, you can export the affected range as a CSV and import a converted .qbo directly into the account.

How do I get Brex history older than 90 days into QuickBooks?

This is the limit people hit most. Brex will not sync transactions older than 90 days, so anything before that has to come in by file. In Brex, filter the transactions view to the older date range and download it as a CSV. Convert that CSV to a .qbo, then import it into the matching QuickBooks account. Because a .qbo is not held to the QuickBooks Online raw-CSV size cap, you can bring in several months or a full fiscal year in one file instead of slicing it into pieces.

How to convert a Brex CSV to QuickBooks in four steps

The process is short and you can repeat it every month.

1. Export the CSV from Brex. Open the transactions or accounting view, filter to the account and date range you need, and download it in CSV format. Brex also offers TXT and Excel, but CSV is the simplest input.

2. Convert the CSV to a .qbo. Upload the file to the Brex CSV to QBO converter. It detects the date, description, and amount columns, fixes the date format, and writes a Web Connect file. It also totals the parsed rows and shows you the sum before the download so you can confirm nothing dropped.

3. Set up the account correctly. Add the Brex card as a Credit Card account in QuickBooks and a Brex cash balance as a Bank account. That way charges increase what you owe and payments reduce it, and the signs match your statement.

4. Import the .qbo. In QuickBooks Online, open Transactions, Bank transactions, pick the account, and upload the file. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files. Review the transactions and accept them.

Does the Brex card go in QuickBooks as a credit card?

Yes. Set the Brex card up as a Credit Card account so charges raise the balance owed and payments lower it. Set a Brex business cash or treasury account up as a Bank account. When you import the converted .qbo into the matching account, the direction of every entry is already correct, and the running balance reconciles against the Brex statement for the period.

Can Brex connect to QuickBooks Desktop?

No. Brex's integration is QuickBooks Online only, and its documentation is explicit that the sync is not supported on QuickBooks Desktop. Desktop cannot read a raw CSV of bank transactions either. The one file Desktop does accept for outside activity is a Web Connect (.qbo) file, which is why converting the Brex CSV is the practical route for any firm still on Desktop.

How do I avoid duplicate Brex transactions in QuickBooks?

Convert and import one date range at a time and do not overlap ranges you have already brought in. If you run both the native sync and file imports, pick a clean cutover date: let the sync own everything from the day you connected it forward, and use converted .qbo files only for the history before that. Keeping the two methods on opposite sides of one date is the simplest way to keep the register clean.

Reconciling a fast-growing startup usually means tying together data from more than one system, and it helps to have the tools in your finance stack connected through a single integration layer so exports and imports do not turn into manual busywork. Even then, the Brex-to-QuickBooks step still comes down to a clean file, and a converted .qbo is the most reliable one.

The bottom line

Brex's native sync is fine for recent activity in QuickBooks Online, but it stops at 90 days, skips Desktop entirely, and can refuse an export over a closed period or a conflicting rule. For every one of those cases, exporting a CSV and importing a converted .qbo is the dependable fix. The Brex CSV to QBO converter builds the file in under a minute, and you can convert any other bank or card the same way with the main CSV to QBO converter.

Convert your CSV to QBO now

Upload your CSV or Excel statement, map the columns, and download a QuickBooks ready QBO file in seconds.

Start converting