the1gofer
05-17-2008, 12:32 PM
All exported transactions are positive numbers. It would be nice to have negative numbers for the debits. Once in excel it's a pain to add all those little =-1* to every debit.
matt454357
05-02-2009, 04:01 PM
This post is a year old, and the problem is still the same. Unless I am missing something (settings/links)?
Yep, I was missing something. There is a transaction type column. Just use this in Excel:
=IF(E2="debit",-1,1)*D2
vBulletin® v3.8.1, Copyright ©2000-2010, Jelsoft Enterprises Ltd.