Identifying Customer Transactions in the Receivables Management and in the General Ledger

Objectives

After completing this lesson, you will be able to:

  • Navigate to postings and transactions in the general ledger and receivables management
  • Recall the most important reporting and analysis tools of the receivables management

General Ledger and Receivables Management

Linda realized that each Customer receives its own account within the system. Now she wants to navigate to the postings she made. This is where she realizes that the outstanding posted invoices can be analyzed on each separate Customer account within the receivables management work area. However, she remembers that each Customer transaction also needs to be represented within the General Ledger, because General Ledger is an overview of all company’s financial operations. She dives into the system and realizes that Receivables Management and General Ledger are connected via reconciliation accounts.

This image illustrates the process of managing receivables and updating the general ledger. The Customer Account is updated for Receivables Management and then is also posted to the general ledger via a Reconciliation Account. Amounts for taxes and revenue are also posted to the general ledger.

Customer invoices may or may not originate from a sales order.

If we create customer invoices from a sales order, it means that our company has sold some stock that needs to be tracked in our balance sheet.​​

In the receivables management, the Customers and their balances are listed separately. In other words, every Customer has their own account, ​where the gross invoice amounts are debited. These amounts also need to be represented in the ​General Ledger. ​​

Receivables are summarized or reconciled on a receivables reconciliation account in the General Ledger. The reconciliation account comes from the Customer master record and is mandatory for each Customer. You cannot make postings directly to a reconciliation account.​​

The output tax amount travels directly to the output tax G/L account.​

With or without sales order in place, the invoice net amounts are posted as revenues.​

Receivable Values in Financial Statements

After learning about reconciliation accounts and their role in connecting Receivables Management and General Ledger, Linda would like to discover where can she find its Customer transactions in the Bike Company’s financial statements, like balance sheet and profit and loss statement. She needs to do that to make sure that Bike Company’s external reporting is consistent.

This image depicts how the values from the Customer invoices appear when viewing a Financial Statement.

Your​ gross invoices amounts always get debited to the receivables reconciliation account, which is found on the assets side of the balance sheet. The structure of the balance sheet and the names of the balance sheet items may differ depending on the ​financial statement version you are using, which depends on the underlying accounting principle.​​

​The net amounts need to be recorded as revenues directly in the Profit & Loss Statement. Depending on the revenue type, it may be credited to one or the other relevant revenues account.​​

​The structure of the profit and loss statement and the names of the profit and loss statement items also may differ depending on the financial statement version you are using, which ​depends on the underlying accounting principle.

Customer Items KPIs

Working with many Customer invoices every day you might want to have a Big Picture view on you company’s Customer operations. Linda thinks this as well. After processing multiple Customer invoices, she would like to generate a few reports with the most important Customer-related key performance indicators (KPIs). Luckily SAP provides functionality that Linda is looking for.

This image describes the Account Receivable Overview application. This application contains analysis regarding accounts receivables data, such as Days Sales Outstanding and Aging Analysis. This allows the user to determine how well receivables collections are progressing.

SAP provides several valuable apps with embedded analytics functionality that deliver important insights on the company’s operations.

In the Receivables Management there is a central app that showcases all important receivables management KPIs – Accounts Receivable Overview. With this analytical overview app, you can monitor important accounts receivable indicators and access further accounts receivable analytical apps. This is a central entry point for the receivables management accountant or a receivables management manager to get a holistic big picture overview on one screen.

From this app you may navigate to further analytical apps for more detailed information. Apps like:

  • Days Sales Outstanding: The representation of an average amount of days your customers take to pay their invoices
  • Receivable Aging (Aging Analysis)
    • The representation your outstanding invoice’s lifetime since the posting date
    • Can be represented as an overdue or not yet due report

There are also many more analytical apps not included in the accounts receivable overview. One worth mentioning would be the Overdue Receivables app. With this app you can check the amount of your customers’ overdue receivable amount. You can monitor the status of the overdue incoming payments for critical customers in your area of responsibility. You can also find out about the potential risks and notify the responsible persons to take action.

Linda learned a lot of fundamentals about Receivables Management. She is able to describe all main functions of this work area including Customer master data creation and invoice posting. However, this is just the beginning. Linda will continue exploring Receivables Management to expand her skills and knowledge. But already now she is ready to tackle new challenges as a receivables management accountant.

View Overdue Receivables

Practice yourself using the interactive simulation to view the Overdue Receivables for your Customer using the Fiori app Overdue Receivables.

Log in to track your progress & complete quizzes