Unwinding debtors into future period

Options
grirvine
grirvine Member, ALL USERS Posts: 3 New Contributor
in Planning & Modeling

Hi,

 

I have a line item with the balance for each invoice which is a list at the end of the month 

 

I have another line item for the predicted timeperiod that cash is expected 

 

I want to forecast cash received based of only the current months closing position. 

regards 

Tagged:

Comments

  • grirvine
    grirvine Member, ALL USERS Posts: 3 New Contributor

    Sorry my list includes invoices 

     

    The module has time, time isn’t the parent of the invoices


    so for example the time selected is Jan 21 


    All 5 invoices have the balances as below 

     

    so in a new module with time in the module I want to display 

     

    mar 21 $34

    apr 21 $50

    jun 21 $100

     

    balance(sum: expected period) 


    however say the period is now mar 21 and 

    invoice 5 still hasn’t been received so it’s now expected in Apr 21 

    any time period previous to mar 21 would be actuals received and I want to forecast the upcoming months receivables  

    apr 21 being the now being $84 invoice 4 and invoice 5

     

    thanks you for your reply 

  • grirvine
    grirvine Member, ALL USERS Posts: 3 New Contributor
    Thank you for your responses

    Yes the POST worked well To solve my issue

    Thanks again

Categories