Git Product home page Git Product logo

vladimir-aubrecht / statementparser Goto Github PK

View Code? Open in Web Editor NEW
26.0 26.0 13.0 1.48 MB

Idea behind the StatementParser is, that it would be nice to be able to process financial data from different kind of statements in automatized way. This is often pretty hard as brokers are giving these data only in form of xls/xlst/pdf or other format which is not directly processable and here comes StatmentParser.

License: Apache License 2.0

C# 100.00%
broker czechia parsing taxes

statementparser's Introduction

Hi there 👋

What you can find here

  • 👾 Only hobby projects.
  • 🎁 Mostly open source projects, Apache license - ping me if it doesn't work for you for some reason, we can discuss that.

What I am currently actively working on

Collaboration

I'll be grateful in case you decide to help me with any of my projects, feel free to create PR! ☺️ Also don't hesitate to ask me anything.

statementparser's People

Contributors

anydot avatar cifratila avatar fabicz avatar mikeus-hanzlik avatar rymeskar avatar vladimir-aubrecht avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

statementparser's Issues

Add parser for parsing of "Potvrzení o zdanitelných příjmech"

Add parser for parsing of "Potvrzení o zdanitelných příjmech". This can be later used for getting important data as name, birth number, salary, etc. for generation of tax declaration itself.

Also consider, that most people are scanning this document: maybe some kind of OCR will be needed?

MorganStanley statements are broken

Starting from last quarter of 2021 MortanStenley changed the format of account statements to "Quarterly Statement" and the parser just ignores them.
image

Provide a list of items to be worked on

I would love to contribute to this initiative.

I am however not sure, what is right now of priority and open for contribution.

It would be great if the repository contained such list.

Create library for generating of Czech Tax Declaration xml file

Czech portal for taxes is allowing to save tax declaration into zipped xml file & load it back and send it to authorities. Would be great, if we have library which can generate this file and we could automatically generate tax declaration through TaxReporter utility.

Add support for Sale transactions

Overview

Current implementation of parsers mostly doesn't support Sale transactions and this should be improved. Idea is, that if user sell some shares, parser should detect it and include it between Sale transaction for given broker.

This feature has several challenges.

Multi year statements

Typically purchase can be done years before sale and not every broker is having information about purchase price on statement with sale transaction.

This means, that user will need to provide also statements with purchase transactions and parser will need to map those two transactions somehow on each other. This creates problem with list of transactions from old statements - we should give user ability to filter outgoing transactions, for example by allowing him/her to specify, that user wants just transactions from specific year.

FIFO

At least in Czech Republic shares are sold in FIFO mode. It means that for tax authorities doesn't matter which share we sold in reality, they will always consider sold oldest purchased share.

This is creating another set of problems as user doesn't need to sell all shares from 1 transaction, but only portion of them and for proper evaluation we need to know complete history of the broker.

We should also make research on how other countries are solving this to find out if it make sense to have this feature configurable/extendable as StatementParser project (only parsing, TaxReporter project is currently heavily focused on Czech Republic, but wrote in a way it's extendable on other countries) is currently country independent and I'd like to preserve it.

#Exchange rates (TaxReporter extension)
Sale transactions are opening questions about exchange rates as there is multiple strategies which can be used:

  • Same yearly exchange rate from current year for purchase and sale price.
  • Yearly exchange rate from current year for sale price, but yearly exchange rate from the year of purchase transaction.
  • Per day exchange rate for sale price and for purchase price.

Create library which can download statements

There were several requests that people would like to provide just their credentials and let the tool to download the statements.

My current thinking is:

  1. Create library which allows to download statements for different brokers
  2. Create standalone utility which reads configuration file with credentials and just download statements
  3. Integrate feature for downloading of statements as optional feature of TaxReporterCLI

Requirements

  • User's credentials should be stored securely (cannot be accessible without re-authentication of user or using some master password, computers are being reused by multiple people ...)
  • User's credentials must be easily reusable cross multiple computers & operating systems (one year I can use Windows computer, but another year I might use MacOS or Linux).
  • Pick solution should allow secure synchronization through some cloud (picked by user).

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.