Hello
Need help in mapping the debtors collections to the respective month(s) based on the credit period scenario. Pls find attached sample work sheet for ref.
The amounts are to be stored in the respective month when the amount is due. For ex if the credit period is 30 days; the sales amount relating to Apr 2021 will be stored in the collections of May 2021. In the xl sheet, sales is mapped to col E and hence the collection to be mapped to col F (if the credit period is 30 days). Thanks for the help in advance
" If the collection period is 30 days, then the amount collected should get populated from May 2021 onwards " what happens if we are in June or July? When should it start?