{ "kpis": { "tours_completed": 25, "tours_scheduled": 14, "bookings_count": 37, "total_guests": 141, "gross_revenue_ytd": 6572.65, "net_revenue_ytd": 4687.48444, "total_commissions": 1885.16556, "total_tips": 195, "tips_entries": 14, "drinks_units": 58, "drinks_revenue_est": 492.5, "drinks_cost": 186, "marina_total": 10087.505625, "mkt_total": 650.45, "plat_subs_total": 1587, "crew_total": 1020, "fuel_total": 375, "fixed_costs_total": 12324.955625, "operating_profit": 3106.48444, "real_result": -9218.471185, "real_margin": -140.25501411150756 }, "monthly": [ { "year": 2026, "month": 1, "faturacao": 0, "comissoes": 0, "c_operacao": 0, "marina": 521.2509375, "custos_mkt": 0, "plataformas_mensais": 91, "outros": 0, "resultado": -612.2509375, "margem": 0 }, { "year": 2026, "month": 2, "faturacao": 0, "comissoes": 0, "c_operacao": 0, "marina": 521.2509375, "custos_mkt": 0, "plataformas_mensais": 91, "outros": 0, "resultado": -612.2509375, "margem": 0 }, { "year": 2026, "month": 3, "faturacao": 1329.06, "comissoes": 427.32736, "c_operacao": 364, "marina": 521.2509375, "custos_mkt": 253.38, "plataformas_mensais": 91, "outros": 0, "resultado": -327.8982975, "margem": -0.24671444291454112 }, { "year": 2026, "month": 4, "faturacao": 3655.19, "comissoes": 1127.651, "c_operacao": 941, "marina": 521.2509375, "custos_mkt": 152.91, "plataformas_mensais": 146, "outros": 0, "resultado": 766.3780624999998, "margem": 0.2096684611470265 }, { "year": 2026, "month": 5, "faturacao": 2290.4, "comissoes": 510.1872, "c_operacao": 351, "marina": 1160, "custos_mkt": 244.16, "plataformas_mensais": 146, "outros": 0, "resultado": -120.94719999999998, "margem": -0.05280614739783443 }, { "year": 2026, "month": 6, "faturacao": 655, "comissoes": 36, "c_operacao": 30, "marina": 1160, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": -717, "margem": -1.0946564885496184 }, { "year": 2026, "month": 7, "faturacao": 590, "comissoes": 72, "c_operacao": 30, "marina": 1160, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": -818, "margem": -1.3864406779661016 }, { "year": 2026, "month": 8, "faturacao": 120, "comissoes": 36, "c_operacao": 15, "marina": 1160, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": -1237, "margem": -10.308333333333334 }, { "year": 2026, "month": 9, "faturacao": 2016, "comissoes": 65.4, "c_operacao": 60, "marina": 1160, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": 584.5999999999999, "margem": 0.2899801587301587 }, { "year": 2026, "month": 10, "faturacao": 0, "comissoes": 0, "c_operacao": 0, "marina": 1160, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": -1306, "margem": 0 }, { "year": 2026, "month": 11, "faturacao": 0, "comissoes": 0, "c_operacao": 0, "marina": 521.2509375, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": -667.2509375, "margem": 0 }, { "year": 2026, "month": 12, "faturacao": 0, "comissoes": 0, "c_operacao": 0, "marina": 521.2509375, "custos_mkt": 0, "plataformas_mensais": 146, "outros": 0, "resultado": -667.2509375, "margem": 0 } ], "platforms": [ { "platform_id": 1, "platform_name": "Port Sailors (directo)", "platform_kind": "direct", "tours_count": 12, "total_guests": 47, "gross_revenue": 3548, "total_commission": 68.13, "total_partner_fee": 0, "total_bokun_sumup": 10.58, "total_discounts": 0, "net_revenue": 3469.29 }, { "platform_id": 5, "platform_name": "Douro Captain", "platform_kind": "partner", "tours_count": 13, "total_guests": 76, "gross_revenue": 3240.25, "total_commission": 509.5432, "total_partner_fee": 500.60735999999997, "total_bokun_sumup": 0, "total_discounts": 0, "net_revenue": 2230.09944 }, { "platform_id": 2, "platform_name": "GetYourGuide", "platform_kind": "ota", "tours_count": 18, "total_guests": 46, "gross_revenue": 2647, "total_commission": 794.1, "total_partner_fee": 197.7, "total_bokun_sumup": 23.505, "total_discounts": 0, "net_revenue": 1631.695 }, { "platform_id": 8, "platform_name": "Portugal-Journey", "platform_kind": "partner", "tours_count": 1, "total_guests": 2, "gross_revenue": 436, "total_commission": 65.4, "total_partner_fee": 0, "total_bokun_sumup": 0, "total_discounts": 0, "net_revenue": 370.6 }, { "platform_id": 7, "platform_name": "Touch Tours", "platform_kind": "partner", "tours_count": 1, "total_guests": 7, "gross_revenue": 245, "total_commission": 0, "total_partner_fee": 0, "total_bokun_sumup": 0, "total_discounts": 0, "net_revenue": 245 }, { "platform_id": 3, "platform_name": "Viator", "platform_kind": "ota", "tours_count": 2, "total_guests": 5, "gross_revenue": 264, "total_commission": 79.2, "total_partner_fee": 0, "total_bokun_sumup": 0, "total_discounts": 0, "net_revenue": 184.8 }, { "platform_id": 6, "platform_name": "Tullium Boats", "platform_kind": "partner", "tours_count": 2, "total_guests": 4, "gross_revenue": 155.4, "total_commission": 0, "total_partner_fee": 0, "total_bokun_sumup": 0, "total_discounts": 0, "net_revenue": 155.4 }, { "platform_id": 4, "platform_name": "AirBNB Experiences", "platform_kind": "ota", "tours_count": 1, "total_guests": 2, "gross_revenue": 120, "total_commission": 24, "total_partner_fee": 0, "total_bokun_sumup": 1.8, "total_discounts": 0, "net_revenue": 94.2 } ], "types": [ { "id": 1, "name_pt": "Sunset Partilhado", "category": "sunset", "tours_count": 26, "total_guests": 129, "avg_guests": 4.961538461538462, "gross_revenue": 6059.65, "avg_revenue": 233.06346153846152, "operating_profit": 3309.06424, "avg_margin": 0.5460817439951153 }, { "id": 2, "name_pt": "Sunset Privado", "category": "sunset", "tours_count": 7, "total_guests": 40, "avg_guests": 5.714285714285714, "gross_revenue": 3477, "avg_revenue": 496.7142857142857, "operating_profit": 2936.87, "avg_margin": 0.8446563129134311 }, { "id": 5, "name_pt": "Daytime Privado", "category": "daytime", "tours_count": 2, "total_guests": 8, "avg_guests": 4, "gross_revenue": 567, "avg_revenue": 283.5, "operating_profit": 178.67259999999996, "avg_margin": 0.3151192239858906 }, { "id": 4, "name_pt": "Daytime Partilhado", "category": "daytime", "tours_count": 4, "total_guests": 12, "avg_guests": 3, "gross_revenue": 552, "avg_revenue": 138, "operating_profit": 165.4776, "avg_margin": 0.2997782608695652 } ], "topTours": [ { "tour_id": 16, "year": 2026, "tour_number": 16, "date": "2026-04-23", "tour_label": "#16/2026", "service_pt": "Sunset Privado", "service_en": "Sunset Private", "service_category": "sunset", "tour_kind": "private", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 5, "gross_revenue": 450, "total_deductions": 4.88, "net_revenue": 445.12, "crew_cost": 70, "fuel_cost": 15, "drinks_cost": 60, "drinks_revenue": 160, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 25, "year": 2026, "tour_number": 25, "date": "2026-05-16", "tour_label": "#25/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 329, "total_deductions": 0, "net_revenue": 329, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 10, "year": 2026, "tour_number": 10, "date": "2026-04-05", "tour_label": "#10/2026", "service_pt": "Sunset Privado", "service_en": "Sunset Private", "service_category": "sunset", "tour_kind": "private", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 550, "total_deductions": 250.25, "net_revenue": 299.75, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 9, "year": 2026, "tour_number": 9, "date": "2026-04-04", "tour_label": "#9/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 10, "gross_revenue": 361.68, "total_deductions": 78.12288, "net_revenue": 283.55712, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 5, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 4, "year": 2026, "tour_number": 4, "date": "2026-03-27", "tour_label": "#4/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 355.8, "total_deductions": 76.8528, "net_revenue": 278.9472, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 12, "drinks_revenue": 33, "tips_total": 22, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 23, "year": 2026, "tour_number": 23, "date": "2026-05-03", "tour_label": "#23/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 10, "gross_revenue": 354, "total_deductions": 89.6832, "net_revenue": 264.3168, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 5, "year": 2026, "tour_number": 5, "date": "2026-03-28", "tour_label": "#5/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 331.26, "total_deductions": 71.55216, "net_revenue": 259.70784, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 7.5, "drinks_revenue": 19.5, "tips_total": 40, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 17, "year": 2026, "tour_number": 17, "date": "2026-04-25", "tour_label": "#17/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 7, "gross_revenue": 284.59, "total_deductions": 56.92, "net_revenue": 227.66999999999996, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 9, "drinks_revenue": 26, "tips_total": 35, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 22, "year": 2026, "tour_number": 22, "date": "2026-05-02", "tour_label": "#22/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 11, "gross_revenue": 263.4, "total_deductions": 49.44, "net_revenue": 213.96, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 7, "drinks_revenue": 15, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 7, "year": 2026, "tour_number": 7, "date": "2026-04-01", "tour_label": "#7/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 7, "gross_revenue": 390, "total_deductions": 176.42399999999998, "net_revenue": 213.576, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 17.5, "drinks_revenue": 44, "tips_total": 11, "losses": 0, "other_costs": 0, "status": "completed" } ], "drinks": [ { "id": 1, "name": "Porto Tónico", "category": "cocktail", "total_units": 39, "total_revenue": 312, "total_cost": 117, "total_profit": 195 }, { "id": 4, "name": "Copo Vinho Verde", "category": "wine_glass", "total_units": 5, "total_revenue": 25, "total_cost": 7.5, "total_profit": 17.5 }, { "id": 3, "name": "Copo Vinho Branco", "category": "wine_glass", "total_units": 4, "total_revenue": 20, "total_cost": 6, "total_profit": 14 }, { "id": 2, "name": "Cerveja", "category": "beer", "total_units": 3, "total_revenue": 10.5, "total_cost": 4.5, "total_profit": 6 }, { "id": 7, "name": "1/2 Garrafa Verde", "category": "wine_half", "total_units": 2, "total_revenue": 20, "total_cost": 8, "total_profit": 12 }, { "id": 13, "name": "Garrafa Espumante/Champanhe", "category": "wine_sparkling", "total_units": 2, "total_revenue": 60, "total_cost": 24, "total_profit": 36 }, { "id": 8, "name": "1/2 Garrafa Rosé", "category": "wine_half", "total_units": 1, "total_revenue": 15, "total_cost": 5, "total_profit": 10 }, { "id": 10, "name": "Garrafa Verde", "category": "wine_bottle", "total_units": 1, "total_revenue": 15, "total_cost": 7, "total_profit": 8 }, { "id": 11, "name": "Garrafa Rosé", "category": "wine_bottle", "total_units": 1, "total_revenue": 15, "total_cost": 7, "total_profit": 8 } ], "tipsByMonth": [ { "month": 3, "total": 82 }, { "month": 4, "total": 86 }, { "month": 5, "total": 27 } ], "reservations": [ { "id": 26, "tour_number": 26, "date": "2026-05-22", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 2, "gross_revenue": 120, "net_revenue": 84, "payment_status": "pending" }, { "id": 27, "tour_number": 27, "date": "2026-05-23", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 2, "gross_revenue": 120, "net_revenue": 84, "payment_status": "pending" }, { "id": 28, "tour_number": 28, "date": "2026-05-23", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 4, "gross_revenue": 240, "net_revenue": 168, "payment_status": "pending" }, { "id": 29, "tour_number": 29, "date": "2026-05-26", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 2, "gross_revenue": 120, "net_revenue": 84, "payment_status": "pending" }, { "id": 30, "tour_number": 30, "date": "2026-05-30", "platform": "Port Sailors (directo)", "service": "Sunset Privado", "guests": 2, "gross_revenue": 102, "net_revenue": 102, "payment_status": "pending" }, { "id": 31, "tour_number": 31, "date": "2026-06-14", "platform": "Port Sailors (directo)", "service": "Sunset Privado", "guests": 2, "gross_revenue": 535, "net_revenue": 535, "payment_status": "partial" }, { "id": 32, "tour_number": 32, "date": "2026-06-26", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 2, "gross_revenue": 120, "net_revenue": 84, "payment_status": "pending" }, { "id": 33, "tour_number": 33, "date": "2026-07-04", "platform": "Port Sailors (directo)", "service": "Sunset Privado", "guests": 2, "gross_revenue": 350, "net_revenue": 350, "payment_status": "pending" }, { "id": 34, "tour_number": 34, "date": "2026-07-20", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 4, "gross_revenue": 240, "net_revenue": 168, "payment_status": "pending" }, { "id": 35, "tour_number": 35, "date": "2026-08-08", "platform": "GetYourGuide", "service": "Sunset Partilhado", "guests": 2, "gross_revenue": 120, "net_revenue": 84, "payment_status": "pending" }, { "id": 36, "tour_number": 36, "date": "2026-09-13", "platform": "Port Sailors (directo)", "service": "Sunset Privado", "guests": 2, "gross_revenue": 240, "net_revenue": 240, "payment_status": "pending" }, { "id": 39, "tour_number": 39, "date": "2026-09-16", "platform": "Port Sailors (directo)", "service": "Daytime Partilhado", "guests": 2, "gross_revenue": 90, "net_revenue": 90, "payment_status": "pending" }, { "id": 37, "tour_number": 37, "date": "2026-09-18", "platform": "Portugal-Journey", "service": "Sunset Partilhado", "guests": 2, "gross_revenue": 436, "net_revenue": 370.6, "payment_status": "paid" }, { "id": 38, "tour_number": 38, "date": "2026-09-29", "platform": "Port Sailors (directo)", "service": "Sunset Privado", "guests": 18, "gross_revenue": 1250, "net_revenue": 1250, "payment_status": "partial" } ], "recentTours": [ { "tour_id": 25, "year": 2026, "tour_number": 25, "date": "2026-05-16", "tour_label": "#25/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 329, "total_deductions": 0, "net_revenue": 329, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 24, "year": 2026, "tour_number": 24, "date": "2026-05-13", "tour_label": "#24/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 2, "gross_revenue": 120, "total_deductions": 37.8, "net_revenue": 82.2, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 5, "drinks_revenue": 15, "tips_total": 10, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 23, "year": 2026, "tour_number": 23, "date": "2026-05-03", "tour_label": "#23/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 10, "gross_revenue": 354, "total_deductions": 89.6832, "net_revenue": 264.3168, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 22, "year": 2026, "tour_number": 22, "date": "2026-05-02", "tour_label": "#22/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 11, "gross_revenue": 263.4, "total_deductions": 49.44, "net_revenue": 213.96, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 7, "drinks_revenue": 15, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 21, "year": 2026, "tour_number": 21, "date": "2026-05-01", "tour_label": "#21/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 6, "gross_revenue": 330, "total_deductions": 123.024, "net_revenue": 206.97600000000003, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 24, "drinks_revenue": 64, "tips_total": 10, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 20, "year": 2026, "tour_number": 20, "date": "2026-05-01", "tour_label": "#20/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 4, "gross_revenue": 192, "total_deductions": 30.240000000000002, "net_revenue": 161.76, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 7, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 19, "year": 2026, "tour_number": 19, "date": "2026-04-30", "tour_label": "#19/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 2, "gross_revenue": 120, "total_deductions": 25.8, "net_revenue": 94.2, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 20, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 18, "year": 2026, "tour_number": 18, "date": "2026-04-27", "tour_label": "#18/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 2, "gross_revenue": 120, "total_deductions": 37.8, "net_revenue": 82.2, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 17, "year": 2026, "tour_number": 17, "date": "2026-04-25", "tour_label": "#17/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 7, "gross_revenue": 284.59, "total_deductions": 56.92, "net_revenue": 227.66999999999996, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 9, "drinks_revenue": 26, "tips_total": 35, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 16, "year": 2026, "tour_number": 16, "date": "2026-04-23", "tour_label": "#16/2026", "service_pt": "Sunset Privado", "service_en": "Sunset Private", "service_category": "sunset", "tour_kind": "private", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 5, "gross_revenue": 450, "total_deductions": 4.88, "net_revenue": 445.12, "crew_cost": 70, "fuel_cost": 15, "drinks_cost": 60, "drinks_revenue": 160, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 15, "year": 2026, "tour_number": 15, "date": "2026-04-18", "tour_label": "#15/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 6, "gross_revenue": 270, "total_deductions": 100.656, "net_revenue": 169.344, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 19, "drinks_revenue": 50, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 14, "year": 2026, "tour_number": 14, "date": "2026-04-17", "tour_label": "#14/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 3, "gross_revenue": 144, "total_deductions": 43.2, "net_revenue": 100.8, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 12, "drinks_revenue": 30, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 13, "year": 2026, "tour_number": 13, "date": "2026-04-15", "tour_label": "#13/2026", "service_pt": "Daytime Partilhado", "service_en": "Daytime Shared", "service_category": "daytime", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 4, "gross_revenue": 180, "total_deductions": 56.7, "net_revenue": 123.3, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 12, "year": 2026, "tour_number": 12, "date": "2026-04-10", "tour_label": "#12/2026", "service_pt": "Daytime Privado", "service_en": "Daytime Private", "service_category": "daytime", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 6, "gross_revenue": 306, "total_deductions": 132.0642, "net_revenue": 173.93579999999997, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 8.5, "drinks_revenue": 23, "tips_total": 5, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 11, "year": 2026, "tour_number": 11, "date": "2026-04-05", "tour_label": "#11/2026", "service_pt": "Daytime Privado", "service_en": "Daytime Private", "service_category": "daytime", "tour_kind": "private", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 2, "gross_revenue": 261, "total_deductions": 117.76319999999998, "net_revenue": 143.2368, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 10, "year": 2026, "tour_number": 10, "date": "2026-04-05", "tour_label": "#10/2026", "service_pt": "Sunset Privado", "service_en": "Sunset Private", "service_category": "sunset", "tour_kind": "private", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 550, "total_deductions": 250.25, "net_revenue": 299.75, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 9, "year": 2026, "tour_number": 9, "date": "2026-04-04", "tour_label": "#9/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 10, "gross_revenue": 361.68, "total_deductions": 78.12288, "net_revenue": 283.55712, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 5, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 8, "year": 2026, "tour_number": 8, "date": "2026-04-03", "tour_label": "#8/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 6, "gross_revenue": 217.92, "total_deductions": 47.070719999999994, "net_revenue": 170.84928, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 10, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 7, "year": 2026, "tour_number": 7, "date": "2026-04-01", "tour_label": "#7/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 7, "gross_revenue": 390, "total_deductions": 176.42399999999998, "net_revenue": 213.576, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 17.5, "drinks_revenue": 44, "tips_total": 11, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 6, "year": 2026, "tour_number": 6, "date": "2026-03-29", "tour_label": "#6/2026", "service_pt": "Daytime Partilhado", "service_en": "Daytime Shared", "service_category": "daytime", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 2, "gross_revenue": 90, "total_deductions": 40.95, "net_revenue": 49.05, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 4.5, "drinks_revenue": 13, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 5, "year": 2026, "tour_number": 5, "date": "2026-03-28", "tour_label": "#5/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 331.26, "total_deductions": 71.55216, "net_revenue": 259.70784, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 7.5, "drinks_revenue": 19.5, "tips_total": 40, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 4, "year": 2026, "tour_number": 4, "date": "2026-03-27", "tour_label": "#4/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 9, "gross_revenue": 355.8, "total_deductions": 76.8528, "net_revenue": 278.9472, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 12, "drinks_revenue": 33, "tips_total": 22, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 3, "year": 2026, "tour_number": 3, "date": "2026-03-25", "tour_label": "#3/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "OPO BOAT II", "operator": "OPO Boat Tours", "total_guests": 2, "gross_revenue": 120, "total_deductions": 122.8, "net_revenue": -2.8, "crew_cost": 0, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 0, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 2, "year": 2026, "tour_number": 2, "date": "2026-03-17", "tour_label": "#2/2026", "service_pt": "Daytime Partilhado", "service_en": "Daytime Shared", "service_category": "daytime", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 4, "gross_revenue": 192, "total_deductions": 74.3724, "net_revenue": 117.6276, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 10, "losses": 0, "other_costs": 0, "status": "completed" }, { "tour_id": 1, "year": 2026, "tour_number": 1, "date": "2026-03-12", "tour_label": "#1/2026", "service_pt": "Sunset Partilhado", "service_en": "Sunset Shared", "service_category": "sunset", "tour_kind": "shared", "boat": "Azimuth", "operator": "Port Sailors", "total_guests": 4, "gross_revenue": 240, "total_deductions": 40.8, "net_revenue": 199.2, "crew_cost": 50, "fuel_cost": 15, "drinks_cost": 0, "drinks_revenue": 0, "tips_total": 10, "losses": 0, "other_costs": 0, "status": "completed" } ], "generated_at": "2026-05-16T23:46:20.227Z" }