Hopefully there is a known answer already. So what do you use to import all transactions of different accounts of different banks of entire family? For me this includes wise, revolut, post finance, credit suisse and different accounts.
I do it manually in excel, for each trade, dividend event and corporate action. I am also hoping for a better solution out there!
It’s a pretty labor-intensive solution at first, but Beancount + Fava is really cool:
1 Like
I use KMyMoney to track my personal finances (highly recommended!). I’m happy to have this data stored only on my hard disk and not having to rely on yet another app…
In order to minimize manual entries, I use the “Finanzassistent” offered by my bank, grouping all transactions into various categories. So instead of ~70 individual “grocery” transactions I just enter the total amount once per month.
for day to day transactions, like grocery shopping, breakfast coffee and bread, paying bills, subscriptions, how does it arrive in excel in the first place? Do you manually enter each transactions?
hmm, grouping transactions is not too hard for me, but getting all transactions from different banks in the first place is a painful thing…
In the EU, banks are obliged to offer an API*. It’s a real shame that we here in Switzerland are once again lagging behind. I use YNAB, which could import automatically, but not with any of the Swiss banks. I therefore do everything manually. Another possibility would be to divide expenses over several credit cards. Always use the same card for grocery shopping, for example.
*I see no security reason as long as it is read only
I misunderstood as “broker transactions”. For the payment transactions I define the relevant columns I want to have and then import the account statement as csv from 2 banks after switching columns and deleting all internal transfers. All is done manually!
I use Moneywiz and can confirm that - through SaltEdge - it works with Wise, Revolut and PostFinance (I have the three of them) but not with CreditSuisse (my wife has it and I track that account manually - but those transactions are very few in our case)
Why dont you use the Camt Kontoexport? It is a ISO Standard, used by many accounting software.
I don’t see this option anywhere as a private customer? At least not with Raiffeisen.
if there some software that supports auto import all accounts via e-banking camt kontoexport ?
Dont know about raiffeisen. With UBS you need to ask about it. But I know people using it witz Raiffeisen, just ask about activation camt reports.
Yes, they are tools beeing able to translate the xml file. I run a small family business as side hustle and I use it to do the accounting for it. It works bith ways, payments I make directly in the accounting tool and then I upload it to the UBS eBanking.
I assume that with a bit excel skills and some AI help one might be able to find a DIY workaround to import the xml informations in a excel sheet
edit: I found this example online, it gives you an idea how it looks: Zahlungen importieren mit Camt.053 und Camt.054 - Wissensdatenbank / Finanzen / Buchhaltung nutzen - Fairgate DeskPro
With UBS i need to download the files manually and import it to my software. Other banks like BEKB are more convenient, you can download the files directly from the accounting software using the ebanking credentials
I actually do accounting for a small non-proift association and there I use bexio importing camt file from postfinance. It works quite ok. But I am not sure I can and I want to do the same with my personal accounts from different banks.
I guess the disucssion so far in this thread already shows that there is no good way for swiss banks
@Jaime did you give a look to the software I mentioned? Or are you looking for free solutions only ?
thank you for recommending that. I was actually using moneywiz quite extensively for half a year but later switched to Wallet by BudgetBakers for it’s web application. But yes, moneywiz is quite good.
1 Like
I’m kind of amazed this continues to be such a bad experience! Every year I have to wrangle with crappy csv’s into excel. I think I might invest some time to finally build something myself to get the data out in a nice way. I’ll keep you posted 
1 Like
btw, i am confused that why bexio can connect to so many swiss banks e-banking but other fintech cannot? Link bexio with your E-Banking