Fee Tracker

The fee side of a project is three numbers that drift apart: what the contract says, what the work has earned, and what has actually been billed and paid. Small firms lose real money in the gaps between them, usually by forgetting the middle one. This keeps the three side by side, per project, with the arithmetic visible.

Workflow

Step 1. Bootstrap if needed

Check whether docs/practice/fees.md exists. If not, copy assets/fee-tracker-template.md there and record the project, the currency as the contract states it, and the fee table with the agreement article each line comes from. If the project has no docs/ folder at all, confirm before creating one.

Step 2. Record progress

When you state a phase's percent complete, record it with the date and your one-line basis. The previous figure moves to the history, never overwritten. Then recompute earned:

Phase <name>
  fee               <as contracted>  [cited]
  percent complete  <as stated, dated>
  earned            <arithmetic>
Earned to date      <sum across phases>

Step 3. Record invoices and payments

One row per invoice: number, date, period or phase it bills, amount, status issued, paid, partial, disputed, with dates. A payment updates the row, dated; a partial payment records both figures.

Step 4. Report

On "where are we", compute and show, as of the date you give:

Earned to date      <n>
Billed to date      <n>
Unbilled earned     <arithmetic>     <- the money being forgotten
Outstanding         <sum of unpaid invoices>
  aging             <each unpaid invoice, days since issue>

Unbilled earned is stated first. It is the number this file exists for.

Step 5. Amendments

A fee change (amendment, additional service) is a new fee line with its own source, never an edit to the original. The contract history stays readable.

Rules

• Every fee line cites the agreement or the amendment it comes from.
• Percent complete is stated, dated, and attributed to you. Never inferred from time elapsed, invoices sent, or drawings issued.
• Show the arithmetic on earned, unbilled, and aging, every time.
• History over overwrite. Progress and status changes append.
• Currency as the contract states it. No conversion, ever.
• Nothing is deleted; a cancelled invoice is marked void, dated.

Anti-patterns

• Estimating percent complete from the calendar because a statement is overdue.
• Treating billed as earned, which hides exactly the gap that matters.
• Logging an amendment by editing the original fee table.
• Netting a disputed invoice out of the totals so the report reads clean.
• Turning the file into a time sheet. Effort is a different axis.

Resources

• assets/fee-tracker-template.md — the file this creates, empty.

No reference files. The numbers come from your contract and your invoices, not from here.