Conditional matching

[Excel God]

Hello forum members,

I have this Inventory worksheet that i'm using to track inventory movements.
Currently there are two tables: Stock in and stock out.

What i want to do is:
1) On the status column of the stock out table, when the Total units of inventory i stocked in for each individual item has been fully stocked out (i.e., Total balance hits 0), the Status changes to "COMPLETED".

2) When some of the items have been partially stocked out (i.e., Total balance > 0 < Total stock in qty) the status changes to "Pending"

3) When the Total Balance = Total Stock in quantity, the status will be "Pending"