Sales and financial reports in Timely show your earnings based on invoices raised for your appointments, packages, and product sales. If your reports are not showing any data, you will need to make sure you are raising invoices for your appointments. In this article, you will learn an overview of the sales and financial reports available to you.
Introduction to using the sales and financial reports
For a large majority of the financial reports, you will be able to filter the report based on the date range, location and the staff member. An invoice will be included in a reporting period date range based on the invoice date.
When you raise an invoice, the invoice date will automatically be set to the day the invoice is raised, not the date of the appointment. This will be something to take into account, especially if you accept deposits or take online payments for appointments. You can adjust the invoice date when you raise or edit an invoice, to set this as a past or future date. Just click on the current date and choose the new date from the date picker.
Sales report
The sales report is a summary of the total sales value for your bookings, products and discounts within a selected timeframe. You can view an overall summary of sales, which will include a summary of your total income, including tax collected, for that period. Sales will then be broken down into:
- Sales by staff member
- Sales by location
- Booked service sales
- Walk-in service sales
- Product sales
- Package sales
- Standard discounts
- Promo code discounts
The sales report is based on the value of all invoices raised, which will also include any unpaid invoices. So this is something to take into account when using this report. You can also run the sales report by appointment date, this will help you accurately report on sales where you have received a deposit on an earlier date. The numbers shown in the sales report will be inclusive of any tax, but you will be able to see at the top of the report, a figure that shows you the total amount of tax collected during this period.
Service sales report
The service sales report goes into more depth on your sales split out by service. You can see the total sales for each service sold during that period, as well as tax totals and category splits. Services that were booked in the calendar will be shown under the booked service sales section.
Walk-in or add on services that have been sold directly to the customer on the invoice, without being added to the calendar, will be included in a separate walk-in service sales section. You can also run the service sales report by appointment date.
Product sales report
The product sales report of the total sales value for products sold. This includes their current stock levels, tax totals and splits by product type. The product sales report currently does not report on discounts.
Transaction summary report
The transaction summary report will record the details of any payments received within a specific date range. You might have noticed a different staff selector on this report, which is the processed by field.
When a payment is applied, we will record the staff member who was logged in and applied the payment to the invoice. This means that the staff member who is assigned the original invoice/sale won't automatically be assigned that payment. You can adjust the processed by field to another staff member while applying the payment.
You can create your own payment types, in addition to the default payment types provided. See our help guide How to create your own payment types for more information.
Invoice detail report
This invoice detail report shows a detailed list of all the bookings, products, packages and vouchers that have been included in the sales report for a specific period. This allows you to easily identify what invoices have been raised during this period and attributed to staff.
Unpaid invoices report
The unpaid invoices report allows you to see list of all of your unpaid invoices, with due dates and customer details. You can filter the report on date (sales are included based on the invoice due date) and by location. Once the report has been run, you can sort the results based on any of the column headers e.g. invoice date, due date, first name/last name etc. To view the sale in question, you can click on the invoice number in the left-hand column.
Customer product sales report
The customer product sales report shows what products your customers have been buying, the quantity they have bought of that product and the total value. The report also links to the invoice that the product was sold on.
Stock levels report
The stock levels report shows a list of all your current retail and professional stock levels. You can filter this report by location and by stock type (retail vs professional).
You can see a summary of the products, by location, at the top of the report. You can then sort the report on any column, but ascending or descending order. You will be able to see the cost price per item, as well as the total cost value of sold products. This is great if you need to keep track of the cost price of consignment items.
Timely note: sales and invoice figures are based on the invoice date (the date that the invoice was raised), not the date the appointment/class took place. This is something to bear in mind if you take online payments for bookings. You can amend the Invoice date at any time, as required.
Stock movement report
The stock movement report allows you to track any changes in stock levels within a certain date range. This gives you a list of all your retail products and internal stock, then details their starting level and any Increases or Decreases during that date range.
Deposits report
The deposits report shows you a list of appointments for a given date range, and what deposits have been paid against those appointments, this only reports on our new deposits feature.