To build a complete SaaS vendor list from accounting data, run a Transaction Detail by Account report in QuickBooks, Xero, or Sage covering the last 15 months, filter to software-related expense accounts, export to CSV, then scan for recurring merchant patterns: identical monthly charges, annual spikes with "subscription" in the memo, and payment-processor charges (Stripe, Paddle, PayPal) that mask the real vendor. The general ledger is the only indisputable source of truth — every card, bank, and AP transaction flows through it.
Self-reported lists do not work. Subscriptions are purchased by individual employees on corporate cards, department heads buy tools on local budgets, and free-tier products quietly upgrade to paid plans — which is why a definitive, audit-ready saas vendor list has to start from the ledger.
This guide walks through how to extract general ledger data, identify recurring software vendor patterns, and build a managed inventory.
The Discovery Process: Mining General Ledger Data
Your general ledger contains every transaction processed across card programs, bank accounts, and accounts payable. This makes it the most comprehensive source for software spend discovery.
Step 1: Export a Transaction Detail Report
In your accounting software (QuickBooks, Xero, Sage, etc.), run a Transaction Detail by Account report for the past 12–15 months.
Select the following filter parameters to isolate your targets:
- Accounts: Software & Subscriptions, IT/Computer Expenses, Professional Services, and Dues/Subscriptions.
- Date Range: Last 15 months (ensures annual billing cycles are captured).
- Required Columns: Transaction Date, Vendor/Merchant, Amount, Memo/Description, Payment Method.
Export this consolidated data as a CSV.
Step 2: Parse and Identify SaaS Merchant Patterns
Once in Google Sheets or Excel, sort by Vendor Name. Look for these specific recurring patterns:
- Consistent Monthly Spikes: Charges of the identical amount billed exactly 30 days apart (e.g., Zendesk, Loom).
- Annual Spikes: Single large transactions with keywords like "annual," "sub," "subscription," or "1 yr" in the memo field (e.g., HubSpot, Zoom Info).
- Processing Merchants: Watch for transactions labeled Stripe, Paddle, or PayPal. Use the memo description or raw payment details to isolate the actual underlying software vendor.
Worked Example: Reading Eight Ledger Rows
Here is a sample slice of a Transaction Detail export and what each pattern tells you:
| Date | Vendor/Merchant | Memo | Amount | What it means |
|---|---|---|---|---|
| 2026-03-01 | Zendesk Inc | Mar plan | $415.00 | Identical amount, 30-day cadence → monthly SaaS |
| 2026-04-01 | Zendesk Inc | Apr plan | $415.00 | (confirms the pattern) |
| 2026-02-17 | HubSpot | Annual subscription 2026 | $19,200.00 | Annual spike + "annual" memo → renewal anniversary ≈ Feb 17 |
| 2026-03-12 | Stripe | CALENDLY.COM | $144.00 | Processor charge → real vendor is Calendly, not Stripe |
| 2026-03-15 | PayPal | ID 8842, no memo | $89.00 | Unidentifiable → pull the PayPal receipt to unmask the vendor |
| 2026-01-30 | Adobe | VIP renewal 12 lic | $4,318.00 | Annual + license count in memo → capture seat count now |
| 2026-03-28 | Zoom US | — | $1,799.88 | Different entity name than "Zoom Video Comm" rows → deduplicate |
| 2026-04-02 | AWS | — | $2,211.43 | Variable amount monthly → infrastructure, not a fixed renewal; track separately |
Eight rows, six distinct actions: two confirmed subscriptions, one renewal date, one masked vendor recovered, one receipt to chase, one dedupe. A 15-month export for a 50-person company is typically 300–600 such rows and takes one focused afternoon to classify the first time.
Step 3: Build the SaaS Vendor Inventory
Add any identified SaaS vendor to your canonical tracker list. Ensure you capture the following fields:
- Vendor Name
- Internal Department Owner (e.g., Marketing for HubSpot)
- Annual Cost
- Estimated Renewal Date (the anniversary of the last transaction)
Once the inventory exists, the next step is putting it to work. See how controllers can build a SaaS vendor management process for delegating ownership, and how to track SaaS renewals from QuickBooks exports for turning this ledger data into a renewal calendar.
Frequently Asked Questions
Why shouldn't I just ask department leads for their software lists?
Department heads rarely keep accurate lists. They frequently forget low-cost monthly tools, are unaware of team members expensing personal utilities, and miss subscriptions billed to centralized departmental cards. Accounting transaction data is the only objective source of truth.
What is the fastest way to maintain this vendor list?
Manual exports and cross-checks become tedious as you grow. In Satellite, you can upload your general ledger CSV directly. The platform's expense-based discovery automatically parses the rows, flags software-looking merchants, and compares them against your active contract records to isolate hidden shadow IT.
Ready to turn raw accounting transaction files into an organized SaaS inventory? Start with the free Satellite renewal tracker — import your QuickBooks or general ledger exports, identify your SaaS vendors, and build a proactive renewal roadmap today. Or sign up for Satellite at a flat $299/month.