Red Color indicates the Collection amount and Green color indicates the uncollected amount.
First of all, cell no B7, no shop monthly pays 1200 tk. So, there is no unpaid amount available in January-May. However, in month of June, I collected 1000 tk. instead of 1200. So, there was remaining 200 tk. Every work is automatically done by Ms.Excel.