About
Applies to: InventoryIQ
In InventoryIQ, Finaloop's inventory management product, the Inventory vendors page shows what you owe each inventory supplier, even before their bill arrives, and every inventory bill and payment behind that number.
InventoryIQ tracks every unit you buy and sell and its cost, first in, first out (FIFO). Because it knows what you ordered from each vendor, it can work out what you owe them from your purchase orders (POs), shipments, transfers and assemblies, minus what you've paid. You find it in the sidebar under Inventory → Inventory vendors, with two tabs: Bills & payments and Vendor balances.
Use this guide to read your vendor balances, link payments to the POs they paid for, add adjustments for payments made before your InventoryIQ start date, and choose how each inventory bill or payment is treated in your books.
1. How your vendor balance is calculated
Each vendor's balance has up to three parts:
Rolling balance: what you owe the vendor for inventory costs where no bill has been received yet. It builds up from your POs, shipment costs, stock transfers and assembly costs, and goes down with inventory payments.
Unpaid bills: unpaid bills from the vendor that were categorized as inventory.
Total balance: Rolling balance plus Unpaid bills.
When a vendor's bill arrives, the billed amount moves out of the rolling balance and into Unpaid bills, so the total you owe stays the same until you pay. Unpaid bills and Total balance appear once you have inventory bills in Finaloop.
On a single vendor's page, the cards at the top show the rolling balance calculation:
Purchase orders + Shipment costs + Stock transfers + Assembly costs - Bills - Payments + Dropshipping balance = Rolling balance
Finaloop shows only the cards that apply to that vendor:
Purchase orders: POs whose production started in the period you're viewing, including costs where the vendor was added to a PO's indirect costs. If your POs reach your books on their shipment date (set under Recognition date in Inventory → Supply chain → Preferences), it counts POs that shipped in the period instead.
Shipment costs: costs added to shipments for this vendor, such as freight or duties.
Stock transfers: costs for this vendor added to a stock transfer, where shipping started in the period.
Assembly costs: dollar amounts added directly to product recipes or assemblies, grouped by month. Click View details on a row to see where each cost came from.
Bills: bills from this vendor that were categorized as inventory-related.
Payments: bank and card transactions for this vendor categorized as inventory-related, excluding bill payments. It includes opening balance adjustments.
Dropshipping balance: dropshipping costs from POs, dropshipping payments and bills, and dropshipping adjustments, if you dropship.
For example, you start production on a $10,000 PO with a vendor and pay them $6,000 by wire, categorized as Finished products. Their rolling balance is $10,000 - $6,000 = $4,000.
A negative rolling balance usually means a PO is missing or was entered with costs that are too low, or a payment doesn't belong to a PO. To find and fix it, see Fixing Negative Vendor Balances.
2. Review your vendor balances
Optional: change the Balances as of date to see what you owed on an earlier date.
Optional: type in Search vendors, or click Filters to set a Rolling balance range or turn on Show non-zero rolling balances only.
① Balances as of, ② the balance cards, ③ the negative balance switch.
Review the list. Each vendor shows its Rolling balance, and its Unpaid bills and Total balance when you have inventory bills. Click a column name to sort by it.
The cards at the top add up the balances of all your inventory vendors. By default, vendors with a negative rolling balance are listed first. When there are any, you'll see a line such as 3 inventory vendors have negative balance with a switch next to it. Turn it on to list only those vendors.
3. Open a vendor's balance
Click a vendor on the Vendor balances tab to open their page. Use the period and Search at the top to narrow what you see.
The vendor's page has two tabs once you have inventory bills in Finaloop, and only the rolling balance view before that:
Rolling balance: the balance cards, then every item that changed the rolling balance, with its Date, Item, Amount, the running Rolling balance, and any payment link in Link (optional) and Link allocation. Click an item's name to open it.
Bills: the vendor's inventory bills, with Bill#, Accounting treatment, Paid amount, Amount and Balance, including bills synced from Bill.com or Settle and bills you created in Finaloop. For more on bills, see Managing your bills (payables).
① The Rolling balance and Bills tabs, ② the balance cards, ③ Add adjustment.
If something you expect isn't on the list, click Missing an entry? → under the buttons. The two most common reasons are:
Missing PO: a PO counts toward the vendor balance only once it has a Production started date (or a shipment, if your POs reach your books on their shipment date).
Missing payment or bill: a payment or bill whose accounting treatment is COGS goes straight to your P&L and doesn't affect the rolling balance. You can change the treatment on the Bills & payments tab.
4. Link payments to purchase orders
Linking connects a payment or bill to the POs, shipments, stock transfers or assemblies it paid for. Each PO then shows whether it's Paid, Partially paid or Unpaid, and you can see exactly which items make up the vendor's balance.
Open the vendor from Inventory → Inventory vendors → Vendor balances.
On the Rolling balance tab, check the box next to each item you want to link, for example a PO and the payment that paid for it.
Click Link items. A link page opens with the items you selected, split into bills and payments on one side and POs, stock transfers, assemblies and shipments on the other.
Optional: click Add bills/payments or Add purchase orders/stock transfers/assemblies/shipments to add more items, select them in Select items to link, and click Save.
Check the Amount to allocate for each item. Amount after allocation shows what's left unlinked.
Click Save in the Save changes? bar.
You'll see Linked successfully, and back on the vendor's page each linked item shows its link number, such as Link #12, in the Link (optional) column.
You can also start from a PO or a shipment: in its PO payable summary or Shipment payable summary, click the vendor to open their balance and link from there. See Managing your POs in Finaloop and Managing your Shipments & Receipts.
To remove a link, click its link number to open it, click Unlink, then confirm in Unlink group.
Note: Linking doesn't change how much you owe. The rolling balance already counts every inventory payment; linking shows which items each payment covered.
5. Add an adjustment to a vendor balance
Adjustments cover amounts Finaloop can't see in your POs, bank or bills, usually from before your InventoryIQ start date. On a vendor's Rolling balance tab, click Add adjustment and choose one of four types:
Adjustment | Use it for | What you enter |
Opening balance adjustment | Goods already received in your warehouses before your InventoryIQ start date that you hadn't paid for by then. If part of an order hadn't arrived yet, add the PO and shipment instead. | Amount |
Historical payment | Payments made before your InventoryIQ start date for POs received after it. | Amount |
Vendor credit | A credit the vendor issued, which you can later link to a PO as a payment. | Related PO (optional), Credit date, Amount |
Dropshipping balance | Aligning a dropshipping vendor's balance with what you actually owe them. Shown only for dropshipping vendors. | Balance date, Amount |
Each vendor can have one opening balance adjustment. You can add an opening balance adjustment or a historical payment only while the books for your InventoryIQ start date are open. For dropshipping, keep adjustments small and contact us for a large gap; see Managing Dropshipping (InventoryIQ).
Add a historical payment
If you added a historical PO (one whose production started before your InventoryIQ start date) and paid some or all of it before that date, add the payment so the vendor's balance is right. It won't double count anything.
Go to Inventory → Inventory vendors → Vendor balances and click the vendor.
Click Add adjustment → Historical payment. The Add adjustment panel opens.
Enter the Amount.
Click Save.
The historical payment now shows on the vendor's Rolling balance tab, and their balance goes down by that amount. To remove an adjustment, click the delete icon on its row.
6. Review your inventory bills and payments
The Bills & payments tab lists every bill and bank or card payment categorized to an inventory category, such as Finished products, Packaging materials, Production costs, Shipping & freight-in or Supplies & materials. The cards at the top total them by category. Each row shows its Date, Vendor, Amount, Category and Accounting treatment, and you can pick a period and search the list.
Every inventory bill or payment has one of two accounting treatments:
Inventory A/P (the default): the payment reduces the vendor's rolling balance tied to your POs, with no immediate effect on cost of goods sold (COGS), what the products you sold cost you.
COGS: the amount goes straight to Product COGS on your P&L, with no effect on inventory or the vendor's balance. Use it for small costs that don't belong to any unit, such as packing paper (incidentals).
To change the treatment of selected bills and payments (Actions → Change accounting treatment), or to set a default with a rule in Purchases settings, see How to expense small supplies like bubble wrap directly to COGS (incidentals).
Export your inventory bills and payments
On the Bills & payments tab, check the rows you want, then click Actions → Export. Finaloop downloads them as a CSV file.
Related articles
Need help?
If a vendor's balance doesn't match what they say you owe, reach out to our Support team through chat or at [email protected], and include the vendor name, the date and the balance you expect.


