Master Payment Tracker
Every cycle on every contract, in one ledger.
A working ledger of every payment cycle on every contract, both directions: money owed to you and money you owe.
What you get
How it works
One row per cycle
You log applied, notified and pay less sums as documents arrive; the sum payable follows the document chain automatically.
Status from today's date
Overdue shows red, due within 7 days amber, paid green. Duplicates and overpayments flag amber.
No notice given
The tracker flags any applied sum past its Due Date with nothing served: the situation where the full application may be recoverable.
Why it is laid out this way
Landscape and screen-first, with totals above the table and filters that work despite protection, because this template is worked in daily rather than printed.
An Excel template with no macros. Only the yellow cells can be edited, the Guide tab explains every step, and it prints on A4. Your contract's terms override the statutory defaults.
Related paid help
Rather have this ledger kept for you? That is Payment Application Assembly & Issuance, on the Quantity Surveying side. And if past cycles ran without the right notices, the s.110B Back-Audit checks what is still recoverable.