When a franchise grows past 20 locations, the accounting workload doesn’t just grow — it multiplies. Every new location means another bank account to reconcile, another set of books to close, another P&L to review. Without automation, you’re either hiring more accounting staff or falling behind.
This guide covers the specific workflows you can automate across a multi-location franchise and the tools that make it possible.
The 20-Location Threshold
Something changes when a franchise crosses roughly 20 locations. The accounting team can no longer rely on manual processes that worked at 5 or 10 locations:
- Bank reconciliation for 20 accounts takes days, not hours
- Monthly close becomes a multi-week process
- Royalty reporting requires pulling data from 20+ sources
- Exception handling gets buried in volume
- Staff turnover is devastating because institutional knowledge is high
The solution isn’t more people — it’s automation that makes each person more effective.
Five Workflows to Automate
1. Bank Feed Connections and Transaction Categorization
The manual version: Log into each location’s bank portal, download transactions, import into accounting software, categorize each transaction manually.
The automated version: Bank feeds push transactions directly into each entity’s books. Categorization rules (set once) apply across all locations. The accounting team reviews exceptions only.
Time saved: 10-15 hours/week for a 20-location franchise.
What to look for in software:
- Direct bank feed connections per entity (not shared bank accounts)
- Customizable categorization rules that can be templated across locations
- Exception flagging for transactions that don’t match any rule
2. Standardized Chart of Accounts
The manual version: Each location has a slightly different chart of accounts because they were set up at different times by different people. Revenue categories don’t match. Expense classifications vary. Consolidated reporting requires manual mapping.
The automated version: One chart of accounts template applied to all locations. New locations inherit the standard structure automatically. Any updates propagate across all entities.
Time saved: 3-5 hours/week in reconciliation and report cleanup.
What to look for in software:
- Template-based chart of accounts that can be applied at entity creation
- Ability to lock or restrict account modifications at the location level
- Consistent account numbering across all entities
3. Consolidated Reporting
The manual version: Export financial reports from each location’s software. Paste into a master spreadsheet. Manually align account categories. Build consolidated views. Repeat monthly.
The automated version: One click generates a consolidated P&L, balance sheet, or cash flow statement across all 20+ locations. Filter by location, region, date range, or custom grouping.
Time saved: 5-8 hours/month per reporting cycle.
What to look for in software:
- Native multi-entity consolidated reporting (not CSV export and import)
- Drill-down from consolidated to individual entity level
- Side-by-side location comparison
- Export in formats your franchisor or board requires
4. Royalty and Fee Calculations
The manual version: Pull gross revenue for each location. Apply the royalty percentage. Calculate marketing fund contributions. Assemble the report. Send to franchisor. Track payments.
The automated version: Revenue data flows from each location’s books into a royalty calculation workflow. Percentages are applied automatically. Reports are generated on schedule. Payment tracking is centralized.
Time saved: 4-6 hours per reporting period.
What to look for in software:
- Per-entity revenue tracking that feeds directly into royalty calculations
- Support for different fee structures across locations (if applicable)
- Historical royalty report access for audits
5. Permission Management and Access Control
The manual version: Create and manage user accounts across 20+ separate software subscriptions. When someone leaves, deactivate their access in each system individually. When roles change, update permissions location by location.
The automated version: Central permission management with entity-level access control. One user account, multiple entity permissions. Onboarding and offboarding happens in one place.
Time saved: 2-3 hours/week for team management.
What to look for in software:
- Role-based access control with entity-level granularity
- Single sign-on for all entities
- Audit trail of who accessed what and when
Automation ROI Calculator
Here’s what automation typically saves a 20-location franchise:
| Workflow | Hours Saved/Month | Monthly Value (at $50/hr) |
|---|---|---|
| Bank feeds + auto-categorization | 40-60 hrs | $2,000-3,000 |
| Standardized chart of accounts | 12-20 hrs | $600-1,000 |
| Consolidated reporting | 5-8 hrs | $250-400 |
| Royalty/fee calculations | 4-6 hrs | $200-300 |
| Permission management | 8-12 hrs | $400-600 |
| Total | 69-106 hrs | $3,450-5,300 |
That’s roughly one full-time equivalent saved per month — before accounting for the software cost savings of moving from per-entity to flat-tier pricing.
Implementation Roadmap
Month 1: Foundation
- Migrate to multi-entity software — Start with 3-5 locations as a pilot
- Standardize chart of accounts — Build your template before migrating remaining locations
- Connect bank feeds — One location at a time, verify categorization rules
Month 2: Scale
- Migrate remaining locations — Use the validated template and process
- Set up categorization rules — Apply rules from pilot locations to new ones
- Train location managers — On their view and what they can access
Month 3: Optimize
- Build consolidated reports — Standard monthly reporting package
- Automate royalty calculations — Based on the reporting framework
- Review and refine — Identify remaining manual steps and automate or simplify
Ongoing
- New location onboarding — Should take under an hour with templates in place
- Monthly process review — Look for exceptions that could become rules
- Quarterly reporting evolution — Add new reports as the business needs them
The Bottom Line
At 20+ locations, franchise accounting automation isn’t a nice-to-have — it’s the difference between an accounting team that’s drowning in data entry and one that’s providing strategic insights. The tools exist to automate the repetitive work. The question is whether you’re using them.
Start with multi-entity accounting software that doesn’t charge per location. Then automate from the highest-volume workflows down.