Reports
Five reports that answer the five questions worth asking — who buys, who you buy from, what actually makes money, what is on the shelf, and what one account owes.
What this screen is for
Reports is a hub. It lists the five reports with a line about each; click one to open it. All of them take a date range and all of them print.
How to get here
Sidebar → Reports.
Customer Sales
Three levels of detail:
- By customer — Customer, Customer No, Bills, Qty, Amount, Net Amount, Outstanding, First Sale, Last Sale
- By invoice — Invoice No, Date, Method, Reference, Invoice Total
- By item — Item No, Item Name, Product, Qty, Net Qty, Amount, Cost, Profit, Margin
Use it to find your best guests, and to see who is quietly running up a balance.
Supplier Purchases
Columns mirror the customer report: Supplier, Bills, Qty, Amount, Returned, Net Amount, Outstanding, Last Purchase — and drill-downs to Bill No / Bill Total and to the items bought.
Use it before paying anyone, and to see which supplier's prices have crept up.
Profit by Item
| Column | Meaning |
|---|---|
| Item Name, Type, Category | What it is |
| Qty | How many sold |
| Returned | How many came back |
| Amount / Net Amount | Revenue, before and after returns |
| Cost | What those sales consumed, from the recipe |
| Profit | Net amount minus cost |
| Margin | Profit as a percentage |
| Bills, First Sale, Last Sale | How often and how recently |
This is the most useful report in the app. Sort by Margin and you will usually find one popular dish making almost nothing, and one quiet dish worth pushing.
Stock Value
Item, Type, On Hand, Value at Cost, Value at Sale. This is your store room as a number — and the report to run before a stock count.
Account Statement
Pick an account and get: Date, Doc No, Type, Description, Method, Debit, Credit, Balance, Remaining.
It reads like a bank statement: every bill adds, every payment subtracts, and the Balance column carries forward. This is the report to print and hand to a customer who disputes what they owe — it works for suppliers too.
Step by step
Month-end review
- Profit by Item for the month — check your margins.
- Customer Sales — who is outstanding.
- Stock Value — what is tied up on the shelf.
- Supplier Purchases — what you owe and to whom.
Settling a dispute
- Account Statement → the customer → a range covering the whole relationship.
- Print it. Every bill and every payment is on it, in order.
Good to know
- Reports print cleanly — the app has dedicated print layouts for them, so what comes out of the printer is not a screenshot of the screen.
- Every report respects the date range. A figure that looks wrong is usually a range that does not cover what you think.
- Customer and supplier statements were once separate; both now live in Account Statement.