Usage of payee and narration

Guys, could clarify what are the best practices for usage of payee and narration? Till now i was using only one " " filed, example: 2018-04-01 * "SIMPLEMOBILE*SERVICES" Liabilities:Business:InkBCash -122.60 USD Expenses:Business:Phone 2018-04-02 * "AMAZON MKTPLACE

Re: Usage of payee and narration

Thank you Martin! Very helpful description and usage example! On Sunday, April 29, 2018 at 3:41:08 AM UTC-4, Martin Michlmayr wrote: > > * mpl...@gmail.com > [2018-04-28 16:43]: > > Martin, could you explain a little bit on the logic on making > > decision on keeping

Re: Usage of payee and narration

Martin, could you explain a little bit on the logic on making decision on keeping record as "narration" vs "payee" "" ? What are the advantages / disadvantages. Let say for example if i put all my records as narrations, what is the situation in which i might see the disadvantages to this

Newbie questions on beatcount and emacs.

Guys hi, I am pretty new to plain text accounting, was using ledger CLI for week or so, like the flexibility over cashGNU, and yesterday installed beancount(using it with emacs). I have several questions: 1 How do you add today's date without typing? In ledger-mode i was using ctrl+C ctrl+A,

Re: Question on file organization.

Martin, yes, i understand on single file. I meant categories. In sample beancount ledger it has following line for banking category: * Banking So i wonder if each Banking account should be separate in it's own category, like this: * Banking Chase ... ... ... * Banking BofA ... ... ... etc

Re: Question on file organization.

Guys, thank you for all your replies! Now i understand better. Beancount has a great community :) On Tuesday, April 10, 2018 at 9:46:12 PM UTC-4, mpl...@gmail.com wrote: > > I am reading right now recommendations on file organization. ( >

Re: Newbie questions on beatcount and emacs.

Martin, thank you for the detailed answer! On Sunday, April 8, 2018 at 1:37:40 PM UTC-4, Martin Blais wrote: > > On Sun, Apr 8, 2018 at 9:10 AM, wrote: > >> Guys hi, >> >> I am pretty new to plain text accounting, was using ledger CLI for week >> or so, like the flexibility

Importing transactions from bank.

Guys hi, How do you import transactions from bank(checking account, credit cards, etc)? What set up do you use? I've found several ledger CLI related projects for this on github, but nothing for beancount. p.s. I am in USA, and have a chase bank if it matters. -- You received this

Re: Importing transactions from bank.

Thank you Michael, that's exactly what i was looking for! On Monday, April 9, 2018 at 4:28:30 PM UTC-4, Michael Droogleever wrote: > > You'll need to use something like this, > https://gist.github.com/mterwill/7fdcc573dc1aa158648aacd4e33786e8#file-importers-chase-py, > > or make your own: >

Question on file organization.

I am reading right now recommendations on file organization. (https://docs.google.com/document/d/1P5At-z1sP8rgwYLHso5sEy3u4rMnIUDDgob9Y_BYuWE/edit#heading=h.3rnrqkmm822f) and have a question When you have multiple banks should they be split into separate sections? * Banking 1 * Banking 2 etc

Re: Best format for importing from bank

Martin, thank you for your detailed reply! Now it's super clear :) On Tuesday, April 17, 2018 at 2:00:11 AM UTC-4, Martin Blais wrote: > > On Mon, Apr 16, 2018 at 7:08 AM, wrote: > >> Guys hi, >> >> From docs (Importing External Data in Beancount >>

Re: Importing transactions from bank.

Martin, thank you for your detailed reply! Now it's super clear :) On Tuesday, April 17, 2018 at 1:45:23 AM UTC-4, Martin Blais wrote: > > On Sun, Apr 15, 2018 at 8:35 PM, wrote: > >> I've started playing with import scripts,the sample files provided in >> repo are very

Re: Anyone got some sort of python headless browser script to fetch ofx file from their bank website?

I saw the following post on reddit related to downloading data from banks. Maybe it will be helpful to you: I'm new to the ledger-cli ecosystem, and spent many hours recently trying to get this all sorted out. I now have a more-or-less fully automated setup that works as such: Component 1

Re: smart_importer

Smart importer inserts payees learned from previous transactions in beancount file? So we are getting: 2013-12-11 * "WHOLEFDS HOU 10236 02124201320 / 042002720272124201320" Liabilities:US:CreditCard -14.47 USD Expenses:Personal:Food 2013-12-14 * "MACY'S #003 HERALD SNEW YORK / 00307963916

Re: Importing transactions from bank.

5 Also what's the right way to calculate balance ? Chase have the following CSV structure, Balance fields are included in checking CSV, so i guess i can use balance of the last transactions for balance. They are not

Re: Importing transactions from bank.

I've started playing with import scripts,the sample files provided in repo are very useful, just have couple of additional questions i was not able to figure out/not 100% sure about: 1 bean-extract does not write transactions in main beancount file (personal.beancount), it generates output

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

Thank you for all your replies guys! I will stick to separate accounts for now, but will sure play with group-by feature. -- 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

Storing beancont files on github/bitbucket

Guys hi, As many of you i use git to track changes of main beancount file, importers, etc. For now i was using git locally, but today created private repo on bitbucket and pushed all the files. Do you also keep your files on github/bitbucket? Or it's bad idea? It's relatively sensitive

Best format for importing from bank

Guys hi, >From docs (Importing External Data in Beancount ) i've understood that PDF is not easy format to work with. But how other formats compare? In chase bank i can choose - CSV,

Re: Storing beancont files on github/bitbucket

Thank you for all your replies guys, makes perfect sense. I will encrypt the data and will use dropbox & back up drives for back ups instead of private repo. -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop

Bean-check does not catch 1 cent differences.

Guys hi, As title says bean-check does not catch 1 cent differences. Is it expected behavior? -- 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

Any of you guys use beancount to work with your CPA/tax professional?

Guys hi, I am using beancount for 7 months and i love it! I have all needed data in front of me and feel in control, but now i use it only as internal tool. Basically it's only for me. I have all my account together in 1 big file (2 companies, personal, etc) and it words good for my needs.

Re: moving to GitHub?

Martin hi, Sorry for bringing it up again :) Thank you for all the work you did, I love beancount and will keep using it not matter what version control systems you will be using. Please consider one point, it's not only about attracting developers, it's also about discoverability for users

Re: Any of you guys use beancount to work with your CPA/tax professional?

"Simpler than that would be to use the income statement to identify all the bits and pieces, and when asked for specific questions, to produce listings of transactions they require." yes, that's what i am planning to do. I've asked what exactly CPA needs and he said profit/loss sheet, trial

Re: Any of you guys use beancount to work with your CPA/tax professional?

"About profit/loss, i.e., a list of trades and their cost basis, selling prices and commissions, isn't there by default." - i've meant difference between profit and expenses, do not to have trades/stocks. "Easiest is to bake to static files" - i see now, will look into bean-bake, creating

How can i distribute amounts between several accounts based on set % or ratio?

Guys hi, Let say i have transactions going into account Expenses:Rent, and i would like 60% of total go to Expenses:Rent:Personal and 40% to Expenses:Rent:Business, what's the best way to do it? -- You received this message because you are subscribed to the Google Groups "Beancount" group.

Re: bean-bake fails (Windows bash)

Have same issue, using "--no-colons" solved it partially, some of the pages/links are not being generated/not working. Here is log with errors: K:\at\office>bean-bake --no-colons at.beancount test Bottle v0.12.13 server starting up (using WSGIRefServer())... Listening on http://localhost:9475/

Re: bean-bake fails (Windows bash)

Guys hi, Still trying to solve this, will appreciate any suggestions on why balsheet.html, income.html, index.html... and web.css are not generated. Might be encoding problem related to "%5C", but not sure. -- You received this message because you are subscribed to the Google Groups

Is it possible to generate bean-bake report for custom period?

By default bean-bake generates yearly reports (Year 2018, Year 2017, etc) Is it possible to generate bean-bake report for custom period? Or change the default calculation of the year? I need to generate report for fiscal year (Oct 1 2017 - Sep 30 2018) -- You received this message because

Update installation guidance for Windows.

Guys hi, Now the installation guidance suggest to use Cygwin or "Windows Subsystem for Linux" for Windows. Cygwin was working fine with beancount, but when i tried to install smart importers on Cygwin it was hell. Smart importers depend on scipy and installing it on Cygwin is very problematic

Re: Update installation guidance for Windows.

Also when researching options to make scipy work on Cygwin/Windows i've met lots of recommendations to abandon Cygwin for Anaconda, but did not try it so can't comment on it. -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from

Question on best practices (using different account vs payee)

Guys hi, I have 5 contractors i am working with very often, and i'd like to be able to see how much i paid each of them separately as well. what's the best way to structure Right now i have it like this: 2019-02-04 * "QuickPay with Zelle payment to FreelancerName1" Assets:Business:Checking

Re: Time tracking - is this possible?

Martin, did you ever end up implementing it? I would be also interested to have possibility to track time. On Sunday, September 25, 2016 at 10:27:50 PM UTC-4, Martin Blais wrote: > > Ah I see. You want "hours minutes" type of format, with minutes over 60 > minutes to form an hour. > > I

Re: Time tracking - is this possible?

Thanks for your reply. i understand the beancount part now. I would like to use fava too, and i was recommended to use separate ledger file "since fava assumes a primary operating currency for its charts". On Tuesday, February 19, 2019 at 11:31:51 PM UTC-5, redst...@gmail.com wrote: > It's

Re: Time tracking - is this possible?

Thanks for clarifying it. I should have separate ledger for time tracking, correct? time and money should not be in same ledger... On Monday, February 18, 2019 at 1:03:00 PM UTC-5, Martin Blais wrote: > > On Mon, Feb 18, 2019 at 5:37 AM > wrote: > > I would be also interested to have

Re: Time tracking - is this possible?

Here is example to make it clear what i mean: To do time tracking should i have separate ledger file? As i understand i can't track money and time in same ledger cause it's different "matter". So i am thinking about creating time account: Assets:Time and accounts showing how i spend time,

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

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

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

"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"

Chart difference between 2 accounts (Fava)

Guys hi, Is it possible to chart difference between 2 accounts ? Let say i have 2 accounts Income:Business:Company1 Expenses:Business:Company1 Right now i see charts for them individually at localhost:5000/myledger/account/Income:Business:Company1 and

Re: Chart difference between 2 accounts (Fava)

Vivek hi, Thank you for your reply Seems like it's not working for me, it filters out some of the accounts, but still lots of non Company1 accounts are present. (so it filters but not fully) Could you understand what i am doing wrong ? I am entering in field called "Filter by tag, payee, ..."

Re: Chart difference between 2 accounts (Fava)

And where can i read more on this "any(account:"X"), any(account:"X*")" expression ? Can't find it in neither in fava nor in beancount docs. On Tuesday, August 27, 2019 at 3:35:47 PM UTC-4, mpl...@gmail.com wrote: > > Guys hi, > > Is it possible to chart difference between 2 accounts ? > > Let

Is it allowed to use 12.5 USD instead of 12.50 USD ? (it's not calculated correctly)

Hello, I have a strange problem - when omitting 0 for cents balances are not calculated correctly Example: With 2019-10-20 * "Food, EatingOut" Expenses:Personal:Food:Water 9.68 USD Expenses:Personal:Food:Meat:Beef 6.80 USD

Re: Is it allowed to use 12.5 USD instead of 12.50 USD ? (it's not calculated correctly)

"Look up how the tolerance is inferred automatically in the documentation (or on this thread)." I see now, so when i using "6.8" instead of "6.80" i was changing transaction tolerance from 0.005 to 0.05, did i understand it right ? Also using whole numbers does not change tolerance, right ?

Re: Is it allowed to use 12.5 USD instead of 12.50 USD ? (it's not calculated correctly)

"Look up how the tolerance is inferred automatically in the documentation (or on this thread)." I see now, so when i using "6.8" instead of "6.80" i was changing transaction tolerance from 0.005 to 0.05, did i understand it right ? On Sunday, October 20, 2019 at 2:04:18 PM UTC-4, Martin Blais

How to export to excel ? (fava)

Guys hi, Could you help me understand how to export to excel in fava ? Here is what i did: 1 installed fava with excel dependency > pip3 install fava[excel] > 2 click "arrow button" next to import. But the only option i am getting is: Download currently filtered entries as a Beancount file >

Is it bad practice to use multiple postings ?

Guys hi, As the title says i wonder if it's bad practice to use multiple postings. Sometimes i use transactions with multiple postings, example: 2019-09-06 * "Paid for ..." Expenses:Business:Company1200 USD Expenses:Business:Company2200 USD Assets:Cash -400

Re: Chart difference between 2 accounts (Fava)

"It can have issues, though, in showing things outside of Company1 if you have transactions that have multiple postings dealing with the root 'Company1' and outside of 'Company1'." -that's exactly the issue i have. "I haven't figured out how to handle this scenario elegantly yet, some just

Re: Question on query output on per transaction basis.

yes, it outputs postings, not transactions. On Thursday, April 30, 2020 at 1:28:19 PM UTC-4, Red S wrote: > > Did you try: `journal` ? > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails

Re: Question on query output on per transaction basis.

i tried to use bean-bake, but stumbled upon couple issues / questions. could you please look at them https://groups.google.com/forum/#!topic/beancount/6P5fVmoDm9Q ? Of course if you will have a spare minute, i know you are in the process of migrating to new version control system. On

Re: Help with bean-bake.

Thank you for your reply. I see now, i was playing more with beancount query language and manged to cover most of things i need. (fava generate excel files for beancount queries, so i can export them easy) Just want to say thank you for building great tool and easy to follow documentation !

Re: Help with bean-bake.

Thank you Jakub, i figured it out. On Monday, May 4, 2020 at 6:21:07 AM UTC-4, kuba jamro wrote: > > If you are trying to get a view on the last UK tax year then I think you > need can do that with Fava. > > You need to add the following into your beancount file and then you can > use FY2019 as

Help with bean-bake.

Hi everyone! I have several questions on bean-bake hope someone could help: 1. What's the argument for --first-month ? "--first-month APRIL" and "--first-month APR" result in error "--first-month 4" runs but does not make any difference, year still starts with Jan 01 2. What's the argument

Question on query output on per transaction basis.

Guys hi, I need to prepare general ledger for my cpa for specific period. Since he does not have beancount installed I originally i planned to use bean-bake, but now i think it will be easier to general excel files in fava. SELECT date, description, account, position FROM date >

Advise on best way to approach following importer.

Hello everyone! I need to write importer that will 1 categorize sale and refund transactions dividing them per division 2 aggregate them 3 other transactions (non sale or refund) provide in regular way (1 leg) so later smart importer will be able to categorize them. Approximate CSV file format