This problem occurs when the same template file is used for exporting data repeatedly, overwriting the existing information every time. Since CST value is not captured for interstate sales when data is exported to same template repeatedly, the total CST payable is not calculated.
To resolve this issue, use a fresh copy of Form 3B excel template to export data in order to avoid deletion of cell-level formula in the excel template.