Skip to the page content

Questions about reports

Answers about this month's profit, today's sales, best sellers, cash balances, stock value, COGS, the Balance Sheet, branch reports, and PDF or Excel downloads.

On this page

How do I see this month's profit?

Open Reports → Profit & Loss, then choose From and Until. The report shows net sales, cost of goods sold, gross profit, expenses, other charges and other income, then Net profit. A negative figure means a loss. Profit & Loss is only open to holders of the Sensitive Reports role. See Reading Profit & Loss.

How do I see today's sales?

The Dashboard shows Sales today, Sales this month, Notes today and Average note this month against the previous period, with the best sellers, this month's customers, the latest transactions, payment methods and charts of sales per day and busy hours. The figures shown follow your role. Every note is listed in Transactions → Sales. See Seeing your sales results.

Do the dashboard figures change by themselves?

With Reverb on, yes. When a note is posted, voided or returned, money in or out is recorded, or stock moves, an open dashboard works out its cards again by itself, at most once every 30 seconds and only while its tab is visible. Without Reverb the figures are worked out once when the page opens, so reload the page for the latest. The stock value, the 6-month chart and the alerts are kept for up to 5 minutes. See Dashboard: today's summary.

Can I click the figures on the dashboard?

Yes. Tap a figure card, such as Sales today, to open today's posted notes in Transactions → Sales. On a chart, tap a day, an agent's bar or a category slice, or press See details. Product, order and cash account names under the alerts and Cash Balances, and Checked in and Late under Attendance today, can be tapped too. The page that opens is already filtered to that figure and the branches picked. A figure whose details page you may not open cannot be tapped. See Opening the details from the dashboard.

Why do I not see the stock value or the monthly profit chart on the dashboard?

The Stock value, Gross profit this month and Sales and expenses over the last 6 months show only to Sensitive Reports holders, as the cost price and the profit do everywhere else. Without that role, Stock and slow movers shows the number of products in stock and the slow movers only. Other cards follow your role and the shop's features: sales per channel needs Sales channels on, and sales per branch needs Several branches on and more than one branch you may use. See Dashboard: today's summary.

How do I know which products sell best and earn the most?

The five best sellers of this month show in the Best sellers card on the dashboard. For every product with its profit, open Reports → Profit by Item. Each product shows the quantity sold, net sales, COGS, gross profit and margin, with the largest gross profit at the top. Profit by Item is an extra feature. See Profit by Item.

How do I see sales per customer, per category or per sales agent?

In Reports → Profit by Item, choose Group by: Item, Category, Brand, Customer, Sales agent or Sales channel. Charts of sales per category and per sales agent are on the Dashboard too. See Profit by Item.

How do I find notes that made a loss or a thin profit?

Open Reports → Profit by Note, then use the Margin filter: Thin or negative margin with the limit in Thin margin limit, or Negative margin only. Profit by Note is an extra feature. See Profit by Note.

How do I see who bought a certain product?

Open Transaction Details → Sale Lines. Each row is one product on a note. Filter by product and date to see who bought it and at what price. See The goods sold.

How do I see the balances of all cash and bank accounts?

Open Reports → Cash Balance and choose As of. Each cash account shows with its type and its balance at the end of that day, then the total of all of them. See Cash balance and cash flow.

How do I see money in and out of one account?

Open Reports → Cash Book, choose the Cash account and the period. Every money in and out shows with its document and running balance. The Cash Book is an extra feature (the same one as Cash Flow); the same history is also in that account's Cash Book in Master Data. See Cash Book.

How do I see the cash flow statement (operating, investing, financing)?

Open Reports → Cash Flow and choose the period. The report shows the cash and bank balance at the start, the money in and out of operating, investing and financing activities, the net increase or decrease, and the closing balance, which equals the Cash Balance and the Balance Sheet. Cash Flow is an extra feature. See Cash Flow.

How do I see the stock value?

Open Reports → Stock and choose As of. Each product shows with its quantity, cost price and value, then Total stock value. The value is the quantity times the average cost price on that date. See Stock: quantity and value.

How do I print the stock report without cost prices?

Switch off Show cost in Reports → Stock, then press Download PDF or Export to Excel. Cost prices, values and their totals are gone, the quantities stay. The same switch is in Stock Card, Stock Movement Summary and the three cost columns of Negative Stock History. It shows only to holders of Sensitive Reports; everyone else always sees the quantities only. See Printing stock without cost prices.

How do I see goods that were sold before their stock was recorded?

Open Reports → Negative Stock History and choose the period. Each time the stock of an item in a warehouse dropped below zero, the report records when it started, its lowest stock and the document that covered it (for example a purchase), even though the stock looks normal now. Below it are the notes that went out while it was negative. Holders of Sensitive Reports also see the cost used, the estimated covering purchase cost and the difference. See Negative Stock History.

Why is one product's COGS this much?

Open Reports → Cost of Goods Sold Proof and choose the product. It shows every intake with its price and every outgoing at the average cost price at that moment, then compares them with the books. This is an extra feature and only opens for holders of Sensitive Reports. See Cost of Goods Sold Proof.

What is the Balance Sheet?

A snapshot of the shop's finances on one day: Assets (cash, receivables, inventory, fixed assets), Liabilities (payables and loans) and Equity. Total assets always equal total liabilities and equity. Open Reports → Balance Sheet and choose As of. The Balance Sheet is an extra feature and only for holders of Sensitive Reports. See Reading the Balance Sheet.

What are Financial Ratios?

A few short figures from Profit & Loss and the Balance Sheet: gross and net profit margin, stock turnover and days of stock, days to collect receivables and to pay debts, and the current and quick ratio. Open Reports → Financial Ratios, choose a period and, if you like, Compare with. Each ratio has a line on how to read it. The report is only for holders of Sensitive Reports and switches on with the Balance Sheet feature. See Reading Financial Ratios.

The Balance Sheet says it does not balance. What now?

Below the report it says Balanced when both sides are equal. When it says it does not balance, with the difference, contact the Vende team through a support ticket. See Both sides must match.

How do I see receivables or payables per party on a past date?

The Receivables and Payables reports only show today's position. For another date, open Reports → Balance Sheet, choose the date, then switch on Breakdown by party. Receivables, payables and advances open up per customer, supplier or category. See Breakdown by party.

How do I compare this month with last month?

In Reports → Profit & Loss, switch on Compare with the previous period. The previous period shows beside it, for example October next to September. See Reading Profit & Loss.

How do I see reports for one branch or every branch?

Reports follow the branch choice at the top of the screen. Choose one branch, or All branches for the whole shop. The line above the report always names the branch and the period being read. See Choosing a branch.

How do I download a report as PDF or Excel?

Set the branch, dates and filters, then press Download PDF or Export to Excel. The PDF is A4 and holds every row. Export to Excel is there when the extra Excel export feature is on. See Downloading reports and lists to Excel or PDF.

The message "This report is too large to show here" appears. What now?

That report covers a great deal of data. Press Download PDF or Export to Excel: the file is prepared in the background and its link is sent to the bell. To see it on screen, narrow the period, warehouse or other filters. See Very large reports.

The message "Costs are being recalculated" appears. What does it mean?

A stock document has just changed, so product costs are being worked out again. Meanwhile the cost, inventory and profit figures are still provisional. Vende does it by itself, usually within a few minutes, and whoever changed the document is told through the bell. See If "Costs are being recalculated" appears.

My accountant wants the journals and the chart of accounts. How?

The backup file from Settings → Backup holds the Chart of Accounts and Journal sheets. When accounting mode is on, the Reports menu also holds the General Journal, General Ledger, Trial Balance and Worksheet for holders of Sensitive Reports. See Accounting reports for accountants.

How do I set a monthly sales target?

Open Settings → Budgets & Targets, choose the month, then fill in the targets in Sales targets for the whole shop, per branch or per sales agent. Progress shows on the Dashboard. Expense budgets per category are filled in on the same page. This is an extra feature. See Expense budgets and sales targets.

Can the sales targets go on the office TV?

Yes. Press Target Board in the Target vs actual per sales agent table on the dashboard, or on Settings → Budgets & Targets. The board opens in a new tab, full screen in large type: the target, actual and percent of every sales agent this month, the shop total, per branch and the working days left. It changes at once when a sale is posted when Reverb is on; without it, it refreshes by itself every 2 minutes. You stay signed in while it is open. See Target Board on the office TV.

Why is there a "(no breakdown)" row in the report?

That row holds what was recorded straight on the parent category, for example salary expenses recorded on Salaries before Salary Andi and Salary Budi were made. The parent's figure is that row plus all its children, so the total does not change. See Nested categories.

Why are the figures in the report indented?

A row's breakdown is written indented, its name and its figure, one step for each level. A total's figure always sits further right than the figures of its breakdown, so they are easy to tell apart. In Excel the figures stay straight in one column. See Indented rows.

An exported list file can no longer be downloaded. Why?

Exported list files are kept for 7 days, then deleted automatically. Export again from the list, then download and keep the file. See Lists to Excel.

Why are Inventory Losses not in the cost of goods sold in Profit & Loss?

Vende's cost of goods sold is the cost of the goods sold. Goods damaged, lost or short at a stocktake show once as Inventory Losses under other charges, and goods found extra at a stocktake once under other income, so nothing is counted twice. For a gross profit that equals the periodic (physical) method's, switch on Stock differences in cost of goods sold in Profit & Loss: both move inside the cost of sales and net profit stays the same. Goods for personal use, used in the shop, samples or free goods, and opening stock stay in their own accounts, so the accountant moves them herself when there are any; each of them has its own line when the Cost of goods sold calculation is switched on. See Stock differences in cost of goods sold and Cost of goods sold calculation.

Still not answered?

Ask us directly. We help until it is clear.

Ask on WhatsApp