Implement Incremental Reconciliation for Large Transaction Batches

[Pidoko257]

Description

Split monthly reconciliation into daily chunks to reduce single-operation lock times and improve system responsiveness during reconciliation.

Acceptance Criteria

• Reconciliation no longer causes query timeouts
• System remains responsive with < 100ms added latency during process
• No data loss or duplication
• Progress tracked

Implementation Notes

• Refactor reconciliation job to use daily batches
• Add state tracking for resumable reconciliation
• Test with large transaction volumes

[Didi-vi]

@Didi-vi has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi, please assign me

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

[Cjay-Cyber-2]

@Cjay-Cyber-2 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

i would like to work on this kindly assign me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Cjay-Cyber-2 to this issue.

[chiemezie1]

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

Hi, I'd like to work on this issue.

I've gone through the requirements, understand the problem, and have the skills needed to implement a solution.

Could you please assign it to me?

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

[Happybello365]

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

Hello i would like to work on this issue

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

[drips-wave]

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

🧑‍💻 @Happybello365: 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 🌊