Skip to main content

Invoice Matching – Tolerances

Updated over a month ago
  • Overview.

  • Parameters.

Coins ERP+ uses tolerances to allow or disallow a match.

  • If the invoiced amount is less than or equal to the expected amount plus the tolerance, Coins ERP+ allows the match.

  • If the invoiced amount is greater than the expected amount plus the tolerance, Coins ERP+ disallows the match (does not allow you to accept the values) or warns you (asks if you want to accept the values).

Tolerances can be applied to each line, or to the invoice total.

There are a number of reasons why the invoice amount may be greater than expected. Some examples are listed below, but the means of dealing with them are the same.

  • Example 1: An order is raised for £1000.00 of materials. The supplier has invoiced you £1050.00 because they have added a delivery charge in error.

  • Example 2: The supplier raised their prices in-between the order being raised and the goods being delivered.

Your business will have defined an upper tolerance – either a value or % amount higher than the original order under which they will accept the payment of the invoice or beyond which approval must be sought before the system will allow payment.

Invoice Amount greater than Order Amount (Within Tolerance)

  1. Open the appropriate matching line and change the Invoice Price to that shown on the invoice or select the Override Value field and amend the Invoice Value.

  2. Save the line.

    Coins ERP+ displays a warning that the Invoice Amount is in excess of expected, but that it is within tolerance.

    Coins ERP+ automatically allocates a Hold Code indicating the within tolerance condition but this is for memorandum and reporting purposes only and does not physically place the invoice on hold.

    The Quantity Invoiced column updates. The Matched amount at the bottom of the screen should now be populated and the Difference should be zero.

  3. Click Next (Next Icon) to return to the batches listing screen.

Invoice Amount greater than Order Amount (Outside Tolerance)

  1. Open the appropriate matching line and change the Invoice Price to that shown on the invoice or select the Override Value field and amend the Invoice Value.

  2. Save the line.

    You will be prompted that the Invoice Amount is in excess of expected, and that it is not within tolerance.

    The Coins ERP+ system can be set to not allow entry of lines that exceed tolerances. If this is the case for your business, you will not be able to continue with the entry of this invoice.

    Coins ERP+ will automatically allocate a Hold Code indicating the outside tolerance condition and the invoice will be placed on hold.

The buyer will need to be consulted regarding the price difference and identify the reason for it. Possible scenarios are:

  1. The Purchase Order is correct and a Credit Note must be requested from the supplier.

  2. The Invoice is correct.

In order to pay the invoice, one of the following actions will need to be taken:

  1. Request a Credit note from the supplier and amend the Hold code on the invoice to indicate this is the case. Enter the credit note when received.

  2. Amend the order and take it off hold.

Did this answer your question?