Reports
27 reports. Each one opens with the headline numbers and what stands out, then the detail, and every table downloads as a spreadsheet.
E-commerce
What is selling, where, and to whom.
Sales overviewSample dataRevenue, orders, average order and units for the period, how they compare with the period before, and the trend.Sales by marketplaceSample dataEach marketplace side by side: orders, revenue, what it keeps in fees, and what is left.Best-selling partsSample dataThe parts that brought in the most revenue, with units, margin and what is left to sell.Sales by brand, category and conditionSample dataWhich brands, departments and conditions sell, by units and revenue.CustomersSample dataNew and returning customers, how often they come back, who spends the most, and where orders ship.Returns and cancellationsSample dataOrders that were cancelled or came back, how often it happens, and why.
Accounting
Money in, money out, and what is left.
Profit and lossSample dataWhat was earned, what it cost, and what is left, line by line and month by month.Payments receivedSample dataMoney that came in, by payment method, what was kept in fees, and orders still waiting to be paid.ExpensesSample dataMoney that went out, by category and by who was paid.Shipping costsSample dataWhat labels cost against what customers were charged, by carrier, and the orders that lost money on shipping.Inventory valuationSample dataWhat the stock on the shelves is worth at cost and at list price, by department, condition and price band.MarginsSample dataProfit on what sold, by brand, and the parts in stock priced closest to (or below) what was paid for them.Sales tax collectedSample dataTax collected from customers, by the state the order shipped to. This money is owed, not earned.Profit by orderSample dataWhat each order actually made after the cost of its parts, marketplace fees and shipping labels.Audit historySample dataEvery recorded change to money, suppliers, customer accounts and what may be sold: who made it, when, and exactly what changed. Stock changes are in their own report.
Operations
The warehouse, the catalog and the team.
Inventory agingReal dataHow long stock has been sitting since it was first listed, and the oldest parts that have never sold.Sell-through by brandReal dataOf everything listed for a brand or department, how much has sold. Shows what moves and what sits.Recommended itemsSample dataParts customers are looking for that Banyan has few or none of, ranked by demand. The list to buy from.Stock changes and shrinkageSample dataEvery reason stock went up or down, and the adjustments people made by hand.Fulfillment speedSample dataHow long orders take to ship and arrive, how many go out within a day, and what is waiting right now.Shipping issuesSample dataShipments flagged with a problem, shipments running late, and what kinds of problem come up.Tasks and employeesSample dataWork finished by each person, how quickly, what is overdue, and which kinds of task pile up.Marketplace coverageReal dataHow much of the catalog is listed on each marketplace, and the parts in stock that are missing from one.Catalog completenessReal dataWhat is missing from product records: part numbers, UPCs, weights, sizes, photos, descriptions and costs.Used items by gradeSample dataUsed, refurbished and for-parts stock by condition grade, and the items still waiting to be graded.Supplier performance and credit recoverySample dataFor each supplier: what arrived, what was wrong with it, what was claimed and how much actually came back.ReceivingSample dataDeliveries checked in, how accurate they were, how long they took, and what is waiting on hold.