Hi! for the customized column, are you able to make it a calculating one? Make the column a retention and then have it automatically calculate a retention? i.e.

[qty]    [rate]     [total]       [5% retention] [total due for period]

   2      $100       $200                -$10                   $190