Bank Reconciliation Alternative Work Flow

[Ealfardan]

@dalacor

would a bank feed address your underlying problem.

Unfortunately no, since we don’t have that in my country.

@dalacor

I don’t actually understand why you want or need things like having the bank records as an external record etc.

I may not be particularly good with words but it seems like @Patch has more or less the same idea here:

@Patch

The core changes suggested are

1. When a bank import is done, Manager retains all the imported records as a bank import. This is similar to when doing a bank reconciliation, Manager doesn’t throw away the reconciliation value after it is found to match.
2. Manager uses progressive matching (from most exact to least exact) to dynamically link bank import data to existing Manager transactions for the bank import period.
3. Manager shows the bank import hiding all transactions which match by default. This display would mostly look the same as the existing bank import display.
4. This display would however also show any existing Manger transaction for which a matching bank import could not be found (ie failed matches in the other direction).
5. There should also be an option to show transactions Manager has matched so users can check the automated matching if they believe there maybe an inappropriate match.

With this in place, a bank transfer becomes just another pre existing Manager transaction. Showing in bank transfers would be nice and still possible in my opinion.

It’s not something that I came up with, most other software do just that, reconciliation and import are the same thing, when you upload your bank statements the process goes like this:

1. The system does its automatic matching
2. Allows the user to do manual matching
3. Import unmatched transactions
4. Retain separate records of the entire bank statement uploaded with linkages to all matched transactions whether automatically matched, manually matched or imported. This way if there’s been any unwanted future changes you just go to bank statement and reimport entries without a match.

You can check Odoo, MS Dynamics, NetSuite and even QuickBooks among many others to get the idea. But I strongly recommend Odoo’s method because it’s the simplest, leanest, most streamlined and most transparent process.