<- View all workflow automations

Vendor statements reconciled automatically — missing invoices and duplicates surfaced before payment

Lido extracts every line item from vendor account statements, compares each entry against your AP ledger, and flags discrepancies, missing invoices, duplicate payments, amount mismatches, and credits not applied. What takes your AP team a day per vendor takes minutes per batch.

  • Extract statement line items from any vendor format. Utility statements, supplier account statements, and vendor aging reports. Lido extracts the line-item table from any layout without per-vendor configuration.
  • Three-way comparison: statement vs. ledger vs. open POs. Lido compares what the vendor says you owe against what's in your AP ledger and your open purchase orders. Discrepancies are highlighted with both sides of the comparison visible.
  • Every discrepancy type flagged specifically. "Invoice #INV-2026-0332 on vendor statement not found in AP ledger" is more useful than "there's a difference." Lido identifies the specific type of discrepancy, missing invoice, duplicate, amount variance, or unapplied credit, so your team knows exactly what to investigate.
Trusted by thousands of finance and operations teams

How vendor statement reconciliation works in Lido

Vendor statement reconciliation is a control that most AP teams do too rarely because it takes too long. When it's automated, the control runs every month without anyone scheduling time for it.

1. Vendor statements arrive and are extracted automatically

Monthly vendor account statements arrive as PDFs, by email, through a vendor portal, or from your supplier's EDI system. Lido picks them up from a watched inbox or folder and extracts every line item: invoice number, invoice date, invoice amount, payment applied, credits applied, and current balance due.

2. Extracted statement data is compared against your AP ledger

Lido receives your current AP ledger as a data export or pulls it via API. Each line item on the vendor statement is matched against the corresponding record in your ledger. Matches on invoice number, amount, and payment date confirm that both sides agree. Mismatches are flagged with both values visible side by side.

3. Specific discrepancy types are identified

Not all discrepancies are the same problem. Lido classifies each one: "Invoice on vendor statement not in AP ledger" (you may owe money you've missed), "Invoice in AP ledger not on vendor statement" (may indicate a payment not acknowledged), "Amount mismatch: statement shows $8,400, ledger shows $8,040" (likely a transposition error), "Payment on vendor statement not reflected in AP ledger" (duplicate payment risk).

4. Unapplied credits from the vendor are surfaced

If the vendor's statement shows a credit balance, from returned goods, an overpayment, or an early payment discount. Lido flags it. Unapplied credits that your ledger does not reflect mean you are paying more than you owe. Each flagged credit comes with the statement line and the reference to the source transaction.

5. Reconciliation output is ready for AP review and close

The output is a reconciliation workbook: one row per statement line item, with the statement amount, the ledger amount, the match status, and the discrepancy type. Matched rows are confirmed. Flagged rows require AP action, investigate, resolve, and document. The workbook becomes the reconciliation support for your month-end close package.

Try it free

See this workflow run on your documents

Upload a batch and get structured output in minutes.

Statement types Lido reconciles

Vendor account statements

Supplier-issued monthly account statements listing open invoices, applied payments, credits, and account balance. Any vendor format, any layout.

Utility account statements

Electric, gas, water, and telecom utility bills showing account charges, prior balance, payments received, and current balance due.

Supplier aging reports

Vendor-generated aging summaries showing invoices by age bucket (current, 30, 60, 90+ days). Useful for identifying invoices that have aged in the vendor's system but not been received.

Credit card and purchasing card statements

Corporate card statements listing transactions, merchant names, amounts, and dates. Reconciled against expense submissions and GL coding.

Intercompany billing statements

Statements from related entities for intercompany services, cost allocations, and shared service charges. Reconciled against intercompany receivables on the counterparty.

Factored invoice statements

Statements from factoring companies or banks that have purchased vendor receivables. Payment goes to the factor, not the original vendor, reconciled against factor statements.

Why vendor statement reconciliation is skipped — and what it costs

The reconciliation that never gets done

Monthly vendor statement reconciliation is on the AP calendar but never gets completed. A statement from Grainger arrives with 34 line items. Reconciling it means opening your AP ledger, scrolling through hundreds of transactions, finding each matching entry, and noting every difference in a separate workbook. For 20 active vendors, that's a week of work done well, or a control that gets signed off without being completed. Either way, duplicate payments, missing invoices, and unapplied credits accumulate until they surface as surprises in an audit.

Reconciliation completes in minutes per vendor, every month

Lido extracts the vendor statement, pulls your AP ledger data, and produces the reconciliation comparison in minutes. Every line item is matched. Every discrepancy is classified. Your AP team reviews the flagged items, not the entire statement. The reconciliation runs every month without anyone scheduling a "statement rec week."

Lido vs manual statement reconciliation

FeatureLidoManual process
Extract statement line items from any vendor format automatically
Compare each line against AP ledger records automatically
Classify discrepancy type (missing, duplicate, mismatch)
Flag unapplied vendor credits before the next payment run
Produce audit-ready reconciliation workbook per vendor
Open the statement and match each line yourself
AP controls

Vendor statement reconciliation is how you catch what the invoice workflow misses

Run it every month automatically and catch duplicate payments and missing invoices before they become audit findings.

Common use cases

Manufacturing

Reconcile 30+ supplier statements monthly before the payment run

A mid-size manufacturer pays 30 active suppliers on net-30 terms. Statements arrive in the first week of each month. Lido reconciles all 30 statements before the payment run, catching two duplicate payment risks and a $4,200 unapplied credit in February alone.

Distribution

Reconcile carrier and freight broker statements weekly

A distributor pays 15 carriers weekly. Carrier statements are reconciled against the rate confirmations and freight invoices processed that week. Duplicate billings for the same load, a common carrier billing error, are flagged before payment is released.

Professional Services

Reconcile software vendor and subscription statements quarterly

A firm with 40+ SaaS subscriptions reconciles vendor statements quarterly. Lido identifies subscriptions billed at the wrong tier, seats billed for terminated employees, and credits from cancelled licenses not reflected in the AP ledger.

Multi-Entity Operations

Consolidate vendor statement reconciliation across entities

A holding company with shared vendors across subsidiaries reconciles vendor statements at the consolidated level. Lido compares the vendor's total balance against the sum of AP ledger balances across all entities, flagging discrepancies that are hidden when each entity reconciles independently.

Stop doing vendor statement reconciliation manually — or skipping it entirely

Try Lido free. Upload a vendor statement and your AP ledger export and see a complete reconciliation in minutes.