Summit Update - Adding New Records

Learn how to process weekly sweep data tapes from sellers and format new loan records into the BI database loader.

May 28, 2026 By Eddy Kup

This guide explains how to process weekly sweep tapes and add new loan records into the BI format database. By following this workflow, you ensure incoming flow data is correctly staged and allocated to the right portfolios before Friday closings.

This process is designed for capital markets analysts and data operators handling recurring tape imports from partners like LenderMac. You will use this procedure whenever you receive weekly bid data that needs to be templated and loaded into the core BI systems.

Prepare the BI Loader template

Before entering data, copy the latest historical BI file for the seller to use as your template.

Step #1: Open the weekly sweep CSV file attached to your source email. — Open the weekly sweep CSV file attached to your source email.

Step #2: In File Explorer, navigate to the active portfolio bids folder: InvestorPoolFiles > PortfolioBids > Active. — In File Explorer, navigate to the active portfolio bids folder: **InvestorPoolFiles > PortfolioBids > Active**.

Step #3: Open the folder for the specific seller (e.g., Lendermac). — Open the folder for the specific seller (e.g., **Lendermac**).

Step #4: Select the most recent BI Loader file, copy it, and paste a duplicate into the folder. — Select the most recent BI Loader file, copy it, and paste a duplicate into the folder.

Step #5: Rename the duplicated file to reflect the current week's date, then open it. — Rename the duplicated file to reflect the current week's date, then open it.

Step #6: Navigate to the Data Input sheet at the bottom of the workbook. — Navigate to the **Data Input** sheet at the bottom of the workbook.

Always verify that the headers in your new source file exactly match the template's headers. Use a quick =IF(A1=B1, 0, 1) formula to confirm the columns haven't shifted.

7

Copy the data from your source tape and paste it into the Data Input sheet.

Filter the BI format tab

Once the raw data is pasted, integrate it into the master database layout. Insert new rows below the seller's previous records so you can easily copy down existing flow allocations (such as Mora, Pathfinder Core, ABS, or QM6).

Step #8: Switch to the BI format tab and open the filter menu on the Seller column. — Switch to the **BI format** tab and open the filter menu on the **Seller** column.

Step #9: Search for your seller (e.g., "LenderMac") and select it from the list. — Search for your seller (e.g., "LenderMac") and select it from the list.

Step #10: Click OK to apply the filter and display only that seller's records. — Click OK to apply the filter and display only that seller's records.

Step #11: Select a cell below the newest existing record, trigger the Insert dialog, and choose Entire row. — Select a cell below the newest existing record, trigger the Insert dialog, and choose **Entire row**.

Step #12: Click OK to insert the blank row. Repeat or use Ctrl + + to add enough rows for the new tape. — Click OK to insert the blank row. Repeat or use `Ctrl` + `+` to add enough rows for the new tape.

Copy the relevant baseline data from the previous week's rows down into your newly inserted rows.

Update line item details

With the rows created and flow mappings copied down, adjust the unique date and identifier fields for the current week.

Field	Value to apply	Notes
Seller ID	Exact Seller ID	Best practice is to append a single quote to the end.
As of Date	Previous weekend's date	This acts as a placeholder and automatically updates once the flow is funded.
Closing Date	Upcoming Friday	Weekly flows typically target Friday closings.
Servicer ID	Assigned Servicer	If the record is missing a specific Servicer ID, default to using the Seller ID.
Price	Base price * 1.03	Apply the temporary 1.03 multiplier to applicable rows.

Step #13: Update the Seller ID column for the new rows. — Update the **Seller ID** column for the new rows.

14

Set the As of Date to the date of the previous weekend.

15

Type the targeted Friday into the Closing Date column.

16

Enter the designated Servicer ID.

17

Apply the +1.03* calculation where temporary pricing rules apply.

18

Copy and Past value entire database and remove excess row.

FAQ

Q: Why do we use the previous weekend for the As of Date?

A: The previous weekend serves as a reliable placeholder during the initial data entry phase. The system will automatically update this field to the accurate date once the flow is officially funded.

Q: What if a loan record doesn't have a designated servicer yet?

A: If there is no specific servicer assigned (or it is TBD), use the Seller ID in the Servicer ID field for now.

Glossary

Term	Definition
BI Format	The standardized data loader layout used to map incoming seller loan tapes into the central database.
Flow Allocation	The internal destination program or vehicle (e.g., Mora, Pathfinder Core, ABS) where incoming loans are categorized.
Master Pool File	The raw weekly data tape received from sellers detailing the metrics of the loans available for purchase.