What is best way to track not only food item, but also how much it costed per pound.

48 views
Skip to first unread message

mpl...@gmail.com

unread,
Apr 15, 2019, 5:04:03 PM4/15/19
to Beancount
Guys hi,

Before i was tracking food in 1 single account

Expenses:Personal:Food

But than i tried to split them in particular food categories

Expenses:Personal:Food:Fruit:Apples
Expenses:Personal:Food:Meat:Beef
etc

And found out that this way i can see much more clear picture and that i started to care how much i actually paid per pound.
i've found out that often price on same food item can very greatly (apples can  cost 0.99lb, 1.49lb and 1.99lb for same variety even in same market)

What's the best way to track it?

Let's say now i have

2019-03-01 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     4.17 USD
  Assets:Cash                                       

2019-03-15 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     6.44 USD
  Assets:Cash  

2019-04-01 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     8.01 USD
  Assets:Cash  

And there is no way to tell which of these transactions were a good buy (for 0.99lb), and which were a more careless buy (for 1.99lb).

Zhuoyun Wei

unread,
Apr 15, 2019, 10:09:24 PM4/15/19
to mpl...@gmail.com, Beancount
The proper way to do this is to use price notation "@" and "@@". But that may be an overkill since you may have many different items to track.

Another method would be to write the information you would like to keep in the metadata.

--
Zhuoyun Wei
> --
> 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 post to this group, send email to bean...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/beancount/1f04b82a-f4b1-49c9-a08d-c032aec888ed%40googlegroups.com <https://groups.google.com/d/msgid/beancount/1f04b82a-f4b1-49c9-a08d-c032aec888ed%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.

mpl...@gmail.com

unread,
Apr 16, 2019, 8:22:19 AM4/16/19
to Beancount
"The proper way to do this is to use price notation "@" and "@@". But that may be an overkill since you may have many different items to track. "
-could you explain why is it overkill? I look up your suggestion in Beancount Syntax Cheat Sheet and seems like i can do

2019-04-01 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     6.44 USD @ 1.49 USD
  Assets:Cash

2019-04-01 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     8.01 USD @ 1.99 USD
  Assets:Cash 

etc

"Another method would be to write the information you would like to keep in the metadata."
-meta data can be put only 1 time per transaction, correct?

So if i have several posting/accounts in 1 transaction, example

2019-04-01 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     8.01 USD
  Expenses:Personal:Food:Meat:Beef      24.63 USD
  Assets:Cash 

than i won't be able to put separate meta data for each?

What i do now is

2019-04-01 * "Key Foods"
  Expenses:Personal:Food:Fruit:Apples     8.01 USD ; 1.99 lb
  Expenses:Personal:Food:Meat:Beef      24.63 USD ; 5.99 lb
  Assets:Cash 

But problem comments are not displayed in fava
> an email to bean...@googlegroups.com.

Martin Michlmayr

unread,
Apr 16, 2019, 8:38:38 AM4/16/19
to bean...@googlegroups.com
* mpl...@gmail.com <mpl...@gmail.com> [2019-04-16 05:22]:
> "Another method would be to write the information you would like to keep in
> the metadata."
> -meta data can be put only 1 time per transaction, correct?

You can.

> So if i have several posting/accounts in 1 transaction, example

2019-04-01 * "Key Foods"
Expenses:Personal:Food:Fruit:Apples 8.01 USD
weight: 1.99
Expenses:Personal:Food:Meat:Beef 24.63 USD
weight: 5.99
Assets:Cash

--
Martin Michlmayr
https://www.cyrius.com/
Reply all
Reply to author
Forward
0 new messages