Skip to content
← Share and support customer ideas for Xero

Purchase orders, bills & inventory

Customer ideas for purchase orders, bills, inventory(products and services) and making supplier payments.

Learn about the forums, how to contribute and create a good idea on Xero Central

Purchase orders, bills & inventory

Categories

Enter your idea

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

1 result found

  1. Inventory report with GP margins

    Inventory activity summary with columns for
    Purchases
    Adjustments
    Sales
    On Hand
    Unit Cost
    Sales (currency value)
    COS (currency value)
    GP
    GP%
    Unit sales price

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Inventory  ·  Admin →
    Existing functionality  ·  AdminDavina Roper (Admin, Xero) responded

    Hey Elna, there is existing functionality in Xero that lets you see gross profit and margin for your inventory items using the Inventory Item Details report. To turn this on in the report, follow these steps:

    1. Go to Accounting > Reports > All reports.
    2. Open the Inventory Item Details report.
    3. Choose the date range you want, then click Update to run the report.
    4. Click Columns, then select:
    • Margin – shows the difference between the cost price and sale price as a percentage (your GP%).
    • Profit per item – shows the difference between the cost price and sale price in dollars (your GP per unit).
    1. Click Update again to refresh the report with those columns showing.

    You can also use the Group/Summarise options to group by item if you want to see totals by product, and use Filters to narrow it down to particular items or date ranges.

    😊

  • Don't see your idea?