Chapters

Purchases & money

Reports

Sales, profit, best and slow sellers, stock value, expiry, purchases, dues, cashier closing, cashbook and VAT, for any dates and branch.

Who it is for:ManagerOwner

On this page

Reports › All reports lists every report. Each one has date and branch filters, can be printed, and most can be downloaded for Excel.

Reports
Reports

Which report answers which question

ReportAnswers
Sales summaryHow much did we sell, by day, cashier, branch or payment method?
Sales & profit by product / categoryWhich products, categories or brands bring the most revenue or profit? Sort by revenue, profit or margin %.
Profit & lossSales minus cost of goods and expenses, month by month.
Cashier closingEach cash shift: expected and counted cash, over or short.
Returns & exchangesEvery return and exchange and how it was paid back.
Best / slow / non-moving productsWhat sells, what barely sells, and what hasn't sold at all (dead stock).
Stock valuationWhat the stock is worth today, at cost and at selling price.
Expiry reportLots expiring within the days you choose.
Purchase reportPurchases by supplier or product.
Supplier duesWhat you owe each supplier, aged 0–30, 31–60, 61–90 and 90+ days.
Customer dues (baki) agingWho owes you, and for how long.
Expenses by categoryWhere the running costs go.
CashbookEvery cash movement of an account, day by day.
VAT by monthVAT collected and paid per month.
Sales summary
Sales summary

Profit

Profit uses the moving average cost: each purchase updates the average cost of the product, and each sale takes that cost. So profit is right even when you bought the same item at different prices.

Profit and loss
Profit and loss

VAT summary

Reports › VAT summary (Mushak-style) has three tabs: Summary (Mushak 9.1 style), the sales register (6.2) and the purchase register (6.1). It helps you or your VAT consultant fill in the return. It is not an NBR return itself.

VAT summary
VAT summary

Branches

Reports follow the branch in the top bar. Staff tied to one branch see only their branch and don't see the whole-shop reports (supplier and customer dues).