This may happen if you have a date in the "Calculate Payments as of" field on the report launch page. Please set up the scheduled report to instead use the option of "Use Today's Date" when doing so. You should see that the results match what you find in the database.

If your scheduled report is still providing incorrect results, please contact support and provide the Article ID for reference to your issue.