About
Applies to: Finaloop Accounting, Margins
Your cost per unit is the number Finaloop multiplies by the units you sell to work out your cost of goods sold (COGS), what the products you sold cost you. Shopify can sync it automatically; for every other sales channel, it's the one number only you can supply.
This applies when you use sales-based COGS in Finaloop Accounting, where COGS is recorded when an order sells using the cost per unit you enter. It also applies in Margins, Finaloop's margin analytics app, which calculates your margins the same way. In Finaloop Accounting, your costs set the COGS in your books; in Margins they set your product margins and SKU analysis.
There are four ways to add costs: sync from Shopify, add a cost to one product, edit many at once, or import a CSV file. Every cost carries a start date and applies from that date until the next cost begins, so a cost change adds to your history instead of rewriting it.
A product with no cost per unit adds $0 of COGS when it sells, so its margin shows as 100%. The Products page tells you how many are missing: [n] products are missing cost per unit for COGS calculation. Turn on the toggle next to it to see only those products.
In Margins: The steps are the same. Start from Products in the sidebar instead of Inventory → Products.
Before you begin
Decide what goes into your cost. Most brands use an average landed cost: the full cost of getting a product to your warehouse, including the product price, freight, duties and inbound fees. See How to calculate your landed cost per unit (in Margins, Calculating your average cost per unit in Margins).
Merge your duplicates first. Only the primary product's cost is used, so a cost entered on a duplicate has no effect. See Merging multiple products.
Know the date each cost should start from. Finaloop recalculates COGS from that date forward.
In Finaloop Accounting, make sure each sales channel is turned on under Inventory settings → General → Sales channels – report per SKU. Inventory settings is at the top right of any Inventory page.
1. Sync your costs from Shopify
If you keep Cost per item up to date in Shopify, Finaloop picks it up with no work on your end. In Finaloop Accounting, turn on Sync cost per unit for Shopify under Inventory settings → General.
Shopify is the only sales channel that shares cost data, so a synced cost belongs to the Shopify product only. Your Amazon, TikTok Shop, Walmart or wholesale sales arrive as separate products with no cost until you add one or merge them with the Shopify product.
In Shopify, set Cost per item on the product or variant.
In Inventory → Products, merge the other channels' copies into the Shopify product, with the Shopify product as primary. See Merging multiple products.
That one Shopify cost then covers every channel selling the SKU. On a product's Cost per unit tab, a synced cost shows the Shopify logo.
Finaloop only reads from Shopify and never writes back to it, to protect your store data. To change a synced cost, update it in your Shopify admin and the new cost flows through. On Bulk costs editing, products on synced costs are left out of the list, and a message tells you how many with cost-per-unit synced from Shopify can be edited directly through your Shopify Admin.
In Finaloop Accounting, keep Sync cost per unit on once you rely on it: turning it off deletes the costs already synced from Shopify, except costs in closed books.
2. Add a cost to one product
Use this for a single SKU that needs a new or updated cost.
Go to Inventory → Products.
Click the product.
Click the Cost per unit tab.
Click Add cost.
① Add cost, ② Current cost, ③ the Edit pencil.
In Add a cost, enter the amount in Cost per unit. If the product already has a cost, also choose the From date the new cost starts.
Click Save in the Add a cost panel.
Click Save in the Save changes? bar at the bottom of the page. Discard throws away the changes you haven't saved.
[IMAGE: replace this line with 18454039_02.png. Alt text: Add a cost panel with the From and Cost per unit fields, and the Save changes? bar with Save and Discard.]
① From, ② Cost per unit, ③ Save changes? bar.
The new cost appears on the timeline and Current cost updates. Until you save the page, the new entry shows To be updated under Net units depleted.
A product's first cost has no From date to pick: it applies from the date your books start in Finaloop, or from the first day of your earliest open year if earlier years are closed.
To change or remove an existing cost, hover over it on the timeline and click the Edit (pencil) or Delete (bin) icon. Edit a cost opens with the same fields, and the edited cost replaces the old one from its date. You can't delete a product's only cost. Then click Save in the Save changes? bar.
You're adding a cost, not replacing one. Earlier entries stay on the timeline and keep applying to the units that sold while they were in effect.
3. Edit costs for many products at once
Go to Inventory → Products.
Click Actions and select Bulk costs edit. The Bulk costs editing page opens.
Optional: turn on the missing-cost toggle to show only products without a cost.
Type a cost into the Average cost field on any row.
To give several products the same cost, tick their checkboxes and enter the amount in Set cost for [n] selected products: at the top right.
Read the note beside each row you changed. It names the date the cost applies from and says whether it replaces an existing cost: This cost will be applied as of [date] or Replacing the previous cost ([amount]), will be applied as of [date].
[IMAGE: replace this line with 18454039_03.png. Alt text: Bulk costs editing page with a cost typed in, the note beside the row and the save bar.]
① Set cost for [n] selected products:, ② the note beside the row, ③ Save and Discard.
Click Save in the bar at the bottom of the page. Discard throws away all the costs you've typed and haven't saved.
The bar counts your saved products as it goes, and Cancel stops a save in progress. When it reads Completed!, each product's Average cost recalculates for the period you're viewing.
Important: A bulk edit doesn't always add a new dated cost. On a product with no cost yet, it applies from the start of the period you have selected. On a product that already has a cost, it replaces that cost and takes over its date. Read the note beside each row before you save.
Click Export costs before you start to download the latest cost per unit for each product, as of the To date on the page, and check it against your own records.
4. Import costs from a CSV file
Importing works best when you're setting up for the first time, or after a vendor price change across many SKUs.
Go to Inventory → Products.
Click Actions and select Bulk costs edit, then click Import CSV.
Click Download the CSV template.
Fill in a cost and a date for each SKU. The file is matched on SKU, so the SKUs in your file need to match the SKUs on the Products page.
Click Click here to choose a file and select your file.
Review the uploaded rows. Use All, Valid products and Invalid products to filter them, and fix any invalid rows.
Click Save.
Once saved, your costs appear on each product's Cost per unit timeline, and COGS recalculates from each cost's date forward. The date column works like this:
The date is when the cost starts to apply, and it keeps applying from there. A cost dated 01-01-2023 applies from January 1, 2023 until the next cost begins.
If there are cost entries dated after the date in your file for SKUs in your upload, the uploaded cost overwrites them.
In Finaloop Accounting, if you've set up dropshipping, you also choose whether the file holds Inventory or Dropshipping costs. See Managing Dropshipping (Sales-Based COGS).
To build the file quickly, go to Products, turn on the missing-cost toggle, click Actions and select Export file. You get exactly the SKUs that still need a cost.
Important: Saved imports can't be reverted. To fix a bad import, upload a corrected file or edit the costs directly on each product.
FAQs
I set costs in Shopify. Why do my Amazon sales still show no cost?
The synced cost belongs to your Shopify product, and Amazon arrives as a separate product. Merge them with the Shopify product as primary. See Merging multiple products.
If I edit a Shopify cost in Finaloop, will it sync back to Shopify?
No. Finaloop has read-only access to your Shopify store. Change the cost in your Shopify admin and the new cost flows through to Finaloop and Margins.
Can I enter a cost for a date in the past?
Yes, as long as that period's books aren't closed. Finaloop recalculates COGS from that date forward. If a year is closed, you'll see Your [year] books are closed, and you can still add costs for the current year.
I entered a cost but the product still shows the old number. Why?
Check the cost's From date first: a cost dated June 1 doesn't apply to units sold in March, so compare it with the period you're viewing. Then check the merge: only the primary product's cost is used, so open the product, expand Product details and see which product is primary.
What if a product has no cost at all?
Its COGS is $0 and its margin shows as 100%. Add a cost using any of the four methods. In Margins, see Why are my products missing cost per unit in Margins?.
Related articles
Need help?
If you're not sure what to include in your cost per unit, or a cost isn't showing where you expect, reach out to our Support team through chat or at [email protected].

