# VAT Shareout "Ventilazione"

VAT Shareout ("Ventilazione" in Italy) is a specific VAT calculation tipycal of small business that handles multiple VAT rates.

These business can declare to government that:

- Purchases are well divided per VAT rate
- Sales are made in aggregated form, without applying any VAT rate

To pay the right taxes, these business need to calculate "Ventilazione" that is VAT rate to apply to sales proportionally to purchases.

The calculation is made starting from the 1° january of each years to the end of each VAT period.

## Example

<table border="1" id="bkmrk-month-vat-rate-purch" style="border-collapse: collapse; width: 100%; border-width: 1px;"><colgroup><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col></colgroup><tbody><tr><td>**Month**</td><td>**VAT rate**</td><td>**Purchase amount**</td><td>**Shareout %**</td></tr><tr><td>January</td><td>4 %</td><td>10.000</td><td>16,53 %</td></tr><tr><td>January</td><td>10 %</td><td>33.000</td><td>54,55 %</td></tr><tr><td>January</td><td>22 %</td><td>17.500</td><td>28,92 %</td></tr><tr><td>**Total**</td><td>  
</td><td>**60.500**</td><td>**100 %**</td></tr></tbody></table>

The aggreate sales of January are 97.000 so the VAT to pay is:

<table border="1" id="bkmrk-vat-rate-shareout-%25-" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col></colgroup><tbody><tr><td>**VAT rate**</td><td>**Shareout %**</td><td>**Sales amount (incl. VAT)**</td><td>**VAT amount**</td></tr><tr><td>4 %</td><td>16,53 %</td><td>16.034</td><td>641</td></tr><tr><td>10 %</td><td>54,55 %</td><td>52.914</td><td>5.291</td></tr><tr><td>22 %</td><td>28,92 %</td><td>28.052</td><td>6.171</td></tr><tr><td>**Total**</td><td>**100 %**</td><td>**97.000**</td><td>**12.103**</td></tr></tbody></table>

New purchases of February increase previous totals and generate a new shareout for February sales:

<table border="1" id="bkmrk-month-vat-rate-purch-1" style="border-collapse: collapse; width: 100%; border-width: 1px;"><colgroup><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col><col style="width: 24.9383%;"></col></colgroup><tbody><tr><td>**Month**</td><td>**VAT rate**</td><td>**Purchase amount**</td><td>**Shareout %**</td></tr><tr><td>January + February</td><td>4 %</td><td>22.000</td><td>18,72 %</td></tr><tr><td>January+ February</td><td>10 %</td><td>59.500</td><td>50,64 %</td></tr><tr><td>January + February</td><td>22 %</td><td>36.000</td><td>30,64 %</td></tr><tr><td>**Total**</td><td>  
</td><td>**117.500**</td><td>**100 %**</td></tr></tbody></table>

And so on...

## Setup

In "VAT Posting Setup" table mark interested purchase lines for "base" in the shareout calculation.

[![image.png](https://kb.brayns.it/uploads/images/gallery/2024-07/scaled-1680-/image.png)](https://kb.brayns.it/uploads/images/gallery/2024-07/image.png)

Also mark the sales lines:

- That ones aggregated "to be sharedout"
- That one after calculation "sharedout"

For lines to be sharedout is necessary also to specify the G/L account for reversing the calculated VAT (sales are posted "included VAT" and need to be reducted for the amount of VAT).

[![image.png](https://kb.brayns.it/uploads/images/gallery/2024-07/scaled-1680-/glyimage.png)](https://kb.brayns.it/uploads/images/gallery/2024-07/glyimage.png)

Before VAT settlement, run and post VAT shareout calculation.

[![image.png](https://kb.brayns.it/uploads/images/gallery/2024-07/scaled-1680-/xEVimage.png)](https://kb.brayns.it/uploads/images/gallery/2024-07/xEVimage.png)