On Wed, Nov 16, 2016 at 1:29 AM, Len Wanger <[email protected]> wrote:
> > Hi, > > Excuse the newbie question. I am trying to make reports that mimic > financial statements for a company. I could use some tips on how to get the > reports formatted for external consumption. I am currently working on the > balance sheet. A few questions I have: > > - Is there a way to get the balance sheet report to: 1) show a specified > string for an account number, instead of the account name (e.g. account > Assets:FixedAssets:Equip to render as "Equipment & Machinery"? Also, is > there a way to get the accounts to render in a specified order instead of > alphabetical order (e.g I want to have bank accounts, then other current > assets, then fixed assets)? > - To do this do I need to write a custom report in Python? Should I look towards the query format? What's the best approach? None of the canned ways to query and report allow you to do this at the moment. I'd recommend you run a query using SQL / bean-query, render to CSV, and write a script to insert the lines into your favorite template. If you're more ambitious / skilled (at Python), you can also write directly to the Beancount Python API. You could reuse this from a script: https://bitbucket.org/blais/beancount/src/b969f5f75b699707d50e52d686248997e5786655/src/python/beancount/query/query.py?at=default&fileviewer=file-view-default > > Thanks, > > Len > > -- > 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 post to this group, send email to [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/beancount/3dc4fc4a-3ec1-46ef-b3d7-2733613be376%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/3dc4fc4a-3ec1-46ef-b3d7-2733613be376%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNH-8M46t7AC_dt_fOHNutm3Zs2%2Bjzs-LVxRznsrwDUXg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
