Review supplier-invoice differences before payment. Request a free first-invoice audit →
LineQuery›Guides

Free browser tool

Free Supplier Invoice Discrepancy Calculator for Shopify Retailers

Enter one purchase-order line, the optional received quantity, and the supplier-invoice values. The calculator separates quantity, unit-price, tax, missing-evidence, and uncertain-match questions so a person can decide what to investigate.

Check one invoice line before payment

Use the invented values already loaded, or replace them with a line from your own records. A receiving quantity is optional; when it is missing, the result stays provisional rather than treating “not provided” as zero.

Invented example loaded

Enter one invoice line

Entered values stay in this browser session and are not sent or stored. Anonymous first-party page and CTA events may still be counted.

Review result

1 item to inspect

+$96.00
Comparison total$432.00Uses received quantity
Invoice total$528.00Using entered invoice values
  • Unit price differs by $4.00 ($22.00 invoiced vs. $18.00 on the PO).
Review only. This result does not approve payment, contact a supplier, or change Shopify inventory.

How the comparison works

  1. The quantity check compares the invoice with received quantity when provided; otherwise it uses ordered quantity and marks the missing evidence.
  2. The unit-price check compares the invoice price with the PO price.
  3. The tax check calculates tax using the entered rates and each side’s line total.
  4. The total difference includes the entered quantity, price, and tax values.
  5. An uncertain match remains a separate human-review item even when the arithmetic agrees.

Shipping, fees, credits, discounts, currency conversion, and rounding are outside this one-line calculator. Use the full reconciliation worksheet to retain a broader review trail.

Illustrative exampleOne line, three records, one review decision
Purchase order · line 424 × $18.00Agreed quantity and unit price
Receiving record · line 424 acceptedPhysical receipt recorded
Supplier invoice · line 424 × $22.00Unit price is $4.00 higher
Invented business details show how a reviewer can trace a unit-price discrepancy to the supporting source lines. LineQuery flags the difference; a person decides what happens next.

Frequently asked questions

What does the invoice discrepancy calculator check?+

It compares one invoice line with the entered PO and optional receiving values. It highlights quantity, unit-price, calculated tax, missing receiving evidence, and uncertain line matches.

Are the numbers I enter stored?+

No. The entered values remain in the browser session and are not sent to LineQuery. The site may count anonymous first-party page visits and named CTA clicks, but calculator values are not included.

Does a zero difference mean the invoice is approved?+

No. It only means the entered arithmetic agrees. A reviewer should still confirm document identity, duplicates, fees, credits, rounding, and source evidence.

Does the calculator connect to Shopify or change inventory?+

No. It is a browser-only review aid. It does not connect to Shopify, approve or pay invoices, contact suppliers, or change purchase orders, receipts, or inventory.