Main Menu> Warehouse Management > Analysis Tools > Profitability
This report shows the Sales Quantity and the Sales Value (sales Price & MRP), Discount, Cost Price, Profit %, Mark Up & mark Down in respect of Opening, Stock In, Stock Out & Closing Stock, along with Profitability analysis figures of Profit, Margin & Mark Up Values.
In collapse mode, the report shows the figures at Stock Group level, while in expand mode, item wise details are shown.
You may explode any Item Group to see the Item details of the specific Group.
Columns in the Profitability are as follows:
Product ID
|
Shows Product id, four digit product code.
|
Child ID
|
Shows Product child id.
|
Type
|
Shows Voucher Type. E.g. Sale, Sale Return etc.
|
Date
|
Shows Transaction date.
|
Time
|
Shows Transaction time.
|
Vch Number
|
Shows Voucher number of the transaction.
|
Qty
|
Shows Transaction quantity.
|
MRP
|
Shows MRP of the item.
|
Sal Rate
|
Shows Sale Rate of the item.
|
P Cost
|
Shows Cost Price of the product.
|
Pur Rate
|
Shows Purchase Rate of the item.
|
Amt (CP)
|
Shows total cost price of the item (Qty x P Cost).
|
Amt (MRP)
|
Shows total MRP of the item (Qty x MRP).
|
Amt (SP)
|
Shows total sale price of the item (Qty x Sale Price).
|
Disc %
|
Shows % of discount given during sale.
|
Profit
|
Shows profit amount.
|
Margin
|
Shows margin % = [(MRP - P Cost)/ P Cost] x 100).
|
Markup
|
Shows markup % = [(Sale Price - Cost Price) / Sale Price)] x 100.
|
|
Buttons in the Profitability Report:
Buttons in Profitability are explained in Using Reports (Register).
Include Tax Amount in Sale in Profitability Report
Scenario
You might want to include the tax amount in the sale amount in profitability report.
Solution
We have added a button in Profitability Report to calculate the profitability after including tax amount in the sale value.
●“Sale With Tax” (toggle button)