Report this item to Etsy

EU VAT Bookkeeping Spreadsheet | Small Business Income Expense Tracker (Digital Download)

NowPrice:$10.66

Original Price: $16.39

Loading

35% off

•

Sale ends in 11:18:02

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

Keep your books and VAT under control in one simple spreadsheet. Log income and expenses, pick a category and VAT rate from dropdowns, and let the formulas do the rest: VAT amounts, monthly and quarterly VAT summaries and a profit & loss dashboard with charts.

Built for EU freelancers, sole traders and small businesses, with Malta's 18% as the default rate and a table of all 27 EU member states' VAT rates.

WHAT'S INCLUDED
- Bookkeeping & VAT Tracker .xlsx: blank version
- The same file with a full year of example data
- Tabs: Instructions, Settings, Categories, Income, Expenses, VAT Summary, P&L Dashboard
- README with Excel and Google Sheets steps
- "Make a copy in Google Sheets" steps (no Excel needed)

FEATURES
- Income and expense logs (500 rows each) with dropdown categories, VAT rates and payment methods
- Automatic VAT and gross amounts (leave the rate blank to use your default)
- Monthly and quarterly output VAT, input VAT and net VAT payable
- P&L dashboard: income, expenses, profit, margin, spend by category, plus 3 charts
- Fiscal-year start of your choice
- Simple formulas only: no macros and no add-ons

WORKS WITH
Microsoft Excel 2016+ (Windows and Mac), Excel for the web, Google Sheets (free) and LibreOffice. In Google Sheets, charts usually convert but may need re-creating; the README shows how.

PLEASE NOTE
- This is a record-keeping tool, NOT tax or accounting advice. VAT rates change. Verify current rates and your obligations with your tax authority or an accountant.
- Reverse charge, OSS and special schemes are not calculated automatically.
- Licence: for your own business records. Reselling or sharing the file is not permitted.

INSTANT DIGITAL DOWNLOAD: no physical item will be shipped. Your files are available from Purchases & Reviews on Etsy once payment is confirmed.

AI disclosure: This design was created by me (the seller). AI tools assisted with parts of the design process and with drafting this listing copy; every file was reviewed, edited and tested by hand.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 13, 2026