Import Transactions - Reconcile by Value Date
Posted: 14 April 2021, 09:32
Hi,
Would it be possible to consider adding an option to reconcile imported transactions based on the value date rather than the date?
To make my credit card accounts work well, I set the date of the automatic transaction to the 15th of each month (this is when my statement / payment amount gets generated) and I then set the value date gets set to the 27th which is when I actually make the payment.
What this currently means, is that when I import my transactions, unless I either disable the option to reconcile based on date, or make it a very wide range of around 15 days, I end up with duplicate transactions as the payment transactions never match.
Would it be possible to consider adding an option to reconcile imported transactions based on the value date rather than the date?
To make my credit card accounts work well, I set the date of the automatic transaction to the 15th of each month (this is when my statement / payment amount gets generated) and I then set the value date gets set to the 27th which is when I actually make the payment.
What this currently means, is that when I import my transactions, unless I either disable the option to reconcile based on date, or make it a very wide range of around 15 days, I end up with duplicate transactions as the payment transactions never match.