View the payment history on your loans – payments API

As a Prosper investor, you may have invested in one or more loan listings that have been posted to the Prosper marketplace. The payments API allows you to retrieve the payment history on a single loan, or a list of loans that you own. If you have purchased a Note on the loan, the payments API will return historical payment history on your pro-rata portion of the loan.

By default, the payments API returns payment history for the last 90 days. You can retrieve payment transactions prior to the default 90-day window by passing a “transaction effective date” query parameter. This query will retrieve payment transactions within the last 90-days of the transaction effective date, inclusive of the date.

The payments API returns all payments in historical order in which the loan payments have been made. If you pass in multiple loan numbers as query parameters to the API, you will receive payments made to the loans in historical order.

Note: Only qualified institutional investors can purchase whole loans.

loans/payments API

Use GET /loans/payments/?loan_number={loan_number} to retrieve payment history for a single loan.

Use GET /loans/payments/?loan_number={loan_number1},{loan_numbe2},{loan_number3}… to retrieve payment history for multiple loans.

Supported methods

GET

Example URIs

GET /loans/payments/?loan_number={loan_number}
   Authorization: bearer 
   Accept: application/json

 

GET /loans/payments/?loan_number={loan_number1},{loan_number2},{loan_number3}
   Authorization: bearer 
   Accept: application/json

 

HTTP Headers

Field name Expected value Required?
Authorization bearer <access_token> Y
Accept application/json Y
timezone By default, all dates returned in the response are in UTC. However, you can specify the timezone in full format.Examples: America/Los_Angeles
America/New_York
N

Query parameters

General parameters

Name Description
offset Defaults to 0.

The starting payment history object within the query result set when paginating.

When making calls that may return a large result set, it is beneficial to page the result set.

By paginating your result set, you will get a much faster response than when requesting a larger, potentially large, data set for the limit value.

Example: If your first call specifies an offset of 0, and a limit of 25, your second call would have an offset value of 25. Your third call would have an offset value of 50. Your fourth call would have an offset value of 75, and so forth.

limit The default limit is 25.

The maximum limit is 100.

Determines how many payments objects to return in the result set. There may be less remaining objects than the value you specify for the limit.

Request parameters

Name Type Description
loan_number integer The identifier of the loan.

When passing multiple loan numbers, separate each loan number with a comma.

Note: You may input as many as 25 individual loan numbers, but only 100 maximum payment objects can be returned (25 default payments limit, 100 maximum payments limit).

Example one: passing a single loan number.
GET /loans/payments/?loan_number=7447

Example two: passing multiple loan numbers.
GET /loans/payments/?loan_number=7447,90876,453262,73236

transaction_effective_date date To get payment transactions prior to the default 90-day window, pass this query parameter in the format transaction_effective_date={yyyy-mm-dd}. This will retrieve payment transactions within the last 90-days of the transaction effective date, inclusive of the date.

Example: passing a single loan number, retrieving payment history in the 90-day window since January 29, 2016.
GET /loans/payments/?loan_number=7447&transaction_effective_date=2016-01-29

loans/payments response object elements

Name Type Description
loan_number integer The unique id of the loan.
transaction_id integer Unique id associated with this loan payment transaction.
funds_available_date datetime Date and time this loan payment’s funds are available in your account.
investor_disbursement_date datetime Date and time this loan payment’s funds are disbursed to the investor.
transaction_effective_date datetime Date and time this loan payment transaction is determined.
account_effective_date datetime Date and time this loan payment appears within your Prosper account.
payment_transaction_code string
  • ACH – Automated clearing house
  • BD – Bank draft
  • CAP – Collection agency
  • DSP – Dispute
  • NSF – Insufficient funds
  • BDF – Bank draft return
  • ACHF – ACH Failure
  • CAPF – Collection Agency Payment Failure
  • SEQR – Payment reversal due to the need to reverse a prior payment
  • INTR – Interest reversal
  • CRINT – Interest reversal
  • CK – Check payment
  • CKF – Check payment reversal
  • LFA – Late Fee Adjustment
  • NSFA – NSF Adjustment
  • LFA2 – Late Fee Adjustment without Cash Disbursement
  • NSFA2 – NSF Adjustment without Cash Disbursement
  • PROMO – A loan payment made on behalf of the borrower as part of a promotional program
  • PROMF – A PROMO reversal
  • CRCRE – A loan payment made on behalf of the borrower as a customer relations credit
  • CRCRF – A CRCRE reversal
  • SIFA – Settled in full credit, or loan payment made to zero out the balance of a loan. Does not result in a cash disbursement to investors.
  • SIFAR – A SIFA reversal.
  • UNWND – Flat cancel a loan
  • ACHF2 – ACH Failure with no NSF
  • CKF2 – Check Failure with no NSF
  • CRCF2 – CRCRE Failure with no NSF
  • CAPF2 – Collection agency payment Failure with no NSF
  • PRMF2 – PROMO reversal with no NSF
  • SIFR2 – A SIFA reversal with no NSF
  • DBSA – Debt Sale transaction made to zero out the balance of a loan. Does not result in a cash disbursement to investors
  • DBSAF – Debt Sale Failure
  • PMT – Catch all generic payment
  • PMTF – Catch all generic payment Failure
  • PMTF2 – Catch all generic payment with no NSF
  • BDF2 – Bank draft return with no NSF
payment_status string
  • Process – Payment is within ACH window and is in-flight
  • Success – Payment is successful
  • Fail – Payment failed
  • Dispute – Payment disputed
match_back_id string Unique identifier for the payment transaction.
prior_match_back_id string For a reversal/failure of a payment, this identifier will
map back to the match_back_id.
loan_payment_cashflow_type string
  • Payment – Standard loan payment by the borrower
  • Adjustment – Payment adjustment, likely due to payment re-application
  • Chargeback – Payment chargeback
  • DebtSale – Proceeds from loan debt sale
  • Other
payment_amount decimal The total amount of this loan payment applied to the investor’s account.

This amount is the sum of:

  • principal_amount
  • interest_amount
  • late_fee_amount
  • nsf_fee_amount

This amount does not include:

  • service_fee_amount
  • collection fee_amount
principal_amount decimal The amount of this loan payment applied to the loan’s principal.
This is part of the payment applied to the investor’s account.
interest_amount decimal The amount of interest applied to this loan payment amount.

This is part of the payment applied to the investor’s account.

origination_interest_amount decimal This will always return 0.
late_fee_amount decimal The late fees (if any) applied to this loan payment.

This is part of the payment applied to the investor’s account.

service_fee_amount decimal The service fees (if any) applied to this loan payment amount.

This part of the payment is collected by Prosper for servicing the loan.

collection_fee_amount decimal The collection fees (if any) charged to collect a loan that has gone into collections.

This part of the payment is paid to the third-party collection agency that collects on a defaulted loan.

gl_reward_amount decimal This element has been deprecated.
nsf_fee_amount decimal The fee charged for insufficient funds in the loan payment funding account at time of the loan payment.

This is part of the payment applied to the investor’s account.

pre_days_past_due integer The days past due on this loan payment prior to applying the payment.
post_days_past_due integer The days past due on this loan payment after applying the late payment.
resulting_principal_balance decimal The amount of principal remaining on the loan once this loan payment has been applied to the loan.

Errors

The following errors may be returned by the loans/payments/ API:

Error Code: Description:
APP1007 The maximum records allowed per page(limit) is 100.
APP1007 Loan number is not valid.
APP1007 Invalid Request. The maximum number of unique loan_number values allowed per request is 25.
SEC0004 This endpoint requires a user token.
PYMT0002 We were unable to retrieve any payment history for loan_numbers: {loan_numbers}. Please verify that the loan_number is valid and the user is an investor on the loan.
SYS0001 We were unable to process your request at this time. Please try again later.

Examples

Example one: Retrieving payment history for a single loan number. In this example, there have been four payments made on the loan in the past 90 days, and the value represents the pro-rata value paid on a Note.

Request:

GET loans/payments/?loan_number=481822&transaction_effective_date=2016-03-05

 
 
 

Response:

{
  "result": [
    {
      "loan_number": 481822,
      "transaction_id": 96905674,
      "funds_available_date": "2016-03-09T19:24:24.877+0000",
      "investor_disbursement_date": "2016-03-09T08:00:00.000+0000",
      "transaction_effective_date": "2016-03-02T08:00:00.000+0000",
      "account_effective_date": "2016-03-02T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "ACC3435571A59C80FF2700942FBB3EB5001A6FA7",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 0.9224,
      "principal_amount": 0.5599,
      "interest_amount": 0.3625,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.0186,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 22.8737
    },
    {
      "loan_number": 481822,
      "transaction_id": 94432324,
      "funds_available_date": "2016-02-09T09:53:17.407+0000",
      "investor_disbursement_date": "2016-02-09T08:00:00.000+0000",
      "transaction_effective_date": "2016-02-02T08:00:00.000+0000",
      "account_effective_date": "2016-02-02T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "7B6733A01A01AABC31CFFEC932BA7A00A02EBC37",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 0.9224,
      "principal_amount": 0.5266,
      "interest_amount": 0.3958,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.0203,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 23.4336
    },
    {
      "loan_number": 481822,
      "transaction_id": 92164585,
      "funds_available_date": "2016-01-08T19:23:04.443+0000",
      "investor_disbursement_date": "2016-01-08T08:00:00.000+0000",
      "transaction_effective_date": "2016-01-02T08:00:00.000+0000",
      "account_effective_date": "2016-01-02T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "B5F9D1772CAD0FA69429D6714B0C93160B3DF0C4",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 0.9224,
      "principal_amount": 0.5176,
      "interest_amount": 0.4047,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.0208,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 23.9601
    }
  ],
  "result_count": 3,
  "total_count": 3
}

 
 
 

Example two: The following example shows a call retrieving payment history for a single loan:

Request:

GET loans/payments/?loan_number=253953

 
 
 

Response:

{
  "result": [
    {
      "loan_number": "253953",
      "transaction_id": 79119014,
      "funds_available_date": "2015-05-05T08:06:58.107+0000",
      "investor_disbursement_date": "2015-05-05T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-28T07:00:00.000+0000",
      "account_effective_date": "2015-04-28T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "84F69212DF5489135E854BD027C232EF868E8944",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 76.58,
      "interest_amount": 23.42,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.79,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2796.95
    },
    {
      "loan_number": "253953",
      "transaction_id": 79119015,
      "funds_available_date": "2015-05-05T08:06:58.373+0000",
      "investor_disbursement_date": "2015-05-05T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-28T07:00:00.000+0000",
      "account_effective_date": "2015-04-28T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "023FD2B5A4976E535749CD23E5FD32BB10B86D65",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 100,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2696.95
    },
    {
      "loan_number": "253953",
      "transaction_id": 78696405,
      "funds_available_date": "2015-04-24T15:34:39.293+0000",
      "investor_disbursement_date": "2015-04-24T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-18T07:00:00.000+0000",
      "account_effective_date": "2015-04-18T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "F632E5AA04A5A325A70656AF5BF127BD465D238A",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 90.34,
      "interest_amount": 9.66,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.32,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2873.53
    },
    {
      "loan_number": "253953",
      "transaction_id": 78572121,
      "funds_available_date": "2015-04-21T05:40:56.787+0000",
      "investor_disbursement_date": "2015-04-21T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-14T07:00:00.000+0000",
      "account_effective_date": "2015-04-14T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "CD969F30B9C403FC5162B092401D94B155960C47",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 97.42,
      "interest_amount": 2.58,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.09,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3063.87
    },
    {
      "loan_number": "253953",
      "transaction_id": 78572122,
      "funds_available_date": "2015-04-21T05:40:57.133+0000",
      "investor_disbursement_date": "2015-04-21T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-14T07:00:00.000+0000",
      "account_effective_date": "2015-04-14T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "724BCE65EDE60BA9BCE54E4911DB4E6B18E20839",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 100,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2963.87
    },
    {
      "loan_number": "253953",
      "transaction_id": 78528406,
      "funds_available_date": "2015-04-20T07:15:55.580+0000",
      "investor_disbursement_date": "2015-04-20T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-13T07:00:00.000+0000",
      "account_effective_date": "2015-04-13T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "DDA231B71BCF18E83698B0D0510146F4D7AE46BE",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 97.34,
      "interest_amount": 2.66,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.09,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3161.29
    },
    {
      "loan_number": "253953",
      "transaction_id": 78436733,
      "funds_available_date": "2015-04-17T11:59:26.907+0000",
      "investor_disbursement_date": "2015-04-17T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-12T07:00:00.000+0000",
      "account_effective_date": "2015-04-12T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "82FD407FA8D65E402752EB80A3014E4516973F66",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 83.66,
      "interest_amount": 16.34,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.55,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3258.63
    },
    {
      "loan_number": "253953",
      "transaction_id": 78264047,
      "funds_available_date": "2015-04-13T07:02:55.090+0000",
      "investor_disbursement_date": "2015-04-13T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-06T07:00:00.000+0000",
      "account_effective_date": "2015-04-06T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "FAAD7D6BEAB04016E4058F8075E8F3E4F99E7FF6",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 169.26,
      "principal_amount": 80.67,
      "interest_amount": 88.59,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 2.98,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3542.29
    },
    {
      "loan_number": "253953",
      "transaction_id": 78264048,
      "funds_available_date": "2015-04-13T07:02:55.503+0000",
      "investor_disbursement_date": "2015-04-13T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-06T07:00:00.000+0000",
      "account_effective_date": "2015-04-06T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "E66A92A041969FFA21B283CF3D413CB0B8576E7F",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 100,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3442.29
    },
    {
      "loan_number": "253953",
      "transaction_id": 78264049,
      "funds_available_date": "2015-04-13T07:02:55.823+0000",
      "investor_disbursement_date": "2015-04-13T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-06T07:00:00.000+0000",
      "account_effective_date": "2015-04-06T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "F3C070C023EAB5ABF210F06C2DCD07354E3F3A55",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 100,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3342.29
    },
    {
      "loan_number": "253953",
      "transaction_id": 77106371,
      "funds_available_date": "2015-03-13T11:49:23.887+0000",
      "investor_disbursement_date": "2015-03-13T07:00:00.000+0000",
      "transaction_effective_date": "2015-03-07T08:00:00.000+0000",
      "account_effective_date": "2015-03-07T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "4CCE2D2C4E7AA2E95AC4AF0A0A97EEB1CC77B6E2",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 169.26,
      "principal_amount": 123.46,
      "interest_amount": 45.8,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 1.54,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3622.96
    },
    {
      "loan_number": "253953",
      "transaction_id": 76534340,
      "funds_available_date": "2015-02-27T13:18:54.303+0000",
      "investor_disbursement_date": "2015-02-27T08:00:00.000+0000",
      "transaction_effective_date": "2015-02-20T08:00:00.000+0000",
      "account_effective_date": "2015-02-20T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "131A5B7190197908FAD74C202479F58272419AC8",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 25,
      "principal_amount": 10.47,
      "interest_amount": 14.53,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.49,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3746.42
    },
    {
      "loan_number": "253953",
      "transaction_id": 76404746,
      "funds_available_date": "2015-02-24T09:31:00.030+0000",
      "investor_disbursement_date": "2015-02-24T09:31:00.030+0000",
      "transaction_effective_date": "2015-02-17T08:00:00.000+0000",
      "account_effective_date": "2015-02-17T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "DB29DAE4A41D589850E6D1763268B20DF241B87E",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 6.36,
      "principal_amount": 0,
      "interest_amount": 6.36,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.21,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3756.89
    },
    {
      "loan_number": "253953",
      "transaction_id": 76358763,
      "funds_available_date": "2015-02-23T18:28:38.357+0000",
      "investor_disbursement_date": "2015-02-23T18:28:38.357+0000",
      "transaction_effective_date": "2015-02-15T08:00:00.000+0000",
      "account_effective_date": "2015-02-15T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "6EE478248BD5A9E4D302FA0BD6348E74F1CD29B5",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 0.55,
      "principal_amount": 0,
      "interest_amount": 0.55,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.02,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3756.89
    },
    {
      "loan_number": "253953",
      "transaction_id": 76358758,
      "funds_available_date": "2015-02-23T18:28:37.027+0000",
      "investor_disbursement_date": "2015-02-23T18:28:37.027+0000",
      "transaction_effective_date": "2015-02-13T08:00:00.000+0000",
      "account_effective_date": "2015-02-13T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "E94FBF6812710AA90C8732942F830FC366936C10",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 25,
      "principal_amount": 25,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3756.89
    },
    {
      "loan_number": "253953",
      "transaction_id": 76358760,
      "funds_available_date": "2015-02-23T18:28:37.767+0000",
      "investor_disbursement_date": "2015-02-23T18:28:37.767+0000",
      "transaction_effective_date": "2015-02-13T08:00:00.000+0000",
      "account_effective_date": "2015-02-13T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "5B42F820AEB6F8B1902385424BF6AC45743170D7",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 169.26,
      "principal_amount": 118.4,
      "interest_amount": 50.86,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 1.71,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3781.89
    },
    {
      "loan_number": "253953",
      "transaction_id": 75595575,
      "funds_available_date": "2015-02-04T11:08:19.660+0000",
      "investor_disbursement_date": "2015-02-04T11:08:19.660+0000",
      "transaction_effective_date": "2015-01-28T08:00:00.000+0000",
      "account_effective_date": "2015-01-28T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "450CEBAF7EADBB121E0EAB91BA30771ADDF73D97",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 169.26,
      "principal_amount": 74.71,
      "interest_amount": 94.55,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 3.18,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3925.29
    },
    {
      "loan_number": "253953",
      "transaction_id": 75595576,
      "funds_available_date": "2015-02-04T11:08:19.973+0000",
      "investor_disbursement_date": "2015-02-04T11:08:19.973+0000",
      "transaction_effective_date": "2015-01-28T08:00:00.000+0000",
      "account_effective_date": "2015-01-28T08:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "73114E5DFE19A673A97B88E28056CF4F27B4B96B",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 25,
      "principal_amount": 25,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3900.29
    }
  ],
  "result_count": 18,
  "total_count": 18
}

 
 
 

Example three: The following example shows a call retrieving payment history for multiple loans, limiting the response to 35 payment objects. Note: The response has been shortened due to space considerations.

Request:

GET loans/payments/?loan_number=185408,253953,345643,456321,187456,199756,208763&limit=35

 
 
 
Response:

{
  "result": [
    {
      "loan_number": "185408",
      "transaction_effective_date": "2015-04-28T07:00:00.000+0000",
      "account_effective_date": "2015-04-30T07:00:00.000+0000",
      "payment_transaction_code": "ACHF2",
      "payment_status": "Fail",
      "match_back_id": "AC0DAC13622BF4828AF878F5C06B1AA951D4D517",
      "prior_match_back_id": "CD84DC59D7E619CC80C253B5C6BB328FD3AE825D",
      "payment_amount": -227.5,
      "principal_amount": -159.03,
      "interest_amount": -68.47,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": -2.45,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 4697.91
    },
    {
      "loan_number": "185408",
      "transaction_effective_date": "2015-04-28T07:00:00.000+0000",
      "account_effective_date": "2015-04-28T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Fail",
      "match_back_id": "CD84DC59D7E619CC80C253B5C6BB328FD3AE825D",
      "prior_match_back_id": "AC0DAC13622BF4828AF878F5C06B1AA951D4D517",
      "payment_amount": 227.5,
      "principal_amount": 159.03,
      "interest_amount": 68.47,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 2.45,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 4538.88
    },
    {
      "loan_number": "253953",
      "transaction_id": 79119014,
      "funds_available_date": "2015-05-05T08:06:58.107+0000",
      "investor_disbursement_date": "2015-05-05T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-28T07:00:00.000+0000",
      "account_effective_date": "2015-04-28T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "84F69212DF5489135E854BD027C232EF868E8944",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 76.58,
      "interest_amount": 23.42,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.79,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2796.95
    },
    {
      "loan_number": "253953",
      "transaction_id": 79119015,
      "funds_available_date": "2015-05-05T08:06:58.373+0000",
      "investor_disbursement_date": "2015-05-05T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-28T07:00:00.000+0000",
      "account_effective_date": "2015-04-28T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "023FD2B5A4976E535749CD23E5FD32BB10B86D65",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 100,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2696.95
    },
    {
      "loan_number": "253953",
      "transaction_id": 78696405,
      "funds_available_date": "2015-04-24T15:34:39.293+0000",
      "investor_disbursement_date": "2015-04-24T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-18T07:00:00.000+0000",
      "account_effective_date": "2015-04-18T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "F632E5AA04A5A325A70656AF5BF127BD465D238A",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 90.34,
      "interest_amount": 9.66,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.32,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2873.53
    },
    {
      "loan_number": "253953",
      "transaction_id": 78572121,
      "funds_available_date": "2015-04-21T05:40:56.787+0000",
      "investor_disbursement_date": "2015-04-21T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-14T07:00:00.000+0000",
      "account_effective_date": "2015-04-14T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "CD969F30B9C403FC5162B092401D94B155960C47",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 97.42,
      "interest_amount": 2.58,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.09,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 3063.87
    },
    {
      "loan_number": "253953",
      "transaction_id": 78572122,
      "funds_available_date": "2015-04-21T05:40:57.133+0000",
      "investor_disbursement_date": "2015-04-21T07:00:00.000+0000",
      "transaction_effective_date": "2015-04-14T07:00:00.000+0000",
      "account_effective_date": "2015-04-14T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Success",
      "match_back_id": "724BCE65EDE60BA9BCE54E4911DB4E6B18E20839",
      "loan_payment_cashflow_type": "Payment",
      "payment_amount": 100,
      "principal_amount": 100,
      "interest_amount": 0,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 2963.87
    },
    {
      "loan_number": "185408",
      "transaction_effective_date": "2015-04-09T07:00:00.000+0000",
      "account_effective_date": "2015-04-09T07:00:00.000+0000",
      "payment_transaction_code": "ACH",
      "payment_status": "Fail",
      "match_back_id": "58BA4A0EBB6940BBA0EB3D1E906FCC76DA28CA1C",
      "prior_match_back_id": "58E15C5D7DD3C3204836E6C552BFF6C4F2454B66",
      "payment_amount": 227.5,
      "principal_amount": 220.31,
      "interest_amount": 7.19,
      "origination_interest_amount": 0,
      "late_fee_amount": 0,
      "service_fee_amount": 0.26,
      "collection_fee_amount": 0,
      "gl_reward_amount": 0,
      "nsf_fee_amount": 0,
      "pre_days_past_due": 0,
      "resulting_principal_balance": 4470.29
    },
    {
     ...
    },
    {
     ...
    }
],
  "result_count": 35,
  "total_count": 35
}