Skip to content
English
  • There are no suggestions because the search field is empty.

Invoice Reconciliation - Line Level Matching

Apicbase checks every line of a supplier invoice against the purchase order line and against what you actually received. Lines that agree are marked as matched, so you only look at what is wrong, and you can ask the supplier for a credit in a few clicks.

Your library needs the new invoice screens switched on. If you do not see them, ask your Customer Success Manager.

The examples follow four invoices (A to D) from one supplier.

1. Before you start

  • Apicbase switches invoice reconciliation on for your library.
  • Your role needs permissions in the Invoice group: View to open and export invoices, Edit to upload invoices, handle lines and send credit requests, Approve to change an invoice's status and set the margin, Delete to delete invoices. You only see the buttons your role allows.
  • Your purchase orders and deliveries are recorded in Apicbase.

2. Getting invoices in

  1. Go to Procurement > Invoices and select the outlet at the top.
  2. Select Upload invoices, then Bulk upload (AI Powered) to upload PDF invoices, Add manually to enter one yourself, or Send via email to see the address to forward invoices to.

The Upload invoices menu with Bulk upload (AI Powered), Add manually and Send via email, next to Settings

Apicbase reads the invoice, recognises the supplier and links the purchase orders. A PO number printed on the invoice is the surest way to get the right order, so ask your supplier to include it. One invoice can cover several orders: invoice D lists two PO numbers, and both were linked automatically.

Invoice D with two linked purchase orders under Apicbase PO's (2), 100% of invoice value matched and Matched lines 4/4

If a purchase order is missing, select Search and link a purchase order on the invoice. The invoice lines are then paired with the order lines automatically. If you unlink an order, its pairings are cleared and lines you accepted or disputed become open again.

While a credit request on the invoice is open, you cannot unlink its purchase orders. You see A credit request is open on this invoice, so its purchase orders cannot be unlinked. and Ask support to withdraw the credit request first. Select View credit request to open it.

3. The invoices list

Each invoice shows a status line:

  • 100% Matched: the invoice total agrees with what you received.
  • Difference: the invoice differs by more than your margin. Invoice C shows Difference: € 17.88.
  • PO missing: no purchase order is linked yet.
  • Delivery not yet received: nothing has been received on the linked orders yet.

The list compares totals. The line check happens inside the invoice.

The invoices list sorted by PO difference (high to low), with the invoices showing Difference: € 17.88 at the top, the filters on the left and Settings and Upload invoices at the top

The default sort, PO difference (high to low), puts the biggest differences first. The list hides approved invoices by default. To see them, tick Approved under Approval status.

To download invoice totals, select the invoices and then Export in the bar that appears. You get a CSV file with the totals of each invoice.

4. Reading an invoice

Select Review to open an invoice. The top of the page sums it up:

  • of invoice value matched: the share of the invoice value on matched lines.
  • Matched lines: matched lines out of all lines.
  • Invoice subtotal (excl. tax) and Total payable.
  • GR amount: the value of what you received.
  • Difference: invoice subtotal minus GR amount.

Invoice A with 100% of invoice value matched, Matched lines 4/4 (All matched), Invoice subtotal €89.41, GR amount €89.41 and a Difference of €0.00

Under Line item reconciliation, lines are grouped under Mismatched lines and Matched. Each line gets a verdict:

  • Matched: quantity and price agree with the delivery and the order, within your margin. A line billed per piece instead of per case also matches when the totals agree.
  • Price mismatch: the unit price differs from the order, or the line amount is not quantity times price.
  • Quantity mismatch: the quantity differs from what you received.
  • No PO line: no purchase order line matches, for example an item you did not order.
  • Not comparable: a quantity, price or article is missing.
  • Suggested match: Apicbase did not recognise the article and paired the line with an order line by name, shown as Paired by name. Check that it is the same article and select Accept. Until then it counts as a mismatch. If it is another article, select Dispute or Unlink from PO.

Invoice C has three mismatches and a Difference of €17.88.

The Mismatched lines of invoice C: Doperwt with Price mismatch, Brood glutenvrij with Quantity mismatch and Verse kruidenmix with No PO line, each with an explanation and Accept and Dispute, and Matched (1) below

The explanation under a line is written by AI, in your library's default language. Check it against the figures. A matched line only shows an explanation when the AI also found the line correct.

Select Show details to compare the Invoice, PO and GR rows. The bread is invoiced 12 × 4.16 = 49.92, but you received 10: a difference of +2 PCE. For a PDF invoice, a snippet of the original under the table shows the line highlighted. Drag it to move it and use the zoom buttons to read it.

Show details on the bread line: Invoice 12 PCE at 4.16 = 49.92, PO 12 PCE, GR 10 PCE = 41.60, Difference +2 PCE (+20.0%) vs GR, and the highlighted line in the original invoice snippet

Select a linked order, or PO # on a line, to see the purchase order next to the invoice: what was ordered and received per article, and which invoice lines are paired with it. Open purchase order opens the order in a new tab.

The purchase order drawer opened from the bread line of invoice C: brood glutenvrij Ordered 12 and Received 10, paired with invoice line #3, and Open purchase order

5. Handling mismatches

For each mismatch, choose:

  • Accept: keep the line as invoiced. It moves to Matched and counts as matched. The amounts do not change.
  • Dispute: mark the line as wrong, so you can claim it from the supplier.

To dispute a line:

  1. Select Dispute. A text box opens with the AI explanation filled in.
  2. Write the reason the supplier will read.
  3. Select Confirm dispute.

Undo reverses an accept or a dispute. A disputed line stays under Mismatched lines, even when its figures match later.

On invoice C, you accept the herb mix that was not on the order. You dispute the peas (7.71 instead of 7.27) and the bread (12 invoiced, 10 delivered). The top bar now shows New credit request (2).

Invoice C with New credit request (2) in the top bar, the peas and the bread Disputed with their reasons, and the herb mix Accepted under Matched

Accepting every line does not approve the invoice.

6. Asking the supplier for a credit

  1. Select New credit request in the top bar.
  2. Check Supplier email and Reply to. A copy of the email goes to the Reply to addresses, which hold your own address by default.
  3. Under Disputed items, untick any line to leave for later. Ticking recalculates the Requested credit amount, so tick first, then adjust the amount.
  4. Add Other remarks if you want; they are optional. The invoice PDF is attached automatically.
  5. Select Send credit request to supplier. If the button stays grey, the hint under the amount says why.

Each line claims what was invoiced minus what was received. For invoice C: €1.76 + €8.32 = €10.08.

The New credit request page with the copy sentence, the two disputed items (€1.76 and €8.32), a requested credit amount of 10.08, the optional Other remarks, the invoice PDF attached and Send credit request to supplier

The supplier gets an email with the disputed lines and reasons. Claimed lines show Credit request # with its number and can no longer be undone. The Credit requests box on the invoice lists each request with its amount and status. Select one to see the claimed lines, and Open settlement request to follow it up.

Invoice C with the Credit requests (1) box and the credit request drawer open: status Requested, Open settlement request, the reasons, Claimed lines and Total requested Excl. tax €10.08

7. Allowing small differences

Set a Margin for Acceptance so small differences count as matched.

  1. On the invoices list, select Settings.
  2. Move the slider (0% to 10%) and select Save.

The margin applies to the outlet selected on the list. Without one, every difference counts.

On invoice B, the cream is billed at 26.61 against 26.25 received, 1.37% more. At 0% it is a Price mismatch. At 2% it is Matched and invoice B shows 100% Matched.

The Settings window with Margin for Acceptance set to 2.0% and Invoices with variance within 2.0% will be marked as matched

The invoices list with the margin at 2%, invoice B (KFS-2026-10437) at 100% Matched below the invoices that still show a Difference

8. Approving, flagging or rejecting an invoice

The top bar of the invoice shows the next step for its status, and the menu next to it holds the other moves:

  • Received or Pending approval: Approve invoice. Menu: Flag, Reject.
  • Flagged: Approve invoice. Menu: Reject. Remove flag is on the flag banner.
  • Approved: Mark as paid. Menu: Flag, Withdraw approval.
  • Rejected: Reopen.
  • Paid: no further moves.

The top bar of a Pending approval invoice with Approve invoice and New credit request, and the menu open with Flag, Reject, Change to Credit note and Delete invoice

Only Reject asks you to confirm. The supplier is not notified of a flag, an approval or a rejection. Remove flag, Reopen and Withdraw approval put the invoice back to Pending approval.

Flag flags the invoice straight away with a suggested reason. A banner shows who flagged it and when, and you can pick another reason there.

The flag banner Flagged by ... on 22 Oct 2026 with the reason list open (Price, Quantity, Items, Delivery, Quality, References, Other) and Remove flag

Before you approve, check open issues under Matched lines. It lists what is still open, such as lines with a price or quantity difference or lines that are not on the purchase order. It is a reminder only: you can still approve the invoice.

The 3 open issues button under Matched lines with its Still open on this invoice list: 1 line with a price difference, 1 line with a quantity difference, 1 line not on the purchase order

In the list, Approve shows on a 100% Matched invoice that still waits for approval.

9. Comparing with the original

Select View on original on a line to open Compare original vs digital with that line selected: the PDF next to the lines Apicbase read, with the line highlighted on both. Click a line on the PDF to find it in the table. To correct a line, select Edit this line and see "How do I correct an invoice Apicbase has read?".

Compare original vs digital for invoice C, with the original PDF on the left, the digital lines with Article code, Qty, Unit, Unit price, Tax % and Amount on the right, and the bread line highlighted on both

Frequently asked questions

Why does a line say No PO line? It is not on the linked orders, or the supplier invoiced another article. Accept it if you agree, otherwise Dispute it.

Why does an invoice say PO missing? Apicbase could not find the order. Link it with Search and link a purchase order.

Why is the credit amount lower than the Difference? The Difference covers the whole invoice. The credit request only claims the disputed lines. On invoice C, the €17.88 also includes the accepted herb mix (€7.80).

Why did an invoice disappear from the list? It was approved. Tick Approved under Approval status.