Maya, a startup operations lead, opened a 1,800 receipt for a research tool nobody had used since February. The receipt was dated 12 September; cancellation notice had been due on 13 August. She had reviewed the last three monthly statements, so the previous annual charge never appeared.
To audit business subscriptions reliably, work from commitments to charges, not just a list of apps people remember. Fix the mistakes that can lock in another year first, then work through seat counts and unidentified payments. Keep the results in one Google Sheet you can revisit.
1. Find annual commitments before their notice windows close
Export at least 13 months of transactions from every business bank account, card, and payment wallet. Include employee-reimbursed subscriptions. Thirteen months gives an annual charge room to appear even when its posting date shifts; it will not reliably reveal multi-year contracts, so check the contract folder too.
Create one register row per subscription, separate from the transaction history. Use these columns:
Vendor | Account/workspace | Owner | Currency | Billing cycle | Renewal date | Notice deadline | Annual commitment | Evidence link | Status
Check invoices and contract terms for the notice deadline. A reminder thirty days before renewal is useless when the contract requires sixty days’ notice. Schedule the internal decision before that deadline, with time for approval and cancellation processing.
If records are incomplete: search billing inboxes for “annual,” “renewal,” and “subscription,” and ask each team lead for tools bought outside central purchasing. Mark unknown deadlines as unresolved; do not infer them from the last card charge.
If the deadline has already passed, request a waiver or credit from the vendor. Record it as requested, not recovered, until confirmed. Meanwhile, document the next available cancellation date.
2. Reconcile paid seats, not just active logins
For each per-seat tool, compare three things: the vendor’s billed quantity, its user roster, and your current staff-and-contractor list. Removing someone from your identity provider may block access without reducing the vendor’s bill.
Check pending invitations, suspended users, and former contractors. Some vendors bill for these; others have minimum seat commitments. A low login count is a review signal, not proof that a seat is unnecessary: an occasional administrator may still need access.
Before removing a departed employee, transfer owned files, integrations, and billing administration. Then change the purchased seat quantity, where required, and save the confirmation.
If the bill does not fall: check whether seats are committed until renewal or whether removal only creates spare capacity. Label the result “capacity freed,” not “cash saved.” Add that quantity to the renewal negotiation rather than assuming the next invoice will shrink.
3. Resolve unfamiliar merchants before cancelling anything
A descriptor such as PAYHUB*BRDSTACK may identify a payment processor and a shortened product name, not the supplier your team recognises. Search the exact descriptor, amount, and transaction date in billing email. Compare invoice references, card last-four digits, and workspace IDs.
Keep both the original descriptor and the verified vendor name. That mapping makes the next review faster without destroying the statement reference needed for reconciliation.
Scan2Sheet can extract receipt data into your Google Sheet and link each row to its cloud-stored receipt image. Use that evidence alongside statements; a receipt collection alone will miss subscriptions whose receipts nobody captured.
If nobody recognises a charge: ask the card issuer for expanded merchant details and contact the vendor through a verified channel. Do not cancel blindly: a forgotten payment can support a live domain or production service. Two equal charges are not automatically duplicates either; check whether they belong to separate workspaces. Escalate suspected unauthorised charges promptly through your issuer’s process.
4. Verify savings and reopen the register every month
Here is an illustrative completed audit, with all amounts in the same currency and on a consistent pre-tax basis:
| Confirmed action | Calculation | Next 12 months avoided |
|---|---|---|
| Cancel Northstar Research before annual renewal | 1 × 1,800 | 1,800 |
| Remove five monthly Flowboard seats | 5 × 29 × 12 | 1,740 |
| Close redundant Sketchroom workspace | 60 × 12 | 720 |
| Total | 1,800 + 1,740 + 720 | 4,260 |
This recovers 4,260 of planned spending, not 4,260 of historical refunds. It assumes the annual renewal falls within the next twelve months and both monthly reductions take effect immediately.
Keep cancellation confirmations and effective dates beside each action. Check the next invoice against the expected amount. If it differs, reopen the action and query the vendor rather than carrying an unsupported saving forward.
Monthly, match new charges to the register and investigate new vendors or price changes. Quarterly, repeat the seat comparison and review approaching notice deadlines; also trigger a seat check whenever someone leaves.
Start with your oldest annual charge and build the register around its next decision deadline.