If you need to build your own money in reconciliation processes or dashboards, follow this guide to find chargebacks, ACH returns, and other adjustments that are included with transfers.

You can learn more about the difference between batches and transfers in the How Money Moves guide.

The process

Choose a process to find transfer details. If you already have a TransferId, choose Find by transfer

If you need to find transfers that include returns and chargebacks by batch, use this approach.

1

Get list of batches

Make a GET request to /Query/batches/{entry}` to list batches by a paypoint. You can use filters and conditions to limit the responses.

cURL example
curl --request GET \
  --url https://api.payabli.com/api/Query/batches/476aacfed00?limitRecord=20&fromRecord=0&batchDate=2024-01-17 \
  --header 'requestToken: <API TOKEN>'
2

Check response for transfers with ACH returns and chargebacks

Now, check to see if the target batch has a transfer, and if the transfer had an ACH return or chargeback.

Check if the batch contains any data in the Transfer object:

  • If it doesn’t, it means that the batch hasn’t been transferred yet.
  • If it does, it means the batch has been transferred. The Transfer object contains the summary info about that transfer.

Check in the Transfer object to see if ReturnedAmount or ChargeBackAmount is 0. If the amount is anything other than 0, then it means the transfer included ACH returns or chargebacks.

Example response
{
    "Summary": {
        "totalRecords": 2,
        "totalAmount": 222.22,
        "totalNetAmount": 0.0,
        "totalPages": 1,
        "pageSize": 20,
        "pageidentifier": "x19smxocx..."
    },
    "Records": [
        {
            "IdBatch": 110297,
            "BatchNumber": "batch_1000_combined_01-17-2024",
            "ConnectorName": " ",
            "BatchDate": "2024-01-17T00:00:00",
            "BatchAmount": 222.22,
            "BatchFeesAmount": 0.00,
            "BatchAuthAmount": 222.22,
            "BatchReleasedAmount": 0.00,
            "BatchHoldAmount": 0.00,
            "BatchReturnedAmount": -140.00,
            "BatchRefundAmount": 0.00,
            "BatchSplitAmount": 11.60,
            "BatchStatus": 3,
            "BatchRecords": 1,
            "PaypointId": 123,
            "PaypointName": "San Valentino Acres Neighborhood Assn, LLC",
            "PaypointDba": "San Valentino Acres",
            "ParentOrgName": "HOAManager",
            "externalPaypointID": null,
            "Method": "combined",
            "ExpectedDepositDate": "2024-01-22T00:00:00",
            "TransferDate": "2024-01-20T00:00:00",
            "Transfer": {
                "TransferId": 10101, // Copy the TransferId for the next step
                "TransferDate": "2024-01-20T23:45:01.877",
                "Processor": " ",
                "TransferStatus": 3,
                "GrossAmount": 222.22,
                "ChargeBackAmount": 0.00, // If amount isn't 0, then this transfer has chargebacks in it
                "ReturnedAmount": -140.00, // If Amount isn't 0, then this transfer has ACH returns in it 
                "RefundAmount": 0.00,
                "HoldAmount": 0.00,
                "ReleasedAmount": 0.00,
                "BillingFeesAmount": 0.00,
                "ThirdPartyPaidAmount": 0.00,
                "AdjustmentsAmount": 0.00,
                "NetFundedAmount": 93.82
            }
        }
    
    ]
}

Copy the TransferId for the next step.

3

Get transfer details

Fetch the transfer details to know about the specific ACH returns or chargebacks processed in the transfer.

Use the TransferId from the last step and make a GET request to /Query/transferDetails/{entry}/{transferId}. You can use filters and conditions to limit the responses.

curl example
curl --request GET \
  --url https://api.payabli.com/api/Query/transferDetails/476aacfed00/10101?limitRecord=20&fromRecord=0 \
  --header 'requestToken: <API TOKEN>'

Review the response to get details about individual transactions with chargebacks or returns.

Go further

You can use this process to reconcile other adjustments to your transfers. Just follow the steps and look for these values instead of ChargeBackAmount and ReturnedAmount:

  • holdAmount
  • releasedAmount
  • billingFeesAmount
  • thirdPartyPaidAmount
  • adjustmentsAmount