NoteLedger accepts XLSX reports exported from the FCI Lender Services investor portal. You can import notes (portfolio data), payment history, loan costs (invoices and charges), and memos — all without an API connection.
NoteLedger recognises five FCI report formats and detects the correct import category automatically:
| Report | Typical filename | Auto-detected category |
|---|---|---|
| Loan Portfolio | LoanPortfolio - <date>.xlsx | Notes |
| Payments From Borrower | Payments_From_Borrower.xlsx | Payments |
| All Paid Invoice Payments | All Paid Invoice Payments.xlsx | Loan Costs |
| Loan Charges | Loan_Charges.xlsx | Loan Costs |
| Loan Servicing Notes | Loan_Servicing_Notes.xlsx | Memos |
Export the file from the FCI portal
Log in to the FCI Lender Services investor portal and navigate to the report you want to import. FCI makes reports available as XLSX downloads from the portfolio overview and individual loan detail pages.
Download the report file to your computer. All five report types are Excel workbooks (.xlsx).
Do not rename the file or re-save it in a spreadsheet application before uploading — doing so can alter the sheet names and column headers that NoteLedger uses to identify the report type.
Navigate to Servicers
In NoteLedger, click your account name or avatar in the top-right user menu, then click Servicers in the dropdown. You will land on the Servicers page, which lists every servicer integration available in your account.
Open the FCI card
On the Servicers page, find the card labeled FCI and click anywhere on it to open the FCI detail page.
Click Import File
On the FCI detail page, look at the top-right area of the page header. Click the Import File button. The page switches to the Upload Import File panel.
Select an Import Category and drop the file
The Upload Import File panel has an Import Category row with the following choices: Auto Detect, Notes, Payments, Loan Costs, and Memos. Leave it set to Auto Detect — NoteLedger reads the column headers from the FCI file to determine the correct category automatically.
Drag your XLSX file onto the file-drop zone, or click inside the zone to open a file picker and select the file.
Review the Import Preview
After the file uploads, NoteLedger parses it and opens the Import Preview panel. A blue banner at the top of the panel confirms the auto-detected category, for example: "Detected as: Notes import."
Each row in the preview table has an Action dropdown with three options:
- Create — a new record will be created for this row.
- Update — an existing record that matched this row will be updated.
- Skip — this row will be ignored during the commit.
NoteLedger pre-fills the action based on whether it found a matching record in your account. You can change any row's action before committing. Use the bulk action buttons above the table to set all rows to the same action at once.
For Notes imports, NoteLedger reads the Lender Account column from your FCI LoanPortfolio file and matches it to one of your holding entities by its stored FCI investor ID. If exactly one entity matches, it is auto-selected. Otherwise, pick the correct entity from the dropdown. The first time you commit a portfolio file for a new entity, NoteLedger saves the investor ID to that entity so future imports auto-match. If a different ID is already stored on the selected entity, the commit is rejected with a clear message.
Click Commit Import
When you are satisfied with the row actions, click the Commit Import button in the top-right of the Import Preview panel. A progress indicator appears while NoteLedger writes the records.
Review the Import Results
When the commit finishes, the page shows the Import Results panel with five summary tiles: Total, Created, Updated, Skipped, and Errors. A status badge in the top-right of the panel reads Completed (green), Partial (yellow), or Failed (red).
If there are any errors, an Error Details section appears below the summary tiles listing the row number and error message for each failure. Rows that errored are not saved — correct the source file and re-upload if needed.
Click Done to dismiss the results and return to the FCI detail page. Your import is also recorded in the Import History table at the bottom of the page for future reference.
