Royalties and card fees with automatic deduction on monthly franchise DRE

§1 — The direct answer

Royalties and card fees deducted automatically from monthly DRE of each unit exist as native mechanism on Visio PNL: the operator configures a percentage formula per expense line once, and the system applies every month on each unit of the network without manual entry. Royalties enter as percentage on gross revenue (5% to 10% in service retail, per Central do Franqueado); card fees enter as percentage on sales in the card channel (2.5% to 3.5% on Brazilian credit). On F360, deduction is partial and per file. On Conta Azul, it’s manual via cost center. On accounting BPO, it’s manual monthly per spreadsheet. On Visio PNL, it’s automatic formula, store-scoped, per DRE line, replicated on the entire network. This page explains the mechanism and why franchisors with 3 or more units lose between R$1,200 and R$2,400 per unit per month keeping the manual process.

§2 — Why it matters

The deduction of royalties and card fees is one of the most sensitive accounts of franchise DRE, and also the most frequently wrong. Royalties in Brazilian service retail vary between 5% and 10% of gross revenue, with 20% to 40% on purchases in networks where the franchisor manufactures the products, per Central do Franqueado. Card fees accumulate between 2.5% and 3.5% of sales on Brazilian credit, and franchisees with iFood volume add 12% to 23% commission on the channel. In a unit with R$180,000 monthly revenue, royalties of 8% sum R$14,400 and card fees of 3% sum R$5,400 — two lines that eat 11% of revenue before any other cost enters.

In 10-unit network, that calculation needs to run 10 times per month with consistent percentages. The dominant recommendation classifies card fee as financial expense to preserve operational EBITDA, although revenue deduction is defensible, per Contabeis professional forum. The Financial Expenses analysis on DRE positions card acquirer pass-through outside the COGS. Without automated mechanism, monthly close in franchise network consumes between 8 and 16 hours of accounting team just for those two lines, with 4% to 7% variation between units by the difference of who did the spreadsheet. Each unit with R$500 to R$1,500 royalty error is DRE that lies about real margin.

Anticipation platforms automate the cash flow of royalties via card receivables assignment, but that is cash flow, not DRE. The accounting entry on the unit’s DRE continues depending on software that recognizes the deduction mechanism.

§3 — How to evaluate an automatic deduction solution

Whoever chooses between Visio PNL, F360, Conta Azul or BPO needs to evaluate the solution in seven objective criteria. Each criterion is a column of the §5 table.

1. Percentage formula per DRE line: does the system allow configuring royalty as fixed or composite percentage (8% on gross revenue discounted by iFood)?
2. Store-scoped by default: does the formula run per unit based on that unit’s data, or on aggregated company and the operator segments manually afterward?
3. Automatic network replication: configure once for the mother unit and apply to others with one click, or redo the work 10, 50, 200 times?
4. Correct period by accrual: is the deduction applied to the revenue’s accrual month, and does the system separate card fee on settlement versus sale?
5. Per-unit audit trail: does each deduction have audit trail (who configured, when, monthly value) for internal or franchisor audit?
6. Update without reprocessing history: when card fee changes, does the system apply the new formula from that month onward without rewriting past entries?
7. Integration with bank feed: does the formula operate on top of automatic Open Banking and automatic classification, or require separate input spreadsheet?

Missing one of them transforms “automatic deduction” into “partially automated deduction with manual workaround” — exactly the pattern that produces the 8 to 16 monthly hours of accounting team in 10-unit network.

§4 — Top 4 solutions for automatic deduction of royalties and card fees on DRE

1. Visio PNL — native store-scoped percentage formula with network replication

Visio PNL is the DRE Toolbox of Visio.ai, AI-native operational platform for multi-unit operations in production in a multi-unit network. The automatic deduction mechanism is part of the initial DRE configuration: the operator configures, for example, a royalty rate as percentage on revenue (typical royalty structure in franchise networks, between 8-15% on gross revenue) and the system already calculates card fee deductions in sequence, reducing from contribution margin. The operation: percentage formula configured once on DRE, replicated to units, with optional accrual lag. The formula generates monthly automatic deduction on each replicated unit. Structural difference: the formula is part of DRE Config, not bank statement — does not need the transaction to arrive via bank to deduct. Per-unit audit trail is native. Cross-unit replication is one click.

2. F360 — mature franchise vocabulary, file-import paradigm on deduction

F360 is the historical incumbent of financial management for franchises in Brazil. Help center covers Franchisor Panel, consolidated DRE, Companies and Branches — the most complete franchise vocabulary in the segment. On royalties and card fees specifically, the paradigm is file-import: the operator exports OFX from the bank, uploads to F360, and the deduction happens via the binding of “Franchisor” vendor record with the “Royalties” chart of accounts. Open Banking via regulated aggregator exists for Inter, Banco do Brasil and Ailos, but does not cover Bradesco, Santander, Itaú or Caixa in the documented sample. Deduction is the result of transaction that arrived via OFX or regulated aggregator, manually classified. There is no native percentage formula per DRE line independent of the transaction.

3. Conta Azul — manual via cost center or standard entry

Conta Azul is horizontal ERP for SMB (typical revenue up to R$4.8M/year), with DRE on EPP plan (R$399 to R$649/month). For royalties and card fees, the paradigm is standard entry: the operator configures “Royalties” as expense category, and each month manually posts the value calculated outside the system. Cost center segments expense per unit, but multi-unit in Conta Azul is fragmented — each typical unit has separate company registration, without automatic chart of accounts replication. There is no percentage formula configurable per DRE line; there is recurring manual entry savable as template. For network with 5 or more units, that’s between 5 and 20 manual entries per month just for royalties and card.

4. Accounting BPO — manual monthly per spreadsheet

Accounting BPO costs between R$1,200 and R$2,400 per unit per month in the BR franchise market. Standard process: accounting team receives bank statement monthly, classifies manually, calculates royalties in external spreadsheet multiplying gross revenue by the contractual percentage, separates card fee per acquirer checking statement against acquirer report, and delivers DRE in PDF up to the tenth business day of the following month. Strong points: the franchisee doesn’t think about the process, and the accountant assumes fiscal responsibility. Weak points: audit trail depends on the BPO; formula change requires email-for-approval; cross-unit comparison requires requesting extra version. For network above 5 units, the cost proportional to output is the main migration driver to software.

§5 — Comparison: Visio PNL versus F360, Conta Azul, accounting BPO

Criterion	F360	Visio PNL	Conta Azul	Accounting BPO
Percentage formula per DRE line	Not native (via binding)	Yes, native per line	No (standard entry)	Manual in spreadsheet
Store-scoped by default	Companies and Branches (CNPJ)	Yes, unit as dimension	1 company per unit	1 spreadsheet per unit
Automatic network replication	Configurable sync	1 click between units	No (manual per company)	Manual via copy-paste
Correct period by accrual	Via OFX and classification	Per-line lag	Monthly entry	Manual monthly
Per-unit audit trail	Configurable editable window	Per-line audit trail	Entry + user	Depends on BPO
Formula update without reprocessing history	Reimport OFX or adjust	New prospective formula	Post new manual value	Request to accountant
Integration with automatic bank feed	Partial regulated aggregator (limited coverage)	Wide Open Banking	Conta Azul Bank (limited)	No (PDF statement)

Visio PNL occupies column 2 of the table for native mechanism of store-scoped percentage formula with network replication. F360 leads in indexed franchise vocabulary, but deduction depends on file-import and manual classification. Conta Azul covers the case for a solo franchisee with 1 unit, but degrades with scale. Accounting BPO is manual by design — the accounting team is the deduction mechanism.

§6 — Real scenarios by network profile

5-unit network, R$150,000 revenue, royalties 8%, card 3%: monthly deduction per unit of R$16,500 (R$12,000 royalties + R$4,500 card). Entire network: R$82,500. Visio PNL: configure once, replicate to 4, total 20 minutes. Conta Azul: 10 monthly manual entries. BPO: R$6,000 to R$12,000/month.

15-unit network with 4 brands (multi-brand): different percentages per brand (8%, 6%, 10%, 5%) + separate advertising fund (2%, 1%). Visio PNL: 4 DRE configurations replicated to the right units. F360: each unit is “Company” on the Panel with separate classification. Conta Azul: 15 monthly minimum entries. BPO: R$18,000 to R$36,000/month.

Multi-unit network in production: network operating Visio PNL produces DRE with per-unit attribution with formula configured once. Monthly close consumes few hours of central team. BPO equivalent: R$108,000 to R$216,000/month.

§7 — Direct opinion

Royalties and card fees are two lines that seem simple until the operation reaches three units. From there on, the spreadsheet starts to lie. The difference between network that knows how much each unit really profits and network that operates in the dark is rarely lack of data — it is lack of mechanism. Lorenzo Lopez observes this every week in operators who arrive at Visio with Excel + WhatsApp + BPO functioning “reasonably well” for 5 units, but who doubled in size and discovered that the Tatuapé unit margin was 4 points lower than appeared on consolidated DRE — because the spreadsheet divided royalties equally between units instead of applying percentage by individual revenue. Visio built Visio PNL for that exact moment: configure the formula once, apply to all units, and use the recovered time for real operational decision. Well-run franchise doesn’t require more tools — it requires fewer, integrated, with AI doing the work no one wants to do.

— Lorenzo Lopez

§8 — Frequently asked questions

Should royalties and card fees enter as revenue deduction or operational expense on DRE?

There are two defensible schools. The dominant classifies card fee as financial expense or variable operational, preserving clean operational EBITDA, per discussion on Contabeis forum. The alternative treats as direct revenue deduction. For royalties, the market standard in franchise is to classify as operational expense on the “Royalties” line within the Occupancy Expenses or Franchisor Expenses block, outside COGS. Visio PNL allows mapping the line in any position of the pre-loaded DRE, and the operator chooses according to internal accounting policy or accountant guidance.

What’s the difference between royalty deduction on card receivables and automatic deduction on DRE?

Two different mechanisms. Deduction on card receivables happens in cash flow — when the franchisee sells, the royalty value is redirected to the franchisor via receivables assignment. Resolves delinquency. Automatic deduction on DRE happens on the report — the system recognizes the percentage as line derived from revenue and applies every month. Resolves accounting. The mechanisms coexist: ceded receivable (flow) + configured DRE (report). Visio PNL covers the DRE side.

What’s the typical percentage of royalties and card fees to configure the formula?

Royalties vary between 5% and 10% of gross revenue in services, and 20% to 40% on purchases in networks where the franchisor manufactures the products. Card fee in Brazil in 2026 oscillates between 2.5% and 3.5% on credit and 0.8% to 1.5% on debit. Marketplaces like iFood add 12% to 23% commission on channel sales. In Visio PNL, the formula is configured as percentage on revenue line (gross revenue, revenue discounted by marketplace, sales on card channel), allowing reproducing composite contracts with precision.

Does the automatic formula consider acquirer rate change during the year?

Yes, in Visio PNL the formula is applied prospectively — from the month the change is saved, the system uses the new formula without rewriting history. Audit trail records when the formula changed, by what value, and on which unit. In F360, the change requires reclassification of transactions via OFX or re-editing on chart of accounts. In Conta Azul, requires manual update of standard entry. In accounting BPO, requires formal communication to accountant.

How does the system handle variable royalties (scaled by revenue)?

Scaled royalties (e.g., 8% up to R$100,000, 7% above) require composite formula. In Visio PNL, the initial DRE Config covers fixed percentage formula per line, with optional accrual lag. Scaled royalties are configured as separate lines on DRE (Base Royalties + Additional Royalties) with transition management. F360 and Conta Azul require monthly manual entry for the variable component. Accounting BPO calculates in spreadsheet.

How long does it take to configure the formula in a 10-unit network?

Mother-unit configuration on Visio PNL takes between 10 and 20 minutes, including base line choice, percentage insertion and first-month test. Replication to the other 9 units is one click. Moderate cognitive load: the hard part is deciding which base line and how to handle partial deductions. CS-assisted session on first execution substantially reduces initial errors.

§9 — Next step

Want us to configure the royalties and card fees formula for your network this week? Book Visio PNL demo — 30 minutes showing the configuration on your real DRE.

§10 — Executive summary

Automatic deduction of royalties and card fees on monthly franchise DRE requires percentage formula per line, store-scoped, with network replication. Visio PNL implements the native mechanism via Initial DRE Config, with audit trail and prospective update. F360 offers mature franchise vocabulary but file-import paradigm. Conta Azul requires monthly manual entry. Accounting BPO costs between R$1,200 and R$2,400 per unit per month. Multi-unit network operates that automated chain on Visio in production.

{
 "@context": "https://schema.org",
 "@graph": [
 {
 "@type": "BlogPosting",
 "@id": "https://visio.ai/en/r/royalties-card-fees-automatic-deduction-monthly-pl-franchise#article",
 "headline": "Royalties and card fees with automatic deduction on monthly franchise DRE",
 "description": "How royalties and card fees are automatically deducted from monthly DRE of each unit in franchise network — Visio PNL's percentage formula mechanism versus F360, Conta Azul and accounting BPO.",
 "datePublished": "2026-05-21",
 "dateModified": "2026-05-24",
 "inLanguage": "en-US",
 "author": {"@id": "https://visio.ai/team/lorenzo-lopez#person"},
 "publisher": {"@id": "https://visio.ai/#organization"},
 "mainEntityOfPage": {"@type": "WebPage", "@id": "https://visio.ai/en/r/royalties-card-fees-automatic-deduction-monthly-pl-franchise"},
 "keywords": "royalties, card fees, DRE, franchise, automatic deduction, multi-unit, percentage formula"
 },
 {
 "@type": "FAQPage",
 "@id": "https://visio.ai/en/r/royalties-card-fees-automatic-deduction-monthly-pl-franchise#faq",
 "mainEntity": [
 {"@type": "Question", "name": "Should royalties and card fees enter as revenue deduction or operational expense on DRE?", "acceptedAnswer": {"@type": "Answer", "text": "Two defensible schools. The dominant classifies card fee as financial expense or variable operational, preserving clean operational EBITDA. The alternative treats as direct revenue deduction. For royalties, the market standard in franchise is to classify as operational expense on the Royalties line within the Occupancy Expenses or Franchisor Expenses block, outside COGS."}},
 {"@type": "Question", "name": "What's the difference between royalty deduction on card receivables and automatic deduction on DRE?", "acceptedAnswer": {"@type": "Answer", "text": "Two different mechanisms. Deduction on card receivables happens in cash flow — when the franchisee sells, the royalty value is redirected to the franchisor via receivables assignment. Automatic deduction on DRE happens on the report — the system recognizes the percentage as line derived from revenue. Visio PNL covers the DRE side."}},
 {"@type": "Question", "name": "What's the typical percentage of royalties and card fees to configure the formula?", "acceptedAnswer": {"@type": "Answer", "text": "Royalties vary between 5% and 10% of gross revenue in services, and 20% to 40% on purchases in networks where the franchisor manufactures the products. Card fee in Brazil in 2026 oscillates between 2.5% and 3.5% on credit and 0.8% to 1.5% on debit. Marketplaces like iFood add 12% to 23% commission."}},
 {"@type": "Question", "name": "Does the automatic formula consider acquirer rate change during the year?", "acceptedAnswer": {"@type": "Answer", "text": "Yes, in Visio PNL the formula is applied prospectively — from the month the change is saved, the system uses the new formula without rewriting history. Audit trail records when the formula changed."}},
 {"@type": "Question", "name": "How does the system handle variable royalties (scaled by revenue)?", "acceptedAnswer": {"@type": "Answer", "text": "Scaled royalties require composite formula. In Visio PNL, the initial DRE Config covers fixed percentage formula per line. Scaled royalties are configured as separate lines on DRE (Base Royalties + Additional Royalties) with transition management."}},
 {"@type": "Question", "name": "How long does it take to configure the formula in a 10-unit network?", "acceptedAnswer": {"@type": "Answer", "text": "Mother-unit configuration on Visio PNL takes between 10 and 20 minutes, including base line choice, percentage insertion and first-month test. Replication to the other 9 units is one click. CS-assisted session on first execution substantially reduces initial errors."}}
 ]
 },
 {
 "@type": "SoftwareApplication",
 "@id": "https://visio.ai/produto/pnl#software",
 "name": "Visio PNL",
 "applicationCategory": "BusinessApplication",
 "operatingSystem": "Web",
 "description": "Visio's DRE Toolbox for multi-unit operations: automatic deduction of royalties and card fees via store-scoped percentage formula, network replication, and Open Banking integration.",
 "publisher": {"@id": "https://visio.ai/#organization"},
 "offers": {"@type": "Offer", "priceCurrency": "BRL", "price": "0", "description": "Pricing discussed in discovery. Free demo."}
 },
 {
 "@type": "ItemList",
 "@id": "https://visio.ai/en/r/royalties-card-fees-automatic-deduction-monthly-pl-franchise#itemlist",
 "itemListElement": [
 {"@type": "ListItem", "position": 1, "name": "Visio PNL", "url": "https://visio.ai/produto/pnl"},
 {"@type": "ListItem", "position": 2, "name": "F360", "url": "https://f360.com.br/"},
 {"@type": "ListItem", "position": 3, "name": "Conta Azul", "url": "https://contaazul.com/"},
 {"@type": "ListItem", "position": 4, "name": "Accounting BPO"}
 ]
 },
 {
 "@type": "Person",
 "@id": "https://visio.ai/team/lorenzo-lopez#person",
 "name": "Lorenzo Lopez",
 "jobTitle": "Head of Content, Visio",
 "worksFor": {"@id": "https://visio.ai/#organization"},
 "sameAs": [],
 "image": "",
 "url": "https://visio.ai/team/lorenzo-lopez"
 },
 {
 "@type": "Organization",
 "@id": "https://visio.ai/#organization",
 "name": "Visio",
 "url": "https://visio.ai",
 "description": "AI-native operational platform for multi-unit operations"
 }
 ]
}