GR/IR Clearing Run

GR/IR Clearing Run

With this Blog Post, I would like to cover the topic GR/IR Clearing run and different scenarios relating the GR/IR Clearing Run.

Agenda :

1. Introduction and purpose
2. Posting Logic
3. Account Determination
4. Final Clearing date for purchasing document
5. Different Business Scenarios
6. References

1. Introduction and Purpose :

The main Purpose is to clear the clearing accounts or the Offset accounts affected during the Goods receipt posting and invoice posting (Procurement process).

GR/IR is used in two broad cases.  One where the Invoice is paid but the goods are yet to be delivered and the other where goods are already delivered but the invoice is yet to be paid.

Clearing or the offset accounts here are Purchase in transit GL account and Unbilled Payable GL account.

If the Invoice is paid and Goods are yet to be delivered the amount is debited in the Purchase in Transit account.

Secondly if the Goods are delivered and the Invoice is yet to come then the amount is credited in the Unbilled Payable Account.

This Offset GL accounts also helps in keeping the track of the goods which are not delivered and goods for which invoices are not yet received.

We perform a GR/IR run in order to nullify both these offset accounts i.e. Credit the Purchase in Transit account and Debit the Unbilled Payable account.

Ideally the Offset accounts should account to zero at the end of the year signifying that all the goods have been received and all the corresponding invoices have been paid.

2. Posting Logic :

Goods receipt:

Debit Material, Credit Unbilled Payable EUR 500 (10 ea.)

Invoice receipt:

Debit Purchase in Transit, Credit Payable EUR 500 (10 ea.)

 

GR/IR clearing Run:

Debit Unbilled Payable EUR 500 (10 ea.)

Credit Purchase in Transit EUR 500 (10 ea.)

In summary, Above Postings can be seen in the below table

3. Account Determination :

Business configuration activity : Charts of Accounts, Financial Reporting Structures, Account Determination

Material GL account maintained under Inventory Sub ledger -> Inventory tab -> Material Inventory Column

Payable GL account maintained under Account Payable Sub ledger -> Payable tab -> Payable Column

Unbilled Payable accounts maintained under Account payable sub ledger -> in transit tab -> unbilled payable column

Purchase in transit accounts maintained under Account payable sub ledger -> in transit tab -> in transit column

Paths for other GL accounts like Cash discount, Price difference etc, are mentioned in the scenarios below.

4. Final Clearing Date for Purchasing Document Items:

Purchasing document items that are fully delivered and fully invoiced are normally marked for final clearing automatically Marked items are cleared by the next GR/IR clearing run that is executed for the period in which Marked Final Clearing Date is set.

There can be situations where it is required to clear the offset accounts even if goods are not delivered or invoices are not generated. In such situations, User hast to Option to either manually finish the delivery/Invoice or Manually mark final clearing date for the purchase order/Purchase order item.

If final clearing date is maintained on the purchase document/purchase document item, GR/IR run process the purchase order and clears the clearing accounts completely even if the goods receipt and invoice receipt quantities do not match.

Note: If the Purchase order/Purchase order item is finished, system always takes the date when Purchase order was finished as final clearing date.

5. Different Business Scenarios:

Following postings are based on the following information :

Process type : To-stock

Perpetual Cost method for material : moving Average

With Different Process type (Non-stock) and/or Perpetual cost method (Standard), postings will vary.

Purchase order Details –

Material X : 10 USD / 1 Ea

Purchase order Quantity : 10 ea.

Scenario 1: A Goods Reciept and an Invoice of equal amounts are made and GR/IR run is executed.

Goods reciept quantity : 10 Ea

Invoice : 100 USD /10 Ea

Final Clearing date is set automatically by system based on the last transaction date.

 

Scenario 2: A Goods Reciept is made and an invoice of different amount (due to purchase price difference) is made and GR/IR run is executed.

Goods Receipt quantity : 10 Ea

Invoice : 110 USD /10 Ea

Exception of type Price variance appears during the supplier invoice postings.

 

Final Clearing date is set automatically by system based on the last transaction date.

G/L for Purchase price difference : Inventory Sub ledger -> Difference tab -> Gain from purchase price difference / Loss from purchase price

 

Scenario 3: A GSR is made and an Invoice is paid with cash discount and GR/IR run is executed.

Goods Receipt quantity : 10 Ea

Invoice : 100 USD / 10 Ea

Payment  : 87 USD

 

Final Clearing date is set automatically by system based on the last transaction date.

G/L for Discount : Account Payable Sub ledger -> Payment Difference tab

 

Scenario 4: Only a Goods Receipt is made and no Invoice is made for the Purchase order and the GR/IR run is executed.

Goods Receipt quantity : 10 Ea

 

In order to process the Purchase document in the run and to clear the offset accounts, Final clearing date has to be maintained manually.

G/L for Purchase Valuation difference : Inventory Sub ledger -> Difference tab -> Gain from purchase valuation difference/Loss from Purchase valuation difference

 

Scenario 5: Only an Invoice is made and no Goods Receipt is made for the Purchase Order and GR/IR run is executed.

Invoice : 100 USD / 10 Ea

Exception of type Missing Receipt or Return Document appears during the supplier invoice postings.

 

In order to process the Purchase document in the run and to clear the offset accounts, Final clearing date has to be maintained manually.

G/L for Purchase Valuation difference : Inventory Sub ledger -> Difference tab -> Gain from purchase valuation difference/Loss from Purchase valuation difference

 

 

6. Reference :

Help Center :

GR/IR Clearing Runs

GR/IR Clearing Quick Guide

Marked Final Clearing date for purchasing document items

GR/IR Clearing Run – Standard Case (Without Differences)

GR/IR Clearing Run – Partial Invoice and Completion of Purchase Order Item

GR/IR Clearing Run – Price Differences with Moving Average Cost Method

Price Differences, Exchange Rate Differences, and Cash Discounts

GR/IR Clearing Run – Credit Memo

GR/IR Clearing Run – Invoice Receipt Before Goods Receipt

Purchasing Document Items Quick Guide

GR/IR Inventories – Balance Summary

Report :

GR/IR Inventories – Balance Summary

Purchase Price Variances

Purchasing Documents – Line Items

I hope this will help in understanding the GR/IR Clearing runs.

Cheers,

Harshal Vakil