Reconciliation taking in Firefly taking into account transaction date instead of booking date

[molnarti]

I have imported some large chunks of data into FF and realized my account balance is not matching. So stared to go through the periods with the reconciliation function, but i realized i am getting mismatches because of dates used.

E.g. there is a transaction made on December 30th, but booked by the bank only in January 4th (often with transactions in-between). But FF is reconciliating based on the transaction date, e.g. its showing it for the previous year, but the bank's closing balance on December 31 does not have this transaction.
These little differences add up, so when conciliating the 3rd period i have to manually calculated all these outlying transactions to find the difference. Also i have found no way to somehow mark the transaction so that its assigned to a different reconciliation period. How should I handle these?

On a related note: what are the effects of reconciliations on existing transactions? i see a column in db telling they are reconcilied and also an Undo reconciliation action on the transaction detail in FF, but what does is actually do?

[JC5]

Hey, thanks for starting this discussion.

Yes, the booking date is currently cosmetic only, I hope to change this in the future. The reconciliation has no "effect" on transactions, it's just a marker.

Cheers,
James

[molnarti]

So what is a good practice to reconciliate these transactions and find out where my differences are coming from? The only thing i could think if was to always change the date of those transactions to the period they belong to according to the bank...

[JC5]

The only thing i could think if was to always change the date of those transactions to the period they belong to according to the bank...

That is basically the only solution right now, sorry about that. Once it matches up though, you can reverse it again.