Ledger Reports
How to generate and read the standard accounting reports available from the ledger — trial balance, investor statement, and bank reconciliation.
The admin panel provides three standard reports built from the ledger. Each one can be viewed on-screen or downloaded as a CSV file. They are designed to give you quick confidence that the books are correct, and to support audits or investor inquiries.
Trial Balance
A trial balance lists every ledger account for an SPV with its current balance, split into debit and credit columns. The total debits must equal the total credits — if they do, the report shows Balanced. If they don't, something is wrong and needs investigation.
Where to find it
Open any SPV's admin page. Scroll down past the Ledger account tree to the Trial Balance panel. The panel shows the report on-screen with a status indicator.
To download as CSV, click the Download Trial Balance button at the top of the SPV page.
How to read it
| Column | What it means |
|---|---|
| Code | The account's unique code (e.g., 1000.SPV-42) |
| Name | A human-readable label for the account |
| Type | Asset, liability, revenue, expense, or equity |
| Debit | The account's balance if it carries a debit balance |
| Credit | The account's balance if it carries a credit balance |
At the bottom, the Total row sums all debits and all credits. When the two are equal, the ledger is balanced for that SPV.
When to use it
- After running a bootstrap or reconciliation pass, to confirm the SPV is balanced
- Before or after making a manual adjustment, to see the impact
- When preparing for an audit or investor report
- As a quick health check alongside the Ledger Health dashboard
Investor Statement
An investor statement shows the full chronological history of a single investment. It traces every journal entry that touched the investor's receivable and capital accounts, with running balances so you can see how the position changed over time.
Where to find it
Open any investment's admin page. If the investment has ledger accounts, you'll see a Download Investor Statement button at the top of the page.
How to read it
The CSV header includes summary information:
- Investor — the investor's name
- Investment — the investment ID
- Committed — the total commitment amount
- Funded — how much has been collected via payments
- Status — the current investment status
Below the summary, each row represents a ledger entry:
| Column | What it means |
|---|---|
| Date | When the event took effect |
| Type | The kind of event (commitment created, payment received, reversal, etc.) |
| Description | A short explanation |
| Account | Which ledger account was affected |
| Debit | Amount debited to the account |
| Credit | Amount credited to the account |
| Receivable | Running balance of how much the investor still owes |
| Capital | Running balance of the investor's funded interest |
At the bottom, the Final Receivable and Final Capital lines show where the investment stands today. If the receivable is zero and the capital matches the commitment, the investment is fully funded.
When to use it
- When an investor asks about the status of their payment
- To trace why a receivable balance is non-zero
- For audit documentation of a specific investment's lifecycle
- To verify that a reversal or adjustment was recorded correctly
Bank Reconciliation
The bank reconciliation report shows how bank transactions were classified for a legacy SPV during the bootstrap process. It breaks down how many transactions were matched to payments, classified as distributions or fees, and how many remain in suspense.
Where to find it
Open any SPV's admin page. If the SPV has bank transactions (legacy SPVs imported from the V1 system), you'll see a Download Bank Reconciliation button at the top of the page.
How to read it
The CSV starts with summary statistics:
- Total Bank Transactions — how many bank statement lines exist for this SPV
- Classification breakdown — a table showing each category with a count and percentage
| Category | What it means |
|---|---|
| Matched to Payments | Bank transactions linked to a specific payment order |
| Intra-Account Transfers | Money moved between SPV bank accounts |
| Startup Wires | Outbound wires to portfolio companies |
| Platform Fee Wires | Outbound wires to the platform for fees |
| Micro Deposits | Small inbound credits for account verification |
| Suspense | Unclassified transactions that need manual review |
Below the summary, the Suspense Items section lists each unresolved item with its bank transaction ID, amount, date, description, and direction (debit or credit). These are the items that the automated classification engine could not categorize and that may require manual resolution through the suspense queue.
When to use it
- After running the bootstrap for a legacy SPV, to see the classification results
- To identify which suspense items still need manual resolution
- For audit documentation of how legacy data was migrated into the ledger
Last updated Mar 26, 2026
Built with Documentation.AI