| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||
2 |  | PriceLabs Expense Tracker | ||||||||||||||
3 | ||||||||||||||||
4 | ||||||||||||||||
5 | ||||||||||||||||
6 | 📌 Note: Please copy the sheet and create your version. There are forumale added to make it easier for you. The numbers added are just for representation. As a host, doing this all by yourself and manually is double the work and takes time away from the actual work you have to do and puts you on a desk cruching numbers rather than optimizing your property for success. With PriceLabs Dynamic Pricing you will be able to price your property dynamically and adjust it according to seasonality, demand patterns, and booking trends. Along with accurate pricing that optimizes revenue and occupancy, you also get robust reporting tools that would help you make data-driven decision regarding your property. Get your subscription now! | |||||||||||||||
7 | ||||||||||||||||
8 | ||||||||||||||||
9 | ||||||||||||||||
10 | ||||||||||||||||
11 | ||||||||||||||||
12 | ||||||||||||||||
13 | ||||||||||||||||
14 | ||||||||||||||||
15 | ||||||||||||||||
16 | Metrics | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | ||
17 | Revenue | 0 | ||||||||||||||
18 | Airbnb | $ 2,000.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 5,400.00 | $ 61,400.00 | ||
19 | Vrbo | $ 2,000.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 350.00 | $ 5,850.00 | ||
20 | Direct booking | $ 500.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 2,540.00 | $ 28,440.00 | ||
21 | <other> | $ 450.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 365.00 | $ 4,465.00 | ||
22 | <other> | $ 2,600.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 2,870.00 | $ 34,170.00 | ||
23 | Total | $ 7,550.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 11,525.00 | $ 134,325.00 | ||
24 | Performance Metrics | 0 | ||||||||||||||
25 | Available Nights | 31 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 306 | ||
26 | Booked Nights | 29 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 216 | ||
27 | Occupancy Rate | 94% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 842% | ||
28 | ADR | $ 150.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 450.00 | $ 5,100.00 | ||
29 | RevPAR | 140 | 306 | 306 | 306 | 306 | 306 | 306 | 306 | 306 | 306 | 306 | 306 | 3506 | ||
30 | Expenses | |||||||||||||||
31 | Electricity | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 540.00 | $ 6,480.00 | ||
32 | Gas | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 136.00 | $ 1,632.00 | ||
33 | Water | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 625.00 | $ 7,500.00 | ||
34 | Internet | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 932.00 | $ 11,184.00 | ||
35 | Maintenance | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 1,200.00 | $ 14,400.00 | ||
36 | Taxes | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 650.00 | $ 7,800.00 | ||
37 | Insurance | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 75.00 | $ 900.00 | ||
38 | HOA | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 25.00 | $ 300.00 | ||
39 | Cleaning | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 2,576.00 | $ 30,912.00 | ||
40 | Supplies | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 1,248.00 | $ 14,976.00 | ||
41 | Towels/Linens | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 13.00 | $ 156.00 | ||
42 | Welcome Gifts | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 11.00 | $ 132.00 | ||
43 | <other> | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 780.00 | ||
44 | <other> | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 655.00 | $ 7,860.00 | ||
45 | Total Expenses | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 8,751.00 | $ 105,012.00 | ||
46 | Net Operating Income | $ (1,201.00) | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 2,774.00 | $ 29,313.00 | ||
47 | Mortgage | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 662.00 | $ 7,944.00 | ||
48 | Cash Flow | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 1,250.00 | $ 15,000.00 | ||
49 | Total Income | $ (3,113.00) | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 862.00 | $ 6,369.00 | ||
50 | ||||||||||||||||