Navy Federal checking, savings, money market and credit cards
Convert a Navy Federal statement to Excel, CSV or QuickBooks
Navy Federal keeps up to 36 months of statements online, with checking, savings and money market on one combined PDF. Convert them to get each account into Excel, CSV or QuickBooks, checked against the balances Navy Federal prints.
- Combined statements read account by account
- Running balance checked on every row
- Summary block kept out of the rows
- Any of the 36 months of statements online
36 months
of statements online
Under Statements, or Account and Tax Statements in the app
$2.00
per older statement copy
For statements past 36 months, on request
1 PDF
for checking, savings and money market
Credit cards get a separate statement
EWC+
Quicken connection type
Per Quicken’s July 2024 support note
The short answer
Can you export a Navy Federal statement to Excel?
Navy Federal’s statements are PDFs, saved for you for up to 36 months in digital banking. Navy Federal does not publish which transaction download formats its online banking offers or how far back they reach, so check Account History in online banking for the current options. For a full statement period, an older month, or anything that has to match the statement exactly, you convert the PDF, and you get the same Excel, CSV or QuickBooks file either way.
The PDF is the complete record, and it is shaped differently from most banks’: one combined statement each month for your primary savings, checking, Money Market Savings, consumer loans and Checking Line of Credit. Credit cards come on their own Visa or Mastercard statement, and certificates and IRAs on a quarterly one.
A converted Navy Federal deposit account is checked twice over: the running balance on every row, and each account’s beginning balance plus its deposits, minus its withdrawals, against its ending balance. Card statements are checked against their account summary instead.
One PDF holds several accounts, and transfers between them appear twice
Sample statement
What a Navy Federal statement looks like
Hover or tap a number to see what each part means for a conversion.
NAVY FEDERAL Credit Union
Statement of Account · Access No. ending 8812
Statement Period 09/14/26 - 10/13/26
Jane Doe · Joint Owner(s): Sam Rivera
Summary of your deposit accounts
- e-Checking 4471 · Previous Balance
- $2,315.60
- e-Checking 4471 · Deposits/Credits
- $2,140.00
- e-Checking 4471 · Withdrawals/Debits
- $428.52
- e-Checking 4471 · Ending Balance
- $4,027.08
- Membership Savings 0001 · Previous Balance
- $1,050.25
- Membership Savings 0001 · Deposits/Credits
- $200.21
- Membership Savings 0001 · Withdrawals/Debits
- $0.00
- Membership Savings 0001 · Ending Balance
- $1,250.46
e-Checking - 4471
| Date | Transaction Detail | Amount($) | Balance($) |
|---|---|---|---|
| 09-14 | Beginning Balance | 2,315.60 | |
| 09-15 | POS Debit - Debit Card 4471 Commissary #0412 Norfolk VA | 86.34- | 2,229.26 |
| 09-15 | Deposit - ACH Paid From DFAS-Cleveland Net Pay | 2,140.00 | 4,369.26 |
| 09-22 | Transfer To Shares 0001 | 200.00- | 4,169.26 |
| 09-30 | Paid To - Dominion Energy Bill Pay | 142.18- | 4,027.08 |
| 10-13 | Ending Balance | 4,027.08 |
Membership Savings - 0001
| Date | Transaction Detail | Amount($) | Balance($) |
|---|---|---|---|
| 09-14 | Beginning Balance | 1,050.25 | |
| 09-22 | Transfer From Checking 4471 | 200.00 | 1,250.25 |
| 10-13 | Dividend | 0.21 | 1,250.46 |
| 10-13 | Ending Balance | 1,250.46 |
Native export
What Navy Federal lets you export
Statements are the documented route. The others depend on what online banking and Quicken currently offer.
Statements in digital banking
Up to 36 months
Combined Checking and Savings Accounts, Credit Card and Loans, and Certificates and IRAs statements, each one a PDF to view, print or save.
Where it stops: A PDF only, with several accounts in one combined statement. Older copies cost $2.00 each.
Quicken connection
Set by the connection; not published
Quicken’s support page (updated July 2024) says Navy Federal moved its Express Web Connect accounts to EWC+ (Quicken Connect on Mac), with Direct Connect accounts not affected at that time.
Where it stops: Brings transactions into Quicken only, from when the connection starts. It does not produce a file you can use elsewhere.
Converting the statement with VouchRow
Any statement you have
The PDF becomes rows in the format your software takes, with each account’s running balance and ending balance checked and every row linked to its line.
Where it stops: Needs the statement PDF. Statements past 36 months have to be ones you saved or ordered.
How far back
How far back each Navy Federal option reaches
Navy Federal publishes a figure for statements and a fee for older copies. It does not publish one for the activity download.
Statements (PDF) in digital banking
Up to 36 months
Combined, credit card, loan and certificate statements under Statements, saved automatically and available to view or print.
Older statement copies
On request, $2.00 each
Statements older than 36 months, sent on request through online banking or by phone.
Activity download from online banking
Not published
Navy Federal does not publish the download formats or range. Check Account History in online banking.
A dashed bar means the bank does not publish a figure; check your own online banking.
Step by step
How to convert a Navy Federal statement
- 1Save the statement PDFs from Navy FederalIn online banking, choose Statements from the navigation menu. In the mobile app, choose More, then Account and Tax Statements, and pick Combined Checking and Savings Accounts, Credit Card and Loans, or Certificates and IRAs.
- 2Keep statement types apartConvert combined statements as one batch and credit card statements as another. They are laid out differently and are checked differently.
- 3Upload and convertSign in to VouchRow and add the PDFs. Digital statements convert in batches. A scanned paper statement is read with OCR, one at a time. A password-protected PDF is unlocked in your browser; the password is never sent.
- 4Check every account’s balancesEach row’s running balance and each account’s ending balance are checked. If anything is off, VouchRow shows the dollar difference, and clicking any row shows its line on the PDF.
- 5ExportExcel or CSV to review, QBO for QuickBooks, QFX or QIF for Quicken, or the Xero CSV preset. Import each account’s rows into the matching account in your software.
Formats
Where is your Navy Federal data going?
Pick the destination. The advice changes with it.
Navy Federal statement to Excel
An .xlsx with one row per transaction: date, description, a signed amount and the running balance from the statement, with deposits positive and withdrawals negative. The Beginning and Ending Balance lines are not rows; they are what the rows are checked against.
Each row links back to its line on the PDF, so on a combined statement you can always see which account’s section a row came from before you filter or total it.
PDF to ExcelNavy Federal statement to CSV
CSV is the format to use when another tool will read the file: a budgeting app, a loan system or an import screen. Choose the date format the importer expects before you export, since the statement prints month and day only.
A converted CSV covers whole statement periods with the same columns every time, which is what a lender’s or budgeting tool’s import expects.
PDF to CSVNavy Federal statement to QuickBooks
Export QBO and import it into the matching bank account in QuickBooks (in QuickBooks Online, under bank transactions, upload from file; in Desktop, as a Web Connect file). Set up checking and savings as separate accounts, the way the combined statement treats them.
Each row carries a transaction ID, so a re-import does not duplicate. Match transfers between your Navy Federal accounts as transfers once both sides are in.
PDF to QBONavy Federal statement to Quicken
If your Navy Federal accounts already connect to Quicken, use converted QFX files to fill in the months before the connection started. Import each one into the existing account so the history joins it rather than creating a new account.
QIF also works, but QIF has no transaction IDs, so a statement imported twice will duplicate. Prefer QFX.
PDF to QFXNavy Federal statement to Xero
Use the Xero CSV preset: one signed amount column and the date format Xero expects. Import each account’s rows into its own bank account in Xero, then reconcile as usual.
Transfers between your Navy Federal accounts reconcile in Xero as transfers once both accounts are imported.
Statements into XeroStatement layout
How a Navy Federal statement is laid out
The facts to check against the statement in front of you. Accounts covered: Checking (Free Active Duty, e-Checking, Flagship and others), Membership Savings and other share savings, Money Market Savings, Visa and Mastercard credit cards, Checking Line of Credit and consumer loans.
| One statement, several accounts | The monthly combined statement covers primary savings, checking, Money Market Savings, consumer loans and the Checking Line of Credit, each in its own section |
|---|---|
| Credit cards | A separate monthly Visa or Mastercard statement, not part of the combined statement |
| Certificates and IRAs | A separate quarterly Certificate/IRA statement |
| Running balance | Yes on deposit accounts: each account’s activity runs from its beginning balance to its ending balance |
| Date format | Navy Federal publishes no sample; statements members have shared print short dates without the year (MM-DD), so the year comes from the statement period |
Why it works
Built around how Navy Federal prints a statement
Several accounts, one PDF
Checking, savings and money market sections are read as the separate accounts they are, each with its own balances, instead of one long list.
Running balance on every row
Each account’s balance column is checked line by line, so a missed or misread row shows up at the line where the balance stops matching.
The summary is the proof
The summary of your deposit accounts lists each account’s previous balance, deposits, withdrawals and ending balance. It is checked against, not imported.
The right year on every row
Rows print a month and day only. The year comes from the statement period, so a December to January statement puts each row in the right year.
Card statements signed as cards
Navy Federal Visa and Mastercard statements have no running balance. They are proved against the account summary, with payments and credits kept as credits to the card.
Statements older than the download
Any of the 36 months of statements online converts the same way, and so do older copies you order or saved.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
Layout
How a Navy Federal combined statement is laid out
Navy Federal describes the monthly combined statement as transaction history “for your primary savings, checking, Money Market Savings, consumer loan, and Checking Line of Credit accounts, as applicable.” It does not publish a sample, so check the details below against your own statement.
Statements members have shared open with a Statement of Account header (the statement period and your access number), then a summary of your deposit accounts: one line per account with the previous balance, deposits and credits, withdrawals and debits, the ending balance and year-to-date dividends. None of those are transactions.
Each account follows in its own section, named with the account type and number and any joint owners. The columns are the date, the transaction detail, the amount and the balance. The section opens with a beginning balance line and closes with an ending balance line, and debits are marked as withdrawals while deposits are not. Navy Federal’s statement disclosure adds an interest charge calculation table (balance subject to interest rate) for the Checking Line of Credit, and a deposit voucher at the bottom of the statement.
Transfers
Transfers between your Navy Federal accounts
Because checking and savings share a statement, a transfer from one to the other appears in both sections: as a withdrawal from checking and as a deposit to savings. The combined statement is right to show it twice; each account’s balance depends on it.
In the converted file each transfer stays in the account it came from, so both accounts reconcile. When you import both into QuickBooks, Quicken or Xero, match the pair as a transfer between your own accounts. Left as they are, the deposit looks like income and the withdrawal like an expense.
Credit cards
Navy Federal credit card statements
Navy Federal Visa and Mastercard accounts get their own monthly statement. Navy Federal’s guide to card statements names the parts: an account summary (previous balance, payments, credits, fees and so on), payment information with the minimum payment and due date, transaction details, interest charges, available credit and, on rewards cards, a rewards summary.
Only the transaction details are rows. There is no running balance, so a converted card statement is checked against the account summary: previous balance, minus payments and credits, plus purchases, fees and interest, must equal the new balance. Payments and credits stay credits to the card in every format.
Older statements
How far back Navy Federal statements go
Navy Federal says up to 36 months of statements are saved for you in digital banking, available to view or print at any time. Its electronic statement disclosure says the same: a PDF can be printed or saved for any statement less than 36 months old.
For anything older, Navy Federal will send a copy for $2.00 per statement, requested through online banking or by calling 1-888-842-6328. A mailed copy converts like a downloaded one; a paper copy you scan is read with OCR, one statement at a time.
Troubleshooting
Common Navy Federal conversion problems
Most Navy Federal errors come from the combined statement.
- Balances never match: the checking and savings sections were read as one account. Each section has its own beginning and ending balance.
- Extra rows at the top: the summary of your deposit accounts was read as transactions. Those lines are the per-account totals.
- Income looks too high after import: transfers from checking to savings were imported as deposits. Match them as transfers.
- Withdrawals show as deposits: the debit marker on the amount was missed. The running balance check catches it on the first row it affects.
- Rows in the wrong year: the statement prints a month and day only. The year has to come from the statement period.
- Statements stop three years back: Navy Federal keeps 36 months online. Older copies are $2.00 each on request.
Side by side
Navy Federal’s online banking vs converting the statement
| Navy Federal online banking | Converting the PDF statement | |
|---|---|---|
| How far back | Statements: up to 36 months. Activity download: not published | Any statement you have, including older copies |
| Formats | PDF statements; download formats not published by Navy Federal | Excel, CSV, QBO, QFX, OFX, QIF, IIF, Tally XML |
| Several accounts | One account at a time on screen | Every account on the combined statement |
| Matches the statement period | Only if you pick the exact dates | Always: one statement, one period |
| Checked against the statement | No | Running balance on every row and each account’s ending balance |
| Proof for a reviewer | A list of rows | Every row linked to its line on the PDF |
Before you import
After converting a Navy Federal statement, check these
- Every account balancesEach account’s beginning balance plus its rows equals its ending balance. If not, the difference is shown.
- Accounts kept apartChecking rows go into the checking account and savings rows into savings, not one combined list.
- Transfers matchedEach transfer between your Navy Federal accounts is one transfer in your books, not income plus an expense.
- No summary rowsNo lines from the summary of deposit accounts, and no Beginning or Ending Balance lines, among the transactions.
- Dates in the right yearOn a statement that crosses New Year, the December rows are in the old year and the January rows in the new one.
- Dividends presentSavings dividends appear as deposits when the statement shows them.
Downloaded activity and statements are not the same thing
Excel for Navy Federal
Who uses it
Who converts Navy Federal statements
VA and mortgage loan files
Lenders and brokers who need two or three months of checking and savings activity, with each account’s balances proved.
Military families’ household budgets
Pay, allotments and bills across checking and savings in one spreadsheet, with transfers between the accounts identified.
Divorce and family law
Up to three years of combined statements, each row traceable to its line, with joint owners shown on each account section.
Bookkeeping for a side business
A Navy Federal checking account used for business, converted to QBO for the months before it was connected to QuickBooks.
FAQ
Navy Federal statements: questions
How do I export a Navy Federal statement to Excel?
Save the statement PDF from Statements in online banking (or Account and Tax Statements in the app) and convert it here to Excel or CSV. Each account on the combined statement is checked against its running balance and ending balance.
How do I get a bank statement from Navy Federal?
In online banking, choose Statements from the navigation menu. In the mobile app, choose More, then Account and Tax Statements, and pick Combined Checking and Savings Accounts. Up to 36 months are saved there.
Can I download Navy Federal transactions as a CSV?
Navy Federal does not publish which download formats its online banking offers, so check Account History for the current options. For a complete statement period, convert the statement PDF to CSV; the rows match the statement and are checked against it.
How far back can I get Navy Federal statements?
Up to 36 months are saved in digital banking. Older statements can be requested for $2.00 per copy through online banking or by calling 1-888-842-6328.
What does a Navy Federal bank statement look like?
It is a combined statement: a summary of your deposit accounts, then a section per account with a beginning balance, the transactions with an amount and a running balance, and an ending balance. Credit cards come on a separate statement.
Why are my checking and savings on the same statement?
Navy Federal issues one monthly combined statement for primary savings, checking, Money Market Savings, consumer loans and the Checking Line of Credit. Each account still has its own section and its own balances.
Does Navy Federal work with Quicken?
Yes. Quicken’s support page (updated July 2024) says Navy Federal moved its Express Web Connect accounts to a newer connection type, EWC+. For months the connection does not reach, convert the statements to QFX and import them into the same account.
Can I convert a Navy Federal credit card statement?
Yes. Card statements are separate from the combined statement and have no running balance, so each one is checked against its account summary. Convert them in their own batch.
Keep going
Related guides and converters
Formats for Navy Federal statements
Other bank pages
Other banks
Sources
The facts about Navy Federal Credit Union on this page come from these pages, checked in October 2026. Banks change their online banking; if something here no longer matches, the bank’s own help page wins. Tell us and we will update it.
- Navy Federal: paperless statements (up to 36 months saved, menu names)
- Navy Federal: digital banking tutorials (statement types)
- Navy Federal: ESIGN consent (36 months online, $2.00 per older copy)
- Navy Federal: statement disclosure (combined, card and certificate statements)
- Navy Federal: combined statement disclosure information
- Navy Federal: credit card basics (parts of a card statement)
- Quicken: Navy Federal connection change to EWC+
Convert your Navy Federal statements
Upload the PDFs, check every account’s running balance and ending balance, and export Excel, CSV, QBO or QFX.