Extraexpense

ExtraExpense allows you to enter expense reports without having to select a fixed VAT rate. We select the VAT rate at 0% and it becomes possible to enter both the pre-tax and post-tax amount and thus determine the VAT by subtraction. This allows you to enter, for example, restaurant bills containing multiple VAT rates or an invoice from another country.

Configuration

In the module settings you will have the option to choose several operating modes:

Basic Function

Disable: The module is not active; VAT management for expense reports works by default. Enabled - if VAT is set to zero: The module is active and allows entry of the total (including tax) and pre-tax (excluding tax) amounts if the VAT rate is zero. Enabled - VAT is set to zero by default: Same as above, but the VAT rate is pre-selected. Enabled - without VAT entry: The VAT selection is removed, and entry of both total (including tax) and pre-tax amounts is mandatory.

Usage and Features

When creating or editing an expense report (via the expense report management form), the VAT rate management is automatically handled to avoid any calculation errors.

Basic Functioning

VAT Rate Management: When you change the VAT rate of a line, an internal mechanism disables keyboard events on the price fields to prevent the simultaneous entry of the Excluding VAT and Including VAT values.

This ensures the consistency of calculations and avoids input errors.

Concrete example: If you change the VAT rate of a line (for example from 0% to 20% or other), the Price excl. VAT and Price incl. VAT fields will be automatically linked.

One of the two fields will be disabled to prevent double entry.

Basic function

If VAT = 20% and the Price excluding tax = €100, you will not be able to fill in the Price including tax field. The Price including tax field will be automatically calculated when the line is validated.

Basic function

If VAT = 10% and the Price including VAT = €220, you will not be able to fill in the Excluding VAT field. The Excluding VAT field will be automatically calculated when the line is validated.

ExtraExpense Features

With the ExtraExpense module, when the VAT rate = 0%, you can still enter a price in Excluding VAT and in Including VAT, without one of the two fields being blocked when the other is filled in.

Example :

Function with ExtraExpense Fichier:ExtraExpense function with extraexpense.png

If VAT = 0% and the Price excluding tax = €50, you can also enter a different amount in the Including tax field. The VAT amount is determined by the difference between the two amounts (here €30, which corresponds to a VAT rate of 60%).

Validité de la ligne

Prise en compte de la ligne ExtraExpense Calcul du Montant de la TVA 20 + 20 + 30 = 70

En suivant les notes de frais créées précédemment, nous obtenons les éléments suivants : TVA à 20 % pour un montant HT de 100 €, soit un total TTC de 120 € et une TVA de 20€ TVA à 10 % pour un montant HT de 200 €, soit un total TTC de 220 € et une TVA de 20€ TVA à 0 % pour un montant HT de 50 €, et un TTC de 80 € soit une TVA de 80-50 = 30€ Nous avons alors un montant de TVA de : 20 + 20 + 30 = 70€ comme affiché sur le total.