Payment reconciliation
How FOPilot matches monobank incoming payments to orders and Nova Poshta cash-on-delivery payouts.
reconcile_payments (Pro/Business) compares monobank incoming transactions (up to 31 days) with card-transfer orders and delivered cash-on-delivery parcels. Rules, strongest first:
- Waybill number in the payout purpose (Nova Poshta / NovaPay) → that parcel and its order (confidence 1.0).
- Payout equal to one parcel's COD amount, or slightly lower (payment-control commission) → 0.7–0.85.
- Payout equal to the sum of several parcels received shortly before (registry payout) → 0.7.
- Order number in the transfer comment and the amount fits → 1.0.
- Amount equals an order total within 7 days and the payer name matches the buyer → 0.95; a unique amount match → 0.75; several → reported as ambiguous with candidates.
Output: matched, ambiguous, unmatched incoming transactions, unpaid expected orders, COD received but not paid out after 3 days, and payouts reported by Nova Poshta but missing in the bank statement. Payer names are shortened; card numbers, phones and IBANs are masked.