Skip to main content

Allocate a cost across products

An overhead only shows up in a product's margin once you say which products it belongs to. Allocating a cost entry does that. You can split it across products, brands, suppliers or sales channels directly, or let SKU.io spread it across the lines of a document, such as a purchase order, in proportion to their revenue, cost, quantity, weight or volume.

Allocations are for reporting only. They change what the Profitability and Contribution Margin reports show, but no accounting entry is created.

Before you begin​

  • Record the cost entry. It needs an Unallocated amount.
  • Decide which basis is fair. A shared warehouse cost might follow quantity or volume. A sales channel's subscription belongs to that channel alone.

Allocate a cost​

  1. Go to Insights → Cost Entries and open the entry.

  2. Click Allocate. The Allocate Cost wizard opens on Target.

  3. Choose what to allocate to:

    • Direct Entities to allocate to specific products, brands, suppliers or sales channels.
    • Document Lines to allocate across the line items on purchase orders, sales orders, transfers, stock takes or assemblies.

    Choose Target Type: Direct Entities or Document Lines

  4. Click Next.

  5. Pick a tab, Product, Brand, Supplier or Channel, and tick each target. For document lines, the tabs are Purchase Order, Sales Order, Transfer, Stock Take and Assembly, and you can narrow them with Document date from and Document date to.

    Select Entities, with tabs for Product, Brand, Supplier and Channel

  6. Click Next.

  7. Under Amount to Allocate, keep the full amount or enter part of it. Available shows what's left to allocate.

  8. Choose how to split it:

    • For direct entities, Equal Split divides the amount evenly, and Manual Amounts lets you type each target's share. Remaining Available shows what's left.
    • For document lines, pick a Proration Strategy: Revenue Based, Cost Based, Quantity Based, Weight Based or Volume Based. Each line gets its share of that measure. With several documents selected, the amount is split equally between the documents first, then across each one's lines.

    Distribution Method with Equal Split chosen

  9. Click Next.

  10. Under Allocation Timing, choose One-time and set the Allocation Date, the day the cost is recognized in your reports. To spread it over several months instead, choose Amortize. See Amortize a prepaid cost.

    Allocation Timing with One-time chosen

  11. Click Next, check the Review Allocation summary, and click Confirm Allocation.

The entry's Allocated and Unallocated totals update, and each target appears under Allocations with its Allocation Date, Strategy and Amount. A document-line allocation lands on the products on those lines.

An allocated cost entry with its allocation to a product

Allocate what's left​

You can allocate an entry in several passes, for example half to one channel now and the rest later. Each pass works on the Unallocated amount. The entry shows Partially Allocated until nothing is left.

Work with the allocations table​

Every allocation is a row on the entry's Allocations tab. Besides its Target, Allocation Date, Strategy and Amount, each row shows:

ColumnWhat it shows
Period Start, Period EndThe dates the allocation covers, if it has them.
Order ReachReached orders with the number of order lines, or No sales in period.
Reached OrdersHow much of the amount landed on order lines.
Source LineThe vendor charge it came from, if the entry has source lines.

Use the Target Type, Strategy, Order Reach and Date filters to narrow the list. Pick Reached orders or No sales in period under Order Reach to see one side only, and sort by that column to group them. To learn what the two mean, read See whether a cost reached your orders.

The Allocations table with its filters

Import allocations​

To allocate a cost to many targets at once, import them from a file.

  1. On the Allocations tab, click Import. The button is off when nothing is left to allocate.

  2. Click Download Template, and add one row per allocation.

  3. Drop the file in, click Choose File, or paste the rows under Paste CSV / TSV data. Click Next: Map Columns.

  4. Check that each Your Column maps to the right field, and click Next: Validate.

  5. Read the preview. Errors lists each row that will be skipped and why.

    The preview listing a row with an unknown SKU

  6. Click Import, such as Import 2 Allocations.

The file can be CSV, TSV or Excel, with up to 5,000 allocations.

ColumnRequiredWhat to enter
Allocation TypeYesproduct, brand, supplier or channel, in any case. Sales Channel also works.
Allocation TargetYesThe product's SKU, or the brand, supplier or channel name, in any case. It must already exist.
Allocation AmountYesMore than 0, in the entry's currency.
Allocation DateNoThe day it's recognized in reports. Left blank, it's the entry's Cost Date.
Allocation Period Start, Allocation Period EndNoThe dates it covers. Give both or neither.

Rows with errors are skipped, and the valid rows are imported together. Fix the skipped rows and import just those. Two problems stop the whole file: when no row is valid, and when the rows add up to more than the entry has left to allocate.

MessageWhat to do
No product has SKU 'x'.Fix the SKU.
Brand 'x' not found.Fix the name. The same message covers suppliers and channels.
Allocation type 'x' is not supported — use product, brand, supplier or channel.Use one of those four.
Allocation amount is required and must be greater than 0.Enter a positive amount.
Give both a period start and a period end, or neither.Complete or clear the period.
Period start is after period end.Correct the dates.
These allocations total x but the cost entry only has y left to allocate. Lower the amounts or remove rows, then validate again.Reduce the file's total.
Importing always adds allocations

An import never updates or replaces an allocation. Each valid row is a new direct allocation, even when the target and date match one you already have. The preview warns you about those rows, but they're still imported.

Export allocations​

  1. Set the columns and filters you want. The file follows your visible columns.
  2. Click Export.
  3. Under Records to export, choose All records, Filtered results or Current page. With rows ticked, you can also export just those.
  4. Choose XLSX (Excel) or CSV, and click Export.

The file always includes ID, Allocation Type, Allocation Target and Allocation Amount, so it can be read back in. With Order Reach visible, you also get Reached Orders Amount and Order Lines Reached. Exporting and importing a file adds new allocations, so don't use it to change existing ones.

Remove allocations​

The amount goes back to Unallocated, and any orders the allocation reached are updated shortly after.

  • To remove one allocation, click the delete icon on its row.
  • To remove several, tick their rows. Choose Selected Only, or All Filtered for everything matching your filters, then click Remove.
  • To start over, click Remove All. It ignores your filters.

None of these can be undone. Allocations created by an amortization schedule can't be removed one at a time, and Remove skips them. Delete the schedule instead.

Next steps​

Video transcript

An overhead only reaches a product's margin once you allocate the cost. To start, open the Insights menu, then choose Cost Entries. Every entry you've recorded is listed on this page. Click the entry you want to allocate, and let its page load. Then click Allocate, and the Allocate Cost wizard appears on the screen. Choose Direct Entities to allocate to products, brands, suppliers or channels. Document Lines spreads the cost across the lines of an order instead. When you've made your choice, click Next for the following step of the wizard process. Pick a tab, such as Channel, then tick every target this cost belongs to. When your targets are ticked, click Next to choose how the amount is split. Enter how much to allocate, or keep the full amount. Equal Split divides it evenly, and Manual Amounts lets you type each share. When the split looks right, click Next to set the timing. One-time recognizes the cost on a single date. Click Next to review your choices. Check the summary, then click Confirm Allocation. The wizard saves your choices and updates the entry. The allocation joins the table, with its date, strategy and amount. Filters narrow the list, including Order Reach. To allocate to many targets at once, click Import. Choose your file, then click Next to map the columns. Check that each column maps to the right field. Then click Next to validate every row in the file. The preview lists every row with a problem, such as an unknown SKU. Those rows are skipped, and the valid rows import together. Click Import to create the allocations, wait for the success message, then click Close. An import always adds new allocations, and never updates existing rows. Click Export to download the table with your visible columns. Choose which records you want and the file format, or click Cancel to stop. To remove allocations, tick the rows you no longer want, and click the Remove button. Confirm in the dialog, and that amount becomes Unallocated again.

Last verified: