Skip to main content

Allocate Custom Expenses by Country

Split shared costs by revenue, or assign an expense to specific countries, to make your country-level Summary reports more useful.

Written by Triple Whale

Country allocation tells Triple Whale how much of a custom expense belongs to each country. You can split an expense automatically based on daily order revenue, or choose countries and set their percentages yourself.

For example, you can share a software subscription across your markets or assign a UK warehouse expense entirely to the United Kingdom.

Before you start

Country level reporting and Country Allocation are available for stores on a paid plan.

You can use it with both fixed expenses and variable expenses. For help setting up an expense, see Add Custom Expenses.


Choose how to split an expense

Default: by revenue

Choose Default — by revenue (shipping country) for costs that apply to your whole business.

Triple Whale splits each day's expense using each country's share of that day's order revenue. The split can change from one day to the next.

For example, suppose a shared service costs $100 per day. On one day, your order revenue is split like this:

Illustrative example. All amounts use the same currency.

Country

Order revenue

Revenue share

Expense allocated

United States

$600

60%

$60

Canada

$300

30%

$30

United Kingdom

$100

10%

$10

Total

$1,000

100%

$100

Filtering Summary to Canada includes $30 of this expense for that day. If Canada's revenue share is 50% the next day, its share of that day's $100 expense is $50.

The allocation preview uses recent revenue from the last 30 days as a guide. Actual allocation is calculated day by day, so the preview may differ from your report.

Selected countries only

Choose Selected countries only when an expense belongs to one country or a specific group of countries.

Select the countries, then keep the equal split or enter your own percentages. Your percentages must total 100%.

For example, suppose a $1,000 agency fee covers the United States and Canada. You assign 70% to the United States and 30% to Canada.

  • The United States receives $700 of the expense.

  • Canada receives $300.

  • Other countries receive none of this expense.

The expense still follows its saved dates and schedule. The 70/30 split stays the same even when daily revenue shares change.

Common use cases

Your expense

Suggested setup

Why use it

Software used across the business

Default: by revenue

Share the cost in line with each country's daily revenue.

A warehouse serving only the UK

Selected countries only: United Kingdom, 100%

Keep the warehouse cost in the country it supports.

An agency supporting the US and Canada

Selected countries only: your agreed percentages

Match the split to the work the agency provides.

Launch costs for a new market

Selected countries only: the launch country, 100%

Assign a fixed cost to that country even before it generates revenue.


Set up country allocation

  1. Add a fixed or variable custom expense, or edit an existing expense.

  2. Complete the expense details, including its amount or rate and dates.

  3. Under Country allocation, choose the revenue-based option or Selected countries only.

  4. For selected countries, choose your countries and set percentages totaling 100%.

  5. Click Save.

A successful save shows Custom Expense saved. The Country Allocation column shows the saved method or selected country codes. Click that entry to edit it later.

Tips for editing percentages

  • Search for a country by its name or two-letter code, such as CA.

  • Adding a country resets all selected countries to an equal split.

Choose all your countries before entering custom percentages. Percentages can use up to two decimal places.


Frequently asked questions

What happens to my existing expenses?

Expenses without a saved country allocation use the default revenue-based split. You do not need to recreate them. Review expenses that should belong only to specific countries.

Do report filters change the revenue-based split?

Additional report filters, such as an order-tag filter, do not recalculate the country percentages.

For example, if Canada receives 30% of a day's fixed expense, applying a VIP order-tag filter does not change that share. Other report values can still change.

Which country does the default option use?

It uses the order's shipping country. If that is missing, Triple Whale uses the point-of-sale location's country, then the store's home country.

If a day has no positive order revenue to use for the split, that day's expense goes to the store's home country.

How does this work with variable expenses?

Triple Whale first calculates the expense from its saved metric and rate, then applies the country split.

For example, if the calculated expense is $200 for a day, a 70/30 allocation assigns $140 and $60 to your selected countries.

Why can't I save my selected-country split?

Select at least one country. Each percentage must be between 0% and 100%, and the total must be 100%. Complete the other required expense fields too.

What if I only ship to one country?

You may see a simplified message instead of the full options. Select Configure country allocation anyway to choose a different setup.

Can I import country percentages from Google Sheets?

Country percentages are not imported from Google Sheets. New imported expenses use the default revenue-based allocation. Set a custom country split in Cost Settings.

Does this change Pixel Attribution?

These settings apply to everywhere custom expense data is used across Triple Whale, including the Pixel Attribution page.

Did this answer your question?