You miss my point. What you are referring to is a balance of payments issue, not a revenue issue. Unless the consumers of imported goods in the northern, mid-south and border states had suddenly stopped consuming. Or you have some evidence that indicates a vastly disproportionate amount of tariffed goods were consumed in the Deep South.
Trade with Europe was in goods and specie, not balance of trade credit.
Imports were being financed with the sale of Southern exports, and without Southern goods to underwrite the process, and Southern consumers to pay for the import tariffs, the government of the US either had to find a new source of revenue or attack Charleston.