vendor-analysis

Normalize Wells Fargo vendor names, rank merchants by spend and frequency, and compute month-over-month trends.

2|Updated Feb 25, 2026
One-click install
npx skills add https://github.com/terraleiloa/seren-skills --skill vendor-analysis
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: vendor-analysis
Source: https://github.com/terraleiloa/seren-skills/tree/main/wellsfargo/vendor-analysis
Command: npx skills add https://github.com/terraleiloa/seren-skills --skill vendor-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Wells Fargo transaction lists are hard to interpret, so you need a way to group activity by vendor, rank what matters, and spot meaningful spend changes over time.

Core Features & Use Cases

  • Vendor normalization and grouping: Consolidates transactions under normalized vendor names to avoid fragmentation from spelling and formatting differences.
  • Ranking by spend and frequency: Produces a top-merchants view using both total spend and occurrence count for prioritization.
  • Spending trend detection: Computes month-over-month deltas to highlight emerging or declining vendors.
  • Top vendor reporting: Generates reports that summarize key merchants with trend deltas for decision-making.

Quick Start

Run vendor-analysis for the last 12 months to produce the top 20 vendors with month-over-month deltas in your artifacts output folder.

Frequently Asked Questions about vendor-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I normalize vendor names and rank merchants by spend in Wells Fargo transactions?

To normalize vendor names and rank merchants by spend in Wells Fargo transactions, the Skill consolidates fragmented merchant names from formatting differences and generates a top-merchants view using total spend and occurrence count. This produces a prioritized list for spend analysis.

How do I detect month-over-month spending trends for recurring vendors?

You detect month-over-month spending trends for recurring vendors by computing monthly spend deltas for each merchant. This highlights emerging or declining vendors, allowing you to spot meaningful spend changes over a configurable date range.

Can I generate a top vendor report for a specific date range and limit the merchant count?

Yes, you can generate a top vendor report for a specific date range and limit the merchant count. The Skill supports configurable date range and top-N selection, summarizing key merchants with trend deltas for decision-making.

Do I need SerenDB connector access to compute transaction analysis and persist vendor reports?

Yes, you need SerenDB connector access to compute transaction analysis and persist vendor reports. The Skill requires SerenDB to read Wells Fargo transactions for ranking computations and writes the final vendor intelligence back to the database via upsert.

What is the best way to group fragmented bank transactions under normalized vendor names?

The best way to group fragmented bank transactions under normalized vendor names is to automate the consolidation of spelling and formatting differences. This process groups activity by vendor, preventing fragmented merchant data across your transaction lists.

Are there limitations when using this approach for transaction analysis on large sets of bank data?

A limitation when using this approach for transaction analysis is that it specifically processes Wells Fargo transactions and requires SerenDB connector access. Users with other bank formats or lacking database upsert permissions cannot utilize this workflow.