How to calculate the VAT according to debits?

You must do your monthly VAT return. Your company does its VAT return according to debits. From the moment when you generated an invoice relating to a sale (whether already paid or pending), you must declare the amount of collected VAT. This article details how to calculate it from the application. 

STEP 1: FROM THE MANAGEMENT EXPORTS, GET THE INVOICES AND CREDIT NOTES EXPORT FOR A PERIOD

From the Management menu > Management exports, select the invoices and credit notes export in the drop-down menu. Then, provide the selected time period: for example from the 1st October 2021 to the 31st October 2020. Also provide the legal entity and the club in question, then confirm. 

From the “All exports” tab, click on the download arrow corresponding to the export you need. 

The zip file is downloaded on your browser. You just have to click on it to access CSV files (Excel compatible files). 

STEP 2: GO TO THE VAT AMOUNTS OF THE INVOICES AND CREDIT NOTES LINES

Double-click on the file called “export n°xxx DetailsLinesInvoices&CreditNotes.csv”. 

Once opened with Excel, please calculate the sum in the column “VAT amount for the invoices or credit notes”. VAT from invoices is indicated as positive numbers and VAT from credit notes are indicated as negative numbers. The sum from this column of the chart will indicate the VAT amount for the current month (indicated with the time filter when generating the export). 

The formula to apply (by adapting cells to the issued export) is: =SUM (R2: R44) for example. 

Once this formula is applied, you’ll find the indicated amount on the Dashboard for the current month. In the same fashion as the two columns following the all including taxes amount, you may find the VAT amount as well as the revenue excluding all taxes.