Zovo Invoice Ledger

Put a batch of supplier invoices into one spreadsheet with net, tax and gross totals. Zovo Invoice Ledger reads invoice PDFs with selectable text, pasted invoice text, or invoice values typed in the chat, and builds one Excel and CSV ledger: supplier, invoice number, invoice and due date, currency, net, tax for each rate, tax total and gross.

Each invoice is checked to the cent: net plus tax must equal the total, and each tax amount must match its rate and taxable base. Invoice numbers that appear twice for the same supplier are flagged, and so are invoices with the same supplier, date and total under different numbers. Values that had to be computed (for example net from a tax-inclusive total) are marked.

The Excel file has a Ledger sheet, totals By supplier, a By tax rate summary (20%, 19%, 5.5%, 8.25% and so on, with the taxable base), and a Checks sheet listing each issue. Totals are kept per currency; amounts in different currencies are not added together.

Reads US and European number formats (1,234.56 and 1.234,56), day/month or month/day dates, and invoice labels in English, German, French, Spanish, Italian and Dutch.

Limitations: reads header totals, not line items; scanned PDFs without selectable text are skipped (type their values instead); up to 20 files, 12 pages per file and 200 invoices at a time; does not convert currencies, file tax returns, or say whether tax can be reclaimed. Download links expire after about an hour.