NoteLedger accepts two CSV formats exported from the Madison Management investor portal — a loan-list file that captures a point-in-time snapshot of your portfolio, and a loan-history file that contains the transaction history for a single loan. You can import either format at any time, with no API key required.
NoteLedger recognises both Madison CSV formats and detects the correct import category automatically:
| Report | File name (typical) | Auto-detected category |
|---|---|---|
| Loan-list CSV | Your Holding Entity LLC- loanlist.csv | Notes |
| Loan-history CSV | 0002005349-loanhistory.csv | Payments / Loan Costs |
Use the loan-list CSV for a full portfolio refresh — it imports or updates Note records (borrower, property, balance, rate, status). Use a loan-history CSV when you want to record payment activity or servicing-cost charges for a specific loan.
Export the file from the Madison portal
Log in to the Madison Management investor portal and navigate to either your portfolio overview (to download a loan-list CSV) or an individual loan's payment history page (to download a loan-history CSV).
Use your browser's download or export button to save the file to your computer. Do not re-save the file in a spreadsheet application before uploading — doing so can alter the column headers and the
Portfolio:header line that NoteLedger uses to detect the file type and match the holding entity. The filename itself can be anything; NoteLedger does not use it for entity matching.
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 Madison Management card
On the Servicers page, find the card labeled Madison Management and click anywhere on it to open the Madison Management detail page.
Click Import File
On the Madison Management 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 unless you know NoteLedger is misidentifying your file — with Auto Detect selected, NoteLedger reads the file headers and first line to determine the correct category.
Drag your CSV 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 loan-list imports, NoteLedger reads the
Portfolio:header line from your Madison loanlist CSV (format:Portfolio: <investor-id> - <entity name>) and matches the investor ID to one of your holding entities. If exactly one entity matches, it is auto-selected. Otherwise, pick the correct entity from the dropdown. The first time you commit a loanlist 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 Madison Management detail page. Your import is also recorded in the Import History table at the bottom of the page for future reference.
