When your #bank sends you a CSV of your transactions, one of the columns should be a unique transaction identifier (e.g. UUID).
That way, your #accounting software won't record a duplicate transaction even if you get the CSV time frame wrong.
Thoughts?