# GRNI Accrual Schedule Worksheet (Goods Received Not Invoiced)

> Source: https://netray.co/tools/grni-accrual-schedule-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Schedule goods received but not invoiced, value each line and support the month end GRNI accrual with an auditable listing.

## Category

cost-finance

## Audience

- Controller
- AP manager
- Accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### PO / line

**Key:** po

**Type:** text

#### Vendor

**Key:** vendor

**Type:** text

#### Receipt date

**Key:** received

**Type:** date

#### Qty received

**Key:** qty_received

**Type:** number

#### Qty invoiced

**Key:** qty_invoiced

**Type:** number

#### PO unit cost

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Uninvoiced qty

**Key:** open_qty

**Type:** number

**Expr:** max(qty_received - qty_invoiced, 0)

#### Accrual value

**Key:** accrual

**Type:** number

**Expr:** max(qty_received - qty_invoiced, 0) * unit_cost

**Format:** currency

#### Age bucket

**Key:** age

**Type:** select

**Options:**

- 0-30 days
- 31-60 days
- 61-90 days
- Over 90 days

#### Action

**Key:** action

**Type:** select

**Options:**

- Accrue
- Chase invoice
- Investigate
- Reverse

**Rows:**

**Po:** PO-10482 / 1

**Vendor:** Alpine Fasteners

**Received:** 2026-09-26

**Qty received:** 5000

**Qty invoiced:** 0

**Unit cost:** 0.18

**Age:** 0-30 days

**Action:** Accrue

**Po:** PO-10455 / 3

**Vendor:** Northern Steel Supply

**Received:** 2026-09-12

**Qty received:** 120

**Qty invoiced:** 80

**Unit cost:** 46.5

**Age:** 0-30 days

**Action:** Chase invoice

**Po:** PO-10311 / 2

**Vendor:** Precision Castings

**Received:** 2026-07-30

**Qty received:** 40

**Qty invoiced:** 0

**Unit cost:** 212

**Age:** 31-60 days

**Action:** Investigate

**Po:** PO-10104 / 1

**Vendor:** Delta Packaging

**Received:** 2026-06-18

**Qty received:** 800

**Qty invoiced:** 0

**Unit cost:** 1.35

**Age:** Over 90 days

**Action:** Investigate

**Po:** PO-10497 / 2

**Vendor:** Harbor Electronics

**Received:** 2026-09-29

**Qty received:** 250

**Qty invoiced:** 100

**Unit cost:** 7.8

**Age:** 0-30 days

**Action:** Accrue

**Totals:**

#### Total GRNI accrual

**Key:** accrual

**Agg:** sum

**Format:** currency

#### Total uninvoiced quantity

**Key:** open_qty

**Agg:** sum

**Format:** number

#### Lines listed

**Key:** po

**Agg:** count

**Format:** integer

**Summary:**

#### Average accrual per line

**Key:** avg_line

**Expr:** sum_accrual / count

**Format:** currency

**Primary:** true

**Notes:** Value each line at the PO price, not the expected invoice price, unless your policy says otherwise. Reconcile the total to the GRNI or received-not-invoiced account in the general ledger and reverse the accrual on day one of the next period.

## Content

**Intro:** Goods received not invoiced, or GRNI, is the liability for stock that has arrived but whose vendor invoice is not yet in accounts payable. This worksheet lists the open receipts, values the uninvoiced quantity and gives you a schedule that ties to the ledger at month end.

**Sections:**

#### How to use the worksheet

**Body:** Export open receipts from your ERP: PO and line, vendor, receipt date, quantity received and quantity invoiced to date. Paste or type them into the rows. The sheet calculates the uninvoiced quantity and the accrual value at PO unit cost. Use the age bucket and action columns to drive follow-up with buyers and AP. Export to Excel for the month end close binder and attach it to the accrual journal.

#### The accounting behind it

**Body:** When stock is received, the receipt typically debits inventory or expense and credits a GRNI clearing account. When the vendor invoice posts, the clearing account is relieved and the payable is set up. Anything left in the clearing account at period end is the GRNI balance. The accrual value for a line is uninvoiced quantity times the PO unit cost. Negative differences, where more was invoiced than received, are excluded here and belong in a separate review.

#### Reading the schedule

**Body:** A healthy GRNI balance is mostly recent receipts. Lines older than 60 or 90 days usually mean a missing invoice, a price dispute, a duplicate receipt or a receipt posted to the wrong PO. Each of those needs a different fix, so give every aged line an owner. Large unexplained balances are an audit finding in many companies, so clearing the oldest items first is the cheapest way to shrink the risk.

#### Common mistakes

**Body:** Teams often accrue at the invoice estimate instead of the PO price without noting it, forget to reverse last month's accrual, or leave service receipts in the list after the service period ended. Another frequent issue is partial invoicing across periods, which creates quantity differences that look like errors. Keep the quantity invoiced column current and reconcile to the ledger balance every month.

**Cta:** If building the GRNI listing means a manual export every close, Netray can help automate the extraction and ageing from your ERP receipt and invoice tables.

**Faq:**

#### What does GRNI mean?

**Answer:** GRNI stands for goods received not invoiced. It is the value of stock or services received for which the supplier invoice has not yet been recorded. It is a liability the company owes, so it is accrued at period end to match cost to the period of receipt.

#### How do I value a GRNI accrual?

**Answer:** Multiply the uninvoiced received quantity by the purchase order unit cost, adding any known freight or duty if your policy capitalises it. If the final invoice price is known to differ, document the adjustment. Avoid estimating from memory.

#### Should GRNI be reversed next month?

**Answer:** Yes in most accrual designs. Reverse the manual accrual journal on the first day of the next period so the real invoice posting does not double count. System generated GRNI balances clear when the invoice is matched.

#### What causes old GRNI balances?

**Answer:** Typical causes are missing vendor invoices, price or quantity disputes, receipts against the wrong PO, duplicate receipts and returned goods not credited. Age the list and assign an owner to each line so the oldest items are resolved first.

## Search terms

grni accrual worksheet, goods received not invoiced excel, grni schedule template, month end accrual receipts not invoiced, grni reconciliation, uninvoiced receipts accrual, grni report excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json