Merchant Mapping for Automatic Categorization

Merchant Mapping for Automatic Categorization

One of the most tedious parts of financial tracking is categorizing transactions. Every grocery store purchase needs to be tagged as groceries, every gas station as transportation, every restaurant as dining out. SavePoint's merchant mapping feature eliminates this repetitive work by learning your categorization preferences.

What Is Merchant Mapping?

Merchant mapping creates rules that automatically assign categories to transactions based on the merchant name. Once you tell SavePoint that transactions from "Whole Foods" should be categorized as "Groceries," every future Whole Foods transaction gets categorized automatically.

This works during both manual entry and import. When you import bank transactions, SavePoint applies your merchant mappings to categorize as many transactions as possible without manual intervention.

Setting Up Merchant Mappings in SavePoint

Access merchant mapping through Settings in SavePoint. You can create mappings in two ways:

During Transaction Entry: When you categorize a transaction, you can create a rule to apply the same category to future transactions from that merchant.

In Settings: Go to Settings, then Merchant Mapping, to view, edit, and create mapping rules directly. This is useful for setting up common merchants before you start importing data.

Best Practices for Merchant Mapping

Start with Your Most Common Merchants: Look at where you spend most frequently. Setting up mappings for your top 20 merchants will handle the majority of your transactions.

Use Partial Matching: If a merchant name varies slightly (like "AMAZON.COM" vs "AMAZON MKTPLACE"), create a mapping that matches the common portion. SavePoint can match partial text patterns.

Review Periodically: As your spending patterns change, you might need to add new mappings or adjust existing ones. A quarterly review keeps your auto-categorization current.

Handle Ambiguous Merchants: Some merchants are hard to categorize automatically. Amazon could be groceries, household supplies, or entertainment depending on what you bought. For these, you might skip mapping and categorize manually, or use a general category like "Shopping" and recategorize specific purchases.

The Import Workflow

When you import transactions from your bank, SavePoint applies merchant mappings to auto-categorize. The import process shows you which transactions were auto-categorized and which need manual attention. This lets you focus your time on the transactions that actually need decisions rather than mechanically categorizing routine purchases.

A well-maintained merchant mapping list can auto-categorize 80% or more of your transactions, dramatically reducing the time needed to keep your finances up to date.

Handling Edge Cases

Not every transaction fits neatly into automatic categorization:

Split Transactions: A Target purchase might include groceries, clothing, and household items. You cannot auto-categorize these accurately. Either use a general category or manually split the transaction.

Irregular Merchants: One-time purchases from merchants you will never visit again do not need mappings. Just categorize them manually.

Category Changes: If you restructure your categories, you may need to update existing mappings to use the new category names.

The time invested in setting up merchant mappings pays dividends through faster transaction processing month after month. It is one of those setup tasks that makes ongoing financial tracking much less tedious.