Hi @peterkingster you can use the steps outlined in this guide to upload your transactions manually into your sheet. How/where exactly you would download your transactions in the first place depends on what your bank has available to you.
There is the experimental Tiller Community Solutions add-on Manage Duplicates workflow, otherwise you can refer to this guide for more tips on handling duplicate transactions in your sheet.