Updated on June 9, 2023

Reconciliation Records

REST Sandbox URL: https://sandbox.4levers.com/NewReportsApi/api/Reports/reconciliation-records 

REST Production URL: https://reports-api.4levers.com/api/Reports/reconciliation-records   

Reconciliation Records Report provides the transactions matching summary report. Use the Reconciliation Records Report to get reconciliation details for specific transactions.

Request Example (REST Production URL)
 

GET: https://reports-api.4levers.com/api/Reports/reconciliation-records?DateFrom=2019-07-23&DateTo=2019-07-24

Request Parameters

 NameTypeRequiredDescription
 datefromdatetime✓determines the selection starting/ending time range
 datetodatetime✓
 entrymodearray integeroptional

nullable

transaction entry mode(s) numerical value.
 daterangetypeenumoptional

specify the output report date range type

Available Values:
 
  • systemdate
  • reconciliationdate
 reconciliationstatusenumoptional

specify the output report reconciliation status

Available Values:
 
  • pending
  • matching
  • mismatch
 transactionidinteger (int64)optionaltransaction identifier
 merchanttransactionidstringoptionaltransaction identifier provided by merchant
 processorsstring/arrayoptionalspecify one or more clearing processors
 processortransactionidstringoptionaltransaction identifier provided by the clearing processor
 paymentmethodsenumoptional

specify the payment method

required in case credit card is populated.

Available Values:
 
  • creditcard
  • ach
  • giftcard
 creditcardsenumoptional

specify a credit card type

Available Values:
 
  • visa
  • mastercard
  • diners
  • isracard
  • americanexpress
  • discover
  • jcb
  • visadebit
  • mastercarddebit
  • delta
  • electron
  • maestro
  • solo
  • interac
 transactiontypeenumoptional

specify a transaction type

Available Values:
 
  • verify
  • authorization
  • void
  • partialvoid
  • capture
  • partialcapture
  • charge
  • refund
  • partialrefund
  • credit
  • chargeback
  • retrieval
  • representment
  • arbitration
  • reversal
  • cancel
 paymenttypesenumoptional

specify the payment type

Available Values:
 
  • regular
  • recurring
  • installments
  • deferred
 serviceprovidersinteger/arrayoptionalenter your service provider id(s)
 operatorsinteger/arrayoptionalenter your operator id(s)
 accountsinteger/arrayoptionalenter your platform account id(s)
 subaccountsstring/arrayoptionalenter your sub-account id(s)
 skipintegeroptional
these parameters determine which records will be displayed in the report based on specified index number.to get from fifth to twentieth record specify skip = 4 and take = 16
 takeintegeroptional
 currenciesstring arrayoptional

enter currency type ids to filter sub-accounts by

Available Values:
 
  • CAD
  • USD
  • EUR
  • GBP
  • AUD
  • SGD
  • JPY
  • NZD

Response Parameters

 NameDescription
 transactionidtransaction identifier
 merchanttransactionidtransaction identifier provided by merchant
 processortransactionidtransaction identifier provided by the clearing processor
 systemdatesystem processing date
 merchantdatemerchant processing date
 paymentmethodselected payment method
 ccoraccountnumbercredit card number or bank account number depending on the selected payment method
 ccexpirationdatecredit card expiration date
 

token

 
payment token if applicable
 CCorAccountOwnerNamename on the credit card or bank account depending on the selected payment method
 amounttransaction amount
 currencytransaction currency
 transactiontypetype of the transaction
 reconciliationdatedate when the transaction matching has been performed
 reconciliationstatustransaction matching status
 reconciliationerrorcodetransaction matching error code
 reconciliationerrorcodedescriptiondescription of the transaction matching error
 chargebackdisputedatechargeback dispute date
 terminalidclearing terminal identifier
 servicepurchasedtypetype of the purchased service
 transactiondescriptiondescription of the transaction
 merchantfreetextmerchant comment on the transaction
 subaccountsub-account identifier
 platformaccountplatform account name
 performedbyservice/user that performed the reconciliation
 entrymode

nullable

transaction entry mode(s) numerical value.

 

				
					
[
  {
        "transactionId": "1999001140378921240",    
        "merchantTransactionId": "4",  
        "processorTransactionId": "d0e14e6a-f77c-4522-b4dd-bcc0b93db6ef",  
        "systemDate": "2022-03-23T14:30:38",   
        "merchantDate": "",    
        "settlementDate": "",  
        "reconciliationDate": "",  
        "reconciliationStatus": "Pending", 
        "reconciliationErrorCode": "", 
        "reconciliationErrorCodeDescription": "",  
        "transactionType": "Charge",   
        "transactionDescription": "Transaction Description",  
        "merchantFreeText": "Merchant Free Text",    
        "paymentMethod": "Visa",   
        "CCOrAccountOwnerName": "Eleanor Johnson",    
        "CCOrAccountOwnerId": "1", 
        "billingAddressEmail": "test@mail.net",    
        "billingAddressPhoneNumber": "",   
        "billingAddressСountry": "USA",   
        "billingAddressState": "FL",   
        "billingAddressAddressLine": "1000 1st Av",  
        "billingAddressСity": "Middleburg",   
        "billingAddressZipPostalCode": "10101",    
        "CCOrAccountIpAddress": "212.98.160.42",   
        "CCOrAccountNumber": "411111******1111",   
        "CCExpirationDate": "1225",    
        "token": "a5f29d91-0397-4ad6-b33a-0d2c9a90789b",   
        "amount": "1.00",  
        "currency": "USD", 
        "processor": "Emulator",   
        "dynamicDescriptor": "TestDescriptor", 
        "merchantId": "",  
        "terminalId": "",  
        "subAccount": "Test Account", 
        "platformAccount": "Test Account",    
        "transactionSource": "Test Tool", 
        "performedBy": "System"    
  },
  {
    "transactionId": "1999001140378921241",    
        "merchantTransactionId": "4",  
        "processorTransactionId": "d0e14e6a-f77c-4522-b4dd-bcc0b93db6ef",  
        "systemDate": "2022-03-23T14:30:38",   
        "merchantDate": "",    
        "settlementDate": "",  
        "reconciliationDate": "",  
        "reconciliationStatus": "Pending", 
        "reconciliationErrorCode": "", 
        "reconciliationErrorCodeDescription": "",  
        "transactionType": "Charge",   
        "transactionDescription": "Transaction Description",  
        "merchantFreeText": "Merchant Free Text",    
        "paymentMethod": "Visa",   
        "CCOrAccountOwnerName": "Eleanor Johnson",    
        "CCOrAccountOwnerId": "1", 
        "billingAddressEmail": "test@mail.net",    
        "billingAddressPhoneNumber": "",   
        "billingAddressСountry": "USA",   
        "billingAddressState": "FL",   
        "billingAddressAddressLine": "1000 1st Av",  
        "billingAddressСity": "Middleburg",   
        "billingAddressZipPostalCode": "10101",    
        "CCOrAccountIpAddress": "212.98.160.42",   
        "CCOrAccountNumber": "411111******1111",   
        "CCExpirationDate": "1225",    
        "token": "a5f29d91-0397-4ad6-b33a-0d2c9a90789b",   
        "amount": "1.00",  
        "currency": "USD", 
        "processor": "Emulator",   
        "dynamicDescriptor": "TestDescriptor", 
        "merchantId": "",  
        "terminalId": "",  
        "subAccount": "Test Account", 
        "platformAccount": "Test Account",    
        "transactionSource": "Test Tool", 
        "performedBy": "System"
  }
]