Invoice Calculation Process

1

Determine Venue's Money

Calculate the venue's share by excluding service fees charged to the customer from the total order value.

Example Order:

• Subtotal (food and drinks): €15.49

• Delivery fee: €4.00

• Discount: -€1.00

• Service fee (charged to customer): €0.50

• Total paid by customer: €18.99

• Venue's money: €18.49 (total minus service fee)

2

Calculate Fees

Apply percentage and/or flat fees to the venue's money only.

Example Orders:

• Order #1 — Payment Method: Online

  • Venue's Money: €18.49

  • Online % rate: 5.00% = €0.92

  • Online flat rate: €0.75

  • Gross Fee: €1.67

• Order #2 — Payment Method: Online

  • Venue's Money: €11.35

  • Online % rate: 5.00% = €0.57

  • Online flat rate: €0.75

  • Gross Fee: €1.32

• Order #3 — Payment Method: Cash

  • Venue's Money: €16.89

  • Cash % rate: 1.00% = €0.17

  • Cash flat rate: €0.50

  • Gross Fee: €0.67

3

Apply VAT on Fees

Apply VAT on the service fees.

VAT rate can vary by location.

Example Orders:

23% VAT is used on the examples.

• Order #1

  • Gross Fee: €1.67

  • VAT: €0.39

• Order #2

  • Gross Fee: €1.32

  • VAT: €0.15

• Order #3

  • Gross Fee: €0.67

  • VAT: €0.15

4

Final Settlement

• Total Sales: All online order revenue

• Less cash sales: Deduct cash orders (venue retains this money)

• Less service fees

  • Service fees charged to customers

  • Services fees on card transactions

  • Service fees on cash transactions

• Less VAT on fees charged to venue

• Equals Net Payout: Final amount to be paid to venue

Service fees charged to customers	€1.50
Gross Fees	€3.66
VAT on Fees	€0.84
Total Invoice Amount	€6.00

Total Sales	€48.23
Less cash sales	€17.39
Less invoice amount	€6.00
Net Payout	€24.84

Sample Invoice Calculation

Service Fee
Online % rate	5.00%
Online flat rate	€0.75
Cash % rate	10.00%
Cash flat rate	€0.50

	Payment Method	Subtotal	Delivery Fee	Discount	Venues Money	Service Fee	Total	Percentage Fee	Flat Fee	Gross Fee Charged To Venue	VAT	Net Fee Charged To Venue
Order #1	Online	€15.49	€4.00	-€1.00	€18.49	€0.50	€18.99	€0.92	€0.75	€1.67	€0.39	€2.06
Order #2	Online	€11.35	€0.00	€0.00	€11.35	€0.50	€11.85	€0.57	€0.75	€1.32	€0.30	€1.62
Order #3	Cash	€12.89	€4.00	€0.00	€16.89	€0.50	€17.39	€0.17	€0.50	€0.67	€0.15	€0.82
Total		€39.73	€8.00	-€1.00	€46.73	€1.50	€48.23	€1.66	€2.00	€3.66	€0.84	€4.50

Total Sales		€48.23
Less cash sales		€17.39
Service fees	€1.50
Gross Fees	€3.66
VAT on Fees	€0.84
Invoice Amount		€6.00
Net payout		€24.84

9KB

invoice-calculation-sheet.xlsx

Open