Purchase Cost Analysis Report

Purchase cost analysis report details the costs associated with purchasing every product during a given period. Use this report to view the Quantity, Main Cost, Additional Cost, Journal Cost and Tax for every product purchased over the reporting period. The output can be customised to show product details, PO #, supplier, location, status and time period.


Users need the Purchase Reporting permission to access this report.


Prerequisite


Table of Contents

Data from this report can be exported in Excel, PDF or RTF format. 



Input:

Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range. This report is filtered by Stock Received date.
CurrencyAllows the user to select the currency to be used in the report.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 



Output:

The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.


Fields
SupplierSupplier name
PO #Purchase order number identifying the purchase
Invoice #Purchase invoice number
SKUUnique product stock keeping unit
ProductName of the product
LocationLocation the product is received at
Batch #Batch or Serial number associated with stock received
CurrencySupplier currency code this purchase is created in
CategoryProduct category
BrandProduct brand
Product TagsComma-separated product tags
FamilyProduct family name
UnitProduct unit of measure
Supplier SKUProduct stock keeping unit assigned by the supplier
Supplier ProductProduct name assigned by the supplier
Order DateDate when the purchase was created
Expiry DateDate when the current product batch expires
StatusPurchase status
YearYear of the invoice date
QuarterQuarter of the invoice date
MonthMonth of the invoice date
Supplier Additional Attribute 1-10Values of Additional supplier attributes
Product Additional Attribute 1-10Values of Additional product attributes
Data Headers
QuantityReceived quantity minus unstock quantity if any
Main CostMain invoice cost for the batch
Additional CostPortion of additional costs distributed to the batch
Journal CostPortion of additional not capitalised costs distributed to the batch
TaxTax amount combining both main invoice and portion of additional costs associated with the batch

NOTE: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields. 


FAQs

[back to top]


I have a question on a purchase order that was completed as a drop shipment and the cost from the manual journal has not been associated with the cost and so when it goes to the sales the margin is based on the cost of the product only. I also went to look at the Purchase Cost Analysis Report and the PO doesnt even show up.

We do not include manual journals and movements for dropship items in Purchase Cost Analysis because in this case nothing to add the cost to. No product movement has happened in DEAR, so journal is just a transaction. Drop Ship Purchases relate to profit/cogs figure in linked sale only. 


Is there a report except PURCHASE COST ANALYSIS REPORT  and PRODUCT PRICES BY SUPPLIER Report  which will also show the cost price versus the RRP (Recommended Retail Price) as a %? Basically, our prices change every week from suppliers so we need to keep track of these in a report to make sure we are charging enough. I would like to see the difference between 1 item cost and RRP - only the bulk items? Is there a function to work out the difference in cost?

Currently, we do not have such a report. However, you could definitely add this as a feature request in our forum, it sounds very useful from over here. Our developers will review this and take it up in due course. 


Hello, Can you point me to a report which tells me my cost on a per product basis?

You may try referring the below mentioned reports to view per product wise cost.


Why are my costs showing as 0?

This report is filtered by Stock Received date, but costs are assigned to a purchase on the purchase invoice authorisation date. If the invoice date is not covered by the reporting period of the report, costs from this invoice will show as 0. Expand the reporting period range to cover the invoice date to see the full costs. 



Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.