Mapping is the process of connecting raw data fields from your integrations to the standardized report fields in Fran Metrics. This is one of the most important configuration steps — it determines what data shows up in your reports and how it's organized.
Different businesses use different chart-of-accounts structures, POS categories, and naming conventions. Mapping lets Fran Metrics translate your unique data structure into a consistent reporting format that works across all your units.
For example, one franchise might call it "Food Sales" while another calls it "Revenue - Food Items." Mapping ensures both end up in the same "Food Revenue" line on your scorecard.
You manually assign each data field from your source to the corresponding report field in Fran Metrics. This gives you full control over how data is organized.
Fran Metrics includes an intelligent Smart Mapping feature that automatically suggests mappings based on predefined rules and patterns. Smart Mapping can:
For organizations that need a unified financial structure across all franchise units, SCOA Mapping provides a centralized chart of accounts that sits above the unit-level mapping. Instead of mapping each unit's QBO accounts directly to data points, you define a single standardized hierarchy — then map unit accounts to that. This makes consolidated P&L reporting consistent no matter how differently each unit's QuickBooks is set up.
SCOA Mapping includes Smart Mapping Rules (match accounts by type and name patterns) and AI-powered suggestions from FRAN to speed up configuration. Your existing mapping setup continues to work — SCOA is an optional layer you can toggle on when ready.