Statements to Sheets logoStatements to Sheets
Built on
Google Cloud

Convert Navy Federal Statements to Excel and CSV

A Navy Federal Credit Union statement covers the accounts a member holds with the credit union. Members use it to follow pay, bills and savings, and many keep each month for their records. The PDF is easy to read on a screen and hard to work with in a spreadsheet.

Statements to Sheets reads the transaction lines and returns a CSV with a full date, a description and a signed amount on every row. If the file prints a running balance, it comes through as its own column. The result opens in Excel and imports into Google Sheets and QuickBooks.

Upload your Navy Federal Credit Union statement to see the first rows before you pay. The first 50 transactions are free.

What the conversion looks like

Sample converter output for a statement of this type, with invented data.

As converted

DateDescriptionAmountBalance
05/02/2025Payroll Deposit Example Co1350.002800.00
05/06/2025Example Market Purchase-47.252752.75
05/13/2025Example Utility Co Bill Pay-102.602650.15
05/20/2025Mobile Check Deposit180.002830.15
05/29/2025Example Cafe Purchase-9.802820.35

Why a Navy Federal statement is hard to convert

Rows are short on context. A line can show only a day and a month, with the year given elsewhere in the statement. A tool that reads line by line has to carry that year down to every row, or the dates are incomplete.

Pay often arrives in several deposits. Split pay and transfers from another account can produce many credits with near-identical names. They must stay on separate rows with their own amounts, not be merged into one.

Members often hold more than one account. When a statement covers several accounts, the lines from each sit close together. Without care, one account's rows run into the next.

Members move often, and so do their records. A family that has been stationed in three places over five years may hold a long run of files, some saved from online banking and some scanned from mail. Every one of them has to end up in the same shape.

About Navy Federal statements

  • Navy Federal is a credit union that serves military members, veterans, Department of Defense staff and their families. Members get statements as PDFs through online banking, and paper copies can be mailed.
  • People turn the PDF into rows for many reasons: a home loan under a VA program, a move that needs proof of income, a tax return, or a family budget.
  • Statements come in monthly batches, so a year of history is a dozen files. Scans of mailed copies are common.

How we convert it

  • Deposits are positive. Withdrawals are negative.
  • Every row gets the full year, even when the line shows only a day and a month.
  • Several deposits on the same day stay on their own rows.
  • A Balance column appears only when the file prints one. We never calculate or guess a balance.
  • The second line of a wrapped description is not counted as a separate transaction.
  • Scanned pages are read with OCR, and sideways pages are turned upright.

Every conversion also checks each page against the page image, and lines that continue a wrapped description are not counted as extra transactions.

The result is a CSV with Date, Description and Amount columns (plus Balance when the statement has one) that opens in Excel and imports into Google Sheets and QuickBooks. You pay per transaction, not per page. See plans and pricing.

What people do with the file

Home loan paperwork. A lender asks for recent records. Convert the last few months, sort by date, and share a single sheet that shows each deposit and payment.

Moving and relocation budgets. Filter the withdrawals by merchant to see what a move really cost, then keep the sheet for the next one.

Tax season. Combine twelve monthly files into one workbook and use a filter to pull out the deposits and the spending you need to report.

Family budgets. Load the CSV into Google Sheets and total each category by month.

Good to know

  • Navy Federal credit card and loan statements may be laid out differently from the account statements described here.
  • Scans can contain OCR digit errors. Compare totals with the statement.

Questions

Will a purchase come out as a negative number?

Yes. Withdrawals are negative and deposits are positive, so the Amount column totals the net movement.

My statement shows no year on each line. Will the rows have one?

Yes. Each row in the CSV gets the full year.

Does it work on a scan of a mailed statement?

Yes. Scans are read with OCR, and sideways pages are turned upright. Compare the totals with the paper copy, since a scan can hide a digit.

How do you charge?

The preview is free, and so are the first 50 transactions. After that you pay per transaction, not per page.

Related Guides

Jeff Gough

Written by

Jeff Gough

Founder of Statements to Sheets and Cascade Foundry LLC. Built this tool after converting 300+ pages of printed bank statements into CSV for a friend's QuickBooks catch-up. Read the full story →