Define what counts as one item
A description that wraps onto a second printed line is usually still one item. A repeated table header on the next page is usually not an item. A subtotal row is usually a summary. The extraction process must distinguish these cases before a spreadsheet can be trusted.
For each item, identify description, quantity, unit, unit price, tax rate and line amount where present. Preserve product references separately from descriptions when the document provides them. Do not fill missing quantities with one just to make arithmetic work.
Check a worked table before checking the grand total
The following invented rows demonstrate the relationship between quantity, price and amount. The amount column is before invoice-level tax in this example. Real invoices can use different conventions, so read the column headings.
- Line amounts add to 100.00.
- At a single 20% tax rate, tax is 20.00 and total is 120.00.
- A missing delivery row makes the row sum 80.00 even if the extracted grand total is correct.
- Discounts, inclusive tax and rounding can change these simple relationships.
Description | Quantity | Unit price | Line amount |
|---|---|---|---|
Demo paper | 4 | 12.50 | 50.00 |
Demo folders | 3 | 10.00 | 30.00 |
Demo delivery | 1 | 20.00 | 20.00 |
Four layouts worth testing
Wrapped descriptions: verify that continuation words stay on the correct item. Page breaks: check the final row before the break and the first after it. Repeated headers: make sure “Quantity” has not become an item description. Multiple tax rates: do not apply one rate to every item just because the first row uses it.
Also check negative lines, credit-style adjustments and invoice-level discounts. The current Kaliits OCR pilot focuses on invoices; a credit note or other document may need a different workflow. Never silently treat an unsupported document as a normal payable invoice.
Evaluate rows and cells, not just a screenshot
Count the printed items and exported rows. Then sample across the table, including the longest description and a row close to a page break. Record missing rows, extra rows, shifted columns and wrong values separately.
Compare tools on the same permitted documents. Track how many edits are needed before the spreadsheet is useful, and how long the review takes. Vendor claims about perfect tables are not a substitute for this test. We do not publish a cross-vendor accuracy ranking because we have not run a controlled benchmark.
A short review that protects the spreadsheet
Check the supplier and customer separately, then the invoice reference, date and currency. Compare each line with the original. A correct total does not prove that the descriptions or quantities are right.
Keep invoice IDs as text, including leading zeros. Check decimal separators and date conventions before combining files from different countries. Missing values need attention; a blank field is more useful than an invented value.
- Compare row count and continuation pages.
- Check quantities, unit prices and line amounts.
- Check subtotal, discounts, charges, tax and total.
- Export a copy and retain your source in your own archive.