[ledgersmb-devel] Re: New reconciliation rules in relation to payment changes?

On Sun, Jan 12, 2020 at 11:49 PM Erik Huelsmann <..hidden..> wrote:

Aggregate into single reconciliation lines (so as to reconcile with a single bank transaction):
* Payments and GL transactions on the same date with the same 'reference'
* GL lines with the same date and same 'source' (source reference number) -- if the gl lines couldn't be merged with a payment

This business rule allows reconciliation - as single reconciliation lines - of:
* Reconciliation of payments with their GL corrections as a single payment line
* Reconciliation of payments (without GL corrections)
* Reconcilation of GL-entered lines with the same source code reference
* Reconciliation of GL-entered lines individually (when no source code reference is entered)

Is this what we want?

Discussing the above on our chat channel, it wasn't clear that payments will be reconciled as individual lines for each payment entered if no payment reference is entered into LedgerSMB.

Also, first reactions were positive to this change.

On further consideration, we discussed it would be better to (start with) the following scheme:

* Reconciliation of payments as single payment lines

* Reconciliation of GL lines aggregated by source reference and posting date

* Reconciliation of GL lines without a source reference as individual lines

The need for corrections to be posted against payments can be addressed by adding the option to the payment screen to enter bank fees (withheld from the transaction) while entering the transaction itself. Bank fees have been the main source for the need to "adjust" payments for me in the past.

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.