About
Applies to: InventoryIQ
InventoryIQ, Finaloop's inventory management product, automatically tracks your vendor balances based on your POs, payments from your banks or credit cards, and from any bills added to Finaloop.
Sometimes, you may see a vendor balance with a negative balance (shown in red) on your Vendor balances page, which means a PO, payment or historical payment may be missing and we need some input from you. Follow the steps in Managing your vendors with negative balances to easily identify and fix any missing data.
1. Managing your vendors with negative balances
If you see a mission (a task in My missions where we ask you for information we need) or an IQ Health Center task asking you to review vendors with negative balances, here's how to track and fix negative vendor balances.
Step 1: Review purchase orders and transfers
Go to Inventory → Inventory vendors → Vendor balances to check any negative balances.
Turn on the inventory vendors have negative balance switch (it shows the number of vendors, for example "4 inventory vendors have negative balance"). This filters the vendors to show only those with negative rolling balances.
Click a vendor to view the details of their balance changes ①.
Double-check that all POs and transfers for this vendor are added and accurate. A PO only counts toward the vendor balance once it has a Production started date (or a shipment date, if your company recognizes POs on shipment), so add the date if it's missing.
If you see something else missing, click +Add adjustment ②.
For the most common reasons an entry doesn't appear, click ③ Missing an entry? → on the vendor page.
Tip: If the issue relates to indirect costs and a PO or transfer is missing under the vendor, make sure the vendor name is correctly added under indirect costs. For example, click the Edit icon next to "Duties and tax" on the PO to assign it to the correct vendor.
Step 2: Review payments
When reviewing negative vendors, review the payments and ensure all payments you see relate to POs or transfers created.
If a payment doesn't relate to a PO or transfer (for example, a small expense like packing paper or another incidental expense), you can treat it directly as COGS (cost of goods sold) on your P&L instead of adding it to your inventory balances. To categorize it directly as COGS:
Click the payment link to go to the Bills & payments page.
Select the payment and go to Actions → Change accounting treatment.
Choose COGS from the dropdown and click Save.
Payments categorized as Finished products or Supplies & materials stay in inventory rather than COGS.
Note: Recording inventory as COGS assigns it directly to your P&L (as Product COGS, under the COGS section).
Important: With some exceptions, under US tax laws, inventory-related costs should be categorized as inventory and expensed only when sold. We recommend that you consult with your tax advisor, CPA, or accountant to make sure you're compliant with the relevant laws.
Step 3: Add historical POs and historical payments
When setting up InventoryIQ, make sure to add any POs or transfers from before you started using InventoryIQ if the items were received after your start date. Also, add any payments tied to these historical POs.
To add a historical payment
Go to Inventory → Inventory vendors → Vendor balances and click the vendor.
Click Add adjustment → Historical payment.
Enter the Amount.
Click Save.
Need help?
If none of these steps fix the issue, feel free to contact our support team at [email protected] for more help. We'll dive deeper and sort it out!



