Explaining the Manual Clearing Functionality​

Objective

After completing this lesson, you will be able to reprocess bank statements

Manual Clearing

In case the configured posting rules and the processing rules cannot determine a match between the incoming payment and open item in the SAP S/4HANA Cloud system, manual reprocessing is required. This step should be considered as a last resort and is not a regular task from the outset of the bank statement processing.

In the SAP Fiori app Reprocess Bank Statement Items, you can reprocess a bank statement item, mark it as reprocessed, and enter a reason for reprocessing. You can also add attachments to bank statement items.

The SAP Fiori app Reprocess Bank Statement overview screen shows several bank statement items with posting status of Not Completed and Completed. Three statements from House Bank 1 have a status of Not Completed and consequently need further attention.

On the overview page of the Reprocess Bank Statements app, you can apply a number of filters to drill down to exactly the information you are looking for. Statement items with a status of Not Completed are highlighted in red and would need further attention to manually post and clear open items.

To perform the reprocessing task, you can proceed to the details of the individual statement items with the Reprocess button.

System screenshot of the SAP Fiori app Reprocess Bank Statements that shows the details of a single bank statement item, containing information about the customer, posting date, payment amount, or memo line. In the lower section of the screen, open items of the customer are displayed that are to be matched.

On the layout of the Reprocess Bank Statement Items app, each area of the screen is used for a specific purpose.

Top panel (information n orange)

The information in the top box is used to show information on the bank statement transaction (incoming money) that is being processed. The company code, bank account, amount, date, and so on, are reflected. In addition, the memo line is displayed, which contains the information on the bank statement item from the bank and from the sending party. The memo line is very helpful in determining the invoice(s) the incoming payment relates to.

Lower left panel (information in blue)

The information in blue shows the (customer) open items to be cleared. Next to the customer open items, there are also all open items of the SAP S/4HANA Cloud system available. Pressing the Select More button, you can filter the open items that are displayed to be cleared. This way a manual matching between the statement item information (orange box) and the open item of a customer is performed. By pressing the Clear button on an open item, the open item moves to the list of open items that will be cleared by this bank statement transaction (green box mentioned below).

Lower right panel (information in green)

The information in green are the proposed open items to be cleared by the bank statement transaction. Pressing the Remove button on an open item that will be cleared by this bank statement transaction (incoming money), the open item moves back to the list of open items available to be cleared (blue box).

The goal is to bring the balance amount to zero with open items that should be cleared against the incoming amount. These are the open items in the green box. Discounts and reason codes could also be considered in the Items to Be Cleared area.

System screenshot of the SAP Fiori app Reprocess Bank Statements, as the continuation of the previous processing steps. Several open items of a customer were manually assigned to the Items to Be Cleared area. The balance of the transaction is zero and all items can be posted.

In case the accountant has identified all the open items of a customer to be matched with the bank statement information, the overall balance of the transaction is zero. A simulation of the posting is possible, saving without posting or the creation of a dispute case. If all issues are cleared, posting is possible.

Once the bank statement items are posted in the SAP S/4HANA Cloud system, the follow-on documents can be displayed. The Reprocess Bank Statement Items app displays Bank Statement details and in addition Journal Entry Information of Posting Area 1 and Posting Area 2 for an incoming payment.

After posting the journal entries, it is also possible to create a rule based on the used parameters of the posting.

After successful processing, all bank statements have the posting status Completed. This also ensures the proper update of all Cash Management related reporting, for example, Cash Position or Liquidity Forecast.

Log in to track your progress & complete quizzes