OneTimeVendors (Conto pro Diverse, CpD)
In procurement or vendor subledger it can be exciting to analyze „OneTimeVendors”.
Let´s have a look to a standard process in procurement when ordering hardware for example. Task will be to find a vendor who supplies laptops for the company in the future. An approach could be as follows:
- Several inquiries with existing vendors for laptops
- Depending on the terms of the offer, the best/cheapest vendor is chosen
- In order to enter the order, the vendor is looked up in the system, to see, if already existing.
- In case that the vendor does not exist in the system, a master data record stating name, address, bank details etc. is saved and the vendor gets a unique vendor number
- If the vendor is listed in the system, the existing master data record is used.
- An order is created that refers to the vendor or vendor number respectively; subsequent documents as incoming invoice and goods receipt will be handled the same way.
Definition of OneTimeVendors
Entering a vendor master record as described above costs time and money. In general, this certainly makes sense, since the data recorded with this business partner can be used for all future transactions.
However, there are situations where the effort is not worth it. A typical example are costs for application and their refunds respectively.
If for the journey of a candidate, such as a train ticket in the amount of 15.00 Euro, refunds will be made, the internal costs of the establishment of a master record would exceed the transaction value by far. Furthermore this record will not be needed lateron, as it is a one-time process.
In this case OneTimeVendor accounts are a useful device. As a special collective account such one-time processes can be posted to. A typical naming convention for such account would be “CpD A-K” for example, where a fictitious vendor number 1000 would be posted to, and fictitious vendor number 2000 posted to “CpD L-Z”.
The invoice for candidate „Toni Test“ could be posted to vendor number 2000, without creating a vendor master record. Reimbursement of expenses for "Stefan Senseless" is also posted to the vendor number 2000, as well as the night of the manager in the "NA Hotel Leipzig" as part of a cancelled flight. Various ("Miscellaneous") transactions are therefore gathered under a single vendor number.
Vendor No. | Vendor Name | Payee | Bank details | Amount |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | Toni Test | 000456, Dt. Bank | 15,00 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000789, CoBa Leipzig | 89,00 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
6442 | Lieschen Müller | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Cayman Islands Ltd. | 000666, Cayman Islands | 1.235.112,00 € |
2000 | CpD L-Z | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000555, NK Schweiz | 2.499,00 € |
As the account CpD-vendor is only a shell, the actual data for each transaction must be saved ad hoc, often when receiving or posting the invoice.
Typical features of processes posted to CpD-accounts can be
- One-time: only business with these partners made only once
- Small amount: In general, only small value transactions are handled
- Ad-Hoc entry: The master record as collective account is only general, details of the invoice have to be entered during posting.
Analytic approaches
From these characteristics and features conversely result the risks that have to be reviewed via data analytics. The essential issue with collecting a lot of business processes in one CpD-Account is, that transparancy gets lost, as shown in the figures with matches. It increases the risk of errors or fraudulent conduct.
Typical audit question would be:
Have recurring transactions been posted to CpD?
Have the transactions to the same business partners been posted repeatedly to a collective account?
--> Then, a separate master record should be created because the one-time character does not exist any longer.
Lieferant No. | Lieferant Name | Zahlungsempfänger | Bankverbindung | Betrag |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | Toni Test | 000456, Dt. Bank | 15,00 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000789, CoBa Leipzig | 89,00 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
6442 | Lieschen Müller | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Cayman Islands Ltd. | 000666, Cayman Islands | 1.235.112,00€ |
2000 | CpD L-Z | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000555, NK Schweiz | 2.499,00 € |
Have big single amounts been posted to CpD?
Have big single amounts been posted to CpD? --> In this case it is recommended to enter an entire master record to prevent that big amounts disappear in the reporting, but to be able to identify each business partner number explicitly.
Lieferant No. | Lieferant Name | Zahlungsempfänger | Bankverbindung | Betrag |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | Toni Test | 000456, Dt. Bank | 15,00 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000789, CoBa Leipzig | 89,00 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
6442 | Lieschen Müller | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Cayman Islands Ltd. | 000666, Cayman Islands | 1.235.112,00 € |
2000 | CpD L-Z | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000555, NK Schweiz | 2.499,00 € |
Have existing vendors (in duplicate) been posted to CpD also?
Have the recipient data, especially the bank details, been registered correctly, or is there perhaps even a master record? (--> Manual entries increase the risk of errors and thus pecuniary loss or duplicate payments.)
Lieferant No. | Lieferant Name | Zahlungsempfänger | Bankverbindung | Betrag |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | Toni Test | 000456, Dt. Bank | 15,00 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000789, CoBa Leipzig | 89,00 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
6442 | Lieschen Müller | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Cayman Islands Ltd. | 000666, Cayman Islands | 1.235.112,00 € |
2000 | CpD L-Z | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Stefan Sorglos | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000555, NK Schweiz | 2.499,00 € |
Are there any abnormalities in the payees?
How is segregation of duties ensured, as the person who creates the master record and enters the invoice “merge”? (--> Especially risky when entering bank details ad hoc.)
Lieferant No. | Lieferant Name | Zahlungsempfänger | Bankverbindung | Betrag |
2000 | CpD L-Z | Stefan Senseless | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | Toni Test | 000456, Dt. Bank | 15,00 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000789, CoBa Leipzig | 89,00 € |
2000 | CpD L-Z | Stefan Senseless | 000123, Sparkasse | 999,99 € |
6442 | Lieschen Müller | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Cayman Islands Ltd. | 000666, Cayman Islands | 1.235.112,00 € |
2000 | CpD L-Z | Lieschen Müller | 000111, Volksbank | 4.999,99 € |
2000 | CpD L-Z | Stefan Senseless | 000123, Sparkasse | 999,99 € |
2000 | CpD L-Z | NA Hotel Leipzig | 000555, NK Schweiz | 2.499,00 € |
The term "one-time vendor" thus means the collective accounts to which one-time transactions should be posted. These transactions should be considered in more detail by means of analysis. There are several exciting approaches in this context.