Performing Open Item Clearing

Objectives

After completing this lesson, you will be able to:
  • Post a financial document with clearing
  • Execute account clearing
  • Use the clearing program
  • Perform incoming and outgoing payments
  • Reset clearing

Open Items

Open Item Clearing

Flowchart showing a process: an invoice is linked to an open item account, which is cleared after a check deposit. Steps lead to actions: Clearing an Account or Post with Clearing.

Open items, such as invoices that have not been paid, are incomplete transactions.

To complete a transaction, you must clear it. A transaction is cleared when a clearing posting is carried out for an item or group of items, so that the resulting balance of the items is zero.

You cannot archive documents with open items. The documents stay in SAP S/4HANA until all open items are cleared.

An example of posting with clearing is as follows:

  1. An invoice is posted to a customer account. This invoice is regarded as an open item because at this point it is unpaid.
  2. The customer pays the invoice and the payment is assigned to the open item.
  3. The invoice is cleared with the payment and the resulting balance is zero.

In this clearing procedure, you manually select open items that balance to zero from an account. Examples of situations where you perform clearing manually are as follows:

  • For bank subaccounts and clearing accounts
  • For situations where you have agreed upon a debit memo procedure
  • For refunds from a vendor

A clearing transaction always creates a clearing document.

Post with Clearing

Illustration of a clearing process: manually enter amount in clearing account, select open item account entries to match, clearing document is auto-created, and items are marked as cleared.

When using the post with clearing function, enter the clearing document amount and select the open items that require clearing. If the total amount of selected open items equals the amount of the clearing document, SAP S/4HANA clears the open items by creating one or more clearing items. If the total amount of selected open items does not equal the amount of the clearing document, the system allows you to post the difference.

The following options are available for clearing open items:

  • Clear several accounts and account types.
  • Clear items in a particular currency.
  • Post differences that result from assigning items to each other.
  • Enter any number of additional line items (for example, bank charges).

A post with clearing transaction can be performed either manually or automatically using the automatic payment program and the automatic clearing program.

How to Display the Posting Keys for Clearing Open Items

How to Display the Posting Keys for Clearing Open Items

Account Clearing

Diagram illustrating an account clearing process: open items are checked, creating a clearing document, and resulting in a partially cleared account with some items still unchecked.

Using the clear account function, the system closes the open items that have zero balance between them within an account. SAP S/4HANA automatically marks these open items as cleared and creates a clearing document.

Each cleared item contains the following information:

  • Clearing document number
  • Clearing date

The clearing date can be either the current date or a date defined by the user.

The clear account function can be used on any account managed on an open item basis in the general ledger and the subledgers.

Clear an Account

Clear an Account

Business Example

Your customer has returned a faulty product they purchased from your company. You must post a credit memo to clear the original invoice posting. SAP S/4HANA provides two transactions for clearing open items, account clearing and post with clearing. In this exercise you use the account clearing function.

Note

In this exercise, when the values include ##, replace the characters with the number that your instructor assigned to you.

Clearing Program

A diagram explains account clearing steps, prerequisites, and non-clearable items, alongside an example of a cleared open item account with amounts 2000, 3000, and 5000 marked.

You can use the automatic clearing program to clear open items for the following accounts:

  • General ledger
  • Subledger

The automatic clearing program groups items within an account that have the same entries in the following fields:

  • Company code
  • Account type
  • Account number
  • Reconciliation account number
  • Currency
  • Special general ledger indicator

The report also uses a maximum of five additional user criteria from the document header or line items to create the groups.

If the balance (in local currency) of items within a group is zero, SAP S/4HANA (FI) automatically clears them and creates clearing documents. All accounts requiring automatic clearing must be defined in Customizing.

The automatic clearing program does not clear the following items:

  • Noted items
  • Statistical postings and certain special general ledger transactions relating to bills of exchange
  • Down payments

    Down payments can only be cleared if down payment clearing items of the same amount have already been posted.

  • Items with withholding tax entries

How to Run the Clearing Program

How to Run the Clearing Program

Preparation: Post four line items to G/L Account 11100010 – two with the same assignment number and two with different ones.

Use of the Assignment Field as a Sort Field

Assignment Field as a Sort Field

A diagram showing data flow between master record, line item display, SD document, and accounting document, highlighting assignment and reference fields linked to posting dates and items.

SAP S/4HANA fills the Assignment field automatically for a line item when you post items according to the Sort field entry in the master record.

The Assignment field can be a combination of up to four fields with a maximum of 18 characters. For example, to display the document number with 10 characters and the posting date with six characters, SAP S/4HANA includes them in the definition of the assignment field.

Similarly, if the sort key is set to the purchase order number in the business partner master record (Customer/Vendor), then SAP S/4HANA fills the Assignment field in the business partner line item with the purchase order number.

If the sort key is set to the cost center in a general ledger master record, then SAP S/4HANA fills the Assignment field in the general ledger line item with the number of the cost center.

Line Item Sorting

Line item sorting in the line item display and clearing functions can be based on the assignment field. For example, when an invoice is posted in sales order management, an accounting document is created in Financial Accounting (FI). The document has a document number that is different to the number of the sales order management invoice. You can use the reference and assignment in the sales order management billing document to trace the document in sales order management that the accounting document is based on. The reference and assignment in the accounting document are copied from the reference and assignment in the sales order management billing document.

You can define which numbers (purchase order, order, delivery, or billing document number) are copied into the sales order management document as reference and assignment and then transferred to FI. You can then use these fields as selection criteria in FI.

How to Display the Sort Key Field in the Master Record

How to Display the Sort Key Field in the Master Record

Manual Payment Process

Flowchart showing steps for Post with Clearing: Document header (payment header, bank data, select open items), Process open items (activate items, cash discount), and Post (overview, post).

A manual payment is a transaction that clears an open item, such as an invoice. The manual payment assigns a clearing document manually.

An incoming payment, which is used in accounts receivable, clears an open debit amount. An outgoing payment, which is used in accounts payable, clears an open credit amount.

Payment Header

Screenshot of an SAP Accounts Receivable interface showing Post Incoming Payments selected, leading to a payment entry screen with fields and a highlighted Propose Items button.

The data entered in the document header is similar to the data entered when posting invoices.

The document header consists of the following sections:

  • The payment header
  • Bank data
  • Selection of open items

Enter the following information in the payment header section of the document header:

  • The document date.

  • The document type, proposed by SAP S/4HANA and based on the transaction called.

  • The company code, if no code is proposed.

  • The date specifications, including the document and posting dates and the posting period. The current date is the default document and posting date, and the posting period is derived from the posting date.

  • The currency specifications, including the currency code, the exchange rate, and the date for currency translation. In the absence of a manually input exchange rate or translation date, the application uses the exchange rate from the exchange rate table on the posting date.

  • Any payment references needed to identify the incoming payment, such as the reference document number, document header text, and clearing text fields.

Enter the following data in the bank data section of the document header:

  • The general ledger (G/L) account number for incoming or outgoing payments.

  • The total payment amount.

  • The bank charges for services: SAP S/4HANA automatically posts these charges to a special expense account.

  • The value date: This date is used to evaluate the position in cash management. It may be the current date, which is the default date in the system.

  • The text description: This is an optional description of the item. Start the line with an asterisk (*) to enable the text to be printed on external correspondence too. You can also work with text templates to select an entry from a list of standard texts.

  • The assignment number: This is created by SAP S/4HANA, or entered manually.

S/4HANA references the following information when calculating post charges:

  • Incoming payments: The application adds the bank charges to the payment amount to form the clearing amount.

  • Outgoing payments: The application subtracts the bank charges from the payment amount to determine the clearing amount.

Processing of Open Items

Steps for posting with clearing, including item selection, clearing confirmation, and the final Post button highlighted for processing.

The Post Incoming Payments: Process open items screen lists all of the unassigned open items. Unassigned open items can include payments, debit or credit memos, and invoices.

You can post the document if the Amount Entered field is the same as the Assigned field.

The cash discount granted is determined by the terms of payment of the line item. SAP S/4HANA calculates the assigned amount based on the cash discount. To change the cash discount, either overwrite the absolute cash discount or change the cash discount percentage rate. The discount must not exceed the set tolerance limits.

To check the document that you have entered, under DocumentSimulate, display all of the items including those created automatically. If the debits and the credits match, you can post the completed document. If you subsequently discover that the document contains an error, reset the cleared items, reverse the document, and re-enter the original posting correctly.

To Process a Manual Payment

Steps

  1. Enter data in the document header.

  2. Select the open items to be cleared.

  3. Save the transaction.

Post with Clearing

Post with Clearing

Business Example

Customers pay open invoices to take advantage of cash discounts. For this reason, you need to know how to post an incoming payment with a cash discount.

Note

In this exercise, when the values include ##, replace the characters with the number that your instructor assigned to you.

Automatic Postings for Clearing Open Items

Illustration of account balancing with a weighing scale, an open item account showing amounts cleared, and a list of factors affecting clearing, including discounts, charges, and payment tolerances.

SAP S/4HANA performs automatic postings, such as tax adjustment, bank charges, and exchange rate differences, when clearing open items. You have already seen the configuration for most of these automatic postings in previous lessons.

You can enter bank charges when you enter the bank data. SAP S/4HANA posts the bank charges to the general ledger account automatically.

To perform manual cross-company code payments, assign a clearing transaction. A clearing transaction can be either an incoming payment or an outgoing payment. Assign the clearing transaction to a combination of the paying company code and the company code for which the payment is being made. Then, when you select the open items, SAP S/4HANA displays the open items from each company code. 

How to Define Cash Discount Expense and Revenue Accounts

How to Define Cash Discount Expense and Revenue Accounts

How to Define a Cash Discount Clearing Account

How to Define a Cash Discount Clearing Account

How to Define a Cash Discount Loss Account

How to Define a Cash Discount Loss Account

Reset of Clearing

Diagram explaining how to reset mistakenly cleared items in an open item account by canceling the clearing document and reverting the items to their original state. Steps are highlighted visually.

You can reset clearing for individual documents. When you reset clearing, SAP S/4HANA removes the clearing data from the line items. Starting with 1709, there is a new app Reset Cleared Items.

SAP S/4HANA logs the changes and displays them in the change documents. In accounts receivable, the application corrects the payment history and the credit limit, if applicable.

How to Reset Clearing

How to Reset Clearing

Summary

  • Open items are incomplete transactions, such as unpaid invoices, requiring clearing to be set to complete.
  • Clearing transactions create in certain cases a clearing document, marking items as cleared with a zero balance.
  • Post with clearing allows manual or automatic selection of open items for clearing.
  • Account clearing automatically marks zero-balance open items as cleared within an account.
  • Use the clearing program for automatic clearing of open items in general ledger and subledger accounts.