To update already existing lines against a bank statement we first need to ensure the ‘Update’ Mode of the Header Bank Statement section is set to ‘Update’.
Then using either the sheet or the user form we can populate the data desired. Ensure the ‘Line Update Mode’ is also set to ‘Update’, and once complete, close the user form (if open) and perform the appropriate upload.