Convert a Navy Federal statement PDF to Excel

How to convert a Navy Federal statement PDF to Excel

1. Download the PDF: sign in to Navy Federal Online Banking and select Statements (in the mobile app: More, then Account and Tax Statements), pick Combined Checking and Savings Accounts, choose the month and save the PDF. Use the downloaded PDF, not a scan of a paper statement: scans don't work yet.
2. Upload it above. Utilly reads every account's table and checks beginning balance + deposits − withdrawals = ending balance for each one. The preview shows Balanced ✓, or exactly how far off it is, before you pay anything.
3. Download the CSV and open it in Excel: one file per account, or one file of all accounts with an Account column. Dates and amounts come in as real dates and numbers.
4. Save as .xlsx (File → Save As → Excel Workbook) if you want to keep formulas or formatting.

What we read on a Navy Federal statement

A Navy Federal "Statement of Account" starts with the Statement Period, a Summary of your deposit accounts and a deposit voucher. Then each account gets its own table, headed by the product and account number (for example "Free EveryDay Checking - 7012345678") with Date, Transaction Detail, Amount($) and Balance($) columns. Checking and savings usually come on the same statement.

What this is based on: test statements built in Navy Federal's layout above, with made-up names and transactions (checking and savings on one statement, a table continued onto the next page, and a December-to-January statement), plus one public example Navy Federal statement with checking and savings: 70 of 70 rows read, both accounts balanced, and deposits and withdrawals equal to the statement's own summary to the cent. Before this page, our reader read none of its rows. We don't link to it because it contains a person's details. We haven't run every Navy Federal statement style through it: business checking, money market savings, certificate and IRA statements and Navy Federal credit card statements haven't been tested, and a scanned statement won't read. That's why the balance check runs on every file: if yours doesn't balance, you see the difference before paying.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-16,Deposit - ACH Paid From Sample Employer Payroll,1850.00,2692.16
2026-09-17,POS Debit- Debit Card 1234 09-15-26 Demo Grocery 0412 Vienna VA,-64.18,2627.98
2026-09-18,POS Debit - Debit Card 1234 Transaction 09-16-26 Example Hardware Store 0042 Fairfax VA,-58.90,2569.08
2026-09-24,Transfer To Credit Card Jordan A Sample,-250.00,2186.61
2026-09-30,Dividend,0.07,2086.68
2026-10-06,Zelle Debit To Alex Example Rent,-1200.00,2713.27

The combined file for checking and savings adds an Account column first ("EveryDay Checking ··5678", "Membership Savings ··5432"). Want money in and money out in two columns? Use =MAX(C2,0) and =MAX(-C2,0).

How far back Navy Federal statements go

Sources: Navy Federal: Switch to Paperless Statements (up to 36 months, where Statements are in online banking and the app), Quicken Community: "Navy Federal Credit Union (NFCU) no longer supports Quicken Downloads" (a member quoting Navy Federal's April 22, 2026 eMessage reply), Quicken: Why am I receiving a message about my Navy Federal Credit Union accounts? (the EWC+ bank-hosted sign-in). Checked Oct 27, 2026.

QuickBooks and Quicken files for Navy Federal

Navy Federal no longer offers a Quicken download file: a member's April 2026 Quicken Community post quotes Navy Federal saying transaction history downloads are CSV and PDF only. Quicken can still connect directly (Quicken says Navy Federal moved Express Web Connect accounts to a bank-hosted sign-in, EWC+). If a connection covers the dates you need, use it. For months it doesn't reach, or the statements a client sent you, start from the PDF. The same Utilly conversion that gives you Excel also includes:

One credit covers every format of that statement, for every account on it. If a connection or an earlier download already brought in some of the same dates, start the PDF months where that stopped so nothing comes in twice.

Common problems

Catching up on months of statements? See catch-up bookkeeping from bank statements, and check any statement's totals with the free bank statement balance checker. Other banks: bank statement PDF to Excel, Chase statement to Excel, Bank of America statement to Excel, Wells Fargo statement to Excel, Capital One statement to Excel, U.S. Bank statement to Excel, Citibank statement to Excel, PNC statement to Excel, or Truist statement to Excel.