Bin contents. Lists bin contents by location and bin number, along with the quantity on hand for each bin item.
Inventory aging. Provides a list of items on hand and how long they have been in inventory. This report is useful for identifying slow-moving inventory, as well as the costs associated with storing and maintaining it.
Inventory stock status. Compiles data of items and their on-hand quantities. Filters include location, category, item name, and vendor.
Inventory summary. A flexible report that offers much detail regarding items on hand, on transactions, and available for sale. Many other options for column data exist as well. Information can be filtered according to location, category, item name, and vendor.
Inventory turnover. Measures the number of times inventory is sold or consumed in a given time period. Turnover rate is Cost of Goods Sold divided by Average Inventory. Average Inventory is the beginning inventory number plus the ending inventory number, divided by two.
Inventory value. Provides the total quantity and value of an inventory item. Can be filtered by location, category, item name, and vendor.
Item analysis. Shows the profitability of an item based on its standard cost. Filters include location, category, item name, and vendor.
Item movement. Provides details about items’ movements on transactions: the quantity received, returned to vendors, shipped, adjusted, etc., as well as the total quantity in and out.
Items in bins. Compiles data on bin-tracked items that includes item location, bin number, and quantity on hand.
Lot history. Shows the transaction history of lot-tracked items. Can be filtered by item or lot number.
Lot stock status. Gives data on the current status of a lot-tracked item. Filters include location, category, item, lot number, and status (whether it is active, expired, or recalled).
Lot traceability. Tracks the history of a lot-tracked item using its lot number. The report shows receiving and shipping information, as well as the item’s use in builds and processes. The report has the option to include information on whether the item has expired or been recalled.
Lots in bins. Provides data on a lot-tracked item stored in bins. Filters include location, category, item, lot number, bin number and status (whether it is active, expired, or recalled).
Overstock/understock report. Gives a breakdown of inventory for a specified item. The report includes the item’s reorder and maximum stock level, as well as the total quantity. Filters include location, category, item name, and vendor.
Physical inventory worksheet. Creates a worksheet that includes the system count of one or more items and a column for you to enter the actual count of each item listed.
Serial unit history. Shows the transaction history of serial-tracked items. Can be filtered by location, category, item name, serial number, customer, and status (in-stock, used, shipped, adjusted out, or all).
Serials in bins. Compiles data on serial-tracked items that includes the serial number, item name, location, and bin number.
Master purchase report. Provides information regarding purchase orders, item receipts, and returns to vendors. Filter options include data by order type, location, vendor, item, customer, category, class, department, or drop shipment.
Open purchase order detail. Compiles data on purchase orders with items that have yet to be received. The report can be filtered by location, item name, or vendor.
Purchase variances. Shows the difference between the expected (standard) costs and actual purchasing costs, also known as purchase price variance or PPV. The report can be filtered by location, item name, or vendor.
Purchases by category—summary. Recaps the units received according to category, along with their total cost.
Purchases by class—summary. Recaps the units received according to class, along with their total cost.
Purchases by customer—summary. Recaps the units received according to customer, along with their total cost.
Purchases by department—summary. Recaps the units received according to department, along with their total cost.
Purchases by item—summary. Recaps the units received according to item, along with their total cost. Items can be filtered by category, name, or vendor.
Purchases by location—summary. Recaps the units received according to location, along with their total cost.
Purchases by vendor—summary. Recaps the units received according to vendor, along with their total cost.
Reorder report. Generates a list of items which have hit their reorder point. The report also includes for each item the quantity available, the maximum stock level, and the quantity needed to restock inventory to the maximum stock level. If Display is chosen under Retrieve your report, three additional options will appear that are available for selected items on the Reorder Report: Generate POs, Add to Reorder list, and Generate transfer.
Vendor efficiency. Provides information on the turnaround time used by a vendor from the time a purchase order is placed until it is received. The report can be filtered by location, item, or vendor. For each PO listed, the report includes whether the order was delivered on time.
Where to buy. Compiles data from the Vendor-Item Catalog so that you can see which of your vendors sell an item, each vendor’s price, and the quantity you need to order. If Display Report is selected from the Actions menu, the report also allows you to add items to the Reorder List. Available on Plus and Pro plans only.
Commission report. Displays commission data filtered by the sales representative, item name, customer, and order type. The report includes specific transaction information, as well as the commissioned earned.
Master sales report. Provides information regarding estimates, invoices, sales orders, and sales receipts. Filter options include data by order type, location, customer, item, vendor, category, channel, class, customer type, department, sales representative, or keyword.
Open sales order detail. Shows sales order transactions with backordered items. Can be filtered by location, item name, and customer.
Open sales receipt detail. Shows sales receipt transactions with backordered items. Can be filtered by location, item name, and customer.
Price book. Provides pricing information about items, the price tier and customer to whom an item is sold, along with the quantity and sales price.
Profit/loss by customer. Displays revenue, COGS, profit, and profit percentage data by customer. Can be filtered by customer or job name.
Profit/loss by item. Displays revenue, COGS, profit, and profit percentage data by customer. Can be filtered by customer or job name.
Profit/loss by job. Displays income, cost, profit, and profit percentage data by job. Can be filtered by location as well.
Ready to invoice. Compiles a list of sales orders that are ready for billing. Can be filtered by location, item name, and customer.
Sales by category—summary. Recaps by category the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by channel—summary. Recaps by channel the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by class—summary. Recaps by class the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by customer—summary. Recaps by customer the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by customer type—summary. Recaps by customer type the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by department—summary. Recaps by department the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by item—summary. Recaps by item the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by location—summary. Recaps by location the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories.
Sales by vendor—summary. Recaps by preferred vendor (as defined in the item record) the units shipped, revenue, COGS, and profit, as well as the percentages in each of these categories. NOTE: Because sales of an item from other vendors will show a zero dollar amount, the report option “Hide Rows With No Sales” is enabled by default.
Sell through. Shows the percentage of a product that is sold to customers after being received from vendors for a certain date range.
Backorder report. Lists data on backordered sales orders and sales receipts. Can be filtered according to location, item name, customer, and order type.
Fulfillment efficiency. Provides information on the turnaround time in fulfilling customer orders from the time a sales order or sales receipt is placed until it is received by the customer. The report can be filtered by location, item name, customer, and order type. For each PO listed, the report includes whether the order was delivered on time.
Ready to pick/ship. Compiles a list of sales orders and sales receipts that are ready to be picked and shipped.
Shipping report. Shows completed shipments by transaction, ship date, customer, item and quantity shipped.
Expanded BOM report. Provides details on an assembly item, including each component, its vendor, the quantity on hand, the quantity used in a build, the cost of each component, and the line total.
Open work order detail. Shows status of open work orders. Includes how many units have been ordered, as well as how many remain to be finished.
Production report. Provides information on build and process transactions, the outputs, and the output quantity.
Where used. Shows how an item is used and the quantity used. Can be filtered by category, item name, and vendor.
Work in progress. If using the work center feature, any build or process transaction in a work center will not reflect in the Inventory Value report. The WIP report accounts for those transactions, listing builds and processes that are in progress. The Work in progress report includes the transaction reference, output, input, input quantity and input value. These item values, when combined with the results of the Inventory Value report, should balance with the asset account(s) total in QuickBooks.
Open rental detail. Shows rental transactions with outstanding items. Can be filtered by location, item name, and customer.
Rental calendar. Shows the due dates for rental items. Filters include location, item, serial number, and customer.
Reconcile item receipts. Provides data on bills, cash purchases, checks, and credit card charges pertaining to item receipts. Highlights financial information that is missing or has a discrepancy with QuickBooks Online.
Reconcile journal entries. Shows journal entry information pertaining to transactions. Highlights financial information that is missing or has a discrepancy with QuickBooks Online.
Reconcile vendor credits. Displays credit information on return-to-vendor transactions. Highlights financial information that is missing or has a discrepancy with QuickBooks Online.
Deleted items. Displays the Deleted items list. Available actions include Restore and Transaction history. The columns available on the Deleted items list are identical to those on the Items list. The Cost basis column is helpful in identifying discrepancies between SOS Inventory and QuickBooks Online, allowing you to determine whether any deleted items still have assigned value.
Transactions assigned. Generates a list of transactions with the name of the individuals to whom they have been assigned. Can be filtered by user or transaction type.