Skip to main content

Initial Cost and Revenue on Stock

Use it to capture true starting costs and revenue on stock items, so ROI reports stay accurate—even for items with works orders or unavailable periods.

Updated this week

What This Feature Does

  • Stores initial cost and initial revenue against a stock item

  • Includes values that occurred before the item became available for hire

  • Supports manual entry, bulk import, and export

  • Improves ROI and profitability reporting accuracy

What do you need access to.

  • Ensure you have permission to edit stock items

  • If using import/export, download the latest stock import template

  • Decide whether values will be added manually or via bulk upload

How This Affects ROI Reports

  • ROI calculations now:

    • Start from the true financial baseline

    • Include costs and revenue incurred before hire availability

  • This is especially important for:

    • Items with works orders

    • Items that generated revenue while unavailable

    • Backfilled or migrated stock data

Record Initial Values Manually on a Stock Item

Step 1: Open the Stock Item

  1. Go to Inventory > product > select your product.

  2. Go to the stock level > edit

Step 2: Enter Initial Cost and Revenue

  1. Navigate to the Financials or Details section of the stock item

  2. Locate the fields:

    • Initial Cost

    • Initial Revenue

  3. Enter the relevant values

Step 3: Save the Stock Item

  • Click Save to commit the changes

  • The values are now stored as part of the stock item’s starting financial position

Importing Initial Cost and Revenue in Bulk

Step 1: Export Stock levels

  1. Go to System Setup

  2. Select Export

  3. Choose the Stock Export option

Step 2: Populate Initial Values

  1. Open the exported file

  2. Locate the columns:

    • Initial Cost

    • Initial Revenue

  3. Enter the correct values for each stock item

    • Leave blank if not applicable

Step 3: Import the Updated File

  1. Return to Stock

  2. Select Import

  3. Upload the completed file

  4. Review and confirm the import

Did this answer your question?