When did you last know exactly how much you were spending on vendors, not a rough estimate, the actual number? Most solo consultants can’t answer within $150. The monthly total tends to drift upward invisibly: a new tool here, a contractor you’ve used twice in six months, a professional association you joined but never engage with. Each individual charge is too small to scrutinize. The total is large enough to matter.
The vendor management spreadsheet makes the total visible. The quarterly review makes it actionable. The cancellation trigger makes the discipline automatic. It’s not about running lean for its own sake, it’s about knowing what you’re spending, getting value for everything you pay for, and having a clear decision rule for what stays and what goes.
Most solos who build this system for the first time find the total is $300–500/month higher than they thought. After the first quarterly review, it’s typically $100–200/month lower than when they started.
The spreadsheet: 6 columns, one row per vendor
Build this in Google Sheets, Notion, or Excel. Six columns:
Column 1: Vendor name The company or tool name. One row per distinct vendor, if you use Adobe Creative Cloud and Figma, those are two rows.
Column 2: Category Four categories cover everything: Software, Contractor, Service, Subscription.
- Software: SaaS tools you pay for monthly/annually
- Contractor: individuals or agencies you pay for work (designer, bookkeeper, developer)
- Service: utilities, insurance, professional services
- Subscription: newsletters, memberships, professional associations, courses
Column 3: Monthly cost Standardize everything to monthly cost. Annual plans get divided by 12. A $240/year plan is $20/month. This makes the total meaningful, you can sum the column and see what you spend per month on vendors.
Column 4: Contract end date / next renewal When does the subscription auto-renew? When does the contractor agreement expire? When is the next billing date for a service? This is the most important column for the cancellation trigger, you need to know renewal dates in advance to act before being charged.
Column 5: Contact name and email Who do you reach for billing issues, cancellations, or support? For SaaS: often the support email or account page. For contractors: their direct contact. For services: the customer service contact.
Column 6: Rating Four ratings:
- Essential: Would cancel a project or harm client relationships without it. Keep regardless of price.
- Used: Use weekly, earning its cost. Keep.
- Marginal: Use occasionally, unclear if it earns its cost. Reassess at next renewal.
- Unused: Haven’t used in 30+ days, doesn’t pay for itself. Cancel immediately.
The rating column is where the decisions happen. Everything else is data collection.
How to build the initial spreadsheet
This takes 30–45 minutes the first time.
Step 1: Pull statements Download the last 3 months of credit card and bank statements. Print or save as PDF.
Step 2: Identify every recurring charge Go through every statement and highlight every recurring charge. Recurring = a charge that appears more than once. Some charges appear quarterly or annually, check all 3 months.
Step 3: Add every charge as a row For each recurring charge: add it to the spreadsheet. Fill in name, category, monthly cost, and renewal date (Google the product to find when trials started or check your email for the original signup confirmation).
Step 4: Add contractors and service vendors Contractors who invoice you periodically aren’t on your credit card statement, check your email for recent invoices. Add each contractor as a row with their typical monthly cost (or the total from the last 12 months divided by 12).
Step 5: Rate everything Go through each row and assign an initial rating. Don’t overthink it, your first instinct is usually accurate. If you can’t remember using something in the last month: Marginal or Unused.
Result: A complete vendor list, total monthly cost visible at the bottom of column 3, every vendor rated.
The quarterly review: 10 minutes
Quarterly (first week of January, April, July, October):
Minute 1–3: Check for new vendors since last review. Pull the last 3 months of statements and add any new recurring charges.
Minute 4–6: Review the Marginal ratings. For each: has anything changed since last quarter? If still Marginal and renewing in the next 60 days: change rating to “Cancel at Renewal.” If the renewal is more than 60 days away: keep as Marginal.
Minute 7–8: Check renewal dates for all vendors. Any Essential or Used vendor renewing in the next 30 days? Confirm you still want to renew before the charge hits.
Minute 9–10: Update ratings based on any usage changes. A tool you’ve started using weekly moves from Marginal to Used. A contractor you haven’t engaged in 90 days moves from Used to Marginal.
That’s the quarterly review. 10 minutes. The action items that come from it (cancellations, renewal decisions) take additional time, but the review itself is a quick pass.
Most vendor accumulation happens not because you made a bad decision but because you never made a final decision. The spreadsheet forces final decisions by making renewal dates visible and ratings explicit. “I’ll decide later” becomes impossible when “later” has a date on a spreadsheet.
The cancellation trigger
The trigger is simple: if a vendor’s renewal date appears in the next 30 days and its rating is Marginal or Unused, cancel before the renewal.
Don’t wait until the day before renewal. Set a calendar reminder 30 days before every vendor’s renewal date. Label it: “[Vendor] renewal, check before [date].” When the reminder fires, check the vendor’s rating. If it’s Marginal or Unused: cancel.
The cancellation process for SaaS tools:
- Log in to the tool’s billing settings
- Find the subscription or billing section
- Click “Cancel” or “Downgrade”
- Confirm via email
- Update the vendor spreadsheet, change status to “Cancelled” and add the cancellation date
For annual plans: don’t cancel mid-year (you’ve already paid). Set the reminder for 30 days before the renewal date and cancel before the next charge.
For contractors: let the current engagement wrap up. Don’t extend with new work if the relationship is in Marginal or Unused territory. Review whether the contractor should be moved to an on-demand arrangement rather than a retainer.
What typically gets cut after the first review
The most common categories of vendor cancellations from the first quarterly review:
Duplicated SaaS tools (2–4 cancellations): Two project management tools, two scheduling tools, two design tools. The migration to a new tool happened but the old one wasn’t canceled. Typical recovery: $40–100/month.
The dormant professional memberships (1–2 cancellations): Association memberships, mastermind groups, networking organizations that you joined with good intentions and haven’t engaged with in 6+ months. Typical cost: $30–80/month.
The abandoned learning subscriptions (1–2 cancellations): Masterclass, Udemy Pro, LinkedIn Learning, a specific course platform. Signed up, watched two lessons, stopped. Still paying $15–30/month.
The rarely-used contractor (1–2 reviews): A VA or bookkeeper you pay a monthly retainer for but only use 2–3 hours per month. The retainer made sense at the volume you projected, the actual volume doesn’t justify it. Move to hourly or project-based.
Total typical first-review recovery: $150–300/month. Annualized: $1,800–3,600.
Maintaining the spreadsheet
After the initial build, maintenance is light:
When you sign up for anything new: Add it to the spreadsheet immediately. Vendor name, cost, category, renewal date, initial rating. 2 minutes.
When you cancel something: Update the row, mark it Cancelled and add the date. Keep cancelled rows at the bottom of the spreadsheet as a historical record.
When a vendor raises prices: Update the monthly cost. If the increase is more than 10%: reassess the rating. Price increases that aren’t accompanied by value increases are a reason to move from Used to Marginal.
The spreadsheet is a living document, not a quarterly snapshot. Keeping it current in real time means the quarterly review is a validation pass, not a data entry session.
Ready to send stronger proposals?
Build, send, and track proposals in one place so follow-up is easier.
Start your free trial →
