mufassall

Konspekt · Biznes jarayonlar

To'lovlarni solishtirish

14 daq · O'rta · mufassall.dtwin.uz/uz/l/reconciliation/

← Darsni ochish

Muammo

Do'kon karta to'lovlarini provayderning javoblari va callback'laridan yozib boradi. Ularning bir qismi yo'qoladi, timeout bo'ladi yoki ikki marta keladi, shuning uchun hisob daftari va haqiqiy pul ajralib ketadi. Har tong bir job daftarni provayderning hisob-kitob hisoboti bilan solishtiradi, xavfsizini o'zi tuzatadi, qolganini odamga beradi.

Nimani o'rganasiz

  • Nega callback'lardan yig'ilgan daftar puldan ajralib ketadi va nega summa butun sonda, eng kichik birlikda saqlanadi
  • Hisob-kitob hisobotini provayder tranzaksiya ID'si, valyuta va sana oynasi bo'yicha moslash
  • To'rt xil nomuvofiqlik: qaysi birini job o'zi tuzatadi, qaysilari qo'lda tekshiruv navbatiga ketadi
  • Kun oxiridagi valyuta bo'yicha jami summa, ogohlantirish va bir narsani ikki marta tuzatmaydigan qayta ishga tushirish
Yakuniy sahna

Diagramma kod sifatida

Darsdagi yakuniy sxemani matn ko'rinishida oling va Jira, GitLab, GitHub, Notion yoki hujjatga qo'ying: Mermaid u yerlarda o'zi chiziladi. D2 va PlantUML (Confluence, IntelliJ) uchun alohida variantlar bor.

Mermaid: sxema

flowchart LR
  n_api["To'lovlar API"]
  n_provider>"Provayder"]
  n_ledger[("Hisob daftari")]
  n_files[("Hisobot fayllari")]
  n_recon("Solishtirish job")
  n_review[["Tekshiruv navbati"]]
  n_analyst(("Moliya xodimi"))
  n_pager>"Navbatchi signali"]
  n_api --> n_provider
  n_provider -.-> n_api
  n_api --> n_ledger
  n_provider --> n_files
  n_files --> n_recon
  n_recon --> n_ledger
  n_recon --> n_provider
  n_recon --> n_review
  n_review --> n_analyst
  n_recon --x n_pager

Mermaid: so'rovlar ketma-ketligi

sequenceDiagram
  participant n_provider as Provayder
  participant n_api as To'lovlar API
  participant n_files as Hisobot fayllari
  participant n_recon as Solishtirish job
  participant n_ledger as Hisob daftari
  participant n_review as Tekshiruv navbati
  participant n_pager as Navbatchi signali
  Note over n_provider,n_api: Daftar javoblar va callback'lardan yoziladi
  n_provider->>n_api: POST /payments/callback HTTP/1.1
  n_api-->>n_provider: HTTP/1.1 200 OK
  Note over n_api,n_provider: Daftar va pul ajralib ketadi
  n_api->>n_provider: 10:20:31 POST /v1/charges ord_3307 amount_minor=4500
  Note over n_provider,n_files: Provayderning hisob-kitob hisoboti
  n_provider->>n_files: settlement_2026-11-17.csv (T+1, ready at 06:00 UTC)
  Note over n_recon,n_ledger: Solishtirish job hisobotni daftar bilan birlashtiradi
  n_recon->>n_ledger: SELECT s.provider_txn_id, s.amount_minor AS theirs,
  n_ledger-->>n_recon: 48 202 rows
  Note over n_recon,n_ledger: Har farq to'rt turdan biriga tushadi
  n_recon->>n_ledger: recon 2026-11-17: 48 198 provider lines, 48 183 ledger rows
  Note over n_recon,n_provider: Xavfsiz turni avtomatik tuzatish, audit yozuvi bilan
  n_recon->>n_provider: GET /v1/payments/ptx_8813 HTTP/1.1
  n_provider-->>n_recon: HTTP/1.1 200 OK
  Note over n_recon,n_review: Qolgan hammasi SLA'li qo'lda tekshiruv navbatiga
  n_recon->>n_review: review_case (new)
  Note over n_recon,n_pager: Kun oxiri: valyuta bo'yicha jami summa
  n_recon->>n_pager: ALERT recon.totals day=2026-11-17
  Note over n_recon,n_ledger: Qayta ishga tushirish bir narsani ikki marta tuzatadi
  n_recon->>n_ledger: 06:40 provider re-sent settlement_2026-11-17.csv (v2)
  Note over n_recon,n_ledger: Har tuzatishning kaliti bor, qayta ishga tushirish hech narsani o'zgartirmaydi
  n_recon->>n_ledger: INSERT INTO recon_fixes (report_date, provider_txn_id, action)
  n_ledger-->>n_recon: INSERT 0 0

D2

direction: right

n_api: "To'lovlar API" {
  shape: rectangle
}
n_provider: "Provayder" {
  shape: cloud
}
n_ledger: "Hisob daftari" {
  shape: cylinder
}
n_files: "Hisobot fayllari" {
  shape: stored_data
}
n_recon: "Solishtirish job" {
  shape: rectangle
  style.multiple: true
}
n_review: "Tekshiruv navbati" {
  shape: queue
}
n_analyst: "Moliya xodimi" {
  shape: person
}
n_pager: "Navbatchi signali" {
  shape: cloud
}

n_api -> n_provider
n_provider -> n_api {
  style.stroke-dash: 3
}
n_api -> n_ledger
n_provider -> n_files
n_files -> n_recon
n_recon -> n_ledger
n_recon -> n_provider
n_recon -> n_review
n_review -> n_analyst
n_recon -> n_pager {
  target-arrowhead.shape: cross
}

PlantUML: so'rovlar ketma-ketligi

@startuml
boundary "Provayder" as n_provider
participant "To'lovlar API" as n_api
database "Hisobot fayllari" as n_files
participant "Solishtirish job" as n_recon
database "Hisob daftari" as n_ledger
queue "Tekshiruv navbati" as n_review
boundary "Navbatchi signali" as n_pager
note over n_provider, n_api : Daftar javoblar va callback'lardan yoziladi
n_provider -> n_api : POST /payments/callback HTTP/1.1
n_api --> n_provider : HTTP/1.1 200 OK
note over n_api, n_provider : Daftar va pul ajralib ketadi
n_api -> n_provider : 10:20:31 POST /v1/charges ord_3307 amount_minor=4500
note over n_provider, n_files : Provayderning hisob-kitob hisoboti
n_provider -> n_files : settlement_2026-11-17.csv (T+1, ready at 06:00 UTC)
note over n_recon, n_ledger : Solishtirish job hisobotni daftar bilan birlashtiradi
n_recon -> n_ledger : SELECT s.provider_txn_id, s.amount_minor AS theirs,
n_ledger --> n_recon : 48 202 rows
note over n_recon, n_ledger : Har farq to'rt turdan biriga tushadi
n_recon -> n_ledger : recon 2026-11-17: 48 198 provider lines, 48 183 ledger rows
note over n_recon, n_provider : Xavfsiz turni avtomatik tuzatish, audit yozuvi bilan
n_recon -> n_provider : GET /v1/payments/ptx_8813 HTTP/1.1
n_provider --> n_recon : HTTP/1.1 200 OK
note over n_recon, n_review : Qolgan hammasi SLA'li qo'lda tekshiruv navbatiga
n_recon -> n_review : review_case (new)
note over n_recon, n_pager : Kun oxiri: valyuta bo'yicha jami summa
n_recon -> n_pager : ALERT recon.totals day=2026-11-17
note over n_recon, n_ledger : Qayta ishga tushirish bir narsani ikki marta tuzatadi
n_recon -> n_ledger : [dublikat] 06:40 provider re-sent settlement_2026-11-17.csv (v2)
note over n_recon, n_ledger : Har tuzatishning kaliti bor, qayta ishga tushirish hech narsani o'zgartirmaydi
n_recon -> n_ledger : INSERT INTO recon_fixes (report_date, provider_txn_id, action)
n_ledger --> n_recon : INSERT 0 0
@enduml

PlantUML: komponentlar

@startuml
left to right direction
component "To'lovlar API" as n_api
cloud "Provayder" as n_provider
database "Hisob daftari" as n_ledger
storage "Hisobot fayllari" as n_files
collections "Solishtirish job" as n_recon
queue "Tekshiruv navbati" as n_review
actor "Moliya xodimi" as n_analyst
cloud "Navbatchi signali" as n_pager
n_api --> n_provider
n_provider ..> n_api
n_api --> n_ledger
n_provider --> n_files
n_files --> n_recon
n_recon --> n_ledger
n_recon --> n_provider
n_recon --> n_review
n_review --> n_analyst
n_recon -[#c62828]-> n_pager
@enduml

Xulosa

Solishtirishning besh qoidasi.

1) Summani valyutasi bilan, butun son va eng kichik birlikda saqlang. 2) Har kuni provayder hisobotini daftaringiz bilan ularning tranzaksiya ID'si, valyuta va kengaytirilgan sana oynasi bo'yicha moslang. 3) Har farqni turga ajrating; faqat provayder tasdiqlagan qatorlarni, faqat oldinga va audit yozuvi bilan avtomatik tuzating. 4) Qolganini ikkala tomon ma'lumoti va SLA bilan tekshiruv navbatiga yuboring, valyuta bo'yicha jami summani tekshiring, toki tushuntirilmagan pul yashirinib qolmasin. 5) Har tuzatish va ishga kalit bering, qayta ishga tushirish hech narsani o'zgartirmasin.

Ko'rsatkichlar: boshida va oxirida

Ko'rsatkichBoshidaOxirida
Nomuvofiqliklar0/kun35/kun
Mos kelmagan summa0 $1 950 $
Avtomatik tuzatilgan0%68%
Ochiq ishlar011

Qadamlar

  1. Holat Daftar javoblar va callback'lardan yoziladi

    Xaridor to'lov sahifasida to'laydi.

  2. Muammo Daftar va pul ajralib ketadi

    Pul yechish chaqiruvi 10 s da timeout bo'ladi va API buyurtmani failed deb belgilaydi.

  3. Yechim Provayderning hisob-kitob hisoboti

    Provayder har tong kechagi hisobotni fayl sifatida (yoki sahifalab o'qiladigan API orqali) chiqaradi: o'tkazgan har yechish, qaytarish va komissiya uchun bitta qator.

  4. Yechim Solishtirish job hisobotni daftar bilan birlashtiradi

    Job faylni oraliq jadvalga yuklaydi va uni daftar bilan provayder tranzaksiya ID'si va valyuta bo'yicha birlashtiradi.

  5. Holat Har farq to'rt turdan biriga tushadi

    Job toza mos kelmagan har qatorni belgilaydi.

  6. Yechim Xavfsiz turni avtomatik tuzatish, audit yozuvi bilan

    Har missing_ours qatori uchun job provayderning holat API'sidan yana bir marta so'raydi.

  7. Yechim Qolgan hammasi SLA'li qo'lda tekshiruv navbatiga

    Qolgan 11 ta holat tekshiruv ishiga aylanadi.

  8. Yechim Kun oxiri: valyuta bo'yicha jami summa

    Qatorma-qator moslash jami summa ushlaydigan narsani o'tkazib yuborishi mumkin: o'zgargan komissiya qoidasi, parser tashlab ketgan qator.

  9. Muammo Qayta ishga tushirish bir narsani ikki marta tuzatadi

    Provayder xato topdi va kechagi hisobotni qayta yubordi.

  10. Yechim Har tuzatishning kaliti bor, qayta ishga tushirish hech narsani o'zgartirmaydi

    Daftarni o'zgartirishdan oldin job tuzatishni unique kalit bilan recon_fixes ga yozadi.

  11. Xulosa Xulosa

    Solishtirishning besh qoidasi.

Atamalar

Solishtirish (reconciliation)
O'z hisob daftaringizni o'sha pulning tashqi yozuvi bilan solishtirib, har bir farqni hal qilish.
Hisob-kitob hisoboti
To'lov provayderining haqiqatan o'tkazgan har bir yechish, qaytarish va komissiyasi bo'yicha kunlik (T+1) ro'yxati.
Eng kichik birlik (tiyin)
Pulni eng kichik birlikda (tiyin, sent) butun son sifatida saqlash, shunda yig'indilar aniq chiqadi.