Hi,
That's what I'm currently using. It stores original values as meta
information in original key and conversions as originalIn and originalOut
|
||from dateutil.parser import parse
from io import StringIO
from beancount.ingest import importer
from beancount.core import data
from beancount.core import amount
from beancount.core.number import D
from beancount.ingest.importers.mixins import identifier
import csv
class Importer(identifier.IdentifyMixin, importer.ImporterProtocol):
"""An importer for Revolut CSV files."""
def __init__(self, regexps, account, currency):
identifier.IdentifyMixin.__init__(self, matchers=[
('filename', regexps)
])
self.account = account
self.currency = currency
def name(self):
return super().name() + self.account
def file_account(self, file):
return self.account
def extract(self, file, existing_entries):
entries = []
with StringIO(file.contents()) as csvfile:
reader = csv.DictReader(csvfile, ['Date',
'Reference','PaidOut', 'PaidIn', 'ExchangeOut', 'ExchangeIn', 'Balance',
'Category', 'Notes'], delimiter=';', skipinitialspace=True)
next(reader)
for row in reader:
metakv = {
'category': row['Category'].strip(),
}
exchangeIn = row['ExchangeIn'].strip()
exchangeOut = row['ExchangeOut'].strip()
if exchangeIn and exchangeOut:
metakv['originalIn'] = exchangeIn
metakv['originalOut'] = exchangeOut
elif exchangeIn:
metakv['original'] = exchangeIn
elif exchangeOut:
metakv['original'] = exchangeOut
meta = data.new_metadata(file.name, 0, metakv)
entry = data.Transaction(
meta,
parse(row['Date'].strip()).date(),
'*',
'',
(row['Reference'].strip() + ' ' +
row['Notes'].strip()).strip(),
data.EMPTY_SET,
data.EMPTY_SET,
[
data.Posting(self.account,
amount.Amount(D(row['PaidIn'].strip()) - D(row['PaidOut'].strip()),
self.currency), None, None, None, None),
]
)
entries.append(entry)
return entries
|
On 16.11.2019 14:45, [email protected] wrote:
Hi
Does anybody has a Revolut statement (csv) parser to import the
transactions to beancounts?
Example rows:
Completed Date ; Description ; Paid Out (CHF) ; Paid In (CHF) ;
Exchange Out; Exchange In; Balance (CHF); Category; Notes
Nov 16, 2019 ; Top-Up by *8753 ; ; 600.00 ; ; ; 703.83; general;
Nov 16, 2019 ; Paypal *collintanaw FX Rate Fr1 = US$1.0066 ; 403.30 ;
; USD 405.96 ; ; 103.83; services;
Thanks for help :)
--
You received this message because you are subscribed to the Google
Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/90613531-9c08-45a5-8dfc-7be50029c224%40googlegroups.com
<https://groups.google.com/d/msgid/beancount/90613531-9c08-45a5-8dfc-7be50029c224%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/a586c6b4-e090-c6f5-1775-9f315b541575%40ch.tario.org.
