# Check Register PDF to Excel: Numbers, Payees, Voids

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-07-02
- Updated: 2026-07-02
- Category: Other financial documents
- Canonical: https://www.fastbankconvert.com/blog/check-register-pdf-to-excel

> Turn a check register PDF to Excel: check numbers in sequence, payees and amounts, voided checks, and spotting gaps in the numbering.
To turn a check register PDF to Excel, give each check a row with number, date, payee, amount, memo and status, and keep voided checks as rows with a zero amount. Store check numbers as whole numbers, sort by them, and use a formula to list any number missing from the sequence before you match the register to the bank.

## Check register columns to keep in Excel

A check register is the list of checks a business or household has written, usually printed from accounting software or written by hand in a booklet. In Excel, each check needs the same handful of columns: number, date written, payee, amount, memo or account, and a status showing whether it is open, cleared or void.

### The core columns

- **Check number**, a whole number with no prefix.
- **Date written**, as a real date.
- **Payee**, exactly as printed.
- **Amount**, a positive number, since every check is money out.
- **Memo or expense account**, for whatever the check paid for.
- **Status**: Open, Cleared or Void.
- **Cleared date**, filled in once the bank statement shows the check.

Registers printed from accounting software often add deposits and a running balance. If yours does, keep deposits on the same sheet with a Type column, and keep the running balance as a check value rather than a figure you rely on.

### Registers from accounting software

A register exported from accounting software is usually a digital PDF with a clean table, and a direct conversion keeps the columns. Repeated column headers on each page, page totals and a report title row need deleting afterwards. Many of the same cleanup steps apply to other software reports; the guides on [a sales report PDF to Excel](/blog/sales-report-pdf-to-excel) and [an inventory report PDF to Excel](/blog/inventory-report-pdf-to-excel) cover header rows, page subtotals and grouped sections in reports of that kind.

### Handwritten registers

A paper check register booklet, photographed or scanned, is a different job. The page is a picture, so every number has to be recognised before it can be copied, and handwriting is harder to read than print. The guide on [OCR for PDF to Excel](/blog/ocr-pdf-to-excel) explains how text recognition works on scans and which fields to double-check afterwards. For check numbers and amounts, check every digit.

## Check numbers as a sequence, not as amounts

Check numbers are identifiers, but unlike most identifiers they carry meaning in their order. Store them as whole numbers so Excel sorts 998, 999, 1000 correctly, and keep any prefix in a separate column. Never let the check number column hold text and numbers mixed, because a sort then splits them into two groups.

### Prefixes and account codes

Some registers print check numbers with a bank or account prefix, such as CHK-1204 or 02-1204. Split that into a Prefix column and a numeric Check number column. If you write checks from two accounts, the prefix keeps the two sequences apart, and every check-number test then runs per account.

### Sorting by number, not by date

A check written on the 3rd can be numbered after one written on the 5th, if checks were torn from different pads or written out of order. Sort by check number for the sequence tests and by date for cash reports. Do not try to make the two orders agree; they are different questions.

### Numbers that look like amounts

When a converter reads a register, the check number column and the amount column sit close together and both hold numbers. A shifted column can put 1204 in the amount column and 412.00 in the number column. A quick test catches it: every check number should be a whole number in a narrow range, and amounts will not be.

## How should voided checks appear in a check register spreadsheet?

A voided check should stay in the spreadsheet as its own row, with status Void, an amount of zero, and a note on why it was voided if one exists. Deleting the row creates a gap in the numbering that looks exactly like a missing check, and the whole point of the sequence test is to flag missing checks.

### Why keep a zero, not the original amount

Some registers print a voided check with its original amount struck through or marked VOID. If the amount stays, it is added to the total spent. Put the printed amount in a separate Original amount column for reference and set the main amount to zero.

### Voids after the check was issued

A check can be voided after it was mailed, for example when it was lost and replaced. Then the register may show the original check, a void entry, and a new check with a later number for the same payee. Keep all three. Link them in a note so anyone reading the register sees the replacement.

### Spoiled checks

A check spoiled while writing, then torn up, is usually recorded as void with no payee. Fill the payee with "Spoiled" rather than leaving it blank, so a filter on blank payees does not treat it as a recording error.

## Finding gaps in check numbering with a formula

A gap in check numbering is any number between the lowest and highest check in the register that does not appear in it. In current Excel versions, one formula lists every missing number at once. In older versions, a helper column that subtracts each check number from the next one flags each gap.

### Worked example: checks 1201 to 1210

The register below is made up to show the tests.

| Check | Date | Payee | Amount | Status |
| --- | --- | --- | --- | --- |
| 1201 | 2026-05-01 | Example Office Supply | 214.60 | Cleared |
| 1202 | 2026-05-02 | City Water Dept | 88.15 | Cleared |
| 1203 | 2026-05-06 | J. Rivera Contracting | 1,500.00 | Cleared |
| 1204 | 2026-05-08 | Sample Insurance Co | 412.00 | Open |
| 1205 | 2026-05-08 | (void) | 0.00 | Void |
| 1206 | 2026-05-12 | Demo Staffing | 950.00 | Cleared |
| 1207 | 2026-05-15 | Demo Freight | 76.40 | Open |
| 1209 | 2026-05-20 | Example Property LLC | 2,200.00 | Cleared |
| 1210 | 2026-05-28 | Corner Print Shop | 133.25 | Open |

### The formula

With check numbers in A2:A10, this formula in Excel 365 or Excel 2021 lists every number missing from the run:

```
=LET(n, A2:A10, s, SEQUENCE(MAX(n)-MIN(n)+1, 1, MIN(n)), FILTER(s, ISNA(MATCH(s, n, 0)), "No gaps"))
```

For the example it returns 1208. Check 1205 does not appear, because the void kept its row.

### The older-version method

Sort by check number. In B3, enter =A3-A2 and fill down. Any value above 1 marks a gap just before that row; a value of 0 marks a duplicate check number, which needs a look of its own. Filter the column for values other than 1.

## Is a gap in the check sequence always a problem?

A gap in the check sequence is not always a problem, but it always needs an explanation. Innocent causes include a check written by hand and never entered, a pad used out of order, or a register printed for a date range that cuts through the sequence. Less innocent causes include a lost, stolen or unrecorded check.

### Innocent gaps

- **Date-range edges.** A register printed for May may skip a check dated in April that was written from a later pad. Widen the date range and the gap often closes.
- **Two pads in use.** If two people write checks from different pads on the same account, each sequence has jumps where the other pad was used.
- **Spoiled checks never recorded.** A torn-up check that was not voided in the register leaves a hole.

### Gaps that need a look

A missing number that the bank later shows as cleared is a check written and never entered. A missing number that never clears may be in someone's drawer, or lost. Matching the register against cleared checks on the bank statement separates these.

### When not to chase the sequence

Some accounts mix printed checks with electronic payments that use their own reference numbers, and some banks issue numbers for online bill payments. Do not run the gap test across those mixed numbers. Filter to paper checks first.

## Matching the check register to cleared checks on the bank statement

Matching the check register to the bank statement means looking up each cleared check from the statement in the register by check number and comparing amounts. Register checks that have not cleared are outstanding. Bank checks with no register row were never recorded. Both lists matter when reconciling the account.

### Building the match

Put the bank statement's checks on a second sheet with check number, date cleared and amount. In the register, add a lookup on check number that pulls the cleared amount. Then:

1. A blank result means the check is outstanding.
2. A cleared amount that differs from the register amount is a recording error on one side.
3. Any bank check number with no register match is unrecorded.

### Finishing the example

Suppose the bank statement for the example account shows checks 1201, 1202, 1203, 1206, 1209 and 1208 cleared, with 1208 for 300.00. Then 1204, 1207 and 1210 are outstanding, totalling 412.00 + 76.40 + 133.25 = 621.65. Check 1208, the gap in the numbering, was written and cashed but never recorded. Add it to the register with the payee from the check image, if the bank provides one.

### Getting the bank side into rows

The bank statement half of this match is where FastBankConvert fits. It is being built to turn bank statement PDFs into Excel, CSV or JSON, with dates, descriptions and amounts in their own columns and a warning if the balances do not add up. It is not open yet; the [get-started page](/get-started) is where to join.