Learn how to read sales reports
Every month, BookSpot invoices for the previous month's booking value, excluding VAT.
You can find the sales reports and statistics under Reports > Overview in the left-hand menu. There, you can select the time period and download reports. The detailed online report is usually whats needed for book-keeping.
Sales Report shows all sales for a specific month, including VAT rates, payments, and returns, divided into online and offline reports.
Sales Report (detailed)
The sales report is divided into two reports to simplify your accounting - online (all payments made online by customers) and offline (all manually registered payments by admin/staff). Often, it is the "online report" from BookSpot that you need to use as a basis for your accounting of payments via your online payment solution.
Sales Report Tab
This tab provides an overview of all your payments and returns via the payment solution you use for online payments. Here you can see:
All new payments during the period
All returns during the period
Sales divided by VAT rates (considering returns)
Bookings & Value Codes Tab
This tab shows all new bookings and sold value codes during the period, either created by the customer themselves via your website/booking widget, or created by you as admin/staff via the back-office section in BookSpot.
Each row represents a sale of a product or a value code created during the period; a booking can therefore be represented by several rows with different products. If a booking has a rebooking guarantee, this is added as a separate row in the list with 0% VAT according to Skatteverkets regulations.
Tab Sales per Product
In this tab, you’ll find all sales for each product during the period.
Tab Payments
This tab shows all payments registered during the period, along with which booking each payment is associated with (column Order ID).
Tab Returns
In this tab, you’ll see all returns during the period, along with the applicable VAT rates for each return.
Why is the payout lower than sales?
The reason the payout from your online payment provider is slightly lower than your total sales for the period is that the sales reports in BookSpot do not account for the fee charged by your online payment provider per transaction.
The report generated by the payment solution (e.g., Bambora/Worldline or Stripe) can be found by logging into their website.
Accruing Revenue
Under Reports > Overview > Sales per product, it is possible to accrue revenue and group the data based on date or month according to the delivery date.
Under the Delivery Date column, you can see the date on which the booking takes place. This date determines which accounting period the revenue belongs to.
If a product, for example K1 has bookings occurring in August, September and October, the revenue will be split across these months. In the report, you will then see three separate rows one for each month, making it easy to accrue the revenue correctly.
What is the difference between revenue and sales?
Sales: Bookings made and paid for in September appear in the sales report for September. Sales are recorded at the time of purchase – regardless of when the service or booking takes place.
Revenue: The booking is counted as revenue in the month the booking takes place. If a customer books and pays in September but the booking is carried out in October, it becomes revenue only in October.
Accrual Report
Under Reports > Overview > Accruals income, you can get an overview of revenue and bookings during a specific period. It shows what has been booked, delivered, and what is still outstanding for the selected period.
New Bookings
The report shows all new bookings that have been registered and belong to the selected period.Delivered/Recognized bookings
This shows the total of bookings that have been completed and are counted as revenue during the period.Cancellations
The report also provides a summary of any cancellations during the period.Remaining bookings
This amount shows the total booked value for bookings that have not yet been completed during the period. It reflects future revenue that has been booked but not delivered within the selected period.
Adyen as a payment solution?
You can easily download a consolidated report that includes fees, VAT, and payouts for a selected period – all in one single document. Read more about this report here.