QVILLAS INVOICES HELP

Payout or Amount due is number at the bottom:
If negative, they paid us. Enter as debit.
If positive, we need to pay them. Enter as credit.
Contra = bid (usually munorco)

Tax:
Totaal exclusief btw MINUS totaal incl btw = tax.
Enter as debit. Contra = bbvsexpense

Rent payments to Qvillas (Verblijfskosten):
Usually large negative amount with date in the BOEKING column.
Enter as credit. Contra = rental number.

Commission when rent paid to Qvillas (Provisie):
Positive item after rent payment with same date in BOEKING col.
Should be 20% of rent payment. Enter as debit. Contra = rental number.

Commission or excess fees collected on rentals paid to Vrbo/Airbnb:
May be labeled 'Service cost over booking Airbnb/Vrbo'.
May include excess service fees collected.
Can be debit or credit. Contra = rental number.

All remaining items are likely positive amounts and are likely expenses.
Enter total as one debit. Contra = bbvsexpense.

Then expenses should be entered to spreadsheet to make sure no out of line or double charges.