FIFO mode for Stock Sell

55 views
Skip to first unread message

Ghanashyam Prabhu

unread,
Jul 27, 2020, 11:21:17 AM7/27/20
to Beancount
I have the following in my beancount file. However it seems like I will always have to indicate sell transactions against an buy lot by filling in the exact price that lot was bought at. 
Doesn't bean count support FIFO mode where whenever there is a SELL transaction beancount figures the lot that was bought first and executes a SELL on that transaction? If not, can you please suggest how are folks handling these SELL transactions especially if you have a long ledger files?

2020-01-07 * "BUY" "VANGUARD TOTAL STOCK MARKET ETF: VTI"
  Assets:US:Schwab:ETF:VTI      12.0000 VTI {164.1090 USD}
  Assets:US:Schwab:Cash

2020-01-17 * "BUY" "VANGUARD TOTAL STOCK MARKET ETF: VTI"
  Assets:US:Schwab:ETF:VTI       6.0000 VTI {168.6290 USD}
  Assets:US:Schwab:Cash

2020-03-18 * "SELL" "VANGUARD TOTAL STOCK MARKET ETF: VTI"
  Assets:US:Schwab:ETF:VTI     -24.0000 VTI {} @ 125.9050 USD
  Assets:US:Schwab:Cash         3021.65 USD
  Income:US:Schwab:PnL

Thanks
Ghanashyam

Patrick Ruckstuhl

unread,
Jul 27, 2020, 11:43:18 AM7/27/20
to bean...@googlegroups.com

Hi,


Did you indicate Fifo when opening the account?

2020-01-01 open Assets:US:Schwab:ETF:VTI VTI "FIFO"

Regards,

Patrick

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/468a55fc-a2da-4bce-8279-ec4fb3f39f92n%40googlegroups.com.

Ghanashyam Prabhu

unread,
Jul 27, 2020, 1:36:01 PM7/27/20
to bean...@googlegroups.com
Thanks, I will try that!

Red S

unread,
Jul 27, 2020, 1:51:54 PM7/27/20
to Beancount
You might find it much faster to do a quick search in the docs, which are very well written and have a great UI. Eg:
https://beancount.github.io/docs/search.html?q=Fifo

Ghanashyam Prabhu

unread,
Jul 27, 2020, 3:36:26 PM7/27/20
to bean...@googlegroups.com
Wonderful, that worked like a charm.
Silly me, should have attempted the github doc search. I was using a Google Search and then the results somehow pointed to 404 on the docs.

On Mon, 27 Jul 2020 at 10:51, Red S <redst...@gmail.com> wrote:
You might find it much faster to do a quick search in the docs, which are very well written and have a great UI. Eg:
https://beancount.github.io/docs/search.html?q=Fifo

--
You received this message because you are subscribed to a topic in the Google Groups "Beancount" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/beancount/xApaVuQjAjE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/a36cbe0c-e4fa-4673-84b8-f2aab9ba1fa8o%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages