Update Monthly Diligence Invoicing via Summit

Export unbilled closed and dropped loan data from Summit and update monthly diligence billing templates in Excel.

September 2, 2026 By Eddy Kup

This guide explains how to extract unbilled diligence data from Summit and update monthly investor billing workbooks in Microsoft Excel.

This process applies to accounting and billing team members responsible for generating and reconciling monthly due diligence management invoices across investor profiles.

Understanding the Billing Workbook Structure

Each investor billing workbook contains three primary worksheets:

Summary / Page 1: The customer-facing invoice that is range-valued and sent to the client without the formulas and subsequent sheets.
Diligence: Aggregates and calculates loan counts and fee totals.
Summit Input: Houses the raw transaction data exported directly from Summit.

Step #1: Open the prior month's billing workbook template in Excel. — Open the prior month's billing workbook template in Excel.

Step #2: Click on the Diligence worksheet tab to review aggregated data formulas. — Click on the **Diligence** worksheet tab to review aggregated data formulas.

Step #3: Click on the Summit Input tab to access the raw data entry sheet. — Click on the **Summit Input** tab to access the raw data entry sheet.

Exporting Unbilled Transactions from Summit

For each investor, you must export two distinct sets of unbilled loans: closed loans from the billing cycle and loans dropped by the buyer.

1. Export Closed Unbilled Loans

Step #4: Click Reset in the left sidebar filter panel to clear previous filters. — Click **Reset** in the left sidebar filter panel to clear previous filters.

Step #5: Click on the DD Fees Billed filter dropdown in the left sidebar. — Click on the **DD Fees Billed** filter dropdown in the left sidebar.

Step #6: Select N to filter for unbilled diligence fees. — Select N to filter for unbilled diligence fees.

Step #7: Click on the Closing Date filter accordion. — Click on the **Closing Date** filter accordion.

Step #8: Select the relevant closing dates for the billing period (e.g., all dates within the target month). — Select the relevant closing dates for the billing period (e.g., all dates within the target month).

Step #9: Scroll to the bottom of the results table and click Export CSV. — Scroll to the bottom of the results table and click **Export CSV**.

2. Export Dropped Unbilled Loans

Step #10: Click Reset to clear active filters. — Click **Reset** to clear active filters.

Step #11: Click on the Transaction Stage filter accordion. — Click on the **Transaction Stage** filter accordion.

Step #12: Select Dropped (Buyer) to filter for loans rejected during diligence. — Select **Dropped (Buyer)** to filter for loans rejected during diligence.

Step #13: Click on the DD Fees Billed filter accordion. — Click on the **DD Fees Billed** filter accordion.

Step #14: Select N under DD Fees Billed. — Select N under **DD Fees Billed**.

Step #15: Click Export CSV to download the dropped loan records. — Click **Export CSV** to download the dropped loan records.

Consolidating and Updating the Template

Step #16: Open the exported CSV files from your browser downloads. — Open the exported CSV files from your browser downloads.

Combine the dropped loan records into the main export file and copy all rows.

Leave a blank row at the end of the data range when pasting. This allows you to jump directly to the bottom using keyboard shortcuts (Ctrl + Down) to easily clear leftover rows from prior months or extend formulas downward.

Paste the combined records into the Summit Input tab of the billing workbook.

Save the workbook under the new billing period filename using File > Save As.

Step #20: Click OK to confirm saving the updated workbook. — Click OK to confirm saving the updated workbook.

Repeating for Additional Investors

To generate invoices for additional investors (such as Apollo/AGM), repeat the process within their respective vault:

Step #21: Click Sign out at the bottom of the left navigation sidebar. — Click **Sign out** at the bottom of the left navigation sidebar.

Step #22: Click SIGN IN on the Summit login screen. — Click **SIGN IN** on the Summit login screen.

Select the target investor profile (e.g., AGM).

Step #24: Click Continue with AGM. — Click **Continue with AGM**.

Step #25: Filter by DD Fees Billed = N and the applicable Closing Date range, then export the CSV. — Filter by **DD Fees Billed** = N and the applicable **Closing Date** range, then export the CSV.

Step #26: Click Reset in the filter panel. — Click **Reset** in the filter panel.

Step #27: Filter by Transaction Stage = Dropped (Buyer) and DD Fees Billed = N, then export the CSV. — Filter by **Transaction Stage** = **Dropped (Buyer)** and **DD Fees Billed** = N, then export the CSV.

Combine the export datasets and paste them into the investor's corresponding Excel template.

Q: Why do unbilled loans need to be exported in two separate queries?

A: Standard closed loans and buyer-dropped loans are tracked under different transaction stages in Summit. Querying closed loans by closing date does not capture loans that were diligenced but dropped prior to closing, requiring a separate filter query for Dropped (Buyer).

Q: Why should an empty row be maintained when pasting data into the template?

A: Leaving a space makes it easy to navigate to the boundary of the dataset using Ctrl + Down. This allows you to quickly erase remnant rows from the prior month or drag formulas down when the current month has more records.

Q: What should you do if the current month has more loan records than the template rows?

A: Copy the formula row from the bottom of the aggregation sheet and drag or paste it downward to cover all newly imported records.

Term	Definition
DD Fees Billed	A Summit filter attribute indicating whether due diligence management fees have already been invoiced (`Y`) or remain unbilled (`N`).
Dropped (Buyer)	A transaction stage identifying loans where due diligence was performed but the buyer ultimately elected not to purchase.
Range Value	The process of converting dynamic Excel formulas into static values before sending the finalized invoice page to a client.