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 (shown there as Loans & Debt) and requires the CFO Advisory 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
- Three tabs: Overview (KPIs and upcoming payments), Schedule (instruments and actions), and Subledger (the per-counterparty Loan Register)
- 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
- Pay (record a payment) posts a balanced principal/interest journal entry and reduces the balance; Draw or Disburse records new money moving
- Editable paydown schedule per loan that also drives the cash flow forecast
- GL Recon badge compares each linked loan's balance with its ledger (Reconciled, a drift amount, or Not on GL)
- 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
- Receivables stay out of your debt totals — money owed to you is reported as Notes Receivable
How it works
A debt instrument is created by uploading a contract, reviewing the AI-parsed terms, and approving. The direction you choose at review (Borrow or Lend) determines how every later payment is booked.
flowchart TD
upload["Upload contract (PDF)"] --> parse["AI parses terms + projects payout table"]
parse --> review["Review & edit: Borrow/Lend, rate, principal, term"]
review --> approve["Approve"]
approve --> borrow["Borrow → debt you owe (liability)"]
approve --> lend["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
- Open the Debt Schedule in the CFO Portal and click Upload contract.
- 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.
- In the review step, confirm 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.
- Correct any field — interest rate (entered as a percentage), principal, current balance, term, and payment frequency — then click Approve to create the instrument.
- Instruments you owe appear under Debt — what you owe; money you've lent appears under Notes Receivable — what's owed to you with its own KPI.
- No contract? Click Add loan and choose We borrowed or We lent, then fill in the terms by hand.
- To log a payment, click Pay on a row, enter the amount and date, pick the bank account, and save — DayZero splits it into principal and interest and posts the journal entry.
- Use Edit to change terms, link the loan to a ledger, or add covenants; Schedule to open the paydown table; Remove to take an instrument off the schedule (existing journal entries are kept).
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 Revenue-based swaps the rate/term fields for a revenue share and a total repayment cap; payments draw down the cap rather than amortizing a balance.
- Link each loan to a ledger in Edit, then watch GL Recon: a drift amount means the loan balance and its Chart of Accounts balance disagree.
- Keep the paydown schedule realistic. Edit rows to match the real payback plan; the cash flow forecast reads from them.
- 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
| Direction | Meaning | Principal is | Interest is | Counterparty |
|---|---|---|---|---|
| Borrow | A loan to you (you owe) — the historical default | A liability | An expense | The lender |
| Lend | A loan from you (a note receivable) | An asset | Income | The borrower you lent to |
The amortization math is identical for both; only the debit/credit sense of the journal entry is flipped.
Payment frequencies
Monthly, quarterly, semi-annual, annual, bullet (single payment at maturity), or revenue share (for revenue-based financing).
Payment split & interest
Each recorded payment is divided into principal and interest using standard amortization: interest for the period is current balance × periodic rate, and the remainder pays down principal. Interest-free obligations 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
| Direction | Cash | Principal account | Interest account |
|---|---|---|---|
| Borrow (you pay) | Credit (cash out) | Debit — Long-Term Debt paid down | Debit — Interest Expense |
| Lend (you get paid) | Debit (cash in) | Credit — Notes Receivable collected | Credit — Interest Income |
Each payment posts as a balanced three-leg journal entry (the interest leg is omitted when interest is zero). The principal and interest accounts are resolved automatically by direction and created on first use.
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 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 (in Edit) with a metric (current ratio, debt-to-equity, DSCR, leverage ratio, or interest coverage), a comparison operator, a threshold, and a measurement frequency.
Paydown schedule and cash flow forecast
Schedule opens a paydown table with due date, principal, interest, total, and status (Scheduled, Paid, Partially paid, Skipped, Overdue). Generate it from the loan terms, add or edit rows, or regenerate (you choose whether to keep hand-edited rows). Excel exports it. These rows feed the 13-week cash flow forecast: payments on debt you owe appear as outflows and repayments on notes receivable as inflows.
Draws, disbursements, and GL reconciliation
Draw (debt you owe) or Disburse (money you lend) records new funds moving, using the bank account you pick. The GL Recon badge appears once a loan is linked to a ledger; click a drift amount to open that account in the Chart of Accounts, or use the banner above the tables to filter to loans with issues.
See also
- Loan Register — per-counterparty registers for interest accrual, write-offs, and full payment history when you lend to or borrow from many parties