The Sales Revenue—Products & Services report lists items sold in a selected period. It shows item type, quantity sold, net sale amount, cost amount, profit amount, and profit percentage. Formulas for Calculating Profits - Profit amount: Sales price – Cost price
- Profit percentage: (Profit value / Sales price) x 100
Ensuring accurate calculations Enter cost and sales prices for all items before creating invoices or credit notes. Profit amounts are based on prices at the time of invoice or credit note entry. Changing prices later doesn’t affect profit calculations on the report. NOTE: If a non-stock item has a negative cost price, the default sales price is zero. Running the report—why and when? The Sales Revenue—Products & Services report provides insight into revenue from product and service sales. Run it at least monthly to monitor sales revenue. To calculate the report - Open Reports, Sales Revenue—Products & Services.
- From the Period list, select:
Period | Description | This Month | First to last date of the current month | This Quarter | First to last date of the current quarter | This Year | First to last date of the current calendar year | Last Month | First to last date of the previous month | Last Quarter | First to last date of the previous quarter | Last Year | First to last date of the previous calendar year | This Fiscal Year | First to last date of the current fiscal year (if you set the Year End Date) | Last Fiscal Year | First to last date of the previous fiscal year (if you set the Year End Date) | Custom | Enter your own date range | -
Optionally, in the Type list, select Stock, Non-Stock, or Service to filter items. Select All to see all types. - Select a category in the Category list to filter items. Select All to see all categories (with categories set up).
-
Click Calculate. Exporting the report Click Export to save the report as a CSV or PDF file. The report saves to the downloads folder. When exporting to CSV, your browser prompts you to choose a folder. When exporting to PDF, your browser opens the report in a new window for download or printing. |