Crego APIs
APIs DocHome Page
Web Apps
  • Jupiter
  • Venus
APIs DocHome Page
Web Apps
  • Jupiter
  • Venus
  1. Loans
  • Back to home
  • LMS
  • EMIs
    • List EMI
      GET
    • List Settlements
      GET
    • Restructure
      POST
    • Calculate EMI
      POST
    • Run EOD
      POST
    • Request Tranche
      POST
    • Outstanding data
      PUT
  • Records
    • Request Approval
      PUT
    • Initiate Excess Payment Refund
      POST
    • Initiate Adjustment for Cashback & Holdback
      POST
    • Get Single Record
      GET
    • Record Listing
      GET
    • Create Record
      POST
    • Mark Processed
      PUT
    • Unmatched
      GET
    • Export record
      PUT
    • Bulk Create Records
      POST
  • Topups
    • List Topups
      GET
    • Unschedule a scheduled topup
      PUT
    • Reinitiate Payout
      POST
    • Check Line Amount
      PUT
    • Create Topup
      POST
    • Update Topup
      PATCH
    • Bulk Topup Create
      POST
    • Re Run Checks
      GET
    • Invoice Parse
      PATCH
  • Accounts
    • Initiate Disbursement
    • Initiate Loan Params
    • Create Account
    • Close Loan Account
    • Refresh Limit
    • Get Loan Params
    • Get Summary
    • Reset RPS
    • Update Loan Params
  • Payouts
    • Retry Failed Payout
    • Create Payout
    • Payout Callback
    • Process Payout
    • Unmatched Payouts
    • List Payouts
    • Export Payout for Bank
  • Loans
    • Export Cashback
      GET
    • Get Emi Amount
      GET
    • Get Loan Summary
      GET
    • List Loans with Excess Balance
      GET
    • Initiate Adjustment
      POST
    • Initiate Refund
      POST
    • List Loans
      GET
  • Line Details
    • Filter Line Details
    • Create
    • Update
    • Get by type
    • Bulk Internal
    • Retrieve
  • Loan Data
    • Create
    • Update
    • Retrieve
  • Fee
    • Get Fee Demands
    • Bulk Create Fee
    • Create Fee
    • List Fee
    • Fee Details
    • Delete Fee
  • Extra Data
    • Update Extra Data
    • List Extra Data
  • Topup Group
    • Create Topup Group
    • List Topup Group
    • Update TopupGroup
  1. Loans

List Loans with Excess Balance

preprod
https://preprod.api.crego.io
preprod
https://preprod.api.crego.io
GET
/v1/lms/loans/excess_balance/
Last modified:2025-02-12 12:30:59

Request

Authorization
Provide your bearer token in the
Authorization
header when making requests to protected resources.
Example:
Authorization: Bearer ********************
Query Params
tab
string 
required
options: cashback/holdback
Example:
cashback
search
string 
optional
expand
string 
optional
Example:
borrower

Request samples

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET 'https://preprod.api.crego.io/v1/lms/loans/excess_balance/?tab=cashback&search&expand=borrower'

Responses

🟢200OK
application/json
Body
count
integer 
required
current_page
integer 
required
page_size
integer 
required
results
array [object {86}] 
required
id
string 
required
created_at
number 
required
updated_at
number 
required
type
string 
required
day
integer 
required
index
integer 
required
transaction_date
number  | null 
required
date
integer  | number 
required
amount
integer 
required
principal_paid
integer 
required
principal_outstanding
integer 
required
originator_principal_paid
integer  | number 
required
originator_principal_outstanding
integer 
required
co_lender_principal_paid
integer  | number 
required
co_lender_principal_outstanding
integer 
required
interest_paid
integer 
required
interest_outstanding
integer 
required
originator_interest_paid
integer 
required
originator_interest_outstanding
integer 
required
co_lender_interest_paid
integer 
required
co_lender_interest_outstanding
integer 
required
overdue_paid
integer 
required
overdue_outstanding
integer  | number 
required
originator_overdue_paid
integer 
required
originator_overdue_outstanding
integer 
required
co_lender_overdue_paid
integer 
required
co_lender_overdue_outstanding
integer 
required
penal_paid
integer 
required
penal_outstanding
integer  | number 
required
penal_tax_paid
integer 
required
penal_tax_outstanding
integer 
required
originator_penal_paid
integer  | number 
required
originator_penal_outstanding
integer 
required
co_lender_penal_paid
integer  | number 
required
co_lender_penal_outstanding
integer 
required
principal_waived
integer 
required
interest_waived
integer 
required
overdue_waived
integer 
required
penal_waived
integer 
required
penal_tax_collected
integer 
required
penal_tax_waived
integer 
required
subvention_ack
integer  | number 
required
originator_subvention_ack
integer  | number 
required
co_lender_subvention_ack
integer  | number 
required
cashback_available
integer  | number 
required
originator_cashback_available
integer 
required
co_lender_cashback_available
integer 
required
cashback_adjusted
integer 
required
cashback_released
integer 
required
holdback_available
integer 
required
holdback_adjusted
integer 
required
holdback_released
integer 
required
partner_interest_outstanding
integer 
required
partner_overdue_outstanding
integer  | number 
required
partner_penal_outstanding
integer  | number 
required
partner_interest_ack
integer 
required
partner_overdue_ack
integer 
required
partner_penal_ack
integer 
required
record_principal
integer 
required
record_interest
integer 
required
record_overdue
integer 
required
record_penal
integer 
required
record_penal_tax
integer 
required
originator_record_principal
integer  | number 
required
originator_record_interest
integer 
required
originator_record_overdue
integer 
required
originator_record_penal
integer  | number 
required
originator_record_penal_tax
integer 
required
co_lender_record_principal
integer  | number 
required
co_lender_record_interest
integer 
required
co_lender_record_overdue
integer 
required
co_lender_record_penal
integer  | number 
required
co_lender_record_penal_tax
integer 
required
remaining_amount
integer 
required
sent_to_gl
boolean 
required
revert_sent_to_gl
boolean 
required
sent_penal_charge_to_gl
boolean 
required
due_amount
integer 
required
dpd
integer 
required
asset_category_date
null 
required
peak_dpd
integer 
required
to_be_deleted
boolean 
required
account
string 
required
loan
object 
required
record
string  | null 
required
payout
string  | null 
required
Example
{"count":20,"current_page":1,"page_size":15,"results":[{"id":"10dc3f22-4bf1-4e31-a3e1-65ca23f4eb18","created_at":1737277395.7291234,"updated_at":1737277395.7300422,"type":"record","day":1,"index":2069687,"transaction_date":1737277387.901774,"date":1737225000.0,"amount":5000.0,"principal_paid":5000.0,"principal_outstanding":0.0,"originator_principal_paid":5000.0,"originator_principal_outstanding":0.0,"co_lender_principal_paid":0.0,"co_lender_principal_outstanding":0.0,"interest_paid":0.0,"interest_outstanding":0.0,"originator_interest_paid":0.0,"originator_interest_outstanding":0.0,"co_lender_interest_paid":0.0,"co_lender_interest_outstanding":0.0,"overdue_paid":0.0,"overdue_outstanding":0.0,"originator_overdue_paid":0.0,"originator_overdue_outstanding":0.0,"co_lender_overdue_paid":0.0,"co_lender_overdue_outstanding":0.0,"penal_paid":0.0,"penal_outstanding":0.0,"penal_tax_paid":0.0,"penal_tax_outstanding":0.0,"originator_penal_paid":0.0,"originator_penal_outstanding":0.0,"co_lender_penal_paid":0.0,"co_lender_penal_outstanding":0.0,"principal_waived":0.0,"interest_waived":0.0,"overdue_waived":0.0,"penal_waived":0.0,"penal_tax_collected":0.0,"penal_tax_waived":0.0,"subvention_ack":0.0,"originator_subvention_ack":0.0,"co_lender_subvention_ack":0.0,"cashback_available":500.0,"originator_cashback_available":500.0,"co_lender_cashback_available":0.0,"cashback_adjusted":0.0,"cashback_released":0.0,"holdback_available":0.0,"holdback_adjusted":0.0,"holdback_released":0.0,"partner_interest_outstanding":0.0,"partner_overdue_outstanding":0.0,"partner_penal_outstanding":0.0,"partner_interest_ack":0.0,"partner_overdue_ack":0.0,"partner_penal_ack":0.0,"record_principal":5000.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":5000.0,"originator_record_interest":0.0,"originator_record_overdue":0.0,"originator_record_penal":0.0,"originator_record_penal_tax":0.0,"co_lender_record_principal":0.0,"co_lender_record_interest":0.0,"co_lender_record_overdue":0.0,"co_lender_record_penal":0.0,"co_lender_record_penal_tax":0.0,"remaining_amount":15000.0,"sent_to_gl":true,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":true,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"54e08a9a-2e40-447a-b9f0-5a947518cf84","loan":{"id":"9b0ebbb4-901d-44d6-a1e4-581638cdc5d9","created_at":1737277387.9961476,"updated_at":1737277393.2354877,"ref_id":"TOP00000RLE","index":156,"status":"closed","loan_amount":5000.0,"subvention_amount":500.0,"holdback_amount":0.0,"payout_amount":4500.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1737277387.901774,"loan_start_date":1737225000.0,"due_date":1742409000.0,"close_date":1737277387.901774,"close_value_date":1737225000.0,"revert_date":null,"revert_value_date":null,"subvention_end_date":1737225000.0,"dpd":0.0,"debit_bank":{"id":"87ef6c21-e6c8-415c-9f16-8d6b195e6a0e","ifsc":"HDFC0000044","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"917020019713523","created_at":1721805842.927797,"updated_at":1721805842.9494624,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"AXIS BANK CORPORATE ACCOUNT 917020019713523"},"credit_bank":{},"utr":"7868574364577","back_date_found":false,"back_date_marked_on":null,"is_processed":true,"is_imported":false,"account":"54e08a9a-2e40-447a-b9f0-5a947518cf84","topup":{"id":"9b0ebbb4-901d-44d6-a1e4-581638cdc5d9","payout_amount":4500.0,"loan_amount":5000.0,"created_at":1737269804.3382666,"updated_at":1737277387.9428127,"ref_id":"TOP00000RLE","index":156,"status":"disbursed","type":"invoice","invoice_date":"2025-01-19","invoice_due_date":null,"invoice_no":"y657868","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":5000.0,"disbursal_amount":5000.0,"subvention_amount":500.0,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1737225000.0,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1737277363.5173466,"custom_bank":{},"tags":["back_date"],"scheduled_at":null,"disbursement_date":1737225000.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"Back date invoice: Invoice Date 2025-01-19","hold_remark":null,"rejection_remark":null,"anomaly_found":true,"anomaly_approved":true,"is_check_completed":true,"uploaded_by":"lender","uploaded_by_id":"6da08401-b1f7-46ec-9013-2a9d7bc6185c","is_imported":false,"account":"54e08a9a-2e40-447a-b9f0-5a947518cf84","same_topup":null}},"record":"4dd0024b-6175-417e-87d4-0170d2f18230","payout":null},{"id":"1d553e11-5b86-4401-935c-d246adbe4ae0","created_at":1721898180.364749,"updated_at":1721898180.365113,"type":"cashback_adjustment","day":0,"index":12712,"transaction_date":null,"date":1721898160.548645,"amount":2.0,"principal_paid":2000.0,"principal_outstanding":0.0,"originator_principal_paid":0.0,"originator_principal_outstanding":0.0,"co_lender_principal_paid":0.0,"co_lender_prin
Modified at 2025-02-12 12:30:59
Previous
Get Loan Summary
Next
Initiate Adjustment
Built with