Jakob Thank you for your answer Jakob!
I’m gonna try to explain it as clear as possible:
• Calculate the daily stocks for each day of the year;
•Multiply the single daily stocks by the days in which they remained constant;
•Add up the amounts obtained;
• Divide the result by 365 days.
The calculation will be done like this then:
100 days X a daily stock of 1000 euros = 100,000
15 days X a daily stock of 700 euros = 10,500
250 days X a daily stock of 2000 euros = 500,000
Sum of 100,000 + 10,500 + 500,000 = 610,500
Division of 610.500 / 365 = 1673 euro average stock
I know that this may seem complex but it really isn’t, what makes complex is that we use our card very often and this adds up to many calculations that can lead to errors (that agenzia delle entrate really like)
For this reason I created an excel file that will make the procedure a little bit easier but still lengthier than introducing an algorithm doing the work for us.
You can try to play with it, it’s an excel file and the instructions are in Italian but are really simple. Google translate will help, or just tell me if something is quite not clear!
https://docs.google.com/file/d/1Ri7t1Tpt9gBbYAR6oplPkXW9iLBPVtQS/edit?usp=docslist_api&filetype=msexcel
