Loans

Loan Reports

Column will generate daily snapshot summary reports for all loans on your platform. The cut-off time for daily snapshots is 7:00pm PT (inclusive). After daily summary reports are generated, you will get webhook events. All reports are available in CSV, JSON and Parquet formats. You can use our Document API to obtain daily summary reports. You can also download them directly from our Dashboard. If you want to list all available daily summary reports, please use our Reporting API.

  • Report type: loan_daily_summary
  • Webhook event: reporting.loan_daily_summary.completed

To check the population of loans for purchase at the beginning of each day and total purchase prices, you can filter loan_daily_summary reports for loans with non-zero sale_price. You can also reference the loan sale summary endpoint.

Each row in daily summary reports contains a loan with the below details. Loans that have been paid off or canceled are shown only in the daily reports up to their paid-off/cancellation day and are excluded from reports thereafter.

Note

All balance values are in the main unit of loan currencies (e.g., dollars for USD).

Column
Description
Type
currency_code
Currency of the loan (e.g., USD)
string
daily_accrued_fee
New servicing fees payable to your platform accrued on the effective_date
string
daily_accrued_interest
New interest receivable for Column and your platform accrued on the effective_date
string
daily_disbursed_principal
New principal receivable disbursed on the effective_date
string
daily_fee_rate
Daily servicing fee rate on the effective_date (e.g., 0.0001 for 0.01%)
string
daily_interest_rate
Daily interest rate on the effective_date (e.g., 0.001 for 0.10%)
string
daily_paid_fee
New servicing fees payable paid to your platform for loan sales on effective_date
string
daily_paid_interest
New interest receivable paid for Column and your platform on effective_date
string
daily_paid_principal
New principal receivable paid for Column and your platform on effective_date
string
daily_retained_accrued_interest
New interest receivable for Column only accrued on effective_date
string
daily_retained_paid_interest
New interest receivable paid for Column only on effective_date
string
daily_retained_paid_principal
New principal receivable paid for Column only on effective_date
string
daily_sold_interest
New interest receivable sold to your platform on effective_date
string
daily_sold_principal
New principal receivable sold to your platform on effective_date
string
effective_date
Date of this summary. Format: YYYY-MM-DD
string
loan_id
ID of the loan
string
loan_program_id
ID of the loan program
string
retained_by_column
Indicates if the loan is retained by Column
boolean
sale_price
Sale price at the end of the effective_date
string
status
Status of the loan
string
total_fee
Total servicing fees payable to your platform
string
total_interest
Total interest receivable for Column and your platform
string
total_principal
Total principal receivable
string
total_retained_interest
Total interest receivable for Column only
string
total_retained_principal
Total principal receivable for Column only
string
total_seasoned_fee
Total seasoned servicing fees payable that are available to be paid to your platform on loan sales
string
total_seasoned_interest
Total seasoned interest receivable available for sale
string
total_seasoned_principal
Total seasoned principal receivable available for sale on the effective_date
string

Sample Report in JSON Format

[
  {
    "currency_code": "USD",
    "daily_accrued_fee": "17.1",
    "daily_accrued_interest": "171",
    "daily_disbursed_principal": "18000",
    "daily_fee_rate": "0.0001",
    "daily_interest_rate": "0.001",
    "daily_paid_fee": "0",
    "daily_paid_interest": "0",
    "daily_paid_principal": "0",
    "daily_paid_retained_interest": "0",
    "daily_retained_accrued_interest": "171",
    "daily_sold_interest": "0",
    "daily_sold_principal": "0",
    "effective_date": "2025-06-23",
    "loan_id": "loan_2zElxSDsVKavI303PZoVHnoEDFN",
    "loan_program_id": "lpgm_30ynUQLwsKxi02qif7jyI1I5CjO",
    "retained_by_column": false,
    "sale_price": "136979.2",
    "status": "current",
    "total_fee": "114",
    "total_interest": "1140",
    "total_principal": "171000",
    "total_retained_interest": "1140",
    "total_retained_principal": "171000",
    "total_seasoned_fee": "108.8",
    "total_seasoned_interest": "1088",
    "total_seasoned_principal": "136000"
  },
  {
    "currency_code": "USD",
    "daily_accrued_fee": "17.1",
    "daily_accrued_interest": "171",
    "daily_disbursed_principal": "18000",
    "daily_fee_rate": "0.0001",
    "daily_interest_rate": "0.001",
    "daily_paid_fee": "0",
    "daily_paid_interest": "0",
    "daily_paid_principal": "0",
    "daily_paid_retained_interest": "0",
    "daily_retained_accrued_interest": "171",
    "daily_sold_interest": "0",
    "daily_sold_principal": "0",
    "effective_date": "2025-06-23",
    "loan_id": "loan_2zElxUD5sXlpFoYM3xFZ0KHspvR",
    "loan_program_id": "lpgm_30ynUWXxIfQOvLV1PRzJ2wFi3DZ",
    "retained_by_column": false,
    "sale_price": "91819",
    "status": "current",
    "total_fee": "114",
    "total_interest": "1140",
    "total_principal": "171000",
    "total_retained_interest": "1140",
    "total_retained_principal": "171000",
    "total_seasoned_fee": "91",
    "total_seasoned_interest": "910",
    "total_seasoned_principal": "91000"
  }
]
Previous
Payments
Next
Overview