Spreadsheet: 751163d1633943598-excel-formula-to-calculate-expired-date-prepayment-adjustment
Sheet: Sheet3

 |  |  |  |  | Date | 2021-08-31 00:00:00
PREPAYMENT SCHEDULE - 1 Year
Group | Invoice Date | Ist Month of Adjustment | Account Code | Month of Adjustment | Invoice No. | Purchase Order No. | [NAME] | [NAME] |  |  |  |  | GST | Total (S) | Last Prepayment Adjustment Month |  |  | Monthly Adjustment | Last Adjustment Amount
1 | 2021-08-27 00:00:00 | 2021-09-01 00:00:00 |  | 3 | 21921 |  |  | Quarterly Maintenance |  | 160 | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
End of Asset Items
Total