Financial Documents

Navy Federal Statement to Excel: Split the Combined PDF

Convert Navy Federal combined statements to Excel or CSV: split checking, savings and loan sections by account and get 36 months of PDFs.

Published
Updated
Reading time
14 min
Topics:Financial DocumentsBank StatementsExcelNavy FederalUSPDF conversioncredit unionQuickBookscombined statement

To convert a Navy Federal statement to Excel, download the monthly PDFs from Statements in online banking, where Navy Federal keeps up to 36 months, and convert them to one row per transaction. The same rows save as CSV just as well. The catch is that a Navy Federal statement is a combined statement: one PDF carries separate sections for your savings, checking, Money Market Savings, consumer loan and Checking Line of Credit accounts, whichever you hold. So every row needs an account column, and transfers between your own accounts need to be flagged before anyone totals income or expenses. Skip that step and a sweep from checking to savings reads as spending, while a line-of-credit advance reads as revenue.

The statement is the source to work from because nothing else is complete. Navy Federal publishes no description of a transaction export or how far back one reaches, and only the statement carries every account section with its own opening and closing balance, which is what a year's books or a tax return has to tie to.

That matters most to the people who process these statements as work: tax preparers whose military-family clients run a Schedule C business or own a rental, bookkeepers for veteran-owned businesses, and owners closing out their own year.

What a Navy Federal Combined Statement Holds

Navy Federal defines the combined statement in its electronic statements agreement. The ESIGN disclosure, NFCU 35A, says the monthly combined statement "provides you with transaction history for your primary savings, checking, Money Market Savings, consumer loan, and Checking Line of Credit accounts, as applicable."

"As applicable" is doing real work in that sentence. Membership at Navy Federal is opened with a share savings account, so even a member with a single checking account receives a statement with at least two sections. Add a Checking Line of Credit and an auto loan and the same PDF has four, each with its own transactions and its own opening and closing balance. A conversion that ignores those boundaries produces one long list in which a savings deposit, a loan payment and a client's check look the same.

Two things to know before collecting them:

  • Certificates and IRAs. Navy Federal's paperless statements page lists "Combined Checking & Savings statements" and "Combined Certificates & IRAs Statements" as separate kinds of statement. A client's download folder can hold both. For a Schedule C or a set of business books, the certificates and IRA statement is usually not needed, so leave it out of the batch or tell the conversion to skip it.
  • The primary member controls the e-statements. The same disclosure says: "Only the primary member may elect to receive the combined statements electronically." If your client is a joint owner who cannot find the PDFs, the request goes to the spouse or parent who holds the primary role.

Third-party guides to these statements report two more details worth checking in any converted output, whatever tool produced it. Withdrawals can print with a trailing minus sign ("45.00-"), and those amounts must come out as negative numbers, not as positive figures with a stray character. And family members can hold accounts under one membership, so a statement may include sections that belong to someone other than your client. Decide on purpose whether those rows stay in the sheet.

Combined statements are not unique to Navy Federal; Truist's combined business statements put several accounts in one PDF as well. What sets Navy Federal's apart is that it is every member's standard monthly statement, not an arrangement for business accounts, and a consumer loan can sit in it beside the Checking Line of Credit, so loan payments and line advances show up twice, once on each side, inside a single file.

Getting the PDFs: 36 Months Online, Older Statements on Request

Navy Federal states the online window on its own paperless statements page: "Up to 36 months of statements are automatically saved for you and available to view or print anytime." Guides elsewhere give other figures. Thirty-six months is Navy Federal's.

To save them:

  1. In online banking, open Statements, choose the month and save the PDF.
  2. In the mobile app, go to More, then Account and Tax Statements.
  3. Name each file by period as you save it (2025-03, 2025-04 and so on). Twelve files called "statement" are a headache by the time you are checking a March figure in November.

The window rolls forward a month at a time, and the oldest statement drops out each month. In practice it holds the current year to date, the two full tax years before it, and part of the year before those. For a job that needs the far end of the window, save the oldest months first.

Older than 36 months, the statements have to be requested from Navy Federal, online or by phone at 1-888-842-6328. On cost, Navy Federal's 2016 disclosure (NFCU 35A) set the copy fee at $2.00 per statement, but the current consumer fee schedule (NFCU 2043ep, 5-25) and business fee schedule (NFCU 1284-B, 10-26) list no statement-copy fee at all. Ask when you place the request. Allow time for it too: a prior-year return or a multi-year catch-up that needs statements from before the window should start with that request, not end with it.

Paper statements a client kept are just as much the record as the PDFs. A scan of each page belongs in the same folder as the downloads, filling whatever months online banking no longer shows.

The Transaction Download Navy Federal Doesn't Document

Navy Federal's current Digital Banking video tutorials include "View Account Statements". None of them covers exporting or downloading transactions, and no public Navy Federal page describes an export: which formats, which accounts, how many months.

Some form of download does exist. NerdWallet's review of Navy Federal Business Checking puts the limitation in practical terms: the account cannot sync with QuickBooks, so account holders have to manually download transaction data and then upload it to QuickBooks. Beyond that, the reports conflict. Third-party guides disagree on which file types the download offers, whether it covers every account or only checking, and how far back it goes. With nothing from Navy Federal to settle it, treat any specific claim about the download as unconfirmed until you see it in the client's own login.

What the statement gives you is not in question:

  • Every section in one document, savings, checking, loan and line of credit together, cut at a fixed date and unchanged afterward.
  • Opening and closing balances for each section, the figures a reconciliation ties to and the proof that no row is missing.
  • The loan and line-of-credit activity, including the side of each payment and advance that a checking-only file would miss.
  • Months the download may not reach, up to the 36 months kept online and beyond them by request.

A practical rule follows. A download is fine for keeping the current month up to date in a budgeting sheet. For a year's books, a Schedule C, a lender's file or catch-up work on prior years, convert the statements, because those are the figures someone will tie to.


Worked Example: Twelve Combined Statements Into One Sheet

Take a Navy veteran who runs a small consulting business as a sole proprietor and files Schedule C. She banks through one Navy Federal membership, and her 2025 statements carry four sections: share savings, the checking account the business runs through, a Checking Line of Credit attached to that checking, and a vehicle loan. Her preparer has the twelve monthly PDFs and needs the business checking activity for the return. (An owner on Navy Federal Business Solutions checking follows the same steps; the account column simply names whatever sections that statement carries.)

Invoice Data Extraction works as a bank statement converter for this job: the twelve PDFs go in as one batch, under one prompt, and come back as one sheet with the account named on every row. The prompt describes the sheet you want, not the statement's layout:

One row per transaction. Columns: Statement Period, Account, Date (YYYY-MM-DD), Description, Amount. Fill the Account column with the account name and last four digits printed on the section header. Show withdrawals as negative amounts. In the loan and line of credit sections, show advances as positive and payments as negative. Skip the Certificates and IRAs statement.

March comes back like this (illustrative figures, descriptions and account numbers):

Statement PeriodAccountDateDescriptionAmountSource File
2025-03Checking 44712025-03-03Deposit, client payment2,850.002025-03.pdf, page 1
2025-03Checking 44712025-03-06Debit card, office supplies-312.472025-03.pdf, page 1
2025-03Checking 44712025-03-10Transfer to Share Savings 1102-500.002025-03.pdf, page 1
2025-03Share Savings 11022025-03-10Transfer from Checking 4471500.002025-03.pdf, page 2
2025-03Checking Line of Credit 88202025-03-18Advance to Checking 44711,000.002025-03.pdf, page 2
2025-03Checking 44712025-03-18Advance from Checking Line of Credit 88201,000.002025-03.pdf, page 1
2025-03Checking 44712025-03-25Payment to Vehicle Loan 3056-415.002025-03.pdf, page 1
2025-03Vehicle Loan 30562025-03-25Payment from Checking 4471-415.002025-03.pdf, page 3

Eight rows, and only two of them are business income or expense. The Account column is what makes the rest manageable: filter on it to see one account's year, or pivot on Account and Statement Period to get each section's monthly totals. In Excel, numbers come through as numbers and dates as dates, so the filter and the pivot work without reformatting. Every money movement between her own accounts shows up as a pair, one row in each section, which is the raw material for the next step.

The Source File column comes with every extraction: each row carries the file and page it came from, and a second column, Review Needed, flags any value or row a panel of AI agents could not agree on, with what to check. In the results viewer, clicking the file name on a row opens that page beside it, which is the quickest way to settle a flagged amount or a month that will not tie. A page that could not be processed is reported, never skipped in silence, and it is not charged.

The size of the job barely changes the steps. A task takes up to 6,000 files, and a single PDF can run to 5,000 pages, so a preparer can put a client's three years of statements, or several clients' years under separate tasks, through the same prompt. That is the usual shape of tax-season catch-up bookkeeping for CPA firms, where a client's statements arrive all at once. At the other end, an owner converting each month's statement as it arrives may find the 50 free pages every month cover the load. The output can also be downloaded as CSV or JSON when the sheet is headed somewhere other than Excel.

From the Sheet to Schedule C: Transfers, Loan Payments and the Line of Credit

Converted statements are only useful for a return once the rows that look like income and expenses, but are not, are marked as such. The combined statement produces more of those than a single-account statement does, because every movement between sections appears on both sides.

Start by filtering to the business account. On the example sheet, that is Checking 4471. Its rows are the Schedule C ledger. The other sections stay in the workbook, because the transfers and the tie-out need them.

Pair the own-account transfers. The $500 that left checking on March 10 and the $500 that arrived in share savings the same day are one movement. Match them on date and amount, mark both rows as a transfer, and neither one reaches the return: a sweep to savings is not an expense, and money brought back from savings into checking is not revenue. A business that moves its own money around every month can have dozens of these pairs a year, and left unmarked they inflate both the income and the expenses on a Schedule C. The wider question of assigning everything else to expense lines is covered in categorizing bank transactions for taxes.

Treat the Checking Line of Credit as borrowing. The $1,000 advance into checking on March 18 is a loan, not income, even though it lands in the business account as a deposit. Repayments are not an expense either, except for the interest the line charges, and that interest counts as a business cost only for the share of the borrowing that funded the business.

Split the vehicle loan payment. The $415 payment is principal and interest together, and the principal is not deductible. If the loan section of the statement shows how each payment was applied, take the interest from there. If it does not, use the year's interest figure from Navy Federal's records for the loan rather than estimating. How much of that interest belongs on the return depends on the vehicle's business use, which stays the preparer's call.

Tie out each section, month by month. Take each account's opening balance from the statement, add that account's rows for the period, and the result should be the closing balance printed for that section. Checking and savings tie on the rows as converted. The line of credit and the loan carry a balance owed, and the loan needs one adjustment: its balance falls by the principal applied, not by the whole payment, so tie it on the principal figure where the section shows one. A checking or savings section that misses points to a missing or misread row, and the Source File column takes you straight to the page.

Doing that yourself keeps a bank charge off the bill. Navy Federal's Business Solutions fee schedule, NFCU 1284-B (10-26), charges $5.00 per half-hour for "repeated checkbook balancing assistance", and the consumer schedule carries the same line. Copies of paid or deposited items cost $1.00 each after the first free copy a month, and a converted row does not replace those when it is the check image itself you need.

Into QuickBooks or Xero: One File per Account

With no QuickBooks sync for Navy Federal Business Checking, Navy Federal statements reach QuickBooks through a file upload, and QuickBooks Online's bank upload brings each file into a single bank account. Xero's statement import works the same way. A combined statement therefore has to become one file per account before it goes anywhere: checking into the checking account's register, savings into savings, and the loan and the line of credit into their liability accounts if the books track them.

There are two ways to get there from the converted year. Filter the Account column and save each account's rows as its own CSV, or run the conversion once per account with a prompt that keeps only that section. Either way, shape the columns to what the import asks for. A Structured Prompt fixes the exact headers in the exact order, such as Date, Description and Amount, or separate money-in and money-out columns if that is the layout you map. In Preferences, leave the Source File and Review Needed columns out of the copy you upload, and keep the full version as the workpaper. The output is CSV or Excel shaped to those columns, not a QBO or OFX file, and nothing posts into the books on its own; the upload is yours. The upload screens and column mapping are covered step by step in importing bank statement files into QuickBooks.

If some of the year already reached the books through a manual download, load only the statement dates before the first downloaded transaction, so the two sources never overlap.

A client with Navy Federal accounts may also bank somewhere near home or base, and the prompt above needs no rewriting for that, because it describes the sheet rather than any bank's layout. The same Account and Statement Period columns work for converting Regions Bank statements to Excel, or for any other bank's PDFs in the client's folder, and the results stack in one workbook.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours