Spreadsheet: 774186d1648277665-restart-balance-after-withdrawal-restart-actual-total-sample
Sheet: Sheet1

Comparing running totals with continuing total, "400" in C9 and down to zeroing totals in I11, both create invalid actual totals when the expense is larger than the actual amount. [NAME] used: =SUM(MAX(0,SUM(B8,IFERROR(-E8,0))),A9)
Income | Running Ttl | Actual Ttl | Expense | Withdraw |  |  | Income | Running Ttl | Actual Ttl | Expense | Withdraw
0 | 0 |  |  |  |  |  | 0
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 1000 |  |  |  | 100 |  |  | 1000
100 |  |  |  |  |  |  | 100 |  |  | Expense K6 is bigger than actual total J6  so this is correct to start over in J7 adding H7
 |  |  | We don’t have 400 leftover here
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | Zero is correct here but it should start from 100 again in C15 once the income comes back in A14
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100 |  |  | [NAME] from 100 to 600, J15 should be 200 when income starts again and adds  [NAME]
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 150 |  |  |  | 100 |  |  | 150
100 |  |  |  |  |  |  | 100
100 |  |  | 100 |  |  |  | 100 |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
 |  |  | 1300 |  |  |  |  |  |  | 1300
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 500 |  |  |  | 100 |  |  | 500
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 150 |  |  |  | 100 |  |  | 150
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 1300 |  |  |  | 100 |  |  | 1300
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 500 |  |  |  | 100 |  |  | 500
100 |  |  |  |  |  |  | 100
100 |  |  | 500 |  |  |  | 100 |  |  | 500
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 3000 |  |  |  | 100 |  |  | 3000
100 |  |  | 150 |  |  |  | 100 |  |  | 150
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  |  |  |  |  | 100
100 |  |  | 1300 |  |  |  | 100 |  |  | 1300
 |  |  | 500 |  |  |  |  |  |  | 500
 |  |  | 150 |  |  |  |  |  |  | 150
 |  |  | 100 |  |  |  |  |  |  | 100
 |  |  | 1300 |  |  |  |  |  |  | 1300
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 150 |  |  |  |  |  |  | 150
 |  |  | 2000 |  |  |  |  |  |  | 2000
 |  |  | 4000 |  |  |  |  |  |  | 4000
 |  |  | 2000 |  |  |  |  |  |  | 2000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 150 |  |  |  |  |  |  | 150
 |  |  | 4000 |  |  |  |  |  |  | 4000
 |  |  | 2000 |  |  |  |  |  |  | 2000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 100 |  |  |  |  |  |  | 100
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 4000 |  |  |  |  |  |  | 4000
 |  |  | 500 |  |  |  |  |  |  | 500
 |  |  | 1500 |  |  |  |  |  |  | 1500
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 100 |  |  |  |  |  |  | 100
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 4000 |  |  |  |  |  |  | 4000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 2000 |  |  |  |  |  |  | 2000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 2500 |  |  |  |  |  |  | 2500
 |  |  | 500 |  |  |  |  |  |  | 500
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 100 |  |  |  |  |  |  | 100
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 2000 |  |  |  |  |  |  | 2000
 |  |  | 4000 |  |  |  |  |  |  | 4000
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 2500 |  |  |  |  |  |  | 2500
 |  |  | 1000 |  |  |  |  |  |  | 1000
 |  |  | 2000 |  |  |  |  |  |  | 2000
 |  |  | 1000 |  |  |  |  |  |  | 1000