This guide explains how to retrieve and interpret the sales reports from the system.
Sales Summary
The Sales Summary gathers sales from all system sales channels (invoicing, online store, POS) onto a single report. The report includes the product name, quantity sold, net amount, gross amount, and accounting account. Additionally, it allows for searching sales by specific product, tag, or sales on a specific accounting account and cost center.
The report does not include payment methods, making it suitable for monthly or yearly sales monitoring by company management. It can also be used to track sales for a specific day. The sales quantities presented in the Sales Summary for each sales channel can be reconciled with reports from their own sales channels. The Sales Summary includes its own usage instructions.
The Sales Summary can be accessed by following the following path:
→ Sales
→ Sales
→ Reports
→ Sales Summary
Sales Summary - Online Shop
Online store sales are presented first in the Sales Summary.
Online store sales are retrieved from the report based on the payment date because online store and POS sales are accounted for on a cash basis in the system.
In the example below, online store sales for October 24, 2023, are retrieved.
Sales Summary - Cash register
Point of sale (POS) sales are presented second in the Sales Summary.
POS sales are retrieved from the report based on the payment date because online store and POS sales are accounted for on a cash basis in the system.
In the example below, POS sales for October 25, 2023, are retrieved.
Sales Summary - Invoices
Invoicing sales are presented third in the Sales Summary.
Invoicing sales are retrieved from the report based on the sales date because invoicing sales are accounted for on an accrual basis in the system at the time of invoice issuance.
In the example below, invoicing sales for October 26, 2023, are retrieved.
Sales Reports by Sales Channel
Sales reports by sales channel include:
- Online Store Sales Report
- Point of Sale (POS) Sales Report
- Recurring Card Charges Report
- Recurring Charges Report
- Invoicing Report
- Payments Report
Sales reports by sales channel can be utilized for more detailed sales analysis. The figures presented in the reports reflect the sales directed to accounting. The reports include details such as received payment methods and tax rate summaries. We recommend using sales channel-specific reports, for example, to export data to an external accounting system. Each report includes its own usage instructions.
Online Shop Sales Report
The Online Store Sales Report gathers online store and appointment sales from the system on a cash basis. The report provides several summaries:
- Summary by Payment Method
- Payment methods received through the online store.
- Payment methods received for online store and appointment orders through the point of sale (paid at the POS).
- Summary by Tax Category
- Summary by Accounting Accounts
- In this summary, there is also a tax rate summary by accounting account.
- Summary by Cost Centers
- In this summary, there is also a tax rate summary by cost center.
- Summary by Products
- Summary of payments made at the cash register (order payments) - by Accounting Accounts
- Summary of payments made at the cash register (order payments) - by Products.
- The report includes a separate description explaining what this mean.
The Online Store Sales Report can be found by following this path:
→ Sales
→ Sales
→ Reports
→ Online Store Sales Report
To retrieve online store and appointment sales, you set a time period for the sales you want to retrieve.
In the example below, online store and appointment sales for October 2023 are retrieved.
Points to Note Regarding the Online Store Sales Report!
Since the "Order Payments" displayed on the POS sales report have been broken down on the online store sales report, these transactions can be found on this report. The breakdown of these transactions can be found at the bottom of the report. However, in the total sales figures of the report, such as "Summary by Tax Category", "Summary by Accounting Accounts", and "Summary by Products", these have already been accounted for. Therefore, there is no need to add the sales of "order payments" to the total sales figures.
If you export sales to an external accounting system, we recommend recording sales from different reports as part of the same entity. This is because of the way payment methods are presented.
The Online Store Sales Report displays sales from online store and appointment transactions paid at the POS, along with payment methods. You can identify these payment methods from the text: "(paid at the POS)". The same payment methods are also visible on the POS sales report. Therefore, this should be considered when recording sales and payment methods in the external accounting system.
Cash register sales report
The Point of Sale (POS) Sales Report gathers system sales made at the point of sale, along with the amounts paid at the POS for invoices and online store and appointment transactions.
The report provides several summaries:
- Summary by Payment Method
- Payment Methods Received at the Point of Sale.
- Payment Methods Received for Online Store and Appointment Orders at the Point of Sale.
- Summary by Tax Category
- Summary by Accounting Accounts
- In this summary, there is also a tax rate summary by accounting account.
- Summary by Cost Centers
- In this summary, there is also a tax rate summary by cost center.
- Summary of Invoice/Order Payments
- Total Amount of Invoices as well as Online Store and Appointment Transactions Paid at the Point of Sale.
- Summary by Products
- Summary by Points of Sale
Point of Sale (POS) Sales Report can be found by following this path:
→ Sales
→ Sales
→ Reports
→ Cash register sales report
On the Point of Sale (POS) Sales Report, you set a time period for the sales you want to retrieve.
In the example below, point of sale (POS) sales for October 2023 are retrieved.
Points to Note Regarding the Cash register sales report
Cash register sales report includes "order payments," which are transactions with a 0% VAT rate. These are transactions related to payments for online store purchases and appointments. While the sales from these transactions are reflected in the online store sales report, the payments are received at the POS. Therefore, "order payment" transactions are shown as 0% VAT on the POS sales report.
Similarly, the report also includes "invoice payments." Sales invoices are invoiced from the system, and the sales from these invoices are reflected in the invoicing report. However, the payments for these invoices are received at the POS. Therefore, "invoice payments" are also 0% VAT transactions on the POS sales report.
When reconciling POS sales, such as in the sales summary or exporting to an external accounting system, it's necessary to deduct the "order payments" and "invoice payments" from the POS sales. You can find the total of these payments under "summary of invoice/order payments," and under "summary by products," you'll find their individual amounts by product (invoice payment and order payment). This way, you get the accurate amount of POS sales.
Cash register sales report includes all payment methods received at the POS. Therefore, the report also includes lump sum payment methods used for paying invoices (invoice payment) and online store and appointment transactions (order payment). This should be considered, especially if payment methods are exported to an external accounting system, as order payment methods are visible in the online store sales report and invoice payment methods in the payments report.
Recurring Charges Report
The Recurring Charges Report gathers the sales from recurring credit card charges made in the system.
The report provides several summaries:
- Summary by Payment Method
- Payments Received via VismaPay
- Payments Received at the Point of Sale for Recurring Credit Card Charges (Paid at the POS)
- Summary by Tax Category
- Summary by Accounting Accounts
- In this summary, there is also a tax rate summary by accounting account.
- Summary by Cost Centers
- In this summary, there is also a tax rate summary by cost center.
- Summary by Products
- Summary of Payments Made at the Point of Sale (Order Payments) - by Accounting Accounts
- Summary of Payments Made at the Point of Sale (Order Payments) - by Products
- The report includes a separate description explaining what these mean.
You can find the Recurring Charges Report by following this path:
→ Sales
→ Sales
→ Reports
→ Recurring Charges Report
In the Recurring Charges Report, you set the period for which you want to retrieve sales.
In the example provided, recurring charges for the year 2023 have been retrieved.
Invoicing Report
The Invoicing Report gathers all invoiced sales made in the system.
The report presents invoices, reminder fees, and credits based on their dispatch dates. Additionally, the report includes the following summaries:
- Accounting Summary
- Tax Summary
You can find the Invoicing Report by following this path:
→ Financial Management
→ Sales Invoices
→ Invoicing Report
In the invoicing report, set the time period for which you want to retrieve sales. Additionally, you can search the report for invoicing sales by specific product, cost center, or ledger account.
Report of Receipts
The receipts report displays all payment receipts that have been recorded for invoices: reference payments, credits, and payments recorded through the cash register (invoice payment on the cash sales report).
The report also includes an accounting summary of payment receipts. To maximize the benefit of this summary, cash payment methods should be directed to their respective accounts receivable.
Additionally, the report can be used to search for payments received with reference data that have not been allocated to invoices (orphan receipts).
You can find the receipts report by following this path:
→ Financial Administration
→ Sales Invoices
→ Transactions
The payments on the report are set by specifying a time period in the date field to retrieve the payments desired. Additionally, by modifying other fields, various information can be sought from the report.
Furthermore, all payments must be selected to be displayed below the listing under "Show - All."
Different search options for payments:
- Write "Invoice" in the "Invoice" -column.
- This way, all payments associated with invoices are obtained.
- In the "Invoice" column, write "No invoice".
- This way, you get orphaned reference payments that have not been allocated to invoices.
- Select your account number in the IBAN column.
- This way you get all reference payments.
- Let's write in the comment column “payment in from cash register.”
- This way, all payments made to invoices via the cash register are obtained.
- These amounts also appear as lump sums on the cash sales report (invoice payment), so this should be taken into account if sales are exported to an external accounting system.
- This way, all payments made to invoices via the cash register are obtained.
- Write "Invoice" in the "Invoice" -column and select your account number in the IBAN -column.
- This way, you will get all the reference payments that have been allocated to invoices.
When exporting sales to an external accounting system, it would be beneficial to export these as a single entity, for example:
The invoicing sales of the company provided:
- The invoicing report shows 51,059.62 € (including VAT information).
The online shop and appointment sales, as well as cash register sales, for the given company:
- Online shop sales report: 3,516.00 € (VAT details in the report)
- Cash register sales report: 10,659.73 € (VAT details in the report)
- Order fees: -1,575.00 € (0% VAT)
- Invoice payments: -3,328.00 € (0% VAT)
- Total: 9,272.73 €