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
  • 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_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":9.04,"originator_subvention_ack":0.0,"co_lender_subvention_ack":0.0,"cashback_available":11.620000000000001,"originator_cashback_available":0.0,"co_lender_cashback_available":0.0,"cashback_adjusted":2.0,"cashback_released":2.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":2000.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":0.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"69fd0af6-3310-4fed-9bf8-1ad4ef612e31","loan":{"id":"4541ca25-cf98-4b75-a2c8-db7d5a6b9e69","created_at":1715603352.0,"updated_at":1722534019.245295,"ref_id":"CT00000LEL","index":1025,"status":"closed","loan_amount":1975.34,"subvention_amount":24.66,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715603352.0,"loan_start_date":1714566552.0,"due_date":1717093800.0,"close_date":1715495210.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1718195189.0,"dpd":0.0,"debit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"credit_bank":{"id":"f8a5a165-8fe7-43ec-9575-c27654fa7a83","ifsc":"HDFC000384748","tags":[],"account_no":"100010203920","banking_id":"a7680d00-2b0d-4f60-aa4a-8b237790efe9","created_at":1715602859.95,"updated_at":1715602859.95,"is_verified":false,"program_ids":[],"account_type":"Current","account_holder_name":"HDFC BANK"},"utr":"SBINO0010134","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"69fd0af6-3310-4fed-9bf8-1ad4ef612e31","topup":{"id":"5dbe9d3b-62b6-410d-b83e-63c63d03fecb","payout_amount":1975.34,"loan_amount":2000.0,"created_at":1715603029.0,"updated_at":1722533992.462126,"ref_id":"CT00000LEL","index":1025,"status":"disbursed","type":"invoice","invoice_date":"2024-04-03","invoice_due_date":"2024-04-03","invoice_no":"Smart03","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":2000.0,"disbursal_amount":2000.0,"subvention_amount":24.66,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1718195189.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715603189.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1714501800.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"69fd0af6-3310-4fed-9bf8-1ad4ef612e31","same_topup":""}},"record":"5262be97-7b9a-4402-9356-ba7740cab759","payout":null},{"id":"1e8aaafd-494c-46c0-aa14-6f3aa6b617f8","created_at":1715414658.7380743,"updated_at":1715414658.7405508,"type":"record","day":0,"index":6569,"transaction_date":null,"date":1715241858.700619,"amount":124124.0,"principal_paid":124124.0,"principal_outstanding":0.0,"originator_principal_paid":0.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":938.58,"originator_cashback_available":0.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":124124.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":41793.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","loan":{"id":"6bcc120e-5041-40f9-82ec-15e50adbde77","created_at":1715414323.0,"updated_at":1722534017.7280881,"ref_id":"CT00000EGG","index":982,"status":"closed","loan_amount":123185.42,"subvention_amount":938.58,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715414324.0,"loan_start_date":1715241524.0,"due_date":1717353000.0,"close_date":1715241859.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1717400902.0,"dpd":0.0,"debit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"credit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"utr":"SCBZeeutr2","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","topup":{"id":"9aa7d97e-32a1-49cd-b21c-988dbad01404","payout_amount":123185.42,"loan_amount":124124.0,"created_at":1715413685.0,"updated_at":1722533988.5553238,"ref_id":"CT00000EGG","index":982,"status":"disbursed","type":"invoice","invoice_date":"2024-05-09","invoice_due_date":"2024-06-03","invoice_no":"zee16B","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":124124.0,"disbursal_amount":124124.0,"subvention_amount":938.58,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1717400902.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715413702.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1715193000.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","same_topup":""}},"record":"453cde1b-ba6f-490a-a911-3033bfd6ee29","payout":null},{"id":"21d03193-dc12-4e9e-b58b-961c2fc295de","created_at":1715414658.738024,"updated_at":1715414658.7403853,"type":"record","day":0,"index":6568,"transaction_date":null,"date":1715241858.696547,"amount":85235.0,"principal_paid":85235.0,"principal_outstanding":0.0,"originator_principal_paid":0.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":644.52,"originator_cashback_available":0.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":85235.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":165917.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","loan":{"id":"0633c84b-5257-41e0-afec-acc6d2a70a0b","created_at":1715414323.0,"updated_at":1722534017.7612212,"ref_id":"CT0000052B","index":983,"status":"closed","loan_amount":84590.48,"subvention_amount":644.52,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715414323.0,"loan_start_date":1715241523.0,"due_date":1717353000.0,"close_date":1715241859.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1717400902.0,"dpd":0.0,"debit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"credit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"utr":"SCBZeeutr3","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","topup":{"id":"6cf0bbf5-0ac1-4f93-9af3-f507ac0f9e17","payout_amount":84590.48,"loan_amount":85235.0,"created_at":1715413686.0,"updated_at":1722533988.6199949,"ref_id":"CT0000052B","index":983,"status":"disbursed","type":"invoice","invoice_date":"2024-05-09","invoice_due_date":"2024-06-03","invoice_no":"zee15B","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":85235.0,"disbursal_amount":85235.0,"subvention_amount":644.52,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1717400902.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715413702.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1715193000.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","same_topup":""}},"record":"453cde1b-ba6f-490a-a911-3033bfd6ee29","payout":null},{"id":"21d9b82a-e34b-481f-b466-69b06ecfd2c0","created_at":1725884364.794106,"updated_at":1725884365.86545,"type":"record","day":21,"index":409464,"transaction_date":1723119564.794102,"date":1722773964.767524,"amount":42965.0,"principal_paid":42845.0,"principal_outstanding":0.0,"originator_principal_paid":29991.499999999996,"originator_principal_outstanding":0.0,"co_lender_principal_paid":12853.5,"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":120.0,"penal_outstanding":0.0,"penal_tax_paid":0.0,"penal_tax_outstanding":0.0,"originator_penal_paid":84.0,"originator_penal_outstanding":0.0,"co_lender_penal_paid":36.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":100.0,"originator_subvention_ack":70.0,"co_lender_subvention_ack":30.0,"cashback_available":450.0,"originator_cashback_available":450.0,"co_lender_cashback_available":450.0,"cashback_adjusted":0.0,"cashback_released":0.0,"holdback_available":0.0,"holdback_adjusted":0.0,"holdback_released":0.0,"partner_interest_outstanding":5.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":42845.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":120.0,"record_penal_tax":0.0,"originator_record_principal":29991.499999999996,"originator_record_interest":0.0,"originator_record_overdue":0.0,"originator_record_penal":84.0,"originator_record_penal_tax":0.0,"co_lender_record_principal":12853.5,"co_lender_record_interest":0.0,"co_lender_record_overdue":0.0,"co_lender_record_penal":36.0,"co_lender_record_penal_tax":0.0,"remaining_amount":147035.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":15,"to_be_deleted":false,"account":"ebbeb520-734d-4b71-b995-a1adbf842eb1","loan":{"id":"e16290bd-cd3b-4ab9-a2a4-713dbccc5f9a","created_at":1723119247.4410212,"updated_at":1723119247.4420633,"ref_id":"TOP0000YG8A","index":1361,"status":"closed","loan_amount":42845.0,"subvention_amount":550.0,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1723119247.319588,"loan_start_date":1720981800.0,"due_date":1721413800.0,"close_date":1722773962.503967,"close_value_date":1722773962.50396,"revert_date":null,"revert_value_date":null,"subvention_end_date":1722946411.723602,"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":{"id":"aaffddc2-1119-4a59-ae4d-d50dd8956f10","ifsc":"HDFC0000240","tags":[],"company":"def9a516-56ab-4a3b-af0c-e37c85b89b1a","account_no":"9999999999999999","created_at":1713246306.9866714,"updated_at":1713246307.0006177,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"Adani Wilmar Limited"},"utr":"ACC002","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"ebbeb520-734d-4b71-b995-a1adbf842eb1","topup":{"id":"2fbb01ab-02a9-4bdb-8d17-4ac3818a0065","payout_amount":42295.0,"loan_amount":42845.0,"created_at":1722946345.9417408,"updated_at":1723119247.379746,"ref_id":"TOP0000YG8A","index":1361,"status":"disbursed","type":"invoice","invoice_date":"2024-07-15","invoice_due_date":null,"invoice_no":"ACC0001","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":42845.0,"disbursal_amount":42845.0,"subvention_amount":550.0,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1722946411.723602,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1722946411.7526956,"custom_bank":{},"tags":["back_date"],"scheduled_at":null,"disbursement_date":1720981800.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"Back date invoice: Invoice Date 2024-07-15","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":"ebbeb520-734d-4b71-b995-a1adbf842eb1","same_topup":null}},"record":"d3b1e4ad-6968-4aef-8974-bc3fbe91b56c","payout":null},{"id":"26210d5f-0228-4fe6-973c-614e9887acca","created_at":1715426198.0245461,"updated_at":1715426198.0265336,"type":"record","day":0,"index":6015,"transaction_date":null,"date":1714562197.956676,"amount":750.0,"principal_paid":1500.0,"principal_outstanding":0.0,"originator_principal_paid":0.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":5.55,"originator_subvention_ack":0.0,"co_lender_subvention_ack":0.0,"cashback_available":12.939999999999998,"originator_cashback_available":0.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":750.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":1050.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"7b3bd634-af25-42bd-a94a-98212c445ed1","loan":{"id":"dd673d4c-fe72-40ab-873a-f5594c6408a7","created_at":1715425939.0,"updated_at":1722534018.684885,"ref_id":"CT00000Q6Q","index":1003,"status":"closed","loan_amount":1481.51,"subvention_amount":18.49,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715425939.0,"loan_start_date":1713784339.0,"due_date":1716316200.0,"close_date":1714562198.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1718017888.0,"dpd":0.0,"debit_bank":{"id":"667608d5-b338-4642-a4c3-9620e0d7595b","ifsc":"ICIC0001420","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714649582.3723164,"updated_at":1714649591.6950285,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh gupta"},"credit_bank":{"id":"3897f668-2990-47bc-a23f-cea3eff11ffa","ifsc":"ICICI00038474803","tags":[],"account_no":"68495248003","banking_id":"a7680d00-2b0d-4f60-aa4a-8b237790efe9","created_at":1715420788.744,"updated_at":1715420788.744,"is_verified":false,"program_ids":[],"account_type":"Current","account_holder_name":"Axis co."},"utr":"HDFC2020390","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"7b3bd634-af25-42bd-a94a-98212c445ed1","topup":{"id":"ede46676-ec3f-44d7-91e1-ac25b5ef3324","payout_amount":1481.51,"loan_amount":1500.0,"created_at":1715425852.0,"updated_at":1722533990.458376,"ref_id":"CT00000Q6Q","index":1003,"status":"disbursed","type":"invoice","invoice_date":"2024-04-01","invoice_due_date":null,"invoice_no":"shree25","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":1500.0,"disbursal_amount":1500.0,"subvention_amount":18.49,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1718017888.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715425888.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1713724200.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"7b3bd634-af25-42bd-a94a-98212c445ed1","same_topup":""}},"record":"7234cfb9-13a8-4a40-a61f-fb2a45b6a2af","payout":null},{"id":"2f0aa711-0687-403d-869d-9c21544822ca","created_at":1729664981.6472301,"updated_at":1729664981.6476033,"type":"cashback_adjustment","day":41,"index":797265,"transaction_date":1729664981.601328,"date":1729664967.2894988,"amount":12.0,"principal_paid":10000.0,"principal_outstanding":0.0,"originator_principal_paid":10000.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":140.0,"overdue_outstanding":0.0,"originator_overdue_paid":140.0,"originator_overdue_outstanding":0.0,"co_lender_overdue_paid":0.0,"co_lender_overdue_outstanding":0.0,"penal_paid":96.0,"penal_outstanding":0.0,"penal_tax_paid":0.0,"penal_tax_outstanding":0.0,"originator_penal_paid":96.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":14.0,"originator_subvention_ack":14.0,"co_lender_subvention_ack":0.0,"cashback_available":4.0,"originator_cashback_available":16.0,"co_lender_cashback_available":0.0,"cashback_adjusted":12.0,"cashback_released":0.0,"holdback_available":0.0,"holdback_adjusted":0.0,"holdback_released":0.0,"partner_interest_outstanding":4.0,"partner_overdue_outstanding":29.0,"partner_penal_outstanding":5.0,"partner_interest_ack":0.0,"partner_overdue_ack":29.0,"partner_penal_ack":5.0,"record_principal":10000.0,"record_interest":0.0,"record_overdue":140.0,"record_penal":96.0,"record_penal_tax":0.0,"originator_record_principal":10000.0,"originator_record_interest":0.0,"originator_record_overdue":140.0,"originator_record_penal":96.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":189764.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":6,"to_be_deleted":false,"account":"3167152d-b893-48f7-83fe-09c13c6d3157","loan":{"id":"217429cd-2685-471d-bea2-bf68ca2c313f","created_at":1721047153.0521595,"updated_at":1722685057.5041049,"ref_id":"TOP00005867","index":1267,"status":"closed","loan_amount":10000.0,"subvention_amount":30.0,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1721047152.9938304,"loan_start_date":1718389800.0,"due_date":1718821800.0,"close_date":1721888559.869086,"close_value_date":1721888559.869081,"revert_date":null,"revert_value_date":null,"subvention_end_date":1721047140.964256,"dpd":0.0,"debit_bank":null,"credit_bank":{"id":"aaffddc2-1119-4a59-ae4d-d50dd8956f10","ifsc":"HDFC0000240","tags":[],"company":"def9a516-56ab-4a3b-af0c-e37c85b89b1a","account_no":"9999999999999999","created_at":1713246306.9866714,"updated_at":1713246307.0006177,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"Adani Wilmar Limited"},"utr":"123123123","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"3167152d-b893-48f7-83fe-09c13c6d3157","topup":{"id":"8998d2ef-e932-40e5-9dfb-12d75ed7968a","payout_amount":9500.0,"loan_amount":10000.0,"created_at":1721047140.890974,"updated_at":1722534011.8754911,"ref_id":"TOP00005867","index":1267,"status":"disbursed","type":"invoice","invoice_date":"2024-07-01","invoice_due_date":null,"invoice_no":"FixedSubvention2","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":10000.0,"disbursal_amount":10000.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":1721047140.964256,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1721047140.9704745,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1718389800.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":null,"hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"lender","uploaded_by_id":"6da08401-b1f7-46ec-9013-2a9d7bc6185c","is_imported":false,"account":"3167152d-b893-48f7-83fe-09c13c6d3157","same_topup":null}},"record":"1024f15f-f2cf-4bb0-81a3-91761e7ffcd8","payout":null},{"id":"66035963-662b-483c-bef4-dae0c4801dcd","created_at":1734417785.9122646,"updated_at":1734417785.9145615,"type":"cashback_refund","day":153,"index":1711337,"transaction_date":1734417785.793336,"date":1734287400.0,"amount":250.0,"principal_paid":0.0,"principal_outstanding":40000.0,"originator_principal_paid":0.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":2271.3972602739727,"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":1622.7123287671227,"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":77.0,"originator_subvention_ack":0.0,"co_lender_subvention_ack":0.0,"cashback_available":173.0,"originator_cashback_available":0.0,"co_lender_cashback_available":0.0,"cashback_adjusted":0.0,"cashback_released":250.0,"holdback_available":0.0,"holdback_adjusted":0.0,"holdback_released":0.0,"partner_interest_outstanding":0.0,"partner_overdue_outstanding":53.01369863013698,"partner_penal_outstanding":53.01369863013698,"partner_interest_ack":0.0,"partner_overdue_ack":0.0,"partner_penal_ack":0.0,"record_principal":0.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":0.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":147,"asset_category_date":null,"peak_dpd":148,"to_be_deleted":false,"account":"7524b6f0-de91-46de-8a5e-74466bd629cb","loan":{"id":"879276fa-487f-46df-a585-60b0eea45ca2","created_at":1720787304.8415408,"updated_at":1722595405.217818,"ref_id":"TOP00009AX5","index":1261,"status":"closed","loan_amount":40000.0,"subvention_amount":500.0,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1720787304.8252606,"loan_start_date":1709836200.0,"due_date":1710268200.0,"close_date":1720506689.873576,"close_value_date":1720506689.873569,"revert_date":null,"revert_value_date":null,"subvention_end_date":1722083239.904218,"dpd":0.0,"debit_bank":null,"credit_bank":{"id":"aaffddc2-1119-4a59-ae4d-d50dd8956f10","ifsc":"HDFC0000240","tags":[],"company":"def9a516-56ab-4a3b-af0c-e37c85b89b1a","account_no":"9999999999999999","created_at":1713246306.9866714,"updated_at":1713246307.0006177,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"Adani Wilmar Limited"},"utr":"1qasdfgytrd","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"7524b6f0-de91-46de-8a5e-74466bd629cb","topup":{"id":"d77c7bec-d0e7-4890-abf5-e399dbdda25a","payout_amount":39500.0,"loan_amount":40000.0,"created_at":1720787208.6149883,"updated_at":1722534011.418151,"ref_id":"TOP00009AX5","index":1261,"status":"disbursed","type":"invoice","invoice_date":"2024-03-08","invoice_due_date":null,"invoice_no":"IRAC1","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":40000.0,"disbursal_amount":40000.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":1722083239.904218,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1720787239.9109156,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1709836200.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":null,"hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"lender","uploaded_by_id":"6da08401-b1f7-46ec-9013-2a9d7bc6185c","is_imported":false,"account":"7524b6f0-de91-46de-8a5e-74466bd629cb","same_topup":null}},"record":null,"payout":"b2453bf5-9e31-4878-a469-9775aa695c07"},{"id":"72f1223d-1b7c-4934-ae51-55857fe0203f","created_at":1715414658.7379746,"updated_at":1715414658.74022,"type":"record","day":0,"index":6567,"transaction_date":null,"date":1715241858.691148,"amount":5674.0,"principal_paid":5674.0,"principal_outstanding":0.0,"originator_principal_paid":0.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":33.58,"originator_cashback_available":0.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":5674.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":251152.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","loan":{"id":"67809de2-3ace-4511-b5ec-f4802889daa7","created_at":1715414324.0,"updated_at":1722534017.9134421,"ref_id":"CT000004YG","index":980,"status":"closed","loan_amount":5640.42,"subvention_amount":33.58,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715414324.0,"loan_start_date":1715241524.0,"due_date":1716921000.0,"close_date":1715241859.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1716968903.0,"dpd":0.0,"debit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"credit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"utr":"scbet5wesdgg","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","topup":{"id":"1b45f4ed-b805-4154-a1d2-26135dc46b7d","payout_amount":5640.42,"loan_amount":5674.0,"created_at":1715413684.0,"updated_at":1722533988.325411,"ref_id":"CT000004YG","index":980,"status":"disbursed","type":"invoice","invoice_date":"2024-05-04","invoice_due_date":"2024-05-29","invoice_no":"zee232B","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":5674.0,"disbursal_amount":5674.0,"subvention_amount":33.58,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1716968903.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715413703.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1715193000.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","same_topup":""}},"record":"453cde1b-ba6f-490a-a911-3033bfd6ee29","payout":null},{"id":"78caa09a-c553-4f47-a9b3-b5cf0d0845c7","created_at":1725884364.8209531,"updated_at":1725884365.865647,"type":"record","day":21,"index":409465,"transaction_date":1723119564.820949,"date":1722773964.794226,"amount":71079.0,"principal_paid":70870.0,"principal_outstanding":0.0,"originator_principal_paid":49609.0,"originator_principal_outstanding":0.0,"co_lender_principal_paid":21261.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":209.0,"penal_outstanding":0.0,"penal_tax_paid":0.0,"penal_tax_outstanding":0.0,"originator_penal_paid":146.29999999999998,"originator_penal_outstanding":0.0,"co_lender_penal_paid":62.699999999999996,"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":165.0,"originator_subvention_ack":115.5,"co_lender_subvention_ack":49.5,"cashback_available":835.0,"originator_cashback_available":835.0,"co_lender_cashback_available":835.0,"cashback_adjusted":0.0,"cashback_released":0.0,"holdback_available":0.0,"holdback_adjusted":0.0,"holdback_released":0.0,"partner_interest_outstanding":10.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":70870.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":209.0,"record_penal_tax":0.0,"originator_record_principal":49609.0,"originator_record_interest":0.0,"originator_record_overdue":0.0,"originator_record_penal":146.29999999999998,"originator_record_penal_tax":0.0,"co_lender_record_principal":21261.0,"co_lender_record_interest":0.0,"co_lender_record_overdue":0.0,"co_lender_record_penal":62.699999999999996,"co_lender_record_penal_tax":0.0,"remaining_amount":75956.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":15,"to_be_deleted":false,"account":"ebbeb520-734d-4b71-b995-a1adbf842eb1","loan":{"id":"7d8cedb9-421d-46ce-9de9-549f2edad7ec","created_at":1723119232.1248384,"updated_at":1723119232.125319,"ref_id":"TOP0000A5WG","index":1362,"status":"closed","loan_amount":70870.0,"subvention_amount":1000.0,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1723119232.047537,"loan_start_date":1720981800.0,"due_date":1721413800.0,"close_date":1722773962.507409,"close_value_date":1722773962.507404,"revert_date":null,"revert_value_date":null,"subvention_end_date":1722946411.925141,"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":{"id":"aaffddc2-1119-4a59-ae4d-d50dd8956f10","ifsc":"HDFC0000240","tags":[],"company":"def9a516-56ab-4a3b-af0c-e37c85b89b1a","account_no":"9999999999999999","created_at":1713246306.9866714,"updated_at":1713246307.0006177,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"Adani Wilmar Limited"},"utr":"ACC011","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"ebbeb520-734d-4b71-b995-a1adbf842eb1","topup":{"id":"95f4555b-1ba5-4aa1-b6f3-b47c18bd2306","payout_amount":69870.0,"loan_amount":70870.0,"created_at":1722946346.1252706,"updated_at":1723119232.1139617,"ref_id":"TOP0000A5WG","index":1362,"status":"disbursed","type":"invoice","invoice_date":"2024-07-15","invoice_due_date":null,"invoice_no":"ACC0002","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":70870.0,"disbursal_amount":70870.0,"subvention_amount":1000.0,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1722946411.925141,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1722946411.9433963,"custom_bank":{},"tags":["back_date"],"scheduled_at":null,"disbursement_date":1720981800.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"Back date invoice: Invoice Date 2024-07-15","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":"ebbeb520-734d-4b71-b995-a1adbf842eb1","same_topup":null}},"record":"d3b1e4ad-6968-4aef-8974-bc3fbe91b56c","payout":null},{"id":"7f105783-7ff7-4d75-9b7d-af1b26beba68","created_at":1734326964.6533751,"updated_at":1734326964.6539085,"type":"cashback_refund","day":3,"index":1695029,"transaction_date":1734326964.579482,"date":1734287400.0,"amount":49.0,"principal_paid":45000.0,"principal_outstanding":0.0,"originator_principal_paid":0.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":35.0,"originator_subvention_ack":0.0,"co_lender_subvention_ack":0.0,"cashback_available":2.0,"originator_cashback_available":0.0,"co_lender_cashback_available":0.0,"cashback_adjusted":0.0,"cashback_released":49.0,"holdback_available":0.0,"holdback_adjusted":0.0,"holdback_released":0.0,"partner_interest_outstanding":7.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":45000.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":5000.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"c4517a76-11ed-4ea6-87f8-270a2699b55e","loan":{"id":"0875ca61-1d4d-47b8-a86a-d1eff7d3a8fa","created_at":1723184120.5113206,"updated_at":1723184120.5115888,"ref_id":"TOP0000LNPY","index":1392,"status":"closed","loan_amount":45000.0,"subvention_amount":86.0,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1723184120.4366915,"loan_start_date":1722450600.0,"due_date":1722882600.0,"close_date":1722670012.926895,"close_value_date":1722670012.926884,"revert_date":null,"revert_value_date":null,"subvention_end_date":1723615977.569097,"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":{"id":"aaffddc2-1119-4a59-ae4d-d50dd8956f10","ifsc":"HDFC0000240","tags":[],"company":"def9a516-56ab-4a3b-af0c-e37c85b89b1a","account_no":"9999999999999999","created_at":1713246306.9866714,"updated_at":1713246307.0006177,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"Adani Wilmar Limited"},"utr":"marg2utr","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"c4517a76-11ed-4ea6-87f8-270a2699b55e","topup":{"id":"13856502-c088-4dfa-b273-3dbe7b0921c1","payout_amount":44914.0,"loan_amount":45000.0,"created_at":1723183879.0569603,"updated_at":1723184120.4966593,"ref_id":"TOP0000LNPY","index":1392,"status":"disbursed","type":"invoice","invoice_date":"2024-08-01","invoice_due_date":null,"invoice_no":"marg2","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":50000.0,"disbursal_amount":50000.0,"subvention_amount":86.0,"holdback_amount":0.0,"margin_amount":5000.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1723615977.569097,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1723183977.5743241,"custom_bank":{},"tags":["back_date"],"scheduled_at":null,"disbursement_date":1722450600.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"Back date invoice: Invoice Date 2024-08-01","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":"c4517a76-11ed-4ea6-87f8-270a2699b55e","same_topup":null}},"record":null,"payout":"ed35898a-aa4a-4c05-81bf-799d39cd8c3d"},{"id":"852f342f-d591-4f00-9e65-f82b1c465041","created_at":1737277395.7281733,"updated_at":1737277395.7298486,"type":"record","day":4,"index":2069686,"transaction_date":1737277387.901774,"date":1720105906.892736,"amount":100000.0,"principal_paid":100000.0,"principal_outstanding":0.0,"originator_principal_paid":100000.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":148.0,"originator_subvention_ack":148.0,"co_lender_subvention_ack":0.0,"cashback_available":352.0,"originator_cashback_available":352.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":100000.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":100000.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":20000.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":"fdbac76c-ff8b-4003-a63a-7fa9446bad5f","created_at":1721303414.7905164,"updated_at":1722595402.3003688,"ref_id":"TOP0000B5EL","index":1277,"status":"closed","loan_amount":100000.0,"subvention_amount":500.0,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1721303414.769726,"loan_start_date":1719772200.0,"due_date":1724956200.0,"close_date":1721315506.9214542,"close_value_date":1720105906.892736,"revert_date":null,"revert_value_date":null,"subvention_end_date":1721303401.142136,"dpd":0.0,"debit_bank":null,"credit_bank":{"id":"aaffddc2-1119-4a59-ae4d-d50dd8956f10","ifsc":"HDFC0000240","tags":[],"company":"def9a516-56ab-4a3b-af0c-e37c85b89b1a","account_no":"9999999999999999","created_at":1713246306.9866714,"updated_at":1713246307.0006177,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"Adani Wilmar Limited"},"utr":"1927398192370","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"54e08a9a-2e40-447a-b9f0-5a947518cf84","topup":{"id":"66f154ec-5b0a-48b9-8913-17513fff7c1a","payout_amount":99500.0,"loan_amount":100000.0,"created_at":1721303401.0568955,"updated_at":1722534012.7048562,"ref_id":"TOP0000B5EL","index":1277,"status":"disbursed","type":"invoice","invoice_date":"2024-07-01","invoice_due_date":null,"invoice_no":"INVFS","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":100000.0,"disbursal_amount":100000.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":1721303401.142136,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1721303401.153333,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1719772200.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":null,"hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"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":"868dbbce-8ac0-4398-aab4-666ee1accda8","created_at":1715414658.7378826,"updated_at":1715414658.73989,"type":"record","day":0,"index":6565,"transaction_date":null,"date":1715241858.68256,"amount":1432.0,"principal_paid":1432.0,"principal_outstanding":0.0,"originator_principal_paid":0.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":7.53,"originator_cashback_available":0.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":1432.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":260279.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","loan":{"id":"2e05665f-dd76-4132-a173-108cae8302ad","created_at":1715414325.0,"updated_at":1722534017.975938,"ref_id":"CT000002GZ","index":978,"status":"closed","loan_amount":1424.47,"subvention_amount":7.53,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715414325.0,"loan_start_date":1715241525.0,"due_date":1716748200.0,"close_date":1715241859.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1716796104.0,"dpd":0.0,"debit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"credit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"utr":"scbet5wesdgg","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","topup":{"id":"4ca8d34f-0923-4306-9fe8-396c648f6f6d","payout_amount":1424.47,"loan_amount":1432.0,"created_at":1715413683.0,"updated_at":1722533988.115482,"ref_id":"CT000002GZ","index":978,"status":"disbursed","type":"invoice","invoice_date":"2024-05-02","invoice_due_date":"2024-05-27","invoice_no":"zee212B","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":1432.0,"disbursal_amount":1432.0,"subvention_amount":7.53,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1716796104.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715413704.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1715193000.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"55c5ff15-61ac-459f-9972-cc5ab060db13","same_topup":""}},"record":"453cde1b-ba6f-490a-a911-3033bfd6ee29","payout":null},{"id":"b453345d-8ff8-4500-ace5-2e88e204f13d","created_at":1731494360.922545,"updated_at":1731494360.9282243,"type":"record","day":10,"index":1160257,"transaction_date":1731494348.806692,"date":1731407948.77752,"amount":3000.0,"principal_paid":3000.0,"principal_outstanding":0.0,"originator_principal_paid":3000.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":9.0,"originator_subvention_ack":9.0,"co_lender_subvention_ack":0.0,"cashback_available":54.0,"originator_cashback_available":54.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":3000.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":3000.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":0.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":0,"asset_category_date":null,"peak_dpd":0,"to_be_deleted":false,"account":"553721ac-475f-456a-bc1f-c6ac6a5d144a","loan":{"id":"425d435a-53e5-4eaf-bcd0-c3972023fd55","created_at":1731059574.0561886,"updated_at":1732642738.171179,"ref_id":"TOP0000RM3E772773","index":6132,"status":"closed","loan_amount":3000.0,"subvention_amount":63.0,"holdback_amount":0.0,"payout_amount":2937.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1731059573.973237,"loan_start_date":1730572200.0,"due_date":1735756200.0,"close_date":1731494348.806692,"close_value_date":1731407948.77752,"revert_date":null,"revert_value_date":null,"subvention_end_date":1735756200.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":"234rtgfdw","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"553721ac-475f-456a-bc1f-c6ac6a5d144a","topup":{"id":"425d435a-53e5-4eaf-bcd0-c3972023fd55","payout_amount":2937.0,"loan_amount":3000.0,"created_at":1731059388.771158,"updated_at":1731059573.9895914,"ref_id":"TOP0000RM3E","index":6132,"status":"disbursed","type":"invoice","invoice_date":"2024-11-03","invoice_due_date":null,"invoice_no":"segalcopy3","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":3000.0,"disbursal_amount":3000.0,"subvention_amount":63.0,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1735756200.0,"invoice_storage_id":null,"invoice_parsed_data":{},"approved_at":1731059457.1011348,"custom_bank":{},"tags":["active_line_amount"],"scheduled_at":null,"disbursement_date":1730572200.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"Unable to allocate amount because: borrower_program line has insufficient available amount (0.0)","hold_remark":null,"rejection_remark":"Unable to allocate amount because: borrower_program line has insufficient available amount (0.0)","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":"553721ac-475f-456a-bc1f-c6ac6a5d144a","same_topup":null}},"record":"1ce1ceee-c89d-4eab-af91-c99f28a3e15c","payout":null},{"id":"c7cc2ff3-4de6-406d-8087-992f4a26db44","created_at":1723094796.380712,"updated_at":1723094796.389548,"type":"eod","day":98,"index":14655,"transaction_date":1723055399.999999,"date":1723055399.999999,"amount":0.0,"principal_paid":0.0,"principal_outstanding":1500.0,"originator_principal_paid":0.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":41.31506849315066,"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":3.575342465753424,"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":18.0,"originator_subvention_ack":0.0,"co_lender_subvention_ack":0.0,"cashback_available":0.48999999999999844,"originator_cashback_available":0.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":0.0,"record_interest":0.0,"record_overdue":0.0,"record_penal":0.0,"record_penal_tax":0.0,"originator_record_principal":0.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":0.0,"sent_to_gl":false,"revert_sent_to_gl":false,"sent_penal_charge_to_gl":false,"due_amount":0.0,"dpd":67,"asset_category_date":null,"peak_dpd":68,"to_be_deleted":false,"account":"69fd0af6-3310-4fed-9bf8-1ad4ef612e31","loan":{"id":"91639d67-0303-4453-909b-496700cabca9","created_at":1715603353.0,"updated_at":1722534019.3482618,"ref_id":"CT00000RN3","index":1026,"status":"closed","loan_amount":1481.51,"subvention_amount":18.49,"holdback_amount":0.0,"payout_amount":0.0,"sanctioned_amount":0.0,"disbursal_amount":0.0,"date":1715603353.0,"loan_start_date":1714652953.0,"due_date":1717180200.0,"close_date":1715494540.0,"close_value_date":null,"revert_date":null,"revert_value_date":null,"subvention_end_date":1718195189.0,"dpd":0.0,"debit_bank":{"id":"fe7ab337-3bb0-4db2-a823-d2c094290c1e","ifsc":"PUNB0457600","tags":[],"company":"23067dbc-6c62-4203-9014-7100e4ffe811","account_no":"1576001500004547","created_at":1714811161.6467052,"updated_at":1714811161.6820965,"is_verified":false,"account_type":"current","name_at_bank":null,"account_holder_name":"rishabh"},"credit_bank":{"id":"f8a5a165-8fe7-43ec-9575-c27654fa7a83","ifsc":"HDFC000384748","tags":[],"account_no":"100010203920","banking_id":"a7680d00-2b0d-4f60-aa4a-8b237790efe9","created_at":1715602859.95,"updated_at":1715602859.95,"is_verified":false,"program_ids":[],"account_type":"Current","account_holder_name":"HDFC BANK"},"utr":"SBINO0010135","back_date_found":false,"back_date_marked_on":null,"is_processed":false,"is_imported":false,"account":"69fd0af6-3310-4fed-9bf8-1ad4ef612e31","topup":{"id":"07a8eb19-3a23-45c3-85ae-c477aa566d2d","payout_amount":1481.51,"loan_amount":1500.0,"created_at":1715603029.0,"updated_at":1722533992.53215,"ref_id":"CT00000RN3","index":1026,"status":"disbursed","type":"invoice","invoice_date":"2024-04-02","invoice_due_date":"2024-04-02","invoice_no":"Smart02","vehicle_no":null,"vehicle_data":{},"vehicle_data_vendor":null,"invoice_amount":1500.0,"disbursal_amount":1500.0,"subvention_amount":18.49,"holdback_amount":0.0,"margin_amount":0.0,"pf_amount":0.0,"pf_gst_amount":0.0,"subvention_end_date":1718195189.0,"invoice_storage_id":"","invoice_parsed_data":{},"approved_at":1715603189.0,"custom_bank":{},"tags":[],"scheduled_at":null,"disbursement_date":1714588200.0,"is_partial_disbursement":false,"disbursement_fee":0.0,"remark":"","hold_remark":null,"rejection_remark":null,"anomaly_found":false,"anomaly_approved":false,"is_check_completed":true,"uploaded_by":"","uploaded_by_id":"","is_imported":false,"account":"69fd0af6-3310-4fed-9bf8-1ad4ef612e31","same_topup":""}},"record":null,"payout":null}]}
Previous
Get Loan Summary
Next
Initiate Adjustment
Built with