Skip to main content

Reconciliation Management

Overview​

The Reconciliation Management system provides a daily overview of transaction batches and their reconciliation status. This system helps administrators track and manage the reconciliation process for all transactions across different publishers.

Daily Reconciliation Dashboard​

Daily Reconciliation Dashboard

Key Metrics​

The dashboard displays several important metrics for each date:

  • Total Batches: Total number of transaction batches processed
  • Reconciled: Number of successfully reconciled batches
  • Unreconciled: Number of batches pending reconciliation
  • Running: Number of batches currently in processing
  • Failed: Number of batches that failed reconciliation

Status Types​

  • Running: Batch is currently being processed
  • Failed: Reconciliation process encountered an error
  • Unreconciled: Batch is pending reconciliation
  • Reconciled: Batch has been successfully reconciled
  • Date range selection available (e.g., 01/04/2025 - 30/04/2025)
  • Search functionality for finding specific transactions
  • Status filter for viewing specific reconciliation states

Daily Summary View​

Daily Summary View

Publisher-wise Breakdown​

For each day, transactions are grouped by publisher showing:

  • Publisher Name: Name of the service provider
  • Total Amount: Aggregate transaction amount for the publisher
  • Total Interchange Fee: Total fees for the publisher's transactions
  • Status: Current processing status
  • Finished At: Completion timestamp

Batch Details​

Batch Details

Overview Section​

Each batch contains the following summary information:

  • Total Amount: Sum of all transaction amounts in the batch
  • Total Interchange Fee: Sum of all interchange fees for the batch

Transaction Details​

Each transaction within a batch includes:

  • Charge ID: Unique identifier for the charge
  • User ID: Identifier of the user who made the transaction
  • Contract ID: Associated contract identifier
  • Finalized At: Timestamp of transaction finalization
  • Finalized Amount: Final transaction amount
  • Interchange Fee: Fee charged for the transaction
  • Charge Type: Type of charge (e.g., Subscription)
  • Status: Current reconciliation status

Best Practices​

  1. Regular Monitoring

    • Check the dashboard daily for any failed reconciliations
    • Review unreconciled transactions promptly

  2. Issue Resolution

    • Investigate failed reconciliations immediately
    • Track patterns in reconciliation failures for systemic issues

  3. Batch Management

    • Monitor running batches for completion
    • Verify reconciled amounts match expected totals

Troubleshooting​

Common Issues​

  1. Failed Reconciliation

    • Verify transaction details
    • Check for system errors in logs
    • Confirm all required data is present

  2. Stuck in Running State

    • Check system resources
    • Verify external service connectivity
    • Consider manual intervention if persists

Resolution Steps​

  1. For failed batches:

    • Review error logs
    • Verify transaction data
    • Attempt manual reconciliation if necessary

  2. For unreconciled batches:

    • Check for missing information
    • Verify system connectivity
    • Process manually if system issues persist