Umut Travel Backoffice

Purchases HT8 875 €640 € deductible VAT

Sales HT12 850 €812 € collected VAT

Gross margin3 975 €Before VAT impact

Net margin after VAT3 803 €30 % real rate

Sort by

Rows

Item / supplier

Service date

Qty

Buy HT

Buy VAT

Buy TTC

Sell HT

Sell VAT

Sell TTC

Margin / TVA

Payment

FlightsTOMS

Air Maroc · Flight · MA

05 Jan - 12 Jan

2 pax

1 240 €

—

1 240 €

1 660 €

84 €

1 744 €

420 €TVA margin

100 %

Royal Mansour HotelTOMS

Atlas Group · Hotel · ES

05 Jan - 10 Jan

5 nights

2 380 €

—

2 618 €

3 310 €

186 €

3 496 €

930 €TVA margin

45 %

Superior roomTOMS

Atlas Group · Hotel · ES

Open date

1 room x 5 nights

900 €

—

990 €

1 210 €

62 €

1 272 €

310 €TVA margin

50 %

Deluxe roomTOMS

Atlas Group · Hotel · ES

Open date

2 rooms x 5 nights

1 180 €

—

1 298 €

1 590 €

89 €

1 679 €

410 €TVA margin

40 %

•

City taxStandard

Atlas Group · Tax · ES

Open date

15 nights

95 €

10 €

105 €

195 €

20 €

215 €

100 €TVA 10%

25 %

•

Agency handling feeStandard

Internal · Service Fee · FR

Booking issue

1 fee

0 €

0 €

0 €

180 €

38 €

218 €

180 €TVA 0%

100 %

Atlas Mountains ExcursionTOMS

Morocco Tours · Excursion · MA

07 Jan

2 pax

560 €

—

616 €

930 €

74 €

1 004 €

370 €TVA margin

65 %

Private transfersTOMS

Morocco Transfers · Transport · MA

05 Jan / 10 Jan

4 rides

420 €

—

462 €

690 €

54 €

744 €

270 €TVA margin

0 %

TOMS formula12 850 € sales HT - 8 875 € purchases HT

VAT impact172 €

Net margin3 803 €

VAT recap by rate

Purchases vs sales on one read

RateBuy baseBuy VATSell baseSell VAT

0%2 480 €0 €0 €0 €

5%0 €0 €4 530 €230 €

6%0 €0 €4 900 €275 €

7%0 €0 €370 €27 €

8%0 €0 €2 360 €188 €

10%6 395 €640 €320 €32 €

12%0 €0 €190 €22 €

21%0 €0 €180 €38 €

Cash flow balance

Keep track of supplier advance vs client collection

To pay suppliers2 023 €Unpaid / partial invoices in this dossier

To receive client1 960 €Global file balance still open

Net position31 €Client cash currently covers supplier exposure