Documentation Index
Fetch the complete documentation index at: https://docs.keystn.com/llms.txt
Use this file to discover all available pages before exploring further.
Overview
The Sales Ledger is a detailed, loan-by-loan record of your funded production. It shows every funded loan alongside its revenue and compensation figures, making it the go-to report for sharing with a bookkeeper, reconciling broker compensation, or producing a clean revenue summary for any time period.
Go to Accounting > Sales Ledger in the sidebar.
Viewing Modes
The Sales Ledger supports two viewing modes:
By Pay Period
Select a pay period from the dropdown to see all funded loans assigned to that pay period. This is useful for:
- Reviewing which loans are included in a commission run
- Reconciling payroll against funded production
- Verifying that the correct loans are associated with each pay period
By Date Range
Select a start and end date to see all funded loans within that range. This is useful for:
- Monthly or quarterly production reports
- Comparing production across arbitrary time periods
- Ad-hoc reporting needs
Loan Details
Each loan in the ledger shows:
| Column | Description |
|---|
| Loan # | Broker loan number |
| Borrower | Borrower’s full name |
| Loan Officer | Assigned loan officer |
| Lender | The lender for this loan |
| Funded Date | Date the loan was funded |
| Loan Amount | Principal loan amount |
| Broker Comp | Broker compensation received |
| Gross Revenue | Gross loan revenue (if tracked) |
| Net Revenue | Net loan revenue after adjustments (if tracked) |
| Status | Current loan status |
| Loan Purpose | Purchase or Refinance |
| Loan Type | Conventional, FHA, VA, etc. |
| Channel | Broker or Non-Delegated Correspondent |
Included Statuses
The Sales Ledger includes all loans that have completed the funding process — Funded and all post-funding commission statuses.
Summary Totals
At the top of the ledger (or in a summary section), the following totals are displayed for the current view:
| Total | Description |
|---|
| Total Loan Amount | Sum of all loan amounts in the view |
| Total Broker Comp | Sum of all broker compensation |
| Total Gross Revenue | Sum of all gross loan revenue |
| Total Reimbursements | Sum of all reimbursements across loans in the view |
- Current page number
- Total number of pages
- Total number of matching loans
Use the pagination controls to navigate through large result sets.
CSV Export
The Sales Ledger supports exporting the current view to CSV format. The export includes all matching loans (not just the current page) with the following columns:
| CSV Column | Source |
|---|
| Loan # | Broker loan number |
| Borrower | First and last name combined |
| Loan Officer | LO’s first and last name |
| Lender | Lender name |
| Funded Date | Formatted date |
| Loan Amount | Decimal amount |
| Broker Comp | Decimal amount |
| Gross Revenue | Decimal amount (if available) |
| Net Revenue | Decimal amount (if available) |
| Status | Loan status |
| Loan Purpose | Purchase or Refinance |
| Loan Type | Product type |
| Channel | Broker or Non-Delegated Correspondent |
Pay Period Selection
When viewing by pay period, the dropdown shows the 50 most recent pay periods sorted by start date (most recent first). Each entry displays:
- Start date
- End date
- Whether the pay period is still in draft status
Use Cases
Sharing with Your Bookkeeper
Export the Sales Ledger by date range and send the CSV to your bookkeeper or accountant. The export includes loan-level revenue, broker comp, and property address — everything needed to record income entries without granting access to your full platform.
Monthly Revenue Reconciliation
Set a date range for the month and review total broker compensation and gross revenue against what was deposited. Use the summary totals at the top for a quick sanity check.
Commission Reconciliation
Select a pay period and compare the loans shown against the commission run details. Verify that all expected loans are included and the amounts align.
Lender Reconciliation
Export loans by date range, then filter or sort the CSV by lender to reconcile broker compensation received against lender statements.
Quarterly Business Review
Set a quarterly date range and use the summary totals for total volume, revenue, and reimbursement figures.
