Re: How to book loses?

2024-06-30 Thread Martin Michlmayr
profits. I use Expenses:Capital-loss -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr...@

Re: bean-extract is gone with v3 [Was: Announcement: v3 and git branches]

2024-06-18 Thread Martin Michlmayr
* Stefano Zacchiroli [2024-06-18 09:27]: > I welcome migration tips on what's the easiest migration path (to > beangulp, I guess?) Yes. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group

Re: Announcement: v3 and git branches

2024-06-17 Thread Martin Michlmayr
ted, but have to be preceded by a single quote: 'A * The limitation for currency names to be 24 characters long has been dropped (I think) Did this make into into this v3 or not (and are there any other changes?) -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because

Re: [ANN] beangrep - grep-like filter for Beancount

2024-05-16 Thread Martin Michlmayr
ok up old transactions and beangrep makes this much easier. Thank you! -- Martin Michlmayr https://www.cyrius.com/ -- 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

Re: New User: Starting Debt

2024-03-28 Thread Martin Michlmayr
* Chary Chary [2024-03-28 11:42]: > I am not an accountant, but as far as I understand, Equity is > exactly the the right account for this. Yep, it's right. Maybe OP can explain why they think it's not right. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message b

Re: Generating a list of vendor payments (for 1099s)

2024-02-01 Thread Martin Michlmayr
e) > > Does anybody have suggestions for this use case? I'd write a Python script that handles the exceptions. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this gro

Re: How to book a real estate purchase with seller credits

2024-01-04 Thread Martin Michlmayr
ibe from this group and stop receiving emails from it, send an > email to beancount+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/1AA015A1-C26D-428C-8297-F97473AF471F%40gmail.com. -- Martin Michlmayr https://www.cyrius.com/

Re: GROUP BY just with one currency?

2024-01-02 Thread Martin Michlmayr
roups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/CAMPYxd%3DYBZ1bJbBGojG97StFytAy6M9KEVHk_O8jdHYPq-cW_w%40mail.gmail.com. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups

Re: Summation for super-accounts in bean-report

2024-01-01 Thread Martin Michlmayr
Expenses:Foo should also yield Expenses:Foo; is that possible?) * Martin Michlmayr [2023-12-21 18:51]: > bean-report is deprecated. > > You can do the following in bean-query: > > SELECT PARENT(account), position, balance WHERE account ~ 'Expenses:Test:

Re: Optionally make commodity directive mandatory?

2023-12-28 Thread Martin Michlmayr
emails from it, send an > email to beancount+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/CABV0qx7m7iR8vYK%2BsgXjGx7UvV0uEsh1WaGE3hpL8eGc8Qiiqw%40mail.gmail.com. -- Martin Michlmayr https://www.cyrius.com/ -- Yo

Re: Summation for super-accounts in bean-report

2023-12-21 Thread Martin Michlmayr
t; https://groups.google.com/d/msgid/beancount/ff1ad476-8e0c-4cd2-ac1c-4eec19af85...@googlegroups.com?utm_medium=email_source=footer -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubs

Re: Updating balance sheet with price insertion

2023-11-20 Thread Martin Michlmayr
o/docs/beancount_query_language.html Fava (the web UI) has a "Holdings" tab which shows original cost and market value. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscrib

Re: Posting Resolution are being rounded

2023-10-26 Thread Martin Michlmayr
ne given in your beancount file. (Martin or Dan or someone can give an accurate explanation.) However, I agree that what beancount does is not optimal here. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount&q

Re: Hello / Beginner question

2023-10-24 Thread Martin Michlmayr
hecking1164.56 XXX @ 0.0810005184033 > EUR > > I guess this works, but I'm not sure if I should invert the conversion rate > every time for transactions like this? Or is there another/better way to do > this? You could write: Assets:AU:Bank:Checking

Re: Sharing expenses for dinner after adding up all expenses

2023-09-18 Thread Martin Michlmayr
p. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to beancount+unsubscr...@googlegroups.com. > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/beancount/CAK21%2BhMcqsxmWKJj%3D3h54MRt6zSDo

Re: Proper tracking of kids allowance

2023-03-05 Thread Martin Michlmayr
notebook. Their asset is your liability. -- Martin Michlmayr https://www.cyrius.com/ -- 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+un

Re: Method to convert posting accounts in already imported data?

2023-01-10 Thread Martin Michlmayr
the Unaccounted to something else. I haven't looked at it yet but check out the emails about "autobean.refactor" from October 2022 on this mailing list. You should be able to fix up your file with autobean.refactor. -- Martin Michlmayr https://www.cyrius.com/ -- You received this

Re: Calculating P for UK -- or non-US

2022-12-25 Thread Martin Michlmayr
redstreet/fava_investor https://github.com/hoostus/portfolio-returns/blob/master/irr.py Although it may not work for you. I'm not exactly sure how you structure your accounts. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Goog

Re: Calculating P for UK -- or non-US

2022-12-23 Thread Martin Michlmayr
ount can do everything ledger can do in this regard (and more, such as LIFO and FIFO, even if that's not useful to you). -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe fro

Open/close - best practices

2022-12-17 Thread Martin Michlmayr
pivot on the "Who" meta-data. (This is usually the method I follow, although I have in the past created sub-accounts for frequent payees). 3) Use "Assets:Receivable:EBay" and open/close as I see fit. (e.g. if it annoys me and I don't expect to sell anything, I add a "clos

Changes in v3?

2022-12-14 Thread Martin Michlmayr
to be preceded by a single quote: 'A * The limitation for currency names to be 24 characters long has been dropped (I think) # Tools * bean-check: new -a option to enable auto plugin What else is there? -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you

Complete assertions in beancount v3?

2022-11-30 Thread Martin Michlmayr
. Will complete assertions be in beancount v3? Also, is there currently (or in v3) a way to check that an account is empty? 2022-04-01 balance ACCOUNT 0 does not work because the currency is missing. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed

Re: Beancount v3 progress

2022-09-08 Thread Martin Michlmayr
put several projects on hold because I don't know whether to target v2 or v3 because there's no clear v3 timeframe. Making beangulp available for v2 (as the other tools are) would be a great help for me. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you ar

Re: Can't get csv importer to work

2022-05-08 Thread Martin Michlmayr
* Alvin Ye [2022-05-07 23:27]: >('Date,Description,Amount,Balance'), This does not match your CSV file. > activity.csv: > Date,Description,Card Member,Account #,Amount,Extended Details,Appears On -- Martin Michlmayr https://www.cyrius.com/ -- You received this message be

Re: Crypto Swaps and balancing

2022-05-07 Thread Martin Michlmayr
rred_tolerance_default" "GBP:0.004" option "inferred_tolerance_default" "USD:0.004" -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from thi

Re: bean-check error for balance assertion with prefix?

2022-04-14 Thread Martin Michlmayr
expected behaviour. This is different to the behaviour in ledger (in case you're used to that). -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving e

Re: Plain text accountant

2022-03-09 Thread Martin Michlmayr
* Tony Xiao [2022-03-09 13:44]: > Would anyone in this group be interested in offering plain text > based accounting service or know anyone who does? I provide such services to a number of clients. I'll respond off-list. -- Martin Michlmayr https://www.cyrius.com/ -- You re

Re: BQL: Exclude zero sum accounts

2022-01-21 Thread Martin Michlmayr
* Daniele Nicolodi [2022-01-21 22:51]: > Turns out that a naive implementation of HAVING was not very difficult to > put together https://github.com/beancount/beanquery/pull/22 Thank you, Daniele! I also asked about this feature in the past. -- Martin Michlmayr https://www.cyri

Re: Does anybody use (number, currency) amounts in metadata?

2021-09-24 Thread Martin Michlmayr
* Martin Blais [2021-09-23 16:54]: > Does anyone use an Amount type as a metadata value? I use that feature for a non-profit. Our books are in USD but some payments are in other currencies via Wise and I use meta-data to track that and run some checks. -- Martin Michlmayr ht

Re: Reporting USD Trans in CAD for CRA

2021-07-19 Thread Martin Michlmayr
to beancount. This query will convert from USD to CAD on the date of the transaction: SELECT date, narration, CONVERT(position, 'CAD', date) WHERE account ~ 'Expenses:Test' -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups

Re: Moving from GnuCash

2021-06-17 Thread Martin Michlmayr
a bank reconciliation script) that might already be built-in with GnuCash or other accounting packages. (I should probably clean up my script and publish it...) -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beanc

Re: autobean.sorted: find out misplaced / misdated transactions

2021-06-15 Thread Martin Michlmayr
ithub.com/zacchiro/beancount-plugins-zack/ does the same. -- Martin Michlmayr https://www.cyrius.com/ -- 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

Re: old transactions when getting going

2021-05-15 Thread Martin Michlmayr
script to call bean-extract, etc. > > My main question is what should I do now with the historical data to > import? You can always create opening balances for a specific point in time and go back later and add more transactions. -- Martin Michlmayr https://www.cyrius.com/ -- You receiv

Re: Beanborg

2021-04-02 Thread Martin Michlmayr
I never published). I'll try to put together an email soon with some thoughts and links to the different solutions. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group an

Re: beancount.ingest is no more. Long live beangulp!

2021-02-01 Thread Martin Michlmayr
nality? (or is that not possible because beancount v2 and v3 can't be installed at the same time?) -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from i

Re: InteractiveBrokers

2020-12-29 Thread Martin Michlmayr
* Martin Blais [2020-12-30 00:56]: > Does anyone here have an importer for Interactive Brokers? https://github.com/tarioch/beancounttools -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancoun

beancount2ledger 1.3: beancount to ledger converter

2020-11-13 Thread Martin Michlmayr
w metadata with hledger output * Support setting auxiliary dates and posting dates from metadata * Support setting the code of transactions from metadata * Support mapping of account and currency names * Improve documentation: * Add user guide * Document limitations -- Martin Michlmayr https://www.

Re: Currency exchange rates sources

2020-11-06 Thread Martin Michlmayr
e exchange rate. I am almost ashamed of my > ignorance int his field. Is there a think like an "official" number? > Which sources does people use? I don't think there's an "official" number but I'll let the experts comment. -- Martin Michlmayr https://www.cyrius.com/

Re: ofx max_date correct?

2020-10-21 Thread Martin Michlmayr
urce=footer> > >> . > >> > > > > -- > 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+unsubscr.

Re: Narration of Postings

2020-09-05 Thread Martin Michlmayr
* Mefju [2020-09-05 08:23]: > I also use narration for postings, and also miss that Beancount does not > parse comments. IHMO that's a feature and not a bug. Ledger uses one syntax for comments and meta-data. This actually makes things quite error prone. -- Martin Michlmayr

Re: Narration of Postings

2020-09-05 Thread Martin Michlmayr
an simply attaching a narration to a posting. Well, a "attaching a narration to a posting" is using meta-data, it's just that the "Payee" metadata has a special meaning in ledger and is used to override the payee from the transaction header. (That's why I was initially confus

Re: Narration of Postings

2020-09-04 Thread Martin Michlmayr
the first posting are attached to the whole transactions. Metadata after a posting is attached to that particular posting, i.e. it works the same way as ledger. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Be

Re: record buying stock with asset checking?

2020-08-11 Thread Martin Michlmayr
stions that are not clear. -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr...@googlegroups.com. To view

Re: Using bean-query programmatically

2020-08-10 Thread Martin Michlmayr
gt; But what if I want to use bean-query engine programmatically? Look at query.run_query() Examples that make use of it are: beancount/plugins/split_expenses.py experiments/misc/monthly_balance.py -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you ar

Re: Decimal(): understanding, syntax

2020-08-10 Thread Martin Michlmayr
unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/95c3b5fb-41cf-4409-a989-4dbf3ae2b5ffo%40googlegroups.com. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Go

Re: Decimal(): understanding, syntax

2020-08-08 Thread Martin Michlmayr
tter, I would book 0.08 for 11 months and 0.12 in the last month (or the other way around). -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiv

Re: Decimal(): understanding, syntax

2020-08-07 Thread Martin Michlmayr
uantize(D('.01'), rounding=decimal.ROUND_HALF_UP) -- Martin Michlmayr https://www.cyrius.com/ -- 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

Re: Linear git history

2020-08-02 Thread Martin Michlmayr
did and offers that as the default. -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr.

Re: How to use plugin in beancount (beancount.plugins.implicit_prices) ?

2020-08-02 Thread Martin Michlmayr
* Booster Hidrogen [2020-08-02 04:56]: > Thank you for the examples, so basically the built in plugin isn't directly > editing the beancount file. Correct. Beancount plugins modify the entries (in memory) when the file is loaded by beancount. Martin -- You received this message because you

Re: How to use plugin in beancount (beancount.plugins.implicit_prices) ?

2020-08-02 Thread Martin Michlmayr
* Martin Michlmayr [2020-08-02 17:40]: > You add the following line to your .beancount file to activate the > plugin: > > plugin "beancount.plugins.implicit_prices" > > That's it. When you add this plugin, price info via @ and @@ will > generate pri

Re: How to use plugin in beancount (beancount.plugins.implicit_prices) ?

2020-08-02 Thread Martin Michlmayr
to activate the plugin: plugin "beancount.plugins.implicit_prices" That's it. When you add this plugin, price info via @ and @@ will generate price entries. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "

beancount2ledger available

2020-07-24 Thread Martin Michlmayr
for beancount2ledger(1) -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr...@googlegroups.com. To view this

Re: Goodbye bean-web, bean-bake, bean-report. What about bean-price?

2020-07-17 Thread Martin Michlmayr
ldings is also pretty nice. Is someone planning on maintaining bean-report for v3? -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from i

Re: Beancount v3

2020-07-04 Thread Martin Michlmayr
nother repo, where they would eventually rot, or if > someone cares, adopt them and maintain or evolve them. I'm interested in maintaining the beancount to ledger conversion scripts. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the

Re: String leterals in Beancount files

2020-06-25 Thread Martin Michlmayr
ght break a lot of beancount files. -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr...@googlegr

Re: Incorrect trial balance with inventory lots?

2020-06-21 Thread Martin Michlmayr
* Martin Michlmayr [2020-06-22 12:13]: > I'm not sure if I'm misunderstanding something but this looks like a > pretty serious issue to me. Never mind. I was confused... -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google

Re: Incorrect trial balance with inventory lots?

2020-06-21 Thread Martin Michlmayr
beancount doesn't set the correct cost when you use FIFO: https://github.com/beancount/beancount/issues/479 I'm not sure if I'm misunderstanding something but this looks like a pretty serious issue to me. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are s

Re: Armature python programmer question about "beancount.parser import _parser"

2020-06-11 Thread Martin Michlmayr
* Chary Chary [2020-06-11 01:22]: > from beancount.parser import _parser > > However I do not see any _parser.py in the beancount/beancount/parser/ _parser is built from the C files that make up the parser. It's built when you make "make build". -- Martin Michlmayr htt

Re: bean-query CONVERT() at a historical rate

2020-06-09 Thread Martin Michlmayr
l mention "trading accounts" as a solution but I don't know how they work. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving

Re: Newbie - No application set to open .beancount file

2020-05-25 Thread Martin Michlmayr
I just found this: https://awesome-beancount.com/#editor-support * Jad Benyahia [2020-05-25 12:47]: > Hi Martin, > > Thank you for your prompt answer. > I'm on MacOS :) > I'll try downloading Emacs then :) > > Thank you! > > Le lun. 25 mai 2020 à 12:27

Re: Newbie - No application set to open .beancount file

2020-05-25 Thread Martin Michlmayr
w Python to use beancount. If you want to enhance beancount, for example by writing bank importers or plugins, then you'd need Python. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscri

Re: Beancount issues

2020-05-19 Thread Martin Michlmayr
ove to GitHub. Anyway, I emailed some people asking for their GitHub username, so please give me a few days. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and s

Re: Beancount issues

2020-05-19 Thread Martin Michlmayr
lly Cc the github author when a ticket > is updated. Yeah, agreed. -- Martin Michlmayr https://www.cyrius.com/ -- 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

Re: Beancount issues

2020-05-18 Thread Martin Michlmayr
* Kirill Goncharov [2020-05-18 01:43]: > But then Martin Michlmayr suggested to create a mapping manually, I > think it's a good approach too. I can take a look tomorrow. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google

Re: Beancount Revisited

2020-05-18 Thread Martin Michlmayr
ke merging files, > applying rules, and intelligently modifying entries. Seems that > most of the python hooks are already in beancount (like parsing > single entry etc.). I'm already using the existing VIM plugin, but > would like to do so much more. Sounds interesting. (And yes, Martin, pleas

Re: "Purchased" leave hours

2020-05-17 Thread Martin Michlmayr
as you wish. >- Should I "price" the conversion between hours and dollars at that >agreement date? Yes. >- Will this allow me to post the purchased leave pay deduction in >dollars, as seen on the pay stub, and auto-convert to "hours paid back"

Re: Customize get_amounts function in csv importer

2020-05-17 Thread Martin Michlmayr
> >> wrapping old) function in the csv module. The problem is that when I have > >> to patch it twice for the above 2 situations, the patches spill over and > >> change the outcomes depending on how I import my custom importers in > >> xxx.import file. > &

Re: Beancount Revisited

2020-05-16 Thread Martin Michlmayr
ublish your scripts. -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr...@googlegro

Re: Documentation is now read-only

2020-05-11 Thread Martin Michlmayr
* Kirill Goncharov [2020-05-11 12:37]: > Update: All major issues were resolved! > > Full API reference now available at > https://xuhcc.github.io/beancount-docs/api_reference/index.html Impressive speed! Thanks to you and your responsive upstream! -- Martin Michlmayr https://ww

Re: Documentation is now read-only

2020-05-11 Thread Martin Michlmayr
* Kirill Goncharov [2019-08-02 02:18]: > Docs now available at GitHub Pages: https://xuhcc.github.io/beancount-docs/ I found a number of formatting issues but they are problems in the Google docs (I left some comments). This looks really good. Thanks for working on this! -- Martin Michlm

Re: Documentation is now read-only

2020-05-11 Thread Martin Michlmayr
one one solution and improve that together? (I noticed some formatting issues in the API reference, i.e. in the docstrings.) -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe fr

Re: Airline miles: expiry and value reporter for Fava, Beancount [fava_miler]

2020-05-06 Thread Martin Michlmayr
d for inspiring me to do similar things... I have to think about some ideas and actually make time to implement them. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this gro

Re: No position matches error

2020-04-30 Thread Martin Michlmayr
erage method. Or is this completely > unrelated to my problem? It typically depends on the tax laws of your country which lot is sold first. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" g

Re: Beancount issues

2020-04-26 Thread Martin Michlmayr
* Kirill Goncharov [2020-04-26 07:02]: > I think we can simply remove profile links and keep only a reference to > original issue with a display name: I kinda like the original links. > This kind of username matching is not reliable anyway I can work on a mapping of user names. -

Re: Beancount issues

2020-04-26 Thread Martin Michlmayr
ncount moves to GitHub. ;) Kirill: in some tickets the Markdown or something seems broken, e.g. https://github.com/xuhcc/beancount/issues/428 -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsub

Re: Categorizing transactions automatically on import

2020-04-09 Thread Martin Michlmayr
= importer.file_account(file) for entry in imported_entries: entry.meta['test'] = 'foo' return imported_entries CONFIG = [ apply_hooks(ofx.Importer('1...', 'Assets:...'), [SPIImporter()]), ] -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you

Re: Categorizing transactions automatically on import

2020-04-09 Thread Martin Michlmayr
r the entries and fix them up. I'm sure this is basic Python stuff but unfortunately I can't figure out how to do it. Has anyone done this and can give an example of such a wrapper? -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to t

Re: Categorizing transactions automatically on import

2020-04-08 Thread Martin Michlmayr
found any examples (apart from smart_importer, but I can't figure out how they do it). Maybe I should just use smart_importer, but for now I'm leaning towards a simple match approach. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the

Why is booking done before plugins

2020-04-08 Thread Martin Michlmayr
into a fundamental issue: beancount does interpolation and booking before plugins. Doing interpolation before plugins makes sense, but I don't understand why the booking code runs at such an early stage. Are there fundamental reasons for this or is that something that could be changed? -- Martin

Categorizing transactions automatically on import

2020-04-08 Thread Martin Michlmayr
ldn't figure out how it works or how I could do the same (without smart_importer). (My Python isn't fantastic.) -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group

Re: Equivalent to ledger's --cleared for reports?

2020-04-01 Thread Martin Michlmayr
ot;. But I can't find it! > > There's surely some simple answer involving queries right? Yes, you can query based on "flag". Note that beancount treats no flag and "*" the same, which imho is not ideal: https://bitbucket.org/blais/beancount/issues/295/flags-differentiate

Re: Beancount issues

2020-03-22 Thread Martin Michlmayr
* Uwe Ziegenhagen [2020-03-22 16:26]: > If you have the issues in a readable format ask us, your followers, to > import them. I am sure some of us have plenty of time now. :-( https://github.com/jeffwidman/bitbucket-issue-migration And someone already said he created a Git repo. --

Re: GROUP by financial year

2020-03-17 Thread Martin Michlmayr
> I don't think there's a concert of financial year that's != calendar year. > > > > On Mon, Mar 16, 2020, 04:19 Martin Michlmayr wrote: > > > >> I can use: > >> > >> SELECT YEAR, SUM(position) WHERE account ~ '^Income' GROUP BY YEAR ORDER &g

Re: GROUP by financial year

2020-03-16 Thread Martin Michlmayr
s/concert/concept/? * Martin Blais [2020-03-16 08:07]: > I don't think there's a concert of financial year that's != calendar year. > > On Mon, Mar 16, 2020, 04:19 Martin Michlmayr wrote: > > > I can use: > > > > SELECT YEAR, SUM(position) WHERE account ~

Exclude empty amounts with GROUP BY

2020-03-16 Thread Martin Michlmayr
-100.00 USD 2020-03-01 * "Sponsorship from B" invoice: "B01" Assets:Receivable 30.00 USD Income:Sponsorship -30.00 USD 2020-03-10 * "Payment from A" invoice: "A01" Assets:Bank 100.00 USD Assets:Receivable -100.00 USD

GROUP by financial year

2020-03-16 Thread Martin Michlmayr
I can use: SELECT YEAR, SUM(position) WHERE account ~ '^Income' GROUP BY YEAR ORDER BY YEAR to see all income per year. Unfortunately, the financial year is not the calendar year. Is there a way to use bean-query to do a GROUP BY on a fiancial year or do I have to write a script? -- Martin

ledger equity equivalence in beancount

2020-03-05 Thread Martin Michlmayr
Is there an equivalence for "ledger equity" in beancount? It creates opening balances so you can split files into different years. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group.

Re: The end of Mercurial on Bitbucket

2020-02-20 Thread Martin Michlmayr
Git. Kirill Goncharov created a Git repo. Maybe he (or others) could help investigate the issues you foresee. I don't think anyone here expects you to do all the work. If you give some pointers, others might be able to help out. -- Martin Michlmayr https://www.cyrius.com/ -- You received

Re: sorting transactions

2019-12-20 Thread Martin Michlmayr
account1 > account1.ledger ledger -f all.ledger print --raw account2 > account2.ledger However, ledger print loses some information, so depending on your ledger file this approach may or may not work. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you

Re: Release my plugins/importers to github and pypi

2019-12-09 Thread Martin Michlmayr
Transferwise "bank transfers"? In the web browser, this works for me: * Click on currency account * Click on "more" on the right, below the account info (where it says "Send CURRENCY" on the left * Download a statement * A menu comes up that offers a choice betwe

Re: Tracking expenses that are really transfers

2019-12-06 Thread Martin Michlmayr
money went out (i.e. cash flow). So I think the question is how to do cash flows in beancount. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop recei

Re: Active currency holdings and average cost booking

2019-11-26 Thread Martin Michlmayr
up. > To unsubscribe from this group and stop receiving emails from it, send an > email to beancount+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/5e4d37c1-016d-499b-a988-a2cf0e7138eb%40googlegroups.com. -- Martin Michlmayr

Re: Currency Conversion Not Working [Advise Needed] on Fava

2019-11-14 Thread Martin Michlmayr
plugins.implicit_prices will do it for you. -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr..

Re: When to use tags and when to create separate account?

2019-10-28 Thread Martin Michlmayr
100.00 EUR > ;; Income:Business:Hosting CDE -150.00 EUR Given this example, is where a way to limit the query where sum(position) is < 125? -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount

Re: "Transitive" conversion of currencies?

2019-10-12 Thread Martin Michlmayr
://bitbucket.org/blais/beancount/issues/255/prices-are-not-transitive -- Martin Michlmayr https://www.cyrius.com/ -- 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

Re: Invalid reference to unknown account 'Expenses:...'

2019-07-03 Thread Martin Michlmayr
* Florian Lindner [2019-07-03 11:21]: > Not sure if the root account "Expenses" needs an open statement, but > I don't think it's wise to book directly to it. "Expenses" alone is not a valid account name in beancount. It needs a subaccount. -- Martin Michlmayr https:

Re: How to manage transactions, which are split across several files

2019-06-27 Thread Martin Michlmayr
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+unsubscr...@googlegroups.com. > To post to this group, send email to beancount@googlegroups.com. > T

Re: How to fix the income statement so that incomes are positive and expenses are negative?

2019-05-09 Thread Martin Michlmayr
positive or negative? Assets are positive > liabilities/income/expenses?? Liabilities and income are Negative, expenses are positive. This way, things balance. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Bea

Re: Stock Splits

2019-05-03 Thread Martin Michlmayr
basic. You can enhance it. -- Martin Michlmayr https://www.cyrius.com/ -- 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+unsubscr...@googlegroups.c

Re: Mass assignment of accounts

2019-05-02 Thread Martin Michlmayr
e correct account based on the payee, or you write a plugin to rewrite your transactions. It sounds like you want the former. -- Martin Michlmayr https://www.cyrius.com/ -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from

  1   2   >