Table of contents
1. Objective and Scope
The purpose of this document is to explain how to perform the internal controls for Accounts Receivable process.
The Internal Controls mentioned in this OP aims to ensure:
- Compliance with AR procedures
- Application of Process Expert's instructions and guidelines
- Assure the mitigation of financial risk in key tasks
This operating procedure (OP) applies to all EMEA companies and customer payments for invoices factored to Solvay SA. The only exception are related to controls "Review of receivables not assigned to 0231" and "Monthly review receivables in local system" in which we analyze all Regions (EMEA, NAFTA and ASIA) in the first one and EMEA and Asia in the second one.
2. Definitions
- SBS: In the current document, "Solvay Business Services" will be replaced by its abbreviation "SBS".
- OTC AR: Order to cash Accounts Receivable
- OTC CM: Order to cash Credit Management
- OP: Operating procedure
- 0231: PI system for Worldwide Accounts Receivable and Payable
- CM: Credit Manager
- DO: Doubtful invoice
- EMEA: Europe, Middle East and Africa
- PE: Process Expert
Scope
ERP
References
4. Add the link to SAP procedures (when it exists) |
Attachments
5. Add the link to attachments (to be stored in AODocs or GDrive) or external links
In PI1:
Open FEBA transaction and choose the following criteria's:
Company code: 0231
Statement date: Statement date of the payments
Statement status: 7
Execute 
Afterwards, click on each unallocated (red entries), click on the 900… document, choose 
and go to the "Attachment list" to check the ticket number. Then, go to Freshdesk and check if the case was correctly created and sent to the correct entity (Credit Manager, cash collector or to banks).
For PF1 and WP1, the payments are posted on customer accounts by RtR (automatic postings during the bank statements upload). Therefore RtR should forward a case to OTC in case of unallocated payment in which they are sure it is customer related. Regarding Poland, as the cash allocation is all manual, a ticket in Freshdesk should be created to justify a possible unallocated.
Then the report "Unallocated" should be retrieved from Sub-account in transaction FBL3 and report as below:
Select only the document type "TI" (transfers IN) and then search by "unallocated" in the text field.
|
Example:
On a daily basis the following file is updated:
All cases should be justified with the reason and mention to whom it was escalated as below |
Example:
3.1.1 Escalation procedure
For unallocated cases for more than three months and if no answer received or if is not enough to allocate the payment, the team member doing the controls should send an email to Accounts Receivables Process Expert, explaining the reason why it is being escalated (mention if no answer received, doubts, proposal). In case it is interco related or any technical constraint, a reminder should be sent to the company related or to IS.
3.2 Weekly review of Unmatched payments
The objective of this control is to assure that all non-matched payments equal or above 50.000,00 EUR have been analyzed and escalated. Therefore a list with all those items has to be justified by the AR specialist and should be sent to Service Center Manager, AR Process Expert and to Cash Collector Team Leader (which should deploy to the cash collector).
In PI1:
Open FBL5N transaction and chose the following variant:
Execute 
The following screen appears
PF1 and WP1
This extraction should also be done for Poland and Reverse Factoring customers. Therefore, enter in FBL5N and choose the following variant (Cc 0005 for PF1 and Cc ZFR3, 8090, 6068, 7531 and 6268 for WP1).
For each of the unmatched amounts, the AR Specialist should update the file below and describe the reason of non-allocation and mention to whom it was escalated:
It should be done a print screen of the file and the image added to the email.
Example:
3.3 Monthly review of receivables not assigned to Solvay SA
The principle is to have all customers/receivables from a company with convention with Solvay SA assigned to Solvay SA. Therefore, the objective of this control is to show evidence that customers not assigned to Solvay SA have a valid reason in the "Long text" field for not assigning its receivables.
This control should be done in the three systems assigning to Solvay SA: PF1, WP1 and RHO.
Open Z3F_FA_MD_REPORT transaction in local systems and choose the following variants in all systems:
Execute 
The following result is showned:
We can see a line per customer and in the "Long text" field it should be inserted the reason of not assignment to 0231. The valid and justified reasons are:
- Public institutions
- Legal purposes
- Phisicall persons
This result should be extracted to excel as below:
Click on 
Execute 
Save the file in your desktop
Finally, add this excel file to the email with the remaining controls.
Example of the file:
3.4 Daily Review of Factoring Monitoring
All the assigned Receivables to Solvay SA that do not have all the information or aren't correct can originate errors when are assigned and are displayed in Z3F_FA_OI_MONITOR transaction.
All the contracts assigned to 0231 are verified automatically by the system through 24 checkings, described below:
| 101 | OPEN: Check downpayment not yet paid |
| 102 | MD: Check vendor master data payment block (Factoring) |
| 103 | DOC: Document currency not accepted |
| 104 | INTRA: Document belongs to a chained vendor |
| 105 | DOC: Posting date is higher then current date |
| 106 | PAYM: payment method of document is not accepted for this vendor |
| 107 | MD: Partner doesn't exist in the factoring company (general) |
| 108 | MD: Partner doesn't exist in the factoring company (company code) |
| 109 | MD: Partner is blocked for posting in the factoring company |
| 110 | MD: Partner is flagged for deletion in the factoring company |
| 111 | DOC: Document date is higher then current date |
| 112 | DOC: The amount is bigger than the reference amount |
113 | DDEBIT: Vendor with direct debit / Doc with other payment meth. |
| 114 | DDEBIT: Amount over the direct debit limit |
| 115 | DDEBIT: Payment method in doc.(5) different from the one in the vendor |
| 116 | MD: Bank country with embargo |
| 117 | DOC: Document type is not valid for agents |
| 118 | COMPANY: Item belong to invalid company code |
| 119 | PAYM: payment method of document is not accepted for this customer |
| 120 | DOC: Document with factoring but master data in manual exception |
| 121 | DOC: Document with factoring but no factoring in master data |
| 122 | MD: Check vendor master data payment block (Affiliate) |
| 123 | DOC: Amount is bigger than max amount (Incoming cash) |
| 124 | DOC: Amount is bigger than max amount (Outgoing cash) |
The objective of this control is to check that all open entries are already handled and escalated to the proper entity.
Run Z3F_FA_OI_MONITOR in the three local systems transaction:
Select Customers and Execute 
Remark: the US, CA, MX and BR customers should be excluded.
The status of the entries should be yellow and the payment block X, meaning that the situation was already escalated through email. If it is red, it means that is open and it wasn't analysed.
It should be done a print screen of the entries and added to the email.
The controller should check all cases pending for more than 15 days and do the follow up, checking if it can be solved and if not, to send a reminder. |
3.5 Records of doubtful receivables and losses based only on a supporting document communicated by CM
For bad debt customers, we should provide the request in which OTC AR received the request to post a customer into doubtful status only if requested by Audit company. In this case, we should search in Freshdesk the request case and send it to the requester.
4. Reporting controls
The email should be send to the following addresses:
Process Expert Accounts Receivables | Claudrik.darnet@solvay.com |
OTC BO Manager | diogo.paiva@solvay.com |
Accounts Receivable team leader: | Paula.simoes@solvay.com |
Cash Collection team leader: | ana.cabecas@solvay.com, who will deploy to Cash Collections team |
Accounts Receivables team mailbox | solvay.ar@solvay.com |