go-homebank-csv

This tool converts "comma separated values" (CSV) files from several banks to the "Transaction import CSV format" supported by HomeBank.

HomeBank is a crossplatform free and easy accounting software.

Supported formats

• MoneyWallet
  • MoneyWallet is an expense manager for Android. go-homebank-csv supports parsing and converting the CSV export format.
• Barclaycard
  • Not exactly CSV, this is the excel export format of Barclays VISA card as found on www.barclays.de.
• Volksbank
  • This is the CSV export format used by a German Volksbank. Most probably all Volksbanks have the same format.
• Comdirect
  • This is the giro account CSV export format used by www.comdirect.de. It has some weird encoding and the internal structure changes often.

Usage

List supported formats:

go-homebank-csv list-formats

Convert single files

Convert one file using format autodetection:

go-homebank-csv convert input-file.csv output-file.csv

Convert one file using known format:

go-homebank-csv convert --format=MoneyWallet input-file.csv output-file.csv

Batch convert a folder of files

You can autoconvert a defined set of folders. To use this feature a config file is needed.

The config file is expected at the following location:

$XDG_CONFIG_HOME/go-homebank-csv/config.yml

For the different operating system this is usually at the following places:

• Linux: ~/.config/go-homebank-csv/config.yml
• MacOS: ~/Library/Application Support/go-homebank-csv/config.yml
• Windows: "LocalAppData"/go-homebank-csv/config.yml

Config file format

A minimal version of a config file looks like the following:

batchconvert:
  sets:
  - name: Bank 1
    inputdir: /home/user/finance/barclaycard/xlsx
    outputdir: /home/user/finance/barclaycard/homebankcsv

The fields have the following meaning:

• name: The name of the entry. The name must be unique.
• inputdir: Where to search for files (non recursively).
• outputdir: Where to place the converted files.

The minimal version can be amended by optional settings:

batchconvert:
  sets:
  - name: Bank 1
    inputdir: /home/user/finance/barclaycard/xlsx
    outputdir: /home/user/finance/barclaycard/homebankcsv
    fileglobpattern: "*.xlsx"
    filemaxagedays: 3
    format: Barclaycard

The additional fields have the following meaning:

• fileglobpattern: Narrow down the files to search for in inputdir by this pattern. The glob pattern follows the one from the package path/filepath from golang standard library.
• filemaxagedays: Narrow down the files to search for in inputdir by specifying a maximum age in days (modification timestamp) in days. Only positive numbers are allowed.
• format: Specify the exact format to be expected. If not given an probably error-prone and time-consuming autodetection is done.

Command line example

With a config file like this:

batchconvert:
  sets:
  - name: Bank 1
    inputdir: /home/user/finance/barclaycard/xlsx
    outputdir: /home/user/finance/barclaycard/homebankcsv
    fileglobpattern: "*.xlsx"
    filemaxagedays: 3
    format: Barclaycard
  - name: Bank 2
    inputdir: /home/user/finance/volksbank/csv
    outputdir: /home/user/finance/volksbank/homebankcsv
    fileglobpattern: "*.csv"
    filemaxagedays: 2
    format: Volksbank

Call the sub-command batchconvert like this:

go-homebank-csv batchconvert

go-homebank-csv will do the following:

• Search in directory "/home/user/finance/barclaycard/xlsx" for files matching "*.xlsx" which have been modified not longer ago than 3 days
• Check if a file with the same basename is already at "/home/user/finance/barclaycard/homebankcsv"
• If this is not the case convert the found files using the same base name with an extention ".csv" and store them at "/home/user/finance/barclaycard/homebankcsv"
• Search in directory "/home/user/finance/volksbank/csv" for files matching "*.csv" which have been modified not longer ago than 2 days
• Check if a file with the same basename is already at "/home/user/finance/volksbank/homebankcsv"
• If this is not the case convert the found files using the same base name with an extention ".csv" and store them at "/home/user/finance/volksbank/homebankcsv"

Developer documentation

Prerequisites

This software uses golangci-lint, pkgsite, changie and goreleaser.

You can install the tools with:

make install-tools

Run tools locally

To lint, test and build the code run make all or simply make as all is the default make target:

make

The single actions also have their own make targets:

make lint
make test
make build

To show the documentation with pkgsite doc-server can be used:

make doc-serve

It starts a server in the foreground and opens a webbrowser.

Start with a new change

Call changie new:

changie new

This will ask for the kind of change and create a new file in ./changes/unreleased.

Create new release

The release process consists of the following steps:

1. Create changelog locally
2. Test goreleaser locally
3. Tag the release locally and trigger goreleaser on Github CI

Create changelog locally

changie batch collects unreleased changes info from ./changes/unreleased and creates a new version file like ./changes/v1.2.3.md.

changie merge collects version files from the ./changes folder and updates CHANGELOG.md.

Change minorto the type of change:

changie batch minor
changie merge

You may want to call the changie commands with the --dry-run to preview the changelog.

Don't forget to commit the changes so that the workspace is clean:

git add .
git commit -m "Prepare release $(changie latest)"

Test goreleaser locally

goreleaser release --snapshot --clean --release-notes .changes/$(changie latest).md

Tag the release locally and trigger goreleaser on Github CI

git tag $(changie latest)
git push origin main && git push --tags