Skip to main content

Confirming year-end inventory balance (sales-based COGS)

Confirm your year-end inventory balance with sales-based cost of goods sold (COGS), and close any gap with your physical count before we close your books.

Written by Ryan

About

Applies to: Finaloop Accounting

At the end of each year, Finaloop asks you to confirm your inventory balance. This helps us (and you) double check its accuracy and make sure we're all aligned before closing your books.

This article is for sales-based cost of goods sold (COGS), where Finaloop records what your products cost you when an order sells, using the cost per unit you enter. Ideally, the inventory balance in your books at year-end matches the value of your physical inventory count, or your best estimate if a physical count and valuation isn't practical.

Aligning your inventory balance with your physical inventory matters for three reasons:

  • Tax compliance: your year-end inventory balance is the basis for your tax return. Its accuracy directly affects your financial statements and your taxable income.

  • Catching discrepancies: confirming the balance checks that your books match the stock you actually have, so the inventory impact on your Profit & Loss (P&L), mostly COGS, is right.

  • Consistent records: your closing balance becomes next year's opening balance, so confirming it keeps your books consistent year over year.

Using InventoryIQ, Finaloop's inventory management product, or purchase-based COGS? Your inventory checklist has different tasks. See Completing your year-end checklist in the Year-end Hub.


1. Open your inventory year-end checklist

  1. In the Year-end Hub, find Inventory and click Go to Inventory. You can also click Let's go on the year-end banner on Inventory → Inventory overview.

  2. Work through the tasks in order:


2. Confirm your closing balance

Confirm your closing balance shows your inventory balance on the last day of the year: This is your closing balance as of [date]. Complete it only after all the other tasks, because they can change this number.

  1. Choose how to confirm the balance:

    • If you did a physical count, click Align your balance. It opens Physical counts, where you enter the value you counted and Finaloop adjusts your inventory and COGS to match it. See Updating inventory based on physical counts.

    • If you didn't, and the balance looks right, there's nothing to enter.

  2. Click Mark as completed.

  3. When every task is complete, click Submit on the checklist.

The task shows as completed, and our team reviews your inventory as part of closing your year. If a later change affects your balance, the task reopens with This task was opened automatically due to changes made. Review the new balance and complete it again.


3. Close a gap between your books and your count

If your Finaloop balance and your physical count don't match, find the cause first. Here's how to close the gap, from the most precise fix to the quickest:

  1. Purchases: in Inventory → Inventory purchases, check that every inventory purchase is categorized correctly and shows up. Add or remove inventory bills and transactions as needed.

  2. Cost per unit: adjust your landed cost per unit on a product's Cost per unit tab in Inventory → Products. A higher cost per unit means higher COGS and a lower inventory value.

  3. Missing sales channels, dead inventory or product giveaways: on a product's COGS tab, click Add to COGS and choose Sales channel, Dead inventory, Product giveaways or Product donations, and we'll calculate the dollar value from the cost per unit. To add a dollar amount for a whole channel instead, click Report per channel on Inventory → COGS.

  4. Sold or fulfilled quantities: on a product's COGS tab, click the edit icon on the card you want to change, or use Actions → Bulk unit edit on the Products page for many products at once.

  5. Physical count: record your count on Inventory → Physical counts and Finaloop adjusts your inventory value on that date to match it.

If you'd rather make one general adjustment, on Inventory → COGS click Report per channel, choose COGS as the Type, Range from January 1 to December 31 as the Period, and Multi-channel as the Sales channel. Enter a positive amount to decrease your inventory value, or a negative amount to increase it. For example, if your Finaloop balance on December 31 is $1,000 and your count is $900, enter $100.

Important: Every adjustment in this section changes your COGS on the P&L, and with it your gross and net profit for the year.


FAQs

Why is this necessary? Isn't Finaloop always supposed to be accurate?

Finaloop calculates your inventory value from your purchases and your COGS, which comes from the units sold and your landed cost per unit. When every input is right, the balance is right. Gaps appear when an input is off, for example:

  • Purchase amounts are wrong: bank or card transactions were miscategorized as inventory, counted twice alongside their bills, or some inventory bills were never added to Finaloop.

  • COGS is off because the cost per unit didn't fully reflect landed costs. See How to calculate your landed cost per unit.

  • COGS is off because the number of units sold or fulfilled isn't fully accurate.

  • COGS or inventory is off because of missing sales channels, dead inventory or product giveaways.


I don't have a physical count or valuation. How do I estimate my inventory value?

Many brands ask their third-party logistics (3PL) provider or warehouse for the count of units stored on December 31. If you sell on Amazon or another marketplace that fulfills for you, its reports show the units stored in its warehouses.

Once you have the quantity of each product on December 31, estimate its cost per unit if you don't already have it. You can use the average cost per unit, or a more specific breakdown by cost layer, working out the cost per unit for each layer from the purchase orders behind it.

Then multiply each product's quantity by its estimated landed cost per unit, including all allocated costs, and add them up. That total is your estimated inventory value.


What about my Inventory in-process and Inventory in-transit balances?

You change them on Inventory → Inventory purchases by setting the Shipped on and Received on dates of each purchase. See Tracking inventory purchases with sales-based COGS.


Related articles


Need help?

If your inventory balance, purchases or COGS still feels off, or you think you need a larger adjustment, reach out to our Support team through chat or at [email protected].

Did this answer your question?