Exception reporting for SyteLine invoices

Executive Summary

SyteLine ships with invoice matching tolerances and an AP exception queue built around the purchase order. That queue answers one question well: does the invoice match the PO, the receipt, and the price on file. It does not answer whether the price on file is still the contracted price, whether a volume tier should have triggered a lower rate, or whether a surcharge should have expired last quarter.

The mechanism causing this is structural, not a configuration gap. Three-way matching in SyteLine compares three internal records against each other. A rate card violation, a stale surcharge, or an unclaimed rebate lives in a document the ERP never ingests. No amount of tolerance tuning inside SyteLine surfaces a condition the system was never given.

What changes this is treating SyteLine's exception report as the first filter, not the last one. It clears the invoices that fail an internal match. Everything that passes still needs to be checked against the contract itself, either manually on a schedule or through a diagnostic that reads both the invoice history and the contract terms together.

1. What does SyteLine actually flag as an invoice exception?

SyteLine's invoice matching flags three kinds of exception: a price variance against the item or vendor price record, a quantity variance against the receipt, and a missing or incomplete PO reference. Each is measured against tolerances set in AP parameters. The report that surfaces these lives in the invoice matching and voucher approval workflow, and it is accurate for what it checks.

It does not check the price record itself against a signed contract, because SyteLine has no field for.

The price variance check compares the invoice unit price to whatever price is stored on the purchase order or the item record. If that stored price was never updated after a rate change, the invoice can match perfectly and still be wrong.

The quantity check compares invoice quantity to receipt quantity, which catches billing for goods never received. It says nothing about a contract labor invoice billed by the hour against a not-to-exceed cap, because SyteLine has no cap field to compare against.

The PO reference check flags invoices with no matching purchase order at all, common on service categories like freight, maintenance, and professional services where a blanket PO or no PO is normal practice. These invoices often route around exception reporting entirely and go straight to manual approval, which is exactly where a rate schedule violation or a rebate gap has the most room to sit unnoticed.

2. How do you build a usable exception report inside SyteLine?

A usable report starts from the AP invoice matching table, joined to the vendor and item price history, and filtered to variances above a set dollar or percentage threshold rather than every micro-variance the tolerance engine logs. Group by vendor and category so a pattern across many small invoices becomes visible, since a single invoice rarely shows a rate card problem on its own. Export on a fixed schedule, weekly or per AP cycle, so review happens before payment rather.

Start with the invoice matching exception table and join it to vendor price history rather than reading the live price field alone. That join shows when a price changed and whether the invoice predates or postdates the change, which the raw exception flag does not distinguish.

Set the threshold above SyteLine's default tolerance. Default tolerances are usually set to catch data entry errors, a few cents or a few percent. A rate card violation can sit comfortably inside that tolerance and never trigger a flag at all.

Group the output by vendor and by category rather than reviewing invoice by invoice. A small overcharge on one freight invoice looks like rounding. The same overcharge repeated across many invoices from the same carrier is a stale rate table, and grouping is the only way that pattern surfaces inside a report built from one invoice at a time.

3. What kinds of drift never reach a SyteLine exception report?

Two categories of contract terms sit structurally outside SyteLine's exception logic: tiered pricing that depends on cumulative volume, and time-bound conditions like surcharge expirations or rebate accrual periods. Both require reading a contract clause and comparing it against invoice history over a period longer than one transaction. SyteLine's matching engine compares one invoice to one PO and one receipt at a single point in time, so neither condition has anywhere to be tested inside the ERP itself.

These two gaps are not a defect in SyteLine's design. The ERP was built to control procurement and receiving, not to store the negotiated terms of a service contract. Closing the gap means adding a source that does hold those terms, whether that is a maintained reference or a dedicated matching process, and checking invoices against it on the same cadence as payment review.

A. Rate card and volume tier checks

SyteLine stores a single price per vendor item, not a tiered schedule. If a contract sets a lower rate above a monthly volume threshold, the ERP has nowhere to hold that condition, so no report built from SyteLine data alone can test whether the tier was honored. That check has to happen against the contract document itself.

B. Surcharge and rebate conditions

A fuel surcharge with an expiration date, or a rebate that accrues against annual spend, are conditions written into contract language rather than transaction data. SyteLine's exception engine has no field for either, so an invoice carrying an expired surcharge or an unclaimed rebate clears the system's matching logic without ever being tested against the clause that governs it.

4. Can a report or dashboard be configured to catch contract terms?

Not from invoice data alone. A report or IDO-based dashboard in SyteLine can be configured to show more fields, tighter thresholds, and better grouping, and all of that improves what the exception queue surfaces from transaction data. None of it gives the system a place to store a rate card, a volume tier, or a surcharge expiration date, so no configuration closes the gap between invoice matching and contract compliance.

The contract terms have to be tracked and compared somewhere.

SyteLine's Interactive Data Objects let you build a custom view joining AP transactions, vendor records, and item history into one report. That is worth doing: it surfaces variance patterns the standard exception screen buries across multiple tabs.

What it cannot do is add a data type SyteLine does not have. A volume tier trigger, an NTE cap, or a rebate accrual schedule are terms in a signed document, not transaction fields, and a custom IDO report still only reads transaction fields.

The practical split is: use SyteLine's reporting layer to clear the invoices that fail an internal match, cheaply and automatically. Track the contract-dependent conditions in a separate reference, whether that is a spreadsheet maintained by AP or a system built specifically to hold contract terms and compare them against invoice history.

5. Should AP maintain a manual contract reference alongside SyteLine?

A maintained reference, even a spreadsheet listing each vendor's rate card, volume tiers, and surcharge conditions, closes part of the gap SyteLine leaves open, and it is worth building if nothing else exists yet. Its limits are structural rather than a matter of effort: it goes stale as contracts renew, it depends on someone remembering to update it after every amendment, and checking many invoices against it by hand does not scale past a handful of vendors. It answers the.

Building the reference is a one-time project: pull every active service vendor contract and record the rate, the tier triggers, the surcharge conditions, and the NTE caps in one place AP can reference during invoice review.

Maintaining it is the harder part. A contract that renews with a new rate, or amends a surcharge clause mid-term, only stays accurate in the reference if someone updates it the same week the amendment is signed. In practice that update often lags, and the reference drifts from the document it is supposed to represent.

This is general information, not legal advice. Whether a given surcharge or rebate clause is enforceable as written depends on the contract's own terms, and AP should confirm interpretation with whoever holds contracting authority before treating a reference sheet as the final word.

6. When does this gap justify a diagnostic instead of a better report?

A better SyteLine report is worth building regardless. A diagnostic becomes the more efficient path once the manual contract reference covers enough vendors and enough invoice volume that keeping it current, and checking every invoice against it, is consuming more AP hours than the exceptions it catches are worth. At that point the work is not a reporting problem inside SyteLine anymore.

It is a matching problem between two documents SyteLine was never built to compare.

The Margin Drift Diagnostic runs invoice-to-contract matching directly, reading rate cards, volume tiers, rebate clauses, and surcharge schedules against invoice history rather than against SyteLine's internal price fields. It is a fixed-scope engagement, not a change to how SyteLine is configured, and it delivers a prioritized roadmap in 2 to 4 weeks, across ValueXPA diagnostics.

The output does not replace SyteLine's exception report. It runs alongside it, covering exactly the contract-dependent conditions the ERP structurally cannot test, so the two together cover both the transaction-level and contract-level checks a single system cannot do alone.

For the wider pattern this sits inside, start with the margin drift guide. See also the six categories drift hides in and what is margin erosion? causes and prevention for manufacturers.

7. Frequently Asked Questions (People Also Ask)

Does SyteLine support three-way matching out of the box?

Yes. SyteLine's standard AP module matches the invoice against the purchase order and the receipt, flagging variances in price and quantity based on configured tolerances. This runs without customization and is the baseline exception check most SyteLine implementations already rely on.

Can SyteLine tolerances be set to catch small rate discrepancies?

Tolerances can be tightened to a smaller dollar or percentage variance, which surfaces more invoices for review. Tightening tolerances increases the volume of flagged invoices without adding the ability to check a rate against a contracted rate card, since the comparison is still against the internal price field.

Why does a blanket PO invoice skip exception reporting in SyteLine?

Service categories like freight, maintenance, and professional services are often billed against a blanket PO or no PO at all, since a fixed quantity isn't known in advance. These invoices frequently route to manual approval rather than the automated exception queue, which is why they carry higher unreviewed risk.

Is Interactive Data Objects (IDO) reporting the same as exception reporting?

No. IDOs are SyteLine's tool for building custom queries and views across any data the system stores. They can build a better exception report by joining more tables, but they only surface data SyteLine already has. Contract terms stored outside the ERP are not reachable through an IDO.

Can a rebate clause be tracked as a SyteLine exception?

Not directly. A rebate clause accrues against cumulative spend over a period defined in the contract, and SyteLine has no field representing that accrual. Tracking it requires a reference outside the ERP or a process that compares invoice history against the contract on a schedule.

How often should an AP team review exceptions in SyteLine?

Reviewing before each payment run, rather than after invoices are already paid, is what makes exception review useful for prevention rather than after-the-fact recovery. The exact cadence should match the AP cycle already in place.

Does tightening SyteLine's matching tolerances eliminate margin drift?

It reduces the invoices that pass matching with a large, obvious variance. It does not reach drift that lives in contract terms SyteLine never stores, such as a volume tier trigger or a surcharge expiration, regardless of how tight the tolerance is set.

What is the fastest way to know whether SyteLine's exception report is missing something?

Pull a sample of paid invoices from a service vendor category, list the contract terms that govern that vendor, and check the invoices against the contract by hand. Any variance that passed SyteLine's matching cleanly but fails against the contract shows the size of the gap for that vendor.