The Goods Received Not Invoiced (GRNI) report is a fundamental accounting tool used to identify financial liabilities. It lists all order line items that have been physically or systematically received by your institution, but have not yet been matched to a supplier invoice.
Purpose of the Report
This report is primarily used by Finance and Accounts Payable teams for:
- Month-End Accruals: Estimating the value of goods/services received that must be recognized as an expense, even if the invoice hasn't arrived.
- Liability Tracking: Monitoring outstanding debts to suppliers.
- Audit Readiness: Providing proof of received goods to justify accrued expenses, during year-end audits.
- Sample report: Unimarket Goods Received Not Invoiced Example
Report Criteria and Logic
To ensure data accuracy, the report follows specific inclusion and exclusion rules:
-
Inclusions:
- Order line items created within the specified date range.
- Items where the receiving status is Completed or Closed.
-
Exclusions:
- Line items where receiving is still Open.
- Orders paid via Stripe (as these are handled through a separate payment flow).
- Orders that have been Closed or Canceled at the header level.
Best Practices for Accruals
- Reconcile Monthly: Run this report at the end of every fiscal period. To ensure your General Ledger accurately reflects your "unbilled" liabilities.
- Identify Missing Invoices: If an item has been "Received" for more than 30 days but remains on this report. It may indicate that the supplier has forgotten to send an invoice or the invoice is lost.
- Verify "Closed" Receiving: Sometimes users "Close" a receipt without actually receiving the goods to stop further actions. Review the "Receiving State" to ensure these aren't accidental accruals.
Note: Consistent monitoring of the GRNI report helps prevent "budget surprises" at the end of the year. By ensuring all received goods are accounted for financially.
Report Columns and Definitions
| Category | Column Name | Description |
| Supplier | Supplier Vendor ID | The unique identifier for the vendor in your ERP system. |
| Product | Product Code / Name | The specific item details from the Purchase Order. |
| Quantities | Quantity | The total quantity ordered. |
| Received Quantity | The quantity officially marked as "Received" by the user. | |
| Invoiced Quantity | Should be 0 or less than the Received Quantity for items on this report. | |
| Financials | Currency / Unit Price | The pricing details for the item. |
| Subtotal / Tax / Total | The financial breakdown of the received value. | |
| Accounting | Account Code | The GL code where the expense will be posted. |
| Distribution % / Amount | How the cost is split across different accounts (if applicable). | |
| Status | Receiving State | Confirms the state of the receipt (e.g., Completed or Closed). |