Reports for Installment Loans

Galileo currently offers two standard reporting files for installment loans:

  • Daily Loan Status — A list of the current loans, subproducts, statuses, and installment due dates
  • Daily Transaction — Details on daily transactions related to loans

Reports are securely delivered as a CSV file each day. The reports contain invaluable data to reconcile your loans and transactions data for that day. It can also be used for reporting purposes to your bank partner.

Daily Loan Status file

This table contains details about the fields included in the Daily Loan Status file. The fields in the daily file are presented in this order.

Field NameTypeLengthDescription
Loan_Idstring30Galileo-generated identifier for the loan.
Customer_Prnstring12The PRN for the customer’s primary account.
Subproduct_Codestring15Galileo-generated identifier for the loan subproduct assigned to the simulation or loan, as configured for the program. For programs with multiple subproducts, the choice would be determined by underwriting.
Loan_Status_Descriptionstring13Current status of the loan. See the Loan Payment Status and Loan Status Table for detailed descriptions of each status.
Loan_Payment_Statusstring4Current loan payment status code. See the Loan Payment Status and Loan Status Table for detailed descriptions of each status.
Loan_Aprfloat16(2)Annual percentage rate for interest charged on the loan. Calculated from the interest defined by the subproduct, the length of the loan, and the origination fee (if applicable).
Loan_Start_Datedate8Date the funds are disbursed and interest, if configured, begins to accrue. Format: YYYYMMDD
Loan_Start_Today_Flagstring5Returns TRUE if the loan started today; otherwise, returns FALSE.
Interest_Ratefloat16(2)Interest rate applied to the loan, as defined by the subproduct.
Per_Diemfloat16(2)Daily interest charged on the loan. This amount will update as installments are paid.
Scheduled_Installment_Amountfloat16(2)Payment due at each installment.
Loan_Terminteger9Total count of installments, as defined by the subproduct.
Original_Loan_Amountfloat16(2)Total loan amount borrowed by the customer.
Principal_Balancefloat16(2)Current principal balance remaining on the loan.
Principal_Paid_To_Datefloat16(2)Principal amount of the loan that is paid off.
Interest_Paid_To_Datefloat16(2)Interest amount of the loan that is paid off.
Fees_Paid_To_Datefloat16(2)The fee amount the customer has paid to date.
Total_Payoff_Amountfloat16(2)Total amount to pay off the remaining loan if the customer paid it off today. Includes the remaining principal amount, interest, and fees.
Maturity_Datedate8The projected date the loan can be paid off by. This is a dynamic value that is based on the customer's actual payment activity. Format: YYYYMMDD
Closed_Datedate8Date that the loan was closed. Value returned if the loan is paid off or charged off. Otherwise, it returns null. Format: YYYYMMDD
Paid_Installmentsinteger2Number of installment payments that the customer has made on the loan.
Remaining_Installmentsinteger2Number of installment payments remaining on the loan.
Non_Accrual_Flagstring5Returns TRUE if interest is not accruing on the loan. Otherwise, returns FALSE.
Delinquency_Datedate8Date when the oldest unpaid installment became past due. (Coming Soon!) Format: YYYYMMDD
Past_Due_Amountfloat16(2)The installment amount that is past due for the loan.
Days_Past_Dueinteger9The number of days that the loan is delinquent. When the loan is charged off, this value resets to 0 because the loan is officially closed.
Loan_Status_Reason_Codestring32The reason provided for charging off the loan, as provided in the API request.
Total_Charge_Off_Amountfloat16(2)The total amount of the loan that was charged off.
Installment_Due_Datedate8Dates when the installments are due. Includes up to 24 columns up to 24 installments. Format: YYYYMMDD

Loan Payment Status and Loan Status table

This table shows fields returned in Loan_Payment_Status and Loan_Status_Description in the Daily Loan Status file.

Loan payment status codeLoan statusOverall loan payment description
OCURValidOpen and payments are current
OPDEValidOpen, but at least one payment is past due
PYOFCompletedCharged-off
CGOFCharge OffCharged-off
PNDGPendingPending loan creation
EXPDExpiredLoan is past the maturity date, and at least one of the installment is unpaid and past due.

Daily Transaction file

This table contains details about the fields included in the Daily Transaction file. The fields in the daily file are presented in this order.

Field NameTypeLengthDescription
Product_Codestring5Indicates the loan product. Currently the only possible value is 90000.
Subproduct_Codestring15Galileo-generated identifier for the loan subproduct assigned to the simulation or loan as configured for the program. For programs with multiple subproducts, the choice would be determined by underwriting.
Branch_Codestring3Indicates the assigned bank branch.
Institution_Codestring4The fintech identification number.
Loan_IDstring30Galileo-generated identifier for the loan.
Currency_Codestring3Three-letter ISO 4217 code is provided for the currency. Currently it only supports USD.
Txn_Codestring4Specifies the type of transaction. Possible values:
  • 9001 — Loan advance
  • 9099 — Advance reversal
  • 9002 — Regular payment
  • 9098 — Payment reversal
  • 9020 — Payoff
  • 9024 — Charge off
  • 9006 — Past due payment
  • 9005 — Installment past due
  • 9004 — Daily interest accrual
  • Reason_Codestring4Specifies whether the transaction source is an external or internal DDA account.
  • 3 — External
  • 9999 — Referential code to indicate internal loan activities
  • Transaction_Amountfloat16(2)Amount of the transaction.
    Amount_Typestring2Specifies whether the transaction was related to principal, interest, or fees. Possible values:
  • 4 — Principal
  • 5 — Interest
  • 64 — Fees
  • Charge_CodestringSpecifies the fee type that is applied to the transaction. Possible values:
  • 8 — Origination fee
  • 9 — Late fee
  • Situationstring11Indicates whether interest is accruing on the loan. Possible values:
  • Accural
  • Non_Accural
  • Business_Datedate8Date the transaction became effective. Format: YYYYMMDD
    Value_Datedate8Date the transaction became effective. Format: YYYYMMDD
    Payment_Idstring30Galileo-generated unique identifier for the payment on the loan. This is the same field as loan_payment_number, which is provided in the Create Loan Payment API response.
    Payment_Source_Codestring4Specifies the source of the payment on the loan. Possible values:
  • USRP — User-initiated payment
  • SYSP — System-initiated payment
  • CRDP — Credit payment
  • CSRP — Customer service payment
  • IVRP — IVR payment
  • PCRP — Provisional credit payment
  • MCRP — Merchant credit payment
  • RCRP — Refund credit payment
  • Reversal_Flagstring5Returns FALSE by default. Returns TRUE on the duplicate transaction record when a loan or payment is reversed.

    Allocation of payment amount in Daily Transaction file

    When a customer makes a payment, they first pay the interest, then the principal, and lastly the fees for the current installment. If there is an overpayment, after making the current installment payment, the remaining amount is allocated first to the interest of the next installment, then the principal and the fees.

    For the Daily Transaction file, this appears differently—the transactions will have separate rows. The transaction lines are separated by transaction codes for interest, principal, and fees. If there is an overpayment, the Daily Transaction file will include a line for each interest, principal, and fees depending on the amount due in the installment. If the transaction amount is $0.00, it will not be included. The loan_payment_number for all the transactions will be the same, which indicates that the customer made a single payment for multiple installments.

    For example, a customer made a payment of $205.00. The current installment due for the customer was $105.00. This breaks down to:

    • $25.00 towards the interest
    • $75.00 towards the principal
    • $5.00 for the fees on that installment

    In the Daily Transaction file, you can expect to see the following:

    • Transaction line for the interest paid ($25.00) for current installment
    • Transaction line for the principal paid ($75.00) for current installment
    • Transaction line for the fees paid ($5.00) for current installment
    • Transaction line for the interest paid ($25.00) for next installment
    • Transaction line for the principal paid ($75.00) for next installment

    Since the fee amount for the next installment is $0.00, the transaction line for will not be included.