# SAP GR/IR Clearing Account Reconciliation Worksheet

> Source: https://netray.co/tools/sap-gr-ir-clearing-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable worksheet that computes the GR/IR balance per purchase order line from receipts and invoices, with ageing for month end clearing.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- Accounts payable accountant
- SAP FI MM consultant
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### PO number

**Key:** po

**Type:** text

#### Item

**Key:** item

**Type:** text

#### Material

**Key:** material

**Type:** text

#### Net price per unit

**Key:** price

**Type:** number

**Format:** currency

#### GR quantity

**Key:** gr_qty

**Type:** number

#### IR quantity

**Key:** ir_qty

**Type:** number

#### GR value

**Key:** gr_val

**Type:** number

**Expr:** gr_qty * price

**Format:** currency

#### IR value

**Key:** ir_val

**Type:** number

**Expr:** ir_qty * price

**Format:** currency

#### GR/IR balance

**Key:** bal

**Type:** number

**Expr:** gr_qty * price - ir_qty * price

**Format:** currency

**Help:** Positive: received not invoiced. Negative: invoiced not received.

#### Age of oldest open item (days)

**Key:** age

**Type:** number

#### Action

**Key:** action

**Type:** select

**Options:**

- Wait for invoice
- Chase vendor invoice
- Chase goods receipt
- Post missing GR
- Write off in MR11
- Under review

**Rows:**

**Po:** 4500012301

**Item:** 10

**Material:** FAST-0412

**Price:** 0.42

**Gr qty:** 5000

**Ir qty:** 5000

**Age:** 0

**Action:** Under review

**Po:** 4500012377

**Item:** 20

**Material:** HSG-8820

**Price:** 18.5

**Gr qty:** 240

**Ir qty:** 200

**Age:** 41

**Action:** Chase vendor invoice

**Po:** 4500012410

**Item:** 10

**Material:** CBL-1150

**Price:** 6.8

**Gr qty:** 300

**Ir qty:** 320

**Age:** 66

**Action:** Chase goods receipt

**Po:** 4500012544

**Item:** 30

**Material:** SEAL-0071

**Price:** 2.15

**Gr qty:** 1000

**Ir qty:** 0

**Age:** 125

**Action:** Chase vendor invoice

**Po:** 4500012601

**Item:** 10

**Material:** BRG-6204

**Price:** 7.9

**Gr qty:** 150

**Ir qty:** 149

**Age:** 210

**Action:** Write off in MR11

**Po:** 4500012688

**Item:** 10

**Material:** PLT-3300

**Price:** 112

**Gr qty:** 0

**Ir qty:** 12

**Age:** 18

**Action:** Post missing GR

**Totals:**

#### Total received value

**Key:** gr_val

**Agg:** sum

**Format:** currency

#### Total invoiced value

**Key:** ir_val

**Agg:** sum

**Format:** currency

#### Net GR/IR balance

**Key:** bal

**Agg:** sum

**Format:** currency

**Summary:**

#### Net balance as percent of received value

**Key:** open_pct

**Expr:** sum_bal / sum_gr_val * 100

**Format:** percent

**Description:** Share of receipts not yet matched by an invoice.

#### Average age of open lines

**Key:** avg_age

**Expr:** avg_age

**Format:** days

#### Oldest open line

**Key:** oldest

**Expr:** max_age

**Format:** days

**Notes:** Fill quantities from ME2N or MB5S for the lines with a balance. Items older than your clearing policy, often 90 to 180 days, are candidates for review and write off with MR11. Do not write off without confirming with purchasing and AP.

## Content

**Intro:** The GR/IR clearing account holds the value of goods received but not yet invoiced, and invoices booked before goods arrive. A healthy balance is small and young. This worksheet turns a list of PO lines into a clear picture of what is open, how old it is and what to do next.

**Sections:**

#### How to use the worksheet

**Body:** Pull the open items from MB5S (GR/IR analysis) or from ME2N with the selection for open invoices, and enter one row per PO line with received quantity, invoiced quantity and net price. The sheet calculates the value on each side and the balance. Set the age in days from the oldest open document, then choose an action. Export to Excel and share with purchasing and accounts payable for the month end meeting.

#### How the GR/IR account works

**Body:** At goods receipt SAP debits stock or a consumption account and credits GR/IR at the PO price. At invoice receipt it debits GR/IR and credits the vendor. If both happen at the same quantity and price, the account nets to zero for that line. A positive balance in this worksheet is a receipt without invoice, which is an accrual in effect. A negative balance means the invoice arrived first, or the receipt is missing and needs to be posted.

**Bullets:**

- Price differences go to a price difference or purchase price variance account, not GR/IR
- Delivery completed or final invoice flags change how MR11 treats the remainder
- Foreign currency lines carry exchange rate effects that net to zero only at the same rate

#### Worked example

**Body:** Line 4500012544, 1000 seals at 2.15, has been received for 125 days with no invoice. The worksheet shows a balance of 2,150 and flags the oldest age. The first action is to ask the vendor for the invoice or confirm the order was cancelled. If the invoice never arrives and purchasing agrees, MR11 can clear the amount to a gain or expense account according to your policy. Transaction MR11SHOW lists documents posted by MR11 for audit trail.

#### Common mistakes

**Body:** Writing off old balances without checking for open invoices parked in MIR4 produces duplicates later. Mixing receipt reversals with real open items inflates the list. Clearing at month end by manual journal on the GR/IR account breaks the link to PO history, so reports show open items that finance already cleared. Use MR11, or the automatic clearing program F.13, so the PO history stays correct.

**Cta:** If your GR/IR list is long every month end, we can build a read-only report on your SAP data that flags the lines by age and likely cause, without changing any postings.

**Faq:**

#### What does a positive GR/IR balance mean?

**Answer:** Goods were received and valued, but the vendor invoice has not been posted. The company owes the vendor, and the GR/IR credit stands in for that liability until the invoice arrives. It is normal for recent deliveries, a problem when lines are old.

#### What is the difference between MR11 and F.13 for GR/IR?

**Answer:** MR11 maintains and clears GR/IR balances by PO line, including write off, and updates the PO history. F.13 is automatic clearing of open items in the GR/IR account when a PO line nets to zero. Use F.13 routinely and MR11 for exceptions.

#### Which SAP transaction shows GR/IR open items?

**Answer:** MB5S shows the GR/IR balance by PO, MR11SHOW shows documents created by MR11, and ME2N with the right selection shows open invoice lines. In S/4HANA you can also open the G/L account line item display for the GR/IR account, usually with the open item filter.

#### How old should GR/IR items get before action?

**Answer:** There is no SAP rule. Many companies review at 60 to 90 days and write off after 180 days to a year with documented approval. Your policy and local audit expectations decide. Use the age column to set your own thresholds.

## Search terms

sap gr/ir clearing, sap gr ir reconciliation excel, sap mr11 gr/ir account maintenance, sap mb5s gr/ir analysis, gr/ir account balance explained, gr/ir clearing month end sap, sap f.13 gr/ir clearing, gr ir write off sap

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