Kinetic Edge Health

Module: Reconciliation Job (Transactions)

TC_ID_RECON_01
Title: Verify scheduled reconciliation job runs at configured time
Preconditions: Job scheduler configured
Steps:

Wait for scheduled time OR trigger job manually
Monitor job execution
Test Data: N/A
Expected Result: Job runs automatically at scheduled time without failure

TC_ID_RECON_02
Title: Verify reconciliation correctly matches transactions between Square and DB
Preconditions: Same transactions exist in Square and internal DB
Steps:

Run reconciliation job
Check comparison result
Test Data: Same payment_id, amount, status
Expected Result: Transactions marked as matched (no discrepancy)

TC_ID_RECON_03
Title: Verify mismatch detection when amount differs
Preconditions: Transaction exists in both systems with different amount
Steps:

Modify amount in DB (or mock difference)
Run reconciliation job
Test Data: Square amount = 100, DB amount = 90
Expected Result: Transaction flagged as mismatch

TC_ID_RECON_04
Title: Verify detection of missing transactions in internal system
Preconditions: Transaction exists in Square but not in DB
Steps:

Run reconciliation job
Test Data: Missing DB record
Expected Result: Transaction identified as missing in DB

TC_ID_RECON_05
Title: Verify reconciliation handles large volume of transactions
Preconditions: Bulk transactions available
Steps:

Run reconciliation job
Test Data: 1000+ transactions
Expected Result: All records processed correctly without performance issues or data loss