v | A | B | C | D | E | F |
1 | Opening Balance | Date | Invoice | Date Due | Payment | Balance |
2 | 100000 | 4/1/2020 | 10000 | 90000 | ||
3 | 4/2/2020 | 20000 | 4/7/2020 | 110000 | ||
4 | 4/3/2020 | 20000 | 90000 | |||
5 | 4/4/2020 | 40000 | 4/9/2020 | 130000 | ||
6 | 4/8/2020 | 20000 | 110000 | |||
7 | 4/10/2020 | 40000 | 70000 |
v | A | B | C | D | E | F |
1 | Opening Balance | Date | Invoice | Date Due | Payment | Balance |
2 | 100000 | 43922 | =IF(C2<>"",B2 +5,"") | 10000 | =A2+C2-E2 | |
3 | 43923 | 20000 | =IF(C3<>"",B3 +5,"") | =F2+C3-E3 | ||
4 | 43924 | 20000 | =F3+C4-E4 | |||
5 | 43925 | 40000 | =B5+5 | =F4+C5-E5 | ||
6 | 43929 | 20000 | =F5+C6-E6 | |||
7 | 43931 | 40000 | =F6+C7-E7 |