Metadata-Version: 2.1
Name: ofxstatement-dutch
Version: 1.3.2
Summary: OFXStatement plugin for dutch financial institutions like DEGIRO, ICSCards, ING and KNAB.
Home-page: https://github.com/gpaulissen/ofxstatement-dutch
Author: Gert-Jan Paulissen
Author-email: gert.jan.paulissen@gmail.com
License: GPLv3
Description: # ofxstatement-dutch 
        
        This project provides custom
        [ofxstatement](https://github.com/kedder/ofxstatement) plugins for these dutch
        financial institutions:
        - DEGIRO trader platform, The Netherlands, CSV (https://www.degiro.nl/)
        - ICSCards, The Netherlands, PDF (https://icscards.nl/)
        - ING bank, The Netherlands, CSV (https://www.ing.nl/)
        - KNAB Online Bank, The Netherlands, CSV (https://www.knab.nl/)
        
        `ofxstatement` is a tool to convert a proprietary bank statement to OFX
        format, suitable for importing into programs like GnuCash or Beancount. The
        plugin for ofxstatement parses the bank statement and produces a common data
        structure, that is then formatted into an OFX file.
        
        The PDF is converted using the
        [pdftotext](https://pypi.org/project/pdftotext/) utility.
        
        ## Installation using Miniconda (minimal conda)
        
        This is a quick start guide meant for users on a Windows 10 platform.
        
        These are the steps:
        
        ### 1. Install [Miniconda for Python 3.x](https://docs.conda.io/en/latest/miniconda.html)
        
        ### 2. Start the Anaconda prompt
        
        Type Anaconda in the search box next to the Windows Start icon in the bottom left of your screen and click the Anaconda Prompt (Miniconda3).
        A command line box will open now with (base) as the prompt.
        
        ### 3. Create an ofxstatement environment
        
        In the command line box type "conda create -n ofxstatement":
        ```bash
        (base) conda create -n ofxstatement
        ```
        Please note that (base) is the command prompt, not a command to type.
        
        ### 4. Switch to the ofxstatement environment and show the installed packages (should be empty the first time)
        
        ```bash
        (base) activate ofxstatement
        (ofxstatement) conda list
        ```
        
        ### 5. Install Python in this environment
        
        ```bash
        (ofxstatement) conda install python
        ```
        
        ### 6. Verify the location of pip
        
        ```bash
        (ofxstatement) where pip
        ```
        This should show something like C:\Users\%USERNAME%\Miniconda3\envs\ofxstatement\Scripts\pip.exe
        
        ### 7. Install ofxstatement-dutch
        
        ```bash
        (ofxstatement) pip install ofxstatement-dutch
        ```
        
        ### 8. (optional) Install the Poppler library
        
        Only if you need to read PDF files (ICSCards for example):
        ```bash
        (ofxstatement) conda install -c conda-forge poppler
        ```
        
        ### 9. Test the installation
        
        Now a small test to see everything works if you have a KNAB CSV file:
        
        ```bash
        (ofxstatement) ofxstatement convert -t nl-knab "<CSV file>" -
        ```
        
        The dash (-) at the end of the command ensures that the OFX output will be
        sent to the terminal and not to a file.  The double quotes are needed for
        files with spaces in its name like
        "Knab transactieoverzicht spaarrekening XXXXXXXX - 2020-01-01 - 2020-05-01.csv".
        
        ### 10. Launching ofxstatement
        
        Please remember to always start the Anaconda prompt and to activate the
        ofxstatement environment first before launching ofxstatement itself, since it
        is only installed in that Conda environment.
        
        You may create a shortcut to combine both. The target of your shortcut should be something like:
        ```
        C:\Windows\System32\cmd.exe /k C:\Users\%USERNAME%\Miniconda3\condabin\activate.bat ofxstatement
        ```
        
        Please continue with the "Usage" section below.
        
        ## Installation
        
        This section is meant for people who do not want to follow the "Installation
        using Miniconda (minimal conda)" section above.
        
        ### Preconditions
        
        For converting PDFs you have to install the poppler library first, see
        [pdftotext](https://pypi.org/project/pdftotext/).
        
        ### Using pip
        
        ```
        $ pip install ofxstatement-dutch
        ```
        
        ### Development version from source
        
        ```
        $ git clone https://github.com/gpaulissen/ofxstatement-dutch.git
        $ pip install -e .
        ```
        
        ### Troubleshooting
        
        This package depends on ofxstatement with a version at least 0.6.5. This
        version may not yet be available in PyPI so install that from source like
        this:
        ```
        $ git clone https://github.com/gpaulissen/ofxstatement.git
        $ pip install -e .
        ```
        
        ## Test
        
        To run the tests from the development version you can use the py.test command:
        
        ```
        $ py.test
        ```
        
        You may need to install the required test packages first:
        
        ```
        $ pip install -r test_requirements.txt
        ```
        
        ## Usage
        
        ### Show installed plugins
        
        This shows the all installed plugins, not only those from this package:
        
        ```
        $ ofxstatement list-plugins
        ```
        
        You should see at least:
        
        ```
        The following plugins are available:
        
          ...
          nl-degiro        DEGIRO trader platform, The Netherlands, CSV (https://www.degiro.nl/)
          nl-icscards      ICSCards, The Netherlands, PDF (https://icscards.nl/)
          nl-ing           ING Bank, The Netherlands, CSV (https://www.ing.nl/)
          nl-knab          KNAB Online Bank, The Netherlands, CSV (https://www.knab.nl/)
          ...
        
        ```
        
        ### Convert
        
        #### DEGIRO trader platform
        
        The DEGIRO files do not only contain money statements but also the whole
        security transaction history. This tool just emits the money statements coming
        from or going to your associated (other) bank account. To be more specific the
        deposits (description like "Storting" or "iDEAL storting") and transfers
        ("Terugstorting"). Maybe in the future the security transaction will be
        emitted too, but currently
        [ofxstatement](https://github.com/kedder/ofxstatement) only processes money
        information.
        
        See also the section configuration below.
        
        Use something like this:
        
        ```
        $ ofxstatement convert -t <configuration name> <file>.csv <file>.ofx
        ```
        
        #### ICSCards
        
        Use something like this:
        ```
        $ ofxstatement convert -t nl-icscards <file>.pdf <file>.ofx
        ```
        
        Or you can convert the PDF yourself and supply the text as input:
        
        ```
        $ pdftotext -layout <file>.pdf <file>.txt
        $ ofxstatement convert -t nl-icscards <file>.txt <file>.ofx
        ```
        
        #### ING bank
        
        Use something like this:
        
        ```
        $ ofxstatement convert -t nl-ing <file>.csv <file>.ofx
        ```
        
        #### KNAB Online Bank
        
        Use something like this:
        
        ```
        $ ofxstatement convert -t nl-knab <file>.csv <file>.ofx
        ```
        
        ### Configuration
        
        For DEGIRO you need to set an account id, since the statement files do not
        contain account information.
        
        ```
        $ ofxstatement edit-config
        ```
        
        This is a sample configuration (do not forget to specify the plugin for each section):
        
        ```
        [degiro:account1]
        plugin = nl-degiro
        account_id = account1
        
        [degiro:account2]
        plugin = nl-degiro
        account_id = account2
        
        ```
        
        ## Change history
        
        See the Changelog (CHANGELOG.md).
        # Changelog
        
        All notable changes to this project will be documented in this file.
        
        The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.0.0/),
        and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html).
        
        ## [Unreleased]
        
        ## [1.3.2] - 2020-08-02
        
        ### Removed
        
        	- Dependency of pdftotext.
        
        ## [1.3.1] - 2020-08-01
        
        ### Changed
        
        	- Layout of the README improved.
        	- Contents of this CHANGELOG for version 1.3.0.
        
        ## [1.3.0] - 2020-08-01
        
        ### Added:
        
        	- Added ability to parse ING balance statements.
        
        ### Changed
        
        	- Improved installation guide using Miniconda3
        	- Improved code quality by using pycodestyle and Python typing module
        
        ## [1.2.1] - 2020-05-01
        
        ### Changed
        
        	- Fixed bug for KNAB converter when counterparty is empty (for
        	interest for example)
        
        ## [1.2.0] - 2020-03-30
        
        ### Added
        
        	- Added converter for:
        		* KNAB Online Bank, The Netherlands, CSV (https://www.knab.nl/).
        
        ### Changed
        
        	- Enhanced header handling for ING and DEGIRO.
        	- Enhanced documentation.
        
        ## [1.1.0] - 2020-03-26
        
        ### Added
        
        	- Added converter for:
        		* DEGIRO trader platform, The Netherlands, CSV (https://www.degiro.nl/).
        	- Added reference to the Changelog in the Readme.
        	- The Readme mentions test_requirements.txt for installing test modules.
        	- More checks concerning the content (dates with start and end
        	date exclusive) that may result in a ValidationError exception.
        	- Added Makefile for keeping the important operations together.
        
        ### Changed
        
        	- The generation af a unique OFX id did only return a counter in
        	case of duplicates.
        	- The Readme mentions now my fork of the ofxstatement instead of
        	https://github.com/kedder/ofxstatement.git.
        	- The __about__.py file outputs the version number and that is
        	used in the Makefile.
        	- The Makefile depends now on GNU make for tagging a release.
        	- MANIFEST.in now includes the Makefile and CHANGELOG.md.
        	- Code refactoring.
        	- Changed bank id (BIC) for ING from INGBNL2AXXX to INGBNL2A.
        
        ## [1.0.1] - 2020-03-16
        
        ### Changed
        
        	- Added poppler library to the instructions.
        	- Readme enhanced.
        
        ## [1.0.0] - 2020-03-15
        
        ### Added
        
        	- First version to convert:
        		* ICSCards, The Netherlands, PDF (https://icscards.nl/)
        		* ING bank, The Netherlands, CSV (https://www.ing.nl/)
        
        
Keywords: ofx,banking,statement,beancount,degiro,ing,icscards,knab
Platform: UNKNOWN
Classifier: Development Status :: 6 - Mature
Classifier: Programming Language :: Python :: 3
Classifier: Natural Language :: English
Classifier: Topic :: Office/Business :: Financial :: Accounting
Classifier: Topic :: Utilities
Classifier: Environment :: Console
Classifier: Operating System :: OS Independent
Classifier: License :: OSI Approved :: GNU General Public License v3 (GPLv3)
Description-Content-Type: text/markdown
Provides-Extra: test
