Illustrating Accounts Receivable Regrouping

Objectives

After completing this lesson, you will be able to:

  • Group accounts receivable open items by due date using the Schedule General Ledger Jobs app
  • Reclassify credit customer balances using the Schedule General Ledger Jobs app
  • Regroup open items after reconciliation account change using the Schedule General Ledger Jobs app

Accounts Receivable Open Items by Due Date Regrouping

Introduction

To provide externals with a better overview of the company's liquidity situation, receivables must be grouped on the balance sheet according to their remaining life.

Business Scenario

Last week, Carla learned about reporting in a training session. During the course, someone from the Group Accounting department mentioned the Bike Company report receivables and payables based on their remaining terms on the balance sheet:

Receivables:

  • Less than one year
  • More than one year

Payables:

  • Less than one year
  • 1 – 5 years
  • More than five years

Carla knows from her daily work that only one reconciliation account can be assigned to a customer master record. This receivable reconciliation account is uniquely assigned to the balance sheet item Accounts receivable – Residual maturity less 1 year of statement version 1010. This version is used for the legal reporting of the Bike Company.

Carla remembers that some customers has got payment targets beyond one year. She wants to know how customer receivables will be accurately reported based on their remaining term.

Now it's Carla's turn to put this into practice. Let's see if she can regroup customer open items according to their remaining term. In this video, Carla creates a test scenario in the SAP sandbox system.

Select the Play button to learn how to regroup receivables in SAP using the Schedule General Ledger Jobs app. Follow step-by-step instructions to ensure accurate posting and reconciliation. Watch now!

Carla's Summary:

Use the Regroup Receivables/Payables template in the Schedule General Ledger Jobs app to organize your receivables (and payables) by remaining term. To use previous valuations (for example, foreign currency valuation or flat-rate individual value adjustment), select them in the Use Valuations field in the job template's parameter settings.

Regroup Accounts Receivable by Remaining Term

In this exercise, you will execute and analyze the regrouping of accounts receivable by remaining term.

Reclassify Accounts Receivable with Credit Balance

Introduction

To ensure the balance sheet is correct, list receivables and payables separately. Customers with a credit balance at the end of the period should be displayed on the liabilities side of the balance sheet.

Business Scenario

After her successful test, Carla met with her manager to discuss additional reclassification scenarios.

Select the Play button to learn how to handle customer accounts with a credit balances and make adjustment postings in this informative video. Understand the posting logic and account determination process for a smooth transaction.

Knowing how to reclassify a customer with a credit balance in the SAP System is crucial. To demonstrate this process, we will watch Carla testing this process. During the test, Carla will determine if customers with a credit balance can be reclassified successfully.

Select the Play button to learn how to reclassify customers with a credit balance and analyze correction postings. Discover the step-by-step process and key parameters involved.

Carla's Summary:

Transfer a customer's liability to the liabilities side of the balance sheet if they have a credit balance in their receivables account. Use the Regroup Receivables / Payables job template in the SAP Fiori app, Schedule General Ledger Jobs, to organize and transfer amounts.

Reclassify Accounts Receivable with Credit Balance

In this exercise, you will analyze the execution and results of the reclassification run of a customer with a credit balance.

Reconciliation Account Change

If the reconciliation account in the customer account master record was changed during a fiscal year, you can also use the Regroup Receivables / Payables job template to report all the receivables at the balance sheet key date using the new receivables reconciliation account.

To do this, select the Changed Rec. Acct. option in the Parameter settings of this template.

Note
First, the transfer postings required due to the change of reconciliation account are carried out. After that, the receivables are sorted. Depending on the results, the adjustments required are determined and carried out.

Regroup Receivables due to Reconciliation Account Change

In this exercise, you will analyze an already executed regrouping receivables run in connection with a changed reconciliation account.

Log in to track your progress & complete quizzes