Inventory/ Managing Unbilled Inventory

4.0. Managing Unbilled Inventory



    

Issuing Receive Order & Supplier’s Invoice With Different Costing

For the same Stock Items and quantities, Unbilled Inventory is a result of the difference in total value purchased, that you have earlier entered; in Receive Order compared to value of the actual Supplier Invoice.

Receiving Stock Items at $1000 each


Alert
STEPS:
  1. Click PURCHASE activity
  2. Click RECEIVE ORDER module
  3. Click NEW
  4. VENDOR select (or create)
    In-Time Supplier Pte Ltd
Details:
  1. ITEM select Dell Desktop
  2. QTY enter 3
  3. UNIT PRICE enter 1000
  4. Lookout for bottom-right, AMOUNT check for 3,270
  5. Click ADD
  6. Close module


Enter the actual Supplier Invoice with Stock Items at $1050 each


Alert
STEPS:
  1. Click PURCHASE activity
  2. Click SUPPLIER INVOICE module
  3. Click NEW
  4. VENDOR select (or create)
    In-Time Supplier Pte Ltd
  5. Click IMPORT
  6. Select RO.12/00000001
  7. Click ADD ALL ROWS
  8. Click BACK



Alert
STEPS:
Details:
Lookout for the middle of the module for
UNIT PRICE change to 1050
Click ADD



Checking For Unbilled Inventory Amount



Alert
STEPS:
  1. Click REPORT activity
  2. Click FINANCIAL
  3. Click TRIAL BALANCE module
  4. Click REFRESH
  5. Unbilled Inventory Account check for $150
During receipt of goods, the items are cost at
$1000 x 3 = $3000.
However, the actual the Supplier Invoiced at $1050
$1050 x 3 = $3150
The is a difference of
$3150 - $3000 = $150.
The system automatically posts it to Unbilled Inventory
Account.


How do you Adjust Unbilled Inventory value


Alert
STEPS:
  1. Click ADJUSTMENT activity
  2. Click CLOSINGS
  3. Click UNBILLED INVENTORY module
  4. POSTING A/C select Stock Adjustment
Select an account you would
like the unbilled inventory
amount to be adjusted to.
  1. Click STEP 1 GENERATE
  2. Click STEP 2 POST
  3. CONFIRM POST UNBILL click YES
  4. POST DONE click OK
  5. Close module


How can you avoid having values posted to Unbilled Inventory

NOTE: Since the Unbilled Inventory value happens when there is a difference between Receive Order and Supplier Invoice, you can amend the value of Receive Order to be the same as Supplier Invoice. Hence, Unbilled Inventory will have zero value.


Alert
STEPS:
  1. Click REPORT activity
  2. Click FINANCIAL
  3. Click TRIAL BALANCE module
  4. Click REFRESH
  5. STOCK ADJUSTMENT check for $150
  6. UNBILLED INVENTORY ACCOUNT
    check for $0
  7. Close module






    • Related Articles

    • 5.0. Receive Order

      How to Create a Receive Order. The Receive Order module does not create accounting entries for non-inventory items. Receive Orders are normally used to take in stock when you have not received the supplier invoice. For inventory items, the Receive ...

    • 3.0. Understanding Stock Item Costing

      How Is Stock Item Costing Calculated? The system uses Weighted Average Cost as the method of calculating Ending Inventory cost. It takes Cost of Goods (Stock Items) available for Sales and divides it by the total quantities of the goods. This gives a ...

    • 4.0. Purchase Order

      Purchase Order A Purchase order is the document that is issued to the supplier. The Purchase Order module does not create accounting entries for all item types, but it does allow imports from QO/PI/IV modules. STEPS: Click on PURCHASES > PURCHASE ...

    • 8.0. Stock Report / Financial Report

      Stock Report STEPS: Click REPORT activity Click INVENTORY Click STOCK module Click REFRESH The report shows the latest stock status of all stock items. Note that you may enter at Filter to search for specific Lot No., Warehouse or Location. Stock ...

    • 7.0. Stock Adjustment

      What Are Types Of Adjustment? STEPS: Click SETUP activity Click ITEM DETAILS Click ADJUSTMENT TYPE module Click NEW TYPE select on the top left side of the module NEW This is meant for you add new item in to the stock list. ADJUSTMENT This is meant ...