App should automatically track cash balances for selected accounts. This is known as double-entry bookkeeping.
This means that:
Whenever you add a transaction where you Buy, Sell, pay fees or taxes, a Transfer transaction is added for Cash asset with a proper currency on the same Account
For each account you can choose if you want to track cash and from which account it should be taken from (eg. to pay your broker from your bank).
This means it now makes sense to import deposits and withdrawals on broker accounts
This also enables us to add a Conversion transaction, where you exchange one asset for the other while forwarding the cost-basis. That would create two opposite Transfer transactions that are linked together.
Early Access
It’s already available under Early Access! To enable it:
Go to Settings → Early access and enable Cash Tracking
Any idea when this would be implemented and ready? It is a must-have for me to use the software. Otherwise, there is no proper way to reconcile and ensure all transactions are coded correctly.
All transactions will have their “other side”, so Dividends as well.
If a transaction was paid in USD and the fee is in EUR, that would create two transactions.
I’ve finished onboarding and stabilizing the platform. I’m now adding additional integration tests to make sure nothing gets broken with these fundamental changes and will be starting the work on cash tracking once I have these.
It’s really close. All tests just passed with flying colors. Now I need to add some minimal UI so you can enable it and I’ll be releasing it to get some first feedback.
Go to Settings → Early access and enable Cash Tracking
Go to Settings → Cash tracking and enable it
A few things to note:
You can safely turn it on and off - all cash transactions are calculated on the fly, so you won’t break your data
Currently you can only configure it globally, but there will be a way to configure it per asset, account and currency
You can enable it on accounts with existing cash balance, meaning the cash will be tracked from the earliest Cash Transfer/Buy/Balance. It’s the safest and most sensible mode, but you need to add some Account Balance or Transfer transactions for the accounts and currencies you want to track
If you enable it everywhere, it will only work for currencies you already have in your project - you will need to add them manually. Once you enable tracking, new currencies will be added automatically
You can convert all cash to a single currency - it’s meant for accounts where brokers do that for you and don’t provide FX conversions
If you navigate to your cash account, you will see all transactions that affected it’s balance. This is by design, but before the full release they will be presented a bit differently to reduce confusion.
Just enabled the Cash Tracking feature - really excited to try this out! The double-entry bookkeeping functionality looks great.
I noticed one small thing in the transaction overview: since enabling cash tracking, the Asset column now only shows the base currency (CHF) instead of the actual traded assets (stocks, ETFs). Not sure if this is intended behavior or something that will be adjusted.
Looking forward to testing it more thoroughly. Thanks for making this available in early access!
Definitely to be adjusted, thanks for reporting. It WILL be like that, but only if you’re viewing cash accounts (because then these transactions belong to cash). But otherwise it should always show the original asset.
Yes, as if you buy, you both add and subtract from the balance at the same time For adding money into portfolio use Transfer. It does update the balance, but doesn’t create any cashflows.
A new version is being released now with a bunch of fixes and some preliminary table decorators (Cash In & Cash Out). You can also sort and filter by relation type.
