Takes the FreeAgent invoice table and generates a CSV file from it. Makes it easier to work with the data in a spreadsheet when calculating late payment fees.

late_invoices.csv

Issue Date,Due Date,Name,Client,Value,Status,Paid On
...

late_invoices.html

<!-- Copy the HTML table element from this page: https://youraccount.freeagentcentral.com/invoices (select to show all invoices -->

late_invoices.rb

# frozen_string_literal: true

require 'bundler/inline'
require 'csv'

gemfile do
  source 'https://rubygems.org'
  gem 'nokogiri', '~> 1.10.1'
  gem 'pry'
end

class String
  def squish!
    gsub!(/\A[[:space:]]+/, '')
    gsub!(/[[:space:]]+\z/, '')
    gsub!(/[[:space:]]+/, ' ')
    self
  end
end

fragment = Nokogiri::HTML.fragment(File.read('late_invoices.html'))
invoice_rows = fragment.css('table#invoices_list tbody tr').select { |tr| tr['id']&.start_with? 'invoice_' }
CSV.open('late_invoices.csv', 'wb') do |csv|
  csv << ['Issue Date', 'Due Date', 'Name', 'Client', 'Value', 'Status', 'Paid On']
  invoice_rows.each do |invoice_row|
    issue_date, due_date, name, client, value, status, = invoice_row.css('td')
    status_text, paid_on = status.text.strip.squish!.split(' – ')
    csv << [issue_date.text.strip, due_date.text.strip, name.text.strip, client.css('a:first-child').text.strip, value.text.strip, status_text, paid_on]
  end
end