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
+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
h
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
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
Yep
Cell phone finger fart
On Mon, Mar 16, 2020, 08:17 Martin Michlmayr wrote:
> 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 c
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 ~ '^Income' GROUP BY YEAR ORDER
> > BY Y
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
> BY YEAR
>
> to see all income per year.
>
> Unfortunately, the financial year
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 Mi
