# Questions about reports

Section: Questions and answers. Address: https://vende.id/docs/tanya-jawab/laporan?lang=en

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.

## 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](https://vende.id/docs/laporan/laba-rugi?lang=en).

## 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](https://vende.id/docs/laporan/laporan-penjualan?lang=en).

## 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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#dashboard-todays-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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#dashboard-todays-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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#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](https://vende.id/docs/laporan/laporan-penjualan?lang=en#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](https://vende.id/docs/laporan/saldo-kas-dan-arus-kas?lang=en).

## 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](https://vende.id/docs/laporan/saldo-kas-dan-arus-kas?lang=en#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](https://vende.id/docs/laporan/saldo-kas-dan-arus-kas?lang=en#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](https://vende.id/docs/laporan/laporan-stok?lang=en#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](https://vende.id/docs/laporan/laporan-stok?lang=en#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](https://vende.id/docs/laporan/laporan-stok?lang=en#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](https://vende.id/docs/laporan/laporan-stok?lang=en#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](https://vende.id/docs/laporan/neraca?lang=en).

## 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](https://vende.id/docs/laporan/rasio-keuangan?lang=en).

## 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](https://vende.id/docs/laporan/neraca?lang=en#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](https://vende.id/docs/laporan/neraca?lang=en#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](https://vende.id/docs/laporan/laba-rugi?lang=en).

## 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](https://vende.id/docs/laporan/cara-membaca-laporan?lang=en#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](https://vende.id/docs/laporan/ekspor-excel-dan-pdf?lang=en).

## 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](https://vende.id/docs/laporan/ekspor-excel-dan-pdf?lang=en#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](https://vende.id/docs/laporan/cara-membaca-laporan?lang=en#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](https://vende.id/docs/laporan/laporan-akuntansi?lang=en).

## 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](https://vende.id/docs/laporan/anggaran-dan-target?lang=en).

## 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](https://vende.id/docs/laporan/anggaran-dan-target?lang=en#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](https://vende.id/docs/laporan/laba-rugi?lang=en#categories-under-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](https://vende.id/docs/laporan/cara-membaca-laporan?lang=en#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](https://vende.id/docs/laporan/ekspor-excel-dan-pdf?lang=en#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](https://vende.id/docs/laporan/laba-rugi?lang=en#stock-differences-in-cost-of-goods-sold) and [Cost of goods sold calculation](https://vende.id/docs/laporan/laba-rugi?lang=en#cost-of-goods-sold-calculation).
