VAT Sales and Purchases Register in Excel in Italian | Monthly and Quarterly Liquidation, F24 Deadlines, Annual VAT Summary

Always know how much VAT you have to pay and when, month by month or quarter by quarter.

WHAT DOES IT DO
• Register of issued invoices: taxable by rate (22, 10, 5, 4% and exempt), VAT and total calculated alone, collected Yes/No
• Register of received invoices: same columns plus the deductible percentage (car 40%, telephone 50%, empty = 100%)
• Settlement by month and by quarter: VAT debit, VAT credit, result, credit carried forward, amount to be paid
• Quarterly: 1% interest and due dates: May 16, August 16, November 16, March 16; monthly: 16th of the following month
• December VAT advance payment deducted from the last settlement and estimate of next year's advance payment (88%)
• Annual summary: turnover, VAT paid, credit at year end, invoices to be collected and paid
• Withholding taxes suffered by professionals and net income for the year

DETAILS
• .xlsx file in Italian, works with Excel, LibreOffice and Google Sheets
• For individual businesses and professionals in the ordinary simplified regime (not flat rate)
• Up to 400 invoices issued and 400 received per year, rates and deadlines 2026 modifiable
• Instructions included, pre-filled example

NOTE
Digital product: no physical items are shipped. This is an indicative calculation tool; it does not replace an accountant or mandatory VAT records. It does not handle cash VAT, reverse charge, pro-rata, or special regimes. Values ​​are effective as of 2026.
Created with the help of AI tools and verified by hand.