How to create the Sales Revenue—Products & Services report
Description
Cause
Resolution

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

  1. Open Reports, Sales Revenue—Products & Services.
  2. 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

     

  3. Optionally, in the Type list, select Stock, Non-Stock, or Service to filter items. Select All to see all types.

  4. Select a category in the Category list to filter items. Select All to see all categories (with categories set up).
  5. 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.

 

Steps to duplicate
Related Solutions