GRN vs Billing Reconciliation Report

Match Rate

92.3%

1,152 of 1,247 GRNs matched

Documents Processed

2,559

1,247 GRNs · 1,312 Invoices

Open Exceptions

8 critical · 14 high · 25 medium

Variance Exposure

$91.4K

Total unresolved variance value

Supplier	GRN Ref	Invoice Ref	GRN Amt	Invoice Amt	Variance	Exception	Priority	Days Open
Summit Engineering	GRN-2026-04801	INV-SEG-1198	$67,500	$74,250	+$6,750	Price Variance	Critical	27
Pacific Metals Inc	—	INV-PMI-2218	—	$42,100	+$42,100	Missing GRN	Critical	22
Northern Supply Chain	GRN-2026-04790	INV-NSC-7782	$9,800	$11,340	+$1,540	Price Variance	Critical	18
Atlas Freight Services	GRN-2026-04778	INV-AFS-3310/3311	$5,400	$10,800	+$5,400	Duplicate Invoice	High	14
Acme Industrial Ltd	GRN-2026-04821	INV-ACM-9934	$24,500	$26,750	+$2,250	Price Variance	High	12
TechComponents SA	GRN-2026-04903	—	$31,400	—	$31,400	Missing Invoice	High	7
Pinnacle Raw Materials	GRN-2026-04912	INV-PRM-8841	$7,250	$8,120	+$870	Price Variance	Medium	5
Meridian Chemicals	GRN-2026-04945	INV-MCH-6672	$22,000	$20,900	−$1,100	Qty Variance	Medium	3

Supplier

GRN Ref

Invoice Ref

GRN Amt

Invoice Amt

Variance

Exception

Priority

Days Open

Summit Engineering

GRN-2026-04801

INV-SEG-1198

$67,500

$74,250

+$6,750

Price Variance

Critical

Pacific Metals Inc

—

INV-PMI-2218

—

$42,100

+$42,100

Missing GRN

Critical

Northern Supply Chain

GRN-2026-04790

INV-NSC-7782

$9,800

$11,340

+$1,540

Price Variance

Critical

Atlas Freight Services

GRN-2026-04778

INV-AFS-3310/3311

$5,400

$10,800

+$5,400

Duplicate Invoice

High

Acme Industrial Ltd

GRN-2026-04821

INV-ACM-9934

$24,500

$26,750

+$2,250

Price Variance

High

TechComponents SA

GRN-2026-04903

—

$31,400

—

$31,400

Missing Invoice

High

Pinnacle Raw Materials

GRN-2026-04912

INV-PRM-8841

$7,250

$8,120

+$870

Price Variance

Medium

Meridian Chemicals

GRN-2026-04945

INV-MCH-6672

$22,000

$20,900

−$1,100

Qty Variance

Medium

Key Insights & Recommendations

Pacific Metals (Missing GRN, $42.1K): Invoice received with no corresponding goods receipt. Warehouse team should confirm whether goods were delivered and GRN was missed, or if this is an erroneous invoice.
Summit Engineering (Price Variance, $6.75K): Invoiced 10% above PO price on a 27-day-old exception. Procurement to verify whether a price amendment was agreed but not updated in the system.
Atlas Freight (Duplicate Invoice, $5.4K): Two invoices (3310 & 3311) submitted against a single GRN. Likely duplicate — AP team should confirm with supplier and reject one.
Overall match rate of 92.3% is within target (>90%), but the 8 critical/high items totalling $56.4K in variance exposure should be prioritised for resolution this week.

GRN vs Billing Reconciliation

Reconciliation Progress

Exceptions by Category

Weekly Exception Trend — February 2026

Variance by Supplier (Top 6)

Aging of Open Exceptions

Key Insights & Recommendations