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 there after.

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"
  }
]