We would like to know that tool you use to control your finances. Some of the big names are:
- Microsoft Money
- SAGE
- GNU Cash
- QuickBooks
- Quicken
- FinanceWorks
What is yours?
Xero - www.xero.com
which generally has its own bank feed except my bank (cash trust from a broker) only allows a spreadsheet format which I then save as CSV prior to running a conversion.
Other accounts I have are in foreign currency and only supply paper data so its easy enough to put into direct Xero format.
Xero requires one currency column - amounts are going out and + amounts are deposits
MYOB (based in Australia) however I is pushing into the US market.
For amex and diners transactions, they are paid into the bank net of merchant fee. On the bank statement the gross settlement is included on the line part of the general narration. I need to extract this value from the feed so when uploaded for reconciling, both the gross and net settled amounts are visible.
Do you suggest simply to reformat the csv file and convert a cleansed csv?
I'm transitioning from QuickBooks Pro, which I've used for 15 years, but the constant updates, the drop of support, the pushing for products I don't need and the push to go to the far more expensive online version. Just can't take it any more. I'm moving over to GnuCash. One bank has ofx direct connect so I think I'll be able to set that one up in GnuCash, my local personal bank just has CSV and Webconnect QBO files, so I just used this converter and it worked perfectly. Thank you!