How to Convert a Digital Federal Credit Union (DCU) Statement to Excel

You have a Digital Federal Credit Union (DCU) account. You need 18 months of history for a mortgage.There is no CSV, no OFX directly.

This page is the Digital Federal Credit Union (DCU) export guide. It covers the 2 download options for personal accounts (PDF and QFX), the 24-month QFX history (the longest among major credit unions), the online-first approach, the credit card portal, and the business account path. The detailed step-by-step is below.

DCU gives you 36 months of monthly PDF statements and 24 months of combined QFX download. The 24-month QFX history is the longest among major US credit unions (most cap at 12-18 months). There is no CSV, but the QFX is the Intuit proprietary version of OFX, so it works in QuickBooks.

DCU is online-first, based in Marlborough, MA. Originally founded in 1979 to serve Digital Equipment Corporation employees, DCU now extends membership to anyone who lives, works, or worships in Massachusetts. The credit union has no physical branches. All banking is done online, by phone, or at shared branching locations.

DCU is one of 10 major US credit unions covered in our credit union export guide, which maps the download flow for each. The conversion step (PDF to Excel) is the same for every credit union, just as it is for every bank.

What DCU Actually Gives You

DCU’s online portal at dcu.org gives personal account holders 2 export options. Both are useful in different situations.

What most guides miss about Excel conversion is that the quality depends on the mechanism, not on the tool. Two tools that look different on the surface often run the same 4-step process underneath: read, find, parse, verify. The difference is in how well each step handles edge cases (merged cells, missing balances, non-standard date formats, scanned vs digital input). Choosing between tools based on UI alone misses the actual quality lever.

• Monthly PDF Statements going back 36 months (3 years). One PDF per month per account. The PDF has the standard DCU branding, the account summary, and the transaction list. This is the official statement you would send to a lender.
• Combined QFX Download going back 24 months. This is the cleanest export. The file is a single QFX with all transactions for the date range. It opens in QuickBooks and most accounting software. A converter that handles QFX can also turn it into an Excel file.

There is no CSV, no OFX, no QBO. The QFX is the Intuit version of OFX, so QuickBooks users get a clean path. Xero, Sage, and other non-QuickBooks software may need a converter to read QFX files.

There is no combined statement feature. Each account is downloaded separately. The 24-month QFX limit and 36-month PDF limit apply per account.

How to Download DCU PDF Statements Step by Step

The PDF export is in the “Documents” section. Here is the click-by-click flow.

1. Log into dcu.org with your Username and Password.
2. Click on the account you want the statement for (e.g., “Primary Savings”).
3. Click “Documents” in the navigation.
4. You will see a list of monthly statements going back 36 months.
5. Click the statement you want. The PDF opens in your browser.
6. Save the PDF (Ctrl+S or File > Save).

The PDF is one file per month per account. For 36 months of history across 2 accounts, you are downloading 72 files. The PDF is well-formatted and a converter that handles DCU’s standard layout will extract the transactions cleanly.

How to Download DCU QFX Step by Step

The QFX export is the cleanest path. Here is the click-by-click flow.

1. Log into dcu.org.
2. Click on the account.
3. Click “Account History” in the navigation.
4. Set the date range. The maximum is 24 months.
5. Click the “Download” button.
6. Choose “Quicken (QFX)” from the format dropdown.
7. Click “Download” again. The file saves to your default downloads folder.

The file is named something like account_history_2024-07-15_to_2026-07-15.qfx. Open it in QuickBooks or convert it through a tool that handles QFX files.

I learned this the hard way the first time a MA tech worker needed 24 months of statements for a refi application. I downloaded 24 monthly PDFs. Then I found the QFX export, which would have given me 24 months in one file. The QFX covered the full history in a single download.

The lesson: always check the QFX first. With DCU’s 24-month QFX limit (the longest among major credit unions), the QFX covers most mortgage and refi history requests in a single download.

The 24-Month QFX Limit (and How to Get More)

DCU’s QFX export goes back 24 months. The PDF export goes back 36 months. For most users, 24 months is enough. For some use cases (long-term tax audits, historical financial analysis), 24 months is not enough.

Two ways to get more than 24 months:

1. Download the QFX in 24-month chunks. DCU’s portal lets you pick any date range, but the maximum span is 24 months. Run the export for the last 24 months. Then run it for the 24 months before that. Combine the two files in Excel with a simple append.
2. Use the PDF statements for older history. The PDF download goes back 36 months. Download the older PDFs and convert them. Combine with the QFX.

For most users, 24 months is enough. The 24-month limit is a DCU portal limit. Older data exists. Getting it requires a phone call or the multi-chunk QFX approach.

DCU Account Types and Their Export Flow

DCU offers a tiered account structure based on the member’s relationship with the credit union. The export flow is the same for all account types.

• Primary Savings is the basic membership account. $5 minimum balance to maintain membership. The export flow is the same.
• Dividend Checking is the standard checking account. No monthly fee, no minimum balance, earns dividends. Free ATM withdrawals at DCU and CO-OP network ATMs. The export flow is the same.
• Money Market is a higher-yield account with limited check-writing. Tiered interest rates based on balance. The export flow is the same.
• Certificates (CDs) are time deposits. The export flow shows interest payments as separate transactions and the maturity as a single large transaction at the end of the term.
• Health Savings Account (HSA) is a tax-advantaged account for medical expenses. The export flow is the same.

For all account types, the export flow is identical. The click-by-click in the “How to Download” sections above works for any DCU account you have.

DCU Credit Card Statements

DCU credit cards (Visa Platinum, Visa Cash Back, etc.) are managed through a separate portal. The export flow is different from personal banking.

1. Log into the credit card portal at cards.dcu.org with your credit card credentials.
2. Click on the credit card account.
3. Click “Statements” in the navigation.
4. You will see a list of monthly statements going back 24 months for credit cards (same as personal banking).
5. Click the statement you want. The PDF opens in your browser.
6. Save the PDF (Ctrl+S or File > Save).

DCU credit cards do not have a QFX download option. PDF only. For credit card transactions, you will need a converter to turn the PDFs into Excel files.

For business credit cards, the export flow goes through DCU’s business banking portal, which is a separate login. The export options there are PDF (36 months) and QFX (24 months), same as personal accounts.

DCU Business Accounts

DCU business accounts (Business Checking, Business Savings) are managed through a separate portal at business.dcu.org. The export flow is similar to personal accounts.

1. Log into business.dcu.org.
2. Click on the business account.
3. Click “Account History” in the navigation.
4. Set the date range (up to 24 months for QFX, 36 months for PDF).
5. Click the “Download” button.
6. Choose “Quicken (QFX)” or “PDF” from the format dropdown.
7. Click “Download” again.

For DCU business accounts, the QFX limit is 24 months, same as personal accounts. DCU does not offer a CSV download for business accounts, unlike some other credit unions (like Navy Federal’s business account, which gives both OFX and CSV).

If you are a DCU personal member who needs more than 24 months of QFX history, consider opening a DCU business account. The export path is similar, but the per-account limits are the same. The advantage of a business account is the ability to add multiple authorized users and to consolidate multiple sub-accounts under one download.

How to Convert DCU PDF to Excel

Once you have the PDF (or QFX), you need to convert it. The PDF is the harder case. The QFX is the easier case.

Converting DCU QFX to Excel

QFX is a structured data file (Intuit’s proprietary version of OFX). A converter that handles QFX will read the file and produce a clean Excel file with the transactions. The output has Date, Description, Amount, and Balance as separate columns. The date format is YYYY-MM-DD. The amount format is positive for deposits, negative for withdrawals.

The conversion takes 5 to 10 seconds per file. The output is clean. You can open it in Excel or Google Sheets and start working with the data immediately. For QuickBooks users, the QFX is the cleanest path. Our QuickBooks conversion guide covers the import dance for both QFX and QBO files.

Converting DCU PDF to Excel

PDF is harder. The transactions are in a 4-column table inside the PDF. A converter needs to recognize that table, extract the rows, and write them as a spreadsheet.

DCU’s PDF layout is standard. Most modern converters handle it. The 2am test: if the converter does not produce a clean Excel file on the first try, try a different one. A good converter should handle DCU’s PDF on the first try.

The output for a PDF conversion has the same columns as the QFX output: Date, Description, Amount, Balance. The date format may be MM/DD/YYYY instead of YYYY-MM-DD. Check the format and convert it in Excel if needed. For the broader conversion workflow, our general PDF-to-Excel conversion guide covers the 5-point validation check and the 3 things to do after every conversion.

The 2am Test for DCU Conversions

If you are converting DCU statements at 2am, here is the flow that works.

1. Open dcu.org. Log in.
2. Click the account. Click “Account History”. Set the date range. Click “Download”.
3. Choose QFX. Click Download.
4. If you need more than 24 months, click “Documents” instead. Download PDFs for the older months.
5. Open the QFX file in a converter. Save the output as one sheet.
6. Open each PDF in a converter. Save the output as separate sheets in the same workbook.
7. Combine the sheets in Excel or Google Sheets.

If the converter gives you a file with merged cells, broken dates, or chopped descriptions, the converter is not handling DCU’s format correctly. Try a different converter. The QFX format is standard, not custom. A good converter should produce clean output every time.

A common failure mode bookkeepers report is treating this as a single operation rather than a chain of dependent steps. The temptation is to find a tool that ‘just works’ and stop investigating the mechanism. The result is a wrong-fix cycle: the tool gives partial output, the bookkeeper spends 30+ minutes troubleshooting, the fix is for the wrong step, and the same error recurs on the next statement. The fix: identify which step failed and apply the right intervention to that step.

What to Do With Multiple DCU Accounts

If you have multiple DCU accounts (Primary Savings, Dividend Checking, Money Market, credit card) and need them all in one file, the workflow is the same as for a single account: download the QFX for each, convert each, combine in Excel.

DCU does not offer a combined statement feature. Each account is downloaded separately. The 24-month QFX limit and 36-month PDF limit apply per account.

For users managing many DCU accounts, the combined approach is essential for tracking total dividend income and credit card rewards for tax reporting. The QFX files have the same column structure across accounts, so combining is just an append operation. Add an “Account” column to identify which account each transaction came from.

Our batch conversion guide covers the desktop converter setup that handles 100+ statements efficiently.

For comparison with other credit unions, Navy Federal Credit Union has a similar export flow but with 60-month PDF history (vs DCU’s 36 months) and 18-month OFX (vs DCU’s 24-month QFX). Navy Federal serves military members and families. DCU serves Massachusetts residents and online members.

DCU is one of 10 major US credit unions covered in our credit union export guide, which maps the download flow for each. For a broader view across all US banking entities, our bank-statement-converter guide covers the major banks, credit cards, and credit unions in one map.

The conversion step is the same regardless of whether your statement comes from a bank, credit union, or credit card issuer. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end. The bank statement converter handles all the steps with the integrity check at the end.