Cairos
Invoicing
Invoicing softwareQuotesRecurring invoicesExpenses and suppliersReceipts and cash flow
Accounting and tax
AccountingAEAT tax formsRecord booksFixed assetsIGIC and the Canary Islands
Operations
Inventory and warehousesCRMTime trackingProjectsGrants and funding
Compliance
VeriFactuTicketBAIElectronic invoicingAll the regulationsSecurity and data
By type of business
Self-employedSmall businessesAccountants and tax advisersForeigners in SpainStartupsRetail and shops
By sector
Hospitality and restaurantsConstruction and renovationProfessional servicesE-commerceAll sectors
By legal structure
AssociationsFoundationsCooperativesSports clubsAll legal structures
Switching software
ComparisonsAn alternative to HoldedMigrating your data
Free tools
Invoice templateVAT calculatorIRPF calculatorAll the tools
Learn
GuidesGlossaryTax calendarBlog
Developers
API and documentationGet started in five minutesResource referenceWebhooks
Help
Help centreContact
Pricing
Start for free Log in
Glossary · VAT

Prorrata: the share of input VAT you can deduct

It appears as soon as part of what you invoice is exempt: training, healthcare, an association's activities. And it is adjusted in the last quarter, which is when almost nobody remembers.

With the rule citedWith a worked exampleNo fluff
In one sentence

The percentage of your input VAT you can deduct when your activity combines transactions carrying a right to deduct with exempt transactions.

VAT · Cairos glossary

Articles 102 to 106 of the VAT Act govern it. The idea is simple: if only part of your turnover carries VAT, only part of the VAT you bear is deductible.

How the general prorrata is worked out

Article 104: you divide the value of the transactions carrying a right to deduct by the total transactions of the year, multiply by a hundred and round the result up to the next whole number. 24.1% is 25%.

During the year you apply a provisional percentage — normally the previous year's final one — and on the last self-assessment of the year you work out the final one and adjust the deductions of the three previous quarters (article 105).

An example with numbers

A language school invoices €90,000 of regulated training over the year, exempt under article 20.One.9, and €30,000 of teaching materials at 21%:

  • Prorrata: 30,000 ÷ 120,000 = 25%
  • Input VAT for the year: €8,000
  • Deductible: €2,000. The other €6,000 is cost.

If last year's prorrata was 40%, over the first three quarters 40 of every 100 euros borne will have been deducted. In the fourth quarter the difference has to be paid back.

When the general prorrata is too harsh, there is the alternative of the special prorrata. And when what you buy is durable, the rules on capital goods come in on top.

The mistake that comes up most

Not adjusting it in the last quarter. It is the most expensive oversight in this glossary: a provisional percentage is applied all year and the year is closed without adjusting it, so the year's deduction is wrong and form 390 gives it away.

Where this carries on in Cairos: Working out the 303 with a prorrata.

This, handled without thinking about it

Cairos keeps the invoices, the record books and Hacienda's forms from the same data, so the theory on this page turns into boxes that are already filled in.

No card and no minimum term.

Support