Format Aldermore Bank CSV for upload to FreeAgent

format_aldermore_bank_csv_for_upload_to_freeagent.rb

# See https://support.freeagent.com/hc/en-gb/articles/115001222564-How-to-format-a-CSV-file-to-upload-a-bank-statement#h_01FWZVYY1GEEGAPKJHG6FKV2HM

require 'csv'

CSV($stdin, headers: true, skip_blanks: true) do |csv|
  csv.each do |row|
    puts([
      Date.parse(row['Date']).strftime("%d/%m/%Y"),
      row['Amount'].gsub(/,/, ''),
      row['Description'].gsub(/,/, '')
    ].join(','))
  end
end