# 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](/api/documents/document-object) 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](/api/reporting/list-all-settlement-reports). - 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](/api/lending/get-loan-sale-summary). 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** > > #### 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 ```json [ { "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" } ] ```