Hello community!
I am working in a non profit and I am trying to figure out the best way to track my budget. The issue is that I have income from multiple donors, all of which will give funds for specific expenses. This means that a donor might cover a percentage of my yearly expense. I also use a "transactions" sheet wherein i input all of the financial transactions. My questions is if I am about to pay an expense (for example rent) that is in total 1000euro and 200euro is covered by donor A and 800euro is covered by donor B is there a way to:
1. input one transaction line that splits the total cost according to the allocation mentioned above?
2. at the end of the year I will have to provide all my donors with reports that show the transactions above and they need all this information: total amount paid, total amount covered by donor, line by line transactions relevant to this donor?
I am not sure if this information is enough, in my head it is but if feel free to ask clarifying questions 🙂
thank you!!!