ofxstatement icon indicating copy to clipboard operation
ofxstatement copied to clipboard

Multiple ofx from one statement

Open infused-kim opened this issue 9 years ago • 4 comments

Hi,

i am working on a paypal plugin, which supports multiple currencies. in order to do this, I would like to generate multiple OFX files for each currency that is used in the paypal csv.

The easiest way to implement it that I can think of is to allow p.get_parser(args.input)

to return a list: [{'parser' : parserUSD, 'account' : 'USD'}, {'parser' : parserEUR, 'account' : 'EUR'}]

convert can then use that to generate multiple OFX files.

What do you think?

Kim

infused-kim avatar Jun 10 '16 11:06 infused-kim

I would also like this for generating different OFX files for the escrow and loan accounts for house mortgages.

rkhwaja avatar Dec 13 '18 18:12 rkhwaja

Any opinions, updates on this? I'm also interested in this, since Revolut produces statements for multiple accounts in a single CSV per currency.

hades avatar Jul 13 '23 07:07 hades

The typical approach here is to process such input file multiple times with different settings. E.g. I have in my config.ini:

[swedbank-eur]
plugin = swedbank
currency = EUR

[swedbank-usd]
plugin = swedbank
currency = USD

My bank generates a single statement with multiple currencies, but ofxstatement runs twice and produces two OFX files. I think that's the only way GnuCash (which is my use case) can import such files (because it imports a file-per-account, which has fixed currency).

Technically, the plugin would only take records with configured currency from the statement and ignore all others.

kedder avatar Jul 13 '23 07:07 kedder

That could also work, yes.

hades avatar Jul 13 '23 08:07 hades