Automatically create a deposit/withdrawal for every buy/sell

[markosp]

Hello,

I would like to ask something similar to the topic here but it’s marked as resolved, so I’m starting a new thread. If continuing the previous thread is preferred, please merge.

Automatically add cash operations

Hello everyone. First of all, thanks to the developers for providing such an impressive program. I have investments in stocks with the same bank as I have the cash account. Therefore, each purchase or sale is automatically linked to the account. I have manually loaded all (many) historical purchase and sale operations from 2015 until now. But do not charge the cash debit operations, believing that you would be able to solve it with the same accounts! Now I find that the metrics, values and gr…

I just started using PP, hoping to replace a complex spreadsheet that I have been using for almost a decade. I imported the full transaction history (buys, sells, and transfers of securities between accounts), and then noticed that the corresponding deposit accounts showed negative balances. So I then created corresponding cash transactions (deposits/removals) for each buy/sell, and the cash balances show as zero.

I read in the other thread that one could convert buys/sells to deliveries. But I already have some actual matched inbound/outbound delivery transactions for transfers of securities between my accounts from one broker to another, and so converting every transaction to delivery doesn’t seem right. Is there a way to automatically create a corresponding cash transaction for a security transaction, for example a tick box that says “funded” for a purchase?

Thanks in advance (and thanks for the software in the first place!)

[Sn1kk3r5]

You can still use delivery. Dikvery just means no cash account associated during transacrion.

Withdrawals for cash can be generated automatically, but only a fix amount and not corresponding to a buy.

[markosp]

But if I convert to delivery it’s as if the stock was purchased previously or was gifted to me. If I later add bank account history and record transfers between bank accounts and brokerage deposit accounts there would be a mismatch (showing a surplus at the brokerage deposit account). And if I wanted to see actual cash flows (money spent purchasing stocks minus sales proceeds) it wouldn’t achieve that.

Converting to delivery seems like a hack to bypass the double entry bookkeeping built in the software. That’s not a problem per se, but wouldn’t a better hack be an automatic creation of a corresponding cash transaction?

[Rafa]

@markosp

but wouldn’t a better hack be an automatic creation of a corresponding cash transaction?

No, because delivery is dealing as you’ve suggested already accordingly.

[markosp]

Ok, thanks. I was thinking that a distinction between transfer and purchase would be useful but I can appreciate that practically it’s not a problem.