Updated on September 14, 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

Name Type Required Description
1 dateFrom datetime ✓ determines the selection starting time range
2 dateTo datetime ✓ determines the selection ending time range
entrymode array integer optional nullable
transaction entry mode(s) numerical value.
daterangetype enum optional specify the output report date range type
Available Values:
  • systemdate
  • reconciliationdate
reconciliationstatus enum optional specify the output report reconciliation status
Available Values:
  • pending
  • matching
  • mismatch
transactionid integer (int64) optional transaction identifier
merchanttransactionid string optional transaction identifier provided by merchant
processors string/array optional specify one or more clearing processors
processortransactionid string optional transaction identifier provided by the clearing processor
paymentmethods enum optional specify the payment method
required in case credit card is populated.
Available Values:
  • creditcard
  • ach
  • giftcard
creditcards enum optional specify a credit card type
Available Values:
  • visa
  • mastercard
  • diners
  • isracard
  • americanexpress
  • discover
  • jcb
  • visadebit
  • mastercarddebit
  • delta
  • electron
  • maestro
  • solo
  • interac
transactiontype enum optional specify a transaction type
Available Values:
  • verify
  • authorization
  • void
  • partialvoid
  • capture
  • partialcapture
  • charge
  • refund
  • partialrefund
  • credit
  • chargeback
  • retrieval
  • representment
  • arbitration
  • reversal
  • cancel
paymenttypes enum optional specify the payment type
Available Values:
  • regular
  • recurring
  • installments
  • deferred
serviceproviders integer/array optional enter your service provider id(s)
operators integer/array optional enter your operator id(s)
accounts integer/array optional enter your platform account id(s)
subaccounts string/array optional enter your sub-account id(s)
skip integer optional
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
take integer optional
currencies string array optional enter currency type ids to filter sub-accounts by
Available Values:
  • CAD
  • USD
  • EUR
  • GBP
  • AUD
  • SGD
  • JPY
  • NZD

Response Parameters

Name Description
transactionid transaction identifier
merchanttransactionid transaction identifier provided by merchant
processortransactionid transaction identifier provided by the clearing processor
systemdate system processing date
merchantdate merchant processing date
paymentmethod selected payment method
ccoraccountnumber credit card number or bank account number depending on the selected payment method
ccexpirationdate credit card expiration date
token
payment token if applicable
CCorAccountOwnerName name on the credit card or bank account depending on the selected payment method
amount transaction amount
currency transaction currency
transactiontype type of the transaction
reconciliationdate date when the transaction matching has been performed
reconciliationstatus transaction matching status
reconciliationerrorcode transaction matching error code
reconciliationerrorcodedescription description of the transaction matching error
chargebackdisputedate chargeback dispute date
terminalid clearing terminal identifier
servicepurchasedtype type of the purchased service
transactiondescription description of the transaction
merchantfreetext merchant comment on the transaction
subaccount sub-account identifier
platformaccount platform account name
performedby service/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"
  }
]