Add payment reconciliation scheduled job to detect unmatched transactions

[RUKAYAT-CODER]

Overview

Payments recorded in the local database may differ from the payment provider's ledger due to webhook failures or processing errors. Without periodic reconciliation, revenue discrepancies go undetected, causing financial reporting errors.

Specifications

Features:

• Daily reconciliation job that compares local payments with the payment provider's transaction list.
• Alert on any unmatched or mismatched transactions.

Tasks:

• Create PaymentReconciliationJob scheduled daily via @Cron.
• Fetch transactions from the payment provider API for the previous day.
• Compare against Payment table records by provider transaction ID.
• Log discrepancies as structured PAYMENT_RECONCILIATION_MISMATCH audit events.
• Expose GET /payments/reconciliation/report (admin-only) for last run results.

Impacted Files:

• New src/payments/reconciliation/reconciliation.service.ts
• src/audit-log/enums/audit-action.enum.ts

Acceptance Criteria

• Reconciliation job runs daily at 02:00 UTC.
• Mismatched transactions appear in the audit log.
• Admin endpoint returns the last reconciliation report.

[Adesam007-pr3dator]

@Adesam007-pr3dator has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi, I would love to work this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Adesam007-pr3dator to this issue.

[Whiznificent]

@Whiznificent has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

gm maintainer i can fix this issue up asap

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Whiznificent to this issue.

[funds0033-cmyk]

@funds0033-cmyk has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I've gone through your project. I will execute this flawlessly and submit within 24

ℹ️ Repo Maintainers: To accept this application, review their application or assign @funds0033-cmyk to this issue.

[drips-wave]

Congratulations, @Whiznificent! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @Whiznificent: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊