After exporting to excel select an empty column and put this in the first cell Assuming D column has the amounts and E column has the debit/credit
=if(E1=”debit”,-D1,D1)
Then just pull down the box to replicate this formula on the rest of the rows.
If this helped you please please consider buying me coffee! Thanks in advance!
Disclosure: This post contains affiliate links. We may earn a commission at no extra cost to you. Prices are accurate as of publication date.