When we include the Next Payment amount column in a custom report, the column should show the the amount of money due upon the date of the next payment. However, in the event that a Pledge is in arrears, the column shows the amount in arrears from the last payment.
Instead of using the Next Payment Amount column, we can reference the Arrears Plus Current Payment and Arrears amount to identify the next scheduled payment amount. We exported the data to Excel so we can use the formula for Arrears Plus Current Payment Amount - Arrears Amount to find the next scheduled payment amount. We can also use the Installment Amount column to show what the next payment will be but this will open appear for pledges with a standard schedule.