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 <[email protected]> [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 <[email protected]> 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 <[email protected]>
>> 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 [email protected].
>> > >> 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 [email protected].
>> > > 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 [email protected].
>> > 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/7c8668c7-81cb-4d73-b86a-b8228ab2c521%40googlegroups.com.
