Debt Schedule

Track every financing instrument in one place: loans, lines of credit, mortgages, equipment financing, SBA loans, convertible notes, and revenue-based financing. The same tracker handles both sides of a loan — money you borrowed (a liability you owe) and money you lent to someone else (a note receivable you collect). Upload a contract and DayZero's AI extracts the terms and projects a payout table; when payments are recorded, principal and interest are split and posted with the correct accounting treatment for each direction.

This feature lives in the CFO Portal and requires the CFO Suite add-on.

Key capabilities

• One tracker for both directions — borrow (a loan to you, a liability) and lend (a loan from you, a note receivable)
• Eight instrument types: term loan, line of credit, mortgage, equipment loan, SBA loan, convertible note, revenue-based, other
• AI contract parsing — drop a PDF term sheet or signed contract and DayZero extracts name, counterparty, principal, rate, term, and schedule, with a confidence score
• Editable review step before anything is saved — correct any field, including direction
• Add a loan three ways: upload a contract, enter it manually, or ask the AI assistant
• Record payments from the schedule — each payment posts a balanced principal/interest journal entry and reduces the balance
• Amortized payment split — each payment is divided into principal and interest using the instrument's rate and cadence
• Direction-aware journal entries — interest books as an expense on debt you owe and as income on money you lent
• Revenue-based financing support — revenue-share rate plus a total repayment cap instead of a fixed interest rate
• Covenant tracking — attach financial covenants (e.g. DSCR, debt-to-equity) with operators and thresholds
• Separate KPIs so receivables never inflate your debt totals — money owed to you is reported as Notes Receivable
• Feeds the 13-week cash flow forecast with scheduled debt outflows

How it works

A debt instrument is created by uploading a contract, reviewing the AI-parsed terms, and approving. The direction you confirm at review time determines how every later payment is booked.

flowchart TD
  upload["Upload contract (PDF)"] --> parse["AI parses terms + projects payout table"]
  parse --> review["Review & edit: direction, rate, principal, term"]
  review --> approve["Approve"]
  approve --> borrow["direction = borrow → debt you owe (liability)"]
  approve --> lend["direction = lend → note receivable (asset)"]
  borrow --> payB["Payment: Cash CR · Principal DR · Interest Expense DR"]
  lend --> payL["Payment: Cash DR · Notes Receivable CR · Interest Income CR"]

How to use it

1. Open the Debt Schedule in the CFO Portal and click Upload contract.
2. Drop a PDF (term sheets and signed contracts both work; revenue-based contracts like Clearco, Wayflyer, and Pipe are supported). DayZero parses it and projects a draft payout table.
3. In the review step, confirm the Direction — Loan to us (we owe) or Loan from us (receivable). This flips the counterparty label between Lender and Borrower and sets the accounting treatment.
4. Correct any field — interest rate (entered as a percentage), principal, current balance, term, and payment frequency — then click Approve to create the instrument.
5. Instruments you owe appear in the main debt table; money you've lent appears under Notes Receivable — what's owed to you with its own KPI.
6. No contract? Click Add loan and choose We borrowed or We lent, then fill in the terms by hand.
7. To log a payment, click Record payment on a row, enter the amount, pick the bank account the money moves through, and save — DayZero splits it into principal and interest and posts the journal entry.

Tip: You can also add a loan by asking the AI assistant directly — e.g. "we lent ACME Supply $50,000 at 8% over 24 months." It sets the direction automatically.

Pro tips

• Double-check direction at review. The AI defaults to borrow and guesses from the contract. If it guesses wrong, interest will book to the wrong account (expense vs. income) — fixing it before approval saves a correcting entry later.
• Revenue-based financing has no interest rate. Choosing the revenue_based type swaps the rate/term fields for a revenue share and a total repayment cap; payments draw down the cap rather than amortizing a balance.
• Receivables stay out of debt KPIs. Money you've lent is reported under Notes Receivable, so your debt-service and total-balance metrics reflect only what you actually owe.
• Covenants are optional but powerful. Attaching covenants (e.g. minimum DSCR) lets the portal surface compliance against the terms you agreed to.

In-depth guide

Direction — which side of the loan you're on

The amortization math is identical for both; only the debit/credit sense of the journal entry is flipped.

Instrument types

term_loan, line_of_credit, mortgage, equipment_loan, sba_loan, convertible_note, revenue_based, other.

Payment frequencies

monthly, quarterly, semi_annual, annual, bullet (single payment at maturity), and revenue_share (for revenue-based financing).

Payment split & interest

Each recorded payment is divided into principal and interest using a standard amortization rule: interest for the period is current_balance × periodic_rate, and the remainder pays down principal. Interest-free obligations (rate of 0) apply the whole payment to principal. For bullet loans, interest accrues as if the full term has elapsed. After each payment the instrument's current balance is reduced by the principal portion.

Journal entries

Each payment posts as a balanced three-leg journal entry (the interest leg is omitted when interest is zero).

Revenue-based financing (RBF)

RBF instruments record a revenue-share rate (in basis points) and a total repayment cap instead of a fixed interest rate. Each payment is computed as revenue × share, capped to the remaining balance under the cap; repayments stop once the cap is reached. The projected schedule shows the cap as a single "until paid" disclosure rather than a fictional month-by-month table.

Covenants

Covenants attach to an instrument with a metric (e.g. debt_to_equity, dscr, current_ratio), an operator (greater/less than, or-equal variants), a threshold, and a measurement frequency.

How instruments are created

Recording payments

Click Record payment on any instrument and supply the amount, date, and the bank/cash account the money moves through. The principal and interest accounts are resolved automatically by direction — Long-Term Debt + Interest Expense for debt you owe, Notes Receivable + Interest Income for a note receivable — creating those system ledgers on first use. The payment is split per the amortization rule, posted as a balanced journal entry, and the instrument's outstanding balance is reduced by the principal portion.

Accounting impact

Debt you owe sits on the balance sheet as a liability and its interest hits the P&L as expense; money you've lent sits as a note-receivable asset and its interest is income. Keeping the two directions distinct ensures debt KPIs, the balance sheet, and the cash flow forecast all reflect reality.

Related files

Start free and bring your loans into focus.