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 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. Last updated July 2026.
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.
| 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 adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.
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.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check 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 files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
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 checked against your file total. You see the rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
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 Transactions, then Bank transactions, then Upload from file.
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.
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. A .qbo file has no equivalent cap. If you are converting several accounts or a full year of history, run them together with the bulk CSV to QBO converter instead of uploading files one by one.
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 the accuracy check is the point. Before the .qbo downloads, the converter adds up every transaction it parsed and compares that total to the total in your Navy Federal CSV. If a row is missing or misread, you see it in the preview 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.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
billed $288 yearly
For a firm or finance team converting across many clients and currencies.
USD / month
billed $888 yearly
For multi-bookkeeper firms managing many client books at scale.
USD / month
billed $2,988 yearly
