Profitability Reports by Item and Customer for Traders

Profitability Reports by Item and Customer for Trading Companies

Most traders know their total sales, but few know the exact profit on each item and each customer. Profitability reports reveal it, provided the data behind them is right: landed cost, discounts, returns and the cost of serving each customer.

Trade and import 6 min read

By Nour Aldein Tleti. Updated 7 October 2026.

How do I find the profitability of each item and each customer?

Calculate the gross profit of each invoice line by line: the actual selling price after discount minus the item’s landed cost. Then total the results by item and by customer, and add service costs such as delivery, late payment and returns. This needs a system that links purchasing, stock and sales, because separate Excel files don’t keep the correct cost for every transaction.

The data the reports need

Landed cost per item: Supplier price plus shipping, clearance and transport, calculated for each shipment and updated with every receipt.
Actual selling price: After discounts, promotions and free quantities, not the list price.
Returns and damaged goods: An item that is returned often may look profitable in sales and actually lose money.
Currency and exchange rate of each transaction: Without them, trading profit gets mixed up with exchange differences.

Reports worth following

Item profitability: Rank items by gross profit and margin, not by sales alone.
Customer profitability: The profit each customer leaves after discounts, service costs and payment time.
Territory and rep profitability: Comparing territories shows where you need to change prices or routes.
Slow-moving items: Goods that don’t move tie up money and space, and their cost grows over time.
Supplier profitability: Comparing each supplier’s items after landed cost shows which supplier deserves a bigger share of your purchasing.

Reading the reports with Syria in mind

Separate trading profit from currency profit: A year may look profitable because stock value rose with the exchange rate, not because of the sales themselves.
Compare with replacement cost: Ask: what would it cost me to buy this item today? The current selling price may be lower than the cost of restocking.
Count the cost of waiting: A customer who pays late in a local currency that is losing value shrinks your real profit.
Separate cash from credit: Profit on a cash invoice is effectively different from profit on an invoice paid months later, so show the two separately.

From data to decision

01
Fix the cost first
Review how landed cost is calculated and how shipping expenses are allocated to items.
02
Link the invoice to cost
Every invoice line carries the item’s cost at the moment of sale.
03
Build a simple dashboard
A few clear indicators are more useful than dozens of tables.
04
Review monthly
A monthly meeting to discuss the best and worst items and customers.
05
Make at least one decision
Adjust a price, drop an item or change a customer’s terms. A report without a decision has no value.
06
Share the decision with the team
Tell purchasing and sales what changed and why, so everyone works from the new results.

What to do with the report’s findings

Finding	Likely explanation	Suggested action
High-selling item with a weak margin	Low price or outdated cost	Review pricing and landed cost
Large customer with little profit	Heavy discounts or late payment	Renegotiate the terms
Item that hasn’t moved for a while	Weak demand or the wrong price	Run a clearance offer or stop buying
Territory with falling profit	Competition or high delivery cost	Review the route and prices there
Small customer with a high margin	Buys distinctive items and pays regularly	Keep them and offer complementary items

Read also

Trade and import

Frequently asked questions

Can these reports be built in Excel?

A small company with few items can do it, but errors build up with manual copying and changing costs. Once items multiply, a connected system is safer.

What is the difference between margin and gross profit?

Gross profit is an amount: selling price minus cost. Margin is that profit as a percentage of the selling price. You need both, because an item can earn a large amount on a small margin.

How do we allocate shipping costs to items?

By value, weight or volume, or a mix of them. Choose a method that makes sense for your goods and apply it consistently, because changing it every time ruins comparison.

Should we share profitability reports with reps?

Share what helps them sell better, such as items with a good margin, without revealing detailed costs for every item.

Who reads these reports in the company?

The owner, the finance manager and the sales manager, each at the level they need: a short dashboard for management and detailed reports for accounting.