Active Vendors, Sage

Card class: Non-Hero • Category: Ecommerce Platform

Count of vendors with activity in the period (open POs, recent Bills, or payments). A vendor master health and spend-concentration signal.

​

At a glance

The number of distinct vendors with genuine activity in the period: an open purchase order, a recently posted Bill, or a payment made. This is not the total count of vendor records (which only ever grows as old suppliers are never deleted), it is the live count of suppliers you are actually transacting with. Read it two ways: as a vendor-master hygiene signal (a count far below your total records means most of your master is dead weight) and as a spend-concentration signal (a small active count carrying large spend means supply risk is concentrated). The card reads the AP sub-ledger and purchasing records, dimension-tagged in Sage Intacct so finance can pivot the active base by Department, Location, or Entity and see who you really depend on.

​

Calculation

Calculated automatically from your Sage data. The card counts distinct vendors with qualifying activity (open PO, posted Bill, or payment) in the period, de-duplicated. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.

​

Worked example

A UK B2B outdoor-gear brand on Sage Intacct, single entity, GBP base currency, roughly 15M GBP annual revenue sourcing finished goods and components from a mix of UK, EU, and Far East suppliers on Net-30 and Net-60 terms, selling through a BigCommerce B2B portal and a Shopify DTC line. Snapshot 14 Apr 26. The vendor master holds 612 records in total; the card counts the active subset for the trailing period. Five things to notice:

1. 135 active vendors out of 612 records means roughly three-quarters of the vendor master is dead weight. That 477-record archive is not harmless: every dormant vendor is a potential duplicate, a stale bank detail that could be a payment-fraud vector, and clutter that slows Bill entry and reporting. The card makes the gap visible. Most businesses never realise how much of their master is inactive because the total count only ever grows. A periodic review to deactivate (not delete, for audit history) genuinely dormant vendors tightens controls and speeds AP.
2. 38 core suppliers carry 81% of spend, which is the concentration story. This is the read that matters for risk. A supply base where a handful of vendors carry the overwhelming majority of spend is efficient but fragile: one core supplier failing, raising prices, or putting you on stop-supply hits hard. Pivot the active base by spend and the Pareto curve is almost always steep. Pair this card with Vendor Payment On-Time Rate to make sure the 38 suppliers you most depend on are the ones you are paying most reliably, because losing goodwill with a core supplier is far costlier than with a long-tail one.
3. The 26 one-time vendors this period are worth a glance for maverick spend. A rising count of one-time vendors often means buying is happening outside the approved supplier list, which forfeits negotiated pricing and weakens controls. The Department dimension cut shows which cost centre is generating the one-off vendors. On this account most traced to a single project team buying ad-hoc, which became an easy procurement win: consolidate that spend onto a contracted supplier.
4. A falling active count is a signal in both directions. Fewer active vendors can mean healthy consolidation (you negotiated and concentrated spend, which is good) or it can mean a shrinking operation buying less (which tracks a revenue decline). The number alone does not tell you which; read it against purchasing volume and revenue. A consolidation that holds spend flat while cutting vendor count is a procurement win; a vendor count falling because the business is buying less is a demand signal.
5. Cross-reference the active base against payment behaviour and aging. The active count is the denominator for the AP relationship cards. Read it next to AP Aging 60+ Days: if your late AP concentrates in a small number of your active vendors, that is a sharper relationship risk than the same total late balance spread across many. Knowing you have 135 active vendors and that the late ones are 4 of your 38 core suppliers turns an abstract AP number into a named action list.

​

Sibling cards merchants should reference together

​

Reconciling against Sage

Where to look in Sage: The native Sage Intacct views to run side by side with this card:

Accounts Payable → Vendors (the full vendor master with status flags; filter to Active status for the closest baseline) Reports → Accounts Payable → Vendor Activity Report (vendors with Bills or payments in the period, the closest native equivalent to this card) Reports → Purchasing → Open Purchase Orders (vendors with open POs, part of the active definition) Reports → Accounts Payable → AP Ledger (the transaction-level Bill and payment detail behind the count) Interactive Custom Report (ICR) built on the AP and Purchasing data sources counting distinct vendors with any open PO, posted Bill, or payment in the trailing window, pivoted by Department and Location dimensions

The Vendors list shows every record with its status; this card counts only those with activity in the window, so it will read well below the Active-status record count. The Vendor Activity Report is the closest native match because it already filters to transacting vendors. For Multi-Entity Console accounts, a shared supplier transacting in two entities is one vendor for concentration purposes but may exist as two records; confirm whether your master uses shared or per-entity vendor records before comparing. Common reconciliation pitfalls:

• Active status vs active activity. A vendor flagged Active in the master but with no transactions in the window is not active by this card’s definition. The gap between the two counts is exactly the dormant-but-not-deactivated population.
• PO-only vs Bill-required. Whether a vendor with an open PO but no posted Bill counts as active depends on the activity definition in the field map. A stricter Bill-required setting reads lower.
• Duplicate vendor records. The same supplier entered twice (different spellings, a re-keyed record) counts as two vendors here and in most native reports until the duplicates are merged.

Why our number may legitimately differ from a Sage Intacct Vendor Activity Report: Cross-connector reconciliation: The cross-channel point is that commerce platforms see customers and orders, never your supply base. Your suppliers, your spend concentration, and your master hygiene live entirely in Sage Intacct. This card turns the AP sub-ledger into a live read of who you actually depend on, and the dimensional carry-through means the answer is always attributable to a Department or Location, so a procurement-consolidation conversation lands on a specific owner.

​

Known limitations / merchant FAQs

Why is this lower than my total vendor count? Because it counts only vendors transacting in the period, not every record in the master. Vendor masters only ever grow, since old suppliers are deactivated rather than deleted for audit history, so the total record count drifts far above the number you actually buy from. The gap between the two is the dormant population, and seeing it is the first step to a vendor-master cleanup. What counts as “active”? By default, a vendor with any open purchase order, a Bill posted in the trailing window, or a payment made in the window. The exact definition is configurable. A stricter setting counts only vendors with a posted Bill, which excludes PO-only relationships where nothing has yet been billed. Pick the definition that matches how you think about your supply base and set it in the field map. Should I worry about high vendor concentration? Concentration is efficient but fragile. A supply base where a few vendors carry most of your spend gives you negotiating leverage and simpler management, but it also means one supplier failing hits hard. The right response is not to fragment your base, it is to know your concentration, have contingency for your core suppliers, and pay them reliably. Use this card to size the concentration and Vendor Payment On-Time Rate to protect the relationships. A rising count of one-time vendors, what does it mean? Usually maverick or off-contract spend: buying happening outside the approved supplier list, which forfeits negotiated pricing and weakens controls. Pivot by Department to find the source. It can also be legitimate (a one-off project, a sample purchase), so investigate rather than assume. A steady trickle is normal; a sustained rise is a procurement-governance flag. Does deactivating a vendor remove it from history? No. Deactivating sets the vendor inactive so it cannot receive new transactions, but its historical Bills and payments remain for audit. This is why the master grows: deletion would break the audit trail. Deactivation is the correct cleanup action, and it tightens controls by closing off dormant records (and their stale bank details) to new activity. Sage Intacct vs Sage 50 / 100 / 200 / X3? This connector targets Sage Intacct. Every Sage product has a vendor master and the concept of active suppliers, but the status model, activity definitions, and API differ. Sage 50 and 200 are UK SMB products; Sage X3 is a different mid-market ERP. The active-vendor concept ports directly; the field map and connector do not. If you run one of those, reach out about connector availability. How do duplicate vendor records affect the count? The same supplier entered twice counts as two until the records are merged. Duplicates inflate the active count and, worse, fragment spend so concentration looks lower than it really is and you may miss volume discounts. A periodic duplicate-merge exercise is good hygiene; this card’s count drops cleanly once duplicates are consolidated, which is itself a useful confirmation the merge worked. Multi-entity: is a shared supplier counted once or twice? It depends on whether your master uses shared (group-level) or per-entity vendor records. With shared records, a supplier transacting in two entities is one vendor for concentration purposes. With per-entity records, it appears as separate vendors. The card de-duplicates within a single record model but cannot merge what the master holds separately. Confirm your master configuration before reading the consolidated count. How fresh is the data? The card refreshes on the standard cadence, typically within 5 to 15 minutes of the most recent posted AP or purchasing activity in Intacct. A newly transacting vendor appears on the next refresh; a vendor that goes quiet drops out of the active count once it falls outside the activity window.

---

​

Tracked live in Vortex IQ Nerve Centre

Active Vendors is one of hundreds of KPI pulses Vortex IQ tracks across Sage and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English. Start for free or book a demo to see this metric running on your own data.