How to Import USAA Transactions into QuickBooks

Short answer: USAA gives you a CSV or an Excel file and nothing else. It retired the Quicken QFX and OFX downloads, and it has never published a QuickBooks Web Connect QBO. So there are three ways into QuickBooks: connect the account and let the QuickBooks Online feed pull recent activity, hand-map the USAA CSV and upload it, or convert the USAA PDF statement into a QBO file and import that like a normal bank download. For prior years, closed accounts, and QuickBooks Desktop, the converted statement is the only path that actually works.

USAA banks millions of military and veteran households, and plenty of them run an LLC, a rental, or a consulting practice through the same institution. It is also one of the thinnest data exporters among large US banks, which is why the Quicken and QuickBooks forums have years of threads from members asking where the download went.

What file formats does USAA give you?

Open an account on usaa.com, filter the activity, and export. The choices are a comma-delimited CSV or an Excel file. The QFX and OFX downloads that once existed were retired, so the direct-to-software path is gone. That leaves QuickBooks in an awkward spot:

Method 1: Connect USAA to QuickBooks Online

Go to Transactions, then Bank transactions, and choose Link account. Search for USAA, sign in, and map each account. The feed backfills roughly 90 days and then updates nightly. Two limits bite here. QuickBooks Desktop lists only a USAA Federal Savings Bank connection for Bank Feeds, and members regularly find the specific product they hold, often a credit card or a business account, is not the one it covers. And even when the QuickBooks Online feed connects cleanly, 90 days is all the history it will ever produce, which is useless for a tax catch-up.

Method 2: Upload the USAA CSV

Download the CSV from usaa.com, then in QuickBooks Online go to Transactions, Bank transactions, open the Link account dropdown, and choose Upload from file. QuickBooks will ask you to match columns, and this is where the work is. It needs a Date column, a Description column, and either a single Amount column with money out shown as negative, or separate Debit and Credit columns. Dollar signs and thousands separators have to go. Dates need to be in a format QuickBooks recognizes. If your USAA file is the credit card export, the charge signs almost certainly need flipping, because a QuickBooks credit card account expects the opposite convention from a bank account.

Two hard caps apply to every manual upload: 1,000 transactions and 350 KB per file. A year of USAA checking will exceed both, so split it, usually one file per statement period, and import them in order.

Method 3: Convert the USAA PDF statement to QBO

This is the path that survives all of USAA's export gaps. Download the monthly PDF statements from the documents area on usaa.com, upload them to the USAA statement to QBO converter, and download a genuine QuickBooks Web Connect file with the dates, descriptions, and signed amounts already mapped. Then:

• QuickBooks Online: Transactions, Bank transactions, Link account dropdown, Upload from file. Pick the QBO, confirm the account, and the transactions appear in For review.
• QuickBooks Desktop: File, Utilities, Import, Web Connect Files. Select the .qbo and choose the account.

Keep one USAA account per file, because QuickBooks maps a single QBO to a single account. And if a live USAA feed is still attached to that account, deactivate it in Bank Feed Settings before importing, or you will be deleting duplicates all afternoon.

Can I still get a QFX file from USAA for Quicken?

Not from USAA. The QFX and OFX downloads were retired, which is exactly why long-time Quicken users found their USAA accounts suddenly unimportable and had to go looking for a converter. The same statement upload that writes a QBO for QuickBooks also writes a QFX for Quicken, so a Quicken register can be rebuilt from the PDF statements even though the bank no longer publishes the file. If you would rather work from the spreadsheet you already downloaded, you can turn that CSV into a Web Connect file instead of converting the PDF.

How far back can I download USAA transactions?

Online activity runs roughly 18 months, and older periods have to be requested from USAA. The QuickBooks Online feed reaches back only about 90 days on first connect. So if you are rebuilding a prior year for a tax filing, an SBA application, or a lender review, neither the feed nor the export can get you there. The PDF statements can, which is why converted statements are the standard workflow for USAA catch-up work rather than a workaround.

Why does the USAA import come in backwards?

Because of the sign convention. In a QuickBooks bank account, money leaving is negative. In a QuickBooks credit card account, a purchase increases what you owe, so the sign flips. When you build a CSV by hand from a USAA card export, it is very easy to load every charge as if it were income, which is the single most common reason a card reconciliation is off by exactly twice the balance. A converted statement comes out signed for the account type it belongs to. If you want to check the rule before you import, our note on whether credit card charges should be positive or negative in QuickBooks spells it out.

Getting the raw rows instead

Not every job needs an import file. If you are analyzing spend, building a profit and loss from statements, or handing a lender a spreadsheet, the USAA statement to Excel converter produces XLSX and CSV from the same PDF upload, with the running balance preserved. Our guide to exporting USAA transactions to CSV or Excel covers that side, and the broader QuickBooks bank statement converter page lays out every import path QuickBooks supports and the limits on each.

The short version

USAA is a bank that hands you data, not files. The feed works for current activity on a supported account and nothing else. The CSV works if you are willing to map columns and fix signs, and only in QuickBooks Online. Converted statements work everywhere: Desktop and Online, current periods and prior years, checking and credit cards, open accounts and closed ones. For anyone doing USAA bookkeeping at any volume, the statement is the source of truth worth building on.