bo100nka/bank-documents-parser

bank-documents-parser

About

This solution automates scanning of digital bank statement documents from various banks and exporting the payments received records into a structured, configurable CSV file format.

It will additionally scan for all .msg files (emails exported from outlook) and extract all of their file attachments.

It was developed as a windows console application using .NET 8 framework.

The source code is maintained here

References

• source code - https://github.com/bo100nka/bank-documents-parser
• .NET 8 runtime installers - https://dotnet.microsoft.com/en-us/download/dotnet/8.0

Installation

Prerequisites

• .NET 8 runtime installed (see References)

Application

Package can be obtained either by:

• manually building the solution from source (requires C# .NET development expertise) or by
• manually downloading pre-built binary package and extracting it into a desired work directory (link for download sent via email)

Updates

• Simply overwrite everything inside the existing installation folder by the contents of the newer version of the application package
• Delete config file as it will be re-created (you can keep backup of the previous config if needed)

Usage

Test run mode ON

• Run the application by executing the bank-statements-parser.exe binary application file (you can also create a shortcut to it)
  • This will initialize the system and create a default work directory structure and a config file located at c:/YellowNET and then simply exit.
• Locate the config file appsettings.json and open it in notepad
• Disable TestRunMode setting (change its value from true to false) - this will disable the "First time run" behavior.
• Optionally change any setting
• Save the file

Test run mode OFF

When the application is executed with the TestRunMode setting off, it will start the main process workflow:

• locates all bank statement documents in the configured directories, for example:
  • c:/YellowNET/TatraBanka
  • c:/YellowNET/SlovenskaPosta
  • c:/YellowNET/VUB
• parses each document in the defined folders
• converts each document into a csv version in c:/YellowNET/Output
• additionally creates two different types of merged csv files:
  • one per bank
  • one final for all banks together
• for easier database import, generates merged sql files grouped by year and quarter
  • NOTE: these files will be big, you might have to increase the max packet size before executing the INSERT INTO statements one by one
• lastly scans for all exported outlook emails (.msg files) in the configured directory (for example c:/YellowNET/EmailsToExtract)
• for every found email it exports all attachments to the output directory

Logging

The application logs every step it performs into:

• the console standard output
• a log file located at c:/YellowNET/app.log (which can be viewed by notepad).

Remarks

• The application flow ignores some outgoing payments.