Skip to main content

Reporting inventory restocks

Report returned units that went back into your stock under sales-based cost of goods sold (COGS), so Finaloop adds them back to inventory and lowers COGS for the right sales channel.

Written by Emily Burrows

About

Applies to: Finaloop Accounting

When a returned product goes back into your stock, Finaloop adds it back to your inventory value and lowers your cost of goods sold (COGS, what the products you sold cost you) once the restock is reported. The steps here are for sales-based COGS, where Finaloop records COGS when an order sells, using the cost per unit you enter (shown in your inventory settings as Sales based).

We sync your sales, fees, and units sold from many sales channels automatically, but information about items restocked is more limited for certain sales channels, including Amazon and TikTok Shop.

If you restock products, whether for Amazon FBM (Fulfilled by Merchant), TikTok Shop FBM or TikTok Shop FBT (Fulfilled by TikTok), we'll need information from you about these restocks.

Note: We sync the restock data for Shopify automatically, so it's important to keep your restock data in Shopify up to date.

To make this as simple as possible, you can report restocks at the total channel level or at the SKU level, either manually or via bulk upload. Use the option that best fits how you track your inventory today.


1. Refunds vs. restocks: What is the difference?

A refund and a restock are two separate events that affect your books differently.

  • A refund is when you return sales funds to a customer. It reduces your net sales, but a refund alone won't have an impact on your COGS or inventory.

  • A restock means the physical unit has returned to your warehouse. When a product is marked as restocked, Finaloop increases your inventory value and reduces the COGS for that SKU.

A refund can occur without a restock, and a restock can occur without a refund. For accurate financials, both must be reported correctly based on what happened in the real world. Refunds are synced automatically by Finaloop, but you'll need to report restocks for Amazon FBM, TikTok Shop FBM and TikTok Shop FBT in Finaloop.


2. How to report restocks in Finaloop

You can report restocks using one of three methods: a total restock value per channel, units restocked on each product, or a bulk edit for many products at once.

Option 1: Report total restock value per channel

This option is ideal if you track total restock amounts outside Finaloop and do not need to break them down by SKU.

  1. In Inventory → COGS, click Report per channel. The New report pane opens.

  2. Type: Select COGS from the dropdown menu.

  3. Period: Select Day, Month or Range, then enter the relevant dates.

  4. Amount: Since a restock reduces your COGS, add the total restock amount as a negative value.

  5. Sales channel: Select the relevant sales channel from the dropdown, like TikTok Shop.

    Screenshot of the New report pane with COGS as the type, a negative amount and TikTok Shop as the sales channel.

    ① Type, ② Amount, ③ Sales channel.
    ​

  6. Click Save.

You'll see Saved successfully! at the bottom of the pane. Entering a negative amount increases your inventory value and reverses previous COGS for those units. For a Month or Range period, the amount is spread daily across the period. If the entry's dates are outside the period you're viewing, filter the COGS page to the entry's dates to see it.


Option 2: Add SKU-level restocks for each product

If you want to track the number of units restocked for each SKU, you can add restock quantities directly in the product.

  1. In Inventory → Products, click the specific product that had restocked items.

  2. Open the COGS tab.

  3. Find the box for the relevant sales channel, like TikTok Shop, and click the pencil icon.

    • If you don't see the relevant sales channel, click Add to COGS, select Sales channel, and then select the relevant channel from the dropdown.

  4. In the pane that opens, add the units restocked in the Units restocked column for each month.

    Screenshot of the TikTok Shop units pane on a product's COGS tab, with monthly Units fulfilled and Units restocked fields.

  5. Click Close, then click Save in the Save changes? bar.

This method adjusts COGS and inventory for each specific SKU. The restocked units show in the sales channel's box on the product's COGS tab, and the product's Net units depleted on the Products page goes down by the same number.


Option 3: Bulk edit restocks for multiple SKUs

This option is recommended if you have many SKUs with restocks or prefer to bulk upload data from a spreadsheet.

  1. In Inventory → Products, click Actions, then Bulk unit edit. The page opens on the COGS tab.

  2. Select a Sales channel from the dropdown.

  3. Under Update method, select the method for calculating the adjustment:

    • Replace: Replaces the existing records for the selected product in the chosen month.

    • Add on top: Adds the value to the total of existing records in the system.

    • If you are only adding restock information, select Add on top.

  4. Update Units restocked by SKU, or click Actions and then Import CSV file and follow the instructions to upload a CSV file with the relevant data for each sales channel.

    Screenshot of Bulk unit edit on the COGS tab with the Sales channel picker, the Update method options and the Units restocked column.

    ① Sales channel, ② Update method, ③ Units restocked.
    ​

  5. Click Save in the Save changes? bar, then click Confirm.

Finaloop shows Successfully updated with the number of records it updated. Before you upload a CSV file, select a sales channel on the page and save or discard any pending changes.

For additional information, see the Sales-based COGS walkthrough (interactive demo).


Related articles


Need help?

If you are unsure where to find your restock information or which restock method to use in Finaloop, reach out to our team through chat or at [email protected].

Did this answer your question?