Text File Importer Picks up Arbitrarily Different Exchange Rates

N Bohr's Avatar

N Bohr

02 Oct, 2019 01:39 PM

I am using Text File Importer to import data in a bank account with a foreign base currency.
The data imports OK; however, the amounts are not converted properly as the converter somehow picks up a fixed (and unreasonable) conversion rate for ALL imported entries.

Is there anyway to provide separate rate for each transaction or a fixed ex rate for all transactions? It is pain to edit each entry after it is imported using the current extension.

  1. Support Staff 1 Posted by Sean Reilly on 02 Oct, 2019 02:41 PM

    Sean Reilly's Avatar

    Hello! This sounds like an issue which we've encountered in a few other customers data files as well, but is fixed by running the attached python script in Moneydance.

    Can you run it using the Window -> Moneybot Console menu, then Open Script, followed by "Run"?


Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? 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