Skip to content
Last updated

Manage loan tapes and loan tape types

Loan tapes are scheduled data exports that deliver loan or payment information to investors via SFTP. Each loan tape is based on a loan tape type, which defines the fields, format, and reporting rules for the export. Use the Loan Tapes pages to configure SFTP delivery, encryption, and file naming for your loan tape exports, and to review the loan tape types that define their structure.

Availability: Requires the beta toggle to be enabled. If you don't see the Capital Markets group (containing Loan Tape Types and Loan Tapes) in your sidebar, contact Peach support. Required permissions: loan.tape:list, loan.tape:read (to view tapes); loan.tape:create (to add tapes); loan.tape:update (to edit tapes); loan.tape.type:list, loan.tape.type:read (to view tape types); loan.tape.type:create (to add tape types); loan.tape.type:update (to edit tape types)

The Loan Tapes and Loan Tape Types pages share a tabbed interface. Select the Types tab to view loan tape type configurations, or the Tapes tab to manage loan tape delivery settings. You can switch between the two tabs from either page.

View loan tape types

From the Admin Portal sidebar, select Loan Tape Types, or select the Types tab from the Loan Tapes page.

ColumnDescription
NameThe display name of the loan tape type.
Type IDThe Peach-assigned loan tape type identifier.
TypeThe category of data exported: loans or payments.
FieldsThe number of fields included in the export, or a dash if no fields are configured.

Use the search bar to filter the list. Select the column management icon to show, hide, or reorder columns.

Create a loan tape type

  1. From the Loan Tape Types list, select + New loan tape type.
  2. In the basic dialog, enter a Name, select a Loan tape type (Loans or Payments), and choose the Fields to include.
  3. Select Create new loan tape type to save with default settings, or More options to configure additional settings.
  4. If you select More options, the advanced sheet opens with these sections:
    • Basic information — name and tape type.
    • Select fields — fields to include in the export.
    • Metadata fields — additional metadata fields (required when loan metadata is selected).
    • Custom field mapping — overrides for column header names. Use + Add custom field mapping to add a row.
    • Reporting options — report LOC draws separately, report days after paid off (minimum 10), and action on missing data.
    • Money unit — full unit (decimal) or sub-unit (pennies).
    • Output options — tape output format and compression type.
  5. Select Create new Loan Tape Type to finish.

Edit or delete a loan tape type

  1. From the Loan Tape Types list, select a row to open the detail drawer.
  2. The drawer displays the full loan tape type configuration.
  3. Select Edit to modify the configuration. The tape type (Loans or Payments) cannot be changed after creation; all other settings can be updated.
  4. Select Save to apply changes.

To delete a loan tape type, select Delete from the detail drawer and confirm. Existing tapes already generated from the type are not affected.

View loan tapes

From the Admin Portal sidebar, select Loan Tapes, or select the Tapes tab from the Loan Tape Types page.

ColumnDescription
Loan tape IDThe Peach-assigned loan tape identifier.
Loan tape type IDThe name and ID of the loan tape type this tape uses.
InvestorThe name and ID of the investor this tape reports to, if one is assigned.
SFTP DestinationThe SFTP hostname and directory where the tape file is delivered.
SFTP EncryptionThe encryption method (GPG or None) and the SFTP access method (Password or Keys).

Use the search bar to filter the list. Select the column management icon to show, hide, or reorder columns.

Create a loan tape

  1. From the Loan Tapes list, select + Create new.
  2. Fill in the loan tape details across the four sections described below (see field reference).
  3. Select Create New Loan Tape.

Loan tape configuration

Select the loan tape type that defines the fields and format for this tape. Optionally select an investor to scope the tape to a single investor's loans. If you leave the investor blank, the tape includes all investors and is sent to the file company.

SFTP delivery settings

Configure how the tape file is delivered. Choose an SFTP protocol (username and password, or SSH keys), then enter the hostname and credentials. Optionally specify a directory on the SFTP server where the file should be uploaded.

File encryption

Choose whether to encrypt the tape file. If you select GPG encryption, provide the public key that Peach uses to encrypt the file before delivery.

File naming

Define a custom file name pattern using placeholders and date format codes. Choose whether dates in the file name reflect the report date or the date the file is generated.

Loan tape fields

FieldDescriptionRequiredValues / Format
Loan tape typeThe loan tape type that defines the export structure.YesDropdown of loan tape types
InvestorThe investor whose loans are included. If blank, the tape includes all investors.NoDropdown of investors
SFTP protocolThe authentication method for SFTP delivery.YesUsername and password (default), SSH Keys
SFTP hostnameThe SFTP server address. May include a port number.YesText (e.g., sftp.example.com:22)
SFTP usernameThe username for SFTP authentication. Required when the protocol is Username and password.ConditionalText
SFTP passwordThe password for SFTP authentication. Required when the protocol is Username and password.ConditionalText (masked)
SFTP change directoryThe directory on the SFTP server where the file is uploaded.NoText (e.g., /reports)
Encryption methodWhether the file is encrypted before delivery.YesNone (default), GPG
Public keyThe GPG public key used to encrypt the file. Required when the encryption method is GPG.ConditionalText (multi-line)
Custom file nameA file name pattern using placeholders and strftime format codes.NoText (e.g., loantape{{loanTapeId}}%m%d_%Y.csv)
Date value in file nameThe date used when resolving date format codes in the file name.YesDate of generation (default), Report date

Loan tape type configuration reference

The following settings define the structure and behavior of a loan tape type. They can be configured in the create flow's advanced sheet or in the detail drawer's edit mode.

SettingDescription
Tape typeThe category of data: loans (loan-level balances and status) or payments (transaction-level payment data).
Tape nameThe display name of the loan tape type.
Output formatThe file format for the export (CSV).
Money unitHow monetary values are expressed: full unit (decimal, e.g., 100.50) or sub-unit (pennies, e.g., 10050).
CompressionFile compression: none, gzip, or zip.
Report draws separatelyWhether individual draws on line of credit loans appear as separate rows.
Report days when paid offThe number of days a paid-off loan continues to appear in the tape after payoff.
Action on missing dataWhether loans with missing data are included with empty fields or excluded from the tape.
Field name mappingsCustom column header names that override default field names in the export.
FieldsThe list of data fields included in the export. Loan tape types support 147 loan fields or 27 payment fields depending on the tape type.