Chapter 19
Reports
Most reports can be filtered by a Period preset (Today, Yesterday, This Week, Last Week, This Month, Last Month, This Quarter, This Year, Last Year) or a Custom date range. Reports show your branch; company-wide users see the branch chosen in the header, or every branch with “All branches.” Most reports can be printed, and exported to CSV on Growth+.
If your business sets prices or keeps average cost per branch (sections 8.6 and 8.7), the stock reports use the prices and costs of the branch you're viewing. With “All branches,” each branch's stock is valued at its own price and cost.
19.1 Available on every plan#
| Report | What it shows |
|---|---|
| Sales Report | Sales in the period, filterable by payment method, payment status, and cashier |
| Stock Valuation | Current value of stock on hand |
| Stock by Branch | Stock levels of every product, one column per branch plus a total, with average cost and stock value. Filter by Branch, Category, Product / SKU, and Stock Status (In Stock / Low / Out); sort by name, stock, or value; export to Excel. |
| Top Selling | Best sellers by quantity, revenue, or profit, filterable by category and result limit |
| Low Stock Alert | Products under their reorder level, with severity and days-until-stockout, filterable by category |
| Expiry Report | Only while batch tracking is on. Every tracked batch, earliest expiry first: product, branch, batch no., expiry date, days to go, status, quantity, and value at cost. Summary cards for Expired, Expiring within N days, Unknown Expiry, and All Tracked Stock. Filter by status (default: “Needs attention”) and category. |
| Damaged Stock | Only while damaged stock is switched on (section 9.4). Damaged items in stock now, per product, with their value at cost and at the normal price. For a period: how many were marked damaged, sold (with their normal price, what they sold for, and the discount given), returned or written off, and cleared as a mistake. Filter by period and category. |
| Tax Report | Tax charged on sales (output tax) and paid on purchases (input tax) for a period, each by rate, with the sales and purchases that carried no tax, and the Net tax payable (or refundable). Periods: This Month, Last Month, This Quarter, This Year, or a custom range. Print it, or export every taxed sale and purchase — with the customer's or supplier's TIN — to CSV. |
| Daily Cash | Only with Access Financial Accounts. One cash drawer, day by day: cash brought forward, money in and out, money sent to the bank and mobile money, cash counts, and what's carried forward. See section 19.5. |
19.2 Advanced reports (Growth & Enterprise only)#
On the Core plan, the Advanced Reports add-on adds these reports.
| Report | What it shows |
|---|---|
| Receivables | Outstanding customer debt, with 0/30/60/90+ day aging buckets and risk level. Opening debts are aged from the date they're owed since (section 6.3). |
| Payables | Outstanding supplier debt, sortable by amount, name, or age, including opening debts (section 7.3). Payments made on a supplier's page count against their oldest debts. |
| Profit & Loss Statement | Revenue, cost of goods sold, gross profit, operating expenses, and net profit for a period, with category breakdown, a daily trend, and comparison to the prior period. Only for those who can see profit (section 19.4). |
| Dead Stock | Products with no sales in a chosen number of days (default 90) that are still holding stock value |
| Profit Margins | Per-product margin analysis, sortable by margin, profit, or revenue. Only for those who can see profit (section 19.4). |
| Customer Credit Settlement | Multi-branch only. When customers deposit money at one branch and spend it at another, this shows each branch's Deposits Issued, Credit Redeemed, amount already Settled, and Net Position — plus a Suggested Settlement table saying which branch should pay which, and how much. |
| Branch Performance | Multi-branch, company-wide users only. Branches ranked by revenue for the period, with sales count, average sale value, gross profit, and margin. Only for those who can see profit (section 19.4). |
19.3 Settling customer credit between branches#
- Reports → 🔁 Customer Credit Settlement, and choose the period you're settling.
- In the Suggested Settlement table, find a row (From branch → To branch, Amount Owed) and click “Record Settlement →.”
- On the transfer screen, which only offers the two branches' accounts, confirm the money movement.
19.4 Who sees profit#
Not everyone needs to see how much the business makes. Only these users see its profit:
- Core and Growth: users with the Admin role, unless your plan has custom roles.
- Enterprise: users whose role has the View Profit permission (profit.view). The Admin role has it, and you can give it to any other role (section 21.2). This also applies on Growth with the Custom Roles add-on.
Everyone else:
- Doesn't see Profit & Loss, Profit Margins, or Branch Performance in the Reports menu, and can't open or export them.
- Sees the Dashboard without today's and this month's profit, and without the profit line on the trend chart. Top Products and Category Performance are ranked by quantity and revenue instead.
- Sees Top Selling and Stock Valuation without their profit, potential profit, and margin columns, and gets the Stock Valuation, Top Selling, and Dead Stock exports without them.
19.5 Daily Cash Report#
Reports → 💵 Daily Cash follows the cash in one drawer, a branch's Cash account, day by day. Choose the Cash account and a Period; it opens on today, for your branch.
One day#
- Cash: brought forward from the day before; money in (cash sales, payments on earlier sales and opening debts, customer deposits, money received from other accounts, cash over at a count); money out (refunds, expenses, payments to suppliers, sent to bank, sent to mobile money, transfer charges, cash short at a count); and carried forward, what should be left in the drawer at the end of the day (“Cash at hand now” for today).
- Sales: the branch's sales for the day by how they were paid (cash, mobile money, bank, customer deposit, credit), and what's still owing on them.
- Cash counts: each count, with who counted, what should have been in the drawer, what was counted, and whether it was short, over, or matched (section 15.5). A line says how much came in or went out after the last count.
- Money moved: each transfer to or from the drawer, with its time, the other account, and who made it.
Cash sales is the cash taken at the till on the day of the sale. Money taken later for a sale made on an earlier day is a payment on an earlier sale.
Several days#
For a longer period there's a row per day: sales, brought forward, money in, sent to bank, sent to mobile money, other money out, short or over at count (“Not counted” on days without one), and carried forward. Each day's carried forward is the next day's brought forward. Click a day to see it in full. A period can be up to 92 days.
Changed since counted#
A count is marked “Changed since counted” when something was recorded afterwards under a time before the count, an import of past sales, say. That changes what the drawer should have held when it was counted, so check that count again.