Damages Schedule PDF to Excel: Checking the Arithmetic

To turn a scanned damages schedule PDF into Excel, run the scan through OCR that detects tables, export a workbook, convert the amount cells to numbers and rebuild every subtotal as a formula. When your formulas reproduce the printed totals, the workbook matches the page, and you can start testing the arithmetic itself.

A damages schedule is a document made of sums. That makes it one of the few scanned documents that can prove its own conversion, and one of the few where a conversion lets you test the author's work as well as the software's. This guide keeps those two tests apart, because mixing them up is how a misread digit gets reported as the other side's mistake.

What is on a damages schedule that a spreadsheet has to keep?

A damages schedule holds categories of loss, line items inside each category, a subtotal for each category, a grand total, and a reference from each line to the document that supports it. A spreadsheet has to keep all five, plus the page each row came from, or it cannot be checked against the served copy.

"Damages schedule" is not a defined form. As the term is commonly used, it means a table setting out what a party claims and how the figure is built up. The one in your file may be called a schedule of loss, a computation of damages or an exhibit to a demand letter. Read the document you were served and the rule or order it answers before you assume what it must contain.

In federal civil cases, one source of such a document is the initial disclosure rule. Federal Rule of Civil Procedure 26(a)(1)(A)(iii) requires a party to provide "a computation of each category of damages claimed by the disclosing party". State courts, arbitral bodies and claims processes set their own requirements, so check which one governs your matter.

What the page shows, and where it belongs in the workbook:

Two things are not on the page and need adding: the page number of the scan for each row, and a line number recording the printed order. Without them a row cannot be traced to the scan, and a sorted sheet cannot be put back in order.

If you are building a schedule of your own from bills, not converting someone else's, the columns are a different question. The guide to converting medical records explains what columns a damages spreadsheet needs.

Converting a scanned damages schedule PDF to an Excel workbook

Convert the schedule in four moves: file the served PDF untouched, run a copy through OCR that detects tables, export Excel, and then shape the exported sheets into one table with a row type on every line. Do no arithmetic until the shape is right.

The steps in order:

1. Save the served PDF where it will not change. Every later check is against this file. Work from a copy.
2. Run the copy through table-aware OCR. In Schema Law you upload the PDF in the browser, check the parsed pages on screen against the original, and export Excel. The workbook puts each table on its own sheet, with the rest of the text on another. Every plan includes the Excel export; the pricing page lists how many pages each plan lets you convert.
3. Save the export twice. Keep one copy exactly as downloaded. Do the work in the other.
4. Combine the table sheets. A schedule that runs over three pages arrives as three or more tables. Stack them on a new sheet in page order, with a Page column filled in before each block is pasted.
5. Add a Line column. Number the rows 1, 2, 3 in printed order. After any sort, sorting on Line restores the schedule as served.
6. Add a Row type column. Mark each row as heading, item, subtotal, total or note. This one column is what makes the later formulas safe.
7. Fill the Category column down. The category name is printed once, over its block. Copy it onto every item row beneath it.
8. Convert the amounts into a new column. Exported cells hold characters, not numbers. Leave the column as read in place and build a numeric column beside it. The Excel guide covers numbers, dates and currency in exported cells.
9. Read the text sheet. Captions, footnotes and assumptions that were not part of a table land there. Move the ones that qualify a figure into your Notes column.

At the end of this stage the working sheet has these columns: Line, Page, Category, Row type, Date, Description, Source, Amount as read, Amount.

Why do the subtotals on a converted damages schedule stop adding up?

Subtotals on a converted damages schedule stop adding up for three conversion reasons: a digit was misread, a subtotal or total row was summed as if it were a line item, or a negative printed in parentheses lost its sign. A fourth reason is that the schedule was wrong on paper. Rule out the first three first.

A misread digit

One wrong character in one amount moves the subtotal and the grand total by the same figure. The difference is the clue. If your sum is out by 60.00, look for a tens digit that could be read two ways. The post on why OCR gets numbers wrong lists the digit pairs and decimal slips to look for, so this guide does not repeat them.

A totals row read as data

On the page, bold type or a ruled line tells you "Subtotal" is a different kind of row. In a cell, it is one more number in the column. Sum the whole column and each category is counted twice: once as its items and once as its subtotal. With a grand total row included, the figure is three times the claim. A sum that is a clean multiple of the printed total is the signature of this fault, and the Row type column is the cure.

Negatives in parentheses

A schedule may print an offset, such as an amount already paid or earnings in mitigation, as (2,400.00). Three things can happen to that cell in conversion. The parentheses may be dropped, leaving a positive 2,400.00. They may be kept, leaving text that a sum skips. Or one parenthesis may be read as another character. In the first case your subtotal is high by twice the offset. In the second it is high by the offset once.

Cells that never became numbers

A cell that still holds text is left out of a sum without any warning. Count the numeric cells in the Amount column and compare with the count of item rows. If the counts differ, find the cell before you look for anything subtler.

Rebuilding the damages schedule's totals as live Excel formulas

Replace nothing. Keep each printed subtotal as a typed value in one column, compute the same figure with a formula in the column beside it, and subtract one from the other. A difference of zero on every subtotal and on the grand total means the item rows match the page.

A worked example

Take a fictional schedule served by the plaintiff in Tennant v. Brightwater Haulage. It has three categories.

On a summary sheet, list the categories and enter the printed subtotals by hand from the scan. Beside each, compute the subtotal from the item rows only:

=SUMIFS(Work!I:I, Work!C:C, "Past medical expenses", Work!D:D, "item")

Here column I is Amount, C is Category and D is Row type. The formula adds the amounts of rows that are items in that category and ignores everything else. A third column holds printed minus computed.

The first pass on the converted workbook gives this:

Property damage ties. Past medical expenses is over by 60.00, which points at a tens digit: the page says 3,915.50 and the cell says 3,975.50. Lost earnings is over by 4,800.00, which is twice 2,400.00: the offset came through as a positive. Correct both cells against the scan, note each correction with its page, and all three differences go to zero. The computed grand total is then the sum of the three computed subtotals, 45,664.65, which matches the page.

Rules for the rebuild

• Type the printed controls from the scan, not from the export. If the printed subtotal is itself misread, comparing it with a formula proves nothing.
• Never overwrite Amount as read. The corrected value goes in Amount. The pair shows what the software read and what the page says.
• Keep a corrections log. Line, page, value as read, value on the page, your initials and the date.
• Tie from the bottom up. Items to subtotals first, then subtotals to the grand total. A grand total that ties while a subtotal does not means two errors are cancelling.
• Lock the tied state. Save a copy named as tied before any analysis starts.

Testing the other side's damages arithmetic in the converted workbook

Once every computed figure matches its printed figure, the workbook is a faithful copy of the schedule, and you can test the schedule itself: recompute what it claims to compute, sort it to see what is large, and look for the same loss entered twice.

That order matters. A discrepancy found before the workbook ties may be a conversion fault. One found after it ties is on the page.

Label each category by the recovery the schedule claims. Medical bills and lost wages sit with compensatory damages. Follow-on costs, such as a rental car or storage, sit with consequential damages. Keep a credit for wages earned after the injury negative, and file that line under mitigation of damages. Put restitution or a civil penalty in its own category so it stays out of the compensatory total.

Recompute

Formulas in the tied workbook already recompute sums. If every subtotal ties to its items, the adding up is right. Now test the lines that are themselves calculations:

• Rate times quantity. A line reading "26 weeks at 550.00" should equal 14,300.00. Put the weeks and the rate in their own cells and multiply.
• Percentages. Interest, tax and uplift lines state a rate and a base. Recompute and compare.
• Periods. Count the weeks or months between the stated start and end dates and compare with the number the line uses.
• Rounding. Note whether lines are rounded before or after they are added. A difference of a few cents across a long schedule is rounding, not a second set of books.

Sort

Sort a copy of the item rows by amount, largest first. The few lines that carry the bulk of the claim are the ones whose source documents deserve the first look. Then sort by date and scan for entries outside the period the claim covers. Sorting on Line puts everything back.

Find duplicate entries

A duplicate is two rows for one loss: the same invoice listed under two categories, or a bill entered once when issued and again when paid. Add a helper column that joins date, payee and amount into one cell, then highlight repeats. Microsoft's page on how to find and remove duplicates in Excel gives the path as Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values.

Highlight; do not delete. The same page warns that "When you use the Remove Duplicates feature, the duplicate data is permanently deleted." Your workbook has to keep showing what was served. Two identical rows may also be two real events, such as two therapy sessions billed at one rate on one day, and only the source documents can tell you which.

Trace to the source documents

Each row's Source column names an exhibit or a Bates range. Pull it and compare payee, date and amount. Where the support is a stack of invoices, put those in a sheet of their own; the guide to extracting billing records to Excel from scanned invoices covers that conversion. A schedule line that is larger than the invoices behind it is a finding. What to do with a finding is a question for the lawyer running the case.

Marking a converted damages schedule as a working copy of the served document

Label the workbook so that nobody can mistake it for the served schedule: say so in the file name, on a first sheet, and in the print header. The served PDF stays the document of record. The workbook is your analysis of it.

A workbook with live formulas looks more authoritative than a scan, and it travels. It gets attached to emails, sent to an expert, printed for a meeting. Each of those copies should carry its own description.

File name. Lead with what the file is, then what it came from. For example: WORKING COPY - Pl damages schedule served 2026-09-14 - converted 2026-10-08.xlsx. The post on legal document conversion has a fuller scheme for naming converted copies so the source scan stays identifiable.

An About sheet, first in the workbook. Put these lines on it:

• Working copy. Not the served document.
• Source: the file name of the served PDF and where it is stored.
• Served by, and the date of service.
• Converted by, the date, and the software used.
• Checks done: for instance, "All three subtotals and the grand total tied to pages 1 to 3 of the scan."
• Corrections made to converted values: the count, with a pointer to the corrections log.
• Columns added by this office: Line, Page, Row type, Amount, and any analysis columns.

Print header. Set a header reading "Working copy prepared by [firm] from the schedule served [date]" so a printed page carries the label too.

Colour for anything you added. Shade the columns and rows that are yours. A reader should see at a glance which cells came from the other side and which are your arithmetic.

Cite the PDF. When a figure goes into a letter or a brief, cite the page of the served schedule. The workbook is how you found the point, not the authority for it.

Before sending the workbook outside the firm, decide whether your analysis columns and notes should go with it. A second copy saved without them is the one to send. For the full list of file types a conversion can produce from one upload, see the export formats on the homepage.