Illustrating Accounts Receivable Regrouping

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.

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!

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.

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.

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.

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.

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.