3133715 - Current System Logic to Calculate Opening & Closing Balance in Customer Account Statements for South Africa

You are running Customer Account Statement and want to understand the logic on how system calculates the Opening and Closing Balance in the system.

In South Africa, it is a legal requirement for companies to send regular account statements to their customers in order to receive due payments.

 SAP Business ByDesign

1. Go to the Receivables work center.
2. Go to the Customer Account Statement view.
3. Select Run Id XXX(represents Run ID)
4. Select All Logs and click on View Report Run Results.
5. Select the tab Data Prepared for Export.

You can view the Closing & Opening Balance for each Customer Account here.

For the calculation of Opening Balance on customer account statement, documents before the selection date is aggregated and displayed as opening balance.

For example: If the Posting Date in the run is 01.04.2021 to 14.06.2021.

• Take a note of Invoices considered for Opening Balance (Prior to 01.04.2021)
• Take a note of Payments received / Cleared (Prior to 01.04.2021)

You can get these numbers by following the below steps:

1. Go to the Receivables work center.
2. Go to the Customers view and then Customer Accounts subview.
3. Search for the Customer XYZ(represents Customer Id) in question.
4. Go to Trade Receivables>Invoices/Payments>All Items.
5. Filter to All Items and then the Advanced Filter.
6. Set the Document Date <=01.04.2021 and Export it into the excel.

In the excel, filter for Invoices where the Sum of amount is A (All invoices prior to 01.04.2021)

Filter for Payments, the Sum of amount is B (All Payments prior to 01.04.2021)

Opening balance = Total open Invoices - Sum of payment/clearings= A-B is the opening Balance in the Customer Account Statement.

Note: If there are no Payments or Clearing made prior to the starting date of the account statement run, then the above logic would not be applicable

For listing out items(in the PDF), we consider only the documents within selection date range of the run.

1. Go to the Receivables work center.
2. Go to the Customers view and then Customer Accounts subview.
3. Search for the Customer XYZ(represents Customer Id) in question.
4. Go to Trade Receivables>Postings tab.
5. Enter the Posting Date from/To: 01.04.2021 / 14.06.2021
6. Export it into the excel.

• Sum of invoices= Debit Amount of Customer Account Statement
• Sum of payments = Credit Amount of Customer Account Statement

Closing Balance(Amount Due as in PDF) = Opening Balance + Sum of invoices – Sum of payments

Customer Account Statements, South Africa, Opening Balance, Closing Balance , KBA , south afica , customer account statements , SRD-FIN-GLO-REP , GLO - Statutory Reporting , Problem