# Trade Confirmation PDF to Excel: One Row Per Trade

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Other financial documents
- Canonical: https://fastbankconvert.com/blog/trade-confirmation-pdf-to-excel

> Turn a trade confirmation PDF to Excel: trade date, settlement date, quantity, price, fees and net amount, gathered into one row per trade.
To turn a trade confirmation PDF to Excel, give each trade one row with the account, security, buy or sell, trade date, settlement date, quantity, price, commission, other fees and net amount. Gather every confirmation for the period onto one sheet, then check that quantity times price, plus or minus fees, equals the printed net amount.

## Trade confirmation fields for one row per trade

A trade confirmation is the broker's record of a single executed trade. FINRA's page on [checking your trade confirmations](https://www.finra.org/investors/insights/checking-trade-confirmations) says each one includes the transaction date, the price and the quantity, and may add the execution time. Those fields, plus fees and the net amount, become the columns of your sheet.

A layout that fits most confirmations:

- **Account**, the last digits are enough.
- **Symbol** and **security name**, both, because a symbol alone can be ambiguous across years.
- **Side**, Buy or Sell.
- **Trade date** and **settlement date**.
- **Quantity**, kept to the decimals printed, since fractional shares are common.
- **Price**, often printed to four decimals. Keep all of them.
- **Principal**, quantity times price.
- **Commission** and **other fees**, in separate columns.
- **Net amount**, what was charged or credited to the account.
- **Capacity**, agent or principal, and **Solicited**, yes or no, if printed.

The last two are easy to skip and worth keeping. FINRA explains that a firm acting as agent must disclose its commission, while a firm acting as principal builds its pay into the price as a markup or markdown. FINRA also suggests checking that a trade your adviser recommended is not labeled unsolicited.

## Trade date and settlement date on a confirmation

The trade date is the day the order was executed. The settlement date is the day the cash and the securities actually change hands. For most trades they are now one business day apart, since the SEC's [rule moving the standard settlement cycle to T+1](https://www.sec.gov/newsroom/press-releases/2023-29) for most broker-dealer transactions reached its compliance date on May 28, 2024.

Keep both dates as real Excel dates. For gains, losses and holding periods, use the trade date. For matching the confirmation to cash moving in or out of the account, use the settlement date, because that is when the cash entry appears on the brokerage statement.

Add a check column that counts business days between the two with NETWORKDAYS, minus one. Most rows should show 1. A Friday trade settles on the next Monday, which still counts as one business day. A larger number is worth a second look, because it may be a type of security on a different cycle or a misread date.

## How do fees turn a trade price into the net amount?

Fees turn the principal into the net amount in opposite directions for buys and sells. On a buy, the net amount is the principal plus commission and fees, the total cost. On a sell, the net amount is the principal minus commission and fees, the proceeds. One formula per side, checked against the printed net, catches most extraction errors.

### A worked example

The two trades below are an example, made up for illustration.

| Side | Symbol | Trade date | Settle date | Qty | Price | Principal | Commission | Fees | Printed net |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Buy | EXMPL | 2026-09-14 | 2026-09-15 | 150 | 42.1550 | 6,323.25 | 0.00 | 0.02 | 6,323.27 |
| Sell | SMPLX | 2026-09-18 | 2026-09-21 | 80 | 97.3000 | 7,784.00 | 4.95 | 0.18 | 7,778.87 |

For the buy, 150 times 42.1550 is 6,323.25, and adding 0.02 of fees gives the printed 6,323.27. For the sell, 80 times 97.30 is 7,784.00, and taking off 4.95 and 0.18 gives 7,778.87. Both check out. The sell traded on a Friday and settled on Monday, one business day later.

If a check fails by a round amount, look at the price first. A four-decimal price such as 42.1550 can lose a digit in extraction and become 42.155 or 4.2155, and the difference shows up immediately in the principal.

### Keep fees in their own columns

FINRA suggests reviewing every fee on a confirmation, including small handling or mailing charges, and asking about any you did not expect. That review is only possible if fees stay in their own columns instead of being folded into the price. A SUM of the fee column at year end also shows what trading cost you in total.

## What if one trade confirmation PDF holds several trades?

Some brokers send one PDF per day that holds every trade made that day, each in its own block, sometimes with partial fills of one order listed as separate executions. Split the PDF into one row per execution, carrying the shared header details, such as account and trade date, down onto each row. Then stack the days.

### Gathering many files

Save each confirmation with its trade date in the file name, such as "confirm-2026-09-14.pdf", convert them, and paste each result below the last. Add a "Source file" column so any row can be traced back. Sort by trade date at the end and look for gaps against the activity section of your brokerage statement, which FINRA recommends comparing with each confirmation.

The layout problem is the same one invoices pose: a header with shared details above a table of lines. [Getting PDF invoice line items and header fields into Excel](/blog/pdf-invoice-line-items-to-excel) covers that pattern in depth, and if your older confirmations are on paper, [scanning paper invoices into rows](/blog/scan-invoice-to-excel) gives the scan settings and checks that work for them too. When you only need the net amounts for a cash summary, [pulling a single column from a PDF into Excel](/blog/extract-a-single-column-from-pdf-to-excel) is faster than taking the whole table.

The cash from a sale often ends up in a checking account. FastBankConvert is built to turn that bank statement PDF into rows, so the transfer can be matched to the confirmation's net amount. It is not open yet, and [the homepage](/) has a sample run.