A growing GRNI balance usually isn't a pile of missing invoices. It's a pile of receipts nobody tidied up.
Goods received not invoiced (GRNI) is the liability for goods or services you have received but not yet been invoiced for. Accrue it at month end so expenses land in the right period. Review it every month by age: chase genuine missing invoices, and correct or close receipts that were duplicated, over-received or matched to the wrong PO.
When goods arrive, the cost belongs to that period even if the invoice comes later. Most purchasing systems post a receipt to a GRNI (or "received not invoiced") liability automatically. When the invoice arrives and matches, the liability is cleared and moves to trade payables.
Each of these leaves a line in GRNI that no invoice will ever clear. Left alone, the balance overstates both costs and liabilities.
With receipt date in column D and the month-end date in a cell named MonthEnd:
=MonthEnd-D2
then bucket it:
=IF(E2<=30,"0-30",IF(E2<=60,"31-60",IF(E2<=90,"61-90","90+")))
A pivot table by supplier and bucket shows where the old lines sit. Usually a handful of suppliers account for most of the problem.
If your system posts GRNI automatically, the accrual is already there; your job is to make sure it is accurate. If it doesn't, accrue for significant receipts manually and reverse the accrual in the next period. See accruals and prepayments at month end for the wider routine.
Releasing old GRNI to profit is a judgement, not a tidy-up. Document why each line will never be invoiced, get approval from the controller, and keep the evidence for the auditors.
Accounts payable runs the report, but most fixes sit with purchasing and the receiving teams. Agree in writing who corrects receipts, who closes purchase orders and who approves releases, so the monthly review ends with actions rather than a list.
UK teams often call this "goods received not invoiced" or a GRN accrual. US teams may call it "received not invoiced" or an unvouchered liability. The routine is the same.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
Yes. It represents goods or services you have received and will have to pay for, so it is a current liability until the invoice arrives.
Usually because receipts are never corrected when they are duplicated, over-received or matched to the wrong order. The fix is a monthly ageing review, not just chasing invoices.
Only after investigating each line and getting approval. Some lines are genuine liabilities that a supplier will invoice later.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.