Import of HSBC UK "NON-STERLING TRANSACTION" records

breaghva's Avatar

breaghva

09 Apr, 2022 05:35 PM

Hi,
HSBC interface to MD is via OFX, QIF, or CSV download. For foreign currency purchase transactions, the (2.99%) service fee is generated as a record separate to the purchase transaction record. I would like to combine the 2 amounts into the purchase transaction. I do this manually currently. It's been like this for some years, and HSBC seem unwilling to offer this as an option from their side.
To automate this in MD would require to find the matching service fee transaction for each foreigh purchase, and then delete it before importing (or after importing).
The matching cannot be absolutely perfect (No Tx-IDs in the feed), but there are string contents to identify relevant transactions, dates can be matched and the fee% is fairly static.

Any suggestions as to a best way to make this work would be gratefully applauded! Thanks

  1. System closed this discussion on 09 Jul, 2022 05:40 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac