Account Checkpoints / Extending the Reconcile featureset

[antmcmullen]

Hello,
I like the ability we have today to mark transactions as reconciled, but i would like to see this extended.

Some of my account statements i have to match the cash balance, the investment value or both.

1. Account Checkpoints,
   An account checkpoint would allow you to specify the balance on a given day (to match with a bank statement for example)
   This checkpoint would give additional reassurance that the items are matched correctly, it may even be beneficial

2. Cascade Reconcile
   one an account checkpoint is reached, the ability to cascade a reconcile to all transactions before that reconcile date.

3. Reconciled lock
   once a transaction is reconciled, it is prevented from deletion or having the transaction total amended, the sub items can be changed, but the date, value and account(s) are locked once reconciled, If a change is required youd have to 'unreconcile' the transaction

4. Investment Checkpoint
   the ability to do similar to account checkpoints, but to specify the volume, and/or price from a statement, and show variances to this. (updating the price model as appropriate)

I have started working on this with the aid of GitHub CoPilot for my own use but reckon such functionality maybe beneficial to the wider community.
see below examples
i) All Accounts Reconcile overview

ii) Specific account, period overview

[kantorge]

Thank you very much for sharing your ideas in such detail. I really like the direction and scope of your suggestions, as I already have something on my to-do list related to more structured handling of the reconciliation process. Is this work in progress available for testing and review?

Account Checkpoints,
An account checkpoint would allow you to specify the balance on a given day (to match with a bank statement for example)
This checkpoint would give additional reassurance that the items are matched correctly, it may even be beneficial

My personal experience is that majority of the accounts, especially for cash, but even ones with strict balance control and account statements, start to deviate in YAFFA. From time to time I do a checkup, and add a correction assigned to "Unknown" payee and to "Unknown" category. This corrects the balance, without modifying the opening balance, which is an anchor of the account balance, and a special transaction type. I'm thinking, if a dedicated technical transaction type could be used for correction, or if account balance milestones should be introduced with the similar intent.

Cascade Reconcile
one an account checkpoint is reached, the ability to cascade a reconcile to all transactions before that reconcile date.

Personally, I use the reconciliation process to validate that each entry is correctly added. (Time to time duplicate entries can be identified, or I used an incorrect account initially.) From a technical perspective, this could be added to support quick cascading.

Reconciled lock
once a transaction is reconciled, it is prevented from deletion or having the transaction total amended, the sub items can be changed, but the date, value and account(s) are locked once reconciled, If a change is required youd have to 'unreconcile' the transaction

Makes sense, good idea.

Investment Checkpoint
the ability to do similar to account checkpoints, but to specify the volume, and/or price from a statement, and show variances to this. (updating the price model as appropriate)

This sounds to be a bit trickier. See my notes above on the correction transaction types. From a technical perspective, it might be feasible to use buy/sell/add/remove transactions to correct investment volume-related gaps. Please provide further details or examples, if there's a use case you'd like to cover.

Let me know your thoughts.