Classify cash to be paid and cash to be received in the future according to the length of time.
Establish a two-dimensional table in excel document: the first column is the amount to be paid and the amount to be received next month; The second column is the amount to be paid and the amount to be received in the next 1-3 months; The third column is the amount to be paid and the amount to be received in the next 3-6 months; Analogy in turn
On the line, it should be divided into at least three lines. The first line is the amount to be paid, the second line is the amount to be received, and the third line is the net amount of the received amount MINUS the paid amount, reflecting your capital position at this time period.