Skip to main content

Updating inventory based on physical counts

Record a physical inventory count in Finaloop so your inventory value matches what's actually on your shelves, with the difference adjusted in your cost of goods sold (COGS).

Written by Emily Burrows

About

Applies to: Finaloop Accounting, InventoryIQ

A physical count in Finaloop Accounting, Finaloop's real-time bookkeeping and accounting service, updates your inventory value on a date to match what you actually counted, and Finaloop records the difference as an adjustment to your cost of goods sold (COGS), what the products you sold cost you.

Sometimes, physical stock counts reveal differences between actual inventory and recorded values. If your inventory balance recorded in Finaloop doesn't align with your physical inventory count, don't worry! The Physical counts page, under Inventory in the sidebar, helps you reconcile your recorded inventory with your physical stock count. You record counts there on a computer.

Whether you track your inventory using our sales-based COGS method, where Finaloop records COGS when an order sells using the cost per unit you enter, or using InventoryIQ, Finaloop's inventory management product, physical counts keep your inventory value accurate for bookkeeping and tax purposes. Here are step-by-step instructions for both inventory methods.


1. Physical counts with sales-based COGS

If the value of your inventory on hand based on a physical count is different from your inventory balance in Finaloop, a physical count helps you resolve this quickly and accurately by adjusting your inventory in Finaloop to align with your actual count.

Steps to adjust inventory

  1. In Inventory → Physical counts, click New count. The Create new count panel opens.

  2. Select the Count date. This can be any date the physical inventory was taken, and it's the date we record the adjustment in your books. You can have one count per date.

  3. Review the Closing balance amount, which is the inventory value recorded in Finaloop on that date before this adjustment. Enter the updated inventory value based on your count in Updated amount. Adjustment shows the difference.

    Create new count panel with the Count date, the Updated amount field and the Calculate based on units and costs link outlined.

    ① Count date, ② Updated amount, ③ Calculate based on units and costs.

  4. Add a Note or click Upload attachment (up to 2 files) to keep records organized.

  5. Click Save, then click Got it on the note that says it may take a few minutes for the update to show in your COGS and inventory numbers.

You'll see Physical count saved, and the count appears on the list. We adjust your inventory value to reflect the updated value, and the adjustment has a corresponding impact on your COGS, so everything is reconciled accurately.


Calculating your inventory value from unit counts

If you know your unit counts but aren't sure about your total inventory value, use our built-in calculator to calculate the value of your inventory.

  1. In the Create new count panel, select the Count date, then click Calculate based on units and costs. You'll see all your synced products from Shopify and Amazon and any products you added to Finaloop.

  2. Enter the updated unit count for each product in the Updated quantities as of column. The calculator multiplies each product's quantity by its Cost per unit (as recorded in Finaloop), shows the result in Total closing balance, and adds them up in Updated closing balance at the top.

  3. If you have additional products that you don't see, click Filters and select Inactive under Attributes. To find products you haven't counted yet, open the All items dropdown and select Product with no input.

  4. To upload counts in bulk, click Actions and select Import CSV, then follow the steps provided: download the empty template or a CSV file with all your products, fill in the adjusted quantity for each SKU (products are matched by SKU), and upload the file to review and save it.

  5. Click Save in the Save changes? bar.

Physical count calculator with the All items dropdown, the Updated quantities as of column and the Actions button outlined.

① All items dropdown, ② Updated quantities as of, ③ Actions.

Important: To get an accurate total, include all products that were in your warehouse during the count. Active products you leave blank are counted as a $0 closing balance, which results in a partial inventory value. If any are blank when you save, a Please note! window asks you to confirm.

Your count is saved with the calculated value and appears on the list.


When the adjustment changes after you save

After saving, the updated inventory value is "frozen" as of the selected date, keeping that period accurate.

Example: If your original inventory value was $5,000 and you adjusted it to $4,000, the new value of $4,000 will be recorded (a negative adjustment of $1,000). If you later make changes to historical data affecting inventory (for example, categorizing open expenses to inventory categories), the $1,000 adjustment will be modified so the inventory value on that date remains $4,000.

If this occurs, a red dot appears next to the count on the Physical count list, so you can review the change:

  1. Click the count with the red dot. The Confirming physical count adjustment panel opens.

  2. Review the Physical count adjustment update message, which shows the new adjustment and how the inventory value before the adjustment changed.

  3. Click Confirm.

You'll see Changes confirmed, and the red dot disappears.

Physical count list with a red dot next to a count whose adjustment changed, beside its Original amount, Adjustment and Updated amount.


2. Physical counts with InventoryIQ

If your inventory on hand based on a physical count is different from your inventory balance in Finaloop, a physical count helps you resolve this quickly and accurately by adjusting your inventory in Finaloop to align with your actual count. With InventoryIQ, you count units per warehouse, and Finaloop values the difference using your first in, first out (FIFO) costs.

Steps to adjust inventory

  1. In Inventory → Physical counts, click New count. If a warehouse system is connected, select Create new count (or Sync count from warehouse to pull the latest numbers from it).

  2. In the Add count window, select the Warehouse and the Date of the physical count, then click Add count. Counts are done per warehouse, with one count per warehouse and date.

  3. If any SKUs have units without costs on the selected date and in the selected warehouse, you'll see Products with missing costs. Click Go to products and resolve these first, then add the count. Why do I have units with missing costs in InventoryIQ? explains how.

  4. Review the list of all products with activity in the selected warehouse as of the chosen date. If any products appear to be missing, click Filters to include inactive products as well.

  5. For each product, compare the current unit count in Finaloop with your physical count: - If they aren't the same, enter your count in Updated units. This will impact the inventory closing balance of that product on the date you entered, and you'll see the Difference and Adjustment. - If they're the same, you can mark the product as accurate by checking the box in the Accurate number column, or leave it as is. Any unedited products are assumed to have correct counts.

  6. To bulk update the quantities, click Actions and select Import CSV.

  7. Add a Note and attach relevant files with Upload attachment.

  8. Click Save in the Save changes? bar.

Finaloop updates the inventory value and reconciles it with your physical count. The Avg. cost per unit column is a guide: the final adjustment uses the exact costs from your FIFO layers.


When the adjustment changes after you save

Once saved, the updated inventory value for that SKU is "frozen" as of the selected date. This keeps it accurate even if historical data changes your inventory: any updates to past transactions automatically adjust the inventory value to maintain consistency.

When that happens, a red dot appears next to the count on the Physical count list. Open the count to see the Total adjustment update message and the affected products, then click Confirm in the I confirm the changes that have been made bar.


3. Viewing and managing physical counts

You can track your physical count changes on the Physical count page. Use Period to choose the dates you see. Here you'll see:

  • Date: The date of the physical count.

  • Original amount: The inventory value recorded before the adjustment.

  • Adjustment: The difference added to your books based on the count.

  • Updated amount: The new total after the adjustment.

With InventoryIQ, use Show by to list counts by Count date or by Warehouse. Click Export to download the list, and use the menu at the end of a row to delete a count (or, with InventoryIQ, duplicate it).

You can update physical counts at any time, as long as the books for the relevant year haven't been closed. If a count falls in a closed year, contact support and we'll help.


4. Key takeaways

  • Physical counts keep your inventory and COGS in line with what's actually on your shelves.

  • With our sales-based COGS method, you can use the built-in calculator to work out your inventory value from product counts and costs.

  • Stay organized by adding notes and attachments for each count.

  • Finaloop keeps your counted value in place when past data changes, and flags any change to the adjustment for you to confirm.


Related articles


Need help?

As always, if you have any questions, just contact us at [email protected] for some support.

Did this answer your question?