Convert a Navy Federal CSV export into a QuickBooks .qbo file. Skip the bank error 185 one-time passcode loop and import a clean Web Connect file instead.
No account needed for your first 3 conversions. We never store your bank login.
Short answer: Download your Navy Federal account history as a CSV, upload it here, and the converter returns a QuickBooks Web Connect (.qbo) file. QuickBooks Online imports the .qbo directly and QuickBooks Desktop reads it through File, Utilities, Import, Web Connect Files. A converted file never asks for a one-time passcode, which is why it works when the automated Navy Federal connection keeps failing with bank error 185.
It handles exports from Navy Federal personal checking and savings, Navy Federal Business Solutions checking, and Navy Federal credit cards.
Navy Federal is a credit union with more than 14 million members, and a large share of the small businesses banking there are run by service members and veterans. The security posture that makes it a good credit union is also what makes the QuickBooks connection fragile. The three routes below are the only ones that exist, and they differ mainly in whether they depend on that live connection at all.
The one-time passcode is the friction. Navy Federal asks for a code sent by text, call or email when it does not recognize a sign in attempt. A person can read that code off a phone. A stored bank feed connection running unattended overnight cannot, so QuickBooks surfaces bank error 185 and the account stops updating. Intuit's own guidance on 185 is that the bank wants additional verification beyond the username and password, such as a security question or a passcode. Reconnecting clears it until the next time the bank decides to challenge, which is why members describe it as recurring rather than fixed.
A .qbo file sidesteps the whole exchange. You already authenticated in the browser when you downloaded the CSV, so the converted file is just data QuickBooks reads off your disk. No credentials, no passcode, no connection to break.
Swipe to see the full table
| Method | Works with QuickBooks Online | Works with QuickBooks Desktop | Needs a live bank connection | Best for |
|---|---|---|---|---|
| Convert the Navy Federal CSV to a .qbo (this tool) | Yes, upload the .qbo | Yes, Import Web Connect file | No | Any Navy Federal account, any date range, and history older than the feed window |
| Upload the raw CSV to QuickBooks Online | Yes, with manual column mapping | No native CSV transaction import | No | One small file, once you map the columns and fix the date format |
| Navy Federal automated bank feed | Yes, when it authenticates | Yes, when it authenticates | Yes, and it must re-authenticate | Day to day syncing, when it is not stuck on error 185 |
Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.
The converter reports how many transactions it read from your file and lists the rows on screen before you download, so a dropped or misread line is caught before it reaches QuickBooks.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.
Built for catch-up and cleanup work. Convert as many periods as the job needs, each file with its own row preview and its own exports.
Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.
One conversion, three formats: the .qbo for QuickBooks, plus an XLSX to review and a CSV for everything else on every paid plan.
Three steps. No column-mapping wizard.
Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.
Every transaction is parsed and counted. You see the rows on screen before exporting.
Download the .qbo and import it as a Web Connect bank feed. Paid plans add XLSX and CSV downloads of the same conversion.
The specifics that decide whether the import is clean. If your case is not here, message us in chat.
Sign in at navyfederal.org on a desktop browser, open the account, and use the download or export option on the account history screen to save a CSV for the date range you need. Upload that file to the converter at the top of this page, check the columns it detected for date, description and amount, and download the .qbo. QuickBooks Online takes it under All apps, Accounting, Bank transactions, then Link account and Upload from file, which is the same screen older accounts still reach through Transactions, Bank transactions.
Bank error 185 means the financial institution asked for more than your username and password, and QuickBooks could not supply it. With Navy Federal that extra step is almost always a one-time passcode sent to your phone. Intuit's fix is to open the bank connection manually and enter the code when prompted, which works until the bank challenges the login again. Members who bank there report seeing it come back repeatedly.
No. QuickBooks Desktop has no native CSV transaction import. Its Import Excel and CSV Toolkit brings in lists such as customers, vendors and items, not bank or credit card transactions. The only transaction import Desktop accepts is a Web Connect file, so converting the Navy Federal CSV to a .qbo is the required step rather than an optional convenience.
No. In an April 22, 2026 reply to a member, Navy Federal confirmed that transaction history downloads in Digital Banking now come in CSV and PDF formats only, and that other file formats are no longer supported. The Quicken-format download that members had used for years went with it. For QuickBooks Desktop that matters most, because the only transaction file Desktop imports is a .qbo Web Connect file, and Navy Federal no longer hands you anything close to one. Download the CSV from the Download button next to Transaction History, convert it here, and import the .qbo. The Navy Federal CSV to QuickBooks guide walks through both QuickBooks editions step by step.
QuickBooks Online expects a narrow CSV: three columns of date, description and amount, or four with credit and debit split apart. A raw credit union export usually carries extra columns such as a running balance or a transaction type, and often a date format QuickBooks reads the wrong way around. Strip it by hand or let the converter build the .qbo, which carries no mapping screen at all.
Online banking keeps a long window of account history available for export, far more than any bank feed will sync. A connected feed typically reaches back only about 90 days regardless of the institution. To rebuild older books, download a CSV for each range you need and convert each one, since importing a .qbo file carries no date restriction.
Yes. Business Solutions is the platform most Navy Federal business members sign into, and its transaction export is a standard CSV. The converter reads the column layout rather than matching a fixed template, so a business checking export and a personal checking export both convert without any setup.
Yes, and the sign convention is the thing to watch. Card exports treat a purchase as a positive number and a payment as a negative one, or the reverse, depending on the file. The converter detects which way the file runs and writes charges and payments to the correct side of the .qbo, so your card register does not end up inverted. The credit card CSV to QuickBooks page explains the check in more detail.
QuickBooks caps a single CSV upload at 350 KB, roughly 1,000 transactions, which is why a busy quarter fails to upload as a spreadsheet. That limit follows a .qbo into QuickBooks Online as well. Converting still saves the work that matters: no column mapping, and a unique ID on each row so a split year cannot double post, while QuickBooks Desktop reads a long .qbo in one pass. For more than one account or a full year, see the bulk CSV to QBO converter page.
No, and that is the point. The import path and the bank feed are independent. You can leave the Navy Federal connection broken, disconnected or never set up at all, and still bring every transaction into QuickBooks by converting the CSV. Many bookkeepers running a monthly close prefer it that way, because a file import happens on a schedule they control rather than whenever the bank feels like honoring a passcode.
Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.
Yes, and you can check it before you import. The converter reads the Navy Federal columns and dates and keeps each amount's sign, then shows the number of parsed transactions and a preview of the rows before the .qbo downloads. Compare that with your Navy Federal CSV, and a missing or misread row shows up there rather than during reconciliation. Working from another bank? Use the CSV to QuickBooks Online converter for any account, or start from the best CSV to QBO converter comparison if you are still choosing a tool. Navy Federal is a credit union, and the credit union CSV to QBO converter page covers why credit union feeds are unreliable and how the CSV route gets around them.
Yearly billing is 50% off the monthly price: you pay for six months and get twelve. Switch to yearly and pay for six months instead of twelve, a 50% saving.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
$294 charged today
For a firm or finance team converting across many clients and currencies.
USD / month
$894 charged today
For a high-volume bookkeeper or firm converting client books at scale.
USD / month
$2,994 charged today
For larger practices that need single sign-on, a named support contact, and twice the Pro volume.
USD / month
$5,988 charged today
