FYI the format quite simple # this matches a financial year like FY2018 for the financial year ending 2018 FY_RE = re.compile(r"^fy(\d{4})$")
# this matches a quarter in a financial year like FY2018-Q2 FY_QUARTER_RE = re.compile(r"^fy(\d{4})-q(\d)$") On Tuesday, 17 March 2020 13:47:36 UTC, kuba jamro wrote: > > +1 for this as a feature request built into beancount. > > I would be willing to help in the development of this feature too. > > > One of the ways I thought this could be done is in fava and actually it > looks like it has already have been done to a basic level. > > There is a fava option fiscal-year-end > https://github.com/beancount/fava/blob/master/fava/help/options.md#fiscal-year-end > . > > I've given it a quick test and it seems to only work in the time filter > box of fava and not in the BQL queries but I could I stand to be corrected. > > Jakub. > > On Tuesday, 17 March 2020 06:26:27 UTC, Martin Michlmayr wrote: >> >> I wasn't sure how to interpret Martin's reply. At first, I thought he >> was saying that he's not aware of circumstances where the FY != >> calendar year. But then I realized that he he was just stating that >> beancount doesn't have a concept of FY. >> >> As you say (and I'm sure as Martin is full aware), the FY often >> differs. The tax year is also different in some countries, e.g. in >> the UK it starts on April 6. >> >> What would the best way be to implement FY in beancount? >> >> * Oon-Ee Ng <ngoon...@gmail.com> [2020-03-17 14:23]: >> > Fairly common for some organizations to have financial years starting >> on >> > (say) 1st August or something similar. Sometimes to sync up with >> regulatory >> > requirements, sometimes so that bonuses/promotions hit a particular >> period >> > of the year, sometimes due to expected peak dates for a particular >> industry. >> > >> > On Mon, Mar 16, 2020 at 8:08 PM Martin Blais <bl...@furius.ca> wrote: >> > >> > > I don't think there's a concert of financial year that's != calendar >> year. >> > > >> > > On Mon, Mar 16, 2020, 04:19 Martin Michlmayr <t...@cyrius.com> >> wrote: >> > > >> > >> 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 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 bean...@googlegroups.com. >> > >> To view this discussion on the web visit >> > >> >> https://groups.google.com/d/msgid/beancount/20200316075211.GW25911%40jirafa.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 bean...@googlegroups.com. >> > > To view this discussion on the web visit >> > > >> https://groups.google.com/d/msgid/beancount/CAK21%2BhNDs0kbdkH-%3DJi%3Df7Lqmd9Ecw3hKbEu_7ab60%2BtL%2BWXuQ%40mail.gmail.com >> >> > > < >> https://groups.google.com/d/msgid/beancount/CAK21%2BhNDs0kbdkH-%3DJi%3Df7Lqmd9Ecw3hKbEu_7ab60%2BtL%2BWXuQ%40mail.gmail.com?utm_medium=email&utm_source=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 bean...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/beancount/CAGQ70euz0fJfv3rT%2BBZWCr5G89bjLsEG5MfNp2KgPUdSzc10HQ%40mail.gmail.com. >> >> >> >> -- >> 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 discussion on the web visit https://groups.google.com/d/msgid/beancount/7c8668c7-81cb-4d73-b86a-b8228ab2c521%40googlegroups.com.