Got it! I can use days, this gets a bit more tricky though, I need to know exact date when my payment got applied in each month I assume, because before the payment date I'll need to use previous balance of the month for each day and after payment date I'll use new balance for the remaining days of the month.
