Kickback Vendor Bid Splitting Invoice Analytics Checker

Group bid amounts by normalized vendor key and flag groups with enough individually subthreshold bids whose combined value reaches the supplied approval threshold.

Description

Bid splitting can involve multiple individually subthreshold amounts whose aggregate reaches an approval limit.

Bid splitting can involve multiple individually subthreshold amounts whose aggregate reaches an approval limit. Vendor normalization groups text keys for a first screen.1

The returned values include Suspicious vendor groups, Suspicious vendor keys, Suspicious combined bids. The How section below explains the calculation, input rules and interpretation.

When to use Kickback Vendor Bid Splitting Invoice Analytics Checker

Use Kickback Vendor Bid Splitting Invoice Analytics Checker when you need to evaluate the supplied records under the calculation and evidence rules below. No date/project grouping, beneficial ownership or actual kickback/splitting intent is analyzed.

Prepare source-backed observations and the applicable engagement policy before entering facts. Use consistent monetary units and periods. Supply all boolean evidence flags explicitly, and treat a successful screen as a reason to continue professional review.

How to use Kickback Vendor Bid Splitting Invoice Analytics Checker and understand its results

  1. Prepare source-backed observations and the applicable engagement policy before entering facts. Use consistent monetary units and periods. Supply all boolean evidence flags explicitly, and treat a successful screen as a reason to continue professional review.
  2. Enter approvalThreshold, bidAmounts, minimumBidsPerVendor, vendorKeys using the field table and calculation rules, then run the tool.
  3. Read suspiciousGroupCount, suspiciousVendorKeys, suspiciousVendorTotal. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
Input fieldMeaningValue type; see rules belowRequirement
approvalThresholdApproval or review threshold used by the supplied process.numberRequired
bidAmountsPositive bid amount for each vendor-key row.list of numberRequired
minimumBidsPerVendorMinimum number of bids required for a candidate group.integer; minimum: 2Required
vendorKeysVendor key associated with each bid amount.list of stringRequired

Require positive finite threshold/bids, minimum safe integer≥2 and aligned lists, possibly empty. Trim/lowercase nonblank vendor keys, group all amounts and select qualifying groups. Return sorted keys/count and checked total. Any at-or-above-threshold bid disqualifies that vendor group.

suspicious=count≥minimum AND all bids<threshold AND sum≥threshold

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output fieldMeaningValue type
suspiciousGroupCountSuspicious vendor groupsinteger; minimum: 0
suspiciousVendorKeysSuspicious vendor keyslist of string
suspiciousVendorTotalSuspicious combined bidsnumber; minimum: 0
json
{
  "input": {
    "approvalThreshold": 750000,
    "bidAmounts": [
      400000,
      380000,
      500000
    ],
    "minimumBidsPerVendor": 2,
    "vendorKeys": [
      "Vendor A",
      "vendor a",
      "Vendor B"
    ]
  },
  "output": {
    "suspiciousGroupCount": 1,
    "suspiciousVendorKeys": [
      "vendor a"
    ],
    "suspiciousVendorTotal": 780000
  }
}

Limitations and assumptions

No date/project grouping, beneficial ownership or actual kickback/splitting intent is analyzed.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Core numeric and string lists are limited to 100,000 entries; text entries are subject to the general large-text limit. Follow any smaller calculation limits above. Missing fields without a declared default, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Lapping Receipt Delay Pattern Detector: Possible lapping patterns can involve equal amounts applied across different customers. A matching pair is an investigative lead. For a complementary task, use Fictitious Vendor W-9 Bank Duplicate Detector: Vendor-master anomalies can include shared tax/account identifiers and active records missing them. Identity duplication is an investigative lead.

References

  1. Kickback Vendor Bid Splitting Invoice Analytics Checker — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies