For all those interested in a new and improved version of my Gsheet / Excel Admin sheet, I’ve just updated the available copies on the webpage to v0.81. This version enables you to keep track of partly deductible VAT: whenever you combine exempted activities with taxable activities in one administration, you can deduct only VAT on your general expenses up to the ratio between your taxable revenue and your total revenue. See also the how-to in the sheet itself for a brief explainer or google pro rata btw.