JUSPAY Unified Dashboard

Batch Chargeback

Overview

The Batch Chargeback module provides comprehensive bulk chargeback processing capabilities for handling multiple dispute and chargeback records simultaneously through CSV file uploads. It offers real-time progress tracking, status monitoring, and detailed reporting for all chargeback operations processed through the Juspay payment platform.

This module is designed for a wide range of users, including:

  • Finance Teams: For processing large volumes of chargebacks efficiently and monitoring financial impact across different dispute types and resolution outcomes with comprehensive financial logs.

  • Dispute Management Teams: For bulk chargeback processing, dispute resolution management, and tracking chargeback status across multiple order records with detailed dispute trails.

  • Operations Teams: To process chargeback and dispute data in bulk, track resolution status, and provide comprehensive dispute management for enhanced financial reconciliation.

Accessing the Module

  1. Log in to the Juspay dashboard.

  2. From the main navigation menu on the left, click on Payments.

  3. Select Bulk Operations from the Payments submenu.

  4. Click on the Chargeback tab from the bulk operations navigation.

  5. The navigation URL for this module is https://portal.juspay.in/batch/chargebackslink icon.

Batch Chargeback
Batch Chargeback

Step-by-Step Usage Instructions

Creating Batch Chargeback

Step 1: Access the Batch Chargeback Interface

  1. Navigate to the Batch Chargeback module using the steps above.

  2. You will see the main dashboard with a description: "This module helps in creating chargeback processing in bulk using a file upload. It provides a holistic view of the files uploaded. Upon clicking the filename in the table below a detailed view of each chargeback uploaded is displayed."

  3. The interface displays any previously uploaded batch chargeback files in a table format.

Step 2: Initiate New Batch Chargeback Upload

  1. Click the "Create Batch Chargeback" button (visible only to users with appropriate permissions).

  2. If maker-checker workflow is enabled for your account, you will first see a description modal:

    • Enter a description for the batch chargeback request in the text field.

    • Click "Submit" to proceed to the file upload interface.

  3. If maker-checker is not enabled, you will directly access the file upload interface.

Batch Chargeback
Batch Chargeback

Step 3: Prepare and Upload CSV File

  1. Download Sample File: Click on the sample file link to download the CSV template (batch_chargeback.csv).

  2. Prepare Your Data: Fill in your chargeback data following the CSV field specifications (see table below).

  3. File Limitations:

    • Maximum 1000 rows per file

    • CSV format only

    • File size limitations apply

  4. Upload Process:

    • Click "Choose File" or drag and drop your CSV file

    • The system validates the file format and structure

    • Mandatory fields are checked (Order ID, Amount, Dispute Status)

    • Column types are validated (Order ID as String, Amount as Number, Dispute Status as String)

Step 4: File Processing and Validation

  1. File Validation: The system performs the following checks:

    • CSV format validation

    • Mandatory field presence (orderid, amount, disputestatus)

    • Data type validation for each column

    • Dispute status validation (must be one of the allowed values)

    • Amount format validation

    • Row count validation (maximum 1000 rows)

  2. Error Handling: If validation fails, specific error messages are displayed:

    • Missing mandatory fields

    • Invalid dispute status values

    • Invalid amount format

    • File format errors

    • Row limit exceeded

  3. Successful Upload: Upon successful validation:

    • File is queued for processing

    • Batch ID is generated

    • Initial status is set to processing

    • Chargeback processing begins

Step 5: Monitor Processing Status

  1. Status Indicators:

    • ACCEPTED: Successfully processed chargebacks (Green indicator)

    • FAILED: Failed chargeback processing attempts (Red indicator)

    • QUEUED: Chargeback requests waiting in processing queue (Blue indicator)

Monitoring and Managing Batch Chargeback

Viewing Batch Chargeback Details

  1. Table View: The main interface displays all uploaded batch files with:

    • File Name: Name of the uploaded CSV file

    • File Upload Status: Current processing status with color-coded labels

    • Total Amount: Sum of chargeback amounts in the uploaded file

    • Date Created: File upload timestamp

    • Last Modified: Last update timestamp

    • Total Tasks: Number of chargeback requests in the file

    • Tasks Progress: Visual progress bar showing completion status

    Batch Chargeback - Table View
    Batch Chargeback - Table View

  2. Detailed View: Click on any filename to access detailed information:

    • Batch Details Card: Expandable/collapsible interface showing:

      • Batch ID: Unique identifier for the uploaded file

      • Date Created and Date Updated timestamps

      • Total Amount with currency formatting

      • Current status with color-coded indicators

    • Progress Statistics: Individual task counts for:

      • Total Accepted Tasks: Successfully processed chargebacks

      • Total Rejected Tasks: Failed chargeback processing attempts

      • Total Queued Tasks: Chargebacks in processing queue

    Batch Chargeback - Detailed View
    Batch Chargeback - Detailed View

Search and Filter Capabilities

  1. File Name Search:

    • Use the search input field with search icon

    • Enter filename to filter results

    • Search is case-sensitive and supports partial matches

    • Clear search using the cross icon

  2. Table Sorting:

    • Click column headers to sort data

    • Available sorting for: File Name, Status, Total Amount, Date Created, Total Tasks

    • Toggle between ascending and descending order

Data Export and Download

Downloading Processed Data

  1. Access Download: Click the "Download Data" button in the batch details view.

  2. CSV Export: Downloads include:

    • Serial numbers (S.No column)

    • All processed chargeback data with the following headers:

      • Order ID

      • Dispute Status

      • Amount

      • Processing Status

      • Resolution Date

      • Financial Impact

      • Task Status

      • Error Message

      • Created At

      • Updated At

  3. File Format:

    • CSV format with comma-separated values

    • Filename format: batch_chargeback.csv

    • Includes header row with column names

CSV File Upload Specifications

CSV Field Requirements

Scroll inside to view more
Field Name
Mandatory/Optional
Data Type
Description
Sample Value
Validation Rules
order_id
Mandatory
String
Order identifier for chargeback processing
"ORD_123456789"
Must be a valid order ID string, cannot be empty
dispute_status
Mandatory
String
Chargeback dispute status
"RECEIVED"
Must be one of: RECEIVED, RESOLVEDINMERCHANTFAVOUR, RESOLVEDINCUSTOMERFAVOUR
amount
Mandatory
Number
Chargeback amount for financial tracking
100.50
Must be a valid numeric value, supports decimal places

Dispute Status Validation Rules

Allowed Dispute Status Values:

  • RECEIVED: Chargeback received and under review

  • RESOLVED_IN_MERCHANT_FAVOUR: Dispute resolved favorably for merchant

  • RESOLVED_IN_CUSTOMER_FAVOUR: Dispute resolved favorably for customer

Validation Process:

  1. Status Check: Only the three specified status values are accepted

  2. Case Sensitivity: Status values are case-sensitive and must match exactly

  3. Format Validation: No additional characters or spaces allowed

  4. Business Logic: Status determines financial impact and reporting classification

Order ID Format Requirements

Order ID Specifications:

  • Format: Alphanumeric string identifier

  • Length: Must be non-empty string

  • Characters: Letters, numbers, underscores, and hyphens allowed

  • Case Sensitivity: Case-sensitive matching

  • Purpose: Links chargeback to specific order for tracking and reconciliation

Amount Validation Requirements

Amount Specifications:

  • Format: Numeric value with optional decimal places

  • Currency: System will use default currency configuration

  • Range: Must be positive value greater than 0

  • Decimal Places: Up to 2 decimal places supported

  • Valid Examples: "100", "100.50", "1500.75"

  • Invalid Examples: "-100", "abc", "100.555"

CSV Format Examples

Complete CSV Format with Sample Data:

File Upload Constraints

  • Maximum Rows: 1000 rows per CSV file

  • File Format: CSV (Comma Separated Values) only

  • Encoding: UTF-8 encoding recommended

  • File Size: Standard file size limitations apply

  • Column Order: Must match the specified header format (orderid, disputestatus, amount)

  • Empty Values: All fields are mandatory and cannot be empty

  • Dispute Status Restriction: Only the three specified status values are supported

Use Cases

Monthly Chargeback Processing

  1. Export chargeback data from dispute management systems

  2. Prepare CSV file with order IDs, dispute statuses, and amounts

  3. Upload file through Batch Chargeback interface

  4. Monitor processing status and download results for financial reconciliation

Dispute Resolution Management

  1. Prepare CSV with chargeback information for bulk status updates

  2. Include resolved dispute statuses for proper financial tracking

  3. Upload file for automated chargeback processing

  4. Track individual processing status and generate resolution reports

Financial Reconciliation

  1. Compile chargeback data from various payment sources

  2. Create CSV with order details, dispute statuses, and financial amounts

  3. Process bulk chargebacks and export results for accounting purposes

  4. Use downloaded chargeback data for financial impact analysis and reporting

Troubleshooting

File Upload Validation Errors:

  • "Invalid file format": Ensure file is in CSV format with proper comma separation

  • "Missing mandatory fields": Verify that orderid, disputestatus, and amount columns are present and not empty

  • "Row limit exceeded": Reduce file size to maximum 1000 rows per upload

  • "Invalid dispute status": Check that disputestatus field contains only allowed values (RECEIVED, RESOLVEDINMERCHANTFAVOUR, RESOLVEDINCUSTOMER_FAVOUR)

  • "Invalid amount format": Ensure amount field contains only valid numeric values with proper decimal formatting

Permissions and Roles

Access to the Batch Chargeback module is controlled by the following permissions:

  • Chargeback Module Access: Required for accessing the batch chargeback interface (ACL: chargeback)

  • Chargeback Write Permission: Required for creating and uploading batch chargeback files (ACL: chargeback with ReadWrite access)

  • Chargeback Read Permission: Needed to view batch chargeback status and download processed data (ACL: chargeback)

Last updated 5 months ago