Reply to topic

(Semi-)Automatic reconciliation

vicnet
Registered Member
Posts
69
Karma
0

(Semi-)Automatic reconciliation

Mon Oct 16, 2017 5:24 pm
Hello,

Is there a way to re-conciliate automatically account from bank imported data ?

I don't want to import data into account, just mark operations from imported data.
My operations are already manually created and each month end, I want to speed up this operation.

I imagine something like:
  • download data from bank (could be external from skrooge)
  • import for reconciliation in skrooge
  • skrooge try to reconciliate as much as possible with different strategies (value comparison, texte matches...), perhaps with a trust level (?)
  • skrooge present find associations between not checked operations and imported one
  • skrooge could purpose some actions (value adaptation, ...)
  • user can add association manually, and can add new operations to match forgotten one
  • then it should be reconciliate easily ;D
a+
Vicnet
User avatar smankowski
Moderator
Posts
715
Karma
7
OS

Re: (Semi-)Automatic reconciliation

Tue Oct 17, 2017 8:56 pm
Hi Vicnet,

The existing process is the following one:
1- You import operation as you want
2- The reconciliation can be done automatically, you just have to enter the target balance and click on the automatic reconciliation

If operations are first created manually, you can do that:
1- You import operation as you want
2- Open potential duplicate
3- Merge operations duplicated (the manual operation will be merge with the imported one)
4- Do the automatic reconciliation

I hope this will help you.
Regards.


Skrooge, a personal finances manager powered by KDE
http://skrooge.org
User avatar smankowski
Moderator
Posts
715
Karma
7
OS

Re: (Semi-)Automatic reconciliation

Thu Oct 19, 2017 11:41 am
Hi Vicnet,

As I said, the automatic reconciliation is working ONLY on imported operations.
I could implement a modification to be able to launch the automatic reconciliation on manually created operations if a setting is enabled. Do you think this could be interesting?


Skrooge, a personal finances manager powered by KDE
http://skrooge.org
vicnet
Registered Member
Posts
69
Karma
0

Re: (Semi-)Automatic reconciliation

Fri Oct 20, 2017 11:31 am
If I understand the process:
- import operations from bank (these operations are valid as they came directly from bank)
- remove potential duplicates with existing (manual) operations, keep imported
- as imported operations came from bank services, ALL the imported operations could be checked automatically

If all operations are imported, there is no need to reconciliate as operations will be exactly the same from bank.
I need reconciliation because I enter operations manually (all my operations in fact).

If I undersand correctly, the main part is in finding duplicates...

How finding duplicate works ?
Why is there an automatic reconciliation as all imported should be checked ?

a+
Vicnet
User avatar smankowski
Moderator
Posts
715
Karma
7
OS

Re: (Semi-)Automatic reconciliation

Fri Oct 20, 2017 1:42 pm
vicnet wrote:If I understand the process:
- import operations from bank (these operations are valid as they came directly from bank)
- remove potential duplicates with existing (manual) operations, keep imported
- as imported operations came from bank services, ALL the imported operations could be checked automatically

Yes. This is the process.
vicnet wrote:If all operations are imported, there is no need to reconciliate as operations will be exactly the same from bank.

Even if operations are imported, the reconciliation is needed.
Indeed, the reconciliation is a "check point" done when you receive the monthly document from your bank. The reconciliation allows:
1- Declare that you agree with your bank on the balance of your account at a given date. When operations are imported this is trivial.
2- All corresponding operations can be hidden.
vicnet wrote:I need reconciliation because I enter operations manually (all my operations in fact).

When operations are created manually, reconciliation is useful too.
But, this is a manual action where you have to click on each operation listed in you monthly report sent by your bank. When the operation is done the pointed operations can be hidden.

The automatic reconciliation is not working on manual operations because automatic reconciliation algorithm tries to find all combinations of operations given the expected balance. Most of the time manual operations don't have the right dates and the algorithm doesn't find a match.
vicnet wrote:If I undersand correctly, the main part is in finding duplicates...

How finding duplicate works ?

The "Open potential duplicate" function opens a page with operations having same amounts and same dates.
vicnet wrote:Why is there an automatic reconciliation as all imported should be checked ?

See above
vicnet wrote:a+
Vicnet


Skrooge, a personal finances manager powered by KDE
http://skrooge.org

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], bartoloni, Bing [Bot], Capitain_Jack, Dave-P, Dibo, Exabot [Bot], gerdeg, gfielding, Google [Bot], Kevaaq, luigitrezzi, lynnux, marthab, raddison, Sogou [Bot], TheraHedwig, Yahoo [Bot]