sort_period = Period.PERIOD

            else:

                sort_period = Period.ANY

        class_bals: Mapping[data.Account, core.MutableBalance] \

            = collections.defaultdict(core.MutableBalance)

        for key, balance in self.balances.items():

            if not key.account.is_under(account):

                pass

            elif key.period & sort_period:

                class_bals[key.classification] += balance

            else:

                # Ensure the balance exists in the mapping

                class_bals[key.classification]

        norm_func = core.normalize_amount_func(f'{account}:RootsOK')

        def sortkey(acct: data.Account) -> Hashable:

            prefix, _, _ = acct.rpartition(':')

            balance = norm_func(class_bals[acct])

            try:

                max_bal = max(amount.number for amount in balance.values())

            except ValueError:

                max_bal = Decimal(0)

            return prefix, -max_bal

        return sorted(class_bals, key=sortkey)

        start_date = self.period_range.start

        stop_date = self.period_range.stop

        return sorted(

            account

            for account in data.Account.iter_accounts(root)

            if account.meta.open_date < stop_date

            and (account.meta.close_date is None

                 or account.meta.close_date > start_date)

        )

class Report(core.BaseODS[Sequence[None], None]):

    C_CASH = 'Cash'

    NO_BALANCE = core.Balance()

    SPACE = ' ' * 4

    def __init__(self,

                 balances: Balances,

                 *,

                 date_fmt: str='%B %d, %Y',

    ) -> None:

        super().__init__()

        self.balances = balances

        self.period_desc = balances.period_desc

            for bals in zip(equity_totals, asset_totals, liabilities)

        ]

        self.write_totals_row(

            "Net cash provided by operating activities",

            period_totals,

            stylename=self.style_endtotal,

        )

        self.write_totals_row("Net Increase in Cash", period_totals)

        begin_totals = [

            self.balances.total(classification=self.C_CASH, period=period)

            for period in [Period.THRU_MIDDLE, Period.OPENING]

        ]

        self.write_totals_row("Beginning Cash", begin_totals)

        self.write_totals_row(

            "Ending Cash",

            period_totals, begin_totals,

            stylename=self.style_bottomline,

        )

    def write_trial_balances(self) -> None:

        self.start_sheet(

            "Trial Balances",

            ["Account Name"],

            ["Classification"],

            ["Balance Beginning", self.balances.period_range.start.strftime(self.date_fmt)],

            totals_prefix=["Change During", f"{self.period_desc} Ending"],

            title_fmt="Chart of Accounts with DRAFT {sheet_name}",

        )

        # Widen text columns

        col_style = self.column_style(3.5)

        for col in self.sheet.childNodes[:2]:

            col.setAttribute('stylename', col_style)

        # Patch up header row text

        header_row = self.sheet.lastChild

        header_row.removeChild(header_row.firstChild)

        header_row.insertBefore(self.multiline_cell(

            ["Balance Ending", self.period_name],

            stylename=header_row.lastChild.getAttribute('stylename'),

        ), header_row.lastChild)

        for acct_root in ['Assets', 'Liabilities', 'Income', 'Expenses', 'Equity']:

            norm_func = core.normalize_amount_func(f'{acct_root}:Dummy')

            want_balance = acct_root not in EQUITY_ACCOUNTS

            self.add_row()

            for account in self.balances.iter_accounts(acct_root):

                period_bal = self.balances.total(account=account, period=Period.PERIOD)

                prior_bal = self.balances.total(account=account, period=Period.PRIOR)

                if want_balance:

                    close_bal = self.balances.total(account=account)

                    close_cell = self.balance_cell(norm_func(close_bal))

                    open_cell = self.balance_cell(norm_func(close_bal - period_bal))

                else:

                    close_cell = odf.table.TableCell()

                    open_cell = odf.table.TableCell()

                self.add_row(

                    self.string_cell(account),

                    self.string_cell(account.meta.get('classification', '')),

                    open_cell,

                    self.balance_cell(norm_func(period_bal)),

                    close_cell,

                    self.balance_cell(norm_func(prior_bal)),

                )

def parse_arguments(arglist: Optional[Sequence[str]]=None) -> argparse.Namespace:

    parser = argparse.ArgumentParser(prog=PROGNAME)

    cliutil.add_version_argument(parser)

    parser.add_argument(

        '--begin', '--start', '-b',

        dest='start_date',

        metavar='DATE',

        type=cliutil.date_arg,

        help="""Date to start reporting entries, inclusive, in YYYY-MM-DD format.

The default is one year ago.

""")

    parser.add_argument(

        '--end', '--stop', '-e',

        dest='stop_date',

        metavar='DATE',

        type=cliutil.date_arg,

        help="""Date to stop reporting entries, exclusive, in YYYY-MM-DD format.

#!/usr/bin/env python3

from setuptools import setup

setup(

    name='conservancy_beancount',

    description="Plugin, library, and reports for reading Conservancy's books",

    author='Software Freedom Conservancy',

    author_email='info@sfconservancy.org',

    license='GNU AGPLv3+',

    install_requires=[

        'babel>=2.6',  # Debian:python3-babel

        'beancount>=2.2',  # Debian:beancount

        'GitPython>=2.0',  # Debian:python3-git

        # 1.4.1 crashes when trying to save some documents.

        'odfpy>=1.4.0,!=1.4.1',  # Debian:python3-odf

        'PyYAML>=3.0',  # Debian:python3-yaml

        'regex',  # Debian:python3-regex

        'rt>=2.0',

    ],

    setup_requires=[

        'pytest-mypy',

        'pytest-runner',  # Debian:python3-pytest-runner

    ],

    tests_require=[

        'mypy>=0.770',  # Debian:python3-mypy

        'pytest',  # Debian:python3-pytest

    ],

    packages=[