How to keep a vendor register and a renewal calendar

Most software overpayment comes from renewals nobody saw. A one-page register of who you pay, who owns each tool and when you can leave fixes that more reliably than any clever tool. This is how to build it in an afternoon and keep it alive with thirty minutes a month.

Run it afterward · guide 1 of 4 · Reviewed Oct 25, 2026

Run your numbers

Each calculator opens on a made-up sample. Type over it with your own figures; nothing you type leaves this tab.

Renewal uplift & notice date

Open as a full page

What a renewal price increase costs over the contract, what capping it saves, and the last day to give notice.

Arithmetic only, not tax, accounting or legal advice. Check the figures against your own order form.

The columns

Add a tenth column for the annual cost if you like, calculated from the cost and the billing period, so the sheet sorts by what matters. A vendor in your register is the same entity that appears in your vendor master in the books; use the same name in both so the two can be matched.

Vendor: the name as it appears on the invoice and on the card statement.
Owner: one named person, not a team.
Job: the work it is hired for, in a clause.
Cost: the amount per billing period, and the currency.
Billing period: monthly, annual or multi-year, and how it is paid (card, invoice, bank).
Renewal date: the day the next term starts.
Notice window: how many days before renewal you must give notice, and in what form.
Data location: where the data lives and how to export it.
Contract link: the order form or the plan page, saved where the team can open it.

Seed it from your books

Do not type the list from memory. Your accounting software already has the names and the totals. Run the vendor-totals report as described in find software in QuickBooks Online or find software in Xero, for twelve months, and paste the software lines into the register. Those guides cover the click paths; this one does not repeat them.

Then fill the gaps the report hides: tools charged to a card without a payee, annual plans that fell outside the window, and personal accounts used for work. The chart of accounts shows where software usually lands.

Turn dates into reminders

The register is only as good as the reminders it produces. A date in a cell that nobody is paged on is a record of a missed renewal waiting to happen.

Compute the notice date
Subtract the notice window from the renewal date. That is the date you can still act.
Two reminders
Create calendar events for the notice date minus 30 days and for the notice date itself. Invite the owner and one backup.
Roll the date forward
When a tool renews, update the renewal date the same day, before the owner forgets.

The monthly review

Thirty minutes, the same day each month, with the books open next to it. Annual plans paid in advance are prepaid expenses, so ask whoever keeps the books to confirm that the schedule matches the register's renewal date.

Sort by notice date and read the next 90 days aloud with the owner of each tool.
For each, ask: do we still use it, how many people, and what would we lose?
Add any new charge from the last month's card and bank statements that is not in the register.
Mark anything with no owner. Assign one or put it on the cancel list.
For anything you plan to end, follow cancelling without penalties.

Common questions

Do we need a tool for this?

A sheet is enough. What matters is that one person owns it and that dates in it also exist as reminders in a calendar. Move to a tool when the sheet gets too long to review in a monthly half hour.

Which date matters most?

Begin with the notice window, not the renewal date. A renewal date tells you when you will be charged; the notice date tells you when you can still do something about it.

What do we do with the contract itself?

Link to it from the register rather than copying terms into a cell. Record only the five things you act on: term, renewal, notice, price on renewal and how to export. For anything legal, the contract governs.

What about tools paid for by a personal card?

Put it in the register anyway, with the card it is on. A tool that is not in any report is the usual reason a renewal gets missed.

Keep going

All software we cover All how-to guides

See what you could stop paying for.

Send us the export and see which lines are worth a second look. A connected version is planned.

Run the free auditFree, in your browser. A connected version is planned, not open yet.

How to keep a vendor register and a renewal calendar

Run it afterward · guide 1 of 4 · Reviewed Oct 25, 2026

Run your numbers

Each calculator opens on a made-up sample. Type over it with your own figures; nothing you type leaves this tab.

Renewal uplift & notice date

Open as a full page

What a renewal price increase costs over the contract, what capping it saves, and the last day to give notice.

Worked example. Type over it.

Result

Price after 3 renewals30,233.09

Extra paid over the term vs a flat price12,146.69

Saved by holding the rise to 3.0%7,739.64

Last day to give notice2026-12-24

60 days from 2026-10-25. Open the negotiation well before it, while saying no is still possible.

Renewal date2027-02-22

Renewal	At the uplift	Held to 3.0%
1	25,920.00	24,720.00
2	27,993.60	25,461.60
3	30,233.09	26,225.45

Each renewal is rounded to a whole cent, like the invoice, and the next rise applies to that invoiced price. Some contracts cap increases; read yours before you assume a rate.