Use the Cash Projection report and in the launch screen for that report, use the field 'Calculate Payments As Of', filling in the date you want to see payments as of.

For instructions on how to use the report, please click here.