Help
App openenPlan een gesprek

Totals, VAT, and rounding

How Cortena handles totals, tax keys, and rounding differences.

Engelse versie wordt getoond

Cortena tracks two views of your invoice total: what was extracted from the document and what is calculated from line items and VAT rates. Understanding both helps you fix review queues and pass export checks.

Who this is for: AP clerks and controllers who see total warnings, VAT validation errors, or export preview mismatches on supplier invoices.

1. Extracted total vs calculated total

ValueSource
Extracted totalRead from the invoice PDF, scan, or e-invoice XML
Calculated totalSum of line amounts + VAT lines Cortena computed

When they differ beyond a small tolerance, the invoice may show Needs review or trigger a workflow condition on totals mismatch. Open line items and check quantity, unit price, VAT rate, and discounts.

2. VAT styles on the invoice

Suppliers present VAT differently. Cortena normalises common patterns:

StyleExample on document
Net + VAT per lineUnit price excl. VAT, VAT % per row
Gross linesAmount includes VAT; Cortena backs out net
Summary block onlyOne subtotal + VAT 19% + total at bottom
Mixed rates7% and 19% on different lines (common in DE)

Edit line items on the detail panel if extraction misread a rate or amount. Changes update the calculated total immediately.

3. Export preview uses stored values

Before sending to DATEV, Twinfield, Exact, or Agicap, Cortena's export preview shows exactly what will leave the system, based on saved invoice and match data, not a hidden recalculation at export time.

If preview totals differ from what you expect:

  1. Fix line items or header totals on the invoice detail.
  2. Re-check BU / VAT codes on each line.
  3. Run export. Preview will match what ends up in your accounting system.

4. Workflow and validation

Your workflow may branch on:

  • Extracted vs calculated total · send mismatches to review
  • Invalid VAT ID · EU VIES check failed
  • Missing booking account · line without match

Configure these in Workflow. See Workflow configuration.

5. Quick fixes

ProblemTry
Totals mismatch after scanReprocess or fix lines manually
Wrong VAT %Edit line → pick correct BU/VAT code
Export rejects VATSync VAT codes from accounting; update guidelines sheet

Quick reference

TermMeaning
Extracted totalFrom document / XML
Calculated totalFrom Cortena line math
Export previewWhat will be sent · matches stored data
Fix mismatchEdit lines or reprocess