50+ Cin7 Core Reports for Success
Cin7 Core Reports - Purchase Reports
-
Pending Purchase Orders
This Cin7 Core report shows pending purchase orders. A purchase order is pending if it has been authorised but the invoice for ordered items has not been processed yet and/or stock is not received. Use this report to see PO status and number of items ordered, still to invoice, and still to receive for a supplier or PO #.
-
Purchase Order Details
This Cin7 Core Report Shows details of purchase orders. This detailed view breaks down purchase orders by product. Use this report to see details of which products are ordered and item quantity, product cost and total product cost per order.
-
Purchase Order Summary
This report shows a summary of purchase orders. This summary view displays purchase orders without product details. Use this report to see order totals, invoice totals and amount due for each supplier order.
-
Purchase Order vs Invoice
This report compares what has been ordered vs what has been invoiced. Use this report to view discrepancies between order and invoice item quantity, order and invoice cost per item, and order and invoice total.
-
Stock Received Not Invoiced
This report displays purchase orders where stock has been received but the supplier has not yet issued an invoice. Use this report to see the item quantity, item cost and total cost for orders with stock received but not yet invoiced.
-
Purchase Invoice Details
This report shows details of purchase invoices. This detailed view breaks down purchase invoices by product. Use this report to see details of which products have been ordered and item quantity, product cost and total product cost per invoice.
-
Purchase Invoice Summary
This report shows a summary of purchase orders. This summary view displays purchase orders without product details. Use this report to see invoice totals, amount paid and amount due for each supplier invoice.
-
Purchase Invoices & Credit Notes
This report shows all authorised purchase invoices and credit notes applicable to the selected time period. Use this report to see invoices and credit notes for each supplier, what products it relates to and amount, tax and total. Amounts can be shown in supplier currency or your base currency.
-
Stock Received vs Invoice
This report compares stock received vs invoice. Use this report to see what has been received but not invoiced or what has been invoiced but not received, along with the order total. You can choose the currency in which to display the order total.
-
Purchase Cost Analysis
Purchase cost analysis report detailing the costs associated with purchasing every product during a given period. Use this report to view Quantity, Main Cost, Additional Cost, Journal Cost and Tax for every product purchased over the report period. The output can be customised to show product details, PO #, supplier, location, status and time period.
-
Supplier Financial Summary
This report indicates summaries of all financial transactions for every supplier including opening balance, total invoiced, total paid and closing balance for the selected time period. You can choose which currency in which to display the summary.
-
Product Prices By Supplier
This report shows the latest price and fixed price (if applicable) for every supplier/product combination. Prices are shown in supplier currency. It also supplier SKUs and whether dropshipping is enabled. This report allows for editing of data via CSV export/import. This report can not be customised.
-
Inventory Suppliers
This report, like the above, shows the latest price and fixed price (if applicable) for every supplier/product combination. Use this report to customise the output to show various product details such as supplier SKU/name, category, product family, brand and more.
Cin7 Core Reports - Sale Reports
-
Sale Outstanding Quotes
This Cin7 Core Report shows all authorised quotes without an authorised sale order/invoice issued during the specified time interval. Use this report to check quote status and view quoted item quantities and quote price per product, customer, sales rep and more.
-
Sales Overview
Shows an overview of all sales, the customer and the sale and shipment status. Use to get a snapshot of sales status and financials (amount invoiced, paid, due, COGS, profit, etc.). The overview does not show product information.
-
Sale Order Details
Shows details of sale orders. This detailed view to breaks down sale orders by product, showing product quantity. The output can be customised to show product details, order/invoice status and more.
-
Pending Sale Orders
Shows pending sale orders. A sale order is classed as pending if the order has been authorised but it does not yet have an authorised pick. Use to see item quantities required per customer, per sale order, per sales rep. and more.
-
Fulfillment Details
Shows fulfillment details for authorised sale orders. Use to see fulfillment status for each order, with quantity picked, packed and shipped. The output can be customised to show carrier, tracking info and more.
-
Sale Invoices & Credit Notes
Shows all authorised sale invoices and credit notes applicable to the selected time period. Use to see invoices and credit notes for each customer, what products it relates to and amount, tax and total. Amounts can be shown in customer currency or your base currency.
-
Sales Profit Summary
Shows profit and additional financial summary for sales. Services, gift cards and non-inventory products are not included on the report. Use to see an overview of amount invoiced, paid, COGS, profit, markup, gross margin and FX gains/losses per order or per customer. The output does not show product details.
-
Profit by Sales Representatives
Shows profit and additional financial summary by sales representatives. Use to see the amount invoiced, paid, COGS, profit, markup, gross margin for each sales representative’s sales per order or per customer. The output does not show product details.
-
Sales by Product Details
Shows quantities, profit and additional financial summary for sales by product. It shows product quantity, amount invoiced, COGS, journal amount, tax and profit. The output can be customised using product details Use to view product sales by customer location (state, country, etc.).
-
Sales by Product Summary
Shows quantities, profit and additional financial summary for sales by product. It shows product quantity, amount invoiced, COGS, journal amount, tax and profit. The output can be customised using product details. does not allow the output to be customised by customer location.
-
Sales Price History
Shows sale price fluctuations for all active products during the selected time period. Price history can be further filtered by location, price tier, year, quarter, month and invoice date.
-
Sales Backorder Details
Shows all authorised sale orders containing backordered items which have not yet shipped to the customer. Use to see which customers and sales orders are waiting on backordered products, the backordered quantity and the date … . does not show product availability in your inventory.
-
Sales Backorder Summary
Shows all backordered products in your inventory. Use to view a summary of backordered products, the supplier for the order, and quantity required, on hand, remaining (on hand - required) and ordered. does not show which sales order the backordered product corresponds to.
-
Find Sale Backorder By Purchase Order
Allows finding all sales included in a specific purchase order created via the 'reorder backordered' function. Use to see products ordered, quantity ordered, supplier and whether stock has been received yet. You can also change the column order to find purchase order by sale backorder.
-
Customer Payment Details
Shows payment details by customer with invoiced, paid, still due/credited for the selected time period. Output currency can be changed. Use the detailed view to see payment details for each order/invoice.
-
Customer Payment Summary
This Cin7 Core Report shows shows a payment summary for your customers, with total invoiced, paid and still due/credited for the selected time period. Output currency can be changed. does not break down totals by order/invoice.
-
Customer Orders by Product
Shows detailed financial and quantity-related information about each product sold. Use to see how much of each product is sold, how profitable/costly each one is, and which customers are buying your product.
-
Sale Credit Notes by Product
Shows detailed financial and quantity-related information about each sale credit note. Use to see how many credit notes are being raised for your products and which customers are raising them.
-
Inventory Velocity
Calculates reorder dates and suggests reorder quantities using the lead time, safety stock and velocity (units sold/day) parameters. Use to make sure you have enough inventory in stock to meet your forecasted sales.
-
Sales Demand Forecast
This Cin7 Core Report Uses historical sales data to estimate future sales quantities of goods and services. can also take into account authorised orders that have not yet been fulfilled.
Cin7 Core Reports - Inventory Reports
-
Cin7 Core Report - Product AvailabilityThis report shows available, on-hand, allocated and on-order quantities and stock value for every product in every location for every batch/serial number and expiry date. Cin7 Core informs users of the expected delivery date of stock currently on order. This report cannot be customised. Use the Products Stock Level report for a more detailed view.
-
Cin7 Core Report - Inventory Movement Details
This report shows a summary of stock movements in a specified timeframe. Use this report to see inventory movement details for specific transactions including transaction reference, date, quantity in and out and cost in and out.
-
Cin7 Core Report - Inventory Movement Summary
This report shows a summary of stock movements in a specified timeframe. Use this report to see financial information such as stock on hand value, volume on hand (if dimensions are specified), unit cost and average cost for all active products. The summary report does not show transaction references.
-
Cin7 Core Report - Products Price List
This report shows a product price list. Use this report to see all of your inventory products listed with prices from up to 10 price tiers.
-
Cin7 Core - Products Stock Level
This report shows the current stock level of all active products in all locations. Use this report to see available, on-hand, allocated, on-order, reordered and minimum before reorder quantities. You can also check the stock on hand value and unit cost of products.
-
Cin7 Core - Warehouse Details
This report shows warehouse details for fulfilled sale orders in selected date range.
-
Cin7 Core - Products Reordering
This report shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for all active products.
-
Cin7 Core - Products Low on Stock
This report shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for active products with stock levels below the minimum before reorder quantity.
-
Cin7 Core - Inventory Aging
This report shows the average age of your inventory. Use this report to see how long products stay in stock measured by time interval (0-30 days up to over 180 days).
-
Cin7 Core Report - Lot Expiry
This report shows all product batches with their expiry dates. Use this report to check how much quantity on hand you have of different product batch numbers and when they will expire.
-
Cin7 Core Report - Lot Recall
Use this feature to track your lot/batch/serial number usage from Purchase/manufacturing through to Sell. Prepare recall letters for customers in case of a Recall event.
-
Cin7 Core Report - Job Costing materials
This report shows materials and stock used on a particular job during the selected time period. It also indicates where this material was purchased if it did not come from inventory already in stock. Use this report to see the quantity and cost of job costing materials.
-
Cin7 Core Report - Production Cost Analysis
This report shows completed finished goods within the selected time period. Use this report to analyse finished goods yield quantity, production cost, and cost of component products and services.
-
Cin7 Core Report - Disassembly Analysis
This report shows completed disassemblies within the selected time period. Use this report to analyse disassembled quantity, cost of disassembled item and any costs from services during the operation.
-
Cin7 Core Report - BOM Component Details
View a list of BOM products that consist of the queried component items along with their relevant product details.
-
Cin7 Core Report - Out of Stock Components for Auto-Assembly
This report shows out of stock components for auto-assembly products grouped by location. Use this report to see the quantities of components that need to be ordered to complete your pending auto-assembly operations.
Dear Inventory Reports - Audit Reports
-
Audit report
System activity report shows all changes in DEAR. Use the Audit Report to view details of all actions performed by each user in DEAR, including all integration- and security-related changes made by authorised users to DEAR configuration settings.
Cin7 Core Reports - Production Reports
Production Reports are for companies that make use of the Production module. If you have not signed up for this module, then it will not yield any data/report.
-
Cin7 Core - Production Overdue report
This report shows the Production Orders/Production Runs which execution is not started on the required date. Use this report to see what Production Orders should be started ASAP to meet the Required by Date.
-
Cin7 Core - Production Required By Date Exceptions report
Required By Date Exceptions shows the Production Orders for which the Required by Date is changed. Use this report to see what customers should be notified about changes in the delivery of their products.
-
Cin7 Core - Production Cost Analysis
This report shows completed finished goods within the selected time period. Use this report to analyse finished goods yield quantity, production cost, and cost of component products and services.
-
Cin7 Core - Production Actual Vs Planned Cycle Time
This report shows the ratio of planned time vs actual time spent to production process to measure the speed of production.
-
Cin7 Core - Production Finished Products Wastage Rate
This report shows the portion of defective elements in relation to all items produced to measure the quality of production.
-
Cin7 Core - Production Components/Resources Used In Production BOM
This reports shows a list of all components and resources used in Production BOMs.
-
Cin7 Core - Production Cost Breakdown
This report shows the costs breakdown by resource costs, material costs and manufacturing overhead endured and costs overrun during production process. Use this report to analyse costs and cost overrun.
-
Cin7 Core - Production Shortage
This report shows the products required for the current Released and Work in Progress Production Orders.
-
Cin7 Core - Production Downtime
The report is intended for display of downtime for the production process. This is the time when resource is not working due to the planned or not planned reasons.