use of name.abuchen.portfolio.datatransfer.pdf.PDFParser.Transaction in project portfolio by buchen.
the class BaaderBankPDFExtractor method addDepositTransaction.
@SuppressWarnings("nls")
private void addDepositTransaction() {
final DocumentType type = new DocumentType("Perioden-Kontoauszug", (context, lines) -> {
Pattern pCurrency = Pattern.compile("Perioden-Kontoauszug:[ ]+(\\w{3}+)-Konto");
// read the current context here
for (String line : lines) {
Matcher m = pCurrency.matcher(line);
if (m.matches()) {
context.put("currency", m.group(1));
}
}
});
this.addDocumentTyp(type);
// deposit, add value to account
// 01.01.2020 Lastschrift aktiv 01.01.2020 123,45
Block block = new Block("\\d+\\.\\d+\\.\\d{4}[ ]+Lastschrift aktiv[ ]+\\d+\\.\\d+\\.\\d{4}[ ]+[\\d.]+,\\d{2}");
type.addBlock(block);
block.set(new Transaction<AccountTransaction>().subject(() -> {
AccountTransaction t = new AccountTransaction();
t.setType(AccountTransaction.Type.DEPOSIT);
return t;
}).section("valuta", "amount").match("\\d+\\.\\d+\\.\\d{4}[ ]+Lastschrift aktiv[ ]+(?<valuta>\\d+\\.\\d+\\.\\d{4})[ ]+(?<amount>[\\d.]+,\\d{2})").assign((t, v) -> {
Map<String, String> context = type.getCurrentContext();
t.setCurrencyCode(asCurrencyCode(context.get("currency")));
t.setDateTime(asDate(v.get("valuta")));
t.setAmount(asAmount(v.get("amount")));
// t.setNote(v.get("text"));
}).wrap(t -> new TransactionItem(t)));
}
use of name.abuchen.portfolio.datatransfer.pdf.PDFParser.Transaction in project portfolio by buchen.
the class BankSLMPDFExtractor method addDividendTransaction.
@SuppressWarnings("nls")
private void addDividendTransaction() {
DocumentType type = new DocumentType("Dividende");
this.addDocumentTyp(type);
Block block = new Block("Dividende");
type.addBlock(block);
Transaction<AccountTransaction> extractor = new Transaction<AccountTransaction>().subject(() -> {
AccountTransaction transaction = new AccountTransaction();
transaction.setType(AccountTransaction.Type.DIVIDENDS);
return transaction;
}).section("date", "shares", "name", "wkn", "currency").match(//
"Am (?<date>\\d+.\\d+.\\d{4}+) wurde folgende Dividende gutgeschrieben:").match(//
"^.*$").match(//
"^(?<name>.*)$").match(//
"^Valor: (?<wkn>[^ ]*)$").match(//
"Brutto \\((?<shares>[\\d.']+) \\* ... ([\\d.']+)\\) (?<currency>\\w{3}+) ([\\d.']+)").assign((t, v) -> {
t.setDateTime(asDate(v.get("date")));
t.setShares(asShares(v.get("shares")));
t.setSecurity(getOrCreateSecurity(v));
}).section("amount", //
"currency").match(//
"Netto (?<currency>\\w{3}+) (?<amount>[\\d.']+)").assign((t, v) -> {
t.setAmount(asAmount(v.get("amount")));
t.setCurrencyCode(v.get("currency"));
}).section("fees", "currency").optional().match(//
".* Verrechnungssteuer (?<currency>\\w{3}+) -(?<fees>[\\d.']+)").assign((t, v) -> t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fees")))))).section("fees", "currency").optional().match(//
".* Quellensteuer (?<currency>\\w{3}+) -(?<fees>[\\d.']+)").assign((t, v) -> t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fees")))))).section("fees", "currency").optional().match(//
".* Nicht r.ckforderbare Steuern (?<currency>\\w{3}+) -(?<fees>[\\d.']+)").assign((t, v) -> t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fees")))))).section("grossValue", "forexSum", "forexCurrency", "totalValue", "currency", //
"exchangeRate").optional().match(//
"Brutto \\(([\\d.']+) \\* ... ([\\d.']+)\\) (\\w{3}+) (?<grossValue>[\\d.']+)").match(//
"Netto (?<forexCurrency>\\w{3}+) (?<forexSum>[\\d.']+)").match(//
"Change ... / ... (?<exchangeRate>[\\d.']+) (?<currency>\\w{3}+) (?<totalValue>[\\d.'-]+)").assign((t, v) -> {
// NOSONAR
// if we end up in the branch, then we have forex
// dividends and must convert taxes in local
// currency
Money totalValue = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("totalValue")));
t.setMonetaryAmount(totalValue);
// keep tax units in case we need to convert them
List<Unit> tax = t.getUnits().collect(Collectors.toList());
t.clearUnits();
Money forexGrossValue = Money.of(asCurrencyCode(v.get("forexCurrency")), asAmount(v.get("grossValue")));
BigDecimal exchangeRate = asExchangeRate(v.get("exchangeRate"));
Money grossValue = Money.of(totalValue.getCurrencyCode(), Math.round(exchangeRate.doubleValue() * forexGrossValue.getAmount()));
Unit unit = new Unit(Unit.Type.GROSS_VALUE, grossValue, forexGrossValue, exchangeRate);
t.addUnit(unit);
// convert tax units
tax.stream().forEach(u -> {
if (u.getAmount().getCurrencyCode().equals(t.getCurrencyCode())) {
t.addUnit(u);
} else {
Money txm = Money.of(t.getCurrencyCode(), Math.round(exchangeRate.doubleValue() * u.getAmount().getAmount()));
Unit fu = new Unit(Unit.Type.TAX, txm, u.getAmount(), exchangeRate);
t.addUnit(fu);
}
});
}).wrap(t -> new TransactionItem(t));
block.set(extractor);
}
use of name.abuchen.portfolio.datatransfer.pdf.PDFParser.Transaction in project portfolio by buchen.
the class HelloBankPDFExtractor method addInboundDelivery.
@SuppressWarnings("nls")
private void addInboundDelivery() {
DocumentType type = new DocumentType("Freier Erhalt");
this.addDocumentTyp(type);
Block block = new Block("Gesch.ftsart: Freier Erhalt");
type.addBlock(block);
block.set(new Transaction<PortfolioTransaction>().subject(() -> {
PortfolioTransaction transaction = new PortfolioTransaction();
transaction.setType(PortfolioTransaction.Type.DELIVERY_INBOUND);
return transaction;
}).section("isin", "name", //
"currency").match(//
"Titel: (?<isin>\\S*) (?<name>.*)$").match("steuerlicher Anschaffungswert: [\\d+,.-]* (?<currency>\\w{3}+) *").assign((t, v) -> t.setSecurity(getOrCreateSecurity(v))).section(//
"shares").match("^Zugang: (?<shares>[\\d+,.]*) Stk.*").assign((t, v) -> t.setShares(asShares(v.get("shares")))).section(//
"date").match("Kassatag: (?<date>\\d+.\\d+.\\d{4}+).*").assign((t, v) -> t.setDateTime(asDate(v.get("date")))).section("amount", //
"currency").match("steuerlicher Anschaffungswert: (?<amount>[\\d+,.-]*) (?<currency>\\w{3}+) *").assign((t, v) -> t.setMonetaryAmount(Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("amount"))))).wrap(TransactionItem::new));
}
use of name.abuchen.portfolio.datatransfer.pdf.PDFParser.Transaction in project portfolio by buchen.
the class INGDiBaExtractor method addBuyTransaction.
@SuppressWarnings("nls")
private void addBuyTransaction() {
DocumentType type = new DocumentType("Wertpapierabrechnung Kauf");
this.addDocumentTyp(type);
Block block = new Block("Wertpapierabrechnung Kauf.*");
type.addBlock(block);
block.set(new Transaction<BuySellEntry>().subject(() -> {
BuySellEntry entry = new BuySellEntry();
entry.setType(PortfolioTransaction.Type.BUY);
return entry;
}).section("wkn", "isin", "name").match("^ISIN \\(WKN\\) (?<isin>[^ ]*) \\((?<wkn>.*)\\)$").match("Wertpapierbezeichnung (?<name>.*)").assign((t, v) -> {
t.setSecurity(getOrCreateSecurity(v));
}).section("shares").match("^Nominale( St.ck)? (?<shares>[\\d.]+(,\\d+)?).*").assign((t, v) -> t.setShares(asShares(v.get("shares")))).section(//
"date").match(//
"(Ausf.hrungstag . -zeit|Ausf.hrungstag|Schlusstag . -zeit|Schlusstag) (?<date>\\d+.\\d+.\\d{4}+).*").assign((t, v) -> t.setDate(asDate(v.get("date")))).section("amount", //
"currency").match(//
"Endbetrag zu Ihren Lasten (?<currency>\\w{3}+) (?<amount>[\\d.]+,\\d+)").assign((t, v) -> {
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
t.setAmount(asAmount(v.get("amount")));
}).section("fee", "currency").optional().match(//
"Handelsplatzgeb.hr (?<currency>\\w{3}+) (?<fee>[\\d.]+,\\d+)").assign((t, v) -> t.getPortfolioTransaction().addUnit(new Unit(Unit.Type.FEE, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fee")))))).section("fee", "currency").optional().match(//
"Provision (?<currency>\\w{3}+) (?<fee>[\\d.]+,\\d+)").assign((t, v) -> t.getPortfolioTransaction().addUnit(new Unit(Unit.Type.FEE, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fee")))))).section("fee", "currency").optional().match(//
"Handelsentgelt (?<currency>\\w{3}+) (?<fee>[\\d.]+,\\d+)").assign((t, v) -> t.getPortfolioTransaction().addUnit(new Unit(Unit.Type.FEE, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fee")))))).wrap(t -> {
if (t.getPortfolioTransaction().getDateTime() == null)
throw new IllegalArgumentException("Missing date");
return new BuySellEntryItem(t);
}));
}
use of name.abuchen.portfolio.datatransfer.pdf.PDFParser.Transaction in project portfolio by buchen.
the class INGDiBaExtractor method addTaxSectionToAccountTransaction.
@SuppressWarnings("nls")
private void addTaxSectionToAccountTransaction(DocumentType type, Transaction<AccountTransaction> transaction) {
// Kapitalerstragsteuer (Einzelkonto)
//
transaction.section("tax", "currency").optional().match("Kapitalertragsteuer \\d+,\\d+ ?% (?<currency>\\w{3}+) (?<tax>[\\d.]+,\\d+)").assign((t, v) -> t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")))))).section("tax1", "currency1", "tax2", "currency2").optional().match("KapSt anteilig 50,00 ?% \\d+,\\d+ ?% (?<currency1>\\w{3}+) (?<tax1>[\\d.]+,\\d+)").match("KapSt anteilig 50,00 ?% \\d+,\\d+ ?% (?<currency2>\\w{3}+) (?<tax2>[\\d.]+,\\d+)").assign((t, v) -> {
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency1")), asAmount(v.get("tax1")))));
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency2")), asAmount(v.get("tax2")))));
}).section("tax", "currency").optional().match("Solidarit.tszuschlag \\d+,\\d+ ?% (?<currency>\\w{3}+) (?<tax>[\\d.]+,\\d+)").assign((t, v) -> {
if (!Boolean.parseBoolean(type.getCurrentContext().get(IS_JOINT_ACCOUNT)))
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")))));
}).section("tax1", "currency1", "tax2", "currency2").optional().match("Solidarit.tszuschlag \\d+,\\d+ ?% (?<currency1>\\w{3}+) (?<tax1>[\\d.]+,\\d+)").match("Solidarit.tszuschlag \\d+,\\d+ ?% (?<currency2>\\w{3}+) (?<tax2>[\\d.]+,\\d+)").assign((t, v) -> {
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency1")), asAmount(v.get("tax1")))));
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency2")), asAmount(v.get("tax2")))));
}).section("tax", "currency").optional().match("Kirchensteuer \\d+,\\d+ ?% (?<currency>\\w{3}+) (?<tax>[\\d.]+,\\d+)").assign((t, v) -> {
if (!Boolean.parseBoolean(type.getCurrentContext().get(IS_JOINT_ACCOUNT)))
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")))));
}).section("tax1", "currency1", "tax2", "currency2").optional().match("Kirchensteuer \\d+,\\d+ ?% (?<currency1>\\w{3}+) (?<tax1>[\\d.]+,\\d+)").match("Kirchensteuer \\d+,\\d+ ?% (?<currency2>\\w{3}+) (?<tax2>[\\d.]+,\\d+)").assign((t, v) -> {
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency1")), asAmount(v.get("tax1")))));
t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency2")), asAmount(v.get("tax2")))));
}).section("tax", "currency", "taxTx", //
"currencyTx").optional().match("QuSt \\d+,\\d+ % \\((?<currencyTx>\\w{3}+) (?<taxTx>[\\d.,]*)\\) (?<currency>\\w{3}+) (?<tax>[\\d.,]*)").assign((t, v) -> {
String currency = asCurrencyCode(v.get("currency"));
String currencyTx = asCurrencyCode(v.get("currencyTx"));
if (currency.equals(t.getCurrencyCode()))
t.addUnit(new Unit(Unit.Type.TAX, Money.of(currency, asAmount(v.get("tax")))));
else
t.addUnit(new Unit(Unit.Type.TAX, Money.of(currencyTx, asAmount(v.get("taxTx")))));
});
}
Aggregations