Reports PREVIEW
RSO has eight on-demand reports, available on the Plus and Enterprise plans: Sales by customer, Sales by product, Purchases by vendor, Stock movement, Low stock, Inventory value, Transfer history and Print history. They work like the reports in RedSmart Accounting and show only the warehouses you work in.
The Period button, Export and comparisons
Next to each report's title is the Period button. It names the period shown, such as This month · Oct 1–23. Open it to pick This month, Last month, This quarter, Last quarter, Year to date or Last year, or enter your own dates under Custom dates and press Show. A report opens on this month. Inventory value shows one day instead: Today, the end of last month, quarter or year, or any date you pick. Low stock always shows stock as it is right now, so it has no Period button.
Export saves the report as a PDF laid out like the page, with your company's legal name from Settings › Company at the top, or as a Spreadsheet (CSV) of the same rows, with amounts as plain numbers.
Reports of a period compare it with the period before: a month with the month before, a quarter with the quarter before, a year with the year before, and custom dates with the same number of days just before them. The This period, Previous and Change columns show the comparison. On a phone, only This period shows.
When you work in more than one warehouse, a Warehouse filter narrows the report to one; All warehouses goes back. The period and filter stay in the page address, so you can bookmark or share a view. All dates are in UTC.
Sales by customer
Go to Reports → Sales by customer. It adds up the sales orders created in the period that were confirmed or shipped, at their line totals after discounts. Drafts and cancelled orders are left out. Each customer shows their number, how many orders and units, and their sales this period and the period before. Sales without a customer are shown as Walk-in sales. The totals at the top show sales, orders, the average order and how many customers ordered. A customer's name opens their page when your role can see customers.
Sales by product
Go to Reports → Sales by product. It shows the same orders by product, with SKU, orders, units sold and sales, against the period before. A kit counts as the kit sold, not its parts.
Purchases by vendor
Go to Reports → Purchases by vendor. It adds up the purchase orders created in the period that were ordered or received, at their order cost, against the period before. Each vendor shows its orders, units and how much has been received so far. The totals show what was ordered, what has been received and how many orders and vendors. A purchase order in a currency other than your company's is left out of the totals, and the report says how many were.
Stock movement
Go to Reports → Stock movement. It shows what came into stock and what went out in the period. At the top are the opening stock, units in, units out and the closing stock.
Units in and Units out break the moves down by cause, against the period before:
- Received from vendors
- Sold to customers (stock goes out when a sales order is confirmed, and comes back when one is cancelled)
- Transfers in and out
- Counts and adjustments
By product lists each product in each warehouse that moved: Opening, Received, Sold, Transfers, Counts and adjustments, and Closing. On a phone you see the change and the closing stock.
The report is worked out from RSO's record of every stock change. If part of the period is from before RSO started keeping that record, the report says so, because moves from before then are missing.
Low stock
Go to Reports → Low stock. It lists every product and warehouse at or below its reorder point, biggest shortage first: Product, SKU, Warehouse, On hand, Reorder point and Shortage. Stock exactly at its reorder point counts as low and shows At point.
The totals show how many items are low, how many are at the reorder point, and how many stock records have no reorder point. Those aren't checked, so set one on the Inventory page if you want them watched. Product and warehouse names open their pages when your role can see them, and Adjust these on the Inventory page takes you to the low items there. The report never places an order: reordering is up to you.
Inventory value
Go to Reports → Inventory value. It lists every product and warehouse with stock: Product, SKU, Warehouse, Qty, Unit cost and Value (quantity × cost). Stock is always valued at each product's cost today, so this isn't a record of what the stock cost when it came in.
Use the Period button to see stock at the end of an earlier day; past days are worked out from the record of stock changes. Value by warehouse compares the day you chose with the end of the month before. Tap a warehouse to filter to it. The totals show the total value, units on hand, and how many products have No cost set. Those are left out of the total, while a cost of 0 counts as $0. Costs are shown only to roles that can see products or edit purchase orders. Other roles see quantities, and compare units instead of value.
Transfer history
Go to Reports → Transfer history. It lists the transfers created in the period with Date (and the transfer's number under it), From and To warehouse, Status, Units and Notes. Open goes to the transfer. Units by route adds up the units sent between each pair of warehouses, against the period before, leaving out cancelled transfers. The status chips (All, Pending, In Transit, Received, Cancelled) show how many transfers in the period have each status now. A warehouse outside your access shows as Another warehouse.
Print history
Go to Reports → Print history. It lists the labels, manifests and packing slips printed in the period from records you can open, with the copies of each kind of document compared with the period before. See Print & labels for reopening a print.