If you are a Natwest user, please be aware that they have changed their CSV file download of the statement. It is no longer limited to credit in and debits out, but it now also includes Pending Payments.
This causes an issue upon uploading the file as you will find unexpected duplicated entries a day or two after the item appears on the statement. For example, entries from the 4th and 5th of the month roll over to become credits on the 6th when a new export is taken, causing a duplication which can inadvertently become reconciled to an account. We are looking for a long term solution for this.
In the mean time, to avoid this happening, please look at the statement prior to uploading and ensure you remove any entries which appear next to an empty "Balance" column (as highlighted in yellow below. Entries with a value in the Balance column are fine to remain (as shown with the red ticks)
Then save and upload your edited CSV