A credit union statement converts to Excel like a bank statement, with one difference: a single PDF often holds every account you have, such as share savings, a share draft checking account and a loan. Give every row an Account column, label dividends as income, and check each account's balance separately before you combine anything.
Share, share draft and loan accounts on one credit union statement
Credit unions use their own names for familiar accounts. A share account is a savings account, since members own shares in the credit union. A share draft account is a checking account. A share certificate is a fixed-term deposit. Many credit unions print all of a member's accounts, loans included, in one combined statement.
The terms in official use
The words are not informal slang. The NCUA page on share insurance coverage, from the federal agency that insures credit union deposits, lists deposits in a share draft account, a share savings account or a share certificate among the funds it covers. Knowing that a share draft is a checking account saves a lot of confusion when you build column headings.
Finding each account on the PDF
A combined statement usually starts with a summary of every account and its balance, then gives each account its own section with a header. The header names the account type and often a short suffix or number that identifies it within your membership. Before converting, make a note of each account, its suffix if there is one, the page it starts on and its opening and closing balance. That note is your plan for the sheet.
Why combined statements are harder
A combined statement is easier to read on paper and harder to convert. A tool that ignores the account headers will produce one long list in which a transfer from savings to checking appears twice and a loan payment looks like spending. The rows are all there, but none of the account balances can be checked.
Why does a credit union statement say dividends instead of interest?
Because members own the credit union, the earnings paid on their share accounts are called dividends rather than interest. The NCUA page on share insurance also refers to posted dividends as part of an insured balance. In your spreadsheet, a dividend line is simply income on a savings or checking account.
How to label it
Keep the description exactly as printed, such as DIVIDEND or DIVIDEND EARNED, and add a Category column with a value such as Interest and dividends. If you will compare accounts at a credit union with accounts at a bank, one shared category makes the totals line up. A pivot table on that category then shows what all your deposit accounts earned in a year.
Dividend dates and periods
Dividends often post on the last day of the statement period, or on a set day each month or quarter. A statement that ends a day before the dividend posts will show no dividend at all for that period, and the next one will. That timing is not an error. It matters only if you are comparing months, where a quarterly dividend makes one month look much better than the others.
Not the same as a loan's interest
On a loan, the interest line is a cost, not income. Keep the two apart in your categories, even though both words appear on the same statement.
Splitting each credit union account into its own Excel rows
Add an Account column and fill it with the account each row belongs to, taken from the section header above it. Then filter or split the sheet by that column. Each account becomes its own clean list, and a combined view is one filter away.
A worked example
The figures are made-up examples from one statement with three accounts. The suffixes are illustrations; use whatever your credit union prints.
| Account | Date | Description | Amount |
|---|---|---|---|
| Share savings 00 | 2026-06-30 | Dividend earned | 0.43 |
| Share draft 10 | 2026-06-01 | Example payroll deposit | 1400.00 |
| Share draft 10 | 2026-06-09 | Debit card, example cafe | -63.10 |
| Share draft 10 | 2026-06-15 | Transfer to loan 40 | -275.00 |
| Auto loan 40 | 2026-06-15 | Payment from share draft 10 | 275.00 |
Opening balances on the statement are 520.00 for share savings, 1,880.00 for share draft and 9,600.00 owed on the auto loan.
The loan row needs care. It is a payment, which lowers what you owe, so it is not money you earned. The next section explains how to treat the loan account so its balance check works.
One sheet per account, or one table
If you will add a month at a time, one sheet per account is simple to keep. If you want a full picture of the membership, keep one table with the Account column and use filters. Either way, decide before the second month, because changing later means moving rows around. A template that already has these columns saves that decision each month, and a bank statement Excel template for converted statements sets one out.
What a converter should do
A statement converter needs to read the account headers and carry the account name onto each row for you. FastBankConvert reads each statement's layout instead of using a fixed list of banks and tells you before download if balances do not add up. It is getting ready to open; FastBankConvert's home page has the details.
Credit union loan sections: payments, principal and interest
A loan section on a credit union statement shows payments received and how each one was split between principal and interest, plus the balance still owed. Record the payment as one row in the loan account's list, and keep the split in two extra columns. The principal part is what reduces the balance.
Columns for the loan sheet
A loan sheet works best with its own columns: date, description, payment, principal, interest and balance owed. Using the example, the 275.00 payment splits into 236.20 of principal and 38.80 of interest. The balance owed drops from 9,600.00 to 9,363.80, which is the opening figure minus the principal, not minus the whole payment.
Signs on a loan
On a loan, the balance is money you owe. If you put it in the same table as your share accounts, show it as a negative number, so a total across accounts gives your net position. A payment then moves the loan balance towards zero, and the principal part is a positive change on a negative balance. That is easier to get right in a separate loan sheet than in a shared one.
Lines with no money moving
Loan sections may include lines such as late fee waived or rate change notices with no amount. They are information, not transactions. Leave them out of the list, or keep them in a notes column.
Does each credit union account balance on its own?
It must. For each share and draft account, the opening balance plus that account's lines equals its closing balance. For each loan, the opening balance owed minus the principal paid plus any new charges equals the closing balance owed. A combined total can hide two errors that cancel, so check accounts one at a time.
The checks for the example
| Account | Opening | Change from rows | Computed closing | Printed closing |
|---|---|---|---|---|
| Share savings 00 | 520.00 | +0.43 | 520.43 | 520.43 |
| Share draft 10 | 1,880.00 | +1,061.90 | 2,941.90 | 2,941.90 |
| Auto loan 40 (owed) | 9,600.00 | -236.20 principal | 9,363.80 | 9,363.80 |
For the share accounts, the change is =SUMIFS(D:D,A:A,"Share draft 10"), with the account name changed on each row. For the loan, sum the principal column of the loan sheet.
Reading a failed check
If the share draft computed closing is 275.00 higher than printed, the transfer to the loan was missed. If the loan's closing is 38.80 too low, the whole payment was taken off instead of only the principal. Each failure points to the kind of line that went wrong, which is why per-account checks are faster to fix than one big total.
Credit union downloads, transaction codes and phones
Some credit unions offer a CSV or other export of account history in online banking, and some statements print short transaction codes beside each line. Both are useful, with limits. An export can save converting a PDF, and codes can fill a category column, but neither replaces the statement as a record.
Using a CSV export
If online banking offers a CSV for an account, it may be quicker than converting the PDF. Check what it covers: an export of history may include pending items and may not show opening and closing balances. Getting a bank statement into a CSV file explains which columns to expect and how to open one without Excel changing dates or long numbers.
Transaction codes
Some statements print a code for each line, such as a short abbreviation for a deposit, a withdrawal or a transfer. Codes can drive a category formula faster than descriptions can. Reading the transaction codes on a bank statement covers what common codes mean and how to map them in a lookup table.
Opening files on a phone
Many members do their banking on a phone, and a CSV downloaded there can be awkward to open. Opening a CSV file on Android shows how to view and share it without a desktop spreadsheet app.