}

    totals = {key: Decimal() for key in total_keys}

    for fund, balances in account_bals.items():

        for key in totals:

            totals[key] += balances[key]

    account_bals[''] = totals

    if full:

        account_bals['Unrestricted'] = unrestricted

    for row in itertools.islice(sheet.getElementsByType(odf.table.TableRow), 4, None):

        cells = iter(testutil.ODSCell.from_row(row))

        try:

            fund = next(cells).firstChild.text

            continue

        try:

            balances = account_bals.pop(fund)

        except KeyError:

            pytest.fail(f"report included unexpected fund {fund}")

        check_cell_balance(next(cells), balances['opening'])

        check_cell_balance(next(cells), balances['Income'])

        if full:

            check_cell_balance(next(cells), -balances['Expenses'])

            check_cell_balance(next(cells), balances['Equity'])

        else:

            check_cell_balance(