Thu 16 Jul, 2020 11:38 am - Thank you for the reply!
the invoice was from 2019
so inv date=6/30/19, first due month is 7/30/19. From 7/30/19 to now 7/15/2020, How to set up the formula for the past months and accrued... (view)
Thu 16 Jul, 2020 10:48 am - I need help on setting this up in excel.
1. All invoices terms = net 30
2.Late payment fee on invoice is 7% of fees due due on each invoice
3.All past due items will accrue interest at 1.5%... (view)