Skip to Content
Technical Articles

Netting/Offsetting of Payables and Receivables

Netting/Offsetting of Payables and Receivables

 

Introduction – Netting is the process of offsetting Payables with Receivables to partially or completely clear the open items for same Supplier & Customer.

In an organization receivables and Payables transactions occur between the organization and the business partners. Such receivables and Payables items are posted to the respective customer or supplier account. All the receivables and Payables pertaining to a customer account is processed in customer account monitor and similarly the due/open items pertaining to a supplier account is processed in the supplier account monitor.

Netting business option enables you to club these receivables and Payables to clear all open items.

 

Prerequisites:

You have selected netting functionality in your Business Configuration. To find this option,

  1. Go to Business Configuration WoC –> Implementation Projects view –> select Implementation project –>click Edit Project Scope
  2. In the Questions step –> select Payment Clearing in Payables and Receivables Processing under Cash Flow Management. Check the statement related to Netting of Payables and Receivables.

You have maintained netting relationships between two business partners. You can do so in the customer and supplier master data.

Netting of Payables & Receivables.png

 

Process Flow:

 

1.     Go to Business Partner Data WoC –> select Business Partner view –> find Supplier (AMS Pvt Ltd).

/wp-content/uploads/2016/06/1_973166.png.

 

2.      Click on Create As button & select Account to create the Supplier as Customer.

/wp-content/uploads/2016/06/2_973167.png.

 

3.      Supplier (AMS Pvt Ltd) is now created as a Customer.

/wp-content/uploads/2016/06/3_973168.png.

 

4.     Goto Receivables WoC –> Customer Account –> check the Trade Receivables.

/wp-content/uploads/2016/06/4_973208.png.

 

5.    Also, go to Payables WoC –> Supplier Account –> check the Trade Payables.

/wp-content/uploads/2016/06/5_973209.png.

 

6.     Click on Clear Manually button on either Supplier or Customer account.

/wp-content/uploads/2016/06/6_973210.png.

 

7.      Here, you can see open documents for both Payables & Receivables.

8.      So here, you can choose the documents which you want to clear as I have shown in the below screenshot.

/wp-content/uploads/2016/06/7_973211.png

 

9.    You can see the cleared documents in the below screenshot.

/wp-content/uploads/2016/06/8_973212.png.

 

10.     Have a look on the Journal Entries for this posting:

/wp-content/uploads/2016/06/9_973213.png

 

Conclusion: If you have same Supplier & Customer then you can clear the open items for Payables & Receivables partially or completely via this process flow.

If you have any issues, you can ask in comments.

 

 

9 Comments
You must be Logged on to comment or reply to a post.
  • I agree, it is a very well put together document. I have been able to get all of the prerequisites completed. How are you able to create a partial clearing if the payable and receivable invoice amounts are not the same? Is this only possible by applying a discount or credit?

    If I can’t clear the entire receivable amount I would like it to be a partial clearing.

    • Hi Joe Sayers,

      Thanks a lot.

      Que. How are you able to create a partial clearing if the payable and receivable invoice amounts are not the same?

      Ans. You can do the partial clearing if the payable and receivable invoice amounts are not the same.

      1. You can see Point 4 in which we have Customer having an Invoice of 5000 USD.
      2. As shown in Point 5, you open the Supplier and click on Clear Manually as shown in Point 6. Here, you can see open documents for both Payables & Receivables.
      3. For the next step as shown in Point 8. You can choose the documents which you want to clear as I have shown in the below screenshot.

      Here we cleared Customer Invoice of 5000 USD with the Supplier Invoice of 45000 USD.

      .

      Let me know if your requirement is met or comment back for any further queries.

      Regards,
      Anant Patel,

      SME, SAP ByDesign
      anant3113@gmail.com

       

      • Anant,

         

        Thank you so much! I was able to change the amount in the “applied net amount” field in Point 8 to achieve the correct application.

         

        Thanks again.

         

        Joe Sayers