General report information

Viking's reporting process is quite complex because we do something unique. Specifically, we create bookings that include 'courses.' Additionally, it is possible to pay for these bookings partially and/or at a later date.

Therefore, we have no choice but to maintain different types of reports:

1. Revenue Report: This page shows an overview of bookings and revenue in a selected date range. It includes bookings on the basis of booking date and the revenue totals can change retrospectively if more bookings get paid.

2. Reports Export: Allows to export the Revenue Report in a CSV file. It shows all bookings corresponding to the selected date range (and other filters). By default this is ordered on booking date and shows bookings made in the selected date range. But you can also toggle 'payment date' and it will show all bookings that have been paid in the selected date range. 

3.  Transaction Report: This report does not show bookings, but instead it shows a list of every (partial) payment registered in Viking, ordered on payment date. This list usually should be 1-1 with your payment provider. Because of partial payments, there can be more than 1 line per booking. Of course the booking that the payment relates to is displayed, as is the 'first course' date of that booking. This report is typically used for accounting purposes and can also be exported. 

4. Courses Report: This report shows the actual amounts of courses that have been completed over a selected date range. This too has nothing to do with the booking date or the payment date.  

Example: Tom makes a booking today for two courses. He schedules his first lesson for two months from now and pays for it on the first day of the course. He schedules his second lesson for three months from now.

In the Revenue Report, the booking will be included as made today but will remain unpaid for two months. After two months, this booking's amount will shift from the 'unpaid' column into the 'total revenue' column. 

The Reports Export, if you select this month and order on booking date, the booking is visible (as unpaid). If you order on payment date, the booking is not visible for this month as it has not been paid yet.

The first to months, nothing will appear in the Transaction and Courses reports. Two months from now, the payment will appear in the Transaction Report, and the first course will appear in the Courses Report. Three months from now, only the second course will appear in the Courses Report.