Command line app to sort double-entry CSVs coming from internet banking statements

§ Call on a file

Call csvsort (or sortcsv) appending your file name (with or without -o/--overwrite flag):

$ csvsort YOURFILE.csv

$ csvsort -o YOURFILE.csv
$ csvsort --overwrite YOURFILE.csv
$ csvsort -v
$ csvsort --version
$ csvsort -h
$ csvsort --help

like this:

calling directly on a file

§ Or omit the file's name

It will let you pick a CSV:

$ csvsort # omit the file's name, but you can include -o/--overwrite flag

omit the file name and csv-sort-cli will offer a list of CSV files in the current folder to choose from:

calling without specifying a file name

You can even try it without installing — use npx:

$ npx csv-sort-cli YOURFILE.csv

§ What it does exactly

  1. It sorts CSV file rows to correspond to the double-entry bookkeeping opens in a new tab principles:
double bookkeeping example

Sometimes internet banking CSV's have rows in a wrong order, especially when entries are on the same date. This library helps to sort the rows in correct order.

  1. As a bonus, it will trim the empty columns/rows:
2D trim of a CSV contents
  1. Not to mention, the our custom CSV parser csv-split-easy used here will ensure that all CSV cell contents are trimmed, and there are no empty rows between the content rows. It also accepts any commas as content if the cell is wrapped with a double quotes.

§ Licence

MIT opens in a new tab

Copyright © 2010–2020 Roy Revelt and other contributors

Related packages:

📦 csv-sort 3.1.0
Sorts double-entry bookkeeping CSV coming from internet banking
📦 csv-split-easy 3.1.0
Splits the CSV string into array of arrays, each representing a row of columns