# Free PDF Converter Missing Rows: Why and What It Costs

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Free vs paid converters
- Canonical: https://cheapbankconvert.com/blog/free-pdf-converter-missing-rows

> Why a free PDF converter is missing rows from your statement, how to spot the gap with the balance, and what a missed row costs to find later.
A free PDF converter ends up missing rows when it reads a statement as a picture of a table rather than a list of transactions. Rows near page breaks, rows with wrapped descriptions and rows without a date are the usual losses. Recompute the running balance and the first row where it stops matching shows you the gap.

## Why is a free PDF converter missing rows from a statement?

A free PDF converter misses rows because a PDF has no rows. It stores text as pieces placed at positions on a page, and the converter must guess which pieces belong together. A general tool built for any table guesses well on neat grids and badly on bank statements, which break the grid in several ways.

A statement looks like a table, but underneath it is lines of text at set coordinates. The converter groups text by its vertical position into rows, and by its horizontal position into columns. Anything that disturbs those positions can make it merge two transactions, split one in half, or skip one.

Free tools tend to use the same approach for invoices, reports and statements. They do not know that a statement has a balance that must add up, so they have no way to notice a lost row. Tools built for statements can check the balance as they go, which is one way to catch gaps.

The model behind the free tool also matters. A free site funded by upgrades has little reason to fix a fault that shows only on long files, because long files are what it wants you to pay for. The guide on [how free converters make money](/blog/free-pdf-to-excel-converter) explains those models.

## Page breaks, wrapped descriptions and dropped statement rows

Dropped statement rows cluster in three places: at page breaks, at descriptions that wrap onto a second line, and at rows that lack one of the usual fields. Each of these breaks the pattern the converter expects, so the text is attached to the wrong row or left out.

**Page breaks.** The last transaction on a page and the first on the next sit next to headers, footers, page numbers and "continued" notes. A converter that strips headers and footers may take a transaction with them. Others repeat a row on both sides of the break.

**Wrapped descriptions.** A long merchant name or a transfer reference can run onto a second line. The converter may treat that line as a new transaction with no amount, or join it to the next transaction and push that one's text out of place.

**Rows missing a field.** Some banks print the date only once for several transactions on the same day. The second and third have a blank date cell. A converter that requires a date to start a row may fold them into the first, so three amounts become one, or two vanish.

Small type, shaded rows and lines between columns can cause the same faults. So can a statement exported with a fit-to-page setting that squeezes the columns together.

## Spotting missing rows with the running balance

The running balance is the fastest way to spot missing rows. Each transaction should change the balance by exactly its amount. Rebuild that sum in the spreadsheet, row by row, and compare it with the balance column copied from the statement. The first row where the two differ is where the gap starts.

Steps, using example column letters:

1. Put the date in column A, the description in B, the signed amount in C (money out negative), and the statement's balance in D.
2. In E2, enter the opening balance from the statement's header.
3. In E3, enter a formula that adds the amount to the previous computed balance, and fill it down.
4. In F3, enter a formula that compares the computed balance with the statement's balance, and fill it down.
5. Filter column F for FALSE. The first FALSE row is where the first missing or wrong row sits.

The formulas, for an example sheet where row 2 holds the opening balance:

```
E3:  =E2+C3
F3:  =ROUND(E3-D3,2)=0
```

The ROUND stops tiny floating-point differences from showing as errors.

A worked example with made-up values: the opening balance is 1,000.00. Row 3 is a purchase of -45.00 with a balance of 955.00, so F3 is TRUE. Row 4 is a deposit of 200.00 with a printed balance of 1,035.00. The computed balance is 1,155.00, and F4 is FALSE. The difference, 120.00, is a missing transaction of -120.00 between rows 3 and 4. Look at that spot in the PDF, usually the bottom of a page, and you will find it.

Once the gap is found, add the row, and every later row should turn TRUE. If they do not, there is a second gap further down.

## Which statement rows do free converters drop most?

Free converters drop the rows that sit next to something that is not a transaction. The first and last row on each page are the most common losses, followed by rows with long or multi-line descriptions, and rows that share a date with the row above. Check those before scrolling the whole sheet.

A quick order of search, before or instead of the balance method:

- **The last row on each page.** Compare it with the PDF page by page.
- **The first row on each page.** Look for one that is missing or doubled.
- **Transfers and payments with long references.** These wrap most often.
- **Days with several transactions.** If the bank prints the date once, check each one came through.
- **Fees and interest at the end of the statement.** They sometimes appear in a separate section the converter treats as a summary.
- **Pending or "uncleared" items** in a separate block, which a converter may skip as not part of the table.

Count the rows on each page of the PDF and in the sheet. If page 3 shows 28 transactions and the sheet has 27 between the page 3 markers, you know which page to search.

## What does a missed statement row cost to find later?

A missed statement row costs little to fix on the day you convert and much more to find later. Today it is one row and one balance check. Months later it may be a budget that never added up, a reconciliation that is off, or a tax figure that is wrong, and you will have to search from scratch.

What a missed row can turn into, depending on what the file was for:

- **A budget.** The month looks better or worse than it was, and a spending pattern disappears. Tools such as [highlighting overspending in Excel](/blog/highlight-overspending-in-excel) only work if every row is there.
- **Bookkeeping.** The bank account will not reconcile, and someone spends an evening finding the difference.
- **Tax records.** A deductible expense is never claimed, or income is understated.
- **An application.** A lender or landlord who compares your summary with the statement sees a number that does not match.

The cost also grows with the number of statements. One missing row in a single month is easy to find. If you convert twelve months with the same free tool and only check at the end of the year, you have twelve files to search.

That is why the balance check belongs on the day of conversion. It takes five minutes, and it turns "something is off somewhere" into "row 47 is missing".

## Missing-row edge case: a statement with no running balance

Some statements, especially credit card statements and some savings accounts, print no running balance. Without it, the row-by-row method cannot work, but the totals can still catch a gap. Compare the sum of the amounts with the statement's totals of money in, money out, or the change from opening to closing balance.

Three checks that work without a balance column:

1. **Total change.** Closing balance minus opening balance should equal the sum of all amounts in the sheet.
2. **Section totals.** Many credit card statements print a total for payments, purchases and fees. Sum each group in the sheet and compare.
3. **Row count by page.** Count transactions on each page of the PDF and in the sheet.

These checks tell you that a row is missing, and roughly how much it is worth, but not where. If the total change is off by 64.99, search the PDF for 64.99. A unique amount is often found in seconds with your PDF reader's search.

If two errors cancel out, such as a missing purchase and a doubled one of the same size, the totals will match and the gap will hide. The row count by page is the check that catches that case.

## When to stop patching missing rows and reconvert

Stop patching missing rows and reconvert when you have found more than two or three gaps, when the gaps repeat on every page, or when you find one on a statement you need for something formal. A file with many repairs is hard to trust, and each fix by hand is a fresh chance to type an amount wrong.

Signs a different tool is the faster route:

- **Every page break loses a row.** The fault is in how the tool reads pages, and it will repeat on every statement.
- **Amounts are merged.** Two transactions in one cell means some figures you see are sums, not transactions.
- **The balance never ties out** even after you add the rows you found.

Options for the reconversion range from free desktop programs to pay-per-file tools. Labels on download sites can be confusing here; the post on [freeware vs shareware PDF converters](/blog/freeware-vs-shareware-pdf-converter) explains what each one promises before you install. Students with a one-off file have their own choices, covered in [free PDF to Excel for students](/blog/free-pdf-to-excel-for-students).

A tool that includes a running balance column lets you run the check above straight away. CheapBankConvert lists a running balance column in its paid statement files and previews the first 2 pages free, which is enough to see how the first page break comes through before you pay. It is getting ready to open; [Get started](/get-started) takes your email so you hear when it does.