Skip to content

balance with full account paths and unused accounts #2429

@thielema

Description

@thielema

I want to do the following: Write a balance report to a FODS file, load this FODS into LibreOffice Calc and append the table to another table, that accesses the numbers from the balance report. I want to access the balance report numbers with the LibreOffice function VLOOKUP (in the German version: SVERWEIS). For proper lookup, VLOOKUP needs the full account name, as provided by the list mode of hledger-balance. However, the list mode misses the amounts for parent accounts. Thus what I want is all the lines and numbers from the tree mode, but the account names written as in the list mode.

This wish is similar to #1550 but I do not want indentation. But I guess, VLOOKUP can be made to tolerate the indentation.

For now I work around the missing functionality by creating multiple balance reports in list mode, but with depths 2, 3, 4.

What I also need is that unused accounts are reported anyway, but with amount zero. This is for accounts that are unused in one year, but exist for transactions in other years. I consider an account existing if there is any transaction that refers to that account or if there is an explicit account declaration.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-WISHSome kind of improvement request or proposal.balancefodsThe FODS output format.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions