SFT Ledger

Item	Type	Due		Raymond owes SFT	Expected to SFT	Raymond's share

This month what's due back and when — click any day for a cash projection

Jobs created or paid in the last 30 days

Job	Date	$ put in	Split	Profit	Payout

Loans last 30 days of activity, plus anything due soon or overdue

Borrower	Due		Principal	Total due

Vendor bills open bills due in the next 30 days or overdue

Vendor	Job	Due		Balance	Raymond owes

Vendor	Bill date	Invoice	Job	Due	Amount	Paid	Balance	Raymond owes	Status	Actions

How it works: a bill charged on a credit line for a job shows up as cash Raymond owes SFT. Reimburse records his cash coming in (deposits to SFT Bank). Pay records SFT paying the vendor (comes out of SFT Bank). Both can be partial.

Interest earnedExpected (still out)rate · days at the end of each bar

Borrower	Start	Term	Due	Principal	Rate	Interest	Total due	Balance	Status	Actions

SFT profitRaymond profitExpected (still active)margin % at the end of each bar

Job	Date	Contract	Costs	Job profit	$ put in	Split	Profit	Payout	Status	Actions

Transfer between accounts

Move cash from one envelope to another — e.g. into NBB Payroll after a job pays out. The total doesn't change; both ledgers get an entry.

→

Add or take out cash

Cash by hand — set a starting balance, pay someone from an envelope, or anything that isn't a loan, job, or vendor bill.

Date	Account	Description	Amount	Balance after

SFT money out right now

Job profit Loan interest

Monthly breakdown

Month	Job profit	Loan interest	Total profit	Principal returned

Partner split Schwartz Family Trust vs Raymond Brown — collected profit

Schwartz Family Trust Raymond Brown

Partner split by month selected year

Month	SFT — jobs	SFT — interest	SFT total	Raymond

Partner split by year all time, at a glance

Year	SFT — jobs	SFT — interest	SFT total	Raymond	SFT share

Profit per job paid jobs

Job	Paid	SFT $ in	SFT profit	Raymond profit	SFT return on $

Interest per loan paid loans

Borrower	Paid	Principal	Interest earned	Return on $	Annualized

Where your data lives

Opened as a file (double-click): data saves in this browser on this computer — export a backup now and then.

Run with server.py (recommended): keep server.py next to this file and run python server.py, then open http://localhost:8000. Everything saves to tracker-data.json beside it (previous version kept as tracker-data.bak.json). Moving to another computer or webserver = copy those files and run it there. Add --lan to reach it from your phone or other PCs. The badge in the top-right shows which mode you're in.

Backup & restore

Export a backup file now and then — importing it restores everything. This is also how you move data between the file version and the server version.

Export spreadsheets

CSV files open straight in Excel.

Start over

Deletes every loan and job stored in this browser. Export a backup first.

Raymond Brown where things stand between Raymond and the Trust

This month what's due back and when — click any day for a cash projection

Jobs created or paid in the last 30 days

Loans last 30 days of activity, plus anything due soon or overdue

Vendor bills open bills due in the next 30 days or overdue

Credit lines vendor accounts you can charge materials to

Bills

Loan analytics paid-back loans

Job analytics paid-out jobs

Cash accounts envelopes in the safe — click one to see its ledger

Checks received cashed at outside banks (Ally, Fortera, USB…) — tracked here, not part of SFT cash on hand

Settlement receipts signed close-outs — a master record of everything paid off in one action, with both signatures

Owed back on cards / apps money SFT borrowed (Amex via Venmo, Stripe…) to fund jobs — not profit, has to go back