Add a line item to an expense if criteria are met

Add a line item to an expense if criteria are met

Hi,

I have a number of banking transactions I'd like to split into two expenses based on text in the description, because a portion is a FX fee applied by the bank. The text in the description is "incl. Foreign Transaction Fee $0.50" and I'd like to add a line item for the $0.50 and subtract this amount from the existing line item. I thought I'd set up a workflow rule and a custom function, but not clear on whether this is acutally possible and what method to update/add a list item would be

any help appreciated.