Hi Folks,

I've run into complications with importing a statement from my bank into Zoho Books. My bank exports their statement using parenthesis for debit transactions. Here's an example of what their CSV format looks like:

"Account","Amount","Balance","Date","Description","Type"
"Free and Clear Checking - x####","($4,524.08)","$5,638.20","01/05/24","Over Counter Check ###","Over Counter Check"
"Free and Clear Checking - x####","$5,667.00","10,162.26","01/05/24","Deposit","Deposit"

If I change the number format in the CSV file to a simple negative number, -4524.08, it will process fine. I'm searching for an easy way to make this change throughout the file, if anyone has any ideas.

Problem #1 is that it seems Zoho software won't recognize the $ sign before the amount, nor will it process the parentheses as negative numbers. Problem #2 is that Google Sheets will convert the numbers into negatives and can remove the $ sign, but exports csv without quotes, for which I also get a processing error.

Anyone have tips for reformatting problematic CSV files?