Hi everyone,
I am trying to build a small "controlling tool" that is supoosed to help us keeping track of upcoming payment obligations.
Attached, please find an simplified version. The basic idea is that you enter payment obligations as they occur in the input sheet and get an overview of monthly obligations in the output sheet.
Input:
I think, the inputs should be self explanatory: column A - cost category for allocation purposes and budget control, amount - well, amount, payment date - date of the (first) payment, recurring - yes, if it is a recurring payment, no if it is one-time, frequency - in what relation to the payment date the payments will occur, end date - until when the payment is supposed to recur
As you can see, I have put in example data.
Output:
In this sheet, the payments that will happen in the respective month should be "drawn" from the input sheet. I have inserted the resulting values manually, but I am looking for a formula, that would calculate this for me.
Do you have any ideas on how to mange this in the output sheet?
Bonus: if I enter 31st of a month in the input sheet and recurring "monthly", how can I make sure that Excel uses this informatiin with months with 30 days or less?
Thanks in advance, and if you have any questions, please ask.
PS: if there are existing solutions/tools out there, I would also use those :p
Bookmarks