Tasks to be completed when creating an operating procedure (from creation to publication)
|
This procedure aims at referring the internal controls to be delivered by Procure-to-Pay (PtP), in which frequency; with whom it should be shared and the expected actions from them; and how to record evidence.
It applies for PtP process Worldwide. Any specificity required at regional level, if and whenever applicable, has a chapter inside this procedure.
Any other complementary documentation (including translated versions) related to this matter must always refer to this procedure.
AP - Accounts Payable
Cockpit - SAP transaction that PtP uses to process invoices. It is the same as Process Director
GR - Goods Receipt
IV - Invoice
POC - Provisioning Operating Center (team in charge for creating Purchase Orders)
PtP - Procure-to-Pay
Any internal control delivered by PtP must have a clear evidence on:
It aims at following up the proper applicability of the tolerance rules, showing all invoices with price discrepancy in 2 main axis, by item :
Axis | Evidence Purpose | Description | Difference Calculation |
|---|---|---|---|
| Goods receipt vs Invoice (GR-IV) | price discrepancy for 3-Way-Match Invoices | Comparison between Goods receipted in the system and the Invoice posted (per line item) | Goods Receipt Line Amount - Invoice Receipt Line Amount |
| Net PO Item Amount vs Invoice Item Value | price discrepancy for 2-Way-Match Invoices | Comparison between Net PO in the system and the Invoice posted (per line item) | PO Line Amount - Invoice Receipt Line Amount |
Prior Note: You can use this template as basis to paste the information into sheet "Raw Data" to benefit from some predefined formulas.
1.1 - You should enter in the SAP transaction dedicated to this report and execute it with following criteria:
1.2 - Then, execute and export the output to Excel.
2.1. - Add an additional columns to the report downloaded previously as follows:
| Column Name | Tolerance Cluster - 3WM (GR - Invoice) | Tolerance Cluster - 2WM (PO Item - Invoice) |
|---|---|---|
| description of output | to check whether discrepancy is relevant and if so it is above / below the tolerance | |
valid options
(meaning)
| not relevant - 2WM (if cockpit document type = "VP" or "RG" or "IP") | not relevant - 3WM (if cockpit document type <> "VP" and "RG" and "IP") |
not relevant - positive (positive amounts) | not relevant - positive (positive amounts) | |
| List of Exceptions | List of Exceptions | |
Inside Tolerance (difference <=200€) | Inside Tolerance (difference <=200€) | |
Outside Tolerance <1K€ (difference up to 1000€) | Outside Tolerance <1K€ (difference up to 1000€) | |
Outside Tolerance >1K€ (difference > 1000€) | Outside Tolerance >1K€ (difference> 1000€) | |
Note: Whenever you have discrepancies Outside Tolerance you should screen and analyse to understand if it was an effective discrepancy and if it was properly validated as described in procedure: III - Handling Price Discrepancy
2.2 - Create 4 pivot tables as follows:
GR - INVOICE (3WM)
| Summary (GR - Invoice) | # GR with Difference | Amount (total value) |
|---|---|---|
| Inside Tolerance | X | Y€ |
| Outside Tolerance <1K€ | X | Y€ |
| Outside Tolerance >1K€ | X | Y€ |
| Total | sum(X) | sum(Y€) |
3WM Discrepancies by Vendor
| Vendor list | # GR with Difference | Amount (total value) |
|---|---|---|
Inside Tolerance +Vendor Name | X X | Y€ Y€ |
Outside Tolerance <1K€ +Vendor Name | X X | Y€ Y€ |
Outside Tolerance >1K€ +Vendor Name | X X | Y€ Y€ |
| Total | sum(X) | sum(Y€) |
PO ITEM - INVOICE (2WM)
| Summary (GR - Invoice) | # GR with Difference | Amount (total value) |
|---|---|---|
| Inside Tolerance | X | Y€ |
| Outside Tolerance | X | Y€ |
| Outside Tolerance >1K€ | X | Y€ |
| Total | sum(X) | sum(Y€) |
2WM Discrepancies by Vendor
| Vendor list | # GR with Difference | Amount (total value) |
|---|---|---|
Inside Tolerance +Vendor Name | X X | Y€ Y€ |
Outside Tolerance <1K€ +Vendor Name | X X | Y€ Y€ |
Outside Tolerance >1K€ +Vendor Name | X X | Y€ Y€ |
| Total | sum(X) | sum(Y€) |