SolidOS / money-pane

Insight in your personal finance data
MIT License
11 stars 1 forks source link

Book date vs Value date #33

Closed michielbdejong closed 3 years ago

michielbdejong commented 3 years ago

From ASN Bank CSV import we get: boekingsdatum: 27-10-2019, journaaldatum: 28-10-2019, valutadatum: 28-10-2019,

From ASN Bank MT940 for the same transaction we get:

So for ASN Bank CSV we should use 'boekingsdatum' and then for ASN Bank MT940 we should probably just use 'date'

michielbdejong commented 3 years ago

Another one, this time for interest:

so let's try to combine 'boekingsdatum' with 'entryDate'

michielbdejong commented 3 years ago

Now I found one (this time for BEA payment in shop) with:

michielbdejong commented 3 years ago

I would expect 'date' to mean the same as 'boekingsdatum', the date on which the account balance changes. I would expect 'entryDate' to mean the same as 'journaaldatum', the date on which the mutation is added in the bank's system valutaDatum the date used for interest calculations

michielbdejong commented 3 years ago

So the reality is that even within the same bank and the same bank account, with different report formats, you already get unsolvable date differences. Will deal with this in #35.