Skip to main content

Fixed Fees

Fixed commission system per transaction that replaces percentage-based commissions. Configured per currency in the tenant's SignUpIntent for enterprise customers who prefer predictable costs.

Configuration in Nova​

Field: internal_sale_fixed_fee_by_currency​

Configured as JSON in the SignUpIntent model:

{
  "USD": 0.40,
  "BRL": 2.00,
  "MXN": 8.00,
  "EUR": 1.50
}

Location: Nova > Sign Up Intents > Tenant > Internal Sale Fixed Fee By Currency

Application Rules​

System Priority​

  1. Fixed fee configured → Fixed fee applies, NO percentage
  2. No fixed fee → Traditional percentage system (configurable percentage)

Currency Logic​

  1. First priority: Fee in sale currency
  2. Second priority: Fee in USD → converts to sale currency
  3. Fallback: No fee configured → uses percentage system

Database Impact​

Table payments​

  • publicala_percentage: NULL when fixed fee applies
  • net_sale_publicala_in_usd_in_cents: Configured fee value
  • tenant_payout_in_cents: Total sale - fixed fee

Calculation Examples​

Case 1: USD Sale with USD Fee (Optimal)​

Sale: $10.00 USD
Configuration: {"USD": 0.40}
Result:
- Publicala: $0.40 USD (40 cents)
- Tenant Payout: $9.60 USD (960 cents)
- publicala_percentage: NULL

Case 2: MXN Sale with MXN Fee​

Sale: $200.00 MXN
Configuration: {"MXN": 8.00}
Result:
- Uses MXN fee (first priority - sale currency)
- Publicala: $8.00 MXN (converted to USD for reporting)
- Tenant Payout: $192.00 MXN (19200 cents)
- publicala_percentage: NULL

Case 3: EUR Sale with USD Fee (Fallback with conversion)​

Sale: €50.00 EUR
Configuration: {"USD": 0.50}
Result:
- Publicala: $0.50 USD (50 cents)
- Tenant Payout: €49.51 EUR (~$0.49 EUR converted)
- publicala_percentage: NULL

Case 4: No Fee Configured​

Sale: $100.00 USD
Configuration: {} (empty)
Result:
- Publicala: Uses configured percentage (e.g., $15.00 USD if 15%)
- Tenant Payout: Sale amount - percentage fee (e.g., $85.00 USD)
- publicala_percentage: [configured percentage value]

Special Cases​

Refunds and Disputes​

All values become negative:

Refund of $10 USD sale with $0.40 USD fee:
- net_sale_publicala_in_usd_in_cents: -40
- tenant_payout_in_cents: -960

$0 Sales (Reports - ChristianBook Case)​

Fee applies even when sale is $0:

Sale: $0.00 USD
Fee: $0.43 USD
Result:
- Publicala: $0.43 USD (43 cents)
- Tenant Payout: -$0.43 USD (-43 cents) [NEGATIVE]

Multiple Currencies Configured​

Always prioritizes sale currency to avoid unnecessary conversions.

Report Verification​

Identify Active Fixed Fee:​

  • Field publicala_percentage = NULL
  • Field net_sale_publicala_in_usd_in_cents = fixed value (not percentage)

Validate Calculations:​

  • USD: Direct fee without conversion
  • Other currencies: Fee converted using exchange rates at transaction time
X

Graph View