I am trying to put a filter on Payment received column ‘Y/N’ and I am extracting all the N’s in the excel.

If I apply column filter for ‘N’ it will create a empty table (that means i do not have any default) - when extracting this in excel I need the empty table to say “100%” compliance on the excel sheet

You can use Empty Table Switch Node
Sends input data to first output if and only if it is not empty. If there are no rows in the input data the second output is activated (with the empty input table).

You will have to use different excel writers for different situations.
I don’t know what exactly you want to do. So can you explain a little more. perhaps upload your workflow.