Skip to main content

How we assign Status and Actions: Matching criteria

Behind-the-scenes: how we assign Status and Actions to your reconciliations


Learn why different invoice properties produce different Status and Actions. We'll guide you through our core matching criteria and explain how we determine if an invoice is a match, missing, or needs investigation.


Contents


1. The five-step reconciliation process


Xelix follows a five-step reconciliation process. In this article, we’ll dive deeper into how we present your Reconciliation Results to you, specifically the Status of an invoice (e.g. if there’s a match between what’s on the Statement and your system) and the associated Assigned Action.


The other steps:

  1. How do we classify and match your invoices? check How we match invoices: Matching logic

  2. How do we extract information from your invoices? check How to reconcile a Statement in Xelix

  3. How do we present your reconciliation results? check Rec Results Page: Ledger, Statement and Action panels

  4. How do we export your reconciliations? check How to export and share your reconciliation

  5. Want to dive deeper into Present? check How to set a Reconciliation Basis to learn how our Status and Assign Actions can ignore invoice timing and/or posting details.


2. Reconciliation Results page: Actions Panel

In this article, we'll guide you through the series of core criteria we evaluate your invoice against, allowing us to delegate a single Status and Assign Action for each invoice.

📌 Tip: We’d recommend you first read our guide on How we match invoices: Matching logic, which explains how we determine which invoices are relevant to your reconciliation. This article dives deeper into what we do with the relevant invoices after we’ve found them.


3. Core criteria

These are the default columns you can see in the Action panel in your Rec Results.

During the matching process, Xelix evaluates every invoice line against four core criteria to determine the invoice’s Status & Assign Actions:

1. Invoice Found: Indicates whether we have found the invoice across any of your systems. This column shows if an invoice is present (even if against a different vendor/currency/division), reversed, deleted or completely missing.


2. Open at Ledger Date: Provides information about the invoice's status in your system as at the ledger date - showing whether it was present, posted later, already paid, scheduled for payment, unposted, reversed or not found at all.

3. Amount Check: Whether the invoice amount matches between your system and the statement

4. Date Check: Whether the invoice date matches between your system and the statement

Based on these criteria combinations, we automatically produce a Status (what we found) and an Assign Action (what you can do about it) for each line in the reconciliation.


As a reminder, these are the following Statuses and Assign Actions we can assign to your invoice:

Status:

  1. Match

  2. Missing

  3. Not open on Ledger

  4. Not on Statement

  5. Amounts don’t match

  6. Invoice dates don’t match

  7. Unposted only

Assign Actions:

  1. Investigate

  2. Request copy

  3. Unposted

  4. Completed

  5. Paid

To learn more about the Action panel in Xelix, check Reconciliation results page: Ledger, Statement and Action panels


4. Assign Actions

4.1 Resolved

No action required: paid & completed

💡Note: We distinguish between “Paid” and “Completed” actions for your clarity - an item with a payment date is marked as “Paid” when it was paid before, subsequently posted or payment scheduled. “Completed” is a clean match, regardless of the payment status.


5. Pending

5.1. Investigation required

What happens when an invoice is in your system but not on statement?

We classify it within your ledger if it satisfies the following conditions:

  • Vendor

  • Division

  • Currency

  • Open / paid after the ledger date

  • Posted date before the ledger date

5.2. Action required


Check our guide on How to set Matching Tolerance to define an acceptable amount difference between your invoices and statements.

Did this answer your question?