Fund portfolio

Write one row per contract at each closing date, with balances, status, days past due, provision and deferred revenue. The table only grows: each run appends closing dates after the last one written and never rewrites a closed date. Reprocessing the current month is allowed until the close; after that, adjustments go into the next close.

Each contract has a single status on the date: sold or assigned (only from the sale date), in judicial recovery or bankruptcy, charged off, paid off and in portfolio. A contract disbursed after the cutoff stays out of that close. The status drives the balance: in portfolio carries the outstanding balance; charged off has a zero balance and the amount goes to cumulative charge-off; judicial recovery keeps the balance while the filing is pending and becomes a loss when it is approved or discharged; sold leaves the portfolio and the provision.

The core may zero out the charged-off amount after a renegotiation or a migration. On the tape, the contract's cumulative charge-off is the greater of what the core reports and the previous tape. Recoveries after the charge-off go into their own column, without reducing the charge-off.

When the core does not send a metric for a contract on a date (interest paid, fee, unpaid balance), use the last non-null value from a previous close and keep the date it came from. That way an incomplete file does not zero out the contract, and the number's origin stays traceable.

The fee charged at origination is recognized over the life of the contract. Deferred revenue = fee received minus the part already recognized, by proportion paid or by elapsed term, as the policy says. A sold or charged-off contract recognizes or reverses the deferred balance at the close of the event.

The inventory file carries, per instrument and reference date, nominal value, present value, acquisition value, PDD (loan-loss provision) bucket and amount, the date the fund acquired it and the adjusted due date. Use the ready values and the latest reference date for the position. Instruments in the write-off buckets stay out of the active inventory and go into losses.

The same system often holds the fund and other group companies, such as the securitizer, under a company code. Every answer states whether it refers to the fund, another vehicle or the consolidated view. An assignment between vehicles within scope does not change the asset balance; an assignment out of scope leaves the portfolio on the assignment date.

The balance sheet comes from the administrator's trial balance. The income statement comes from the accounting ledger, with effective entries only (types A and M); opening balance (I) and closing or total (F) lines do not enter. The ledger arrives in cumulative files that repeat the period: deduplicate on the entry hash, without the file name, keeping the most recent file. The last date of each month is the close; the current month is the current position.

Economic net assets are the accounting equity plus the result not yet incorporated, equal to assets minus liabilities. Senior and subordinated quotas come from the portfolio composition for the same date, or the last one before it within the same month, never a future date. The difference between net assets and the sum of the series sits on a visible unallocated adjustment line.

Compare each metric with the previous close and block the close when the change exceeds the limit: for example, 10% on contract count, 15% on principal balance, 20% on interest and deferred revenue, 25% on provision, 30% on charge-offs and 40% on recoveries. A first close and a metric with no history stay as a warning, not an approval.