Hello! I'm a newcomer to Beancount and text-based accounting, and I'm
working on moving from spreadsheets to Beancount for my small business. I
am using "inventories" to track physical inventory - in my case, notebooks
which I make and sell.
My question is as follows: when I purchase inventory with different prices
per lot, my trial balance does not "balance". Rather, the value of assets
is is calculated using the most recent inventory purchase price, rather
than the price specific to that lot. Here is an example:
option "booking_method" "FIFO"
option "operating_currency" "USD"
plugin "beancount.plugins.implicit_prices"
2014-01-01 open Equity:Opening-Balances
2014-01-01 open Assets:Checking:Chase
2018-12-01 open Assets:Inventory
2018-01-01 * "Deposit"
Assets:Checking:Chase 1000.00 USD
Equity:Opening-Balances
2018-12-27 * "Original run of notebooks"
Assets:Inventory 25 NOTEBOOKS { 20.00 USD, "Original lot of
books"}
Assets:Checking:Chase -500.00 USD
2019-12-27 * "New run of notebooks"
Assets:Inventory 25 NOTEBOOKS { 12.00 USD, "New run of
books"}
Assets:Checking:Chase -300.00 USD
In this case, the stated value of my inventory is $600.00. However, I would
*expect* the value to be $800.00: the first lot was purchased for $500.00,
and the second was purchased for $300.00.
I realize that is is a bit of a misapplication of "inventories" - in
beancount (and ledger), inventory refers to securities. I surmise that the
remaining $200.00 is considered an unrealized loss within the system, and
thus the trial balance does not, well, balance by that amount.
My question is: would there be a more appropriate way, or directive, to
change the behavior of beancount to not do this, and simply use the cost of
an item at the time it was purchased for determining the value of assets?
Thank you!
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/b31ffec7-ff19-4ea8-8730-7fdcc519d0fao%40googlegroups.com.
