The cost of direct sales
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
DOWNLOAD AS EXCEL OR CREATE A COPY OF THIS FILE TO USE IT (File >> Create a copy)
Comment and share your result in:
2
The cost of direct sales. Part 1: Calculation
3
The cost of my hotel direct sale
in a specific period
HELP

Choose a period and fill in the yellow blanks with the data from that period only.

Taxes: do not mix net and gross amounts.
4
5
INCOME: Amount of direct bookings (figure after cancellations)Income: allocate the amount from bookings RECEIVED (pick-up) during the period -not the one from stays during that period- and subtract cancelled bookings or their estimate.
6
7
8
Do you have PERCENTAGE expenses? Note down the amount of that percentage. For example, if you are paying 2% of 200,000€, the amount is 4,000€.

Do you have a single-payment FIXED COST? Estimate its amortisation period and note down the amount corresponding to the period you are analysing. For example, if you paid 20,000€ and you want to amortise it in three years, analysing one year would mean a cost of 6,666€.
9
EXPENSES: Total amount including branding (If it is fixed, just allocate the part corresponding to that period)% attributable to direct sale:
10
Hotel/chain website: Design, contents, texts, translations...30%€0
11
Hotel/chain app30%€0
12
Booking engine100%€0
13
Support/boosting technologies (Triptease, Flip.to, etc.)100%€0
14
SEO30%€0
15
SEM80%€0
16
Email marketing80%€0
17
Metasearch: Investment in their CPC-CPA programmes100%€0
18
Tripadvisor Business Advantage, Trivago Manager Plus...50%€0
19
Call centre, booking department, chatbots...10%€0
20
Customer loyalty programme50%€0
21
Others€0
22
23
Total expenses:
€0
24
25
RESULT:0,0%
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...