WooCommerce invoice reconciliation

WooCommerce invoice reconciliation: match payments, VAT totals, PDFs, refunds, and credit notes.

WooCommerce orders are not the same as reconciled invoices. If finance needs to match bank transfers, paid dates, VAT basis, refunds, credit notes, and PDF evidence, your invoice workflow needs to carry more than an order status.

Why reconciliation becomes a purchase trigger

Many EU WooCommerce stores start by attaching a PDF invoice to order emails. The real pain appears later: bank transfers arrive after checkout, refunds need credit notes, reverse-charge orders need evidence, and accountants need export rows that agree with the issued PDFs.

Lattice Invoices is being shaped around this operational gap: turn WooCommerce orders into finance-ready invoice packets with payment state, VAT evidence, customer PDFs, credit notes, and accountant handoff fields connected from the start.

Invoice reconciliation readiness checklist

Every invoice has a clear payment state: draft/proforma, issued, partially paid, paid, overdue, refunded, or credited
Bank-transfer references, order numbers, customer company names, and invoice numbers are easy to match during month-end bookkeeping
Partial refunds and failed payments create linked credit notes instead of silently changing the original invoice total
VAT/BTW totals can be reconciled by country, tax rate, reverse-charge status, exemption reason, and accounting period
Customer-facing PDFs, My Account downloads, and email attachments match the same invoice number visible in finance exports
Accountant export rows include invoice number, payment method, paid date, due date, credit-note reference, VAT basis, and PDF URL

Payment-to-invoice reconciliation map

ScenarioWhat finance must matchInvoice workflow requirement
Bank transfer paid laterBACS order is created today, payment lands next weekKeep proforma/request separate from final paid invoice and expose paid date/due date for finance.
Stripe/card paid immediatelyPayment succeeds before invoice PDF is emailedIssue invoice with paid status, transaction reference, VAT evidence, and customer download link.
Partial refundOne line item or discount is refunded after the invoice was issuedCreate a credit note linked to the invoice instead of overwriting the original invoice total.
Subscription renewalRenewal invoice is generated automatically, then payment fails or retriesKeep renewal invoice, failed-payment state, reminder trail, and final payment event connected.
Month-end accountant handoffBookkeeper needs totals by VAT rate and payment statusExport reconciled invoice/credit-note rows with PDF URLs, payment status, VAT basis, and customer metadata.

Common reconciliation failure points

BACS payments that arrive days later

Problem: A customer chooses bank transfer. WooCommerce marks the order on-hold, finance sees money in the bank later, and nobody is sure whether the PDF should be a proforma, unpaid invoice, or paid invoice.

Lattice path: Separate the payment-request/proforma stage from the final invoice packet, then store the paid date, bank-transfer reference, PDF, and export fields together.

Refunds that break VAT totals

Problem: Support refunds part of an order but the accountant's spreadsheet still shows the original VAT invoice. The VAT return and customer PDF no longer line up.

Lattice path: Create a linked credit note with the same VAT context and export both the original invoice and correction row for reconciliation.

Mixed B2B VAT decisions

Problem: Some EU buyers are reverse-charged, some are domestic VAT, and some are manually exempt. Month-end reconciliation requires digging through order meta and email notes.

Lattice path: Keep VAT ID, exemption reason, country pair, invoice wording, and VAT summary in one invoice record instead of scattered checkout metadata.

Early-access offer: €49 invoice reconciliation workflow review

Send your store URL, country, current invoice plugin, payment methods, refund/credit-note workflow, VAT setup, and accountant export needs. The goal is to turn the reconciliation problem into a concrete Lattice Invoices workflow before month-end pressure hits.

Send my reconciliation requirements

FAQ

What does invoice reconciliation mean in WooCommerce?

It means matching every invoice and credit note to its WooCommerce order, payment status, paid date, refund state, VAT treatment, PDF document, customer download, and accountant export row so finance can close a period without manual guesswork.

Why is bank transfer reconciliation harder than card payments?

Bank transfer orders are often created before money arrives. Stores need a clean proforma or payment-request workflow, then a final invoice state when the payment is matched. Without that separation, accountants often reconcile from order notes and bank statements manually.

Should refunds change the original invoice?

Usually the issued invoice should remain preserved. A refund should create a linked credit note or correction document that references the original invoice number and carries the correct VAT treatment for the refunded amount.

How does Lattice Invoices help with reconciliation?

The early-access product path is focused on EU WooCommerce invoice operations: VAT fields, sequential numbers, PDFs, credit notes, bank-transfer workflows, due dates, customer downloads, payment-state evidence, and accountant-ready exports.