> For the complete documentation index, see [llms.txt](https://support.ordereazi.com/central/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.ordereazi.com/central/order-management/reports/supplier-spend-report.md).

# Supplier Spend Report

See what you bought from each supplier for the orders you sold, with the cost, selling price, and profit on each line.

When you negotiate with a supplier, you need to know how much you buy from them for your Sales Orders and what you earn on it. The **Supplier Spend Report** in OrderEazi lists the lines you bought from suppliers for the orders you sold. It shows each line's cost, selling price, and GP (gross profit).

### Before you start

You'll need the **Supplier Spend** permission, in the **Reports** permission group, and **Export (All Reports)** to export it. If you don't have them, ask your OrderEazi administrator to add them to your role.

### How to run the report

1. In the main menu, go to **Reports** > **Supplier Spend**.
2. To narrow it down, type at least 3 letters under **Search Supplier** or **Search Customer**, or a document number under **Search PO/SO/PRO**.
3. Set the **Report date range (SO Created Date)**. It starts on the current month.
4. Select **Generate Report**.

### What the report shows

Each row is a product line that's on both a Sales Order and a Purchase Order, newest first. It shows the **Date** of the Sales Order, the **Sales Rep**, **Customer**, **Industry**, **Supplier**, and the **PRO** (project), **PO**, and **SO** numbers. Then the line's **Name**, **SKU**, and **Supplier SKU**, and its figures, all excluding VAT (Excl):

* **Units Sold**, **Cost (Excl)**, and **Total Cost (Excl)**: The quantity sold, and the cost of one unit and of the line.
* **Selling (Excl)** and **Total Selling (Excl)**: The selling price of one unit and of the line, before discounts.
* **GP Amount** and **GP Perc**: **Total Selling (Excl)** less **Total Cost (Excl)**, as an amount and a percentage.

The **PO** column shows the number from your accounting system, so it's blank until the Purchase Order has synced. Products sold from stock, without a Purchase Order, aren't included.

**Example:** You're meeting Office Direct. You type "Office Direct" under **Search Supplier** and run the report for the last quarter. You export it and add up the columns: 48 lines, R210 000 cost and R285 000 selling, so R75 000 GP. You use the figures to ask for a better price on the chairs you buy most.

The screen shows 10 rows at a time. Select **Load More** for more. There's no totals row on screen.

### How to export

Select **Export**. The Excel file adds the supplier's code in your accounting system, whether each product is a stock product, and the product description.

### Related pages

* [Reports](/central/order-management/reports.md): the other reports
* [Suppliers](/central/order-management/suppliers.md): your suppliers